public static Reports.POCRetensionReportData GetPOCRetensionReport(DateTime startDate, DateTime endDate)
{
Reports.POCRetensionReportData result = new Reports.POCRetensionReportData();
MySqlCommand cmd = new MySqlCommand("prcPOCRetensionReport_1");
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("StartDate", startDate);
cmd.Parameters.AddWithValue("EndDate", endDate);
using (MySqlConnection cn = new MySqlConnection(YellowstonePathology.Properties.Settings.Default.CurrentConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (MySqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result.StartDate = (DateTime)dr[0];
}
dr.NextResult();
while (dr.Read())
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pocRetensionReportDataItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
}
}
if (result.POCRetensionReportDataItems.Count == 0)
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
pocRetensionReportDataItem.Status = "No Cases Found.";
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
return(result);
}
public static Reports.POCRetensionReportData GetPOCRetensionReport(DateTime startDate, DateTime endDate)
{
Reports.POCRetensionReportData result = new Reports.POCRetensionReportData();
SqlCommand cmd = new SqlCommand("prcPOCRetensionReport_1");
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@StartDate", System.Data.SqlDbType.DateTime).Value = startDate;
cmd.Parameters.Add("@EndDate", System.Data.SqlDbType.DateTime).Value = endDate;
using (SqlConnection cn = new SqlConnection(Properties.Settings.Default.ProductionConnectionString))
{
cn.Open();
cmd.Connection = cn;
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
result.StartDate = (DateTime)dr[0];
}
dr.NextResult();
while (dr.Read())
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
Persistence.SqlDataReaderPropertyWriter sqlDataReaderPropertyWriter = new Persistence.SqlDataReaderPropertyWriter(pocRetensionReportDataItem, dr);
sqlDataReaderPropertyWriter.WriteProperties();
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
}
}
if (result.POCRetensionReportDataItems.Count == 0)
{
Reports.POCRetensionReportDataItem pocRetensionReportDataItem = new Reports.POCRetensionReportDataItem();
pocRetensionReportDataItem.Status = "No Cases Found.";
result.POCRetensionReportDataItems.Add(pocRetensionReportDataItem);
}
return result;
}
