public ActionResult Index() { try { MessageAndUser messageAndUser = new MessageAndUser(); messageAndUser.messages = db.Msgs.ToList(); messageAndUser.users = db.Site_Users.ToList(); return(View(messageAndUser)); } catch (DbUpdateException dbException) { ViewBag.DbExceptionMessage = dbException.Message; } catch (EntityException entityException) { //InnerException.Message gives a more detailed message, a message that I wouldn't show on a webpage ViewBag.EntityExceptionMessage = entityException.InnerException.Message; //This one also gives a message but very vague. //ViewBag.EntityExceptionMessage = entityException.Message; } catch (SqlException sqlException) { ViewBag.SqlExceptionNumber = sqlException.Number; ViewBag.SqlExceptionMessage = sqlException.Message; } catch (Exception genericException) { ViewBag.ExceptionMessage = genericException.Message; } //If everything goes well, then the return line below won't get reached. return(View("~/Views/Errors/Details.cshtml")); }
public ActionResult AdminHomePage(int id) { MessageAndUser messageAndUser = new MessageAndUser(); messageAndUser.user = db.Site_Users.SingleOrDefault(su => su.Id == id); messageAndUser.users = db.Site_Users.ToList(); messageAndUser.messages = db.Msgs.ToList(); return(View(messageAndUser)); }
public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MessageAndUser messageAndUser = new MessageAndUser(); messageAndUser.message = db.Msgs.Find(id); messageAndUser.users = db.Site_Users.ToList(); if (messageAndUser.message == null) { return(HttpNotFound()); } return(View(messageAndUser)); }
public ActionResult Create(int id) { try { int msgId = db.Msgs.Count(); //var sql = "select count(*) from msgs"; //int msgId = db.Database.SqlQuery<int>(sql).Single(); Msgs msg = new Msgs(); msg.Id = msgId; msg.Sender_User_Id = id; msg.Pre_Msg_Id = -1; List <Site_Users> userList = db.Site_Users.ToList(); List <Site_Users> ul = new List <Site_Users>(); if (id == 0) { ul.Add(userList[1]); ul.Add(userList[2]); } else if (id == 1) { ul.Add(userList[0]); ul.Add(userList[2]); } else if (id == 2) { ul.Add(userList[0]); ul.Add(userList[1]); } MessageAndUser messageAndUser = new MessageAndUser(); //messageAndUser.users = userList; messageAndUser.users = ul; messageAndUser.message = msg; return(View(messageAndUser)); } catch (DbUpdateException dbException) { ViewBag.DbExceptionMessage = dbException.Message; } catch (EntityException entityException) { //InnerException.Message gives a more detailed message, a message that I wouldn't show on a webpage ViewBag.EntityExceptionMessage = entityException.InnerException.Message; //This one also gives a message but very vague. //ViewBag.EntityExceptionMessage = entityException.Message; } catch (SqlException sqlException) { ViewBag.SqlExceptionNumber = sqlException.Number; ViewBag.SqlExceptionMessage = sqlException.Message; } catch (Exception genericException) { ViewBag.ExceptionMessage = genericException.Message; } //If everything goes well, then the return line below won't get reached. return(View("~/Views/Errors/Details.cshtml")); }