public int RegisterEmployee(string empName, string empGender, string empDOB, string empAddress, string empCity, string empPhoneNumber, string empEmailAddress, int empType, string empDateOfJoin, string empDateOfLeave, int empBank, string empAccountNumber) { RegisterEmployeeBO objRegisterEmployeeBO = new RegisterEmployeeBO(); objRegisterEmployeeBO.empName = empName; objRegisterEmployeeBO.empGender = empGender; objRegisterEmployeeBO.empDOB = empDOB; objRegisterEmployeeBO.empAddress = empAddress; objRegisterEmployeeBO.empPhoneNumber = empPhoneNumber; objRegisterEmployeeBO.empEmailAddress = empEmailAddress; objRegisterEmployeeBO.empType = empType; objRegisterEmployeeBO.empDateOfJoin = empDateOfJoin; objRegisterEmployeeBO.empDateOfLeave = empDateOfLeave; objRegisterEmployeeBO.empBank = empBank; objRegisterEmployeeBO.empAccountNumber = empAccountNumber; RegisterEmployeeDL objRegisterEmployeeDL = new RegisterEmployeeDL(); return objRegisterEmployeeDL.RegisterEmployee(objRegisterEmployeeBO); }
public int RegisterEmployee(string empName, string empGender, string empDOB, string empAddress, string empCity, string empPhoneNumber, string empEmailAddress, int empType, string empDateOfJoin, string empDateOfLeave, int empBank, string empAccountNumber) { RegisterEmployeeBO objRegisterEmployeeBO = new RegisterEmployeeBO(); objRegisterEmployeeBO.empName = empName; objRegisterEmployeeBO.empGender = empGender; objRegisterEmployeeBO.empDOB = empDOB; objRegisterEmployeeBO.empAddress = empAddress; objRegisterEmployeeBO.empPhoneNumber = empPhoneNumber; objRegisterEmployeeBO.empEmailAddress = empEmailAddress; objRegisterEmployeeBO.empType = empType; objRegisterEmployeeBO.empDateOfJoin = empDateOfJoin; objRegisterEmployeeBO.empDateOfLeave = empDateOfLeave; objRegisterEmployeeBO.empBank = empBank; objRegisterEmployeeBO.empAccountNumber = empAccountNumber; RegisterEmployeeDL objRegisterEmployeeDL = new RegisterEmployeeDL(); return(objRegisterEmployeeDL.RegisterEmployee(objRegisterEmployeeBO)); }
public int RegisterEmployee(RegisterEmployeeBO objRegisterEmployeeBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spRegisterEmployee", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@empName", objRegisterEmployeeBO.empName); cmd.Parameters.Add("@empGender", objRegisterEmployeeBO.empGender); cmd.Parameters.Add("@empDOB", objRegisterEmployeeBO.empDOB); cmd.Parameters.Add("@empAddress", objRegisterEmployeeBO.empAddress); cmd.Parameters.Add("@empPhoneNumber", objRegisterEmployeeBO.empPhoneNumber); cmd.Parameters.Add("@empEmailAddress", objRegisterEmployeeBO.empEmailAddress); cmd.Parameters.Add("@empType", objRegisterEmployeeBO.empType); cmd.Parameters.Add("@empDateOfJoin", objRegisterEmployeeBO.empDateOfJoin); cmd.Parameters.Add("@empDateOfLeave", objRegisterEmployeeBO.empDateOfLeave); cmd.Parameters.Add("@empBank", objRegisterEmployeeBO.empBank); cmd.Parameters.Add("@empAccountNumber", objRegisterEmployeeBO.empAccountNumber); conn.Open(); int id = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return id; }
public int RegisterEmployee(RegisterEmployeeBO objRegisterEmployeeBO) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()); SqlCommand cmd = new SqlCommand("spRegisterEmployee", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@empName", objRegisterEmployeeBO.empName); cmd.Parameters.Add("@empGender", objRegisterEmployeeBO.empGender); cmd.Parameters.Add("@empDOB", objRegisterEmployeeBO.empDOB); cmd.Parameters.Add("@empAddress", objRegisterEmployeeBO.empAddress); cmd.Parameters.Add("@empPhoneNumber", objRegisterEmployeeBO.empPhoneNumber); cmd.Parameters.Add("@empEmailAddress", objRegisterEmployeeBO.empEmailAddress); cmd.Parameters.Add("@empType", objRegisterEmployeeBO.empType); cmd.Parameters.Add("@empDateOfJoin", objRegisterEmployeeBO.empDateOfJoin); cmd.Parameters.Add("@empDateOfLeave", objRegisterEmployeeBO.empDateOfLeave); cmd.Parameters.Add("@empBank", objRegisterEmployeeBO.empBank); cmd.Parameters.Add("@empAccountNumber", objRegisterEmployeeBO.empAccountNumber); conn.Open(); int id = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(id); }