protected void Page_Load(object sender, EventArgs e)
{
try
{
if (Request.QueryString["Type"] != null)
{
switch (Request.QueryString["Type"])
{
case "QuestionnaireResponse":
if (Request.QueryString["PQID"] != null)
{
QuestionnaireResponse report = new QuestionnaireResponse();
securityAgent = new CryptoProvider();
report.Parameters["@PQID"].Value = securityAgent.decryptText(Request.QueryString["PQID"].Replace(" ", "+"));
ReportViewerControl.Report = report;
}
break;
case "PatientReport":
if (Request.QueryString["PatientID"] != null)
{
ConsolidatedReport report = new ConsolidatedReport();
securityAgent = new CryptoProvider();
report.Parameters["@PatientID"].Value = securityAgent.decryptText(Request.QueryString["PatientID"].Replace(" ", "+"));
ReportViewerControl.Report = report;
}
break;
case "VisitDetails":
if (Request.QueryString["PatientID"] != null)
{
TestSummaryReport report = new TestSummaryReport();
securityAgent = new CryptoProvider();
report.Parameters["@PatientID"].Value = securityAgent.decryptText(Request.QueryString["PatientID"].Replace(" ", "+"));
ReportViewerControl.Report = report;
}
break;
}
}
}
catch (Exception ex)
{
CommonHelpers.writeLogToFile("Page_Load: ReportViewer.aspx", ex.Message);
}
}
public List <ConsolidatedReport> GetCumulativeFamilyExpenseByDate(string startDate, string endDate)
{
using (SqlConnection connection = new SqlConnection(Utilities.GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("GetCumulativeFamilyExpenseByDate", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@startDate", startDate);
command.Parameters.AddWithValue("@endDate", endDate);
try
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
SqlDataReader dr = command.ExecuteReader();
List <ConsolidatedReport> consolidatedReports = new List <ConsolidatedReport>();
while (dr.Read())
{
ConsolidatedReport consolidatedReport = new ConsolidatedReport();
consolidatedReport.Name = dr["Name"].ToString();
consolidatedReport.Spent = (int)dr["Spent"];
consolidatedReports.Add(consolidatedReport);
}
return(consolidatedReports);
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
}
return(null);
}
public List <List <ConsolidatedReport> > GetTodayYesterdayAndMonthlyExpense()
{
using (SqlConnection connection = new SqlConnection(Utilities.GetConnectionString()))
{
using (SqlCommand command = new SqlCommand("GetTodayYesterdayAndMonthlyExpense", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
try
{
if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
using (SqlDataReader dr = command.ExecuteReader())
{
List <ConsolidatedReport> todayFamilyExpenses = new List <ConsolidatedReport>();
List <ConsolidatedReport> yesterdayFamilyExpenses = new List <ConsolidatedReport>();
List <ConsolidatedReport> monthlyFamilyExpenses = new List <ConsolidatedReport>();
while (dr.Read())
{
ConsolidatedReport todayFamilyExpense = new ConsolidatedReport();
todayFamilyExpense.Name = dr["Name"].ToString();
todayFamilyExpense.Spent = (int)dr["SpentToday"];
todayFamilyExpense.Remark = dr["Remark"].ToString();
todayFamilyExpenses.Add(todayFamilyExpense);
}
if (dr.NextResult())
{
while (dr.Read())
{
ConsolidatedReport yesterdayFamilyExpense = new ConsolidatedReport();
yesterdayFamilyExpense.Name = dr["Name"].ToString();
yesterdayFamilyExpense.Spent = (int)dr["SpentYesterday"];
yesterdayFamilyExpense.Remark = dr["Remark"].ToString();
yesterdayFamilyExpenses.Add(yesterdayFamilyExpense);
}
}
if (dr.NextResult())
{
while (dr.Read())
{
ConsolidatedReport monthlyFamilyExpense = new ConsolidatedReport();
monthlyFamilyExpense.Name = dr["Name"].ToString();
monthlyFamilyExpense.Spent = (int)dr["SpentMonthly"];
monthlyFamilyExpense.Remark = dr["Remark"].ToString();
monthlyFamilyExpenses.Add(monthlyFamilyExpense);
}
}
List <List <ConsolidatedReport> > consolidatedReports =
new List <List <ConsolidatedReport> >()
{
todayFamilyExpenses, yesterdayFamilyExpenses, monthlyFamilyExpenses
};
return(consolidatedReports);
}
}
}
catch (SqlException ex)
{
}
finally
{
if (connection.State == System.Data.ConnectionState.Open)
{
connection.Close();
}
}
}
}
return(null);
}
