public async Task <HttpResponseMessage> GetEmployeeDetails(int Uid)
{
try
{
if (Uid.Equals(0) || Uid.Equals(null))
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No details found for given id : " + Uid));
}
else
{
employee = await db.GetEmployeeDetails(Uid);
if (employee != null || employee.id != 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, employee));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No details found for given id : " + Uid));
}
}
}
catch (Exception es)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, es.Message));
}
}
public async Task <EmployeeDetailsBO> udpateEmployeeDetails(EmployeeDetailsBO employee)
{
try
{
con = await DBConnection.ApexConnection();
cmd = new DBConnection().BuildProcedureCommand("P_Ins_Employee", con);
cmd.Parameters.AddWithValue("@FirstName", employee.FirstName);
cmd.Parameters.AddWithValue("@LastName", employee.LastName);
cmd.Parameters.AddWithValue("@SSN", employee.SSN);
cmd.Parameters.AddWithValue("@countryCode", employee.countryCode);
cmd.Parameters.AddWithValue("@MobileNumber", employee.MobileNumber);
cmd.Parameters.AddWithValue("@Userid", employee.UserId);
using (var reader = await cmd.ExecuteReaderAsync())
{
if (reader.Read())
{
employee = new EmployeeDetailsBO();
employee.countryCode = reader["COUNTRYCODE"].ToString();
employee.MobileNumber = reader["Mobile"].ToString();
employee.FirstName = reader["FIRSTNAME"].ToString();
employee.LastName = reader["LASTNAME"].ToString();
employee.SSN = reader["SSN"].ToString();
employee.id = Convert.ToInt32(reader["ID"]);
}
}
con.Close();
return(employee);
}
catch (Exception es)
{
throw es;
}
}
public async Task <EmployeeDetailsBO> GetEmployeeDetails(int Uid)
{
try
{
con = await DBConnection.ApexConnection();
cmd = new DBConnection().BuildProcedureCommand("P_SEL_GET_EMPLOYEE_DETAILS", con);
cmd.Parameters.AddWithValue("@userid", Uid);
using (var reader = await cmd.ExecuteReaderAsync())
{
EmployeeDetailsBO emp = new EmployeeDetailsBO();
if (reader.Read())
{
emp.countryCode = reader["CountryCode"].ToString();
emp.MobileNumber = reader["Number"].ToString();
emp.FirstName = reader["FirstName"].ToString();
emp.LastName = reader["LastName"].ToString();
emp.SSN = reader["SSN"].ToString();
emp.id = Convert.ToInt32(reader["Empid"]);
}
con.Close();
return(emp);
}
}
catch (Exception es)
{
throw es;
}
}
public ActionResult Edit(EmployeeDetailsBO emp)
{
try
{
int UserId = Convert.ToInt32(Session["Uid"]);
emp.UserId = UserId;
IRestResponse response = consumer.UpdateEmployeeDetails(emp);
if ((int)response.StatusCode == 200)
{
var employee = JsonConvert.DeserializeObject <EmployeeDetailsBO>(response.Content);
return(RedirectToAction("Details", "Employee"));
}
else
{
if (ModelState.IsValid)
{
ModelState.AddModelError(string.Empty, "Something wrong, please raise the issue with support");
}
}
}
catch (Exception es)
{
ModelState.AddModelError(string.Empty, es.Message);
}
return(View());
}
public IRestResponse UpdateEmployeeDetails(EmployeeDetailsBO EmpBO)
{
var client = new RestClient(Url + ApexConfig.UdpateEmployeeDetails + EmpBO.UserId);
var request = new RestRequest(Method.PUT);
string jsonRequest = JsonConvert.SerializeObject(EmpBO);
request.AddParameter(
"application/json; charset=utf-8",
jsonRequest,
ParameterType.RequestBody);
request.AddBody(jsonRequest);
var response = client.Execute(request);
return(response);
}
public async Task <HttpResponseMessage> AddEmployeeInfo(EmployeeDetailsBO employee)
{
try
{
employee = await db.InsEmployeeDetails(employee);
if (employee.id != 0)
{
return(Request.CreateResponse(HttpStatusCode.Created, employee));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, "something bad happened"));
}
}
catch (Exception es)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, es.Message));
}
}
public async Task <HttpResponseMessage> UdpateEmployeeDetails(EmployeeDetailsBO employee, int Uid)
{
try
{
if (Uid != 0)
{
employee.UserId = Uid;
}
employee = await db.udpateEmployeeDetails(employee);
if (employee != null || employee.id != 0)
{
return(Request.CreateResponse(HttpStatusCode.OK, employee));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "No details found for given id : " + employee.id));
}
}
catch (Exception es)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, es.Message));
}
}
