public int price(int adjVID)
{
AdjustmentVoucherItemDAO adjvidao = new AdjustmentVoucherItemDAO();
List <AdjustmentVoucherItem> adjvitemlist = adjvidao.getAdjustmentVoucherItemListByADJVID(adjVID);
int stop = 0;
decimal unittotal = 0;
int qty = 0;
foreach (AdjustmentVoucherItem breakitem in adjvitemlist)
{
//update item quantity
SupplierItem supplieritem;
List <SupplierItem> itemlist = context.SupplierItems.Where(x => x.itemID == breakitem.itemID).ToList();
if (itemlist.Count > 0)// not null
{
supplieritem = itemlist.First();
qty = Math.Abs(breakitem.quantity);
unittotal = ((supplieritem.price) * qty);
if (unittotal >= 250)
{
stop = 1;
break;
}
}
}
context.SaveChanges();
return(stop);
}
public void addAdjV(List <AdjustmentVoucherItemcart> list)
{
AdjustmentVoucher adjvoucher = new AdjustmentVoucher();
adjvoucher.storeStaffID = (string)System.Web.HttpContext.Current.Session["loginID"];
adjvoucher.adjDate = DateTime.Now;
adjvoucher.status = "pending";
adjvoucher.authorisedBy = "";
context.AdjustmentVouchers.Add(adjvoucher);
int adjvID = adjvoucher.adjVID;
/*************Then Add ADJVItems******************/
AdjustmentVoucherItemDAO adjvidao = new AdjustmentVoucherItemDAO();
foreach (AdjustmentVoucherItemcart cartitem in list)
{
AdjustmentVoucherItem adjvi = new AdjustmentVoucherItem();
adjvi.adjVID = adjvoucher.adjVID;
adjvi.itemID = cartitem.ItemID;
adjvi.quantity = cartitem.Qty;
adjvi.record = cartitem.Record;
context.AdjustmentVoucherItems.Add(adjvi);
}
context.SaveChanges();
}
