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));
}
}
