private void ReinitateLotteryServices()
{
processingLogStatusCtr = 0;
this.lotteryDataServices = new LotteryDataServices(this.lotteryDetails);
this.lotteryDataWorker = new LotteryDataWorker();
this.dashboardReport = new DashboardReport(this.lotteryDataServices);
this.dashboardReport.DashboardReportingEvents += DashboardReport_DashboardReportingEvents;
}
/// <summary>
/// Loads entire set of tiles.
/// </summary>
/// <param name="dashboardReport"></param>
private void LoadAndConfigureControls(DashboardReport dashboardReport)
{
this.DashboardTitle = dashboardReport.Name;
foreach (var tile in dashboardReport.Tiles)
{
this.CreateTile(tile);
}
}
public async Task <EntityShortRepresentation> CreateReportAsync(DashboardReport body, CancellationToken cancellationToken = default)
{
var result = await GetReportsUrl()
.PostJsonAsync(body, cancellationToken)
.ReceiveJsonWithErrorChecking <EntityShortRepresentation>()
.ConfigureAwait(false);
return(result);
}
public ModelsBuilderDashboardController(IOptions <ModelsBuilderSettings> config, ModelsGenerator modelsGenerator,
OutOfDateModelsStatus outOfDateModels, ModelsGenerationError mbErrors)
{
_config = config.Value;
_modelGenerator = modelsGenerator;
_outOfDateModels = outOfDateModels;
_mbErrors = mbErrors;
_dashboardReport = new DashboardReport(config, outOfDateModels, mbErrors);
}
public async Task <EntityShortRepresentation> UpdateReportAsync(string id, DashboardReport body, CancellationToken cancellationToken = default)
{
var result = await GetReportsUrl()
.AppendPathSegment(id)
.PutJsonAsync(body, cancellationToken)
.ReceiveJsonWithErrorChecking <EntityShortRepresentation>()
.ConfigureAwait(false);
return(result);
}
public object Any(DashboardReport request)
{
var result = new Dto <DashboardReport>();
var handler = new ReportHandler(Db, CurrentSession);
result.Result = request;
result.Result.Dispatched = handler.GetDispatchedInventory(request.StartDate, request.EndDate, request.GroupBy);
result.Result.Received = handler.GetReceivedInventory(request.StartDate, request.EndDate, request.GroupBy);
result.Result.Sales = handler.GetSalesByTotal(request.StartDate, request.EndDate, request.GroupBy);
return(result);
}
public ActionResult Index()
{
var db = new DashboardAppEntities();
var dashboardReport = new DashboardReport
{
//NewComments = db.Comments.Count(),
//NewTasks = db.Tasks.Count(),
//NewOrders = db.Orders.Count(),
//SupportTickets = db.SupportTickets.Count()
};
ViewBag.Title = "Home";
return(View(dashboardReport));
}
public DashboardReport GetDashboardReport()
{
var report = new DashboardReport
{
GeneratedDate = DateTime.Now,
AssetsByCategoryData = new List <int>(),
AssetsByCategoryLabels = new List <string>(),
ThreatsByCategoryData = new List <int>(),
ThreatsByCategoryLabels = new List <string>(),
ProcessesByCategoryData = new List <int>(),
ProcessesByCategoryLabels = new List <string>()
};
using (var db = new RAAPEntities(GetConnectionString()))
{
var allAssets = db.Assets.Include("AssetSubCategory").ToArray();
// assets by category
var assetsByCategory = allAssets.GroupBy(a => a.AssetSubCategory.Name).ToArray();
report.AssetsByCategoryLabels = assetsByCategory.Select(a => a.Key).ToList();
report.AssetsByCategoryData = assetsByCategory.Select(a => a.Count()).ToList();
var allProcesses = db.Processes.Include("ProcessCategory").ToArray();
// processes by category
var processesByCategory = allProcesses.GroupBy(a => a.ProcessCategory.Name).ToArray();
report.ProcessesByCategoryLabels = processesByCategory.Select(a => a.Key).ToList();
report.ProcessesByCategoryData = processesByCategory.Select(a => a.Count()).ToList();
var allThreats = db.Threats.Include("ThreatCategory").ToArray();
// threats by category
var threatsByCategory = allThreats.GroupBy(a => a.ThreatCategory.Name).ToArray();
report.ThreatsByCategoryLabels = threatsByCategory.Select(a => a.Key).ToList();
report.ThreatsByCategoryData = threatsByCategory.Select(a => a.Count()).ToList();
}
return(report);
}
public ActionResult Index()
{
try
{
var db = new DashboardAppEntities();
var dashboardReport = new DashboardReport
{
NewComments = db.Comments.Count(),
NewTasks = db.Tasks.Count(),
NewOrders = db.Orders.Count(),
SupportTickets = db.SupportTickets.Count()
};
ViewBag.Title = "Home";
return(View(dashboardReport));
}
catch (Exception ex)
{
System.Diagnostics.Trace.TraceError("If you're seeing this, something bad happened {0}", ex);
throw ex;
}
}
public DashboardReport GetDashboardReport(DashboardParameters para)
{
IQueryable <TransactionLog> result = _db.TransactionLogs;
if (para.Plant != "All")
{
result = result.Where(p => p.PlantId == para.Plant);
}
if (para.FillingMachine != "All")
{
result = result.Where(p => p.MachineName == para.FillingMachine);
}
if (para.ProductCode != "All")
{
result = result.Where(p => p.ProductCode == para.ProductCode);
}
if (para.Duration == 0)
{
DateTime dateTimeFrom = DateHelper.StartOfDay(DateTime.Now).ToUniversalTime();
DateTime dateTimeTo = DateHelper.EndOfDay(DateTime.Now).ToUniversalTime();
result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo));
}
else
{
DateTime start = DateHelper.StartDate(para.Duration);
DateTime end = DateHelper.EndDate(para.Duration);
DateTime dateTimeFrom = DateHelper.StartOfDay(start).ToUniversalTime();
DateTime dateTimeTo = DateHelper.EndOfDay(end).ToUniversalTime();
result = result.Where(p => (p.TransactionDate >= dateTimeFrom && p.TransactionDate <= dateTimeTo));
}
///.Where(p => (p.TransactionDate >= para.DateFrom && p.TransactionDate <= para.DateTo))
var data = result
.Where(p => p.ClientId == para.ClientId)
.GroupBy(p => p.ProductCode)
.Select(s => new DashboardReport
{
Units = s.Count(),
RequiredWeight = s.Sum(p => p.TargetWeight),
ActualWeight = s.Sum(p => p.ActualWeight),
AverageWeight = s.Average(p => p.ActualWeight),
PercDiffWeight = ((s.Sum(p => p.ActualWeight) - s.Sum(p => p.TargetWeight)) / s.Sum(p => p.TargetWeight)) * 100,
AverageFillTime = s.Average(p => p.ActualFillTime)
}).FirstOrDefault();
if (data == null)
{
data = new DashboardReport
{
Units = 0,
RequiredWeight = 0,
ActualWeight = 0,
AverageWeight = 0,
PercDiffWeight = 0,
AverageFillTime = 0
};
}
return((DashboardReport)data);
}
