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"); }