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) { } }