public EmployeeDTO GetEmployeeById(EmployeeGetDTO ObjGetEmpById) { EmployeeDTO employee = new EmployeeDTO(); using (DbLayer dbLayer = new DbLayer()) { SqlCommand SqlCmd = new SqlCommand("spSelectEmployee"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@Id", ObjGetEmpById.Id); SqlCmd.Parameters.AddWithValue("@ActionBy", ObjGetEmpById.ActionBy); employee = dbLayer.GetEntityList <EmployeeDTO>(SqlCmd).FirstOrDefault(); } return(employee); }
public List <EmployeeDTO> GetInActiveEmployee(EmployeeGetDTO objInActive) { List <EmployeeDTO> inActiveList = new List <EmployeeDTO>(); using (DbLayer dbLayer = new DbLayer()) { SqlCommand SqlCmd = new SqlCommand("spSelectEmployee"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@Id", objInActive.Id); SqlCmd.Parameters.AddWithValue("@Active", 0); SqlCmd.Parameters.AddWithValue("@ActionBy", objInActive.ActionBy); inActiveList = dbLayer.GetEntityList <EmployeeDTO>(SqlCmd); } return(inActiveList); }
public HttpResponseMessage GetAllEmployees(EmployeeGetDTO ObjGetEmp) { HttpResponseMessage message; try { // EmployeeDataAccessLayer dal = new EmployeeDataAccessLayer(); var dynObj = new { result = _employee.GetAllEmployees(ObjGetEmp) }; message = Request.CreateResponse(HttpStatusCode.OK, dynObj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Somthing wrong, Try Again!" }); ErrorLog.CreateErrorMessage(ex, "Employee", "GetAllEmplloyees"); } return(message); }
public List <EmployeeDTO> GetAllEmployees(EmployeeGetDTO ObjGetEmp) { List <EmployeeDTO> employee = new List <EmployeeDTO>(); using (DbLayer dbLayer = new DbLayer()) { SqlCommand SqlCmd = new SqlCommand("spSelectEmployee"); SqlCmd.Parameters.AddWithValue("@ActionBy", ObjGetEmp.ActionBy); SqlCmd.CommandType = CommandType.StoredProcedure; employee = dbLayer.GetEntityList <EmployeeDTO>(SqlCmd); foreach (var emp in employee) { foreach (var emp2 in employee) { if (emp.ReportTo == emp2.Id) { emp.ReportToName = emp2.FirstName + " " + emp2.SecondName; } } } } return(employee); }
public bool InsertEmployee(EmployeeInsertDTO employee) { bool res = false; EmployeeGetDTO emp = new EmployeeGetDTO(); SqlCommand SqlCmd = new SqlCommand("spInsertEmployee"); SqlCmd.CommandType = CommandType.StoredProcedure; SqlCmd.Parameters.AddWithValue("@ReferenceId", ((employee.ReferenceId == null) ? "" : employee.ReferenceId)); SqlCmd.Parameters.AddWithValue("@FirstName", employee.FirstName); SqlCmd.Parameters.AddWithValue("@SecondName", ((employee.SecondName == null) ? "" : employee.SecondName)); SqlCmd.Parameters.AddWithValue("@FatherName", employee.FatherName); SqlCmd.Parameters.AddWithValue("@Gender", employee.Gender); SqlCmd.Parameters.AddWithValue("@DateOfBirth", employee.DateOfBirth); SqlCmd.Parameters.AddWithValue("@ContactNo", employee.ContactNo); SqlCmd.Parameters.AddWithValue("@Email", ((employee.Email == null) ? "" : employee.Email)); SqlCmd.Parameters.AddWithValue("@CurrentAddress", employee.CurrentAddress); SqlCmd.Parameters.AddWithValue("@PermanentAddress", employee.PermanentAddress); SqlCmd.Parameters.AddWithValue("@NativePlace", employee.NativePlace); SqlCmd.Parameters.AddWithValue("@BloodGroup", employee.BloodGroup); SqlCmd.Parameters.AddWithValue("@MedicalExam", employee.MedicalExam); SqlCmd.Parameters.AddWithValue("@DesignationId", employee.DesignationId); SqlCmd.Parameters.AddWithValue("@ReportTo", employee.ReportTo); SqlCmd.Parameters.AddWithValue("@CompanyId", employee.CompanyId); SqlCmd.Parameters.AddWithValue("@State", employee.State); SqlCmd.Parameters.AddWithValue("@City", employee.City); SqlCmd.Parameters.AddWithValue("@AdhaarNo", employee.AdhaarNo); SqlCmd.Parameters.AddWithValue("@AlternateContactNo", employee.AlternateContactNo); SqlCmd.Parameters.AddWithValue("@Photo", employee.Photo); SqlCmd.Parameters.AddWithValue("@PreviousCompany", employee.PreviousCompany); SqlCmd.Parameters.AddWithValue("@JobType", employee.JobType); SqlCmd.Parameters.AddWithValue("@DOJ", employee.DOJ); SqlCmd.Parameters.AddWithValue("@ReferenceBy", employee.ReferenceBy); SqlCmd.Parameters.AddWithValue("@ReferenceContact1", employee.ReferenceContact1); SqlCmd.Parameters.AddWithValue("@ReferenceContact2", employee.ReferenceContact2); SqlCmd.Parameters.AddWithValue("@MaritalStatus", employee.MaritalStatus); SqlCmd.Parameters.AddWithValue("@MotherName", employee.MotherName); emp = new DbLayer().GetEntityList <EmployeeGetDTO>(SqlCmd).FirstOrDefault(); if (emp.EmpId > 0) { res = true; } if (emp.EmpId > 0 && employee.BankDetail.Count > 0) { foreach (var c in employee.BankDetail) { SqlCommand sqlCmd2 = new SqlCommand("spInsertEmployeeBank"); sqlCmd2.CommandType = CommandType.StoredProcedure; if (sqlCmd2.Connection != null) { if (sqlCmd2.Connection.State == ConnectionState.Closed) { sqlCmd2.Connection.Open(); } } sqlCmd2.Parameters.AddWithValue("@EmployeeId", emp.EmpId); sqlCmd2.Parameters.AddWithValue("@AccountNumber", c.AccountNo); sqlCmd2.Parameters.AddWithValue("@BankName", c.BankName); sqlCmd2.Parameters.AddWithValue("@BranchName", c.Branch); sqlCmd2.Parameters.AddWithValue("@IFSCCode", c.IFSC); sqlCmd2.Parameters.AddWithValue("@MICRCode", c.MICR); sqlCmd2.Parameters.AddWithValue("@IsPrimaryAccount", c.isPrimary); sqlCmd2.Parameters.AddWithValue("@CreatedBy", c.CreatedBy); int queryRes = new DbLayer().ExecuteNonQuery(sqlCmd2); if (queryRes != Int32.MaxValue) { res = true; sqlCmd2.Connection.Close(); } else { // this part needed error handling code. res = false; } } } return(res); }