public async Task <IActionResult> CreateEmployee([FromBody] EmployeeInsertDTO employee) { var newEmployee = _mapper.Map <EmployeeInsertModel>(employee); var result = await _mediator.Send(new AddEmployeeCommand(newEmployee)); return(Created(string.Empty, new { result.Id, EmployeeName = result.Name, EmployeeAge = result.Age })); }
public ActionResult <string> CreateEmployee([FromBody] EmployeeInsertDTO employee) { var newEmployee = _mapper.Map <EmployeeInsertModel>(employee); var employeeId = _service.Insert(newEmployee); var uri = Url.Link("GetNameById", new { id = employeeId, }); return(Created(uri, new { employee.Name })); }
public HttpResponseMessage CreateEmployee(EmployeeInsertDTO employee) { HttpResponseMessage message; try { // EmployeeDataAccessLayer dal = new EmployeeDataAccessLayer(); var dynObj = new { result = _employee.InsertEmployee(employee) }; message = Request.CreateResponse(HttpStatusCode.OK, dynObj); } catch (Exception ex) { message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "Something wrong. Try Again!" }); ErrorLog.CreateErrorMessage(ex, "Employee", "CreateEmployee"); } return(message); }
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); }