//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);
}
