Exemple #1
0
    private void GetSalesManager()
    {
        DataTable ds = new DataTable();

        try
        {
            ds = ClsPurchaseOrder.GetPO_ApprovedDetails(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim()));
            if (ds.Rows.Count > 0)
            {
                GvwSalesRegister.Visible    = true;
                GvwSalesRegister.DataSource = ds;
                GvwSalesRegister.DataBind();
                ViewState["Data"] = ds;
                ds.Dispose();
                if (ViewState["PageINdex"] != null)
                {
                    GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString());
                }
            }
            else
            {
                lblmsg.Text = "NO Data Found...";
                GvwSalesRegister.Visible = false;
                //ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('NO Data Found...');</script>", false);
            }
        }
        catch (Exception ex)
        {
        }
    }
    private void GetSalesManager()
    {
        DataTable ds = new DataTable();

        try
        {
            ds = ClsPurchaseInvoice.Get_PurchaseOrderForPurchaseInvoice(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim()));
            GvwSalesRegister.DataSource = ds;
            GvwSalesRegister.DataBind();
            ViewState["Data"] = ds;
            ds.Dispose();
            if (ViewState["PageINdex"] != null)
            {
                GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString());
            }
        }
        catch (Exception ex)
        {
        }
    }
    private void GetSalesManager()
    {
        DataTable ds = new DataTable();

        try
        {
            ds = ClsPurchaseInvoice.Get_PurchaseOrderForPurchaseInvoice(Convert.ToDateTime(Txt_FromDate.Text.Trim()), Convert.ToDateTime(Txt_ToDate.Text.Trim()));
            if (ds.Rows.Count > 0)
            {
                lblMsg.Text = "";
                GvwSalesRegister.Visible    = true;
                GvwSalesRegister.DataSource = ds;
                GvwSalesRegister.DataBind();
                ViewState["Data"] = ds;
                ds.Dispose();
                if (ViewState["PageINdex"] != null)
                {
                    GvwSalesRegister.PageIndex = Convert.ToInt32(ViewState["PageINdex"].ToString());
                }

                for (int i = 0; i < ds.Rows.Count; i++)
                {
                    DataTable dtPartial = ClsPurchaseInvoice.GetPartialdataBasedOnPONum(ds.Rows[i]["GRN_Number"].ToString());
                    if (dtPartial.Rows.Count > 0)
                    {
                        GvwSalesRegister.Rows[i].Cells[1].BackColor = System.Drawing.Color.Yellow;
                    }
                }
            }
            else
            {
                GvwSalesRegister.Visible = false;
                lblMsg.Text = "No Records Found";
                // ScriptManager.RegisterStartupScript(this, typeof(Page), "Alert", "<script>alert('NO Data Found...');</script>", false);
            }
        }
        catch (Exception ex)
        {
        }
    }