public bool UpdateEmployeeBankDtl(EmployeeBankDetailInsertDTO employee)
{
bool res = false;
SqlCommand sqlCmd = new SqlCommand("spUpdateEmployeeBankDtl");
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@EmployeeBankId", employee.EmployeeBankId);
sqlCmd.Parameters.AddWithValue("@EmployeeId", employee.Id);
sqlCmd.Parameters.AddWithValue("@AccountNumber", employee.AccountNo);
sqlCmd.Parameters.AddWithValue("@BankName", employee.BankName);
sqlCmd.Parameters.AddWithValue("@BranchName", employee.Branch);
sqlCmd.Parameters.AddWithValue("@IFSCCode", employee.IFSC);
sqlCmd.Parameters.AddWithValue("@MICRCode", employee.MICR);
sqlCmd.Parameters.AddWithValue("@IsPrimaryAccount", employee.isPrimary);
sqlCmd.Parameters.AddWithValue("@CreatedBy", employee.CreatedBy);
int queryRes = new DbLayer().ExecuteNonQuery(sqlCmd);
if (queryRes != Int32.MaxValue)
{
res = true;
}
else
{
// this part needed error handling code.
res = false;
}
return(res);
}
public HttpResponseMessage UpdateEmployeeBankDtl(EmployeeBankDetailInsertDTO employee)
{
HttpResponseMessage message;
try
{
// EmployeeDataAccessLayer dal = new EmployeeDataAccessLayer();
var dynObj = new { result = _employee.UpdateEmployeeBankDtl(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);
}
