public ActionResult Edit(long SeqNo) { try { drplist(); SchoolCalenderModel TModel = new SchoolCalenderModel(); tblSchoolCalendar TCtable = Connection.tblSchoolCalendars.SingleOrDefault(x => x.CalenderSeqNo == SeqNo); TModel.CalenderSeqNo = SeqNo; TModel.AcadamicYear = TCtable.AcadamicYear; TModel.FromDate = TCtable.FromDate; TModel.ToDate = TCtable.ToDate; TModel.SpecialComment = TCtable.SpecialComment; TModel.IsHoliday = TCtable.IsHoliday; TModel.DateComment = TCtable.DateComment; return(PartialView("EditView", TModel)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
public ActionResult ShowAddView(string id) { SchoolCalenderModel TModel = new SchoolCalenderModel(); TModel.AcadamicYear = id; ViewBag.AccYear = id; return(PartialView("AddView", TModel)); }
// [UserFilter(Function_Id = "ScCal")] public ActionResult Delete(long SeqNo) { try { SchoolCalenderModel TModel = new SchoolCalenderModel(); TModel.CalenderSeqNo = SeqNo; return(PartialView("DeleteView", TModel)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
public ActionResult Delete(SchoolCalenderModel Model) { UserId = USession.User_Id; try { Connection.GDDeleteSchoolCalenderActivity(Model.CalenderSeqNo, "Azi@", "N"); Connection.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(Json(false, JsonRequestBehavior.AllowGet)); } }
//[UserFilter(Function_Id = "ScCal")] public ActionResult Index(string AcademicYear) { SchooId = USession.School_Id; try { if (AcademicYear == null) { tblAccadamicYear AccYear = Connection.tblAccadamicYears.SingleOrDefault(a => a.SchoolId == SchooId); ViewBag.AcademicYear = AccYear.AccadamicYear; } else { ViewBag.AcademicYear = AcademicYear; } var Group = Connection.GDgetSchoolCalenderEvent(SchooId, AcademicYear, "Y"); List <GDgetSchoolCalenderEvent_Result> Grouplist = Group.ToList(); SchoolCalenderModel tcm = new SchoolCalenderModel(); List <SchoolCalenderModel> tcmlist = Grouplist.Select(x => new SchoolCalenderModel { CalenderSeqNo = x.CalenderSeqNo, SchoolId = x.SchoolId, AcadamicYear = x.AcadamicYear, DateComment = x.DateComment, IsHoliday = x.IsHoliday, SpecialComment = x.SpecialComment, FromDate = x.FromDate, ToDate = x.ToDate, StartMonth = x.FromDate.Month.ToString(), EndMonth = x.ToDate.Month.ToString(), CreatedBy = x.CreatedBy, CreatedDate = x.CreatedDate.ToShortDateString(), IsActive = x.IsActive }).ToList(); return(View(tcmlist)); } catch (Exception ex) { Errorlog.ErrorManager.LogError(ex); return(View()); } }
public ActionResult Edit(SchoolCalenderModel Model, string IsHoliday1) { UserId = USession.User_Id; try { string holiday = IsHoliday1; if (IsHoliday1 == null) { holiday = "N"; } Connection.GDModifySchoolCalenderActivity(Model.CalenderSeqNo, Model.ToDate, Model.FromDate, Model.SpecialComment, Model.DateComment, holiday, UserId); Connection.SaveChanges(); return(RedirectToAction("Index")); } catch { return(View()); } }
public ActionResult Create(SchoolCalenderModel Model) { string _resutl = "Error"; try { if (Model.CalenderSeqNo == 0) { Connection.GDsetSchoolCalenderActivity("CKC", Model.AcadamicYear, Model.DateComment, Model.IsHoliday, Model.SpecialComment, Model.FromDate, Model.ToDate, "Azi@", "Y"); } else { Connection.GDModifySchoolCalenderActivity(Model.CalenderSeqNo, Model.ToDate, Model.FromDate, Model.SpecialComment, Model.DateComment, Model.IsHoliday, "Azi@"); } Connection.SaveChanges(); _resutl = "Success"; } catch (Exception Ex) { Errorlog.ErrorManager.LogError("@SchoolCalender Create(SchoolCalenderModel Model)", Ex); _resutl = "Exception"; } return(Json(_resutl, JsonRequestBehavior.AllowGet)); }