Как добавить данные в хранимую процедуру в SQL server с помощью языка C#

---

я хочу добавить запись в базу данных с помощью C#. но когда я нажимаю на кнопку "Добавить", появляется окно сообщения с сообщением, что

Employee Record could not be added!!!!"

Что я уже пробовал:

<pre> //methode
string qry = "execute insertemplab @Employee_id,@Emplyee_name,@Emplyee_phone,@Employee_address,@Employee_type,@clothmanufacture";
            
            SqlConnection connection = getconnection();
            SqlCommand command = new SqlCommand(qry, connection);
            command.CommandType = CommandType.StoredProcedure;
          command.Parameters.AddWithValue("@Employee_ID", lab.Employee_ID);
            command.Parameters.AddWithValue("Emplyee_Name", lab.EmployeeName);
            command.Parameters.AddWithValue("@Emplyee_phone", lab.PhoneNumber);
            command.Parameters.AddWithValue("@Employee_Address", lab.EmployeeAddress);
            command.Parameters.AddWithValue("@Employee_Type", lab.EmployeType);
            command.Parameters.AddWithValue("@clothmanufacture", lab.ClothManufactured);
            
            try{
                command.ExecuteNonQuery();
                
                MessageBox.Show("Employee Record Added Successfully");
            }
            catch (SqlException ex)
            {
                MessageBox.Show("Employee Record could not be added!!!!");
            }



        }

//при нажатии на кнопку Добавить

LaboureClass lab = new LaboureClass(txtlaboureID.Text, txtname.Text, txtphone.Text, txtaddress.Text, txttype.Text, int.Parse(txtmanufacture.Text));
            
           
            DBconnect.addEmployerecord(lab);

//это моя процедура в SQL server

create proc insertemplab @Employee_id varchar(50), @Emplyee_name varchar(50), 
 @Emplyee_phone varchar(50),  @Employee_address varchar(50),  @Employee_type varchar(50),@clothmanufacture varchar(50)
as
begin 
insert into Employee_tbl(Employee_id,Emplyee_name,Emplyee_phone,Employee_address,Employee_type) values(@Employee_id, @Emplyee_name,  @Emplyee_phone,  @Employee_address,  @Employee_type)
insert into Labour_tbl(L_Employee_id,clothmanufacture) values(@Employee_id,@clothmanufacture)

end 

---