protected void Page_Load(object sender, EventArgs e)
{
list = (List <ReorderItem>)Session["finalReorderList"];
string staffID = (string)Session["loginID"];
if (Session["finalReorderList"] != null)
{
var groupedSupplierList = list.Select(x => x.SupplierID).Distinct().ToList();
for (int i = 0; i < groupedSupplierList.Count; i++)
{
reorderCart.Add(new ReorderCart());
reorderCart[i].SupplierID = groupedSupplierList[i].ToString();
reorderCart[i].StaffName = storeStaffDAO.getStoreStaffInfoById(staffID).storeStaffName;
reorderCart[i].OrderDate = DateTime.Now.ToShortDateString();
poCart.Add(new PurchaseOrder());
poCart[i].supplierID = reorderCart[i].SupplierID;
poCart[i].orderBy = reorderCart[i].StaffName;
poCart[i].orderDate = DateTime.Now;
}
GridView_reorderListBySup.DataSource = reorderCart;
GridView_reorderListBySup.DataBind();
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (reorderCart.Count != 0)
{
for (int i = 0; i < poCart.Count; i++)
{
PoDAO.CreateNewPO(poCart[i]);//update PO table
string supplierID = poCart[i].supplierID;
List <ReorderItem> list1 = new List <ReorderItem>();
List <PurchaseOrderItem> poItemCart = new List <PurchaseOrderItem>();
List <StockCard> sList = new List <StockCard>();
for (int j = 0; j < list.Count; j++)
{
if (list[j].SupplierID == supplierID)
{
list1.Add(list[j]);
}
}
for (int k = 0; k < list1.Count; k++)
{
poItemCart.Add(new PurchaseOrderItem());
poItemCart[k].itemID = list1[k].ItemID;
poItemCart[k].quantity = list1[k].OrderQty;
poItemCart[k].poID = poCart[i].poID;
POItemDAO.CreateNewPOItem(poItemCart[k]); //Update Purchase Order Item table
itemDAO.UpdateItemQtyOnHand(poItemCart[k].itemID, poItemCart[k].quantity); //Update Item Table
sList.Add(new StockCard());
sList[k].itemID = list1[k].ItemID;
sList[k].date = poCart[i].orderDate;
sList[k].quantity = list1[k].OrderQty;
sList[k].balance = itemDAO.GetItemQtyByItemID(list1[k].ItemID);
sList[k].record = poCart[i].supplierID;
sDAO.CreateNewRecord(sList[k]);
}
}
Session["finalReorderList"] = null;
Session["reorderList"] = null;
GridView_reorderListBySup.DataSource = null;
GridView_reorderListBySup.DataBind();
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Success！');</script>");
}
else
{
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Empty list, please check！');</script>");
}
}
