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."));
            }
        }