public async Task <IActionResult> GetSummary()
{
DashboardSummaryViewModel dashboardSummary = new DashboardSummaryViewModel();
try
{
string userId = HttpContext.Session.GetString(SessionHelper.USER_ID);
string userRole = HttpContext.Session.GetString(SessionHelper.ROLES);
string userDept = HttpContext.Session.GetString(SessionHelper.USER_DEPT);
//todo: make method GetSummaryOfField(fieldId, userRole, userDept) instead of multiple methods for each field
dashboardSummary.DataSet = _mapper.Map <SummaryItemViewModel>(await _queryService.GetSummaryOfDataSet(userRole, userDept));
dashboardSummary.Storage = _mapper.Map <SummaryItemViewModel>(await _queryService.GetSummaryOfStorage(userRole, userDept));
dashboardSummary.ExternalParty = _mapper.Map <SummaryItemViewModel>(await _queryService.GetSummaryOfExternalParty(userRole, userDept));
dashboardSummary.Issue = _mapper.Map <SummaryItemViewModel>(await _queryService.GetSummaryOfDatasetIssue(userRole, userDept));
}
catch (Exception e)
{
_logger.LogError("Error calling GetSummary: {0}", e.Message);
}
return(Json(new
{
data = dashboardSummary
}));
}
public IList <Order> FilterResult(IList <Order> orders, DashboardSummaryViewModel model)
{
IList <Order> result = orders;
//if (model.dateFrom == default && model.dateTo == default)
result = orders.Where(o => o.CreateData >= model.DateFrom && o.CreateData <= model.DateTo).ToList();
if (Successor != null)
{
return(Successor.FilterResult(result, model));
}
return(result);
}
public IList <Order> FilterResult(IList <Order> orders, DashboardSummaryViewModel model)
{
IList <Order> result = orders;
if (model.OrderID != 0)
{
result = orders.Where(o => o.Id == model.OrderID).ToList();
}
if (Successor != null)
{
return(Successor.FilterResult(result, model));
}
return(result);
}
public DashboardSummaryViewModel GetDashboardSummary()
{
DateTime monthFirstDate = DateTime.Today.AddDays(1 - DateTime.Today.Day);
var query = from o in m_ContentContext.Order_Heads
where o.OrderDate > monthFirstDate
select o;
var summary = new DashboardSummaryViewModel();
summary.MonthlyOrder = query.Count();
summary.MonthlyPayment = query.Select(s => (decimal?)s.GrandTotal).Sum(s => s).GetValueOrDefault();
summary.DailyOrder = query.Where(w => w.OrderDate > DateTime.Today).Count();
summary.DailyPayment = query.Where(w => w.OrderDate > DateTime.Today).Select(s => (decimal?)s.GrandTotal).Sum(s => s).GetValueOrDefault();
return(summary);
}
public IList <Order> FilterResult(IList <Order> orders, DashboardSummaryViewModel model)
{
IList <Order> result = orders;
if (model.Event != "0")
{
result = orders.Where(o => o.OrderDetails.Any(o => o.EventID.ToString() == model.Event)).ToList(); //Sprawdzic co jest w modelu? czy w Evencie jest tylko ID?
}
if (Successor != null)
{
return(Successor.FilterResult(result, model));
}
return(result);
}
public IList <Order> FilterResult(IList <Order> orders, DashboardSummaryViewModel model)
{
IList <Order> result = orders;
if (!string.IsNullOrWhiteSpace(model.Name))
{
result = orders.Where(o => o.OrderUser.Name.ToUpper().Contains(model.Name.ToUpper())).ToList();
}
if (Successor != null)
{
return(Successor.FilterResult(result, model));
}
return(result);
}
public IList <Order> FilterResult(IList <Order> orders, DashboardSummaryViewModel model)
{
var pageSize = int.Parse(model.PageSize);
IList <Order> result = orders;
if (model.PageSize != "1")
{
result = orders.Skip((model.Page - 1) * pageSize).Take(pageSize).ToList();
}
if (Successor != null)
{
return(Successor.FilterResult(result, model));
}
return(result);
}
public async Task <IActionResult> Index(DashboardSummaryViewModel model, int page)
{
//if (page == 1 && page != model.Page)
// page = model.Page;
if (page < 1)
{
page = 1;
}
model.Page = page;
ViewBag.Active = Tabs.Dashboard;
var events = await _eventService.ListAsync();
var orderFilter = new LastNameOrderFilter(new OrderCityFilter(new OrderDateFilter(new OrderEventFilter(new OrderNameFilter(null)))));
var idFilter = new OrderIdFilter(null);
var eventList = events.Select(e => new SelectListItem()
{
Text = e.Title, Value = e.Id.ToString()
}).ToList();
eventList.Add(new SelectListItem {
Text = "Wszystkie", Value = "0"
});
var pageSizes = new List <SelectListItem> {
new SelectListItem {
Text = "5", Value = "5"
},
new SelectListItem {
Text = "10", Value = "10"
},
new SelectListItem {
Text = "25", Value = "25"
},
new SelectListItem {
Text = "50", Value = "50"
},
new SelectListItem {
Text = "Wszystkie", Value = "1"
},
};
if (model.PageSize == "0")
{
model.PageSize = "10";
}
if (User.IsInRole("Admin"))
{
var summaryViewModel = new DashboardSummaryViewModel()
{
PageSize = model.PageSize,
PageSizes = pageSizes,
Events = eventList,
Orders = model.OrderID != 0 ? idFilter.FilterResult(await _orderService.GetSummaryOrders(), model) : orderFilter.FilterResult(await _orderService.GetSummaryOrders(), model)
};
ViewBag.Page = page;
ViewBag.PagesMax = summaryViewModel.PageSize == "1" ? 1 : Math.Ceiling((double)summaryViewModel.Orders.Count / double.Parse(summaryViewModel.PageSize));
var pageFilter = new OrderPageSizeFilter(null);
if (model.OrderID == 0)
{
summaryViewModel.Orders = pageFilter.FilterResult(summaryViewModel.Orders, model);
}
summaryViewModel.Page = page;
return(View(summaryViewModel));
}
return(RedirectToAction("UserIndex"));
}
