public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
if (ModelState.IsValid)
{
var exists = (from e in _context.AcademicRecord where string.Compare(e.StudentId, academicRecord.StudentId) == 0 && string.Compare(e.CourseCode, academicRecord.CourseCode) == 0 select e).FirstOrDefault <AcademicRecord>();
if (exists == null)
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
else
{
ModelState.AddModelError("CourseCode", "The student has already had an academic record for this course");
}
}
var courses = (from a in _context.Course select new { Code = a.Code, Title = a.Code + " - " + a.Title }).ToList();
ViewData["CourseCode"] = new SelectList(courses, "Code", "Title");
var students = (from b in _context.Student select new { Id = b.Id, Name = b.Id + " - " + b.Name }).ToList();
ViewData["StudentId"] = new SelectList(students, "Id", "Name");
return(View(academicRecord));
}
public async Task <IActionResult> Edit([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
if (ModelState.IsValid)
{
try
{
_context.Update(academicRecord);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AcademicRecordExists(academicRecord.StudentId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["CourseCode"] = new SelectList(_context.Course, "Code", "Code", academicRecord.CourseCode);
ViewData["StudentId"] = new SelectList(_context.Student, "Id", "Id", academicRecord.StudentId);
return(View(academicRecord));
}
protected void btnAddtoCourseRecord(object sender, EventArgs e)
{
//put inputs into vars
string sNumber = txtStudentID.Text;
string sName = txtStudentName.Text;
int sGrade = int.Parse(txtGrade.Text);
//attach courses sesssion to courses list and selectedCourse to index of dropdown
List <Course> courses = (List <Course>)Session["courses"];
Course selectedCourse = courses[dropdownCourseList.SelectedIndex - 1];
//create new student object with inputs and new academicrecord object with selected course and student objects
Student student = new Student(sNumber, sName);
AcademicRecord newRecord = new AcademicRecord(selectedCourse, student);
//add grade to record object
newRecord.Grade = sGrade;
//make records list var (no list yet)
List <AcademicRecord> records;
if (Session["records"] != null)
{
//if records session exists, attach it to records list and add new Record, otherwise make new list
records = (List <AcademicRecord>)Session["records"];
records.Add(newRecord);
}
else
{
records = new List <AcademicRecord>();
records.Add(newRecord);
}
//make list accessible by content page
List <AcademicRecord> visibleList = new List <AcademicRecord>();
//add the students to the new list
foreach (AcademicRecord r in records)
{
if (r.Course == selectedCourse)
{
visibleList.Add(r);
}
}
//The following line of code was copied from Brenna Arbour
visibleList = visibleList.OrderBy(x => x.Student.Name.Split(' ').Last()).ThenBy(x => x.Student.Name.Split(' ').First()).ToList();
//update records sesssion and selectedCourse
Session["records"] = records;
Session["selectedcourse"] = selectedCourse;
//display students using the new list
foreach (AcademicRecord r in visibleList)
{
DisplayStudentsTable(r);
}
}
public async Task <IActionResult> Edit(string studentId, string courseCode, [Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
if (studentId != academicRecord.StudentId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(academicRecord);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AcademicRecordExists(academicRecord.StudentId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
// Pass student name and course title to view
populateEditViewData(studentId, courseCode);
return(View(academicRecord));
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
var existing = _context.AcademicRecord.Where(a => a.CourseCode.Equals(academicRecord.CourseCode) && a.StudentId.Equals(academicRecord.StudentId)).FirstOrDefault();
ViewData["Error"] = "";
if (existing != null)
{
ViewData["Error"] = "The student has already had this academic record";
}
else
{
if (ModelState.IsValid)
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
//ViewData["CourseCode"] = new SelectList(_context.Course, "Code", "Code", academicRecord.CourseCode);
//ViewData["StudentId"] = new SelectList(_context.Student, "Id", "Id", academicRecord.StudentId);
ViewData["CourseCode"] = new SelectList(_context.Course.Select(c => new { Code = c.Code, Course = c.Code + " - " + c.Title }), "Code", "Course");
ViewData["StudentId"] = new SelectList(_context.Student.Select(s => new { Id = s.Id, Student = s.Id + " - " + s.Name }), "Id", "Student");
return(View(academicRecord));
}
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 btnAddStudent_OnClick(object sender, EventArgs e)
{
using (var studentRecords = new StudentRecordEntities())
{
Course course = (from a in studentRecords.Courses where a.Code == courseList.SelectedValue select a).FirstOrDefault();
List <AcademicRecord> records = (from b in course.AcademicRecords where b.StudentId == number.Text select b).ToList();
if (records.Count > 0)
{
numberError.Text = "The system already has record of this student for the selected course";
ShowStudent(course);
}
else
{
Student student = (from c in studentRecords.Students where c.Id == number.Text select c).FirstOrDefault();
if (student == null)
{
student = new Student();
student.Id = number.Text;
student.Name = name.Text;
studentRecords.Students.Add(student);
}
AcademicRecord academic = new AcademicRecord();
academic.CourseCode = course.Code;
academic.Grade = int.Parse(grade.Text);
academic.Student = student;
course.AcademicRecords.Add(academic);
studentRecords.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
}
}
protected void btnAddstudentRecord_Click(object sender, EventArgs e)
{
//Initializing variables
string sName = studentName.Text;
string sNumber = studentNumber.Text;
int sGrade = int.Parse(grade.Text);
//Retrieving session for added Courses
List <Course> addedCourses = (List <Course>)Session["addedCourses"];
//Retrieving session for Academic Records
List <AcademicRecord> records = (List <AcademicRecord>)Session["records"];
AcademicRecord record = null;
//getting course object from course selection
Course selectedCourse = addedCourses[courseSelection.SelectedIndex - 1];
if (courseSelection.SelectedValue == selectedCourse.ToString())
{
//Initializing selected course object
Course course = new Course(selectedCourse.CourseNumber, selectedCourse.CourseName);
//Initializing student object
Student student = new Student(sNumber, sName);
//Initializing Academic Record object
record = new AcademicRecord(course, student);
//Getting grade
record.Grade = sGrade;
//adding academic record object into a session list
records.Add(record);
//Displaying Table of added students
foreach (AcademicRecord r in records)
{
if (courseSelection.SelectedValue == r.Course.ToString())
{
TableCell c1 = new TableCell();
c1.Text = string.Concat(r.Student.Id);
TableCell c2 = new TableCell();
c2.Text = string.Concat(r.Student.Name);
TableCell c3 = new TableCell();
c3.Text = string.Concat(r.Grade);
TableRow row = new TableRow();
row.Controls.Add(c1);
row.Controls.Add(c2);
row.Controls.Add(c3);
tblStudents.Controls.Add(row);
}
}
}
// Clearing text inputs
studentName.Text = "";
studentNumber.Text = "";
grade.Text = "";
}
public ActionResult DeleteAcademicPlanForSubjectId(int subjectId, int studentId, int semesterId)
{
AcademicRecord academicRecord = db.AcademicPlan.FirstOrDefault(p => p.SubjectId == subjectId && p.StudentId == studentId && p.SemesterId == semesterId);
db.AcademicPlan.Remove(academicRecord);
db.SaveChanges();
return(RedirectToAction("AcademicPlanForSubjectId", new { id = subjectId }));
}
public ActionResult CreateAcademicPlanForSubjectId(AcademicRecord academicRecord)
{
//try
//{
db.AcademicPlan.Add(academicRecord);
db.SaveChanges();
return(RedirectToAction("AcademicPlanForSubjectId", new { id = academicRecord.SubjectId }));
//}
//catch
//{
// return RedirectToAction("Error");
//}
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
if (ModelState.IsValid)
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CourseCode"] = new SelectList(_context.Course, "Code", "Code", academicRecord.CourseCode);
ViewData["StudentId"] = new SelectList(_context.Student, "Id", "Id", academicRecord.StudentId);
return(View(academicRecord));
}
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 btnAddStudent_OnClick(object sender, EventArgs e)
{
List <Course> courses = Session["courses"] as List <Course>;
Course course = courses[courseList.SelectedIndex];
Student student = new Student(number.Text, name.Text);
AcademicRecord academicRecord = new AcademicRecord(course, student);
academicRecord.Grade = Int32.Parse(grade.Text);
course.AcademicRecords.Add(academicRecord);
course.AcademicRecords.OrderBy(s => s.Student.Name.Split(' ')[1]).ThenBy(s => s.Student.Name.Split(' ')[0]).ToList();
if (courses == null || courses.Count == 0)
{
TableRow errorRow = new TableRow();
TableCell errorCell = new TableCell();
errorCell.Text = "No students in system yet";
errorCell.ForeColor = System.Drawing.Color.Red;
errorCell.ColumnSpan = 4;
errorCell.HorizontalAlign = HorizontalAlign.Center;
errorRow.Cells.Add(errorCell);
Table.Rows.Add(errorRow);
Table.Visible = true;
}
foreach (var record in course.AcademicRecords)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();;
cell.Text = record.Student.Id;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = record.Student.Name;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = record.Grade.ToString();
row.Cells.Add(cell);
Table.Rows.Add(row);
Table.Visible = true;
}
Table.Visible = true;
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
var existing = _context.AcademicRecord.Where(a => a.CourseCode.Equals(academicRecord.CourseCode) && a.StudentId.Equals(academicRecord.StudentId)).FirstOrDefault();
ViewData["Error"] = "";
if (existing != null)
{
ViewData["Error"] = "The student already has an academic record for the course.";
}
else
{
if (ModelState.IsValid)
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
List <object> courses = new List <object>();
foreach (var course in _context.Course)
{
courses.Add(new
{
Code = course.Code,
Title = course.Code + " - " + course.Title
});
}
ViewData["CourseCode"] = new SelectList(courses, "Code", "Title");
List <object> students = new List <object>();
foreach (var student in _context.Student)
{
students.Add(new
{
Id = student.Id,
Name = student.Id + " - " + student.Name
});
}
ViewData["StudentId"] = new SelectList(students, "Id", "Name");
return(View(academicRecord));
}
protected void btnAddNewStudent_Click(object sender, EventArgs e)
{
string selectedCourseCode = Session["selectedCourseCode"] as string;
if (selectedCourseCode != null && selectedCourseCode != "-1")
{
using (StudentRecordEntities entityContext = new StudentRecordEntities())
{
Course selectedCourse = (from c in entityContext.Courses where c.Code == selectedCourseCode select c).FirstOrDefault <Course>();
//might need .ToList() or list type after FirstorDefault
string idInput = txtStudentID.Text.Trim().ToUpper();
Student newStudent = (from s in entityContext.Students
where s.Id == idInput
select s).FirstOrDefault <Student>();
if (newStudent == null)
{
newStudent = new Student();
newStudent.Name = txtStudentName.Text;
newStudent.Id = txtStudentID.Text;
entityContext.Students.Add(newStudent);
AcademicRecord newRecord = new AcademicRecord();
newRecord.Student = newStudent;
newRecord.Course = selectedCourse;
newRecord.Grade = int.Parse(txtGrade.Text);
entityContext.AcademicRecords.Add(newRecord);
entityContext.SaveChanges();
Response.Redirect("AddStudent.aspx");
}
else
{
AcademicRecord ar = (from a in entityContext.AcademicRecords
where a.Course.Code == selectedCourse.Code && a.StudentId == newStudent.Id
select a).FirstOrDefault <AcademicRecord>();
//check if the system already has a record of this student/ course?
if (ar != null)
{
txtStudentIdExists.Text = "The system already has record of this student in this class";
}
}
}
}
}
protected void ShowStudentRecords()
{
var courses = GetCourses();
for (int i = studentTable.Rows.Count - 1; i > 0; i--)
{
studentTable.Rows.RemoveAt(i);
}
foreach (Course course in courses)
{
string format = course.Code + " " + course.Title;
if (CourseList.SelectedValue == format)
{
using (StudentRecordEntities1 entityContext = new StudentRecordEntities1())
{
AcademicRecord records = (from c in entityContext.AcademicRecords
where c.CourseCode == course.Code
select c).FirstOrDefault <AcademicRecord>();
if (records != null)
{
foreach (AcademicRecord record in records.Course.AcademicRecords)
{
TableRow studentRow = new TableRow();
TableCell idCell = new TableCell();
TableCell nameCell = new TableCell();
TableCell gradeCell = new TableCell();
TableCell cell = new TableCell();
idCell.Text = record.Student.Id;
nameCell.Text = record.Student.Name;
gradeCell.Text = record.Grade.ToString();
cell.Text = "<a href='AddStudent.aspx?action=edit&id=" + record.Student.Id + "&course=" + course.Code + "'/>Change Grade</a>"
+ " | <a class='deleteCourse' href='AddStudent.aspx?action=delete&id=" + record.Student.Id + "&course=" + course.Code + "'/>Delete</a>";
studentRow.Cells.Add(idCell);
studentRow.Cells.Add(nameCell);
studentRow.Cells.Add(gradeCell);
studentRow.Cells.Add(cell);
studentTable.Rows.Add(studentRow);
}
}
}
}
}
}
private void DisplayStudentsTable(AcademicRecord r)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = r.Student.Id;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = r.Student.Name;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = r.Grade.ToString();
row.Cells.Add(cell);
studentRecordsTable.Rows.Add(row);
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
if (ModelState.IsValid)
{
if (!AcademicRecordExists(academicRecord.StudentId, academicRecord.CourseCode))
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
else
{
ViewBag.ErrorStyle = "color:red; display:block";
}
}
SetCourseAndStudentViewData();
return(View(academicRecord));
}
protected void addBtn_Click(object sender, EventArgs e)
{
//creating a new student
string studentNumber = studentNumberTxt.Text;
string studentName = studentNameTxt.Text;
AlgonquinCollege.Registration.Entities.Student newStudent = new AlgonquinCollege.Registration.Entities.Student(studentNumber, studentName);
//create a new course
string index = (string)Session["selectedCourse"];
string selectedCourseName = DropDownList1.SelectedValue.ToString();
Course newCourse = new Course(index, selectedCourseName);
//creating a list of academic records
List <AcademicRecord> academicRecordList = new List <AcademicRecord>();
AcademicRecord newAcademicRecord = new AcademicRecord(newCourse, newStudent);
newAcademicRecord.Grade = int.Parse(gradeTxt.Text);
//adding course to list and session
if (Session["academicRecordListSession"] == null)
{
academicRecordList.Add(newAcademicRecord);
Session["academicRecordListSession"] = academicRecordList;
}
else
{
academicRecordList = (List <AcademicRecord>)Session["academicRecordListSession"];
academicRecordList.Add(newAcademicRecord);
Session["academicRecordListSession"] = academicRecordList;
}
academicRecordList.Sort((p1, p2) => string.Compare(p1.Student.Name, p2.Student.Name, true));
//displaying table
ShowStudentRecords();
studentNumberTxt.Text = "";
studentNameTxt.Text = "";
gradeTxt.Text = "";
}
protected void btnAdd_Click(object sender, EventArgs e)
{
using (var entityContext = new StudentRecordEntities())
{
if (Page.IsValid)
{
List <Student> students = entityContext.Students.ToList <Student>();
List <AcademicRecord> academRecords = entityContext.AcademicRecords.ToList <AcademicRecord>();
bool stExist = false;
foreach (Student student in students)
{
if (student.Id == stdId.Text)
{
AcademicRecord academRecord = new AcademicRecord();
academRecord.CourseCode = Session["selectedcourseCode"].ToString();
academRecord.Student = student;
academRecord.Grade = Int32.Parse(stdGrade.Text);
entityContext.AcademicRecords.Add(academRecord);
entityContext.SaveChanges();
stExist = true;
break;
}
}
if (!stExist)
{
Student std = new Student();
std.Id = stdId.Text;
std.Name = stdName.Text;
entityContext.Students.Add(std);
AcademicRecord academRecord = new AcademicRecord();
academRecord.CourseCode = Session["selectedcourseCode"].ToString();
academRecord.Student = std;
academRecord.Grade = Int32.Parse(stdGrade.Text);
entityContext.AcademicRecords.Add(academRecord);
entityContext.SaveChanges();
}
}
}
DisplayStdn();
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
// Check for duplicate records:
if ((from a in _context.AcademicRecord
where a.CourseCode.Equals(academicRecord.CourseCode) &&
a.StudentId.Equals(academicRecord.StudentId)
select a).FirstOrDefault() != null)
{ // Duplicate record exists
ViewData["Error"] = "Student already has an academic record for the course.";
}
else if (ModelState.IsValid)
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
// Include course titles and student names in drop down lists
populateCreateViewData();
return(View(academicRecord));
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
var selectedAccount = (from account in _context.AcademicRecord where account.StudentId == academicRecord.StudentId && account.CourseCode == academicRecord.CourseCode select account).FirstOrDefault();
if (selectedAccount != null)
{
ModelState.AddModelError("", "The Student Already Exists Within The System.");
}
else
{
if (ModelState.IsValid)
{
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
List <object> courses = new List <object>();
foreach (Course course in _context.Course)
{
courses.Add(new { Code = course.Code, Title = course.Code + "-" + course.Title });
}
List <object> students = new List <object>();
foreach (Student student in _context.Student)
{
students.Add(new { Id = student.Id, Name = student.Id + "-" + student.Name });
}
ViewData["CourseCode"] = new SelectList(courses, "Code", "Title", academicRecord.CourseCode);
ViewData["StudentId"] = new SelectList(students, "Id", "Name", academicRecord.StudentId);
return(View(academicRecord));
}
public async Task <IActionResult> Create([Bind("CourseCode,StudentId,Grade")] AcademicRecord academicRecord)
{
if (ModelState.IsValid)
{
//query if student ID + courseCode already exists
var academicExist = (from acExist in _context.AcademicRecord
where string.Compare(acExist.StudentId, academicRecord.StudentId) == 0 &&
string.Compare(acExist.CourseCode, academicRecord.CourseCode) == 0
select acExist).FirstOrDefault <AcademicRecord>();
//if academic record does not exist yet:
if (academicExist == null)
{
//adding an academic record
_context.Add(academicRecord);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
else
{
//display error:
ModelState.AddModelError("", "The academic record of this course already exists!");
}
}
//display updated view
var courses = (from c in _context.Course select new { Code = c.Code, Title = c.Code + " - " + c.Title }).ToList();
ViewData["CourseCode"] = new SelectList(courses, "Code", "Title");
var students = (from st in _context.Student select new { Id = st.Id, Name = st.Id + " - " + st.Name }).ToList();
ViewData["StudentId"] = new SelectList(students, "Id", "Name");
return(View());
}
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");
}
}
}
}
}
public int Add(StudentProfileViewModel model,
List <AcademicRecordsViewModel> records,
GuardianViewModel gardian,
InitialPaymentDetailViewModel officeFrom, int[] OriginalDocumentId)
{
Student std = new Student();
std.Id = Guid.NewGuid();
std.StdNameBangla = model.StdNameBangla;
std.StdNameEnglish = model.StdNameEnglish;
std.StdFatherNameBangla = model.StdFatherNameBangla;
std.StdFatherNameEnglish = model.StdFatherNameEnglish;
std.StdMotherNameBangla = model.StdMotherNameBangla;
std.StdMotherNameEnglish = model.StdMotherNameEnglish;
std.AdmissionDate = DateTime.Now;
std.DateOfBirth = model.DateOfBirth;
std.EntryDate = DateTime.Now;
std.FormNo = _context.Students.Select(s => s.FormNo).Max() + 1;
std.Gender = model.Gender;
std.IsActive = true;
std.IsSuspended = model.IsSuspended;
std.Nationality = model.Nationality;
std.PermanentAddress = model.PermanentAddress;
std.Phone = model.Phone;
std.Email = model.Email;
std.Picture = model.Picture;
std.PresentAddress = model.PresentAddress;
std.Religion = model.Religion;
std.SuspendedDesc = model.SuspendedDesc;
std.RegistrationNo = officeFrom.RegistrationNo;
std.ExamRollNo = officeFrom.ExamRollNo;
std.CourseId = model.CourseId;
std.AcademicSessionId = model.AcademicSessionId;
std.SemesterId = model.SemesterId;
_context.Students.Add(std);
foreach (var item in records)
{
if (item.ExamId > 0)
{
AcademicRecord r = new AcademicRecord();
r.ExamId = item.ExamId;
r.GroupId = item.GroupId;
r.BoardId = item.BoardId;
r.YearOfPassing = item.YearOfPassing;
r.RollOfExam = item.RollOfExam;
r.Grade = item.Grade;
r.StudentId = std.Id;
_context.AcademicRecords.Add(r);
}
}
Guardian gar = new Guardian();
gar.Id = Guid.NewGuid();
gar.Name = gardian.Name;
gar.Occupation = gardian.Occupation;
gar.Relation = gardian.Relation;
gar.Phone = gardian.Phone;
gar.Address = gardian.Address;
gar.StudentId = std.Id;
_context.Guardians.Add(gar);
InitialPaymentDetail ip = new InitialPaymentDetail();
ip.CourseFee = officeFrom.CourseFee;
//ip.InitialPayment = officeFrom.InitialPayment;
ip.CourseId = model.CourseId;
//ip.PaymentScheduleId = officeFrom.PaymentScheduleId;
ip.StudentId = std.Id;
_context.InitialPaymentDetails.Add(ip);
foreach (var d in OriginalDocumentId)
{
StudentOriginalDocument stdDOc = new StudentOriginalDocument();
stdDOc.StudentId = std.Id;
stdDOc.OriginalDocumentId = d;
_context.StudentOriginalDocuments.Add(stdDOc);
}
StudentSemesterMapping sm = new StudentSemesterMapping();
sm.StudentId = std.Id;
sm.SemesterId = model.SemesterId;
sm.IsActive = true;
_context.StudentSemesterMappings.Add(sm);
try
{
_context.SaveChanges();
}
catch (DbEntityValidationException e)
{
Console.WriteLine(e);
}
return(0);
}
protected void addBtn_Click(object sender, EventArgs e)
{
using (StudentRecordEntities entityContext = new StudentRecordEntities())
{
//check if student number exists
var student = (from st in entityContext.Students
where st.Id == studentNumberTxt.Text
select st).FirstOrDefault <Student>();
if (student == null) //if student number is not found
{
//creating a new student and saving into database
Student student1 = new Student();
{ student1.Id = studentNumberTxt.Text; student1.Name = studentNameTxt.Text; };
entityContext.Students.Add(student1);
entityContext.SaveChanges();
//retrieving the course info from dropdown list
var course = (from c in entityContext.Courses
where c.Code == DropDownList1.SelectedValue.ToString()
select c).FirstOrDefault <Course>();
//creating academic records
AcademicRecord academicRecord = new AcademicRecord();
{ academicRecord.Course = course; academicRecord.Student = student1; academicRecord.Grade = int.Parse(gradeTxt.Text); };
//adding academic record to database:
entityContext.AcademicRecords.Add(academicRecord);
entityContext.SaveChanges();
//clear form fields and redirecting to home page:
studentNumberTxt.Text = "";
studentNameTxt.Text = "";
gradeTxt.Text = "";
Response.Redirect("AddStudent.aspx");
}
else //if student number already exists
{
if (Request.Params["action"] == "edit") //if user wants to change grade (edit)
{
List <Student> stList = entityContext.Students.ToList <Student>();
student.Id = studentNumberTxt.Text;
var academicRecord = (from ac in entityContext.AcademicRecords
where (ac.StudentId == student.Id &&
ac.CourseCode == DropDownList1.SelectedValue)
select ac).FirstOrDefault <AcademicRecord>();
academicRecord.Grade = int.Parse(gradeTxt.Text);
entityContext.SaveChanges();
studentNumberTxt.Text = "";
studentNumberTxt.Enabled = true;
studentNameTxt.Text = "";
studentNameTxt.Enabled = true;
gradeTxt.Text = "";
gradeTxt.Enabled = true;
DropDownList1.Enabled = true;
Response.Redirect("AddStudent.aspx");
}
else //if it's not editing
{
//checking if there is an academic record for student + course
var academicRecord = (from ac in entityContext.AcademicRecords
where ac.StudentId == studentNumberTxt.Text && ac.Course.Code == DropDownList1.SelectedValue.ToString()
select ac).FirstOrDefault <AcademicRecord>();
if (academicRecord == null) //if academicRecord for student + course is not found
{
//creating a new student
Student student1 = new Student();
{ student1.Id = studentNumberTxt.Text; student1.Name = studentNameTxt.Text; };
//retrieving the course info from dropdown list
var course = (from c in entityContext.Courses
where c.Code == DropDownList1.SelectedValue.ToString()
select c).FirstOrDefault <Course>();
//creating academic records
AcademicRecord academicRecord1 = new AcademicRecord();
{ academicRecord1.CourseCode = course.Code; academicRecord1.StudentId = student1.Id; academicRecord1.Grade = int.Parse(gradeTxt.Text); };
//adding academic record to database:
entityContext.AcademicRecords.Add(academicRecord1);
entityContext.SaveChanges();
//clear form fields:
studentNumberTxt.Text = "";
studentNameTxt.Text = "";
gradeTxt.Text = "";
Response.Redirect("AddStudent.aspx");
}
else //if there is an academic record with student number + course (display error)
{
spanNumber.InnerText = "The system already has records of this student for the selected course!";
//clear form fields:
studentNumberTxt.Text = "";
studentNameTxt.Text = "";
gradeTxt.Text = "";
}
}
}
}
}
protected void ButtonAddToCourse_Click(object sender, EventArgs e)
{
if (DropDownListCourses.SelectedValue != "-1")
{
string selectedCourseID = DropDownListCourses.SelectedValue;
string studentNumber = TextBoxStudentNumber.Text;
string studentName = TextBoxStudentName.Text;
int studentGrade = Convert.ToInt32(TextBoxGrade.Text);
using (StudentRecordEntities entityContext = new StudentRecordEntities())
{
var course = (from c in entityContext.Courses
where c.Code == selectedCourseID
select c).FirstOrDefault <Course>();
Student student = new Student();
AcademicRecord academicRecord = new AcademicRecord();
student.Id = studentNumber;
student.Name = studentName;
academicRecord.Grade = studentGrade;
academicRecord.StudentId = studentNumber;
academicRecord.CourseCode = course.Code;
// academicRecord.Course = course;
var CheckStudent = (from s in entityContext.Students
where s.Id == studentNumber
select s).FirstOrDefault <Student>();
if (CheckStudent != null)
{
LabelErrorMessage.Text = "Student with this ID already exist in Student table";
}
else
{
academicRecord.Course = course;
academicRecord.Student = student;
entityContext.Students.Add(student);
entityContext.SaveChanges();
LabelErrorMessage.Text = "";
}
course.AcademicRecords.Add(academicRecord);//
var academicRecrd = (from a in entityContext.AcademicRecords
where a.StudentId == studentNumber && a.CourseCode == course.Code
select a).FirstOrDefault <AcademicRecord>();
if (academicRecrd != null)
{
LabelErrorMessage.Text = "The system already has a record of this student for the selected course";
}
else
{
entityContext.AcademicRecords.Add(academicRecord);
entityContext.SaveChanges();
LabelErrorMessage.Text = "";
}
using (StudentRecordEntities studentsCourse = new StudentRecordEntities())
{
var studentsInSelectedCourse = (from a in entityContext.AcademicRecords
where a.CourseCode == selectedCourseID
select a).ToList <AcademicRecord>();
showCourseInfo(studentsInSelectedCourse);
}
}
}
}
protected void addBtn_Click(object sender, EventArgs e)
{
//creating a new student
string studentNumber = studentNumberTxt.Text;
string studentName = studentNameTxt.Text;
AlgonquinCollege.Registration.Entities.Student newStudent = new AlgonquinCollege.Registration.Entities.Student(studentNumber, studentName);
//create a new course
string index = (string)Session["selectedCourse"];
string selectedCourseName = DropDownList1.SelectedValue.ToString();
Course newCourse = new Course(index, selectedCourseName);
//creating a list of academic records
List <AcademicRecord> academicRecordList = new List <AcademicRecord>();
AcademicRecord newAcademicRecord = new AcademicRecord(newCourse, newStudent);
newAcademicRecord.Grade = int.Parse(gradeTxt.Text);
//adding course to list and session
if (Session["academicRecordListSession"] == null)
{
academicRecordList.Add(newAcademicRecord);
Session["academicRecordListSession"] = academicRecordList;
}
else
{
academicRecordList = (List <AcademicRecord>)Session["academicRecordListSession"];
academicRecordList.Add(newAcademicRecord);
Session["academicRecordListSession"] = academicRecordList;
}
//sorting list by name
StudentCompareByName myComp = new StudentCompareByName();
academicRecordList.Sort(myComp);
//displaying table
foreach (AcademicRecord item in academicRecordList)
{
if (item.Course.CourseName == DropDownList1.Text)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = item.Student.Id.ToString();
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = item.Student.Name;
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = item.Grade.ToString();
row.Cells.Add(cell);
tableSort.Rows.Add(row);
}
}
studentNumberTxt.Text = "";
studentNameTxt.Text = "";
gradeTxt.Text = "";
}
