private void Set_Queries_CurReport(int Guarantor)
{
ReportSimpleGrid report = new ReportSimpleGrid();
report.Query = DetailReport(Guarantor);
report.SubmitQuery(); // Fill the report.TableQ
report.TableQ = (new Report1_GuarantorAllocation()).ConvertTableToAllStrings(report.TableQ);
AddColBalance(report);// Calculates and Adds the Balance Column to the Query. // Also Adds Providers Abbreviations
report.Title = "Allocation to Guarantor ";
DataTable dtGuarantorName = Db.GetTableOld("SELECT "+DbHelper.Concat("LName","' '","FName")+"FROM Patient WHERE PatNum = " + Guarantor);
string GuarantorName = dtGuarantorName.Rows[0][0].ToString();
report.SubTitle.Add("Guarantor Account: " + GuarantorName + " " + DateTime.Now.ToShortDateString());
this._MainReportTable = report.TableQ;
this._Title = report.Title + "\n" + report.SubTitle[0];
BuildSummaryTable(Guarantor, DateTime.MinValue, DateTime.MaxValue);
report.Summary = SummaryTable_as_Strings(); // No Summary Table until built
//DataTable dtSummary = Db.GetTable(ProviderRevenueByGuarantor(Guarantor));
}
private void Set_Queries_CurReport(int Guarantor)
{
ReportSimpleGrid report = new ReportSimpleGrid();
report.Query = DetailReport(Guarantor);
report.SubmitQuery(); // Fill the report.TableQ
report.TableQ = (new Report1_GuarantorAllocation()).ConvertTableToAllStrings(report.TableQ);
AddColBalance(report); // Calculates and Adds the Balance Column to the Query. // Also Adds Providers Abbreviations
report.Title = "Allocation to Guarantor ";
DataTable dtGuarantorName = Db.GetTableOld("SELECT " + DbHelper.Concat("LName", "' '", "FName") + "FROM Patient WHERE PatNum = " + Guarantor);
string GuarantorName = dtGuarantorName.Rows[0][0].ToString();
report.SubTitle.Add("Guarantor Account: " + GuarantorName + " " + DateTime.Now.ToShortDateString());
this._MainReportTable = report.TableQ;
this._Title = report.Title + "\n" + report.SubTitle[0];
BuildSummaryTable(Guarantor, DateTime.MinValue, DateTime.MaxValue);
report.Summary = SummaryTable_as_Strings(); // No Summary Table until built
//DataTable dtSummary = Db.GetTable(ProviderRevenueByGuarantor(Guarantor));
}
/// <summary>
/// This expects that the last column will be Amount. If not It will do nothing.
/// RunDetialReport(Guarantor) query first. // Adds Provider's abbreviations to Table as well
///
/// Adds a column to report.TableQ
/// </summary>
private static void AddColBalance(ReportSimpleGrid report) //to report.TableQ
{
if (report.TableQ != null && report.TableQ.Columns.Count == 10)
if (report.TableQ.Columns[8].ColumnName == "Amount")
{
decimal RunningBalance = 0;
// Find Provider Abbreviations
System.Collections.Hashtable htProvs = new System.Collections.Hashtable();
try
{
DataTable dt = Db.GetTableOld("SELECT ProvNum, Abbr FROM Provider");
if (dt.Rows.Count != 0)
foreach (DataRow dr in dt.Rows)
if (!htProvs.ContainsKey(dr[0].ToString()))
htProvs[dr[0].ToString()] = dr[1].ToString();
if (!htProvs.ContainsKey("0"))
htProvs["0"] = "UnEarned";
}
catch
{
}
for (int i = 0; i < report.TableQ.Rows.Count; i++)
{
try
{
decimal amount = 0;
try
{
amount = decimal.Parse(report.TableQ.Rows[i][8].ToString());
}
catch { }
RunningBalance += amount;
if (amount > 0)
{
report.TableQ.Rows[i][5] = amount.ToString("F2");
report.TableQ.Rows[i][6] = "";
}
else
{
report.TableQ.Rows[i][5] = "";
report.TableQ.Rows[i][6] = amount.ToString("F2");
}
report.TableQ.Rows[i][7] = RunningBalance.ToString("F2");
// Fix Provider Column From # to Abreviation, Need to do it here
// because Prov# = 0 is undefined
if (htProvs.Count != 0)
if (htProvs.ContainsKey(report.TableQ.Rows[i][9].ToString()))
report.TableQ.Rows[i][4] = htProvs[report.TableQ.Rows[i][9].ToString()].ToString();
// Change Column 0 Date Display if Date on previous row has been displayed
if (i > 0)
if (report.TableQ.Rows[i][0].ToString() == report.TableQ.Rows[i - 1][0].ToString())
report.TableQ.Rows[i][0] = ""; // makes Dates more readable if not redundant.
}
catch
{
report.TableQ.Rows[i][7] = "ERROR";
}
}
report.TableQ.Columns.RemoveAt(8);// Remove Amount
report.TableQ.Columns.RemoveAt(8); // Remove ProvNums
DataRow dr2 = report.TableQ.NewRow();
report.TableQ.Rows.Add(dr2); // add blank row
dr2 = report.TableQ.NewRow();
dr2[6] = "Total";
dr2[7] = RunningBalance.ToString("F");
report.TableQ.Rows.Add(dr2);
}
}
/// <summary>
/// This expects that the last column will be Amount. If not It will do nothing.
/// RunDetialReport(Guarantor) query first. // Adds Provider's abbreviations to Table as well
///
/// Adds a column to report.TableQ
/// </summary>
private static void AddColBalance(ReportSimpleGrid report) //to report.TableQ
{
if (report.TableQ != null && report.TableQ.Columns.Count == 10)
{
if (report.TableQ.Columns[8].ColumnName == "Amount")
{
decimal RunningBalance = 0;
// Find Provider Abbreviations
System.Collections.Hashtable htProvs = new System.Collections.Hashtable();
try
{
DataTable dt = Db.GetTableOld("SELECT ProvNum, Abbr FROM Provider");
if (dt.Rows.Count != 0)
{
foreach (DataRow dr in dt.Rows)
{
if (!htProvs.ContainsKey(dr[0].ToString()))
{
htProvs[dr[0].ToString()] = dr[1].ToString();
}
}
}
if (!htProvs.ContainsKey("0"))
{
htProvs["0"] = "UnEarned";
}
}
catch
{
}
for (int i = 0; i < report.TableQ.Rows.Count; i++)
{
try
{
decimal amount = 0;
try
{
amount = decimal.Parse(report.TableQ.Rows[i][8].ToString());
}
catch { }
RunningBalance += amount;
if (amount > 0)
{
report.TableQ.Rows[i][5] = amount.ToString("F2");
report.TableQ.Rows[i][6] = "";
}
else
{
report.TableQ.Rows[i][5] = "";
report.TableQ.Rows[i][6] = amount.ToString("F2");
}
report.TableQ.Rows[i][7] = RunningBalance.ToString("F2");
// Fix Provider Column From # to Abreviation, Need to do it here
// because Prov# = 0 is undefined
if (htProvs.Count != 0)
{
if (htProvs.ContainsKey(report.TableQ.Rows[i][9].ToString()))
{
report.TableQ.Rows[i][4] = htProvs[report.TableQ.Rows[i][9].ToString()].ToString();
}
}
// Change Column 0 Date Display if Date on previous row has been displayed
if (i > 0)
{
if (report.TableQ.Rows[i][0].ToString() == report.TableQ.Rows[i - 1][0].ToString())
{
report.TableQ.Rows[i][0] = ""; // makes Dates more readable if not redundant.
}
}
}
catch
{
report.TableQ.Rows[i][7] = "ERROR";
}
}
report.TableQ.Columns.RemoveAt(8); // Remove Amount
report.TableQ.Columns.RemoveAt(8); // Remove ProvNums
DataRow dr2 = report.TableQ.NewRow();
report.TableQ.Rows.Add(dr2); // add blank row
dr2 = report.TableQ.NewRow();
dr2[6] = "Total";
dr2[7] = RunningBalance.ToString("F");
report.TableQ.Rows.Add(dr2);
}
}
}
