Ejemplo n.º 1
0
        //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();
            }
        }
Ejemplo n.º 2
0
        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);
            }
        }