protected void GrdOrgInvoicesOutstanding_Sort(string sortExpression, params string[] sortExpr)
{
DataTable dataTable = Session["orginvoicesoutstanding_data"] as DataTable;
if (dataTable != null)
{
if (Session["orginvoicesoutstanding_sortexpression"] == null)
{
Session["orginvoicesoutstanding_sortexpression"] = "";
}
DataView dataView = new DataView(dataTable);
string[] sortData = Session["orginvoicesoutstanding_sortexpression"].ToString().Trim().Split(' ');
string newSortExpr = (sortExpr.Length == 0) ?
(sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" :
sortExpr[0];
dataView.Sort = sortExpression + " " + newSortExpr;
Session["orginvoicesoutstanding_sortexpression"] = sortExpression + " " + newSortExpr;
GrdOrgInvoicesOutstanding.DataSource = dataView;
GrdOrgInvoicesOutstanding.DataBind();
}
}
protected void GrdOrgInvoicesOutstanding_FillGrid()
{
bool insuranceCompanies = !UserView.GetInstance().IsAgedCareView;
DataTable dt = InvoiceDB.GetAllOutstandingByOrgAsReport(Convert.ToInt32(Session["SiteID"]), 0, insuranceCompanies);
dt.DefaultView.Sort = "name";
dt = dt.DefaultView.ToTable();
Session["orginvoicesoutstanding_data"] = dt;
btnExportAllFacs.Visible = dt.Rows.Count > 0;
btnPrintAllFacs.Visible = dt.Rows.Count > 0;
if (dt.Rows.Count > 0)
{
GrdOrgInvoicesOutstanding.DataSource = dt;
try
{
GrdOrgInvoicesOutstanding.DataBind();
GrdOrgInvoicesOutstanding.PagerSettings.FirstPageText = "1";
GrdOrgInvoicesOutstanding.PagerSettings.LastPageText = GrdOrgInvoicesOutstanding.PageCount.ToString();
GrdOrgInvoicesOutstanding.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdOrgInvoicesOutstanding.DataSource = dt;
GrdOrgInvoicesOutstanding.DataBind();
int TotalColumns = GrdOrgInvoicesOutstanding.Rows[0].Cells.Count;
GrdOrgInvoicesOutstanding.Rows[0].Cells.Clear();
GrdOrgInvoicesOutstanding.Rows[0].Cells.Add(new TableCell());
GrdOrgInvoicesOutstanding.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdOrgInvoicesOutstanding.Rows[0].Cells[0].Text = "No Record Found";
}
btnEmailAllFacs.Attributes["onclick"] = "if (!confirm('Estimating 20 seconds per email for " + dt.Rows.Count + " facilities, you will need to let this page run for about " + (dt.Rows.Count / 3) + " Minutes. \\r\\nAre you sure you want to continue?')) return false;";
}