//Calculation to get total goods received so far for the PO public static int GetTotalGoodsReceived(int poid, string itemcode) { Team10ADModel context = new Team10ADModel(); List <GoodsReceivedRecord> goodsrecordlist = context.GoodsReceivedRecords.Where(x => x.POID == poid).ToList(); int totalqty = 0; if (goodsrecordlist != null) { foreach (GoodsReceivedRecord good in goodsrecordlist) { GoodsReceivedRecordDetail item = context.GoodsReceivedRecordDetails.Where(x => x.ItemCode == itemcode && x.GoodReceiveID == good.GoodReceiveID).First(); if (item.ReceivedQuantity != null) { totalqty += (int)item.ReceivedQuantity; } } } return(totalqty); }
public void SavingGoodsReceivedWCF(PostWCFReceivingGoodData[] goodwcflist) { PostWCFReceivingGoodData good = goodwcflist[1]; GoodsReceivedRecord grr = new GoodsReceivedRecord(); grr.POID = Convert.ToInt32(good.PoId); grr.StoreStaffID = Convert.ToInt32(good.StoreStaffID); grr.ReceivedDate = DateTime.Now; List <GoodsReceivedRecordDetail> grrdlist = new List <GoodsReceivedRecordDetail>(); foreach (PostWCFReceivingGoodData wcfgood in goodwcflist) { GoodsReceivedRecordDetail gooddetail = new GoodsReceivedRecordDetail(); gooddetail.ItemCode = wcfgood.ItemCode; gooddetail.ReceivedQuantity = Convert.ToInt32(wcfgood.Quantity); good.Remark = wcfgood.Remark; grrdlist.Add(gooddetail); } Data.SavingGoodsReceived((int)grr.POID, grr, grrdlist); }