protected void BindGridBasedOnSearch() { List <PurchaseOrder> POList = new List <PurchaseOrder>(); string supplierName = ddlSupplier.Text; string from = txtFrom.Text; string to = txtTo.Text; if ((from == "" || to == "") && supplierName == "---Select Supplier---") { ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>win.alert('Notice', 'Please input search condition!');</script>"); POList = PoDAO.findPOList(); } if (supplierName == "---Select Supplier---" && (from != "" && to != "")) { DateTime dateFrom = Convert.ToDateTime(from); DateTime dateTo = Convert.ToDateTime(to); POList = PoDAO.findPOByDate(dateFrom, dateTo); } if ((from == "" || to == "") && supplierName != "---Select Supplier---") { string supID = supDAO.findSupplierByName(supplierName).supplierID; POList = PoDAO.findPOBySupplierID(supID); } if (from != "" && to != "" && supplierName != "---Select Supplier---") { DateTime dateFrom = Convert.ToDateTime(from); DateTime dateTo = Convert.ToDateTime(to); string supID = supDAO.findSupplierByName(supplierName).supplierID; POList = PoDAO.findPOByDateAndSupID(dateFrom, dateTo, supID); } GridView_PurchaseOrder.DataSource = POList; GridView_PurchaseOrder.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { List <ReorderItem> list = new List <ReorderItem>(); list = (List <ReorderItem>)Session["finalReorderList"]; List <ReorderItem> list1 = new List <ReorderItem>(); string supplierID = Request.QueryString["supplierID"]; for (int i = list.Count - 1; i >= 0; i--) { if (list[i].SupplierID == supplierID) { list1.Add(list[i]); } } List <POItem> POList = new List <POItem>(); for (int i = 0; i < list1.Count; i++) { string itemID = list1[i].ItemID; POList.Add(new POItem()); POList[i].ItemID = itemID; POList[i].Description = list1[i].Description; POList[i].OrderQty = list1[i].OrderQty; POList[i].Price = list1[i].Price; POList[i].TotalAmount = (POList[i].Price) * (POList[i].OrderQty); } GridView_PurchaseOrder.DataSource = POList; GridView_PurchaseOrder.DataBind(); }
protected void BindGrid() { List <PurchaseOrder> POList = new List <PurchaseOrder>(); POList = PoDAO.findPOList(); GridView_PurchaseOrder.DataSource = POList; GridView_PurchaseOrder.DataBind(); }