public async Task ExecuteLoadSeedDataCommand(Account account)
{
if (IsBusy)
{
return;
}
IsBusy = true;
if (!_DataClient.IsSeeded)
{
await _DataClient.SeedLocalDataAsync();
}
Orders.Clear();
Orders.AddRange((await _DataClient.GetAllOrdersAsync()).Where(x => x.AccountId == account.Id));
WeeklySalesChartDataPoints.Clear();
WeeklySalesChartDataPoints.AddRange((await _ChartDataService.GetWeeklySalesDataPointsAsync(Orders)).OrderBy(x => x.DateStart).Select(x => new ChartDataPoint(FormatDateRange(x.DateStart, x.DateEnd), x.Amount)));
var weeklyTotal = WeeklySalesChartDataPoints.Sum(x => x.YValue);
CategorySalesChartDataPoints.Clear();
CategorySalesChartDataPoints.AddRange((await _ChartDataService.GetCategorySalesDataPointsAsync(Orders)).Select(x => new ChartDataPoint(x.Key, x.Sum(y => y.Amount))).OrderBy(x => x.XValue));
var categoriesTotal = CategorySalesChartDataPoints.Sum(x => x.YValue);
WeeklySalesAverage = String.Format("{0:C}", WeeklySalesChartDataPoints.Average(x => x.YValue));
IsBusy = false;
}
public Database()
{
Customers.AddRange(new []
{
new Customer(1, "Mike"),
new Customer(2, "John"),
new Customer(3, "Bob"),
new Customer(4, "Nick"),
});
Products.AddRange(new []
{
new Product(1, "Phone", 500),
new Product(2, "Notebook", 1000),
new Product(3, "PC", 1500),
new Product(4, "XBox", 800),
});
Orders.AddRange(new []
{
new Order(1, 1, 1),
new Order(2, 1, 1),
new Order(3, 4, 1),
new Order(4, 2, 2),
new Order(5, 3, 2),
new Order(6, 4, 2),
new Order(7, 1, 3),
new Order(8, 2, 3),
new Order(9, 3, 3),
new Order(10, 3, 3),
new Order(11, 2, 4),
new Order(12, 3, 4),
new Order(13, 4, 4),
});
}
public void CancelSelectedOrders()
{
var selectedOrders = SelectedTicket.SelectedOrders.ToList();
ClearSelectedOrders();
SelectedTicket.CancelOrders(selectedOrders);
Orders.Clear();
Orders.AddRange(SelectedTicket.Orders.Select(x => new OrderViewModel(x, _cacheService, _applicationState)));
}
public void CancelSelectedOrders()
{
var selectedOrders = SelectedTicket.SelectedOrders.ToList();
ClearSelectedOrders();
SelectedTicket.CancelOrders(selectedOrders);
Orders.Clear();
Orders.AddRange(SelectedTicket.Orders.Select(x => new OrderViewModel(x)));
}
public void Handle(CustomerChangedMessage message)
{
Orders.Clear();
if (message.Customer != null && !string.IsNullOrEmpty(message.Customer.CustomerID))
{
var ticket = BusyWatcher.GetTicket();
Task.Factory.StartNew(() => Orders.AddRange(_repository.GetOrdersFromCustomer(message.Customer.CustomerID))).ContinueWith((x) => ticket.Dispose());
OrderDetails = string.Format("Order Details for customer {0}", message.Customer.ContactName);
}
}
private async Task loadOrders()
{
Orders.Clear();
if (SelectedStation == null)
{
_eventAggregator.PublishOnUIThread(new StatusEvent(this, "No Station Selected"));
return;
}
MarketTypes = await _orderManagerService.GetMarketTypesAsync().ConfigureAwait(false);
var orders = await _orderManagerService.GetOrdersAsync(SelectedStation.StationId).ConfigureAwait(false);
Orders.AddRange(orders);
}
private void LoadOrdersCommandHandler(object sender)
{
this.IsEnabled = false;
StatusText = "Loading Orders......";
this.Dispatcher.BeginInvoke(new Action(() =>
{
bool canLoadMoreOrders = false;
var orders = DbOrder.GetBumpedOrders(_skipCount, ChefmateController.Instance.CurrentSettings.RecallCount, ref canLoadMoreOrders);
CanLoadMoreOrders = canLoadMoreOrders;
_skipCount += ChefmateController.Instance.CurrentSettings.RecallCount;
Orders.AddRange(orders);
this.IsEnabled = true;
StatusText = "";
}));
}
public Customer(string id, string name, string address, string city,
string postalcode, string country, string phone, string fax, List <Order> orders = null)
{
Id = id ?? "";
Name = name ?? "";
Address = address ?? "";
City = city ?? "";
Postalcode = postalcode ?? "";
Country = country ?? "";
Phone = phone ?? "";
Fax = fax ?? "";
if (orders != null)
{
Orders.AddRange(orders);
}
}
private async void executeImportXml()
{
var dialog = new FolderBrowserDialog();
dialog.ShowNewFolderButton = false;
dialog.SelectedPath = Properties.Settings.Default.OrderXmlPath;
if (dialog.ShowDialog() == DialogResult.OK)
{
ICollection <Order> orders = _orderXmlService.ImportOrders(dialog.SelectedPath);
orders.ForEach(f => f.StationId = SelectedStation.StationId);
Orders.Clear();
await _orderManagerService.LoadInvTypes(orders);
Orders.AddRange(orders.Select(order => new OrderVm(order)));
Properties.Settings.Default.OrderXmlPath = dialog.SelectedPath;
Properties.Settings.Default.Save();
}
_eventAggregator.PublishOnUIThread(new StatusEvent(this, "Order(s) imported"));
}
/// <summary>
/// Initializes a new instance of the <see cref="DetachedFlowQuery{TSource}" /> class.
/// </summary>
/// <param name="criteriaFactory">
/// The criteria factory.
/// </param>
/// <param name="alias">
/// The alias.
/// </param>
/// <param name="options">
/// The options.
/// </param>
/// <param name="query">
/// The query.
/// </param>
protected internal DetachedFlowQuery
(
Func <Type, string, ICriteria> criteriaFactory,
string alias = null,
FlowQueryOptions options = null,
IMorphableFlowQuery query = null
)
: base(criteriaFactory, alias, options, query)
{
if (Constructor != null)
{
if (Orders.Any(x => !x.IsBasedOnSource))
{
var newOrders = OrderHelper.GetSourceBasedOrdersFrom(Orders.ToArray(), Constructor, Data);
Orders.Clear();
Orders.AddRange(newOrders);
}
}
}
protected override async Task LoadMoreContent()
{
if (Loading || LoadingMore)
{
return;
}
LoadingMore = true;
var dataSource = await VmService.LoadHistoryOrders(LOADING_ORDERS_COUNT, offset : Orders.Count);
CanLoadMore = !dataSource.IsNullOrEmpty() && dataSource.Count == LOADING_ORDERS_COUNT;
LoadMoreCommand.RaiseCanExecuteChanged();
InvokeOnMainThread(() =>
{
Orders.AddRange(dataSource);
});
LoadingMore = false;
}
public async Task ExecuteLoadSeedDataCommand(Account account)
{
if (IsBusy)
{
return;
}
IsBusy = true;
await _CustomerDataClient.SeedDataAsync();
Orders.Clear();
Orders.AddRange((await _CustomerDataClient.GetAllOrdersAsync()).Where(x => x.AccountId == account.Id));
WeeklySalesChartDataPoints.Clear();
WeeklySalesChartDataPoints.AddRange((await _ChartDataService.GetWeeklySalesDataPointsAsync(Orders)).OrderBy(x => x.DateStart).Select(x => new ChartDataPoint(x.DateStart.ToString("d MMM"), x.Amount)));
CategorySalesChartDataPoints.Clear();
CategorySalesChartDataPoints.AddRange((await _ChartDataService.GetCategorySalesDataPointsAsync(Orders, _Account)).OrderBy(x => x.XValue));
WeeklySalesAverage = String.Format("{0:C}", WeeklySalesChartDataPoints.Average(x => x.YValue));
IsBusy = false;
}
public async void Handle(AddOrdersEvent e)
{
await Activate().ConfigureAwait(false);
var orders = new List <Order>();
foreach (InvType item in e.Items)
{
var order = new Order();
order.AutoProcess = true;
order.TypeId = item.TypeId;
order.InvType = item;
order.IsBuyOrder = e.BuyOrder;
order.IsSellOrder = e.SellOrder;
item.Orders.Add(order);
orders.Add(order);
}
var orderViewModels = orders.Select(f => new OrderVm(f)).ToList();
await _orderManagerService.LoadMarketDataAsync(orderViewModels, SelectedRegion, SelectedStation, DayLimit);
Orders.AddRange(orderViewModels);
SelectedOrders.Clear();
SelectedOrders.AddRange(orders.Select(order => new OrderVm(order)));
SelectedOrder = Orders.Last();
FocusedOrder = SelectedOrder;
_eventAggregator.PublishOnUIThread(new OrdersChangedEventArgs {
Added = orders
});
string msg = "Order(s) added";
if (orders.Count == 1)
{
msg = "'" + orders.Single().InvType.TypeName + "' added to Orders";
}
_eventAggregator.PublishOnUIThread(new StatusEvent(this, msg));
}
protected override void InternalRender(HtmlTextWriter writer)
{
writer.AddAttribute(HtmlTextWriterAttribute.Class, "search");
writer.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "2");
writer.AddAttribute(HtmlTextWriterAttribute.Width, "auto");
string hint = GetHint();
if (hint != String.Empty)
{
writer.AddAttribute(HtmlTextWriterAttribute.Title, hint, true);
}
writer.RenderBeginTag(HtmlTextWriterTag.Table);
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
bool first = true;
foreach (SearchControl control in _searchControls)
{
if (first)
{
first = false;
}
else
{
/*
* writer.AddAttribute(HtmlTextWriterAttribute.Valign, "middle");
* writer.RenderBeginTag(HtmlTextWriterTag.Td);
* writer.AddAttribute(HtmlTextWriterAttribute.Src, "images/searcharrow.gif");
* writer.AddAttribute(HtmlTextWriterAttribute.Class, "searcharrow");
* writer.AddAttribute(HtmlTextWriterAttribute.Width, "16");
* writer.AddAttribute(HtmlTextWriterAttribute.Height, "10");
* writer.AddAttribute(HtmlTextWriterAttribute.Border, "0");
* writer.RenderBeginTag(HtmlTextWriterTag.Img);
* writer.RenderEndTag();// IMG
* writer.RenderEndTag();// TD
*/
}
writer.AddAttribute(HtmlTextWriterAttribute.Valign, "middle");
writer.AddAttribute(HtmlTextWriterAttribute.Nowrap, null);
writer.RenderBeginTag(HtmlTextWriterTag.Td);
{
if (_titleAlignment != TitleAlignment.None)
{
writer.Write(HttpUtility.HtmlEncode(Session.RemoveAccellerator(control.GetTitle())));
if (_titleAlignment != TitleAlignment.Top)
{
Session.RenderDummyImage(writer, "10px", "0");
}
}
if (_titleAlignment == TitleAlignment.Top)
{
writer.Write("<br>");
}
control.Render(writer);
}
writer.RenderEndTag();//TD
}
writer.AddAttribute(HtmlTextWriterAttribute.Align, "right");
writer.AddAttribute(HtmlTextWriterAttribute.Valign, "middle");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
Session.RenderDummyImage(writer, "5", "1");
writer.AddAttribute(HtmlTextWriterAttribute.Type, "button");
writer.AddAttribute(HtmlTextWriterAttribute.Valign, "top");
writer.AddAttribute(HtmlTextWriterAttribute.Value, Strings.Get("FindButtonText"));
writer.AddAttribute(HtmlTextWriterAttribute.Class, "trigger");
writer.AddAttribute(HtmlTextWriterAttribute.Onclick, Session.GetActionLink(Session.Get(this).Context, ID + "Search"));
writer.RenderBeginTag(HtmlTextWriterTag.Input);
writer.RenderEndTag(); // INPUT
Session.RenderDummyImage(writer, "5", "1");
writer.RenderEndTag(); // TD
writer.AddAttribute(HtmlTextWriterAttribute.Valign, "middle");
writer.AddAttribute(HtmlTextWriterAttribute.Align, "right");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
{
writer.AddAttribute(HtmlTextWriterAttribute.Class, "lookup");
writer.AddAttribute(HtmlTextWriterAttribute.Src, "images/lookup.png");
writer.AddAttribute(HtmlTextWriterAttribute.Onclick, "ShowDropDown('" + ID + "SearchBy', GetParentTable(this))", true);
writer.RenderBeginTag(HtmlTextWriterTag.Img);
writer.RenderEndTag();
}
Session.RenderDummyImage(writer, "5", "1");
writer.RenderEndTag(); // TD
writer.RenderEndTag(); // TR
writer.RenderEndTag(); // TABLE
// Render search-by drop-down
if (Source != null)
{
writer.AddAttribute(HtmlTextWriterAttribute.Class, "searchby");
writer.AddAttribute(HtmlTextWriterAttribute.Style, "display: none");
writer.AddAttribute(HtmlTextWriterAttribute.Id, ID + "SearchBy");
writer.RenderBeginTag(HtmlTextWriterTag.Div);
writer.AddAttribute(HtmlTextWriterAttribute.Cellpadding, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Cellspacing, "0");
writer.AddAttribute(HtmlTextWriterAttribute.Border, "0");
writer.RenderBeginTag(HtmlTextWriterTag.Table);
// Construct the a complete list of possible orderings including non-sparse keys
Orders orders = new Orders();
orders.AddRange(Source.TableVar.Orders);
DAE.Schema.Order orderForKey;
foreach (Key key in Source.TableVar.Keys)
{
if (!key.IsSparse)
{
orderForKey = new Order(key);
if (!orders.Contains(orderForKey))
{
orders.Add(orderForKey);
}
}
}
foreach (Order order in orders)
{
if (IsOrderVisible(order) && !order.Equals(Source.Order))
{
writer.AddAttribute(HtmlTextWriterAttribute.Onclick, String.Format("Submit('{0}?ActionID={1}&Sort={2}',event)", (string)Session.Get(this).Context.Session["DefaultPage"], ID + "SortBy", HttpUtility.UrlEncode(order.ToString())), true);
writer.RenderBeginTag(HtmlTextWriterTag.Tr);
writer.AddAttribute("onmouseover", @"className='highlightedmenuitem'");
writer.AddAttribute("onmouseout", @"className=''");
writer.RenderBeginTag(HtmlTextWriterTag.Td);
writer.Write(HttpUtility.HtmlEncode(GetOrderTitle(order)));
writer.RenderEndTag(); // TD
writer.RenderEndTag(); // TR
}
}
writer.RenderEndTag(); // TABLE
writer.RenderEndTag(); // DIV
}
}
public DataContext(DbContextOptions <DataContext> options) : base(options)
{
List <Customer> customers = new List <Customer>
{
new Customer
{
CustomerId = Guid.Parse("D066AFA6-1F64-4EBC-9EBD-71CE77C86171"),
Name = "Bob Smith",
Orders = new List <Order>
{
new Order
{
OrderId = Guid.Parse("690114E8-1107-492A-BEDD-19F3137757D2"),
Name = "Order One",
CustomerId = Guid.Parse("D066AFA6-1F64-4EBC-9EBD-71CE77C86171"),
OrderItems = new List <OrderItem>
{
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 1",
OrderId = Guid.Parse("690114E8-1107-492A-BEDD-19F3137757D2")
},
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 2",
OrderId = Guid.Parse("690114E8-1107-492A-BEDD-19F3137757D2")
}
}
},
new Order
{
OrderId = Guid.Parse("25E82EC3-F544-4F9D-B102-31C9EBBB2C60"),
Name = "Order Two",
CustomerId = Guid.Parse("D066AFA6-1F64-4EBC-9EBD-71CE77C86171"),
OrderItems = new List <OrderItem>
{
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 1",
OrderId = Guid.Parse("25E82EC3-F544-4F9D-B102-31C9EBBB2C60")
},
new OrderItem
{
OrderItemId = Guid.NewGuid(),
Product = "Product 2",
OrderId = Guid.Parse("25E82EC3-F544-4F9D-B102-31C9EBBB2C60")
}
}
}
}
},
new Customer
{
CustomerId = Guid.Parse("CD5C3E08-76B9-4B51-B913-253CC16EF37C"), Name = "Jane Dough"
}
};
Customers.AddRange(customers);
Orders.AddRange(customers.SelectMany(c => c.Orders));
OrderItems.AddRange(customers.SelectMany(customer => customer.Orders)
.SelectMany(order => order.OrderItems));
SaveChanges();
}
public void Init()
{
if (Items.Any())
{
return;
}
var items = new[]
{
new Item {
MinimumAmount = 10, Name = "Eggs", Units = "Dozen"
},
new Item {
MinimumAmount = 15, Name = "Milk", Units = "Gallons"
},
new Item {
MinimumAmount = 20, Name = "Flour", Units = "Lbs"
},
new Item {
MinimumAmount = 5, Name = "Syrup", Units = "Gallons"
},
new Item {
MinimumAmount = 2, Name = "Chocolate", Units = "Lbs"
},
new Item {
MinimumAmount = 25, Name = "Strawberries", Units = "Bunches"
},
new Item {
MinimumAmount = 3, Name = "Ice Cream", Units = "Gallons"
},
new Item {
MinimumAmount = 10, Name = "Sugar", Units = "Lbs"
},
new Item {
MinimumAmount = 4, Name = "Corn Syrup", Units = "Gallons"
},
new Item {
MinimumAmount = 5, Name = "Sugar (Powdered)", Units = "Lbs"
},
new Item {
MinimumAmount = 10, Name = "Salt", Units = "Oz"
}
};
var vendors = new[]
{
new Vendor
{
City = "Sacramento",
Name = "Costco",
Country = "United States",
Phone = "123-456-7890",
State = "CA",
StreetAddress = "1000 J St.",
ZipCode = "93103"
},
new Vendor
{
City = "San Fransisco",
Name = "USA Food",
Country = "United States",
Phone = "123-666-7890",
State = "CA",
StreetAddress = "1300 Main St.",
ZipCode = "90043"
},
new Vendor
{
City = "Sacramento",
Name = "Whole Foods",
Country = "United States",
Phone = "555-456-0987",
State = "CA",
StreetAddress = "100 H St.",
ZipCode = "93103"
}
};
var orders = new[]
{
new Order {
Status = OrderStatus.None, OrderDate = DateTime.Now
},
new Order {
Status = OrderStatus.Approved, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(1))
},
new Order {
Status = OrderStatus.Approved, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(2))
},
new Order {
Status = OrderStatus.Denied, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(3))
},
new Order {
Status = OrderStatus.Fulfilled, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(4))
},
new Order {
Status = OrderStatus.Denied, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(5))
},
new Order {
Status = OrderStatus.Fulfilled, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(6))
},
new Order {
Status = OrderStatus.Approved, OrderDate = DateTime.Now.Subtract(TimeSpan.FromDays(7))
}
};
// Add dummy rows
Items.AddRange(items);
Vendors.AddRange(vendors);
Orders.AddRange(orders);
SaveChanges();
// Go ahead and add the items to each vendor and such
var dbItems = Items.ToList();
var dbVendors = Vendors.ToList();
var dbOrders = Orders.ToList();
var products = new List <Product>();
for (var i = 0; i < dbItems.Count; ++i)
{
products.AddRange(from v in dbVendors.Where((x, ij) => ij % 10 != 0 || i % 2 == 0)
let pkgAmt = Random.Next(6, 24)
let price = Random.Next(25, 200) * pkgAmt
let sku = Guid.NewGuid().ToString()
select
new Product {
Item = dbItems[i], Vendor = v, PackageAmount = pkgAmt, Price = price, SKU = sku
});
}
var orderItems = new List <OrderItem>();
foreach (var t in dbOrders)
{
orderItems.AddRange(from t1 in dbItems
select products.OrderBy(x => Guid.NewGuid()).First(x => x.Item == t1)
into randProd
let orderAmt = Random.Next(1, 4)
let paid = orderAmt * randProd.Price
let totalAmt = orderAmt * randProd.PackageAmount
select new OrderItem
{
Item = randProd.Item,
ItemId = randProd.Item.ItemId,
Vendor = randProd.Vendor,
VendorId = randProd.Vendor.VendorId,
Order = t,
OrderId = t.OrderId,
OrderAmount = orderAmt,
PaidPrice = (int)Math.Ceiling((double)paid),
TotalAmount = (int)Math.Ceiling(totalAmt)
});
}
var q =
orderItems.GroupBy(x => new { x.Item, x.Order, x.Vendor })
.Where(g => g.Count() > 1)
.Select(y => y.Key)
.ToList();
foreach (var k in q)
{
Console.WriteLine($"Order {k.Order.OrderId} Name {k.Item.Name} Vendor {k.Vendor.Name}");
}
var newestFulfilledOrder = orders.OrderBy(x => x.OrderDate).First(x => x.Status == OrderStatus.Fulfilled);
var stocks = (
from oi in orderItems
where oi.OrderId == newestFulfilledOrder.OrderId
let prod = products.First(x => x.Item == oi.Item && x.Vendor == oi.Vendor)
select new Stock
{
Amount = oi.OrderAmount * prod.PackageAmount,
Item = oi.Item,
ItemId = oi.ItemId,
Vendor = oi.Vendor,
VendorId = oi.VendorId
}).ToList();
var shelfNums = GenerateSequence(1, stocks.Count + 1).ToList();
foreach (var s in stocks)
{
s.Location = $"Shelf {shelfNums[Random.Next(0, shelfNums.Count)]}";
}
Products.AddRange(products);
OrderItems.AddRange(orderItems);
Stocks.AddRange(stocks);
SaveChanges();
}
public void AddOrder(List <Order> orders)
{
Orders.AddRange(orders);
}
public OrderRendererBase(Order[] orders)
{
Orders.AddRange(orders);
}
public void AddOrders(List <ComplexOrder> orders)
{
Orders.AddRange(orders);
SetAsOpen();
}