// POST api/PurchaseBillDescription
public HttpResponseMessage PostPurchaseBillDescription(PurchaseBillDescription purchasebilldescription)
{
if (ModelState.IsValid)
{
purchasebilldescription.UOM = null;
purchasebilldescription.Product = null;
//db.PurchaseBillDescriptions.Add(purchasebilldescription);
purchasebilldescription.InsertBy = loginUser.UserID;
db.Entry(purchasebilldescription).State = purchasebilldescription.PurchaseBillDescriptionID == 0 ?
EntityState.Added : EntityState.Modified;
db.SaveChanges();
PurchaseOrderDescription purchaseOrderDescription = db.PurchaseOrderDescriptions.Where(r => (r.PurchaseOrderID == purchasebilldescription.PurchaseOrderID) && (r.ProductID == purchasebilldescription.ProductID)).SingleOrDefault();
if(purchaseOrderDescription!=null)
{
var BilledQuantity = (db.PurchaseBillDescriptions.Where(r => (r.ProductID == purchasebilldescription.ProductID) && (r.PurchaseOrderID == purchasebilldescription.PurchaseOrderID)).Select(r => r.Quantity)).ToList().Sum();
purchaseOrderDescription.BilledQuantity = BilledQuantity;
db.Entry(purchaseOrderDescription).State = EntityState.Modified;
db.SaveChanges();
}
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, purchasebilldescription);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = purchasebilldescription.PurchaseBillDescriptionID }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
// PUT api/PurchaseBillDescription/5
public HttpResponseMessage PutPurchaseBillDescription(long id, PurchaseBillDescription purchasebilldescription)
{
if (!ModelState.IsValid)
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
if (id != purchasebilldescription.PurchaseBillDescriptionID)
{
return Request.CreateResponse(HttpStatusCode.BadRequest);
}
purchasebilldescription.UpdateBy = loginUser.UserID;
db.Entry(purchasebilldescription).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException ex)
{
return Request.CreateErrorResponse(HttpStatusCode.NotFound, ex);
}
return Request.CreateResponse(HttpStatusCode.OK);
}
