public ActionResult Teacher_load(SVM.Teacher_load model, int page = 1, char action = '0', int row = -1, int id_teacher_load = -1)
        {
            switch (action)
            {
                case 'a':
                    ModelState.Clear();

                    ViewBag.action = action;
                    ViewBag.row = row;

                    model = new SVM.Teacher_load();
                    break;

                case 's':
                    if (ModelState.IsValid)
                    {
                        if (DB.Teacher_load.Count(tl => tl.id_teacher == model.id_teacher && tl.id_subject == model.id_subject) > 0)
                        {
                            ViewBag.action = 'a';
                            ViewBag.row = row;

                            ModelState.AddModelError("-2", Localizator.Localizate("Teacher_load_duplicate_teacher_and_subject_error", CurrentLangCode));
                        }
                        else
                        {
                            ViewBag.action = '0';
                            ViewBag.row = -1;

                            try
                            {
                                DB.Teacher_load.Add(model);
                                DB.SaveChanges();
                            }
                            catch (Exception ex)
                            {
                                ModelState.AddModelError("-3", Localizator.Localizate("Teacher_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.Teacher_load.Find(id_teacher_load);
                    break;

                case 'u':
                    if (ModelState.IsValid)
                    {
                        if (DB.Teacher_load.Count(tl => tl.id_teacher == model.id_teacher && tl.id_subject == model.id_subject && tl.id_teacher_load != model.id_teacher_load) > 0)
                        {
                            ViewBag.action = 'e';
                            ViewBag.row = row;

                            ModelState.AddModelError("-2", Localizator.Localizate("Teacher_load_duplicate_teacher_and_subject_error", CurrentLangCode));
                        }
                        else
                        {
                            ViewBag.action = '0';
                            ViewBag.row = -1;

                            try
                            {
                                DB.Teacher_load.Find(id_teacher_load).id_teacher = model.id_teacher;
                                DB.Teacher_load.Find(id_teacher_load).id_subject = model.id_subject;
                                DB.SaveChanges();
                            }
                            catch (Exception ex)
                            {
                                ModelState.AddModelError("-3", Localizator.Localizate("Teacher_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.Teacher_load.Find(id_teacher_load);
                    if (DB.Teacher_load.Count(tl => tl.id_teacher == model.id_teacher && tl.id_subject == model.id_subject) > 0)
                    {
                        try
                        {
                            DB.Teacher_load.Remove(DB.Teacher_load.Find(id_teacher_load));
                            DB.SaveChanges();
                        }
                        catch (Exception ex)
                        {
                            ModelState.AddModelError("-4", Localizator.Localizate("Teacher_load_delete_error", CurrentLangCode));
                            if (HttpContext.IsDebuggingEnabled)
                                ModelState.AddModelError("-4", ex.GetBaseException().Message);
                        }
                    }
                    else
                    {
                        ModelState.AddModelError("-5", Localizator.Localizate("Teacher_load_existance_error", CurrentLangCode));
                    }
                    break;

                default:
                    ModelState.Clear();

                    ViewBag.action = '0';
                    ViewBag.row = -1;
                    break;
            }

            try
            {
                IQueryable<SVM.Teacher_load> Iteacher_loads;

                int elements_on_page = Int32.Parse(ConfigurationManager.AppSettings["ElementsOnPage"]);
                if (DB.Teacher_load.Count() <= elements_on_page)
                {
                    ViewBag.pages = 1;
                    Iteacher_loads = DB.Teacher_load;
                }
                else
                {
                    int pages = (DB.Teacher_load.Count() / elements_on_page) + 1;

                    ViewBag.elements_on_page = elements_on_page;
                    ViewBag.page = page;
                    ViewBag.pages = pages;

                    if (page == 1)
                        Iteacher_loads = DB.Teacher_load.Take(elements_on_page);
                    else
                    {
                        if (page == pages)
                            Iteacher_loads = DB.Teacher_load.OrderBy(t => t.id_teacher_load).Skip(elements_on_page * (page - 1));
                        else
                            Iteacher_loads = DB.Teacher_load.OrderBy(t => t.id_teacher_load).Skip(elements_on_page * (page - 1)).Take(elements_on_page);
                    }
                }

                ViewBag.teacher_loads = Iteacher_loads.ToList();
                ViewBag.teachers = DB.Teacher.ToList();
                ViewBag.subjects = DB.Subject.ToList();
                ViewBag.departments = GetSafeDepartmentsForTLoads().ToList();
                ViewBag.faculties = GetSafeFaculties().ToList();
            }
            catch (Exception ex)
            {
                ModelState.AddModelError("-1", Localizator.Localizate("Teacher_load_view_error", CurrentLangCode));
                if (HttpContext.IsDebuggingEnabled)
                    ModelState.AddModelError("-1", ex.GetBaseException().Message);
            }

            return View(model);
        }
 public void TeacherLoadTest_InvalidDataNullIdTeacher_ShouldIsNotNull()
 {
     //arrange
     SVM.Teacher_load tchrl = new SVM.Teacher_load();
     //act
     object result = tchrl.id_teacher;
     //assert
     Assert.IsNotNull(result);
 }
 public void TeacherLoadTest_ValidData_ShouldIsInstanceOfType()
 {
     //arrange
     int id_t = 1;
     int id_s = 1;
     //act
     object result = new SVM.Teacher_load(id_s, id_t);
     //assert
     Assert.IsInstanceOfType(result,typeof(SVM.Teacher_load));
 }
 public void TeacherLoadTest_EmptyConstructor_ShouldIsNotNull()
 {
     //act
     object result = new SVM.Teacher_load();
     //assert
     Assert.IsNotNull(result);
 }