public ActionResult DeleteConfirmed(int id)
{
OrgOrgType orgOrgType = db.OrgOrgTypes.Find(id);
db.OrgOrgTypes.Remove(orgOrgType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "OrgOrgTypeId,OrgId,OrgTypeId,OrgName")] OrgOrgType orgOrgType)
{
if (ModelState.IsValid)
{
db.Entry(orgOrgType).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName", orgOrgType.OrgId);
ViewBag.OrgTypeId = new SelectList(db.OrgTypes, "OrgTypeId", "OrgTypeName", orgOrgType.OrgTypeId);
return(View(orgOrgType));
}
public ActionResult Create(OrgOrgType orgOrgType)
{
if (ModelState.IsValid)
{
db.OrgOrgTypes.Add(orgOrgType);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName", orgOrgType.OrgId);
ViewBag.OrgTypeId = new SelectList(db.OrgTypes, "OrgTypeId", "OrgTypeName", orgOrgType.OrgTypeId);
return(View(orgOrgType));
}
// GET: OrgOrgTypes/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrgOrgType orgOrgType = db.OrgOrgTypes.Find(id);
if (orgOrgType == null)
{
return(HttpNotFound());
}
return(View(orgOrgType));
}
// GET: OrgOrgTypes/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
OrgOrgType orgOrgType = db.OrgOrgTypes.Find(id);
if (orgOrgType == null)
{
return(HttpNotFound());
}
ViewBag.OrgId = new SelectList(db.Orgs, "OrgId", "OrgName", orgOrgType.OrgId);
ViewBag.OrgTypeId = new SelectList(db.OrgTypes, "OrgTypeId", "OrgTypeName", orgOrgType.OrgTypeId);
return(View(orgOrgType));
}
public ActionResult Edit(Org org)
{
try
{
if (ModelState.IsValid)
{
db.Entry(org).State = EntityState.Modified;
db.SaveChanges();
var changedorg = db.OrgOrgTypes.AsNoTracking().Where(x => x.OrgId == org.OrgId).FirstOrDefault();
var orgorgtype = new OrgOrgType
{
OrgOrgTypeId = changedorg.OrgOrgTypeId,
OrgId = changedorg.OrgId,
OrgTypeId = changedorg.OrgTypeId,
OrgName = org.OrgName
};
changedorg = orgorgtype;
db.Entry(changedorg).State = EntityState.Modified;
db.SaveChanges();
//Update RegisteredUserOrganisations.Orgname
var userlinkedtoorg = db.RegisteredUserOrganisations.Where(x => x.OrgId == changedorg.OrgId).Select(p => p.RegisteredUserId).ToList();
var listofusers = new List <int>(userlinkedtoorg);
foreach (var usr in userlinkedtoorg)
{
var getuser = db.RegisteredUserOrganisations.AsNoTracking().Where(x => x.RegisteredUserId == usr).FirstOrDefault();
var reguserorg = new RegisteredUserOrganisation
{
RegisteredUserOrganisationId = getuser.RegisteredUserOrganisationId,
RegisteredUserId = getuser.RegisteredUserId,
OrgId = getuser.OrgId,
Email = getuser.Email,
FirstName = getuser.FirstName,
LastName = getuser.LastName,
OrgName = org.OrgName,
RegUserOrgBrand = getuser.RegUserOrgBrand,
IsTester = getuser.IsTester,
RegisteredUserTypeId = getuser.RegisteredUserId,
PrimarySchoolUserRoleId = getuser.PrimarySchoolUserRoleId,
SecondarySchoolUserRoleId = getuser.SecondarySchoolUserRoleId,
EnrolmentDate = getuser.EnrolmentDate,
CreatedBy = getuser.CreatedBy,
FullName = getuser.FullName,
TitleId = getuser.TitleId,
LastLogOn = getuser.LastLogOn,
RegistrationFlags = getuser.RegistrationFlags,
};
getuser = reguserorg;
db.Entry(getuser).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("SystemAdminIndex"));
}
ViewBag.DomainId = new SelectList(db.Domains, "DomainId", "DomainName", org.DomainId);
ViewBag.OrgBrandId = new SelectList(db.OrgBrands, "OrgBrandId", "OrgBrandName", org.OrgBrandId);
ViewBag.OrgTypeId = new SelectList(db.OrgTypes, "OrgTypeId", "OrgTypeName", org.OrgTypeId);
return(View(org));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Redirect("~/ErrorHandler.html"));
}
}
public ActionResult Create(Org org)
{
try
{
var rud = Session["Email"];
var loggedinuser = db.RegisteredUsers.Where(x => x.Email == rud.ToString()).Select(x => x.Email).FirstOrDefault();
var orgredirect = db.RegisteredUserOrganisations.Where(x => x.Email == rud.ToString()).Select(x => x.OrgId).FirstOrDefault();
if (rud.ToString() != loggedinuser)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
if (ModelState.IsValid)
{
org.CreatedBy = Session["RegisteredUserId"].ToString();
org.CreationDate = DateTime.Now;
db.Orgs.Add(org);
db.SaveChanges();
var orgOrgType = new OrgOrgType()
{
OrgId = org.OrgId,
OrgName = org.OrgName,
OrgTypeId = (int)org.OrgTypeId
};
db.OrgOrgTypes.Add(orgOrgType);
db.SaveChanges();
// list of groups
var groups = db.GroupTypes.Where(x => (x.GroupOrgTypeId == org.OrgTypeId) || x.GroupOrgTypeId == null).Select(g => g.GroupTypeId).ToList();
var grouptypeid = new List <int>(groups);
foreach (var newgrp in groups)
{
var groupname = db.GroupTypes.Where(x => x.GroupTypeId == newgrp).Select(s => s.GroupTypeName).FirstOrDefault();
var grouporgtypeid = db.GroupTypes.Where(x => x.GroupTypeId == newgrp).Select(s => s.GroupOrgTypeId).FirstOrDefault();
var grouprefnumb = db.GroupTypes.Where(x => x.GroupTypeId == newgrp).Select(s => s.GroupRefNumb).FirstOrDefault();
var orggroup = new OrgGroup()
{
OrgId = org.OrgId,
GroupName = groupname,
CreationDate = DateTime.Now,
GroupTypeId = newgrp,
GroupOrgTypeId = grouporgtypeid,
GroupRefNumb = grouprefnumb
};
db.OrgGroups.Add(orggroup);
db.SaveChanges();
}
//return RedirectToAction("SystemAdminIndex", "Orgs", new { id = orgredirect });
return(RedirectToAction("SystemAdminIndex"));
}
ViewBag.DomainId = new SelectList(db.Domains, "DomainId", "DomainName", org.DomainId);
ViewBag.OrgBrandId = new SelectList(db.OrgBrands, "OrgBrandId", "OrgBrandName", org.OrgBrandId);
ViewBag.OrgTypeId = new SelectList(db.OrgTypes, "OrgTypeId", "OrgTypeName", org.OrgTypeId);
return(View(org));
}
catch (Exception e)
{
Console.WriteLine(e);
return(View(org));
}
}
