/* * Function : Add_Customer_Click * Description : Inserts the new Customer into the database * * * Parameters : object sender, RoutedEventArgs e * * Returns : void * */ public void Add_Customer_Click(object sender, RoutedEventArgs e) { string firstName = firstN.Text; string lastName = lastN.Text; string phoneNum = phoneN.Text; bool status; if (ValidateString(firstName) == true) { if (ValidateString(lastName) == true) { if (phoneNum.Length == 12) { status = true; } else { status = false; } } else { status = false; } } else { status = false; } if (status) { DBMS dbms = new DBMS(); try { int retCode = dbms.CreateCustomer(firstName, lastName, phoneNum); if (retCode == 1) { MessageBox.Show("New customer added successfully"); } else { throw new Exception(); } } catch (Exception) { errorMsg.Visibility = Visibility.Visible; } } else { errorMsg.Visibility = Visibility.Visible; } }
private void Show_Orders_Click(object sender, RoutedEventArgs e) { DBMS dbms = new DBMS(); DataTable dt = new DataTable(); if (Orders.Columns.Count == 7 || Orders.Columns.Count == 0) { DataGridTemplateColumn col1 = new DataGridTemplateColumn(); col1.Header = "Refund"; FrameworkElementFactory factory1 = new FrameworkElementFactory(typeof(Button)); factory1.SetValue(Button.ContentProperty, "Refund"); factory1.AddHandler(Button.ClickEvent, new RoutedEventHandler(RefundBtn_Click)); DataTemplate cellTemplate1 = new DataTemplate(); cellTemplate1.VisualTree = factory1; col1.CellTemplate = cellTemplate1; Orders.Columns.Add(col1); } dt = dbms.DisplayOrders(); Orders.ItemsSource = dt.DefaultView; }
/* * Function : RemoveBtn_Click * Description : Removes the Order from the cart * * * Parameters : object sender, RoutedEventArgs e * * Returns : void * */ private void RemoveBtn_Click(object sender, RoutedEventArgs e) { DBMS dbms = new DBMS(); if (sessionID.Count != 0) { foreach (var key in ProNameQuant.Keys) { string proID = dbms.GetProductID(key.ToString()); dbms.UpdateDatabaseQuantity(proID, ProNameQuant[key], 1); } foreach (var i in sessionID) { dbms.RemoveFromCart(i); } this.NavigationService.Navigate(new Cart_Page()); Show_Cart_Click(sender, e); MessageBox.Show("Product removed from the Cart"); } else { MessageBox.Show("No Product is selected"); } }
private void SelectBtn_Click(object sender, RoutedEventArgs e) { stockCB.Items.Clear(); DataRowView r = (DataRowView)((Button)e.Source).DataContext; int id = int.Parse(r["SKU"].ToString()); string name = r["name"].ToString(); int totalStock = int.Parse(r["stock"].ToString()); decimal price = decimal.Parse(r["wPrice"].ToString(), System.Globalization.NumberStyles.Currency); List <string> branches = new List <string>(); pr = price; productN = name; sku = id.ToString(); for (int i = 1; i <= totalStock; ++i) { stockCB.Items.Add(i); } if (BranchCB.Items.Count < 3) { DBMS dbms = new DBMS(); branches = dbms.GetBranches(); for (int i = 0; i < branches.Count; ++i) { BranchCB.Items.Add(branches.ElementAt(i)); } } if (stockCB.Items.Count != 0) { stockCB.SelectedItem = 1; } NameTB.Text = name; CalculatedTotal.Text = "$" + (price * quant).ToString(); Product_Border.Visibility = Visibility.Visible; totalP = CalculatedTotal.Text; }