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);
}
