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
}