public ActionResult Create(ClassViewModels model) { try { SE_ProjectEntities db = new SE_ProjectEntities(); if (DLSInterface.loggedEmail == null) { ViewBag.Warn = "Please Login First"; } else if (db.TeacherTbls.Any(t => t.Email.Equals(DLSInterface.loggedEmail))) { ClassTbl c = new ClassTbl(); c.Name = model.name; c.School_Id = db.SchoolTbls.Where(s => s.Name.Equals(model.schoolName)).FirstOrDefault().Id; c.Code = model.classCode; bool isexist = false; foreach (ClassTbl cls in db.ClassTbls) { if (cls.Name == model.name && cls.School_Id == c.School_Id) { isexist = true; } } if (!isexist) { db.ClassTbls.Add(c); db.SaveChanges(); } int teacherId = db.TeacherTbls.Where(t => t.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Id; int classId = db.ClassTbls.Where(C => C.Name.Equals(model.name)).FirstOrDefault().Id; bool isExist = false; foreach (TeacherClassOTM tc in db.TeacherClassOTMs) { if (tc.Teacher_Id == teacherId && tc.Class_Id == classId) { isExist = true; } } if (isExist) { ViewBag.Warn = "Already Exists"; } else { TeacherClassOTM tc = new TeacherClassOTM(); tc.Teacher_Id = teacherId; tc.Class_Id = classId; db.TeacherClassOTMs.Add(tc); db.SaveChanges(); ViewBag.Warn = "Success"; } } else { ViewBag.Warn = "You Must Be Teacher To Register Class"; } return(View("Create")); } catch { return(View()); } }
public ActionResult AddClass(ViewClassViewModels model) { try { SE_ProjectEntities db = new SE_ProjectEntities(); List <SchoolTbl> SchoolList = db.SchoolTbls.ToList(); ViewBag.SchoolList = new SelectList(SchoolList, "Id", "Name"); if (DLSInterface.loggedEmail == null) { ViewBag.Warn = "Login First"; return(View()); } else if (db.TeacherTbls.Any(t => t.Email.Equals(DLSInterface.loggedEmail))) { int teacherId = db.TeacherTbls.Where(t => t.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Id; int classId = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Id; string classCode = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Code; bool isExist = false; foreach (TeacherClassOTM tc in db.TeacherClassOTMs) { if (tc.Teacher_Id == teacherId && tc.Class_Id == classId) { isExist = true; } } if (isExist) { ViewBag.Warn = "Already Registered in Class"; return(View()); } else { TeacherClassOTM tc = new TeacherClassOTM(); tc.Teacher_Id = teacherId; tc.Class_Id = classId; if (classCode.Equals(model.classCode)) { db.TeacherClassOTMs.Add(tc); db.SaveChanges(); ViewBag.Warn = "Success!"; return(View()); } else { ViewBag.Warn = "Invalid code!"; return(View()); } } } else if (db.StudentTbls.Any(t => t.Email.Equals(DLSInterface.loggedEmail))) { int studentId = db.StudentTbls.Where(s => s.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Id; int classId = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Id; string classCode = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Code; bool isExist = false; foreach (StudentClassOTM sc in db.StudentClassOTMs) { if (sc.Student_Id == studentId && sc.Class_Id == classId) { isExist = true; break; } } if (isExist) { ViewBag.Warn = "Already Registered in Class"; return(View()); } else { StudentClassOTM sc = new StudentClassOTM(); sc.Student_Id = studentId; sc.Class_Id = classId; if (classCode.Equals(model.classCode)) { db.StudentClassOTMs.Add(sc); db.SaveChanges(); ViewBag.Warn = "Success!"; return(View()); } else { ViewBag.Warn = "Invalid code!"; return(View()); } } } return(View()); } catch { return(View()); } }