public static DataTable GetFJCCamperReport(CamperOrgType CamperOrg, ProgramType Program, int FedID, int CampYearID, int CampID, string StatusID_List)
{
var db = new SQLDBAccess("CIPMS");
// Camp and Syang are different
if (CamperOrg == CamperOrgType.EnrollmentConfirmationFJC || CamperOrg == CamperOrgType.EnrollmentConfirmationPartner)
{
db.AddParameter("@Action", "GetFJCCamperReportPerCamp");
}
else if (CamperOrg == CamperOrgType.Synagogue)
{
db.AddParameter("@Action", "GetFJCCamperReportPerSynag");
}
if (Program != ProgramType.NoUse)
{
db.AddParameter("@Program", Program);
}
if (FedID >= 0)
{
db.AddParameter("@FedID", FedID);
}
db.AddParameter("@CampYearID", CampYearID);
db.AddParameter("@CampID", CampID);
db.AddParameter("@StatusID_List", StatusID_List);
return(db.FillDataTable("usprsCamperApplications_Select"));
}
private string GetReportName(CamperOrgType type)
{
var fileName = "report";
switch (type)
{
case CamperOrgType.EnrollmentConfirmationFJC:
case CamperOrgType.EnrollmentConfirmationPartner:
fileName = "Camper Enrollment Confirmation Report";
break;
case CamperOrgType.CamperContactInfo:
fileName = "Camper Contact Info";
break;
case CamperOrgType.CamperDetailReport:
fileName = "Camper Detail Report";
break;
default:
fileName = "Camper Detail Report By Synagogue";
break;
}
return(fileName);
}
/// <summary>
/// Used for Excel reporting
/// </summary>
/// <param name="program"></param>
/// <param name="FedID"></param>
/// <param name="CampYearID"></param>
/// <param name="CampID_List"></param>
/// <param name="StatusID_List"></param>
/// <returns></returns>
public static DataSet GetFJCCamperReportInBatch(CamperOrgType CamperOrg, ProgramType program, int FedID, int CampYearID, string CampID_List, string StatusID_List, int TimesReceivedGrant)
{
DataTable dt;
dt = CamperApplicationDA.GetFJCCamperReportInBatch(CamperOrg, program, FedID, CampYearID, CampID_List, StatusID_List);
DataSet ds = new DataSet();
// now, create each table per camp, and store each table into a dataset
if (dt.Rows.Count > 0)
{
int LastCampID = Convert.ToInt32(dt.Rows[0]["CampID"]);
int CampID = LastCampID;
DataTable dtTemp = dt.Clone();
foreach (DataRow dr in dt.Rows)
{
CampID = Convert.ToInt32(dr["CampID"]);
if (CampID != LastCampID)
{
ds.Tables.Add(dtTemp);
dtTemp = null;
dtTemp = dt.Clone();
}
LastCampID = CampID;
dtTemp.ImportRow(dr);
}
// the last table must also be added because it never goes into the if condition right above
ds.Tables.Add(dtTemp);
}
// Delete the first column, because we don't need to display it
foreach (DataTable dtt in ds.Tables)
{
dtt.Columns.RemoveAt(0); // Camp ID column
}
return(ds);
}
