public HttpResponseMessage updateStockTransferItem(String id, Models.TrnStockTransferItem stockTransferItem) { try { var stockTransferItems = from d in db.TrnStockTransferItems where d.Id == Convert.ToInt32(id) select d; if (stockTransferItems.Any()) { var updateStockTransferItem = stockTransferItems.FirstOrDefault(); updateStockTransferItem.STId = stockTransferItem.STId; updateStockTransferItem.ItemId = stockTransferItem.ItemId; updateStockTransferItem.ItemInventoryId = stockTransferItem.ItemInventoryId; updateStockTransferItem.Particulars = stockTransferItem.Particulars; updateStockTransferItem.UnitId = stockTransferItem.UnitId; updateStockTransferItem.Quantity = stockTransferItem.Quantity; updateStockTransferItem.Cost = stockTransferItem.Cost; updateStockTransferItem.Amount = stockTransferItem.Amount; var item = from d in db.MstArticles where d.Id == stockTransferItem.ItemId select d; updateStockTransferItem.BaseUnitId = item.First().UnitId; var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == stockTransferItem.ItemId && d.UnitId == stockTransferItem.UnitId select d; if (conversionUnit.First().Multiplier > 0) { updateStockTransferItem.BaseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier); } else { updateStockTransferItem.BaseQuantity = stockTransferItem.Quantity * 1; } var baseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier); if (baseQuantity > 0) { updateStockTransferItem.BaseCost = stockTransferItem.Amount / baseQuantity; } else { updateStockTransferItem.BaseCost = stockTransferItem.Amount; } db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertStockTransferItem(Models.TrnStockTransferItem stockTransferItem) { try { Data.TrnStockTransferItem newStockTransferItem = new Data.TrnStockTransferItem(); newStockTransferItem.STId = stockTransferItem.STId; newStockTransferItem.ItemId = stockTransferItem.ItemId; newStockTransferItem.ItemInventoryId = stockTransferItem.ItemInventoryId; newStockTransferItem.Particulars = stockTransferItem.Particulars; newStockTransferItem.UnitId = stockTransferItem.UnitId; newStockTransferItem.Quantity = stockTransferItem.Quantity; newStockTransferItem.Cost = stockTransferItem.Cost; newStockTransferItem.Amount = stockTransferItem.Amount; newStockTransferItem.BaseUnitId = stockTransferItem.BaseUnitId; var item = from d in db.MstArticles where d.Id == stockTransferItem.ItemId select d; newStockTransferItem.BaseUnitId = item.First().UnitId; var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == stockTransferItem.ItemId && d.UnitId == stockTransferItem.UnitId select d; if (conversionUnit.First().Multiplier > 0) { newStockTransferItem.BaseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier); } else { newStockTransferItem.BaseQuantity = stockTransferItem.Quantity * 1; } var baseQuantity = stockTransferItem.Quantity * (1 / conversionUnit.First().Multiplier); if (baseQuantity > 0) { newStockTransferItem.BaseCost = stockTransferItem.Amount / baseQuantity; } else { newStockTransferItem.BaseCost = stockTransferItem.Amount; } db.TrnStockTransferItems.InsertOnSubmit(newStockTransferItem); db.SubmitChanges(); return(newStockTransferItem.Id); } catch { return(0); } }