private int BuildCampListThatHasData(ReportParamCampersFJC param, Role userRole)
{
if (UserRole == Role.CampDirector)
{
param.ProgramTypeID = ProgramType.JWest; // Camp director 's data must be limited with JWest
param.CampsThatHaveDataDict.Add(param.Camp_Dict.First().Key, param.Camp_Dict.First().Value);
param.CampID_HaveData_List = param.Camp_Dict.First().Key.ToString();
// Remember to save the changes back to session
Session["ReportParamCampersFJC"] = param;
return(1); // by definition, camper director is guaranteed to have one and ONLY on camp association
}
else
{
// For other roles that can see more than 1 camp
// The very first thing we have to do is to find out how many camps have actual data with selected Status
return(CreateCampThatHaveDataDictionaryObject());
}
}
protected void btnReport_Click(object sender, EventArgs e)
{
if (!ValidateInputData())
{
return;
}
ReportParamCampersFJC param = new ReportParamCampersFJC()
{
CampYearID = Int32.Parse(ddlCampYear.SelectedValue),
CampYear = Int32.Parse(ddlCampYear.SelectedItem.Text),
ProgramTypeID = (ProgramType)Int32.Parse(ddlProgram.SelectedValue),
FedID = -1, /* flag value*/
CamperOrg = CamperOrgType.EnrollmentConfirmationFJC
};
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
param.Camp_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
param.Status_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
param.BuildStrings();
Session.Add("ReportParamCampersFJC", param);
Response.Redirect("ReportFJCCampers.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
lblMsg.Text = "";
// We use Session variable for passing the composite object for reporting
param = (ReportParamCampersFJC)Session["ReportParamCampersFJC"];
UserRole = (Role)Convert.ToInt32(Session["RoleID"]);
DeteleOldReportFiles();
if (!IsPostBack)
{
// 2011-11-01 Camper Contact Info report is totally different from other reports here, but I need to re-use the paginig mechanism. Refactor is needed, else this page
// will be bloated
if (param.CamperOrg == CamperOrgType.CamperContactInfo || param.CamperOrg == CamperOrgType.CamperDetailReport)
{
CreateCampThatHaveDataDictionaryObject();
int CampCount = param.CampsThatHaveDataDict.Count;
if (CampCount > 0)
{
CreateMainReport();
// show this message when actual camp with data didn't match with selected camps by user
if (param.Camp_Dict.Count != param.CampsThatHaveDataDict.Count)
{
lblMsg.Text = String.Format("Only {0} of selected {1} have data", CampCount, param.Camp_Dict.Count);
}
spanPagerTop.Visible = true;
spanPagerBottom.Visible = true;
}
else
{
// no camps that have data with selected status, we would display message and show no data
lblMsg.Text = String.Format("There is no data from the selected {0} and Status", "programs and camps");
spanPagerTop.Visible = false;
spanPagerBottom.Visible = false;
}
}
else
{
// We need to return only camps that have data (selected camp with no data won't be displayed at all)
// so before we create the real report, we need to query the db to see how many camps actually have data
int CampCount = BuildCampListThatHasData(param, UserRole);
if (CampCount > 0)
{
// we have at least one camp that has data, so we can create the main reports with paging
CreateMainReport();
// show this message when actual camp with data didn't match with selected camps by user
if (param.Camp_Dict.Count != param.CampsThatHaveDataDict.Count)
{
lblMsg.Text = String.Format("Only {0} of selected {1} have data", CampCount, param.Camp_Dict.Count);
}
spanPagerTop.Visible = true;
spanPagerBottom.Visible = true;
}
else
{
// no camps that have data with selected status, we would display message and show no data
lblMsg.Text = String.Format("There is no data from the selected {0} and Status", param.CamperOrg);
spanPagerTop.Visible = false;
spanPagerBottom.Visible = false;
}
}
}
}
protected void btnReport_Click(object sender, EventArgs e)
{
bool e_flag = true;
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
e_flag = false;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one camp";
return;
}
e_flag = true;
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
e_flag = false;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one status";
return;
}
ReportParamCampersFJC param = new ReportParamCampersFJC()
{
CampYearID = Int32.Parse(ddlCampYear.SelectedValue),
ProgramTypeID = ProgramType.NoUse,
CampYear = Int32.Parse(ddlCampYear.SelectedItem.Text),
CamperOrg = CamperOrgType.EnrollmentConfirmationPartner
};
if (UserRole == Role.CampDirector)
{
param.FedID = -1; // for camp director, Fed are JWest Federations only
}
else
{
param.FedID = Int32.Parse(ddlFed.SelectedValue);
}
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
param.Camp_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
param.Status_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
param.BuildStrings();
Session.Add("ReportParamCampersFJC", param);
Response.Redirect("ReportFJCCAmpers.aspx");
}
private static DataTable GenerateDataTable(ReportParamCampersFJC param)
{
return(CamperApplicationBL.GetCamperSummaryReport(param.CampYearID, param.FedID, param.CampID_List, param.StatusID_List));
}
protected void btnReport_Click(object sender, EventArgs e)
{
if (!ValidateInputData())
{
return;
}
var param = new ReportParamCampersFJC()
{
CampYearID = Int32.Parse(ddlCampYear.SelectedValue),
CampYear = Int32.Parse(ddlCampYear.SelectedItem.Text),
FedID = -1, /* flag value*/
CamperOrg = CamperOrgType.CamperDetailReport
};
foreach (ListItem li in chklistFed.Items)
{
if (li.Selected)
{
param.Fed_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
param.Camp_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
param.Status_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
param.BuildStrings();
int timesReceivedGrant = 0;
if (chk1stTimers.Checked)
{
timesReceivedGrant += 2;
}
if (chk2ndTimers.Checked)
{
timesReceivedGrant += 4;
}
if (chk3rdTimers.Checked)
{
timesReceivedGrant += 8;
}
param.TimesReceivedGrant = timesReceivedGrant;
Session.Add("ReportParamCampersFJC", param);
Response.Redirect("ReportFJCCampers.aspx");
}
protected void btnReport_Click(object sender, EventArgs e)
{
bool e_flag = true;
foreach (ListItem li in chklistSynag.Items)
{
if (li.Selected)
{
e_flag = false;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one synagogue";
return;
}
e_flag = true;
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
e_flag = false;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one status";
return;
}
ReportParamCampersFJC param = new ReportParamCampersFJC()
{
CampYearID = Int32.Parse(ddlCampYear.SelectedValue),
CampYear = Int32.Parse(ddlCampYear.SelectedItem.Text),
ProgramTypeID = (ProgramType)(-1),
FedID = Int32.Parse(ddlFed.SelectedValue),
CamperOrg = CamperOrgType.Synagogue
};
foreach (ListItem li in chklistSynag.Items)
{
if (li.Selected)
{
param.Camp_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
param.Status_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
param.BuildStrings();
Session.Add("ReportParamCampersFJC", param);
Response.Redirect("ReportFJCCAmpers.aspx");
}
protected void btnReport_Click(object sender, EventArgs e)
{
bool e_flag = true;
foreach (ListItem li in chklistFed.Items)
{
if (li.Selected)
{
e_flag = false;
break;
}
}
if (e_flag && UserRole != Role.CampDirector)
{
lblMsg.Text = "You must select at least one federation/camp";
return;
}
e_flag = true;
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
e_flag = false;
break;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one camp";
return;
}
e_flag = true;
int status_count = 0;
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
e_flag = false;
status_count++;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one status";
return;
}
if (!chk1stTimers.Checked)
{
if (!chk2ndTimers.Checked)
{
if (!chk3rdTimers.Checked)
{
if (!chkAllTimers.Checked)
{
lblMsg.Text = "You must at least select one option from # of years in program ";
return;
}
}
}
}
ReportParamCampersFJC param = new ReportParamCampersFJC {
CampYearID = Int32.Parse(ddlCampYear.SelectedValue), ProgramTypeID = ProgramType.NoUse, CampYear = Int32.Parse(ddlCampYear.SelectedItem.Text)
};
if (UserRole == Role.CampDirector)
{
param.FedID = -1; // for camp director, Fed are JWest Federations only
}
else
{
param.FedID = Int32.Parse(chklistFed.SelectedValue);
}
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
param.Camp_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
param.Status_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
param.BuildStrings();
using (DataSet ds = GenerateDataSet())
{
if (chkAllTimers.Checked)
{
gvAllTimers.DataSource = ds.Tables["AllCampers"];
gvAllTimers.DataBind();
divAllTimers.Visible = true;
}
else
{
divAllTimers.Visible = false;
}
if (chk1stTimers.Checked)
{
gv1stTimers.DataSource = ds.Tables["1stYearCampers"];
gv1stTimers.DataBind();
div1stTimers.Visible = true;
}
else
{
div1stTimers.Visible = false;
}
if (chk2ndTimers.Checked)
{
gv2ndTimers.DataSource = ds.Tables["2ndYearCampers"];
gv2ndTimers.DataBind();
div2ndTimers.Visible = true;
}
else
{
div2ndTimers.Visible = false;
}
if (chk3rdTimers.Checked)
{
if (ds.Tables["3rdYearCampers"] != null)
{
if (ds.Tables["3rdYearCampers"].Rows.Count > 0)
{
gv3rdTimers.DataSource = ds.Tables["3rdYearCampers"];
gv3rdTimers.DataBind();
div3rdTimers.Visible = true;
}
else
{
div3rdTimers.Visible = false;
}
}
else
{
div3rdTimers.Visible = false;
}
}
else
{
div3rdTimers.Visible = false;
}
}
divMenu.Visible = false;
divReport.Visible = true;
}
protected void btnReport_Click(object sender, EventArgs e)
{
bool e_flag = true;
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
e_flag = false;
break;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one camp";
return;
}
e_flag = true;
int status_count = 0;
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
e_flag = false;
status_count++;
}
}
if (e_flag)
{
lblMsg.Text = "You must select at least one status";
return;
}
if (status_count != 1)
{
lblMsg.Text = "You can only select one status at a time";
return;
}
ReportParamCampersFJC param = new ReportParamCampersFJC();
param.CampYearID = Int32.Parse(ddlCampYear.SelectedValue);
param.ProgramTypeID = ProgramType.NoUse;
param.CampYear = Int32.Parse(ddlCampYear.SelectedItem.Text);
if (UserRole == Role.CampDirector)
{
param.FedID = -1; // for camp director, Fed are JWest Federations only
}
else
{
param.FedID = Int32.Parse(ddlFed.SelectedValue);
}
foreach (ListItem li in chklistCamp.Items)
{
if (li.Selected)
{
param.Camp_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
foreach (ListItem li in chklistStatus.Items)
{
if (li.Selected)
{
param.Status_Dict[Int32.Parse(li.Value)] = li.Text;
}
}
param.BuildStrings();
divMenu.Visible = false;
divReport.Visible = true;
gv.DataSource = GenerateDataTable(param);
gv.DataBind();
}
