//private void GetAllStoreUnit() //{ // StoreUnitBLL aStoreUnitBLL = new StoreUnitBLL(); // try // { // var row = aStoreUnitBLL.GetAllStoreUnit(((SessionUser)Session["SessionUser"]).OCode); // if (row.Count > 0) // { // ddlStoreUnit.DataSource = row.ToList(); // ddlStoreUnit.DataTextField = "Store_Unit_Name"; // ddlStoreUnit.DataValueField = "Store_Unit_Id"; // ddlStoreUnit.DataBind(); // ddlStoreUnit.Items.Insert(0, new ListItem("---Select One---", "0")); // } // } // catch // { // } //} //private void GetAllStore() //{ // StoreBLL aStoreBll = new StoreBLL(); // try // { // var row = aStoreBll.GetAllStoreLocation(((SessionUser)Session["SessionUser"]).OCode); // if (row.Count > 0) // { // ddlStoreName.DataSource = row.ToList(); // ddlStoreName.DataTextField = "StoreName"; // ddlStoreName.DataValueField = "Store_Code"; // ddlStoreName.DataBind(); // ddlStoreName.Items.Insert(0, new ListItem("---Select One---", "0")); // } // } // catch // { // } //} //protected void GetAllProject() //{ // try // { // ProjectBLL projectBll = new ProjectBLL(); // var row = projectBll.GetAllProject(); // if (row.Count > 0) // { // ddlProject.DataSource = row.ToList(); // ddlProject.DataTextField = "Project_Name"; // ddlProject.DataValueField = "Project_Code"; // ddlProject.DataBind(); // ddlProject.Items.Insert(0, new ListItem("---Select One---", "0")); // } // } // catch // { // } //} //public void FillCompany() //{ // DataTable dt = new DataTable(); // dt = companyBll.GetCentralCompany(); // ddlCompanyCode.DataSource = dt; // ddlCompanyCode.DataValueField = "CompanyCode"; // ddlCompanyCode.DataTextField = "CompanyCode"; // ddlCompanyCode.DataBind(); // foreach (DataRow dr in dt.Rows) // { // HiddenCompanyName.Value = dr["CompanyName"].ToString(); // HiddenCompanyCode.Value = dr["CompanyCode"].ToString(); // } //} private void GetApproveDistinctPO() { string OCODE = ((SessionUser)Session["SessionUser"]).OCode; //List<POReceivedR> PoReceivedPOes = _purchaseOrderbll.GetApproveDistinctPO(OCODE); var result = aMasterLCBLL.Get_All_PO_EstimatedSummaryList(OCODE).Where(x => x.IsPO_Approved == true).ToList(); if (result.Count > 0) { grdPOList.DataSource = result; grdPOList.DataBind(); } else { grdPOList.DataSource = null; grdPOList.DataBind(); } }
public void Get_PendingPOSummaryByDate() { string Ocode = ((SessionUser)Session["SessionUser"]).OCode; DateTime fromDate = Convert.ToDateTime(txtFromDate.Text); DateTime toDate = Convert.ToDateTime(txtToDate.Text); var result = aMasterLCBLL.Get_All_PO_EstimatedSummaryList(Ocode).Where(x => x.LC_PO_Date >= fromDate && x.LC_PO_Date <= toDate && x.IsPO_Approved == false).ToList(); if (result.Count > 0) { grvPOSummary.DataSource = result; grvPOSummary.DataBind(); } else { grvPOSummary.DataSource = null; grvPOSummary.DataBind(); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Found!')", true); } }