public ActionResult Index()
{
var model = new HomePageModel();
model.CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity);
model.CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity);
model.Locations = EquipmentProvider.GetUserLocations(db, User.Identity);
@ViewBag.Title = "Главная страница";
return(View(model));
}
public ActionResult Index(int page = 1)
{
string userName = User.Identity.Name ?? "";
int pagesize = 20;
var locations = EquipmentProvider.GetUserLocations(_cdb, User.Identity);
var locationsArray = locations.Select(x => x.ID).ToArray();
var analysis = _cdb.MiningAnalyzes.Where(t => locationsArray.Contains(t.LocationID)).Where(v => v.IsValid).ToList();
@ViewBag.Title = "Анализы по добыче";
return(View(new MiningAnalysisView
{
Locations = locations,
MiningAnalysis = analysis.OrderByDescending(t => t.AnalysisTimeStamp).ToPagedList(page, pagesize),
CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity),
CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity)
}));
}
public ActionResult Index(int page = 1)
{
string userName = User.Identity.Name ?? "";
int pagesize = 20;
var beltScales = EquipmentProvider.GetUserAuthorizedEquipment <BeltScale>(_cdb, User.Identity);
var beltScalesArray = beltScales.Select(x => x.ID).ToArray();
var transfers = _cdb.InternalTransfers.Where(t => beltScalesArray.Contains((int)t.EquipID))
.Where(v => v.IsValid).Where(d => d.TransferTimeStamp >= DbFunctions.AddDays(System.DateTime.Now, -2));
@ViewBag.Title = "Анализы для конвейерных весов";
return(View(new BeltTransfersView
{
BeltTransfers = transfers.OrderByDescending(t => t.TransferTimeStamp).ToPagedList(page, pagesize),
CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity),
CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity)
}));
}
public ActionResult Index(int page = 1)
{
string userName = User.Identity.Name ?? "";
int pagesize = 20;
var wagonScales = EquipmentProvider.GetUserAuthorizedEquipment <WagonScale>(_cdb, User.Identity);
var wagonScalesArray = wagonScales.Select(x => x.ID).ToArray();
var transfers = _cdb.WagonTransfers.Where(t => wagonScalesArray.Contains((int)t.EquipID))
.Where(d => d.TransferTimeStamp >= DbFunctions.AddDays(System.DateTime.Now, -2));
@ViewBag.Title = "Данные вагонных весов";
return(View(new WagonScales_Transfers
{
WagonScales = wagonScales,
Transfers = transfers.OrderByDescending(t => t.TransferTimeStamp).ToPagedList(page, pagesize),
CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity),
CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity)
}));
}
public ActionResult Index(int page = 1)
{
string userName = User.Identity.Name ?? "";
int pagesize = 20;
var rockUtils = EquipmentProvider.GetUserAuthorizedEquipment <RockUtil>(_cdb, User.Identity);
var rockUtilsArray = rockUtils.Select(x => x.ID).ToArray();
var transfers = _cdb.RockUtilTransfers.Where(t => rockUtilsArray.Contains((int)t.EquipID))
.Where(d => d.TransferTimeStamp >= DbFunctions.AddDays(System.DateTime.Now, -2));
@ViewBag.Title = "Данные утилизации породы";
return(View(new RockUtil_Transfer
{
RockUtils = rockUtils,
RockUtilTranfers = transfers.OrderByDescending(t => t.TransferTimeStamp).ToPagedList(page, pagesize),
CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity),
CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity)
}));
}
public ActionResult Index(int page = 1)
{
string userName = User.Identity.Name ?? "";
int pagesize = 20;
var wagonScales = EquipmentProvider.GetUserAuthorizedEquipment <WagonScale>(_cdb, User.Identity);
var wagonScalesArray = wagonScales.Select(x => x.ID).ToArray();
var transfers = _cdb.WagonTransfers.Where(t => wagonScalesArray.Contains((int)t.EquipID))
.Where(v => v.IsValid).Where(d => d.TransferTimeStamp >= DbFunctions.AddDays(System.DateTime.Now, -2));
transfers.OrderByDescending(o => o.TransferTimeStamp);
var groups = transfers.GroupBy(l => l.LotName).ToList();
List <WagonBatch> batches = new List <WagonBatch>();
foreach (var g in groups)
{
WagonBatch batch = new WagonBatch();
float netto = transfers.Where(b => b.LotName == g.Key.ToString()).Sum(s => s.Brutto) - transfers.Where(b => b.LotName == g.Key.ToString()).Sum(s => s.Tare);
batch.LotName = g.Key.ToString();
batch.TransferTimeStamp = g.First().TransferTimeStamp;
batch.WagonQuantity = g.Count();
batch.FromDest = g.First().FromDest.LocationName;
batch.ToDest = g.First().ToDest;
batch.Item = g.First().Item.Name;
batch.Netto = netto;
batch.WagonAnalysisID = g.First().AnalysisID;
batch.WagonAnalysis = g.First().Analysis;
batches.Add(batch);
}
@ViewBag.Title = "Анализы для вагонных весов";
return(View(new WagonBatchView
{
WagonBatches = batches.ToPagedList(page, pagesize),
CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity),
CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity)
}));
}
public ActionResult Index(int page = 1)
{
string userName = User.Identity.Name ?? "";
int pagesize = 20;
var skips = EquipmentProvider.GetUserAuthorizedEquipment <Skip>(_cdb, User.Identity);
var skipsArray = skips.Select(x => x.ID).ToArray();
var transfers = _cdb.SkipTransfers.Where(t => skipsArray.Contains((int)t.EquipID))
.Where(d => d.TransferTimeStamp >= DbFunctions.AddDays(System.DateTime.Now, -2));
@ViewBag.Title = "Данные скиповых подъемов";
return(View(new SkipsAndTransfersModel
{
Skips = skips,
SkipTransfers = transfers.OrderByDescending(t => t.TransferTimeStamp).ToPagedList(page, pagesize),
Counters = new Dictionary <string, string>(),
CanEdit = CtsAuthorizeProvider.CanEditUser(User.Identity),
CanDelete = CtsAuthorizeProvider.CanDeleteUser(User.Identity)
}));
}