public ViewOrders() { InitializeComponent(); this.scheduler = TaskScheduler.FromCurrentSynchronizationContext(); te = new ThirtyOneEntities(); }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (orderControl.CustomerID == Guid.Empty) return; using (ThirtyOneEntities te = new ThirtyOneEntities()) { Order order = new Order(); order.CustomerID = orderControl.CustomerID; order.IsPaid = orderControl.IsPaid; order.OrderDate = Convert.ToDateTime(PartyDatePicker.Text); order.OrderID = Guid.NewGuid(); order.OrderShipping = orderControl.ShippingTotal; order.OrderSubTotal = orderControl.ProductSubTotal; order.OrderTax = orderControl.TaxTotal; order.OrderTotal = orderControl.TotalPrice; if (order.IsPaid && orderControl.PaymentTypeID != null) order.PaymentTypeID = orderControl.PaymentTypeID; else order.PaymentTypeID = GetNonePaymentTypeID(); te.AddToOrders(order); te.SaveChanges(); } orderControl.BeginRemoveStoryboard(); Storyboard saveCompleteSB = (Storyboard)FindResource("SaveCompleteStoryboard"); saveCompleteSB.Begin(); }
private void btnDelete_Click(object sender, RoutedEventArgs e) { if (OrdersDataGrid.SelectedItems.Count == 0) { return; } using (ThirtyOneEntities toe = new ThirtyOneEntities()) { Guid orderID = (OrdersDataGrid.SelectedItem as Order).OrderID; Order order = toe.Orders.Single(t => t.OrderID == orderID); toe.DeleteObject(order); toe.SaveChanges(); } OrdersDataGrid.SelectedIndex = -1; CustomerNameTextBlock.Text = string.Empty; OrderTotalTextBlock.Text = string.Empty; IsPaidCheckBox.IsChecked = false; PaymentTypeComboBox.SelectedIndex = -1; te.Dispose(); te = new ThirtyOneEntities(); DateTime orderDate = Convert.ToDateTime(OrdersDateComboBox.SelectedValue.ToString()); var orders = from t in te.Orders where t.OrderDate == orderDate && t.PartyID == null select t; OrdersDataGrid.ItemsSource = orders; }
private void btnDelete_Click(object sender, RoutedEventArgs e) { if (OrdersDataGrid.SelectedItems.Count == 0) return; using (ThirtyOneEntities toe = new ThirtyOneEntities()) { Guid orderID = (OrdersDataGrid.SelectedItem as Order).OrderID; Order order = toe.Orders.Single(t => t.OrderID == orderID); toe.DeleteObject(order); toe.SaveChanges(); } OrdersDataGrid.SelectedIndex = -1; CustomerNameTextBlock.Text = string.Empty; OrderTotalTextBlock.Text = string.Empty; IsPaidCheckBox.IsChecked = false; PaymentTypeComboBox.SelectedIndex = -1; te.Dispose(); te = new ThirtyOneEntities(); DateTime orderDate = Convert.ToDateTime(OrdersDateComboBox.SelectedValue.ToString()); var orders = from t in te.Orders where t.OrderDate == orderDate && t.PartyID == null select t; OrdersDataGrid.ItemsSource = orders; }
private void CreateTableContraints() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "ALTER TABLE [Customers] ADD CONSTRAINT [PK_Customers] PRIMARY KEY ([CustomerID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Orders] ADD CONSTRAINT [PK__Orders__00000000000000BB] PRIMARY KEY ([OrderID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Parties] ADD CONSTRAINT [PK_Parties] PRIMARY KEY ([PartyID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [PaymentTypes] ADD CONSTRAINT [PK__PaymentTypes__00000000000000DE] PRIMARY KEY ([PaymentTypeID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__Customers__0000000000000115] ON [Customers] ([CustomerID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__Orders__00000000000000A9] ON [Orders] ([OrderID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__Parties__000000000000012B] ON [Parties] ([PartyID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__PaymentTypes__00000000000000D6] ON [PaymentTypes] ([PaymentTypeID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Orders] ADD CONSTRAINT [CustomerOrders] FOREIGN KEY ([CustomerID]) REFERENCES [Customers]([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION;"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Orders] ADD CONSTRAINT [PaymentTypeOrders] FOREIGN KEY ([PaymentTypeID]) REFERENCES [PaymentTypes]([PaymentTypeID]) ON DELETE NO ACTION ON UPDATE NO ACTION;"; te.ExecuteStoreCommand(script, new object[] { }); } }
private Guid GetNonePaymentTypeID() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { return te.PaymentTypes.SingleOrDefault(t => t.PaymentTypeName == "None").PaymentTypeID; } }
private Guid GetNonePaymentTypeID() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { return(te.PaymentTypes.SingleOrDefault(t => t.PaymentTypeName == "None").PaymentTypeID); } }
public ViewParty() { InitializeComponent(); this.scheduler = TaskScheduler.FromCurrentSynchronizationContext(); te = new ThirtyOneEntities(); }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(CustomerNameTextBox.Text)) { return; } this.Cursor = Cursors.Wait; try { using (ThirtyOneEntities toe = new ThirtyOneEntities()) { Customer cust = toe.Customers.SingleOrDefault(t => t.CustomerName == CustomerNameTextBox.Text.Trim()); if (cust != null) { this.Cursor = Cursors.Arrow; MessageBox.Show("Customer already exists."); return; } } } catch (Exception ex) { this.Cursor = Cursors.Arrow; string error = string.Format("{0}{1}{2}{3}", ex.Message, Environment.NewLine, (ex.InnerException != null) ? ex.InnerException.Message : "", ex.StackTrace); MessageBox.Show(error); return; } try { using (ThirtyOneEntities te = new ThirtyOneEntities()) { Customer c = te.CreateObject <Customer>(); c.CustomerID = Guid.NewGuid(); c.CustomerName = CustomerNameTextBox.Text.Trim(); te.Customers.AddObject(c); te.SaveChanges(); } CustomerNameTextBox.Text = string.Empty; OnCustomerAddCompleted(); Storyboard saveCompleteSB = (Storyboard)FindResource("SaveCompleteStoryboard"); saveCompleteSB.Begin(); CustomerNameTextBox.Focus(); } catch (Exception ex) { this.Cursor = Cursors.Arrow; MessageBox.Show(ex.Message); return; } this.Cursor = Cursors.Arrow; }
private void CreatePartiesTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [Parties] ([PartyID] uniqueidentifier NOT NULL ROWGUIDCOL, [PartyDate] datetime NOT NULL, [PartyTotal] float NOT NULL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreateOrdersTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [Orders] ([OrderSubTotal] float NULL, [OrderTax] float NULL, [OrderTotal] float NULL, [IsPaid] bit NOT NULL, [OrderID] uniqueidentifier NOT NULL ROWGUIDCOL, [CustomerID] uniqueidentifier NOT NULL, [PaymentTypeID] uniqueidentifier NOT NULL, [OrderDate] datetime NOT NULL, [PartyID] uniqueidentifier NULL, [OrderShipping] float NULL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreateCustomersTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [Customers] ([CustomerID] uniqueidentifier NOT NULL ROWGUIDCOL, [CustomerName] nvarchar(150) NOT NULL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreatePaymentTypesTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [PaymentTypes] ([PaymentType] nvarchar(100) NULL, [PaymentTypeID] uniqueidentifier NOT NULL ROWGUIDCOL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreateTestTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [Test] ([CustomerID] uniqueidentifier NOT NULL ROWGUIDCOL, [CustomerName] nvarchar(150) NOT NULL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreatePartiesTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [Parties] ([PartyID] uniqueidentifier NOT NULL ROWGUIDCOL, [PartyDate] datetime NOT NULL, [PartyTotal] float NOT NULL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreateOrdersTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [Orders] ([OrderSubTotal] float NULL, [OrderTax] float NULL, [OrderTotal] float NULL, [IsPaid] bit NOT NULL, [OrderID] uniqueidentifier NOT NULL ROWGUIDCOL, [CustomerID] uniqueidentifier NOT NULL, [PaymentTypeID] uniqueidentifier NOT NULL, [OrderDate] datetime NOT NULL, [PartyID] uniqueidentifier NULL, [OrderShipping] float NULL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrWhiteSpace(CustomerNameTextBox.Text)) return; this.Cursor = Cursors.Wait; try { using (ThirtyOneEntities toe = new ThirtyOneEntities()) { Customer cust = toe.Customers.SingleOrDefault(t => t.CustomerName == CustomerNameTextBox.Text.Trim()); if (cust != null) { this.Cursor = Cursors.Arrow; MessageBox.Show("Customer already exists."); return; } } } catch (Exception ex) { this.Cursor = Cursors.Arrow; string error = string.Format("{0}{1}{2}{3}", ex.Message, Environment.NewLine, (ex.InnerException != null) ? ex.InnerException.Message : "", ex.StackTrace); MessageBox.Show(error); return; } try { using (ThirtyOneEntities te = new ThirtyOneEntities()) { Customer c = te.CreateObject<Customer>(); c.CustomerID = Guid.NewGuid(); c.CustomerName = CustomerNameTextBox.Text.Trim(); te.Customers.AddObject(c); te.SaveChanges(); } CustomerNameTextBox.Text = string.Empty; OnCustomerAddCompleted(); Storyboard saveCompleteSB = (Storyboard)FindResource("SaveCompleteStoryboard"); saveCompleteSB.Begin(); CustomerNameTextBox.Focus(); } catch (Exception ex) { this.Cursor = Cursors.Arrow; MessageBox.Show(ex.Message); return; } this.Cursor = Cursors.Arrow; }
public void UpdateData() { DateTime now = DateTime.Now; DateTime startOfMonth = new DateTime(now.Year, now.Month, 1); DateTime endOfMonth = new DateTime(now.Year, now.Month, 1).AddMonths(1); DateTime startOfYear = new DateTime(now.Year, 1, 1); DateTime endOfYear = new DateTime(now.Year, 1, 1).AddYears(1); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var thisMonth = from c in te.Orders where c.OrderDate >= startOfMonth && c.OrderDate < endOfMonth && c.IsPaid == true group c by c.IsPaid into g select new { MonthlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisMonth.Count() != 0) ThisMonthTotal.Text = string.Format("{0:c}", thisMonth.First().MonthlyTotal); else ThisMonthTotal.Text = string.Format("{0:c}", 0); var thisYear = from c in te.Orders where c.OrderDate >= startOfYear && c.OrderDate < endOfYear && c.IsPaid == true group c by c.IsPaid into g select new { YearlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisYear.Count() != 0) ThisYearTotal.Text = string.Format("{0:c}", thisYear.First().YearlyTotal); else ThisYearTotal.Text = string.Format("{0:c}", 0); var total = from c in te.Orders where c.IsPaid == true group c by c.IsPaid into g select new { TotalTotal = g.Sum(t => t.OrderSubTotal) }; if(total.Count() != 0) Total.Text = string.Format("{0:c}", total.First().TotalTotal); else Total.Text = string.Format("{0:c}", 0); } }
private List <Customer> GetCustomers() { List <Customer> list = new List <Customer>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = te.Customers; list = custs.ToList(); } return(list); }
private List<Customer> GetCustomers() { List<Customer> list = new List<Customer>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = from c in te.Orders select c.Customer; list = custs.Distinct().ToList(); } return list; }
private List <Customer> GetCustomers() { List <Customer> list = new List <Customer>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = from c in te.Orders select c.Customer; list = custs.Distinct().ToList(); } return(list); }
private void CreatePaymentTypeData() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'None','c0a5d459-00b2-4ca1-a436-3a57744551e4');"; te.ExecuteStoreCommand(script, new object[] { }); script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'Cash','8c2229c7-46d6-4dd7-b70f-fd53ae5bfbcc');"; te.ExecuteStoreCommand(script, new object[] { }); script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'Check','4598225c-1175-46d1-8f62-dbdb2a859c3d');"; te.ExecuteStoreCommand(script, new object[] { }); script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'Debit/Credit','8a7c971e-091b-4e4e-9255-2cfafb9f405f');"; te.ExecuteStoreCommand(script, new object[] { }); } }
private List<Party> GetParties() { List<Party> list = new List<Party>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = from c in te.Parties orderby c.PartyDate descending select c; list = custs.ToList(); } return list; }
private List <PaymentType> GetPaymentTypes() { List <PaymentType> list = new List <PaymentType>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = from c in te.PaymentTypes orderby c.PaymentTypeName descending select c; list = custs.ToList(); } return(list); }
private List <DateTime> GetOrderDates() { List <DateTime> list = new List <DateTime>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = from c in te.Orders where c.PartyID == null orderby c.OrderDate descending select c.OrderDate; list = custs.Distinct().ToList(); } return(list); }
public void UpdateData() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { var unpaidOrders = from c in te.Orders where c.IsPaid == false && c.OrderTotal != null select new UnpaidOrder { OrderDate = c.OrderDate, CustomerName = c.Customer.CustomerName, OrderTotal = c.OrderTotal.Value, IsPaid = false }; UnpaidOrdersGrid.ItemsSource = unpaidOrders; } }
public void UpdateData() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { var unpaidOrders = from c in te.Orders where c.IsPaid == false && c.OrderTotal != null select new UnpaidOrder { OrderDate = c.OrderDate, CustomerName = c.Customer.CustomerName, OrderTotal = c.OrderTotal.Value, IsPaid = false }; UnpaidOrdersGrid.ItemsSource = unpaidOrders; } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { using (ThirtyOneEntities toe = new ThirtyOneEntities()) { Guid orderID = (PartyDataGrid.SelectedItem as Order).OrderID; Order order = toe.Orders.Single(t => t.OrderID == orderID); order.IsPaid = IsPaidCheckBox.IsChecked.Value; if (PaymentTypeComboBox.SelectedItem != null) { order.PaymentTypeID = (PaymentTypeComboBox.SelectedItem as PaymentType).PaymentTypeID; } else { order.PaymentTypeID = GetNonePaymentTypeID(); } toe.SaveChanges(); } PartyDataGrid.SelectedIndex = -1; CustomerNameTextBlock.Text = string.Empty; OrderTotalTextBlock.Text = string.Empty; IsPaidCheckBox.IsChecked = false; PaymentTypeComboBox.SelectedIndex = -1; te.Dispose(); te = new ThirtyOneEntities(); Guid partyID = (PartyDateComboBox.SelectedItem as Party).PartyID; var orders = from t in te.Orders where t.PartyID == partyID select t; PartyDataGrid.ItemsSource = orders; }
private void btnSave_Click(object sender, RoutedEventArgs e) { if (orderControl.CustomerID == Guid.Empty) { return; } using (ThirtyOneEntities te = new ThirtyOneEntities()) { Order order = new Order(); order.CustomerID = orderControl.CustomerID; order.IsPaid = orderControl.IsPaid; order.OrderDate = Convert.ToDateTime(PartyDatePicker.Text); order.OrderID = Guid.NewGuid(); order.OrderShipping = orderControl.ShippingTotal; order.OrderSubTotal = orderControl.ProductSubTotal; order.OrderTax = orderControl.TaxTotal; order.OrderTotal = orderControl.TotalPrice; if (order.IsPaid && orderControl.PaymentTypeID != null) { order.PaymentTypeID = orderControl.PaymentTypeID; } else { order.PaymentTypeID = GetNonePaymentTypeID(); } te.AddToOrders(order); te.SaveChanges(); } orderControl.BeginRemoveStoryboard(); Storyboard saveCompleteSB = (Storyboard)FindResource("SaveCompleteStoryboard"); saveCompleteSB.Begin(); }
private List<Customer> GetCustomers() { List<Customer> list = new List<Customer>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = te.Customers; list = custs.ToList(); } return list; }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (OrderStackPanel.Children.Count == 0) { return; } this.Cursor = Cursors.Wait; bool hasOrderBeenAdded = false; using (ThirtyOneEntities te = new ThirtyOneEntities()) { Guid partyID = Guid.NewGuid(); Party p = new Party(); p.PartyID = partyID; p.PartyDate = Convert.ToDateTime(PartyDatePicker.Text); p.PartyTotal = partyTotal; foreach (UIElement ele in OrderStackPanel.Children) { if (ele is OrderControl) { OrderControl oc = ele as OrderControl; if (oc.CustomerID == Guid.Empty) { continue; } if (oc.ProductSubTotal == 0) { continue; } hasOrderBeenAdded = true; Order order = new Order(); order.CustomerID = oc.CustomerID; order.IsPaid = oc.IsPaid; order.OrderDate = p.PartyDate; order.OrderID = Guid.NewGuid(); order.OrderShipping = oc.ShippingTotal; order.OrderSubTotal = oc.ProductSubTotal; order.OrderTax = oc.TaxTotal; order.OrderTotal = oc.TotalPrice; order.PartyID = p.PartyID; if (order.IsPaid) { order.PaymentTypeID = oc.PaymentTypeID; } else { order.PaymentTypeID = GetNonePaymentTypeID(); } te.AddToOrders(order); //oc.BeginRemoveStoryboard(); } } if (hasOrderBeenAdded) { te.AddToParties(p); te.SaveChanges(); } } this.Cursor = Cursors.Arrow; }
public void UpdateData() { DateTime now = DateTime.Now; DateTime startOfMonth = new DateTime(now.Year, now.Month, 1); DateTime endOfMonth = new DateTime(now.Year, now.Month, 1).AddMonths(1); DateTime startOfYear = new DateTime(now.Year, 1, 1); DateTime endOfYear = new DateTime(now.Year, 1, 1).AddYears(1); double ordersTotal = 0; double commissionTotal = 0; using (ThirtyOneEntities te = new ThirtyOneEntities()) { var thisMonth = from c in te.Orders where c.OrderDate >= startOfMonth && c.OrderDate < endOfMonth && c.IsPaid == true group c by c.IsPaid into g select new { MonthlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisMonth.Count() > 0) { ordersTotal = (thisMonth.First().MonthlyTotal.HasValue) ? thisMonth.First().MonthlyTotal.Value : 0; commissionTotal = Math.Round(ordersTotal * .25, 2); ThisMonthTotal.Text = string.Format("{0:c}", commissionTotal); } else { ThisMonthTotal.Text = string.Format("{0:c}", 0); } var thisYear = from c in te.Orders where c.OrderDate >= startOfYear && c.OrderDate < endOfYear && c.IsPaid == true group c by c.IsPaid into g select new { YearlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisYear.Count() > 0) { ordersTotal = (thisYear.First().YearlyTotal.HasValue) ? thisYear.First().YearlyTotal.Value : 0; commissionTotal = Math.Round(ordersTotal * .25, 2); ThisYearTotal.Text = string.Format("{0:c}", commissionTotal); } else { ThisYearTotal.Text = string.Format("{0:c}", 0); } var total = from c in te.Orders where c.IsPaid == true group c by c.IsPaid into g select new { TotalTotal = g.Sum(t => t.OrderSubTotal) }; if (total.Count() > 0) { ordersTotal = (total.First().TotalTotal.HasValue) ? total.First().TotalTotal.Value : 0; commissionTotal = Math.Round(ordersTotal * .25, 2); Total.Text = string.Format("{0:c}", commissionTotal); } else { Total.Text = string.Format("{0:c}", 0); } } }
public void UpdateData() { DateTime now = DateTime.Now; DateTime startOfMonth = new DateTime(now.Year, now.Month, 1); DateTime endOfMonth = new DateTime(now.Year, now.Month, 1).AddMonths(1); DateTime startOfYear = new DateTime(now.Year, 1, 1); DateTime endOfYear = new DateTime(now.Year, 1, 1).AddYears(1); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var thisMonth = from c in te.Orders where c.OrderDate >= startOfMonth && c.OrderDate < endOfMonth && c.IsPaid == true group c by c.IsPaid into g select new { MonthlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisMonth.Count() != 0) { ThisMonthTotal.Text = string.Format("{0:c}", thisMonth.First().MonthlyTotal); } else { ThisMonthTotal.Text = string.Format("{0:c}", 0); } var thisYear = from c in te.Orders where c.OrderDate >= startOfYear && c.OrderDate < endOfYear && c.IsPaid == true group c by c.IsPaid into g select new { YearlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisYear.Count() != 0) { ThisYearTotal.Text = string.Format("{0:c}", thisYear.First().YearlyTotal); } else { ThisYearTotal.Text = string.Format("{0:c}", 0); } var total = from c in te.Orders where c.IsPaid == true group c by c.IsPaid into g select new { TotalTotal = g.Sum(t => t.OrderSubTotal) }; if (total.Count() != 0) { Total.Text = string.Format("{0:c}", total.First().TotalTotal); } else { Total.Text = string.Format("{0:c}", 0); } } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { if (OrderStackPanel.Children.Count == 0) return; this.Cursor = Cursors.Wait; bool hasOrderBeenAdded = false; using (ThirtyOneEntities te = new ThirtyOneEntities()) { Guid partyID = Guid.NewGuid(); Party p = new Party(); p.PartyID = partyID; p.PartyDate = Convert.ToDateTime(PartyDatePicker.Text); p.PartyTotal = partyTotal; foreach (UIElement ele in OrderStackPanel.Children) { if (ele is OrderControl) { OrderControl oc = ele as OrderControl; if (oc.CustomerID == Guid.Empty) continue; if (oc.ProductSubTotal == 0) continue; hasOrderBeenAdded = true; Order order = new Order(); order.CustomerID = oc.CustomerID; order.IsPaid = oc.IsPaid; order.OrderDate = p.PartyDate; order.OrderID = Guid.NewGuid(); order.OrderShipping = oc.ShippingTotal; order.OrderSubTotal = oc.ProductSubTotal; order.OrderTax = oc.TaxTotal; order.OrderTotal = oc.TotalPrice; order.PartyID = p.PartyID; if (order.IsPaid) order.PaymentTypeID = oc.PaymentTypeID; else order.PaymentTypeID = GetNonePaymentTypeID(); te.AddToOrders(order); //oc.BeginRemoveStoryboard(); } } if (hasOrderBeenAdded) { te.AddToParties(p); te.SaveChanges(); } } this.Cursor = Cursors.Arrow; }
private void CreatePaymentTypesTable() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "CREATE TABLE [PaymentTypes] ([PaymentType] nvarchar(100) NULL, [PaymentTypeID] uniqueidentifier NOT NULL ROWGUIDCOL);"; te.ExecuteStoreCommand(script, new object[] { }); } }
private List<DateTime> GetOrderDates() { List<DateTime> list = new List<DateTime>(); using (ThirtyOneEntities te = new ThirtyOneEntities()) { var custs = from c in te.Orders where c.PartyID == null orderby c.OrderDate descending select c.OrderDate; list = custs.Distinct().ToList(); } return list; }
private void CreatePaymentTypeData() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'None','c0a5d459-00b2-4ca1-a436-3a57744551e4');"; te.ExecuteStoreCommand(script, new object[] { }); script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'Cash','8c2229c7-46d6-4dd7-b70f-fd53ae5bfbcc');"; te.ExecuteStoreCommand(script, new object[] { }); script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'Check','4598225c-1175-46d1-8f62-dbdb2a859c3d');"; te.ExecuteStoreCommand(script, new object[] { }); script = "INSERT INTO [PaymentTypes] ([PaymentType],[PaymentTypeID]) VALUES (N'Debit/Credit','8a7c971e-091b-4e4e-9255-2cfafb9f405f');"; te.ExecuteStoreCommand(script, new object[] { }); } }
private void CreateTableContraints() { using (ThirtyOneEntities te = new ThirtyOneEntities()) { string script = "ALTER TABLE [Customers] ADD CONSTRAINT [PK_Customers] PRIMARY KEY ([CustomerID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Orders] ADD CONSTRAINT [PK__Orders__00000000000000BB] PRIMARY KEY ([OrderID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Parties] ADD CONSTRAINT [PK_Parties] PRIMARY KEY ([PartyID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [PaymentTypes] ADD CONSTRAINT [PK__PaymentTypes__00000000000000DE] PRIMARY KEY ([PaymentTypeID]);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__Customers__0000000000000115] ON [Customers] ([CustomerID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__Orders__00000000000000A9] ON [Orders] ([OrderID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__Parties__000000000000012B] ON [Parties] ([PartyID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "CREATE UNIQUE INDEX [UQ__PaymentTypes__00000000000000D6] ON [PaymentTypes] ([PaymentTypeID] ASC);"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Orders] ADD CONSTRAINT [CustomerOrders] FOREIGN KEY ([CustomerID]) REFERENCES [Customers]([CustomerID]) ON DELETE NO ACTION ON UPDATE NO ACTION;"; te.ExecuteStoreCommand(script, new object[] { }); script = "ALTER TABLE [Orders] ADD CONSTRAINT [PaymentTypeOrders] FOREIGN KEY ([PaymentTypeID]) REFERENCES [PaymentTypes]([PaymentTypeID]) ON DELETE NO ACTION ON UPDATE NO ACTION;"; te.ExecuteStoreCommand(script, new object[] { }); } }
public void UpdateData() { DateTime now = DateTime.Now; DateTime startOfMonth = new DateTime(now.Year, now.Month, 1); DateTime endOfMonth = new DateTime(now.Year, now.Month, 1).AddMonths(1); DateTime startOfYear = new DateTime(now.Year, 1, 1); DateTime endOfYear = new DateTime(now.Year, 1, 1).AddYears(1); double ordersTotal = 0; double commissionTotal = 0; using (ThirtyOneEntities te = new ThirtyOneEntities()) { var thisMonth = from c in te.Orders where c.OrderDate >= startOfMonth && c.OrderDate < endOfMonth && c.IsPaid == true group c by c.IsPaid into g select new { MonthlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisMonth.Count() > 0) { ordersTotal = (thisMonth.First().MonthlyTotal.HasValue) ? thisMonth.First().MonthlyTotal.Value : 0; commissionTotal = Math.Round(ordersTotal * .25, 2); ThisMonthTotal.Text = string.Format("{0:c}", commissionTotal); } else { ThisMonthTotal.Text = string.Format("{0:c}", 0); } var thisYear = from c in te.Orders where c.OrderDate >= startOfYear && c.OrderDate < endOfYear && c.IsPaid == true group c by c.IsPaid into g select new { YearlyTotal = g.Sum(t => t.OrderSubTotal) }; if (thisYear.Count() > 0) { ordersTotal = (thisYear.First().YearlyTotal.HasValue) ? thisYear.First().YearlyTotal.Value : 0; commissionTotal = Math.Round(ordersTotal * .25, 2); ThisYearTotal.Text = string.Format("{0:c}", commissionTotal); } else { ThisYearTotal.Text = string.Format("{0:c}", 0); } var total = from c in te.Orders where c.IsPaid == true group c by c.IsPaid into g select new { TotalTotal = g.Sum(t => t.OrderSubTotal) }; if (total.Count() > 0) { ordersTotal = (total.First().TotalTotal.HasValue) ? total.First().TotalTotal.Value : 0; commissionTotal = Math.Round(ordersTotal * .25, 2); Total.Text = string.Format("{0:c}", commissionTotal); } else { Total.Text = string.Format("{0:c}", 0); } } }
private void SaveButton_Click(object sender, RoutedEventArgs e) { using (ThirtyOneEntities toe = new ThirtyOneEntities()) { Guid orderID = (PartyDataGrid.SelectedItem as Order).OrderID; Order order = toe.Orders.Single(t => t.OrderID == orderID); order.IsPaid = IsPaidCheckBox.IsChecked.Value; if (PaymentTypeComboBox.SelectedItem != null) order.PaymentTypeID = (PaymentTypeComboBox.SelectedItem as PaymentType).PaymentTypeID; else order.PaymentTypeID = GetNonePaymentTypeID(); toe.SaveChanges(); } PartyDataGrid.SelectedIndex = -1; CustomerNameTextBlock.Text = string.Empty; OrderTotalTextBlock.Text = string.Empty; IsPaidCheckBox.IsChecked = false; PaymentTypeComboBox.SelectedIndex = -1; te.Dispose(); te = new ThirtyOneEntities(); Guid partyID = (PartyDateComboBox.SelectedItem as Party).PartyID; var orders = from t in te.Orders where t.PartyID == partyID select t; PartyDataGrid.ItemsSource = orders; }