public HttpResponseMessage putPurchaseOrderLine(String id, Entities.TrnPurchaseOrderLine newPurchaseOrderLine) { try { var purchaseOrderLine = from d in db.TrnPurchaseOrderLines where d.Id == Convert.ToInt32(id) select d; if (purchaseOrderLine.Any()) { //var userId = (from d in db.MstUsers where d.AspNetUserId == User.Identity.GetUserId() select d).FirstOrDefault().Id; var updatePurchaseOrderLine = purchaseOrderLine.FirstOrDefault(); updatePurchaseOrderLine.PurchaseOrderId = newPurchaseOrderLine.PurchaseOrderId; updatePurchaseOrderLine.ItemId = newPurchaseOrderLine.ItemId; updatePurchaseOrderLine.UnitId = newPurchaseOrderLine.UnitId; updatePurchaseOrderLine.Quantity = newPurchaseOrderLine.Quantity; updatePurchaseOrderLine.Cost = newPurchaseOrderLine.Cost; updatePurchaseOrderLine.Amount = newPurchaseOrderLine.Amount; db.TrnPurchaseOrderLines.InsertOnSubmit(updatePurchaseOrderLine); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch (Exception e) { Debug.WriteLine(e); return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public HttpResponseMessage postPurchaseOrderLine(Entities.TrnPurchaseOrderLine purchaseOrderLine) { try { Data.TrnPurchaseOrderLine newPurchaseOrderLine = new Data.TrnPurchaseOrderLine(); newPurchaseOrderLine.PurchaseOrderId = purchaseOrderLine.PurchaseOrderId; newPurchaseOrderLine.ItemId = purchaseOrderLine.ItemId; newPurchaseOrderLine.UnitId = purchaseOrderLine.UnitId; newPurchaseOrderLine.Quantity = purchaseOrderLine.Quantity; newPurchaseOrderLine.Cost = purchaseOrderLine.Cost; newPurchaseOrderLine.Amount = purchaseOrderLine.Amount; db.TrnPurchaseOrderLines.InsertOnSubmit(newPurchaseOrderLine); db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } catch (Exception ex) { Debug.WriteLine(ex); return(Request.CreateResponse(HttpStatusCode.InternalServerError, "Something's wrong from the server.")); } }