public ActionResult UnbanUser(string csuID) { try { var banTable = new tb_BannedUserTable(); var banStu = db.tb_BannedUserTable.FirstOrDefault(e => e.CSU_ID == csuID); if (banStu == null) { TempData["Message"] = "Unable to unban user " + csuID + "."; return(View("BanView")); } var usersToUnban = from d in db.tb_BannedUserTable where d.CSU_ID == csuID select d; foreach (var u in usersToUnban) { if (u.isPermBanned == false) { db.tb_BannedUserTable.Remove(u); } } // removes all instances of user from tb_BannedUserTable db.SaveChanges(); TempData["Message"] = "User " + csuID + " Unbanned"; return(RedirectToAction("BanView")); } catch { TempData["Message"] = "The Student" + csuID + " was NOT able to be unbanned, try again."; return(View("BanView")); } //return null; }
public ActionResult BanUser(string csuID, string reason, bool?isPermBan) { tb_BannedUserTable banTable = new tb_BannedUserTable(); var banStu = db.tb_CSUStudent.FirstOrDefault(e => e.CSU_ID == csuID); if (banStu == null) { TempData["Message"] = "No Student record found."; return(RedirectToAction("BanView")); } banTable.CSU_ID = banStu.CSU_ID; banTable.isBanned = true; banTable.isPermBanned = isPermBan == true; banTable.BanReason = reason; banTable.BannedBy = SessionVariables.CurrentUser.ENAME; banTable.DateBanned = DateTime.Now; db.tb_BannedUserTable.Add(banTable); db.SaveChanges(); //generate an email notice to the banned user // now setup the message properties email.BanEmail(isPermBan, banStu); TempData["Message"] = "User " + csuID + " Banned"; return(RedirectToAction("BanView")); }