public DashboardViewModel Get(DashboardRequest request)
{
return new DashboardViewModel
{
Users = _userRepository.Query()
};
}
public IEnumerable <DashboardDetails> GetDashboardDetails(DashboardRequest dashboardReq)
{
_logger.LogInformation("GetDashboardDetails Initiated");
var parameter = new DynamicParameters();
parameter.Add("@UserId", dashboardReq.UserId);
parameter.Add("@RoleId", dashboardReq.RoleId);
parameter.Add("@Status", dashboardReq.Status);
var allObj = _unitOfWork.SP_Call.List <DashboardDetails>(SD.Proc_FBMGetDashboardDetails, parameter);
_logger.LogInformation("GetDashboardDetails Completed");
return(allObj.ToList());
}
public Task Dispatch(DashboardContext context)
{
DashboardRequest request = context.Request;
DashboardResponse response = context.Response;
if (!"POST".Equals(request.Method, StringComparison.OrdinalIgnoreCase))
{
response.StatusCode = 405;
return((Task)Task.FromResult <bool>(false));
}
this._command(context);
return((Task)Task.FromResult <bool>(true));
}
private List <Charts> llenarDashboard(string tipoDashboard, DashboardRequest filtro)
{
List <Charts> dataDashboard = new List <Charts>();
filtro.TipoDashboard = tipoDashboard;
dataDashboard.AddRange(dashboardService.Buscar(filtro).Result.Select(x => new Charts()
{
label = x.TipoPeriodicidad,
y = x.Valor
}));
return(dataDashboard);
}
private static void SetProperty(DashboardRequest request, PropertyInfo propertyInfo, ITaskParameters searchObject)
{
var value = Task.Run(() => request.GetFormValuesAsync(propertyInfo.Name)).Result.FirstOrDefault();
if (value == null)
{
return;
}
var propertyType = Nullable.GetUnderlyingType(propertyInfo.PropertyType) ??
propertyInfo.PropertyType;
var propertyValue = ConvertFromInvariantString(propertyType, value);
propertyInfo.SetValue(searchObject, propertyValue, null);
}
public virtual async Task <ActionResult> Update([FromRoute] int id, [FromBody] DashboardRequest request)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var result = await _dashboardsService.UpdateDashboardByIdAsync(request, id);
if (!result)
{
return(StatusCode(500));
}
return(NoContent());
}
public DashboardSummary ActivityGroup(DashboardRequest request)
{
var costCentreRoot = context.CostCentres.Find(request.CostCode);
IEnumerable <ActivityGroup> childGroups;
ActivityGroup[] activities;
var configuration = Configurations[request.Section];
if (request.ActivityGroupId == null)
{
activities = configuration
.ActivityIds
.Select(id => context.ActivityGroups.Find(id))
.ToArray();
var index = 1;
childGroups = activities.Select(a =>
{
a.OrderId = index * 100;
index++;
return(a);
});
}
else
{
var actvity = context.ActivityGroups.Find(request.ActivityGroupId);
activities = new[] { actvity };
childGroups = actvity.ChildGroups;
}
var slices = childGroups
.Select(a =>
new SliceDataModel
{
CentreNode = costCentreRoot.Node,
Color = a.Color,
CostCode = costCentreRoot.CostCode,
Description = a.Description,
OrderId = a.OrderId,
Title = a.Name,
ActivityGroupId = a.Id,
ActivityGroupNode = a.Node,
UomLong = a.UOMLong,
UomShort = a.UOMShort
}).ToArray();
return(CreateSummary(request, slices, activities, costCentreRoot));
}
public DashboardResponse ProcessDashboardRequest(DashboardRequest objRequest)
{
try
{
objDashboardResponse.DashboardType = objRequest.DashboardType;
objDashboardResponse.DashboardGrid = objclsDashboard.GetDashboard(objRequest.DashboardType, objRequest.DateTime);
return(objDashboardResponse);
}
catch (Exception)
{
return(objDashboardResponse);
}
finally
{
objDashboardResponse = null;
objclsDashboard = null;
}
}
public IEnumerable <CrumbNode> ActivityGroupChildren(DashboardRequest request)
{
var groupId = request.ActivityGroupId;
if (groupId == null)
{
var configuration = SliceService.Configurations[request.Section];
var nodes = configuration
.ActivityIds
.Select(id => context.ActivityGroups.Find(id))
.Select(@group => new CrumbNode(@group.Name, @group.Id, request.CostCode));
return(nodes);
}
return(context
.ActivityGroups
.Where(@group => @group.ParentGroupId == groupId)
.OrderBy(@group => @group.OrderId)
.ToArray()
.Select(@group => new CrumbNode(@group.Name, @group.Id, request.CostCode)));
}
public async Task Dispatch(DashboardContext context)
{
DashboardRequest request = context.Request;
DashboardResponse response = context.Response;
if (!"POST".Equals(request.Method, StringComparison.OrdinalIgnoreCase))
{
response.StatusCode = 405;
//return (Task)Task.FromResult<bool>(false);
}
if (await this._command(context))
{
response.ContentType = "application/json";
response.StatusCode = (int)HttpStatusCode.OK;
}
else
{
response.StatusCode = 422;
}
//return (Task)Task.FromResult<bool>(true);
}
private async void frmDashboard_Load(object sender, EventArgs e)
{
var counters = await _authService.GetCounters();
txtClients.Text = counters.NumberOfClients.ToString();
txtSuppliers.Text = counters.NumberOfSuppliers.ToString();
var requests = await _requestService.GetAll <List <Request> >();
txtRequests.Text = requests.Count.ToString();
var dashboardList = new List <DashboardRequest>();
foreach (var request in requests)
{
var user = await _authService.GetById(request.ClientId);
var fromAddress = await _addressService.GetById <Address>((int)user.AddressId);
var toAddress = await _addressService.GetById <Address>(request.DeliveryAddress);
var status = await _statusService.GetById <Status>(request.StatusId);
var dashboardRequest = new DashboardRequest
{
Client = user.FirstName + " " + user.LastName,
Date = request.Date,
From = fromAddress.City,
To = toAddress.City,
Price = request.Price.ToString() + " $",
Status = status.Name,
RequestId = request.RequestId
};
dashboardList.Add(dashboardRequest);
}
dgvRequests.DataSource = dashboardList;
}
public List <PartnerProfilesLatest> ExpressInterestSelectrequest([FromBody] DashboardRequest Dashboard)
{
return(this.IDashboardRequest.ExpressInterestSelectBal(Dashboard));
}
public IActionResult Create(DashboardRequest r) => Repo .Create(r.ToModel(ActualUser.Id)) .ToActionResult(x => ToCreateReply(x));
public List <PartnerProfilesLatest> ExpressInterestSelectBal(DashboardRequest dreq)
{
return(dashboard.ExpressInterestSelectDal(dreq));
}
public IEnumerable <CrumbNode> CostCentreTreeWalk(DashboardRequest request)
{
return(context
.CostCentreTreeWalk(request.CostCode)
.Select(centre => new CrumbNode(centre.Name, request.ActivityGroupId, centre.CostCode)));
}
public IActionResult Update(DashboardRequest r) => Repo .Update(r.ToModel(ActualUser.Id)) .Finalize(() => AlertManager.Reload()) .ToActionResult(x => ToCreateReply(x));
public DashboardSummary CostCentre(DashboardRequest request)
{
var activity = (request.ActivityGroupId == null)
? null
: context.ActivityGroups.Find(request.ActivityGroupId);
var costCentreRoot = context.CostCentres.Find(request.CostCode);
var slices = costCentreRoot
.ChildrenCostCentres
.Select(centre =>
{
var returnModel = new SliceDataModel
{
CentreNode = centre.Node,
Color = centre.Color,
CostCode = centre.CostCode,
Description = centre.Description,
OrderId = centre.OrderId,
Title = centre.Name
};
if (activity == null)
{
return(returnModel);
}
returnModel.ActivityGroupId = activity.Id;
returnModel.ActivityGroupNode = activity.Node;
returnModel.UomLong = activity.UOMLong;
returnModel.UomShort = activity.UOMShort;
return(returnModel);
}).ToArray();
if (!slices.Any())
{
slices = new[]
{
new SliceDataModel
{
CentreNode = costCentreRoot.Node,
Color = costCentreRoot.Color,
CostCode = costCentreRoot.CostCode,
Description = costCentreRoot.Description,
OrderId = costCentreRoot.OrderId,
Title = costCentreRoot.Name
}
};
if (activity != null)
{
slices[0].ActivityGroupId = activity.Id;
slices[0].ActivityGroupNode = activity.Node;
slices[0].UomLong = activity.UOMLong;
slices[0].UomShort = activity.UOMShort;
}
}
if (activity != null)
{
return(CreateSummary(request, slices, new[] { activity }, costCentreRoot));
}
var configuration = Configurations[request.Section];
var activities = configuration.ActivityIds.Select(guid => context.ActivityGroups.Find(guid)).ToArray();
return(CreateSummary(request, slices, activities, costCentreRoot));
}
public DashboardSummary CreateSummary(
DashboardRequest request,
SliceDataModel[] sliceData,
ActivityGroup[] activities,
CostCentre centre)
{
var configuration = Configurations[request.Section];
var uomLong = string.Empty;
var showCo2 = false;
var groupNodes = activities.Select(a => a.Node).ToArray();
var summary = new DashboardSummary
{
costCentre = centre.Name,
activityGroup = (request.ActivityGroupId == null)
? configuration.DisplayName
: activities[0].Name,
displayTotal = true
};
var slices = sliceData
.OrderBy(s => s.OrderId)
.Select(s =>
{
var slice = new SliceModel
{
activityGroupId = s.ActivityGroupId,
color = s.Color,
costCode = s.CostCode,
description = s.Description,
title = s.Title,
sliceId = CreateSliceId(s.ActivityGroupId, s.CostCode),
};
var noUnits =
(string.IsNullOrEmpty(s.UomShort)) ||
(string.IsNullOrEmpty(s.UomLong));
if (configuration.ShowCo2 || noUnits)
{
showCo2 = true;
slice.co2label = Constants.Constants.Co2LabelShort;
slice.amount = GetTotal(
TotalEmissions,
request.StartDate,
request.EndDate,
s.ActivityGroupNode,
s.CentreNode,
groupNodes) / 1000;
}
if (configuration.ShowCo2 && !noUnits)
{
slice.uom = s.UomShort;
slice.units = GetTotal(
TotalUnits,
request.StartDate,
request.EndDate,
s.ActivityGroupNode,
s.CentreNode,
groupNodes);
}
if (!configuration.ShowCo2 && !noUnits)
{
slice.co2label = s.UomShort;
uomLong = s.UomLong;
slice.amount = GetTotal(
TotalUnits,
request.StartDate,
request.EndDate,
s.ActivityGroupNode,
s.CentreNode,
groupNodes);
}
return(slice);
}).ToArray();
decimal lastYearTotal;
decimal totalAmount;
if (showCo2)
{
totalAmount = GetTotal(
TotalEmissions,
request.StartDate,
request.EndDate,
null,
centre.Node,
groupNodes) / 1000;
lastYearTotal = GetTotal(
TotalEmissions,
request.StartDate.AddYears(-1),
request.EndDate.AddYears(-1),
null,
centre.Node,
groupNodes) / 1000;
}
else
{
totalAmount = GetTotal(
TotalUnits,
request.StartDate,
request.EndDate,
null,
centre.Node,
groupNodes);
lastYearTotal = GetTotal(
TotalUnits,
request.StartDate.AddYears(-1),
request.EndDate.AddYears(-1),
null,
centre.Node,
groupNodes);
}
var yoy = (lastYearTotal == 0)
? 0
: ((totalAmount - lastYearTotal) / lastYearTotal) * 100;
var currencies = GetCurrencies(
request.StartDate,
request.EndDate,
groupNodes,
centre.Node);
summary.co2label = (showCo2)
? Constants.Constants.Co2LabelLong
: uomLong;
summary.currencies = currencies;
summary.slices = slices;
summary.total = totalAmount;
summary.yoy = yoy;
return(summary);
}
public void Handle(DashboardRequest message)
{
_manager.ShowWindow(new DashboardViewModel(u, _events));
TryClose();
}
public object Get(DashboardRequest request)
{
return(new Dashboard {
IsConnected = _dashboardAdapter.IsConnected
});
}
public virtual async Task <IHttpActionResult> ActivityGroup(DashboardRequest request)
{
var result = await Task.Run(() => service.ActivityGroupTreeWalk(request));
return(Ok(result));
}
public virtual async Task <IHttpActionResult> CostCentre(DashboardRequest request)
{
var result = await Task.Run(() => service.CostCentreTreeWalk(request));
return(Ok(result));
}
private DashboardSummary CreateSummary(DashboardRequest request)
{
return(request.Dimension == Dimension.ActivityGroup ? service.ActivityGroup(request) : service.CostCentre(request));
}
