public ActionResult AddEventToOrgCalendar() { try { var sess = Session["OrgId"].ToString(); int i = Convert.ToInt32(sess); var orgschcalendar = new OrgSchCalendar(); // Get all the groups from the database var grp = db.OrgGroups.Where(c => c.OrgId == i).ToList(); // Get all the Catergory from the database var calendarcategorys = db.CalendarCategorys.ToList(); // Initialize the view model var addeventtoorgcalviewmodel = new AddNewOrgSchCalViewModel { OrgSchCalendar = orgschcalendar, CalendarCategorys = calendarcategorys, OrgGroups = grp.Select(x => new OrgGroup() { OrgGroupId = x.OrgGroupId, OrgId = x.OrgId, GroupName = x.GroupName }).ToList() }; ViewBag.CalendarCategoryId = new SelectList(db.CalendarCategorys, "CalendarCategoryId", "CategoryName"); ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName"); return(PartialView("~/Views/Shared/PartialViewsForms/_AddEventToOrgCalendar.cshtml", addeventtoorgcalviewmodel)); } catch (Exception e) { Console.WriteLine(e); return(Redirect("~/ErrorHandler.html")); } }
// Update past events by sys admin and set the archived glad public ActionResult UpdateEvents() { try { if (Session["OrgId"] == null) { return(RedirectToAction("Signin", "Access")); } if ((int)Session["OrgId"] != 23) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } if ((int)Session["OrgId"] == 23) { // LOOP THROUGH LIST OF EVENTS IN DB var orgschevnts = db.OrgSchCalendars.Select(x => x.OrgSchCalendarId).ToList(); var orgschevntslist = new List <int>(orgschevnts); foreach (var evntid in orgschevnts) { // GET EVENT DATE var eventdate = db.OrgSchCalendars.Where(x => x.OrgSchCalendarId == evntid).Select(x => x.EventDate).FirstOrDefault(); // GET VALUE OF ISSCHEDULE var eventid = db.OrgSchCalendars.AsNoTracking().Where(x => x.OrgSchCalendarId == evntid).FirstOrDefault(); if (eventdate < DateTime.Now) { var schevnt = new OrgSchCalendar { OrgSchCalendarId = eventid.OrgSchCalendarId, CalendarCategoryId = eventid.CalendarCategoryId, OrgId = eventid.OrgId, Name = eventid.Name, CreatorId = eventid.CreatorId, CreatorFullName = eventid.CreatorFullName, CreationDate = eventid.CreationDate, IsRecurring = eventid.IsRecurring, Frequency = eventid.Frequency, SendAsEmail = eventid.SendAsEmail, EventDate = eventid.EventDate, Description = eventid.Description, EventTime = eventid.EventTime, Isarchived = true }; eventid = schevnt; db.Entry(eventid).State = EntityState.Modified; db.SaveChanges(); } } return(RedirectToAction("SysAdminSetUp", "Home")); } return(new HttpStatusCodeResult(204)); } catch (Exception e) { Console.WriteLine(e); return(Redirect("~/ErrorHandler.html")); } }
public ActionResult DeleteConfirmed(int?Id) { try { if (Request.Browser.IsMobileDevice == true && Session["IsTester"] == null) { return(RedirectToAction("WrongDevice", "Orgs")); } if (Session["OrgId"] == null) { return(RedirectToAction("Signin", "Access")); } var sess = Session["OrgId"].ToString(); int i = Convert.ToInt32(sess); OrgSchCalendar orgSchCalendar = db.OrgSchCalendars.Find(Id); db.OrgSchCalendars.Remove(orgSchCalendar); db.SaveChanges(); //// UPON DELETING A CALNDR EVENT - LOG THE EVENT var orgeventlog = new Org_Events_Log() { Org_Event_SubjectId = orgSchCalendar.OrgSchCalendarId.ToString(), Org_Event_SubjectName = orgSchCalendar.Name, Org_Event_TriggeredbyId = Session["RegisteredUserId"].ToString(), Org_Event_TriggeredbyName = Session["FullName"].ToString(), Org_Event_Time = DateTime.Now, OrgId = Session["OrgId"].ToString(), Org_Events_Types = Org_Events_Types.Calendar_Event_Deleted }; db.Org_Events_Logs.Add(orgeventlog); db.SaveChanges(); return(RedirectToAction("Index", "Orgs", new { id = i })); } catch (Exception e) { Console.WriteLine(e); return(Redirect("~/ErrorHandler.html")); } }
public ActionResult Edit(OrgSchCalendar orgSchCalendar) { try { if (Request.Browser.IsMobileDevice == true && Session["IsTester"] == null) { return(RedirectToAction("WrongDevice", "Orgs")); } if (Session["OrgId"] == null) { return(RedirectToAction("Signin", "Access")); } var sess = Session["OrgId"].ToString(); int i = Convert.ToInt32(sess); // LOOP THRU LIST OF RECORD IN TABLE AND REMOVE var orgschcalid = db.OrgSchCalndrGrps .Where(x => x.OrgSchCalendarId == orgSchCalendar.OrgSchCalendarId) .Where(x => x.OrgId == i) .Select(x => x.OrgSchCalndrGrpId) .ToList(); var orgschcalidtolist = new List <int>(orgschcalid); foreach (var recrd in orgschcalid) { var removercrd = db.OrgSchCalndrGrps .Where(x => x.OrgSchCalndrGrpId == recrd) .Where(x => x.OrgId == i) .Select(x => x.OrgSchCalndrGrpId) .FirstOrDefault(); OrgSchCalndrGrp orgschcalndrgrp = db.OrgSchCalndrGrps.Find(removercrd); db.OrgSchCalndrGrps.Remove(orgschcalndrgrp); } // LOOP THRU LIST OF GROUPS PROVIDED var grps = orgSchCalendar.OrgGroups.Select(x => x.OrgGroupId).ToList(); var grpstolist = new List <int>(grps); foreach (var grp in grps) { // GET VALUE OF IS-SELECTED var isselected = orgSchCalendar.OrgGroups .Where(x => grp == x.OrgGroupId) .Select(x => x.IsSelected) .FirstOrDefault(); if (isselected == true) { var orgschcalndrGrps = new OrgSchCalndrGrp() { OrgSchCalendarId = orgSchCalendar.OrgSchCalendarId, OrgGroupId = grp, OrgId = i, }; db.OrgSchCalndrGrps.Add(orgschcalndrGrps); db.SaveChanges(); } } if (!(ModelState.IsValid) || ModelState.IsValid) { db.Entry(orgSchCalendar).State = EntityState.Modified; db.SaveChanges(); //// UPON EDITING A CALNDR EVENT - LOG THE EVENT - var orgeventlog = new Org_Events_Log() { Org_Event_SubjectId = orgSchCalendar.OrgSchCalendarId.ToString(), Org_Event_SubjectName = orgSchCalendar.Name, Org_Event_TriggeredbyId = Session["RegisteredUserId"].ToString(), Org_Event_TriggeredbyName = Session["FullName"].ToString(), Org_Event_Time = DateTime.Now, OrgId = Session["OrgId"].ToString(), Org_Events_Types = Org_Events_Types.Calendar_Event_Edited }; db.Org_Events_Logs.Add(orgeventlog); db.SaveChanges(); return(RedirectToAction("Index", "Orgs", new { id = i })); } ViewBag.CalendarCategoryId = new SelectList(db.CalendarCategorys, "CalendarCategoryId", "CategoryName", orgSchCalendar.CalendarCategoryId); ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName", orgSchCalendar.OrgId); return(View(orgSchCalendar)); } catch (Exception e) { Console.WriteLine(e); return(Redirect("~/ErrorHandler.html")); } }
public ActionResult EditOrgSchCal(int Id) { try { if (Request.Browser.IsMobileDevice == true && Session["IsTester"] == null) { return(RedirectToAction("WrongDevice", "Orgs")); } if (Session["OrgId"] == null) { return(RedirectToAction("Signin", "Access")); } var sess = Session["OrgId"].ToString(); int i = Convert.ToInt32(sess); var edtcalevent = db.OrgSchCalendars .Include(x => x.CalendarCategory) .Where(x => x.OrgSchCalendarId == Id) .FirstOrDefault(); var orgschcalendar = new OrgSchCalendar(); // Get all the groups from the database var grp = db.OrgGroups.Where(c => c.OrgId == i).ToList(); // Get all the Catergory from the database var calendarcategorys = db.CalendarCategorys.ToList(); // Initialize the view model var editeventorgcalviewmodel = new EditOrgSchCalViewModel { OrgSchCalendarId = edtcalevent.OrgSchCalendarId, CalendarCategoryId = edtcalevent.CalendarCategoryId, OrgId = edtcalevent.OrgId, Name = edtcalevent.Name, CreatorId = edtcalevent.CreatorId, CreatorFullName = edtcalevent.CreatorFullName, Description = edtcalevent.Description, EventDate = edtcalevent.EventDate, EventTime = edtcalevent.EventTime, CreationDate = edtcalevent.CreationDate, IsRecurring = edtcalevent.IsRecurring, Frequency = edtcalevent.Frequency, SendAsEmail = edtcalevent.SendAsEmail, Isarchived = edtcalevent.Isarchived, OrgGroups = grp.Select(x => new OrgGroup() { OrgGroupId = x.OrgGroupId, OrgId = x.OrgId, GroupName = x.GroupName, IsSelected = x.IsSelected }).ToList() }; foreach (var group in editeventorgcalviewmodel.OrgGroups) { int groupCount = editeventorgcalviewmodel.OrgGroups.Count(); } foreach (var item in editeventorgcalviewmodel.OrgGroups) { var isselected = db.OrgSchCalndrGrps .Where(x => x.OrgGroupId == item.OrgGroupId) .Where(x => x.OrgSchCalendarId == Id) .Where(X => X.OrgId == i) .Select(x => x.OrgSchCalndrGrpId) .Count(); if (isselected == 0) { item.IsSelected = false; editeventorgcalviewmodel.CalendarCategoryId = edtcalevent.CalendarCategoryId; } else { item.IsSelected = true; editeventorgcalviewmodel.CalendarCategoryId = edtcalevent.CalendarCategoryId; } } ViewBag.CalendarCategoryId = new SelectList(db.CalendarCategorys, "CalendarCategoryId", "CategoryName"); ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName"); return(PartialView("~/Views/Shared/PartialViewsForms/_EditOrgSchCal.cshtml", editeventorgcalviewmodel)); } catch (Exception e) { Console.WriteLine(e); return(Redirect("~/ErrorHandler.html")); } }