/* * Load available judges that don't have auditions assigned to them */ private void LoadEmptyJudges(int auditionId) { // Clear before updating ddlOpenJudges.Items.Clear(); ddlOpenJudges.Items.Add(new ListItem("", "")); // Load judge's that have not yet been assigned to any auditions DataTable table = DbInterfaceJudge.LoadUnscheduledJudges(auditionId); ddlOpenJudges.DataSource = table; ddlOpenJudges.DataBind(); }
/* * Pre: * Post: The input preference is deleted front the judge's list of preferences * @param preferenceType is the type of the preference to delete * @param preference is the specific preference to delete * @returns true if the preference is successfully deleted and false otherwise */ public bool deletePreference(Utility.JudgePreferences preferenceType, string preference) { bool result; JudgePreference prefToDelete = new JudgePreference(-1, preferenceType, preference); result = DbInterfaceJudge.DeleteJudgePreference(id, preferenceType, preference); if (result) { preferences.Remove(prefToDelete); } return(result); }
/* * Constructor for an existing judge * @param loadPreferences should be true if the judge's preferences need to be * loaded from the database and false otherwise */ public Judge(int id, string firstName, string mi, string lastName, string email, string phone, int districtId, string contactTypeId, List <JudgePreference> preferences, bool loadPreferences) : base(id, firstName, mi, lastName, email, phone, districtId, contactTypeId) { if (!loadPreferences) { this.preferences = preferences; } else { this.preferences = DbInterfaceJudge.GetJudgePreferences(id); } }
/* * Pre: id must be an integer or the empty string * Post: The input parameters are used to search for existing contacts. Matching contact * information is displayed in the input gridview. * @param gridView is the gridView in which the search results will be displayed * @param id is the id being searched for - must be an integer or the empty string * @param firstName is all or part of the first name being searched for * @param lastName is all or part of the last name being searched for * @returns true if results were found and false otherwise */ private bool searchJudgeContacts(GridView gridView, string id, string firstName, string lastName, string session) { DataTable table; bool result = true; try { if (!id.Equals("")) { table = DbInterfaceJudge.GetJudgeSearchResults(id, firstName, lastName); } else { table = DbInterfaceJudge.GetJudgeSearchResults("", firstName, lastName); } //If there are results in the table, display them. Otherwise clear current //results and return false if (table != null && table.Rows.Count > 0) { gridView.DataSource = table; gridView.DataBind(); gridView.HeaderRow.BackColor = Color.Black; //save the data for quick re-binding upon paging Session[session] = table; } else if (table != null && table.Rows.Count == 0) { clearGridView(gridView); result = false; } else if (table == null) { showErrorMessage("Error: An error occurred during the search. Please make sure all entered data is valid."); } } catch (Exception e) { showErrorMessage("Error: An error occurred during the search. Please make sure all entered data is valid."); //log issue in database Utility.LogError("Judge Setup", "searchJudgeContacts", gridView.ID + ", " + id + ", " + firstName + ", " + lastName + ", " + session, "Message: " + e.Message + " Stack Trace: " + e.StackTrace, -1); } return(result); }
/* * Pre: * Post: The new preference is added to the judge's list of preferences *@param preferenceType is the type of the new preference *@param preference is the specific preference *@returns true if the preference was successfully added and false otherwise */ public bool addPreference(Utility.JudgePreferences preferenceType, string preference) { bool result = true; JudgePreference newPref = DbInterfaceJudge.AddJudgePreference(id, preferenceType, preference); if (preferences == null) { preferences = new List <JudgePreference>(); } if (newPref != null) { preferences.Add(newPref); } else { result = false; } return(result); }
public JudgeAuditionOrganizer(Dictionary <int, List <AuditionSlot> > judgeSlots, int auditionOrgId) { JudgeSlots = judgeSlots; JudgeTimeSlots = DbInterfaceJudge.LoadAuditionJudgesTimeSlots(auditionOrgId); AuditionTimeSlots = DbInterfaceAudition.GetAuditionTimeSlots(auditionOrgId); }
/* * Constructor for loading the data of an existing judge */ public Judge(int id) : base(id, true) { preferences = DbInterfaceJudge.GetJudgePreferences(id); }
/* * Load the time options for the selected audition */ //private void LoadAuditionTimes(int auditionOrgId) //{ // DataTable timePreferences = DbInterfaceAudition.LoadJudgeTimePreferenceOptions(auditionOrgId); // chkLstTime.DataSource = timePreferences; // chkLstTime.DataBind(); //} /* * Load the preferences of the selected judge for the selected year and audition district */ private void LoadJudgePreferences(int auditionOrgId) { int contactId = Convert.ToInt32(lblId.Text); List <string> auditionLevels = DbInterfaceJudge.LoadJudgeAuditionLevels(contactId, auditionOrgId); List <string> types = DbInterfaceJudge.LoadJudgeAuditionTypes(contactId, auditionOrgId); List <string> levels = DbInterfaceJudge.LoadJudgeLevels(contactId, auditionOrgId); List <string> instruments = DbInterfaceJudge.LoadJudgeInstruments(contactId, auditionOrgId); List <string> timeIds = DbInterfaceJudge.LoadJudgeTimes(contactId, auditionOrgId); // Load audition levels foreach (string level in auditionLevels) { int idx = -1; if (level.Equals("D2") || level.Equals("D2NM") || level.Equals("D3")) // Convert D2, D2NM, and D3 to District { idx = chkLstTrack.Items.IndexOf(new ListItem("District")); if (idx >= 0) { chkLstTrack.Items.FindByValue("District").Selected = true; } } else { idx = chkLstTrack.Items.IndexOf(new ListItem(level)); if (idx >= 0) { chkLstTrack.Items.FindByValue(level).Selected = true; } } } // Load audition types foreach (string type in types) { int idx = -1; idx = chkLstType.Items.IndexOf(new ListItem(type)); if (idx >= 0) { chkLstType.Items.FindByValue(type).Selected = true; } } // Load levels foreach (string level in levels) { if (chkLstCompLevel.Items.Count == 0) { chkLstCompLevel.DataBind(); } ListItem temp = chkLstCompLevel.Items.FindByValue(level.Trim()); if (temp != null) { chkLstCompLevel.Items.FindByValue(temp.Value).Selected = true; } } // Load instruments foreach (string instrument in instruments) { int idx = -1; if (chkLstInstrument.Items.Count == 0) { chkLstInstrument.DataBind(); } idx = chkLstInstrument.Items.IndexOf(new ListItem(instrument)); if (idx >= 0) { chkLstInstrument.Items.FindByValue(instrument).Selected = true; } } // Load times //foreach (string timeId in timeIds) //{ // if (chkLstTime.Items.Count == 0) chkLstTime.DataBind(); // ListItem temp = chkLstTime.Items.FindByValue(timeId.Trim()); // if (temp != null) // chkLstTime.Items.FindByValue(temp.Value).Selected = true; //} }
/* * Submit the changes to the judge's preferences for the selected audition */ protected void btnSubmit_Click(object sender, EventArgs e) { int contactId = -1; bool success = true; if (ddlDistrict.SelectedIndex > 0 && ddlYear.SelectedIndex > 0 && Int32.TryParse(lblId.Text, out contactId)) { int auditionOrgId = DbInterfaceAudition.GetAuditionOrgId(Convert.ToInt32(ddlDistrict.SelectedValue), Convert.ToInt32(ddlYear.SelectedValue)); // Delete all current preferences for the audition before updating DbInterfaceJudge.DeleteJudgePreferences(contactId, auditionOrgId, false); // Add new audition tracks foreach (ListItem item in chkLstTrack.Items) { if (item.Selected && item.Value.Equals("District")) // Convert District to D2, D2NM, and D3 { success = success && DbInterfaceJudge.AddJudgeAuditionLevel(contactId, auditionOrgId, "D2"); success = success && DbInterfaceJudge.AddJudgeAuditionLevel(contactId, auditionOrgId, "D2NM"); success = success && DbInterfaceJudge.AddJudgeAuditionLevel(contactId, auditionOrgId, "D3"); } else if (item.Selected) { success = success && DbInterfaceJudge.AddJudgeAuditionLevel(contactId, auditionOrgId, "State"); } } // Add new audition types foreach (ListItem item in chkLstType.Items) { if (item.Selected) { success = success && DbInterfaceJudge.AddJudgeAuditionType(contactId, auditionOrgId, item.Value); } } // Add new comp levels foreach (ListItem item in chkLstCompLevel.Items) { if (item.Selected) { success = success && DbInterfaceJudge.AddJudgeLevel(contactId, auditionOrgId, item.Value); } } // Add new instruments foreach (ListItem item in chkLstInstrument.Items) { if (item.Selected) { success = success && DbInterfaceJudge.AddJudgeInstrument(contactId, auditionOrgId, item.Value); } } // Add new time preferences //foreach (ListItem item in chkLstTime.Items) //{ // if (item.Selected) // success = success && DbInterfaceJudge.AddJudgeTime(contactId, auditionOrgId, Convert.ToInt32(item.Value)); //} } else { showWarningMessage("Please select a judge, district, and year."); success = false; } if (success) { showSuccessMessage("The judge's preferences were successfully updated."); clearPage(); } else { showErrorMessage("There was an error updating the judge's preferences"); } }
/* * Load the total time each judge for the audition has available */ private void LoadJudgeTimeAllowances(int auditionId) { judgeTimeAllowances = DbInterfaceJudge.LoadAuditionJudgesTimeAllowances(auditionId); Session[judgeTimesSession] = judgeTimeAllowances; }