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