private void RefreshTable() { dataGridView1.Rows.Clear(); dataGridView1.Refresh(); List <Classes> classList = new List <Classes>(); classList = ClassesDB.ClassLoad(); dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "Class ID"; dataGridView1.Columns[1].Name = "Class Title"; dataGridView1.Columns[2].Name = "Class Track"; foreach (Classes classes in classList) { string[] row; row = new string[] { classes.ClassID.ToString(), classes.ClassTitle, classes.ClassTrack }; dataGridView1.Rows.Add(row); } int id = 0; foreach (Classes classes in classList) { if (classes.ClassID >= id) { id = classes.ClassID + 1; } } classIDLabel1.Text = id.ToString(); }
private void btnDelete_Click(object sender, EventArgs e) { if (lblSelected.Text == "") { MessageBox.Show("Please select a class to delete"); } else { Classes newClasses = new Classes(); int classNum = Convert.ToInt32(lblSelected.Text); newClasses.ClassID = classNum; ClassesDB.ClassDelete(newClasses); List <Teacher> teacherList = TeacherDB.TeacherLoad(); foreach (Teacher teacher in teacherList) { foreach (int classid in teacher.ClassID) { if (classid == newClasses.ClassID) { teacher.ClassID.Remove(classid); TeacherDB.TeacherDelete(teacher); TeacherDB.TeacherSave(teacher); } } } RefreshTable(); } }
public ActionResult MailMerge() { List <Class> classes = ClassesDB.GetClasses(); ViewBag.Classes = classes; return(View()); }
private void btnDelete_Click(object sender, EventArgs e) { Teacher deleteTeacher = new Teacher(); deleteTeacher.TeacherID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); deleteTeacher.FirstName = dataGridView1.CurrentRow.Cells[1].Value.ToString(); deleteTeacher.LastName = dataGridView1.CurrentRow.Cells[2].Value.ToString(); //Need to check all classes and see if teacher has that class and delete them. List <Classes> ListClasses = ClassesDB.ClassLoad(); foreach (Classes classes in ListClasses) { foreach (int teacherid in classes.TeacherID) { if (deleteTeacher.TeacherID == teacherid) { classes.TeacherID.Remove(teacherid); ClassesDB.ClassDelete(classes); ClassesDB.ClassSave(classes); } } } TeacherDB.TeacherDelete(deleteTeacher); RefreshTable(); }
private void comboBox1_TextChanged(object sender, EventArgs e) { for (int i = 0; i < checkedListBox1.Items.Count; i++) { checkedListBox1.SetItemChecked(i, false); } List <Teacher> TeacherList = TeacherDB.TeacherLoad(); List <Classes> ClassList = ClassesDB.ClassLoad(); string[] teacherName = comboBox1.Text.Split(' '); Teacher teacher = TeacherDB.TeacherFind(Convert.ToInt32(teacherName[0])); for (int i = 0; i < checkedListBox1.Items.Count; i++) { string[] classid = checkedListBox1.Items[i].ToString().Split(' '); foreach (int id in teacher.ClassID) { if (Convert.ToInt32(classid[0]) == id) { checkedListBox1.SetItemChecked(i, true); } } } }
public ActionResult ClassRating() { List <Class> classes = ClassesDB.GetClasses(); ViewBag.Classes = classes; return(View()); }
private void btnDelete_Click(object sender, EventArgs e) { Student deleteStudent = new Student(); deleteStudent.StudentID = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString()); deleteStudent.FirstName = dataGridView1.CurrentRow.Cells[1].Value.ToString(); deleteStudent.LastName = dataGridView1.CurrentRow.Cells[2].Value.ToString(); //Need to check all classes and see if teacher has that class and delete them. List <Classes> ListClasses = ClassesDB.ClassLoad(); foreach (Classes classes in ListClasses) { if (classes.StudentID != null) { foreach (int studentid in classes.StudentID) { if (deleteStudent.StudentID == studentid) { classes.StudentID.Remove(studentid); ClassesDB.ClassDelete(classes); ClassesDB.ClassSave(classes); } } } } StudentDB.StudentDelete(deleteStudent); RefreshTable(); }
public ActionResult GetRating(int id) { List <PupilWithAvgMark> pupils = ClassesDB.GetClassRating(id); ViewData["ClassID"] = id; return(PartialView(pupils)); }
//Save a new class private void button3_Click(object sender, EventArgs e) { Classes newClass = new Classes(); List <int> teacherID = new List <int>() { 0, 0, 0, 0 }; newClass.ClassID = Convert.ToInt32(classIDLabel1.Text); newClass.ClassTitle = txtTitle.Text; newClass.Sections = 1; newClass.TeacherID = teacherID; if (comboBox1.Text == "") { newClass.ClassTrack = "A"; } else { newClass.ClassTrack = comboBox1.Text; } ClassesDB.ClassSave(newClass); RefreshTable(); }
private void EditTeacher_Load(object sender, EventArgs e) { dataGridView1.Rows.Clear(); dataGridView1.Refresh(); dataGridView1.ColumnCount = 3; dataGridView1.Columns[0].Name = "Class ID"; dataGridView1.Columns[1].Name = "Class Title"; dataGridView1.Columns[2].Name = "Class Track"; Teacher teacher = TeacherDB.TempLoad(); lblTeacherID.Text = teacher.TeacherID.ToString(); txtFirstName.Text = teacher.FirstName; txtLastName.Text = teacher.LastName; Teacher newTeacher = TeacherDB.TeacherFind(teacher.TeacherID); List <Classes> ClassList = new List <Classes>(); foreach (int classID in newTeacher.ClassID) { Classes newClass = ClassesDB.ClassFind(classID); string[] row = new string[] { newClass.ClassID.ToString(), newClass.ClassTitle, newClass.ClassTrack }; dataGridView1.Rows.Add(row); } }
public ActionResult ViewPupils() { List <PupilWithClass> p = PupilsDB.GetPupilsWithClass(); List <Class> classes = ClassesDB.GetClasses(); ViewBag.Classes = classes; return(View(p)); }
public ActionResult EditClassInformation(int action) { ClassWithManagment Class = ClassesDB.GetClassFullInf(action); List <TeacherShortInf> teachers = TeachersDB.GetTeachersShortInf(); ViewBag.Teachers = teachers; return(View(Class)); }
// Добавление нового ученика. public ActionResult AddPupilForm() { List <Class> classesList = ClassesDB.GetClasses(); SelectList classesSL = new SelectList(classesList, "Class_ID", "Class_Name"); ViewBag.Classes = classesSL; return(View()); }
public ActionResult ViewMarkInfo(int delete, int a = 0) { int pupilId = PupilsDB.GetPupilIdByMark(delete); PupilFullInformation p = PupilsDB.GetPupilsFullInformation(pupilId); int classID = ClassesDB.GetClassId(p.Class); MarksDB.DeleteMark(delete); return(RedirectToAction("ViewMarks", "Teacher", new { id = classID })); }
// Редактирование информации про ученика. public ActionResult EditPupilInformation(int action) { PupilFullInformation p = PupilsDB.GetPupilsFullInformation(action); List <Class> classesList = ClassesDB.GetClassesWithoutCurr(p.Class); SelectList classesSL = new SelectList(classesList, "Class_ID", "Class_Name"); ViewBag.Classes = classesSL; return(View(p)); }
public ActionResult ClassFullInf(int id) { ClassWithManagment Class = ClassesDB.GetClassFullInf(id); List <Pupil> pupils = PupilsDB.GetPupilsInClass(id); ViewBag.Pupils = pupils; ViewBag.ClassId = id; return(View(Class)); }
public ActionResult AddNewMark(Mark m, int res = 0) { MarksDB.AddMark(m.Pupil_ID, res, (int)m.TypeOfWork_ID, (int)m.PupilMark); PupilFullInformation pupil = PupilsDB.GetPupilsFullInformation(m.Pupil_ID); int classID = ClassesDB.GetClassId(pupil.Class); return(RedirectToAction("ViewMarks", "Teacher", new { id = classID })); }
private string CLR(int id) { string classString; Classes newClass = ClassesDB.ClassFind(id); classString = newClass.ClassID.ToString() + " " + newClass.ClassTitle + " " + newClass.ClassTrack; return(classString); }
public ActionResult GetRating(int action, int classID) { List <PupilWithAvgMark> pupils = ClassesDB.GetClassRating(classID); new ElectronicJournnal.Models.GenerateClassRatingReport().CreatePackage(@"E:\Uni\Course Project\ElectronicJournnal\ElectronicJournnal\Files\CurrentClassRatingReport.docx", pupils); string file_path = Server.MapPath("~/Files/CurrentClassRatingReport.docx");; string file_type = "application/docx"; string file_name = "Рейтинг " + ClassesDB.GetClassFullInf(classID).Class_Name + " класса.docx"; return(File(file_path, file_type, file_name)); }
public ActionResult ViewClasses(int action = 0, int delete = 0) { if (action != 0) { return(RedirectToAction("ClassFullInf", "Teacher", new { id = action })); } else { ClassesDB.DeleteClass(delete); return(RedirectToAction("ViewClasses", "Teacher")); } }
public ActionResult AddLessonForm() { List <Class> classes = ClassesDB.GetClasses(); ViewBag.Classes = classes; List <TeacherShortInf> teachers = TeachersDB.GetTeachersShortInf(); ViewBag.Teachers = teachers; List <Subject> subjects = SubjectsDB.GetSubjects(); ViewBag.Subjects = subjects; return(View()); }
public ActionResult EditLesson(int lessonID) { LessonFullInf lesson = LessonsDB.GetLessonFullInf(lessonID); List <Class> classes = ClassesDB.GetClasses(); ViewBag.Classes = classes; List <TeacherShortInf> teachers = TeachersDB.GetTeachersShortInf(); ViewBag.Teachers = teachers; List <Subject> subjects = SubjectsDB.GetSubjects(); ViewBag.Subjects = subjects; return(View(lesson)); }
private void AssignClasses_Load(object sender, EventArgs e) { List <Teacher> TeacherList = TeacherDB.TeacherLoad(); List <Classes> ClassList = ClassesDB.ClassLoad(); foreach (Classes classes in ClassList) { string className = classes.ClassID + " " + classes.ClassTitle + " " + classes.ClassTrack; checkedListBox1.Items.Add(className, false); } foreach (Teacher teacher in TeacherList) { comboBox1.Items.Add(teacher.TeacherID + " " + teacher.FirstName + " " + teacher.LastName); } }
// Фильтрация учеников. public ActionResult FilterPupils(int Class_ID, int to = 0, int from = 0) { StringBuilder expr = new StringBuilder(); expr.Append("SELECT Pupils.Pupil_ID, Pupils.Name, Pupils.Surname, Pupils.Patronymic, Classes.Class_Name FROM Pupils, Marks, Types_Of_Work, Classes WHERE Pupils.Pupil_ID = Marks.Pupil_ID AND Marks.TypeOfWork_ID = Types_Of_Work.TypeOfWork_ID AND Pupils.Class_ID = Classes.Class_ID AND Marks.Mark IS NOT NULL GROUP BY Pupils.Pupil_ID, Pupils.Name, Pupils.Surname, Pupils.Patronymic, Classes.Class_Name "); if (Class_ID == 0 && to == 0 && from == 0) { expr.Append(""); } else if (Class_ID != 0 && to == 0 && from == 0) { string className = ClassesDB.GetClassFullInf(Class_ID).Class_Name; expr.Append($"HAVING Classes.Class_Name = '{className}'"); } else if (Class_ID != 0 && from != 0 && to == 0) { string className = ClassesDB.GetClassFullInf(Class_ID).Class_Name; expr.Append($"HAVING (CAST(CAST(SUM (Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10,2))) >= {from} AND Classes.Class_Name = '{className}' "); } else if (Class_ID != 0 && from == 0 && to != 0) { string className = ClassesDB.GetClassFullInf(Class_ID).Class_Name; expr.Append($"HAVING (CAST(CAST(SUM (Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10,2))) <= {to} AND Classes.Class_Name = '{className}' "); } else if (Class_ID != 0 && from != 0 && to != 0) { string className = ClassesDB.GetClassFullInf(Class_ID).Class_Name; expr.Append($"HAVING (CAST(CAST(SUM (Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10,2))) >= {from} AND (CAST(CAST(SUM(Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10, 2))) <= {to} AND Classes.Class_Name = '{className}' "); } else if (Class_ID == 0 && from != 0 && to == 0) { expr.Append($"HAVING (CAST(CAST(SUM (Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10,2))) >= {from}"); } else if (Class_ID == 0 && from == 0 && to != 0) { expr.Append($"HAVING (CAST(CAST(SUM (Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10,2))) <= {to}"); } else if (Class_ID == 0 && from != 0 && to != 0) { expr.Append($"HAVING (CAST(CAST(SUM (Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10,2))) >= {from} AND(CAST(CAST(SUM(Marks.Mark * Coefficient) AS NUMERIC) / SUM(Coefficient) AS NUMERIC(10, 2))) <= {to}"); } List <PupilWithClass> pupils = PupilsDB.GetFilterPupils(expr.ToString()); return(PartialView(pupils)); }
private void SchedulePlan_Load(object sender, EventArgs e) { List <Classes> ClassList = ClassesDB.ClassLoad(); List <Teacher> TeacherList = TeacherDB.TeacherLoad(); List <Student> StudentList = StudentDB.StudentLoad(); txtClasses.Text = ClassList.Count.ToString(); txtStudents.Text = StudentList.Count.ToString(); txtTeachers.Text = TeacherList.Count.ToString(); txtErrors.Text = "3"; txtClassSize.Text = "10"; //Needs to be set based on a formula (Total Teachers, Periods, Classes and Students) int classSize = Convert.ToInt32(txtClassSize.Text); double classesPerHour = StudentList.Count / classSize; txtClassesPerHour.Text = classesPerHour.ToString(); }
private void btnModify_Click(object sender, EventArgs e) { if (lblSelected.Text != "") { Classes newClass = new Classes(); newClass.ClassID = Convert.ToInt32(lblSelected.Text); newClass.ClassTitle = dataGridView1.CurrentRow.Cells[1].Value.ToString(); newClass.ClassTrack = dataGridView1.CurrentRow.Cells[2].Value.ToString(); ClassesDB.TempSave(newClass); ClassEdit newForm = new ClassEdit(); newForm.Show(); } else { MessageBox.Show("Please select a class to modify"); } }
public ActionResult SaveClassInformation(ClassWithManagment c, int action = 0, int cancel = 0) { if (action == 0) { return(RedirectToActionPermanent("ClassFullInf", "Teacher", new { id = c.Class_ID })); } else { ClassesDB.UpdateClass(c.Class_ID, c.Formation_Date, c.Class_Name); ClassWithManagment cl = ClassesDB.GetClassFullInf(c.Class_ID); if (cl.Teacher_ID != c.Teacher_ID) { ClassesDB.FinishClassManagment(c.ClassManagment_ID); ClassesDB.AddClassManagment(c.Class_ID, c.Teacher_ID); } return(RedirectToActionPermanent("ClassFullInf", "Teacher", new { id = c.Class_ID })); } }
private void btnSave_Click(object sender, EventArgs e) //Needs validation { if (true) //Validate everything { List <int> ClassList = new List <int>(); List <Classes> ClassListSave = new List <Classes>(); //Retrieves class data and populates list foreach (object classData in checkedListBox1.CheckedItems) { string[] classInfo = classData.ToString().Split(' '); Classes newClass = ClassesDB.ClassFind(Convert.ToInt32(classInfo[0])); ClassListSave.Add(newClass); ClassList.Add(newClass.ClassID); } //Find teacher and add data into teacher string[] teacherID = comboBox1.Text.Split(' '); Teacher newTeacher = TeacherDB.TeacherFind(Convert.ToInt32(teacherID[0])); newTeacher.ClassID = ClassList; foreach (Classes classes in ClassListSave) { classes.TeacherID.Add(newTeacher.TeacherID); ClassesDB.ClassDelete(classes); ClassesDB.ClassSave(classes); } TeacherDB.TeacherDelete(newTeacher); TeacherDB.TeacherSave(newTeacher); } else { MessageBox.Show("Please select the correct number of classes or select a different teacher"); } this.Close(); }
private void AddClassesStudent_Load(object sender, EventArgs e) { List <Student> StudentList = StudentDB.StudentLoad(); foreach (Student student in StudentList) { string entry = student.StudentID + " " + student.FirstName + " " + student.LastName + " " + student.Grade; comboBox1.Items.Add(entry); } Student newStudent = StudentDB.TempLoad(); label2.Text = newStudent.StudentID.ToString(); textBox1.Text = newStudent.FirstName; textBox2.Text = newStudent.LastName; newStudent = StudentDB.StudentFind(Convert.ToInt32(label2.Text)); txtGrade.Text = newStudent.Grade.ToString(); List <Classes> ClassList = ClassesDB.ClassLoad(); foreach (Classes classes in ClassList) { checkedListBox1.Items.Add(classes.ClassID + " " + classes.ClassTitle + " " + classes.ClassTrack); } if (newStudent.ClassID != null) { for (int i = 0; i < checkedListBox1.Items.Count; i++) { foreach (int classid in newStudent.ClassID) { string[] id = checkedListBox1.Items[i].ToString().Split(' '); if (classid == Convert.ToInt32(id[0])) { checkedListBox1.SetItemChecked(i, true); } } } } }
//Save all classes to student private void button1_Click(object sender, EventArgs e) { Student student = StudentDB.StudentFind(Convert.ToInt32(label2.Text)); List <int> ClassId = new List <int>(); foreach (object classid in checkedListBox1.CheckedItems) { string[] id = classid.ToString().Split(' '); ClassId.Add(Convert.ToInt32(id[0])); Classes classes = ClassesDB.ClassFind(Convert.ToInt32(id[0])); List <int> studentID = new List <int>(); studentID.Add(classes.ClassID); ClassesDB.ClassDelete(classes); ClassesDB.ClassSave(classes); } student.ClassID = ClassId; StudentDB.StudentDelete(student); StudentDB.StudentSave(student); }