static XtraReport CreateSalesOrdersSummaryReport()
{
return(new SalesOrdersSummaryReport()
{
DataSource = QueriesHelper.GetSaleSummaries(DataProvider.OrderItems)
});
}
IList <QuoteMapItem> GetOpportunities(Stage stage, Expression <Func <Quote, bool> > filterExpression = null)
{
var unitOfWork = UnitOfWorkFactory.CreateUnitOfWork();
var quotes = unitOfWork.Quotes.GetFilteredEntities(filterExpression).ActualQuotes();
return(QueriesHelper.GetOpportunities(quotes, unitOfWork.Customers, stage).ToList());
}
public IList <QuoteMapItem> GetOpportunities(Stage stage, Expression <Func <Quote, bool> > filterExpression = null)
{
var unitOfWork = CreateUnitOfWork();
var quotes = unitOfWork.Quotes.GetFilteredEntities(filterExpression ?? FilterExpression);
var customers = unitOfWork.Customers;
return(QueriesHelper.GetOpportunities(quotes, customers, stage).ToList());
}
protected override void OnInitializeInRuntime()
{
base.OnInitializeInRuntime();
var unitOfWork = UnitOfWorkFactory.CreateUnitOfWork();
Sales = QueriesHelper.GetSales(unitOfWork.OrderItems);
SelectedSale = Sales[0];
AverageOrders = QueriesHelper.GetAverageOrders(unitOfWork.Orders.ActualOrders(), NumberOfAverageOrders);
}
List <IEnumerable <CostAverageItem> > GetCostAverageItems()
{
return(new List <IEnumerable <CostAverageItem> >()
{
QueriesHelper.GetCostAverageItems(unitOfWork.OrderItems, Period.ThisYear),
QueriesHelper.GetCostAverageItems(unitOfWork.OrderItems, Period.ThisMonth),
QueriesHelper.GetCostAverageItems(unitOfWork.OrderItems, Period.FixedDate, LastOrderDate(unitOfWork))
});
}
static XtraReport CreateCustomerSalesSummaryReport(long customerID)
{
var report = new CustomerSalesSummaryReport();
var customer = DataProvider.Customers.FirstOrDefault(c => c.Id == customerID);
if (customer != null)
{
report.DataSource = QueriesHelper.GetCustomerSaleOrderItemDetails(customer.Id, DataProvider.OrderItems);
}
return(report);
}
protected override void OnEntityChanged()
{
base.OnEntityChanged();
StatisticsViewModel.FilterTypeChanged -= StatisticsViewModel_FilterTypeChanged;
var addresses = new HashSet <Address>(QueriesHelper.GetDistinctStoresForPeriod(UnitOfWork.Orders, PrimaryKey).Where(x => x != null).Select(cs => cs.Address));
this.CitiesMapViewModel.Cities = CreateCities(addresses);
StatisticsViewModel.EntityId = PrimaryKey;
StatisticsViewModel.SelectedAddress = this.CitiesMapViewModel.Cities.FirstOrDefault();
StatisticsViewModel.FilterTypeChanged += StatisticsViewModel_FilterTypeChanged;
}
List <CityViewModel> CreateCities(HashSet <Address> addresses, Period period = Period.Lifetime)
{
var newCities = new List <CityViewModel>();
foreach (var city in addresses.Select(a => CityViewModel.Create(a, UnitOfWork)))
{
city.Sales = QueriesHelper.GetSaleMapItemsByCustomerAndCity(UnitOfWork.OrderItems, PrimaryKey, city.Address.City, period).GroupBy(mi => mi.Product).Select(gr => new SalesViewModel(gr.Key.Name, gr.CustomSum(mi => mi.Total)));
string address = city.Address.City;
if (!newCities.Any(c => c.Address.City == address))
{
newCities.Add(city);
}
}
return(newCities);
}
void DashboardInitialization()
{
SummaryOpportunities = QueriesHelper.GetSummaryOpportunities(unitOfWork.Quotes).ToList();
GoodSoldPeriodSelector = new ObservableCollection <bool>()
{
true, false, false
};
RevenuePeriodSelector = new ObservableCollection <bool>()
{
true, false, false
};
GoodSoldPeriodSelector.CollectionChanged += GoodSoldSelectorChanged;
RevenuePeriodSelector.CollectionChanged += RevenuesSelectorChanged;
salesSummaryItems = GetSalesSummaryItems();
costAverageItems = GetCostAverageItems();
DashboardOrders = QueriesHelper.GetOrderInfo(unitOfWork.Orders);
SalesSummarySelectedItem = salesSummaryItems[0].ToList();
CostSelectedItem = costAverageItems[0].ToList();
}
public IList <QueryResponse> FindModels()
{
Stack <ModelState> stack = new Stack <ModelState>();
var initialFluentValues = FluentsHelper.InitializeFluents(_extractionResult.Fluents.Count).ToList();
initialFluentValues.RemoveAll(
x => !ObservationHelper.ValidateModelWithObservation(x, 0, _extractionResult, _scenarioId));
_queryExecutors = QueriesHelper.CreateQueryExecutors(_queries, initialFluentValues, _scenarioId);
foreach (var fluents in initialFluentValues)
{
ProcessModel(new ModelState
{
Time = 0,
Fluents = fluents,
Action = null,
OcclussionFluents = null
}, stack);
stack.Clear();
}
return(_queryExecutors.Select(x => x.GetResponse()).ToList());
}
XtraReport CreateAndInitializeReport(CustomerReportType reportType)
{
var locator = GetService <Services.IReportLocator>();
var report = locator.GetReport(reportType) as XtraReport;
switch (reportType)
{
case CustomerReportType.SelectedContactDirectory:
report.DataSource = CollectionViewModel.SelectedEntity.Employees;
break;
case CustomerReportType.ContactDirectory:
report.DataSource = ViewModel.CustomerEmployees;
break;
case CustomerReportType.LocationsDirectory:
report.DataSource = CollectionViewModel.Entities;
break;
case CustomerReportType.SalesDetail:
var orders = QueriesHelper.GetCustomerSaleDetails(CollectionViewModel.SelectedEntityKey, CollectionViewModel.GetOrderItems());
//((CustomerSalesDetailReport)report).SetChartData(orders.SelectMany(x => x.OrderItems).ToArray());
report.DataSource = orders;
break;
case CustomerReportType.Profile:
report.DataSource = new List <Customer> {
CollectionViewModel.SelectedEntity
};
break;
case CustomerReportType.SalesSummary:
report.DataSource = QueriesHelper.GetCustomerSaleOrderItemDetails(CollectionViewModel.SelectedEntity.Id, CollectionViewModel.GetOrderItems());
break;
}
return(report);
}
public IEnumerable <object> UpdateMapItems(DateTime start, DateTime end)
{
IEnumerable <object> mapItems;
var items = Entity.Orders.Where(x => x.OrderDate >= start && x.OrderDate <= end).GroupBy <Order, CustomerStore>(order => order.Store);
if (items.Count() > 0)
{
decimal minimumSalesValue = items.Min <IGrouping <CustomerStore, Order> >(orders => orders.CustomSum(order => order.TotalAmount));
decimal maximumSalesValue = items.Max <IGrouping <CustomerStore, Order> >(orders => orders.CustomSum(order => order.TotalAmount));
decimal dif = maximumSalesValue - minimumSalesValue;
mapItems = items.Select(group => new {
Address = group.Key.Address,
TotalSales = group.CustomSum(order => order.TotalAmount),
TotalOpportunities = QueriesHelper.GetQuotesTotal(UnitOfWork.Quotes, group.Key, start, end),
AbsSize = dif > 0 ? (double)((group.CustomSum(order => order.TotalAmount) - minimumSalesValue) / dif) : 1.0
});
}
else
{
mapItems = Enumerable.Empty <object>();
}
SelectedItem = mapItems.LastOrDefault();
return(mapItems);
}
void StatisticsViewModel_FilterTypeChanged(object sender, PeriodEventArgs e)
{
var addresses = new HashSet <Address>(QueriesHelper.GetDistinctStoresForPeriod(UnitOfWork.Orders, PrimaryKey).Where(x => x != null).Select(cs => cs.Address));
this.CitiesMapViewModel.Cities = CreateCities(addresses, e.Period);
}
internal object GetQuoteInfos()
{
return(QueriesHelper.GetSummaryOpportunities(Entities.AsQueryable()).ToList());
}
public virtual void ShowRevenueAnalysisReport()
{
ShowDocument <OrderRevenueViewModel>("OrderRevenueView", new object[] {
QueriesHelper.GetRevenueAnalysisReportItems(CreateUnitOfWork().OrderItems, SelectedEntity.StoreId.Value), RevenueReportFormat.Analysis
});
}
public void ShowRevenueReport()
{
ShowDocument <OrderRevenueViewModel>("OrderRevenueView", new object[] {
QueriesHelper.GetRevenueReportItems(CreateUnitOfWork().OrderItems), RevenueReportFormat.Summary
});
}
internal IEnumerable <SaleSummaryInfo> GetSaleSummaryInfos()
{
return(QueriesHelper.GetSaleSummaries(CreateUnitOfWork().OrderItems));
}
protected override void OnEntitiesLoaded(DevAVDbDataModel.IDevAVDbUnitOfWork unitOfWork, IEnumerable <CustomerInfoWithSales> entities)
{
base.OnEntitiesLoaded(unitOfWork, entities);
QueriesHelper.UpdateCustomerInfoWithSales(entities, unitOfWork.CustomerStores, unitOfWork.CustomerEmployees, unitOfWork.Orders.ActualOrders());
}
public IEnumerable <CustomerStore> GetSalesStores(Period period = Period.Lifetime)
{
return(QueriesHelper.GetDistinctStoresForPeriod(UnitOfWork.Orders, Entity.Id, period));
}
public decimal GetQuotesTotal(CustomerStore store, DateTime begin, DateTime end)
{
return(QueriesHelper.GetQuotesTotal(UnitOfWork.Quotes.GetEntities(), store, begin, end));
}
public IEnumerable <DevAV.MapItem> GetSalesByCity(string city, Period period = Period.Lifetime)
{
return(QueriesHelper.GetSaleMapItemsByCustomerAndCity(UnitOfWork.OrderItems, Entity.Id, city, period));
}
protected override void OnEntitiesLoaded(IDevAVDbUnitOfWork unitOfWork, IEnumerable <ProductInfoWithSales> entities)
{
base.OnEntitiesLoaded(unitOfWork, entities);
QueriesHelper.UpdateMonthlySales(unitOfWork.OrderItems, entities);
}
private void GetDetails()
{
TextForQueries.Text = QueriesHelper.LoadFilesToList(ListWithQueries.Text);
}
private void Queries_Shown(object sender, EventArgs e)
{
ListWithQueries.DataSource = QueriesHelper.GetAllTextFiles();
}
void UpdateAverageQuotes()
{
AverageQuotes = QueriesHelper.GetAverageQuotes(CreateReadOnlyRepository().GetFilteredEntities(null), NumberOfAverageQuotes);
}
/// <summary>
/// Initializes a new instance of the QuoteCollectionViewModel class.
/// This constructor is declared protected to avoid undesired instantiation of the QuoteCollectionViewModel type without the POCO proxy factory.
/// </summary>
/// <param name="unitOfWorkFactory">A factory used to create a unit of work instance.</param>
protected QuoteCollectionViewModel(IUnitOfWorkFactory <IDevAVDbUnitOfWork> unitOfWorkFactory = null, UnitOfWorkPolicy unitOfWorkPolicy = UnitOfWorkPolicy.Individual)
: base(unitOfWorkFactory ?? UnitOfWorkSource.GetUnitOfWorkFactory(), x => x.Quotes, x => QueriesHelper.GetQuoteInfo(x))
{
}
/// <summary>
/// Initializes a new instance of the CustomerCollectionViewModel class.
/// This constructor is declared protected to avoid undesired instantiation of the CustomerCollectionViewModel type without the POCO proxy factory.
/// </summary>
/// <param name="unitOfWorkFactory">A factory used to create a unit of work instance.</param>
protected CustomerCollectionViewModel(IUnitOfWorkFactory <IDevAVDbUnitOfWork> unitOfWorkFactory = null)
: base(unitOfWorkFactory ?? UnitOfWorkSource.GetUnitOfWorkFactory(), x => x.Customers, query => QueriesHelper.GetCustomerInfo(query))
{
}
internal IEnumerable <SaleAnalisysInfo> GetSaleAnalisysInfos()
{
return(QueriesHelper.GetSaleAnalysis(CreateUnitOfWork().OrderItems));
}
/// <summary>
/// Initializes a new instance of the CustomerCollectionViewModel class.
/// This constructor is declared protected to avoid undesired instantiation of the CustomerCollectionViewModel type without the POCO proxy factory.
/// </summary>
/// <param name="unitOfWorkFactory">A factory used to create a unit of work instance.</param>
protected CustomerCollectionViewModel(IUnitOfWorkFactory <IDevAVDbUnitOfWork> unitOfWorkFactory = null, UnitOfWorkPolicy unitOfWorkPolicy = UnitOfWorkPolicy.Individual)
: base(unitOfWorkFactory ?? UnitOfWorkSource.GetUnitOfWorkFactory(), x => x.Customers, query => QueriesHelper.GetCustomerInfoWithSales(query), unitOfWorkPolicy: unitOfWorkPolicy)
{
}
public void PrintOrderSummaryReport()
{
ShowReport(ReportInfoFactory.CustomerSalesSummaryReport(QueriesHelper.GetCustomerSaleOrderItemDetails(SelectedEntity.Id, CreateUnitOfWork().OrderItems)), "SalesSummary");
}
