// POST api/EmployeesExpensesPayment
public HttpResponseMessage PostEmployeesExpensesPayment(EmployeesExpensesPayment employeesexpensespayment)
{
if (ModelState.IsValid)
{
employeesexpensespayment.InsertBy = loginUser.UserID;
db.EmployeesExpensesPayments.Add(employeesexpensespayment);
db.SaveChanges();
var TotalPayment = (db.EmployeesExpensesPayments.Where(r => (r.EmployeesExpensesID == employeesexpensespayment.EmployeesExpensesID) && (r.EmployeeID == employeesexpensespayment.EmployeeID)).Select(r => r.PaymentAmount)).ToList().Sum();
EmployeesExpenses employeesexpenses = db.EmployeesExpenses.Find(employeesexpensespayment.EmployeesExpensesID);
employeesexpenses.PaymentAmount = (decimal)TotalPayment;
employeesexpenses.DueAmount =employeesexpenses.ApproveAmount- (decimal)TotalPayment;
db.Entry(employeesexpenses).State = EntityState.Modified;
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, employeesexpensespayment);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = employeesexpensespayment.EmployeesExpensesPaymentID }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
// PUT api/EmployeesExpensesPayment/5
public HttpResponseMessage PutEmployeesExpensesPayment(long id, EmployeesExpensesPayment employeesexpensespayment)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != employeesexpensespayment.EmployeesExpensesPaymentID)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
employeesexpensespayment.UpdateBy = loginUser.UserID;
db.Entry(employeesexpensespayment).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
