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