public JsonResult AddClassTeacher(ClassTeacherModel Model) { try { string result = "Error"; var AY = Connection.tblAccadamicYears.Where(u => u.SchoolId == _session.School_Id).FirstOrDefault(); // List<tblClass> ClassesList = Connection.tblClasses.Where(r => r.SchoolId == "CKC" && r.GradeId == GradeId).ToList(); int countt = Connection.tblClassTeachers.Count(u => u.TeacherId == Model.TeacherId && u.AccedamicYear == AY.AccadamicYear && u.IsActive == "Y"); int Ccount = Connection.tblClassTeachers.Count(u => u.ClassId == Model.ClassId && u.AccedamicYear == AY.AccadamicYear && u.GradeId == Model.GradeId && u.SchoolId == _session.School_Id && u.IsActive == "Y"); if (countt != 0) { result = "TExits"; //ViewBag.TeacherId = Model.TeacherID.ToString(); } else if (Ccount != 0) { result = "CExits"; } else { tblClassTeacher NewQ = new tblClassTeacher(); NewQ.CreatedBy = _session.User_Id; NewQ.CreatedDate = DateTime.Now; NewQ.IsActive = "Y"; NewQ.AccedamicYear = AY.AccadamicYear; NewQ.SchoolId = AY.SchoolId; NewQ.GradeId = Model.GradeId; NewQ.ClassId = Model.ClassId; NewQ.TeacherId = Model.TeacherId; Connection.tblClassTeachers.Add(NewQ); Connection.SaveChanges(); result = "Success"; } return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { Errorlog.ErrorManager.LogError("Teacher Controller - AddClassTeacher(ClassTeacherModel Model)", Ex); return(Json("Exception", JsonRequestBehavior.AllowGet)); } }
public JsonResult DeleteClassTeacher(ClassTeacherModel Model) { try { tblClassTeacher TCtable = Connection.tblClassTeachers.SingleOrDefault( x => x.TeacherId == Model.TeacherId && x.GradeId == Model.GradeId && x.ClassId == Model.ClassId && x.AccedamicYear == Model.AccedamicYear && x.SchoolId == Model.SchoolId); TCtable.IsActive = "D"; Connection.SaveChanges(); return(Json("Sucses", JsonRequestBehavior.AllowGet)); } catch { return(Json("Error", JsonRequestBehavior.AllowGet)); } }