public static bool AddEmployeesBLL(Employee emp, Employee_Security empsec, string desig, string grade) { bool isEmployeeAdded = false; bool isEmployeeValidated = false; try { isEmployeeValidated = ValidateEmployeeBLL(emp, empsec, desig, grade); if (isEmployeeValidated) { isEmployeeAdded = EmployeeOperations.AddEmployeesDAL(emp, empsec, desig, grade); return(isEmployeeAdded); } else { throw new PayrollException("Error"); } } catch (PayrollException) { throw; } catch (System.Exception) { throw; } }
public static bool AddEmployeesDAL(Employee emp, Employee_Security empsec, string desig, string grade) { bool isEmployeeAdded = false; try { SqlCommand command = new SqlCommand("Group3_Payroll.usp_AddEmployee", connection); command.CommandType = CommandType.StoredProcedure; SqlParameter empid = new SqlParameter("@EmpId", emp.Employee_Id); SqlParameter pwd = new SqlParameter("@Password", emp.Employee_Password); SqlParameter doj = new SqlParameter("@doj", emp.DOJ); SqlParameter fname = new SqlParameter("@Firstname", emp.Employee_FirstName); SqlParameter lname = new SqlParameter("@Lastname", emp.Employee_LastName); SqlParameter address = new SqlParameter("@Address", emp.Employee_Address); SqlParameter squestion = new SqlParameter("@SecurityQuestion", empsec.Security_Question); SqlParameter sanswer = new SqlParameter("@SecurityAnswer", empsec.Security_Answer); SqlParameter dsig = new SqlParameter("@Designation", desig); SqlParameter grd = new SqlParameter("@Grade", grade); command.Parameters.Add(empid); command.Parameters.Add(pwd); command.Parameters.Add(doj); command.Parameters.Add(fname); command.Parameters.Add(lname); command.Parameters.Add(address); command.Parameters.Add(squestion); command.Parameters.Add(sanswer); command.Parameters.Add(dsig); command.Parameters.Add(grd); if (connection.State != ConnectionState.Open) { connection.Open(); } command.ExecuteNonQuery(); isEmployeeAdded = true; if (connection.State == ConnectionState.Open) { connection.Close(); } return(isEmployeeAdded); } catch (PayrollException) { throw; } catch (System.Exception) { throw; } }
public static bool ValidateEmployeeBLL(Employee emp, Employee_Security empsec, string desig, string grade) { bool isEmployeeValidated = true; StringBuilder sm = new StringBuilder(); try { if (emp.Employee_Id == 0) { isEmployeeValidated = false; sm.Append("Employee Id should not be empty"); } if (emp.Employee_Password == null) { isEmployeeValidated = false; sm.Append("Employee Password should not be empty"); } if (emp.Employee_FirstName.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Employee First name should not be empty"); } if (emp.Employee_LastName.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Employee Last name should not be empty"); } if (emp.Employee_Address.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Employee Address name should not be empty"); } if (emp.DOJ < DateTime.Now) { isEmployeeValidated = false; sm.Append("Employee DOJ cannot be in past"); } if (empsec.Security_Question.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Security Question should not be empty"); } if (empsec.Security_Answer.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Security Answer should not be empty"); } if (desig.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Employee Designation should not be empty"); } if (grade.Equals(string.Empty)) { isEmployeeValidated = false; sm.Append("Employee Grade should not be empty"); } if (!isEmployeeValidated) { throw new PayrollException(sm.ToString()); } return(isEmployeeValidated); } catch (PayrollException) { throw; } catch (System.Exception) { throw; } }