// GET: Evetns
public ViewResult Events(string sortOrder, string currentFilter, string startDate, string endDate, string searchString, int?page)
{
if (Session["UserTicket"] != null)
{
ViewBag.CurrentSort = sortOrder;
ViewBag.IdSortParm = String.IsNullOrEmpty(sortOrder) ? "id_asc" : "";
ViewBag.UserIdSortParm = sortOrder == "UserId" ? "UserId_desc" : "UserId";
ViewBag.DepartSortParm = sortOrder == "DeparmentId" ? "DeparmentId_desc" : "DeparmentId";
ViewBag.DateSortParm = sortOrder == "Date" ? "Date_desc" : "Date";
ViewBag.NotifDateSortParm = sortOrder == "NotifDate" ? "NotifDate_desc" : "NotifDate";
if (startDate == null)
{
startDate = DateTime.Today.AddDays(-15).ToString("MM-dd-yyyy");
}
if (endDate == null)
{
endDate = DateTime.Today.AddDays(30).ToString("MM-dd-yyyy");
}
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
ViewBag.startDate = startDate.ToString();
ViewBag.endDate = endDate.ToString();
EventsModel e = new EventsModel();
var events = e.GetEvents(new Guid(Session["UserTicket"].ToString()), DateTime.Parse(startDate), DateTime.Parse(endDate));
if (!String.IsNullOrEmpty(searchString))
{
events = events.Where(s => s.title.Contains(searchString) ||
s.content.Contains(searchString) ||
s.departments.Name.Contains(searchString) ||
s.Id.ToString().Contains(searchString) ||
s.UserId.ToString().Contains(searchString));
}
switch (sortOrder)
{
case "id_asc":
events = events.OrderBy(s => s.Id);
break;
case "UserId":
events = events.OrderBy(s => s.UserId);
break;
case "UserId_desc":
events = events.OrderByDescending(s => s.UserId);
break;
case "DeparmentId_desc":
events = events.OrderByDescending(s => s.departments.Name);
break;
case "DeparmentId":
events = events.OrderBy(s => s.departments.Name);
break;
case "Date_desc":
events = events.OrderByDescending(s => s.date);
break;
case "Date":
events = events.OrderBy(s => s.date);
break;
case "NotifDate_desc":
events = events.OrderByDescending(s => s.notificationDate);
break;
case "NotifDate":
events = events.OrderBy(s => s.notificationDate);
break;
default: // id ascending
events = events.OrderByDescending(s => s.Id);
break;
}
int pageSize = 5;
int pageNumber = (page ?? 1);
return(View(events.ToPagedList(pageNumber, pageSize)));
}
RedirectToAction("Login", "login");
return(View());
}
// GET: PWrInfo
public ActionResult Index()
{
if (Session["UserTicket"] != null)
{
MessagesModel m = new MessagesModel();
EventsModel e = new EventsModel();
var tuple = new Tuple <List <MessagesModel>, List <EventsModel> >
(m.GetMessages(new Guid(Session["UserTicket"].ToString())).OrderByDescending(msg => msg.Id).ToList(), e.GetEvents(new Guid(Session["UserTicket"].ToString())).OrderByDescending(evt => evt.Id).ToList());
return(View(tuple));
}
return(Redirect("~/Login/Login"));
}