public ActionResult DeleteStudentexcactivities(StudentExtraCModel Model) { try { tblStudentExtraCurricularActivity Tble = Connection.tblStudentExtraCurricularActivities.Find(Model.StudentId, Model.SchoolId, Model.ActivityCode); Connection.tblStudentExtraCurricularActivities.Remove(Tble); Connection.SaveChanges(); var item = Connection.tblStudentExtraCurricularActivities.FirstOrDefault(i => i.SchoolId == Model.SchoolId && i.ActivityCode == Model.ActivityCode); //tblStudentExtraCurricularActivity Tblew = Connection.tblStudentExtraCurricularActivities.Find(item.ActivityCode); //Connection.tblStudentExtraCurricularActivities.Remove(Tblew); // Connection.SaveChanges(); string s = Model.SchoolId + "!" + Model.StudentId; return(Json(s, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Index"); } catch { return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public JsonResult AddStudentExcActivity(StudentExtraCModel Model) { try { string result = "Error"; // var count2 = Connection.tblStudentExtraCurricularActivities.Count(); // Model.HouseId = count2.ToString(); if (Model.ActivityCode != null && Model.SchoolIdE != null && Model.StudentIdE != null) { var count = Connection.tblStudentExtraCurricularActivities.Count(u => u.ActivityCode == Model.ActivityCode && u.SchoolId == Model.SchoolIdE && u.StudentId == Model.StudentIdE); if (count == 0) { // Model.SchoolId = Schoold; tblStudentExtraCurricularActivity newscg = new tblStudentExtraCurricularActivity(); newscg.CreatedBy = USession.User_Id; newscg.CreatedDate = DateTime.Now; newscg.SchoolId = Model.SchoolIdE; newscg.StudentId = Model.StudentIdE; newscg.ActivityCode = Model.ActivityCode; newscg.IsActive = "Y"; Connection.tblStudentExtraCurricularActivities.Add(newscg); Connection.SaveChanges(); result = "sessioncheck" + "!" + Model.SchoolIdE + "!" + Model.StudentIdE; // ViewBag.SchoolId = Model.SchoolId; } else { result = "Exits"; } } else { result = "fill"; } //ShowTeacherQualificatoin(); return(Json(result, JsonRequestBehavior.AllowGet)); } catch (Exception Ex) { Errorlog.ErrorManager.LogError("Teacher Controller - AddQualification(QualificationModel Model)", Ex); return(Json("Exception", JsonRequestBehavior.AllowGet)); } }