public ActionResult DeleteTeacherSubject(TSubjectModel Model) { try { tblTeacherSubject Tble = Connection.tblTeacherSubjects.Find(Model.TeacherSubjectSeqNo); Connection.tblTeacherSubjects.Remove(Tble); Connection.SaveChanges(); return(Json(Model.Teacher_ID, JsonRequestBehavior.AllowGet)); } catch { return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public JsonResult AddTeacherSubject(TSubjectModel Model) { try { string result = "Error"; var count = Connection.tblTeacherSubjects.Count( u => u.ClassId == Model.ClassId && u.GradeId == Model.GradeId && u.SubjectId == Model.SubjectId); if (count == 0) { var AY = Connection.tblAccadamicYears.Where(u => u.SchoolId == _session.School_Id).FirstOrDefault(); tblTeacherSubject NewQ = new tblTeacherSubject(); NewQ.CreatedBy = _session.User_Id; NewQ.CreatedDate = DateTime.Now; NewQ.IsActive = "Y"; NewQ.AcedemicYear = AY.AccadamicYear; NewQ.SchoolIds = _session.School_Id; NewQ.GradeId = Model.GradeId; NewQ.ClassId = Model.ClassId; NewQ.TeacherId = Model.Teacher_ID; NewQ.SubjectId = Model.SubjectId; Connection.tblTeacherSubjects.Add(NewQ); Connection.SaveChanges(); result = Model.Teacher_ID.ToString(); } else { result = "Exits"; } return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { Errorlog.ErrorManager.LogError("Teacher Controller - AddTeacherSubject(TSubjectModel Model)", Ex); return(Json("Exception", JsonRequestBehavior.AllowGet)); } }