public ActionResult Index() { ViewBag.Message = false; Dropdownlistdata("", ""); var Group = Connection.GDgetAllSubject("Y"); List <GDgetAllSubject_Result> Grouplist = Group.ToList(); Grade_SubjectModel tcm = new Grade_SubjectModel(); List <Grade_SubjectModel> tcmlist = Grouplist.Select(x => new Grade_SubjectModel { SubjectId = x.SubjectId, ShortName = x.ShortName, SubjectName = x.SubjectName, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).ToList(); return(PartialView(tcmlist)); // return View(); }
public ActionResult Delete(string AcademicYear, string GradeId, string SubjectId) { Grade_SubjectModel TModel = new Grade_SubjectModel(); TModel.AcademicYear = AcademicYear; TModel.GradeId = GradeId; TModel.SubjectId = Convert.ToInt32(SubjectId); return(PartialView("DeleteView", TModel)); }
public ActionResult Edit(Grade_SubjectModel Model) { try { SchoolId = USession.School_Id; UserId = USession.User_Id; Connection.GDModifyGradeSubject(Model.AcademicYear, SchoolId, Model.GradeId, Model.SubjectId, Model.SubjectCategoryId, Model.Optional, UserId); Connection.SaveChanges(); ViewBag.ShowDiv = false; // Detail(Model.AcademicYear, Model.GradeId); return(RedirectToAction("Detail", Model)); } catch { return(View()); } }
public ActionResult Delete(Grade_SubjectModel Model) { try { SchoolId = USession.School_Id; UserId = USession.User_Id; Connection.GDdeleteGradeSubject(Model.AcademicYear, SchoolId, Model.GradeId, Model.SubjectId, "N", UserId); Connection.SaveChanges(); //return View(); return(Json(true, JsonRequestBehavior.AllowGet)); //return RedirectToAction("Detail",Model); } catch { return(View()); } }
public ActionResult Edit(string AcademicYear, string GradeId, string SubjectId, string SubjectCategoryId, string Optional) { Dropdownlistdata(AcademicYear, GradeId); int suid = Convert.ToInt32(SubjectId); Grade_SubjectModel TModel = new Grade_SubjectModel(); tblSubject TCtable = Connection.tblSubjects.SingleOrDefault(x => x.SubjectId == suid); TModel.AcademicYear = AcademicYear; TModel.GradeId = GradeId; TModel.SubjectName = TCtable.SubjectName; TModel.ShortName = TCtable.ShortName; TModel.SubjectId = Convert.ToInt32(SubjectId); TModel.SubjectCategoryId = Convert.ToInt32(SubjectCategoryId); TModel.Optional = Optional; tblGrade TGtable = Connection.tblGrades.SingleOrDefault(x => x.GradeId == GradeId); TModel.GradeName = TGtable.GradeName; return(PartialView("Edit", TModel)); }
public ActionResult Detail(string AcademicYear, string GradeId) { try { Dropdownlistdata(AcademicYear, GradeId); SchoolId = USession.School_Id; var Group = Connection.GDgetAllGradeSubject(AcademicYear, SchoolId, GradeId, "Y"); List <GDgetAllGradeSubject_Result> Grouplist = Group.ToList(); Grade_SubjectModel tcm = new Grade_SubjectModel(); List <Grade_SubjectModel> tcmlist = Grouplist.Select(x => new Grade_SubjectModel { AcademicYear = x.AcademicYear, GradeId = x.GradeId, GradeName = x.GradeName, SubjectId = x.SubjectId, ShortName = x.ShortName, SubjectName = x.SubjectName, SubjectCategoryId = x.SubjectCategoryId, SubjectCategoryName = x.SubjectCategoryName, Optional = x.Optional, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).ToList(); return(View("Create", tcmlist)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } // return View(); }
public ActionResult Create(int[] SubjectCategoryId, int[] selectedNames, string GradeId, string[] optional, string AcademicYear) { try { SchoolId = USession.School_Id; UserId = USession.User_Id; int valCounter = 0; int valCounter1 = 0; int lenth = 0; foreach (int SubCatId in SubjectCategoryId) { if (SubCatId != 0) { valCounter++; } } foreach (string val in optional) { if (val != "") { valCounter1++; } } if (selectedNames != null) { lenth = selectedNames.Length; } if (lenth != valCounter || valCounter1 != lenth || GradeId == "" || AcademicYear == "") { return(RedirectToAction("Index")); } else { ViewBag.Message = false; Dropdownlistdata(AcademicYear, GradeId); int count = -1; foreach (int SubCatId in SubjectCategoryId) { if (SubCatId != 0) { count++; int count1 = -1; foreach (int SubId in selectedNames) { count1++; if (count == count1) { int count2 = -1; foreach (string optionalval in optional) { count2++; if (count2 == count1) { Connection.GDsetGradeSubject(AcademicYear, SchoolId, GradeId, SubId, SubCatId, optionalval, UserId, "Y"); } } } } } } var Group = Connection.GDgetAllGradeSubject(AcademicYear, SchoolId, GradeId, "Y"); List <GDgetAllGradeSubject_Result> Grouplist = Group.ToList(); Grade_SubjectModel tcm = new Grade_SubjectModel(); List <Grade_SubjectModel> tcmlist = Grouplist.Select(x => new Grade_SubjectModel { AcademicYear = x.AcademicYear, GradeId = x.GradeId, GradeName = x.GradeName, SubjectId = x.SubjectId, ShortName = x.ShortName, SubjectName = x.SubjectName, SubjectCategoryId = x.SubjectCategoryId, SubjectCategoryName = x.SubjectCategoryName, CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate, IsActive = x.IsActive, Optional = x.Optional, ModifiedBy = x.ModifiedBy, ModifiedDate = x.ModifiedDate }).ToList(); return(View(tcmlist)); } } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }