public DataSet GetBillData(string companyID, string doctorID, string Speciality, string CaseNo, string BillNo) { string CompanyId = ((Bill_Sys_BillingCompanyObject)(Session["BILLING_COMPANY_OBJECT"])).SZ_COMPANY_ID; DataSet ds = new DataSet(); if (extddlLocation.Visible == true && extddlLocation.Text != "" && extddlLocation.Text != "NA") { ds = ds = objBillReport.GetBillDetails(companyID, doctorID, speciality, CaseNo, BillNo, extddlLocation.Text); } else { ds = objBillReport.GetBillDetails(companyID, doctorID, speciality, CaseNo, BillNo); } return(ds); }
protected void Page_Load(object sender, EventArgs e) { string selecttedrdb = Request.QueryString["selectedvalue"].ToString(); if (selecttedrdb == "0") { if (Request.QueryString["PomID"] != null) { pomid = Request.QueryString["PomID"].ToString(); companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; Bill_Sys_ReportBO _objReport = new Bill_Sys_ReportBO(); DataSet dsBillView = _objReport.GetBillDetails(pomid, companyid); grdPaymentTransaction.DataSource = dsBillView; grdPaymentTransaction.DataBind(); //ModalPopupExtender1.Show(); } } else { if (Request.QueryString["PomID"] != null) { pomid = Request.QueryString["PomID"].ToString(); companyid = ((Bill_Sys_BillingCompanyObject)Session["BILLING_COMPANY_OBJECT"]).SZ_COMPANY_ID; Bill_Sys_ReportBO _objReport = new Bill_Sys_ReportBO(); DataSet dsBillView = _objReport.GetBillDetailsOther(pomid, companyid); grdPaymentTransaction.DataSource = dsBillView; grdPaymentTransaction.DataBind(); //ModalPopupExtender1.Show(); } } }
protected void grdPomReport_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("View")) { int index = Convert.ToInt32(e.CommandArgument); string Path = grdPomReport.DataKeys[index][0].ToString(); Page.ClientScript.RegisterClientScriptBlock(typeof(GridView), "Msg", "window.open('" + Path + "'); ", true); } if (e.CommandName.Equals("BillView")) { String sz_PomId = e.CommandArgument.ToString(); _objReport = new Bill_Sys_ReportBO(); DataSet dsBillView = _objReport.GetBillDetails(sz_PomId, txtCompanyID.Text); grdPaymentTransaction.DataSource = dsBillView; grdPaymentTransaction.DataBind(); ModalPopupExtender1.Show(); } #region "Sort" DataView dv; DataSet ds = new DataSet(); ds = (DataSet)Session["POMReport"]; dv = ds.Tables[0].DefaultView; if (e.CommandName.ToString() == "POMID") { if (txtSort.Text == e.CommandArgument + " ASC") { txtSort.Text = e.CommandArgument + " DESC"; } else { txtSort.Text = e.CommandArgument + " ASC"; } } else if (e.CommandName.ToString() == "BillNumber") { if (txtSort.Text == e.CommandArgument + " ASC") { txtSort.Text = e.CommandArgument + " DESC"; } else { txtSort.Text = e.CommandArgument + " ASC"; } } else if (e.CommandName.ToString() == "POMGeneratedDate") { if (txtSort.Text == e.CommandArgument + " ASC") { txtSort.Text = e.CommandArgument + " DESC"; } else { txtSort.Text = e.CommandArgument + " ASC"; } } else if (e.CommandName.ToString() == "BillStatus") { if (txtSort.Text == e.CommandArgument + " ASC") { txtSort.Text = e.CommandArgument + " DESC"; } else { txtSort.Text = e.CommandArgument + " ASC"; } } dv.Sort = txtSort.Text; grdPomReport.DataSource = dv; // grdExel.DataSource = dv; grdPomReport.DataBind(); // grdExel.DataBind(); #endregion }