public HttpResponseMessage updateStockInItem(String id, Models.TrnStockInItem stockInItem) { try { var stockInItems = from d in db.TrnStockInItems where d.Id == Convert.ToInt32(id) select d; if (stockInItems.Any()) { var updateStockInItem = stockInItems.FirstOrDefault(); updateStockInItem.INId = stockInItem.INId; updateStockInItem.ItemId = stockInItem.ItemId; updateStockInItem.Particulars = stockInItem.Particulars; updateStockInItem.UnitId = stockInItem.UnitId; updateStockInItem.Quantity = stockInItem.Quantity; updateStockInItem.Cost = stockInItem.Cost; updateStockInItem.Amount = stockInItem.Amount; var item = from d in db.MstArticles where d.Id == stockInItem.ItemId select d; updateStockInItem.BaseUnitId = item.First().UnitId; var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == stockInItem.ItemId && d.UnitId == stockInItem.UnitId select d; if (conversionUnit.First().Multiplier > 0) { updateStockInItem.BaseQuantity = stockInItem.Quantity * (1 / conversionUnit.First().Multiplier); } else { updateStockInItem.BaseQuantity = stockInItem.Quantity * 1; } var baseQuantity = stockInItem.Quantity * (1 / conversionUnit.First().Multiplier); if (baseQuantity > 0) { updateStockInItem.BaseCost = stockInItem.Amount / baseQuantity; } else { updateStockInItem.BaseCost = stockInItem.Amount; } db.SubmitChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound)); } } catch { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } }
public Int32 insertStockInItem(Models.TrnStockInItem stockInItem) { try { Data.TrnStockInItem newStockInItem = new Data.TrnStockInItem(); newStockInItem.INId = stockInItem.INId; newStockInItem.ItemId = stockInItem.ItemId; newStockInItem.Particulars = stockInItem.Particulars; newStockInItem.UnitId = stockInItem.UnitId; newStockInItem.Quantity = stockInItem.Quantity; newStockInItem.Cost = stockInItem.Cost; newStockInItem.Amount = stockInItem.Amount; var item = from d in db.MstArticles where d.Id == stockInItem.ItemId select d; newStockInItem.BaseUnitId = item.First().UnitId; var conversionUnit = from d in db.MstArticleUnits where d.ArticleId == stockInItem.ItemId && d.UnitId == stockInItem.UnitId select d; if (conversionUnit.First().Multiplier > 0) { newStockInItem.BaseQuantity = stockInItem.Quantity * (1 / conversionUnit.First().Multiplier); } else { newStockInItem.BaseQuantity = stockInItem.Quantity * 1; } var baseQuantity = stockInItem.Quantity * (1 / conversionUnit.First().Multiplier); if (baseQuantity > 0) { newStockInItem.BaseCost = stockInItem.Amount / baseQuantity; } else { newStockInItem.BaseCost = stockInItem.Amount; } db.TrnStockInItems.InsertOnSubmit(newStockInItem); db.SubmitChanges(); return(newStockInItem.Id); } catch { return(0); } }