public bool ModifyEmployee(ModifyEmployeeDTO obj)
{
bool res = false;
obj.ModifiedBy = "1002";
SqlCommand cmd = new SqlCommand("sp_ModifyEmployee");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@p_EmployeeId", obj.EmployeeId);
cmd.Parameters.AddWithValue("@p_EmployeeName", obj.EmployeeName);
cmd.Parameters.AddWithValue("@p_DateOfJoining", obj.DateOfJoining);
cmd.Parameters.AddWithValue("@p_EmployeeType", obj.EmployeeType);
cmd.Parameters.AddWithValue("@p_DepartmentId", obj.DepartmentId);
cmd.Parameters.AddWithValue("@p_RoleId", obj.RoleId);
cmd.Parameters.AddWithValue("@p_MobileNo", obj.MobileNo);
cmd.Parameters.AddWithValue("@p_Email", obj.Email);
cmd.Parameters.AddWithValue("@p_ActionBy", obj.ModifiedBy);
int result = new DBlayer().ExecuteNonQuery(cmd);
if (result != Int32.MaxValue)
{
res = true;
}
return(res);
}
public HttpResponseMessage ModifyEmployee(ModifyEmployeeDTO obj)
{
HttpResponseMessage message;
try
{
EmployeeDAL dal = new EmployeeDAL();
var dynobj = new { result = dal.ModifyEmployee(obj) };
message = Request.CreateResponse(HttpStatusCode.OK, dynobj);
}
catch (Exception ex)
{
message = Request.CreateResponse(HttpStatusCode.BadRequest, new { msgText = "something Wrong.Try Again!" });
}
return(message);
}
