public ActionResult Students_group_load(SVM.Students_group_load model, int page = 1, char action = '0', int row = -1, int id_students_group_load = -1) { switch (action) { case 'a': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = new SVM.Students_group_load(); break; case 's': if (ModelState.IsValid) { if (DB.Students_group_load.Count(sgl => sgl.id_students_group == model.id_students_group && sgl.id_subject == model.id_subject) > 0) { ViewBag.action = 'a'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Students_group_load_duplicate_group_and_subject_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Students_group_load.Add(model); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Students_group_load_add_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'a'; ViewBag.row = row; } break; case 'e': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = DB.Students_group_load.Find(id_students_group_load); break; case 'u': if (ModelState.IsValid) { if (DB.Students_group_load.Count(sgl => sgl.id_students_group == model.id_students_group && sgl.id_subject == model.id_subject && sgl.id_students_group_load != model.id_students_group_load) > 0) { ViewBag.action = 'e'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Students_group_load_duplicate_group_and_subject_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Students_group_load.Find(id_students_group_load).hours = model.hours; DB.Students_group_load.Find(id_students_group_load).id_students_group = model.id_students_group; DB.Students_group_load.Find(id_students_group_load).id_subject = model.id_subject; DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Students_group_load_edit_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'e'; ViewBag.row = row; } break; case 'r': ModelState.Clear(); model = DB.Students_group_load.Find(id_students_group_load); if (DB.Students_group_load.Count(sgl => sgl.id_students_group == model.id_students_group && sgl.id_subject == model.id_subject) > 0) { try { DB.Students_group_load.Remove(DB.Students_group_load.Find(id_students_group_load)); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-4", Localizator.Localizate("Students_group_load_delete_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-4", ex.GetBaseException().Message); } } else { ModelState.AddModelError("-5", Localizator.Localizate("Students_group_load_existance_error", CurrentLangCode)); } break; default: ModelState.Clear(); ViewBag.action = '0'; ViewBag.row = -1; break; } try { IQueryable<SVM.Students_group_load> Istudents_group_loads; int elements_on_page = Int32.Parse(ConfigurationManager.AppSettings["ElementsOnPage"]); if (DB.Students_group_load.Count() <= elements_on_page) { ViewBag.pages = 1; Istudents_group_loads = DB.Students_group_load; } else { int pages = (DB.Students_group_load.Count() / elements_on_page) + 1; ViewBag.elements_on_page = elements_on_page; ViewBag.page = page; ViewBag.pages = pages; if (page == 1) Istudents_group_loads = DB.Students_group_load.Take(elements_on_page); else { if (page == pages) Istudents_group_loads = DB.Students_group_load.OrderBy(t => t.id_students_group_load).Skip(elements_on_page * (page - 1)); else Istudents_group_loads = DB.Students_group_load.OrderBy(t => t.id_students_group_load).Skip(elements_on_page * (page - 1)).Take(elements_on_page); } } ViewBag.students_group_loads = Istudents_group_loads.ToList(); ViewBag.students_groups = DB.Students_group.ToList(); ViewBag.subjects = DB.Subject.ToList(); } catch (Exception ex) { ModelState.AddModelError("-1", Localizator.Localizate("Students_group_load_view_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-1", ex.GetBaseException().Message); } return View(model); }
public ActionResult Students_group(SVM.Students_group model, int page = 1, char action = '0', int row = -1, int id_students_group = -1) { switch (action) { case 'a': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = new SVM.Students_group(); break; case 's': if (ModelState.IsValid) { if (DB.Students_group.Count(sg => sg.name == model.name) > 0) { ViewBag.action = 'a'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Students_group_duplicate_number_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Students_group.Add(model); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Students_group_add_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'a'; ViewBag.row = row; } break; case 'e': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = DB.Students_group.Find(id_students_group); break; case 'u': if (ModelState.IsValid) { if (DB.Students_group.Count(sg => sg.name == model.name && sg.id_students_group != model.id_students_group) > 0) { ViewBag.action = 'e'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Students_group_duplicate_number_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Students_group.Find(id_students_group).name = model.name; DB.Students_group.Find(id_students_group).people_amount = model.people_amount; DB.Students_group.Find(id_students_group).id_department = model.id_department; DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Students_group_edit_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'e'; ViewBag.row = row; } break; case 'r': ModelState.Clear(); model = DB.Students_group.Find(id_students_group); if (DB.Students_group.Count(sg => sg.name == model.name) > 0) { try { DB.Students_group.Remove(DB.Students_group.Find(id_students_group)); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-4", Localizator.Localizate("Students_group_delete_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-4", ex.GetBaseException().Message); } } else { ModelState.AddModelError("-5", Localizator.Localizate("Students_group_existance_error", CurrentLangCode)); } break; default: ModelState.Clear(); ViewBag.action = '0'; ViewBag.row = -1; break; } try { IQueryable<SVM.Students_group> Istudents_groups; int elements_on_page = Int32.Parse(ConfigurationManager.AppSettings["ElementsOnPage"]); if (DB.Students_group.Count() <= elements_on_page) { ViewBag.pages = 1; Istudents_groups = DB.Students_group; } else { int pages = (DB.Students_group.Count() / elements_on_page) + 1; ViewBag.elements_on_page = elements_on_page; ViewBag.page = page; ViewBag.pages = pages; if (page == 1) Istudents_groups = DB.Students_group.Take(elements_on_page); else { if (page == pages) Istudents_groups = DB.Students_group.OrderBy(sg => sg.id_students_group).Skip(elements_on_page * (page - 1)); else Istudents_groups = DB.Students_group.OrderBy(sg => sg.id_students_group).Skip(elements_on_page * (page - 1)).Take(elements_on_page); } } ViewBag.students_groups = Istudents_groups.ToList(); ViewBag.departments = DB.Department.ToList(); ViewBag.faculties = GetSafeFaculties().ToList(); } catch (Exception ex) { ModelState.AddModelError("-1", Localizator.Localizate("Students_group_view_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-1", ex.GetBaseException().Message); } return View(model); }
public ActionResult Teacher(SVM.Teacher model, int page = 1, char action = '0', int row = -1, int id_teacher = -1) { switch (action) { case 'a': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = new SVM.Teacher(); break; case 's': if (ModelState.IsValid) { if (DB.Teacher.Count(t => t.surname == model.surname && t.name == model.name && t.patronymic == model.patronymic) > 0) { ViewBag.action = 'a'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Teacher_duplicate_surname_and_name_and_patronymic_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Teacher.Add(model); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Teacher_add_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'a'; ViewBag.row = row; } break; case 'e': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = DB.Teacher.Find(id_teacher); break; case 'u': if (ModelState.IsValid) { if (DB.Teacher.Count(t => t.surname == model.surname && t.name == model.name && t.patronymic == model.patronymic && t.id_teacher != model.id_teacher) > 0) { ViewBag.action = 'e'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Teacher_duplicate_surname_and_name_and_patronymic_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Teacher.Find(id_teacher).surname = model.surname; DB.Teacher.Find(id_teacher).name = model.name; DB.Teacher.Find(id_teacher).patronymic = model.patronymic; DB.Teacher.Find(id_teacher).working_position = model.working_position; DB.Teacher.Find(id_teacher).regalia = model.regalia; DB.Teacher.Find(id_teacher).id_department = model.id_department; DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Teacher_edit_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'e'; ViewBag.row = row; } break; case 'r': ModelState.Clear(); model = DB.Teacher.Find(id_teacher); if (DB.Teacher.Count(t => t.surname == model.surname && t.name == model.name && t.patronymic == model.patronymic) > 0) { try { DB.Teacher.Remove(DB.Teacher.Find(id_teacher)); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-4", Localizator.Localizate("Teacher_delete_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-4", ex.GetBaseException().Message); } } else { ModelState.AddModelError("-5", Localizator.Localizate("Teacher_existance_error", CurrentLangCode)); } break; default: ModelState.Clear(); ViewBag.action = '0'; ViewBag.row = -1; break; } try { IQueryable<SVM.Teacher> Iteachers; int elements_on_page = Int32.Parse(ConfigurationManager.AppSettings["ElementsOnPage"]); if (DB.Teacher.Count() <= elements_on_page) { ViewBag.pages = 1; Iteachers = DB.Teacher; } else { int pages = (DB.Teacher.Count() / elements_on_page) + 1; ViewBag.elements_on_page = elements_on_page; ViewBag.page = page; ViewBag.pages = pages; if (page == 1) Iteachers = DB.Teacher.Take(elements_on_page); else { if (page == pages) Iteachers = DB.Teacher.OrderBy(t => t.id_teacher).Skip(elements_on_page * (page - 1)); else Iteachers = DB.Teacher.OrderBy(t => t.id_teacher).Skip(elements_on_page * (page - 1)).Take(elements_on_page); } } ViewBag.teachers = Iteachers.ToList(); ViewBag.departments = DB.Department.ToList(); ViewBag.faculties = DB.Faculty.ToList(); } catch (Exception ex) { ModelState.AddModelError("-1", Localizator.Localizate("Teacher_view_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-1", ex.GetBaseException().Message); } return View(model); }
public ActionResult Faculty(SVM.Faculty model, int page = 1, char action = '0', int row = -1, int id_faculty = -1) { switch (action) { case 'a': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = new SVM.Faculty(); break; case 's': if (ModelState.IsValid) { if (DB.Faculty.Count(f => f.name == model.name || f.abbreviation == model.abbreviation) > 0) { ViewBag.action = 'a'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Faculty_duplicate_name_or_abbreviation_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Faculty.Add(model); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Faculty_add_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'a'; ViewBag.row = row; } break; case 'e': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = DB.Faculty.Find(id_faculty); break; case 'u': if (ModelState.IsValid) { if (DB.Faculty.Count(f => (f.name == model.name || f.abbreviation == model.abbreviation) && f.id_faculty != model.id_faculty) > 0) { ViewBag.action = 'e'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Faculty_duplicate_name_or_abbreviation_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Faculty.Find(id_faculty).name = model.name; DB.Faculty.Find(id_faculty).abbreviation = model.abbreviation; DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Faculty_edit_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'e'; ViewBag.row = row; } break; case 'r': ModelState.Clear(); model = DB.Faculty.Find(id_faculty); if (DB.Faculty.Count(f => f.name == model.name || f.abbreviation == model.abbreviation) > 0) { try { DB.Faculty.Remove(DB.Faculty.Find(id_faculty)); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-4", Localizator.Localizate("Faculty_delete_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-4", ex.GetBaseException().Message); } } else { ModelState.AddModelError("-5", Localizator.Localizate("Faculty_existance_error", CurrentLangCode)); } break; default: ModelState.Clear(); ViewBag.action = '0'; ViewBag.row = -1; break; } try { IQueryable<SVM.Faculty> Ifaculies; int elements_on_page = Int32.Parse(ConfigurationManager.AppSettings["ElementsOnPage"]); if (DB.Faculty.Count() <= elements_on_page) { ViewBag.pages = 1; Ifaculies = DB.Faculty; } else { int pages = (DB.Faculty.Count() / elements_on_page) + 1; ViewBag.elements_on_page = elements_on_page; ViewBag.page = page; ViewBag.pages = pages; if (page == 1) Ifaculies = DB.Faculty.Take(elements_on_page); else { if (page == pages) Ifaculies = DB.Faculty.OrderBy(f => f.id_faculty).Skip(elements_on_page * (page - 1)); else Ifaculies = DB.Faculty.OrderBy(f => f.id_faculty).Skip(elements_on_page * (page - 1)).Take(elements_on_page); } } ViewBag.faculties = Ifaculies.ToList(); } catch (Exception ex) { ModelState.AddModelError("-1", Localizator.Localizate("Faculty_view_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-1", ex.GetBaseException().Message); } return View(model); }
public ActionResult Classroom(SVM.Classroom model, int page = 1, char action = '0', int row = -1, int id_classroom = -1) { switch (action) { case 'a': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = new SVM.Classroom(); break; case 's': if (ModelState.IsValid) { if (DB.Classroom.Count(c => c.number == model.number) > 0) { ViewBag.action = 'a'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Classroom_duplicate_number_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Classroom.Add(model); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Classroom_add_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'a'; ViewBag.row = row; } break; case 'e': ModelState.Clear(); ViewBag.action = action; ViewBag.row = row; model = DB.Classroom.Find(id_classroom); break; case 'u': if (ModelState.IsValid) { if (DB.Classroom.Count(c => c.number == model.number && c.id_classroom != model.id_classroom) > 0) { ViewBag.action = 'e'; ViewBag.row = row; ModelState.AddModelError("-2", Localizator.Localizate("Classroom_duplicate_number_error", CurrentLangCode)); } else { ViewBag.action = '0'; ViewBag.row = -1; try { DB.Classroom.Find(id_classroom).number = model.number; DB.Classroom.Find(id_classroom).people_capacity = model.people_capacity; DB.Classroom.Find(id_classroom).id_department = model.id_department; DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-3", Localizator.Localizate("Classroom_edit_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-3", ex.GetBaseException().Message); } } } else { ViewBag.action = 'e'; ViewBag.row = row; } break; case 'r': ModelState.Clear(); model = DB.Classroom.Find(id_classroom); if (DB.Classroom.Count(c => c.number == model.number) > 0) { try { DB.Classroom.Remove(DB.Classroom.Find(id_classroom)); DB.SaveChanges(); } catch (Exception ex) { ModelState.AddModelError("-4", Localizator.Localizate("Classroom_delete_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-4", ex.GetBaseException().Message); } } else { ModelState.AddModelError("-5", Localizator.Localizate("Classroom_existance_error", CurrentLangCode)); } break; default: ModelState.Clear(); ViewBag.action = '0'; ViewBag.row = -1; break; } try { IQueryable<SVM.Classroom> Iclassrooms; int elements_on_page = Int32.Parse(ConfigurationManager.AppSettings["ElementsOnPage"]); if (DB.Classroom.Count() <= elements_on_page) { ViewBag.pages = 1; Iclassrooms = DB.Classroom; } else { int pages = (DB.Classroom.Count() / elements_on_page) + 1; ViewBag.elements_on_page = elements_on_page; ViewBag.page = page; ViewBag.pages = pages; if (page == 1) Iclassrooms = DB.Classroom.Take(elements_on_page); else { if (page == pages) Iclassrooms = DB.Classroom.OrderBy(c => c.id_classroom).Skip(elements_on_page * (page - 1)); else Iclassrooms = DB.Classroom.OrderBy(c => c.id_classroom).Skip(elements_on_page * (page - 1)).Take(elements_on_page); } } ViewBag.classrooms = Iclassrooms.ToList(); ViewBag.departments = DB.Department.ToList(); ViewBag.faculties = DB.Faculty.ToList(); } catch (Exception ex) { ModelState.AddModelError("-1", Localizator.Localizate("Classroom_view_error", CurrentLangCode)); if (HttpContext.IsDebuggingEnabled) ModelState.AddModelError("-1", ex.GetBaseException().Message); } return View(model); }