public PartialViewResult FilterRequests(string rDate)
{
IndexList indexList = new IndexList();
DateTime requestDate;
if (DateTime.TryParseExact(rDate, "dd.MM.yyyy", null, System.Globalization.DateTimeStyles.None, out requestDate))
{
if (User.IsInRole("LAN\\TR_Managers") || AccountManager.IsApprover(User.Identity.Name).Item2 || User.IsInRole("LAN\\TR_Viewers"))
{
var model = _db.Requests
.Where(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.RequestDate == requestDate))
.OrderByDescending(r => r.PublishDate)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = model.Count;
indexList.RowPerPage = model.Count;
return PartialView("_Table", indexList);
}
else
{
var model = _db.Requests
.Where(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.UserLogin == User.Identity.Name && r.RequestDate == requestDate))
.OrderByDescending(r => r.PublishDate)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = model.Count;
indexList.RowPerPage = model.Count;
return PartialView("_Table", indexList);
}
}
else
{
if (User.IsInRole("LAN\\TR_Managers") || AccountManager.IsApprover(User.Identity.Name).Item2 || User.IsInRole("LAN\\TR_Viewers"))
{
var model = _db.Requests
.Where(r => (r.IsDeleted != true || r.IsDeleted == null))
.OrderByDescending(r => r.PublishDate)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = model.Count;
indexList.RowPerPage = model.Count;
return PartialView("_Table", indexList);
}
else
{
var model = _db.Requests
.Where(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.UserLogin == User.Identity.Name))
.OrderByDescending(r => r.PublishDate)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = model.Count;
indexList.RowPerPage = model.Count;
return PartialView("_Table", indexList);
}
}
}
public ActionResult RequestsToApprove(int id)
{
IndexList indexList = new IndexList();
if (!_db.RequestApprovers.Any( a => a.EmployeeId == id) && !User.IsInRole("LAN\\TR_Admins"))
{
ViewBag.BackController = "Home";
return View("Denied");
}
var model = _db.Requests
.Where(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.ApproverEmployeeId == id && r.Status == 0))
.OrderByDescending(r => r.PublishDate)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = model.Count;
indexList.RowPerPage = model.Count;
return View(indexList);
}
public PartialViewResult ShowNewRequestsToApprover(int id)
{
IndexList indexList = new IndexList();
var model = _db.Requests
.Where(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.ApproverEmployeeId == id && r.Status == 0))
.OrderByDescending(r => r.PublishDate)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
ViewBag.Message = "Показаны неподписанные";
ViewBag.LinkText = "Показать подписанные и неподписанные";
ViewBag.ActionName = "ShowAllRequestsToApprover";
indexList.Requests = model;
indexList.TotalRows = model.Count;
indexList.RowPerPage = model.Count;
return PartialView("_SignRequests", indexList);
}
public ActionResult Index(int? page)
{
var indexList = new IndexList();
indexList.RowPerPage = 30;
int skip = 0;
if (page.HasValue)
{
skip = indexList.RowPerPage * ((Int32)page - 1);
}
//Общий список заявок, доступен TR_Managers, Viewers и Тем, кто имеет право подписи
if (User.IsInRole("LAN\\TR_Managers") || AccountManager.IsApprover(User.Identity.Name).Item2 || User.IsInRole("LAN\\TR_Viewers"))
{
var model = _db.Requests
.Where(r => (r.IsDeleted != true || r.IsDeleted == null))
.OrderByDescending(r => r.PublishDate)
.Skip(skip)
.Take(30)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = _db.Requests.Count(r => (r.IsDeleted != true || r.IsDeleted == null));
return View(indexList);
}
else //Список заявок конкретного пользователя
{
var model = _db.Requests
.Where(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.UserLogin == User.Identity.Name))
.OrderByDescending(r => r.PublishDate)
.Skip(skip)
.Take(30)
.ToList();
foreach (var r in model)
{
r.DetailsLink = RequestType.GetDetailsLink(r);
r.DetailsButton = RequestType.GetDetailsButton(r);
r.RequestTypeLabel = RequestType.GetRequestTypeLabel(r);
}
indexList.Requests = model;
indexList.TotalRows = _db.Requests.Count(r => ((r.IsDeleted != true || r.IsDeleted == null) && r.UserLogin == User.Identity.Name));
return View(indexList);
}
}