protected void AddRequestBtn_Click(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
if (db.CourseRequests.Where(cr => cr.TermId == termId && cr.StudentId == SelectedStudentId && cr.CourseId == NewCourseRequestSelector.RequestedCourseId).Count() > 0)
{
LogError("Multiple Course Requests for the Same class detected.");
ErrorLabel.Text = "You have already submitted a course request for this student for this class.";
ErrorPanel.Visible = true;
return;
}
int crn = db.CourseRequests.Count() > 0 ? db.CourseRequests.OrderBy(cr => cr.id).ToList().Last().id + 1 : 0;
WebhostMySQLConnection.CourseRequest request = new WebhostMySQLConnection.CourseRequest()
{
CourseId = NewCourseRequestSelector.RequestedCourseId,
id = crn,
IsGlobalAlternate = NewCourseRequestSelector.Priority == 2,
IsSecondary = NewCourseRequestSelector.Priority == 1,
StudentId = SelectedStudentId,
TermId = termId
};
db.CourseRequests.Add(request);
db.SaveChanges();
State.log.WriteLine("Added new Course Request:");
State.log.WriteLine("{0} - {1}", SelectedStudentId, request.CourseId);
}
Response.Redirect(Request.RawUrl);
}
protected void DeleteRequestBtn_Click(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
WebhostMySQLConnection.CourseRequest request = db.CourseRequests.Where(cr => cr.id == CourseRequestId).Single();
request.APRequests.Clear();
db.CourseRequests.Remove(request);
//LogWarning("Deleted Course Request of {2} for {0} {1}.", request.Student.FirstName, request.Student.LastName, request.RequestableCourse.Course.Name);
db.SaveChanges();
Response.Redirect(Request.RawUrl);
}
}
protected void SelectCR_Click(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
LoadedId = -1;
int crid = Convert.ToInt32(CourseRequestDDL.SelectedValue);
WebhostMySQLConnection.CourseRequest courseRequest = db.CourseRequests.Where(cr => cr.id == crid).Single();
RequestedCourseName.Text = courseRequest.RequestableCourse.Course.Name;
int sid = Convert.ToInt32(StudentSelectDDL.SelectedValue);
Student student = db.Students.Where(s => s.ID == sid).Single();
int termId = DateRange.GetCurrentOrLastTerm();
List <int> currentClasses = student.Sections.Where(sec => sec.Terms.Select(t => t.id).Contains(termId)).Select(sec => sec.id).ToList();
CurrentCourseDDL.DataSource = SectionListItem.GetDataSource(currentClasses);
CurrentCourseDDL.DataTextField = "Text";
CurrentCourseDDL.DataValueField = "ID";
CurrentCourseDDL.DataBind();
SecondaryCourseDDL.DataSource = SectionListItem.GetDataSource(currentClasses);
SecondaryCourseDDL.DataTextField = "Text";
SecondaryCourseDDL.DataValueField = "ID";
SecondaryCourseDDL.DataBind();
int year = DateRange.GetCurrentAcademicYear();
GradeTable stdaf = db.GradeTables.Where(gt => gt.AcademicYearID == year && gt.Name.Equals("Standard A-F Scale")).Single();
CurrentCourseGradeDDL.DataSource = stdaf.GradeTableEntries.ToList();
CurrentCourseGradeDDL.DataTextField = "Name";
CurrentCourseGradeDDL.DataValueField = "id";
CurrentCourseGradeDDL.DataBind();
SecondaryCourseGradeDDL.DataSource = stdaf.GradeTableEntries.ToList();
SecondaryCourseGradeDDL.DataTextField = "Name";
SecondaryCourseGradeDDL.DataValueField = "id";
SecondaryCourseGradeDDL.DataBind();
List <int> facultyIds = db.Faculties.Select(f => f.ID).ToList();
CurrentTeacherDDL.DataSource = FacultyListItem.GetDataSource(facultyIds);
CurrentTeacherDDL.DataTextField = "Text";
CurrentTeacherDDL.DataValueField = "ID";
CurrentTeacherDDL.DataBind();
DeptHeadDDL.DataSource = FacultyListItem.GetDataSource(facultyIds);
DeptHeadDDL.DataTextField = "Text";
DeptHeadDDL.DataValueField = "ID";
DeptHeadDDL.DataBind();
GradeTable approval = db.GradeTables.Where(gt => gt.AcademicYearID == year && gt.Name.Equals("AP Approval")).Single();
ApprovalDDL.DataSource = approval.GradeTableEntries.ToList();
ApprovalDDL.DataTextField = "Name";
ApprovalDDL.DataValueField = "id";
ApprovalDDL.DataBind();
ApprovalPanel.Visible = true;
if (courseRequest.APRequests.Count > 0)
{
APRequest apcr = courseRequest.APRequests.FirstOrDefault();
LoadedId = apcr.id;
if (apcr.Sections.Count > 0)
{
List <Section> secs = apcr.Sections.ToList();
CurrentCourseDDL.ClearSelection();
CurrentCourseDDL.SelectedValue = Convert.ToString(secs[0].id);
if (student.StudentComments.Where(com => com.CommentHeader.SectionIndex == secs[0].id && com.CommentHeader.TermIndex == termId).Count() > 0)
{
StudentComment comment = student.StudentComments.Where(com => com.CommentHeader.SectionIndex == secs[0].id && com.CommentHeader.TermIndex == termId).Single();
CurrentCourseGradeDDL.ClearSelection();
CurrentCourseGradeDDL.SelectedValue = Convert.ToString(comment.FinalGradeID);
}
if (secs.Count > 1)
{
SecondaryCourseDDL.ClearSelection();
SecondaryCourseDDL.SelectedValue = Convert.ToString(secs[1].id);
if (student.StudentComments.Where(com => com.CommentHeader.SectionIndex == secs[1].id && com.CommentHeader.TermIndex == termId).Count() > 0)
{
StudentComment comment = student.StudentComments.Where(com => com.CommentHeader.SectionIndex == secs[1].id && com.CommentHeader.TermIndex == termId).Single();
SecondaryCourseGradeDDL.ClearSelection();
SecondaryCourseGradeDDL.SelectedValue = Convert.ToString(comment.FinalGradeID);
}
}
}
CurrentTeacherDDL.ClearSelection();
CurrentTeacherDDL.SelectedValue = Convert.ToString(apcr.TeacherSignedBy);
DeptHeadDDL.ClearSelection();
DeptHeadDDL.SelectedValue = Convert.ToString(apcr.DeptHeadSignedBy);
ApprovalDDL.ClearSelection();
ApprovalDDL.SelectedValue = Convert.ToString(apcr.ApprovalId);
}
}
}
protected void SubmitBtn_Click(object sender, EventArgs e)
{
using (WebhostEntities db = new WebhostEntities())
{
int newCRN = db.CourseRequests.Count() > 0? db.CourseRequests.OrderBy(c => c.id).ToList().Last().id : -1;
Student student = db.Students.Where(s => s.ID == SelectedStudentId).Single();
List <WebhostMySQLConnection.CourseRequest> coursereqs = student.CourseRequests.Where(cr => cr.TermId == termId).ToList();
foreach (WebhostMySQLConnection.CourseRequest cr in coursereqs)
{
if (cr.APRequests.Count > 0)
{
foreach (APRequest req in cr.APRequests)
{
req.Sections.Clear();
}
db.APRequests.RemoveRange(cr.APRequests);
cr.APRequests.Clear();
}
}
db.CourseRequests.RemoveRange(coursereqs);
if (SeniorProjectCB.Checked)
{
WebhostMySQLConnection.CourseRequest sp = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = 1995,
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(sp);
}
if (LSP.Checked)
{
WebhostMySQLConnection.CourseRequest sp = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = 2057,
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(sp);
}
if (ESL.Checked)
{
WebhostMySQLConnection.CourseRequest sp = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = student.GraduationYear > 2018 ? 2058 : 2059,
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(sp);
}
// Ignore if already enrolled in English Full Year class.
if (!EnglishFullYearCB.Checked)
{
WebhostMySQLConnection.CourseRequest eng1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(English1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(eng1);
if (English2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest eng2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(English2DDL.SelectedValue),
IsSecondary = EnglishSelectionPriority.SelectedIndex == 0,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(eng2);
}
}
if (!HistoryFullYearCB.Checked)
{
if (History1DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest hist1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(History1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(hist1);
if (History2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest hist2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(History2DDL.SelectedValue),
IsSecondary = HistorySelectionPriority.SelectedIndex == 0,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(hist2);
}
}
}
if (!MathFullYear.Checked)
{
if (Math1DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest math1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Math1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(math1);
if (Math2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest math2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Math2DDL.SelectedValue),
IsSecondary = MathPriority.SelectedIndex == 0,
IsGlobalAlternate = MathPriority.SelectedIndex == 2,
TermId = termId
};
db.CourseRequests.Add(math2);
}
}
}
if (!WorldLanguageSkip.Checked)
{
if (WorldLang1DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest wl1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(WorldLang1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(wl1);
if (WorldLang2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest wl2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(WorldLang2DDL.SelectedValue),
IsSecondary = MathPriority.SelectedIndex == 0,
IsGlobalAlternate = MathPriority.SelectedIndex == 2,
TermId = termId
};
db.CourseRequests.Add(wl2);
}
}
}
if (Tech1DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest tech1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Tech1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(tech1);
if (Tech2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest tech2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Tech2DDL.SelectedValue),
IsSecondary = TechPriority.SelectedIndex == 0,
IsGlobalAlternate = TechPriority.SelectedIndex == 2,
TermId = termId
};
db.CourseRequests.Add(tech2);
}
}
if (!ScienceFullYearCB.Checked)
{
if (Science1DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest sci1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Science1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(sci1);
if (Science2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest sci2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Science2DDL.SelectedValue),
IsSecondary = SciencePriority.SelectedIndex == 0,
IsGlobalAlternate = SciencePriority.SelectedIndex == 2,
TermId = termId
};
db.CourseRequests.Add(sci2);
}
if (Science3DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest sci3 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Science3DDL.SelectedValue),
IsSecondary = true,
IsGlobalAlternate = true,
TermId = termId
};
db.CourseRequests.Add(sci3);
}
}
}
if (Art1DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest art1 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Art1DDL.SelectedValue),
IsSecondary = false,
IsGlobalAlternate = false,
TermId = termId
};
db.CourseRequests.Add(art1);
if (Art2DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest art2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Art2DDL.SelectedValue),
IsSecondary = ArtPriority.SelectedIndex == 0,
IsGlobalAlternate = ArtPriority.SelectedIndex == 2,
TermId = termId
};
db.CourseRequests.Add(art2);
}
if (Art3DDL.SelectedIndex >= 0)
{
WebhostMySQLConnection.CourseRequest art2 = new WebhostMySQLConnection.CourseRequest()
{
id = ++newCRN,
StudentId = SelectedStudentId,
CourseId = Convert.ToInt32(Art3DDL.SelectedValue),
IsSecondary = Art3Priority.SelectedIndex == 1,
IsGlobalAlternate = Art3Priority.SelectedIndex == 0,
TermId = termId
};
db.CourseRequests.Add(art2);
}
}
if (student.CourseRequestComments.Where(crn => crn.TermId == termId).Count() > 0)
{
CourseRequestComment crn = student.CourseRequestComments.Where(c => c.TermId == termId).Single();
crn.Notes = NotesInput.Text;
}
else
{
int crnid = db.CourseRequestComments.Count() > 0?db.CourseRequestComments.OrderBy(c => c.id).ToList().Last().id + 1:0;
CourseRequestComment crn = new CourseRequestComment()
{
id = crnid,
Notes = NotesInput.Text,
StudentId = SelectedStudentId,
TermId = termId
};
db.CourseRequestComments.Add(crn);
}
db.SaveChanges();
Response.Redirect("~/CourseRequestConfirmed.aspx");
}
}