public void Selected(IEnumerable selectedItems)
{
QueueVM.ChangePriority(selectedItems, Priority);
}
public void Selected(IEnumerable selectedItems)
{
QueueVM.ChangeProfile(selectedItems, Item);
}
// GET: Queues
public ActionResult Index(short?id)
{
DataTable secondT = new DataTable();
if (Session["datatable"] != null)
{
secondT = ((DataTable)Session["datatable"]);
}
var queue = db.Queue.Include(q => q.Group).Include(q => q.Queue2).Include(q => q.QueueOrder).Where(q => q.GroupID == id);
List <QueueVM> vm = new List <QueueVM>();
foreach (var item in queue)
{
QueueVM v = new QueueVM();
if ((db.Queue.Where(p => p.QueueID == item.QueueNextQueue)).Select(q => q.QueueDescription).Count() > 0)
{
v.NextQueue = (db.Queue.Where(p => p.QueueID == item.QueueNextQueue)).Select(q => q.QueueDescription).First();
}
if (db.Processing.Where(p => p.ProcUserComplete == null).Where(p => p.QueueID == item.QueueID).OrderBy(p => p.ProcInQueue).Count() > 0)
{
v.OldestFileInQueue = Math.Round((double)(DateTime.Today - (db.Processing.Where(p => p.ProcUserComplete == null).Where(p => p.QueueID == item.QueueID).OrderBy(p => p.ProcInQueue).First().ProcInQueue)).TotalDays, 2);
}
var dodList = db.Processing.Include(path => path.Record).Where(p => p.ProcUserComplete == null && p.Record.DOD != null).Where(p => p.QueueID == item.QueueID).OrderBy(p => p.Record.DOD);
if (dodList.Count() > 0)
{
v.OldestProcDate = DateTime.Parse(dodList.OrderBy(p => p.Record.DOD).First().Record.DOD.ToString()).ToString("MM/dd/yyyy");
}
var fq = db.FilesInQueue(item.QueueID).Sum(p => p.fileAmount).ToString();
var uq = db.UsersInQueue(item.QueueID).Count().ToString();
if (fq == "")
{
v.FilesInQueue = 0;
}
else
{
v.FilesInQueue = Int32.Parse(fq);
}
if (uq == "")
{
v.UsersInQueue = 0;
}
else
{
v.UsersInQueue = Int32.Parse(uq);
}
var avg = (db.Processing.Where(p => p.ProcUserComplete >= DbFunctions.AddDays(DateTime.Now, -60) && p.Username != null && p.QueueID == item.QueueID).Average(p => DbFunctions.DiffDays(p.ProcInQueue, p.ProcUserComplete)));
if (avg == null)
{
v.AvgQueueTime = 0;
}
else
{
v.AvgQueueTime = Math.Round((double)avg, 2);
}
v.Auditing = item.AuditQueue;
v.q = item;
vm.Add(v);
}
ViewBag.GroupName = queue.First().Group.GroupName.ToString();
return(View(vm));
}
public ConnectCommand(QueueVM vm)
{
VM = vm;
}
public DisconnectCommand(QueueVM vm)
{
VM = vm;
}
