private void PopulateFederations() { _objGen = new General(); DataSet dsFed = _objGen.get_AllFederationsFJCFunding(); //var results = from myRow in dsFed.Tables[0].AsEnumerable() //where myRow.Field<int>("allowAdminPaymentProcessing") == 1 //select myRow; // 2013-01-03 Temporarily allow a few fedadmin to do payment processing string FedID = (string)Session["FedId"]; //DataRow[] drsss = dsFed.Tables[0].Select("ID = " + FedID); //bool isAllow = (bool)drsss[0]["allowAdminPaymentProcessing"]; if (FedID == "35" || FedID == "5" || FedID == "37" || FedID == "23" || FedID == "89" || FedID == "49" || FedID == "11" || FedID == "12" || FedID == "32" || FedID == "36" || FedID == "26") { var dict = new Dictionary <string, string>(); DataRow[] drs = dsFed.Tables[0].Select("ID = " + FedID); dict.Add(FedID, drs[0]["Federation"].ToString()); lstFederations.DataSource = dict; lstFederations.DataTextField = "Value"; lstFederations.DataValueField = "Key"; lstFederations.DataBind(); } else if (Session["RoleID"].ToString() == "6") { // Movement Camps Admin lstFederations.DataSource = MovementDAL.GetMovementFedIDsByUserID(Convert.ToInt32(Session["UsrID"])); lstFederations.DataTextField = "Federation"; lstFederations.DataValueField = "ID"; lstFederations.DataBind(); if ((lstFederations.Items.Count != 0)) { lstFederations.Items.Insert(0, new ListItem("--Select--", "-1")); } } else { lstFederations.DataSource = dsFed; lstFederations.DataTextField = "Federation"; lstFederations.DataValueField = "ID"; lstFederations.DataBind(); if ((lstFederations.Items.Count != 0)) { lstFederations.Items.Insert(0, new ListItem("--Select--", "-1")); } } }
private void PopulateSrchControls() { DataSet dsYears; _objGen = new General(); if (ddlCampYear.Items.Count <= 0) { dsYears = _objGen.GetAllCampYears(); ddlCampYear.Items.Clear(); ddlCampYear.DataSource = dsYears; ddlCampYear.DataTextField = "CampYear"; ddlCampYear.DataValueField = "ID"; ddlCampYear.DataBind(); if (_CampYear != "") { ddlCampYear.SelectedIndex = (int)Application["CampYear"] - 2008 - 1; } } if (_strRoleID == _strFJCAdmin || _strRoleID == _strApprover) //FJC Admin { //Populate Federation dropdown with all Federations DataSet dsFed; dsFed = _objGen.get_AllFederations(); //*********** //TV: 02/2009 - Issue # 4-002: changed Federation from DropDownList to multi-select ListBox lstFederations.Items.Clear(); lstFederations.DataSource = dsFed; lstFederations.DataTextField = "Federation"; lstFederations.DataValueField = "ID"; lstFederations.DataBind(); if ((lstFederations.Items.Count != 0)) { lstFederations.Items.Insert(0, new ListItem("--Select--", "-1")); } //*********** //Populate Camp List with all the Camps DataSet dsCamps; _objGen = new General(); dsCamps = _objGen.get_AllCampsList(ddlCampYear.SelectedItem.Text); lstCamps.Items.Clear(); lstCamps.DataSource = dsCamps; lstCamps.DataTextField = "Camp"; lstCamps.DataValueField = "ID"; lstCamps.DataBind(); if ((lstCamps.Items.Count != 0)) { lstCamps.Items.Insert(0, new ListItem("--Select--", "-1")); } //DataSet dsYears; //dsYears = _objGen.GetAllCampYears(); //ddlCampYear.DataSource = dsYears; //ddlCampYear.DataTextField = "CampYear"; //ddlCampYear.DataValueField = "ID"; //ddlCampYear.DataBind(); //if (_CampYear != "") //{ // ddlCampYear.SelectedIndex = ddlCampYear.Items.Count - 1; //} //Populate Users dropdown with all users DataSet dsModifiedBy; _objGen = new General(); dsModifiedBy = _objGen.get_Users(); ddlModifiedBy.DataSource = dsModifiedBy; ddlModifiedBy.DataTextField = "Name"; ddlModifiedBy.DataValueField = "ID"; ddlModifiedBy.DataBind(); if ((ddlModifiedBy.Items.Count != 0)) { ddlModifiedBy.Items.Insert(0, new ListItem("--Select--", "-1")); } } else if (_strRoleID == _strFedAdmin || _strRoleID == _strFed_CampAdmin) //Federation Admin OR Fed/Camp Admin { //*********** //TV: 02/2009 - Issue # 4-002: changed Federation from DropDownList to multi-select ListBox //Populate Federation dropdown with the Federation of user and disable it DataSet dsFedDetails = new DataSet(); lstFederations.Items.Clear(); if (_strFedID != "") { if (_strFedName != null) { lstFederations.Items.Insert(0, new ListItem(_strFedName, _strFedID)); } else { dsFedDetails = _objGen.GetFederationDetails(_strFedID); if (dsFedDetails != null) { lstFederations.Items.Insert(0, new ListItem(dsFedDetails.Tables[0].Rows[0]["Name"].ToString(), _strFedID)); } } txtHidFederations.Text = _strFedID; lstFederations.SelectedValue = _strFedID; } else { lstFederations.Items.Insert(0, new ListItem("--Select--", "-1")); } lstFederations.Enabled = false; //*********** //Populate Camp List with Camps associated with the Federation DataSet dsFedCamps; _objGen = new General(); if (IsFederationHasAllCamps()) { dsFedCamps = _objGen.get_AllCampsList(ddlCampYear.SelectedItem.Text); lstCamps.DataSource = dsFedCamps; lstCamps.DataTextField = "Camp"; lstCamps.DataValueField = "ID"; } else { //*********** //TV: 02/2009 - Issue # 4-002: changed Federation from DropDownList to multi-select ListBox, //call new overloaded method in the General class which accepts a comma delimted list of FedIDs //dsFedCamps = _objGen.GetFedCamps(Convert.ToInt32(_strFedID)); dsFedCamps = _objGen.GetFedCamps(_strFedID, ddlCampYear.SelectedItem.Text); //*********** lstCamps.DataSource = dsFedCamps; lstCamps.DataTextField = "Camp"; lstCamps.DataValueField = "CampID"; } lstCamps.DataBind(); if ((lstCamps.Items.Count != 0)) { lstCamps.Items.Insert(0, new ListItem("--Select--", "-1")); } //Populate Users dropdown with users associated with the Federation DataSet dsModifiedBy; _objGen = new General(); dsModifiedBy = _objGen.GetUsersByFederation(_strFedID); ddlModifiedBy.DataSource = dsModifiedBy; ddlModifiedBy.DataTextField = "Name"; ddlModifiedBy.DataValueField = "ID"; ddlModifiedBy.DataBind(); if ((ddlModifiedBy.Items.Count != 0)) { ddlModifiedBy.Items.Insert(0, new ListItem("--Select--", "-1")); } } else if (_strRoleID == _strCampDir) //Camp Director { //*********** //TV: 02/2009 - Issue # 4-002: changed Federation from DropDownList to multi-select ListBox //Set Federation dropdown to nothin and disable it lstFederations.Items.Clear(); lstFederations.Items.Insert(0, new ListItem("--Select--", "-1")); lstFederations.Enabled = false; //*********** //Populate Camp List with Camps associated with the Camp Director DataSet dsUsrCamps; _objGen = new General(); dsUsrCamps = _objGen.GetUserCamps(Convert.ToInt32(_strUsrID), Convert.ToInt32(Session["CampYear"])); lstCamps.Items.Clear(); lstCamps.DataSource = dsUsrCamps; lstCamps.DataTextField = "Camp"; lstCamps.DataValueField = "CampID"; lstCamps.DataBind(); if ((lstCamps.Items.Count != 0)) { lstCamps.Items.Insert(0, new ListItem("--Select--", "-1")); } //Set Users dropdown to nothin and disable it ddlModifiedBy.Items.Insert(0, new ListItem("--Select--", "-1")); ddlModifiedBy.Enabled = false; } else if (_strRoleID == _strMovementAdmin) //Movement Camps admin { var dt = MovementDAL.GetMovementFedIDsByUserID(Convert.ToInt32(Session["UsrID"])); lstFederations.Items.Clear(); lstFederations.DataSource = dt; lstFederations.DataTextField = "Federation"; lstFederations.DataValueField = "ID"; lstFederations.DataBind(); if ((lstFederations.Items.Count != 0)) { lstFederations.Items.Insert(0, new ListItem("--Select--", "-1")); } var result = (from myRow in dt.AsEnumerable() select myRow.ItemArray[0].ToString()).ToArray(); string fedIds = string.Join(",", result); var dsFedCamps = _objGen.GetFedCamps(fedIds, ddlCampYear.SelectedItem.Text); lstCamps.DataSource = dsFedCamps; lstCamps.DataTextField = "Camp"; lstCamps.DataValueField = "CampID"; lstCamps.DataBind(); if ((lstCamps.Items.Count != 0)) { lstCamps.Items.Insert(0, new ListItem("--Select--", "-1")); } //Populate Users dropdown with users associated with the Federation _objGen = new General(); var dsModifiedBy = _objGen.GetUsersByFederation(_strFedID); ddlModifiedBy.DataSource = dsModifiedBy; ddlModifiedBy.DataTextField = "Name"; ddlModifiedBy.DataValueField = "ID"; ddlModifiedBy.DataBind(); if ((ddlModifiedBy.Items.Count != 0)) { ddlModifiedBy.Items.Insert(0, new ListItem("--Select--", "-1")); } } //Populate Status List DataSet dsStatus; _objGen = new General(); dsStatus = _objGen.get_AllStatus(); lstStatus.DataSource = dsStatus; lstStatus.DataTextField = "Status"; lstStatus.DataValueField = "ID"; lstStatus.DataBind(); if ((lstStatus.Items.Count != 0)) { lstStatus.Items.Insert(0, new ListItem("--Select--", "-1")); } //Populate Sort Column Names Dropdown ddlColums.Items.Insert(0, new ListItem("--Select--", "-1")); ddlColums.Items.Add(new ListItem("First Name", "FirstName")); ddlColums.Items.Add(new ListItem("Last Name", "LastName")); ddlColums.Items.Add(new ListItem("Email ID", "PersonalEmail")); ddlColums.Items.Add(new ListItem("FJCID", "FJCID")); ddlColums.Items.Add(new ListItem("Federation", "Federation")); ddlColums.Items.Add(new ListItem("Age", "Age")); ddlColums.Items.Add(new ListItem("Grade", "Grade")); ddlColums.Items.Add(new ListItem("Zip", "Zip")); ddlColums.Items.Add(new ListItem("Date Created", "CreatedDate")); ddlColums.Items.Add(new ListItem("Date Submitted", "SubmittedDate")); ddlColums.Items.Add(new ListItem("Last Updated Date", "ModifiedDate")); ddlColums.Items.Add(new ListItem("Modified By", "Admin")); ddlColums.Items.Add(new ListItem("Status", "Status")); //Populate Sort Order Dropdown ddlSortOrder.Items.Insert(0, new ListItem("--Select--", "-1")); ddlSortOrder.Items.Add(new ListItem("Ascending", "Asc")); ddlSortOrder.Items.Add(new ListItem("Descending", "Desc")); }
private void SetVals() { var strRole = (string)Session["RoleID"]; var userId = Convert.ToInt32(Session["UsrID"]); if (strRole == ConfigurationManager.AppSettings["CAMPDIRECTOR"]) { //If logged in role is Camp Director show records for his camp(s) with status Elligible by Staff var strUserCamps = string.Empty; DataSet dsUserCamps = _objGen.GetUserCamps(userId, Convert.ToInt32(Session["CampYear"].ToString())); for (int i = 0; i <= dsUserCamps.Tables[0].Rows.Count - 1; i++) { if (strUserCamps == string.Empty) { strUserCamps = dsUserCamps.Tables[0].Rows[i]["CampId"].ToString(); } else { strUserCamps = strUserCamps + "," + dsUserCamps.Tables[0].Rows[i]["CampId"].ToString(); } } _objCamperDet.Camplist = strUserCamps; _objCamperDet.FederationID = (string)ConfigurationManager.AppSettings["JWest"] + "," + (string)ConfigurationManager.AppSettings["JWestLA"]; _objCamperDet.Status = "7,10"; } else if (strRole == ConfigurationManager.AppSettings["FEDADMIN"]) { //If logged in role is Federation Admin, show records for his federation with status - //Elligible, Pending School Eligibility, Not Registered, Being Researched, Camp Full, Payment Review _objCamperDet.FederationID = (string)Session["FedId"]; _objCamperDet.Status = "1,2,6,7,9,12,14,20,21,42,43,45"; if (_objCamperDet.FederationID == ((int)FederationEnum.PJL).ToString()) { _objCamperDet.Status += ",46,47,48,49"; } } else if (strRole == ConfigurationManager.AppSettings["FJCADMIN"]) { //If logged in role is FJC Admin, show records for his federation with status - //Elligible, Pending School Eligibility, Not Registered, Being Researched, Camp Full, Payment Review _objCamperDet.FederationID = (string)ConfigurationManager.AppSettings["JWest"] + "," + (string)ConfigurationManager.AppSettings["JWestLA"]; _objCamperDet.Status = "1,2,6,9,12,14,20,21,27,43,45"; } else if (strRole == ConfigurationManager.AppSettings["APPROVER"]) { //if logged in role is Approver, show records with status - Second Approval _objCamperDet.Status = "15,16"; } else if (strRole == "6") // Movement Camp Admin is 6 { DataTable dt = MovementDAL.GetMovementFedIDsByUserID(userId); var result = (from myRow in dt.AsEnumerable() select myRow.ItemArray[0].ToString()).ToArray(); string fedIds = string.Join(",", result); _objCamperDet.FederationID = fedIds; _objCamperDet.Status = "1,2,6,7,9,12,14,20,21,42,43,45"; } //Show only items with WorkQueue Flag as true _objCamperDet.WorkQueue = true; }