protected void Page_Load(object sender, EventArgs e)
{
UserRole = (Role)Convert.ToInt32(Session["RoleID"]);
lblMsg.Text = "";
chkAllCamps.Enabled = true;
//btnReport123.Enabled = true;
MakeKeyStatusBold();
if (!IsPostBack)
{
using (CIPMSEntities1 ctx = new CIPMSEntities1())
{
ddlCampYear.DataSource = ctx.tblCampYears.Select(x => new { id = x.ID, text = x.CampYear });
ddlCampYear.SelectedValue = Application["CampYearID"].ToString();
ddlCampYear.DataBind();
}
if (UserRole == Role.CampDirector)
{
ddlFed.Visible = false;
ddlFed.DataSourceID = null;
chklistCamp.DataSourceID = null;
chklistCamp.DataSource = CampsDA.GetCampByJWestCampDirector(Int32.Parse(ddlCampYear.SelectedValue), Int32.Parse(Session["UserID"].ToString()));
chklistCamp.DataBind();
chkAllCamps.Visible = false;
}
}
}
public static DataTable GetAllCampsByYearIDAndFedList(int CampYearID, object FedList)
{
var myFedList = (ListItemCollection)FedList;
string FedIDList = "";
foreach (ListItem li in myFedList)
{
if (li.Selected)
{
FedIDList += li.Value;
FedIDList += ", ";
}
}
// in case there is no fed selected, we must have some data in FedIDList else the T-SQL will return error
if (FedIDList != "")
{
FedIDList = FedIDList.Substring(0, FedIDList.Length - 2);
}
else
{
Role userRole = (Role)(Int32.Parse(HttpContext.Current.Session["RoleID"].ToString()));
if (userRole == Role.CampDirector)
{
return(CampsDA.GetCampByCampID(CampYearID, (int)Int32.Parse(HttpContext.Current.Session["UserID"].ToString())));
}
else
{
FedIDList = "-987654";
}
}
return(CampsDA.GetAllCampsByYearIDAndFedIDList(CampYearID, FedIDList));
}
