protected void btn_SubmitCourse_Click(object sender, EventArgs e)
{
string courseCode = txtCourseNumber.Text.ToUpper().Trim();
string action = Request.Params["action"];
using (StudentRecordEntities1 entity = new StudentRecordEntities1())
{
if (action == "edit")
{
string id = Request.Params["id"];
Course course = (from c in entity.Courses
where c.Code == id
select c).FirstOrDefault <Course>();
if (course != null)
{
course.Title = txtCourseName.Text;
entity.Entry(course).State = System.Data.Entity.EntityState.Modified;
entity.SaveChanges();
Response.Redirect("AddCourse.aspx");
}
}
else
{
Course course = (from c in entity.Courses
where c.Code == courseCode
select c).FirstOrDefault <Course>();
if (course != null)
{
if (course.Code == courseCode)
{
err.Text = "Course with that code already exists!";
err.Visible = true;
}
}
else
{
Course newCourse = new Course();
newCourse.Code = courseCode;
newCourse.Title = txtCourseName.Text;
entity.Courses.Add(newCourse);
entity.SaveChanges();
err.Visible = false;
Response.Redirect("AddCourse.aspx");
}
}
}
}
protected void ActionHandler(string action)
{
string courseId = Request.Params["course"] as String;
string studentId = Request.Params["id"] as String;
using (StudentRecordEntities1 entityContext = new StudentRecordEntities1())
{
Course course = (from c in entityContext.Courses
where c.Code == courseId
select c).FirstOrDefault <Course>();
if (action == "edit")
{
AcademicRecord record = (from c in course.AcademicRecords
where c.StudentId == studentId
select c).FirstOrDefault <AcademicRecord>();
CourseList.SelectedValue = course.Code + " " + course.Title;
txtStudentName.Text = record.Student.Name;
txtStudentNum.Text = record.Student.Id;
txtStudentName.ReadOnly = true;
txtStudentNum.ReadOnly = true;
CourseList.Enabled = false;
}
else if (action == "delete")
{
AcademicRecord record = (from c in course.AcademicRecords
where c.StudentId == studentId
select c).FirstOrDefault <AcademicRecord>();
course.AcademicRecords.Remove(record);
entityContext.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
}
}
protected void CourseInformation(string action, string id)
{
using (StudentRecordEntities1 entityContext = new StudentRecordEntities1())
{
Course course = (from c in entityContext.Courses
where c.Code == id
select c).FirstOrDefault <Course>();
if (course != null)
{
if (action == "delete")
{
for (int i = course.AcademicRecords.Count() - 1; i >= 0; i--)
{
var ar = course.AcademicRecords.ElementAt <AcademicRecord>(i);
course.AcademicRecords.Remove(ar);
}
entityContext.Courses.Remove(course);
entityContext.SaveChanges();
Response.Redirect("AddCourse.aspx");
}
else if (action == "edit")
{
txtCourseNumber.Text = course.Code;
txtCourseNumber.ReadOnly = true;
}
}
}
}
public void btnSubmit_Click(object sender, EventArgs e)
{
Page.Validate();
if (Session["selectedcourse"] != null)
{
if (Page.IsValid)
{
using (var context = new StudentRecordEntities1())
{
Course course = context.Courses.Where(c => c.Code == drpCourseSelection.SelectedValue).FirstOrDefault();
if (course != null)
{
List <AcademicRecord> records = course.AcademicRecords.Where(r => r.StudentId == studentID.Text).ToList();
if (records.Count > 0)
{
studentExistsError.Text = "The system already has a record of this student for the selected course";
orderList();
}
else
{
Student s = context.Students.Where(st => st.Id == studentID.Text).FirstOrDefault();
if (s == null)
{
s = new Student();
s.Id = studentID.Text;
s.Name = studentName.Text;
context.Students.Add(s);
}
AcademicRecord a = new AcademicRecord();
a.CourseCode = course.Code;
a.Grade = int.Parse(studentGrade.Text);
a.Student = s;
course.AcademicRecords.Add(a);
context.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
}
}
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string name = txtEmployeeName.Text;
string userName = txtUserName.Text.ToLower();
string password = txtPassword.Text;
using (StudentRecordEntities1 entityContext = new StudentRecordEntities1())
{
Employee employee = (from em in entityContext.Employees
where em.UserName == userName
select em).FirstOrDefault <Employee>();
if (employee == null)
{
Employee em = new Employee();
em.UserName = userName;
em.Name = name;
em.Password = password;
List <ListItem> selected = new List <ListItem>();
foreach (ListItem item in checkList.Items)
{
if (item.Selected)
{
Role r = (from rm in entityContext.Roles
where rm.Role1.ToLower() == item.Value.ToLower()
select rm).FirstOrDefault <Role>();
if (r != null)
{
r.Employees.Add(em);
}
}
}
entityContext.SaveChanges();
Response.Redirect("AddEmployee.aspx");
}
else
{
errMsg.Text = "Our system has indicated that username is already in use, please choose another";
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
Course course = new Course();
course.Code = courseNumber.Text;
course.Title = courseName.Text;
using (var context = new StudentRecordEntities1())
{
if (context.Courses.Where(c => c.Code == courseNumber.Text).Count() > 0)
{
labelCourseNumberError.Text = "Course with this code already exists.";
return;
}
else
{
context.Courses.Add(course);
context.SaveChanges();
Response.Redirect("AddCourse.aspx");
}
}
}
protected void btn_AddToCourse_Click(object sender, EventArgs e)
{
string action = Request.Params["action"];
ActionHandler(action);
String studentName = txtStudentName.Text.Trim();
String studentID = txtStudentNum.Text.Trim();
String[] courseString = CourseList.SelectedValue.Split();
string courseCode = courseString[0];
using (StudentRecordEntities1 entityContext = new StudentRecordEntities1())
{
// TODO: Add edit actions
if (action == "edit")
{
string studentId = Request.Params["id"] as String;
string courseId = Request.Params["course"] as String;
Course editCourse = (from c in entityContext.Courses
where c.Code == courseId
select c).FirstOrDefault <Course>();
if (editCourse != null)
{
AcademicRecord record = (from c in editCourse.AcademicRecords
where c.StudentId == studentId
select c).FirstOrDefault <AcademicRecord>();
record.Grade = int.Parse(txtStudentGrade.Text);
entityContext.Entry(record).State = System.Data.Entity.EntityState.Modified;
entityContext.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
}
else
{
Course course = (from c in entityContext.Courses
where c.Code == courseCode.Trim()
select c).FirstOrDefault <Course>();
string format = course.Code + " " + course.Title;
if (CourseList.SelectedValue == format)
{
int studentGrade = int.Parse(txtStudentGrade.Text.Trim());
Student student = (from c in entityContext.Students
where c.Id == studentID
select c).FirstOrDefault <Student>();
if (student != null)
{
AcademicRecord record = (from c in student.AcademicRecords
where c.CourseCode == course.Code
select c).FirstOrDefault <AcademicRecord>();
if (course.AcademicRecords.Contains(record))
{
errMsg.Text = "The system already has a record of this student for the selected course";
errMsg.Visible = true;
}
else
{
AcademicRecord newRecord = new AcademicRecord();
newRecord.Grade = studentGrade;
newRecord.Student = student;
newRecord.Course = course;
course.AcademicRecords.Add(newRecord);
entityContext.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
}
else
{
Student newStudent = new Student();
newStudent.Name = studentName;
newStudent.Id = studentID;
AcademicRecord newRecord = new AcademicRecord();
newRecord.Grade = studentGrade;
newRecord.Student = newStudent;
newRecord.Course = course;
course.AcademicRecords.Add(newRecord);
entityContext.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
}
}
}
}