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 Create(AddNewOrgSchCalViewModel viewModel) { try { if (Request.Browser.IsMobileDevice == true && Session["IsTester"] == null) { return(RedirectToAction("WrongDevice", "Orgs")); } if (Session["OrgId"] == null) { return(RedirectToAction("Signin", "Access")); } var rr = Session["OrgId"].ToString(); int i = Convert.ToInt32(rr); var RegisteredUserId = Convert.ToInt32(Session["RegisteredUserId"]); var SessionId = Convert.ToInt32(Session["SessionId"]); viewModel.OrgSchCalendar.CreatorId = RegisteredUserId; viewModel.OrgSchCalendar.OrgId = i; viewModel.OrgSchCalendar.CreatorFullName = db.RegisteredUsers.Where(x => x.RegisteredUserId == RegisteredUserId).Select(x => x.FullName).FirstOrDefault(); viewModel.OrgSchCalendar.CreationDate = DateTime.Now; viewModel.OrgSchCalendar.Isarchived = false; if (!(ModelState.IsValid) || ModelState.IsValid) { db.OrgSchCalendars.Add(viewModel.OrgSchCalendar); db.SaveChanges(); // UPON CREATING A CALNDR EVENT - LOG THE EVENT var orgeventlog = new Org_Events_Log() { Org_Event_SubjectId = viewModel.OrgSchCalendar.OrgSchCalendarId.ToString(), Org_Event_SubjectName = viewModel.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_Created }; db.Org_Events_Logs.Add(orgeventlog); db.SaveChanges(); var grps = viewModel.OrgGroups.Select(x => x.OrgGroupId).ToList(); var grpstolist = new List <int>(grps); foreach (var grp in grps) { // GET VALUE OF IS-SELECTED var isselected = viewModel.OrgGroups.Where(x => grp == x.OrgGroupId).Select(x => x.IsSelected).FirstOrDefault(); if (isselected == true) { var orgschcalndrGrps = new OrgSchCalndrGrp() { OrgSchCalendarId = viewModel.OrgSchCalendar.OrgSchCalendarId, OrgGroupId = grp, OrgId = i, }; db.OrgSchCalndrGrps.Add(orgschcalndrGrps); db.SaveChanges(); } } return(Content("")); } ViewBag.CalendarCategoryId = new SelectList(db.CalendarCategorys, "CalendarCategoryId", "CategoryName", viewModel.OrgSchCalendar.CalendarCategoryId); ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName", viewModel.OrgSchCalendar.OrgId); return(Content("")); } catch (Exception e) { Console.WriteLine(e); return(View(viewModel)); } }