protected void ProgramDisplay(object sender, EventArgs e) { ProgramDataContext program = new ProgramDataContext(); if (campus.SelectedIndex > 0) { programList.Items.Clear(); string linqQuery = campus.SelectedValue + " == \"YES\""; var programs = program.Programs .Where(linqQuery) .ToList(); programs = programs.Where(p => p.Active == true).ToList(); programList.Items.Add(new ListItem("Please Select:", "0")); var graduate = programs.Where(p => p.DegreeType == "GRADUATE").Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Graduate Degree Programs", "Header")); foreach (var subject in graduate) { programList.Items.Add(new ListItem(subject.Name + ", Graduate Degree", subject.ID.ToString())); } programPanel.Visible = true; } else { programPanel.Visible = false; } }
public string DetermineCampus(string zipCode) { string campus = "Louisville"; ProgramDataContext programs = new ProgramDataContext(); var lexingtonZipCodes = programs.ZipLists.Where(z => z.Location_Code == "21").Select(z => z.ZIP).ToList(); var fortKnoxZipCodes = programs.ZipLists.Where(z => z.Location_Code == "11").Select(z => z.ZIP).ToList(); var northernKentuckyZipCodes = programs.ZipLists.Where(z => z.Location_Code == "01").Select(z => z.ZIP).ToList(); if (lexingtonZipCodes.Contains(zipCode.Trim())) { campus = "Lexington"; } else if (fortKnoxZipCodes.Contains(zipCode.Trim())) { campus = "Fort Knox"; } else if (northernKentuckyZipCodes.Contains(zipCode.Trim())) { campus = "Northern Kentucky"; } return(campus); }
public string ZipCodes(string zipCode) { string campusID = "70"; ProgramDataContext programs = new ProgramDataContext(); var lexingtonZipCodes = programs.ZipLists.Where(z => z.Location_Code == "21").Select(z => z.ZIP).ToList(); var fortKnoxZipCodes = programs.ZipLists.Where(z => z.Location_Code == "11").Select(z => z.ZIP).ToList(); var northernKentuckyZipCodes = programs.ZipLists.Where(z => z.Location_Code == "01").Select(z => z.ZIP).ToList(); if (lexingtonZipCodes.Contains(zipCode.Trim())) { campusID = "71"; } else if (fortKnoxZipCodes.Contains(zipCode.Trim())) { campusID = "72"; } else if (fortKnoxZipCodes.Contains(zipCode.Trim())) { campusID = "73"; } return(campusID); }
public string OnlineAccount(string zipCode) { string campus = "SullivanLouisville"; ProgramDataContext programs = new ProgramDataContext(); var lexingtonZipCodes = programs.ZipLists.Where(z => z.Location_Code == "21").Select(z => z.ZIP).ToList(); if (lexingtonZipCodes.Contains(zipCode.Trim())) { campus = "SullivanLexington"; } return(campus); }
protected void ProgramDisplay(object sender, EventArgs e) { ProgramDataContext program = new ProgramDataContext(); if (campus.SelectedIndex > 0 && degreeType1.SelectedIndex > 0) { programList.Items.Clear(); string linqQuery = campus.SelectedValue + " == \"YES\""; var programs = program.Programs .Where(linqQuery) .ToList(); programs = programs.Where(p => p.Active == true).ToList(); programList.Items.Add(new ListItem("Please Select:", "0")); if (degreeType1.SelectedValue == "Undergraduate") { var associate = programs.Where(p => p.DegreeType == "ASSOCIATE ").OrderBy(p => p.VersionDescrip).Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Associate Degree Programs", "Header")); programList.DataSource = associate; programList.DataTextField = "Name"; programList.DataValueField = "ID"; programList.DataBind(); var bachelor = programs.Where(p => p.DegreeType == "BACHELOR").OrderBy(p => p.VersionDescrip).Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Bachelor Degree Programs", "Header")); programList.DataSource = bachelor; programList.DataTextField = "Name"; programList.DataValueField = "ID"; programList.DataBind(); var certificate = programs.Where(p => p.DegreeType == "CERTIFICATE ").Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Certificate Programs", "Header")); programList.DataSource = certificate; programList.DataTextField = "Name"; programList.DataValueField = "ID"; programList.DataBind(); var diploma = programs.Where(p => p.DegreeType == "DIPLOMA").Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Diploma Programs", "Header")); programList.DataSource = diploma; programList.DataTextField = "Name"; programList.DataValueField = "ID"; programList.DataBind(); //var dcCertificate = programs.Where(p => p.DegreeType == "DC").Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); //programList.Items.Add(new ListItem("Dale Carnegie Certificate Programs", "Header")); //programList.DataSource = dcCertificate; //programList.DataTextField = "Name"; //programList.DataValueField = "ID"; //programList.DataBind(); } else if (degreeType1.SelectedValue == "Graduate") { var graduate = programs.Where(p => p.DegreeType == "GRADUATE").Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Graduate Degree Programs", "Header")); programList.DataSource = graduate; programList.DataTextField = "Name"; programList.DataValueField = "ID"; programList.DataBind(); } else if (degreeType1.SelectedValue == "POST GRADUATE") { var postGrad = programs.Where(p => p.DegreeType == "POST GRADUATE ").Select(p => new { Name = p.VersionDescrip, ID = p.ProgramID }).OrderBy(p => p.Name); programList.Items.Add(new ListItem("Post Graduate Programs", "Header")); programList.DataSource = postGrad; programList.DataTextField = "Name"; programList.DataValueField = "ID"; programList.DataBind(); } programPanel.Visible = true; } else { programPanel.Visible = false; } }
//Used to get the Text value of a control so the CreateTiff function knows what to draw on the image protected string GetControlText(string controlId, Panel currentPanel) { ProgramDataContext program = new ProgramDataContext(); try { Control control = currentPanel.FindControl(controlId); //check to see what type of control is selected so you can get the appropiate text value if (control is TextBox) { return(((TextBox)control).Text); } else if (control is DropDownList) { if (((DropDownList)control).SelectedIndex > 0) { if (controlId != "programList") { return(((DropDownList)control).SelectedItem.Text); } else { var selectedProgram = program.Programs.FirstOrDefault(p => p.ProgramID == Convert.ToInt16(((DropDownList)control).SelectedValue)); HttpContext.Current.Session["ProgramDoc"] = selectedProgram.ProgramDoc.ToString(); return(((DropDownList)control).SelectedItem.Text + " - " + selectedProgram.DegreeType); } } else { return(null); } } else if (control is Literal) { return(((Literal)control).Text); } else if (control is RadioButtonList) { if (((RadioButtonList)control).SelectedIndex > -1) { return(((RadioButtonList)control).SelectedItem.Text); } else { return(null); } } else if (control is CheckBox) { if (((CheckBox)control).Checked) { return("Yes"); } else { return("No"); } } else if (control is HiddenField) { return(SigJsonToImage(((HiddenField)control).Value.ToString(), controlId)); } else { return(" "); } } catch { //Response.Redirect(controlId); return(" "); } }