private void BillDone(int flags) { if (flags == 1) { MessageBoxResult result = MessageBox.Show("Thanh toán thành công. Bạn có muốn tiếp tục mua sắm???", "Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { CakeShop_dbEntities db = new CakeShop_dbEntities(); Bill bill = new Bill(); bill.Date = DateTime.Now; bill.Payed = false; InitializeComponent(); db.Bills.Add(bill); db.SaveChanges(); GridMain.Children.Clear(); TitleFunction.Text = "Trang chủ"; var screen = new UserControlTypes(); screen.Handler += Categories; GridMain.Children.Add(screen); } else { this.Close(); } } }
//Xoa cac bill chua thanh toan private void Window_Closed(object sender, EventArgs e) { CakeShop_dbEntities db = new CakeShop_dbEntities(); var bd = db.BillDetails.ToList(); foreach (var item in bd) { if (item.Bill.Payed == false) { db.BillDetails.Remove(item); db.SaveChanges(); } } var d = db.Bills.ToList(); foreach (var item in d) { if (item.Payed == false) { db.Bills.Remove(item); db.SaveChanges(); } } Application.Current.Shutdown(); }
private void TotalCarts_Click(object sender, RoutedEventArgs e) { CakeShop_dbEntities db = new CakeShop_dbEntities(); var bills = db.Bills.ToList(); var currentBill = bills[bills.Count - 1]; currentBill.Payed = true; db.SaveChanges(); Handler?.Invoke(1); this.Visibility = Visibility.Collapsed; }
public MainWindow() { CakeShop_dbEntities db = new CakeShop_dbEntities(); Bill bill = new Bill(); bill.Date = DateTime.Now; bill.Payed = false; InitializeComponent(); db.Bills.Add(bill); db.SaveChanges(); var d = db.Bills.ToList(); }
private void Cart_Click_MouseLeftButtonUp(object sender, MouseButtonEventArgs e) { CakeShop_dbEntities db = new CakeShop_dbEntities(); GridMain.Children.Clear(); TitleFunction.Text = "Thanh toán"; var data = db.Bills.ToList(); var screen = new UserControlCreateCakeBill(GridMain, data[data.Count - 1]); screen.Handler += BillDone; GridMain.Children.Add(screen); }
private void Border_Loaded(object sender, RoutedEventArgs e) { var db = new CakeShop_dbEntities(); var Cakes = db.Cakes.ToList(); var temp = _rng.Next(Cakes.Count); // var file = AppDomain.CurrentDomain.BaseDirectory; dataImg = $"{file}Images\\{Cakes[temp].Image}"; _CakeAva.Source = new BitmapImage(new Uri(dataImg)); // _CakeDetail.Text = Cakes[temp].Detail; _CakeName.Text = Cakes[temp].Name; }
private void Down_MouseLeftButtonUp(object sender, RoutedEventArgs e) { CakeShop_dbEntities db = new CakeShop_dbEntities(); var dtbill = db.BillDetails.ToList(); var selectedItem = BillDTG.SelectedItem as BillDetail; foreach (var item in dtbill) { if (item.CakeID == selectedItem.CakeID && item.IDBill == selectedItem.IDBill && selectedItem != null && item.Quantity > 0) { item.Quantity -= 1; item.Totality = item.Quantity * item.Cake.Price; } } db.SaveChanges(); Refresh(); }
private void DeleteBill_Click(object sender, RoutedEventArgs e) { //var item = BillDTG.SelectedItem as BillDetail; // //db.SaveChanges(); ////refresh //var Bills = db.BillDetails.ToList(); //BillDTG.ItemsSource = Bills; CakeShop_dbEntities db = new CakeShop_dbEntities(); var dtbill = db.BillDetails.ToList(); var selectedItem = BillDTG.SelectedItem as BillDetail; foreach (var item in dtbill) { if (item.CakeID == selectedItem.CakeID && item.IDBill == selectedItem.IDBill && selectedItem != null) { db.BillDetails.Remove(item); } } db.SaveChanges(); Refresh(); }
private void Refresh() { var db = new CakeShop_dbEntities(); var bills = db.Bills.ToList(); var currentBill = bills[bills.Count - 1]; var sum = 0; foreach (var item2 in currentBill.BillDetails) { if (item2.Totality != null) { sum += (int)item2.Totality; } } currentBill.Totality = sum; TotalCartTextBlock.Text = sum.ToString() + "$"; var billFillter = from item in db.BillDetails where item.IDBill == currentBill.ID select item; var data = billFillter.ToList(); BillDTG.ItemsSource = data; }
public UserControlCharts() { InitializeComponent(); var db = new CakeShop_dbEntities(); var bills = db.Bills.ToList(); var billdetails = db.BillDetails.ToList(); var MonthRevenue = new List <int>() { 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, }; foreach (var item in bills) { var date = item.Date.ToString().Split('/'); var MM = Int32.Parse(date[1]); var sum = 0; foreach (var item2 in item.BillDetails) { if (item2.Totality != null) { sum += (int)item2.Totality; } } item.Totality = sum; if (item.Totality != null) { MonthRevenue[MM - 1] += (int)item.Totality; } } var columnChart = new SeriesCollection(); for (int i = 0; i < 12; i++) { var data = new ColumnSeries() { Title = $"Tháng {i + 1}", Values = new ChartValues <int> { MonthRevenue[i] } }; columnChart.Add(data); } CartesianChart.Series = columnChart; var PieChart = new SeriesCollection(); var CakeLoai = new List <int>() { 0, 0, 0, 0, 0, }; foreach (var item in billdetails) { int catID = item.Cake.CatID != null ? (int)item.Cake.CatID : 0; if (item.Totality != null) { CakeLoai[catID - 1] += (int)item.Totality; } } var category = db.Categories.ToList(); for (int i = 0; i < CakeLoai.Count; i++) { var data = new PieSeries() { Title = $"{category[i].CatName}", Values = new ChartValues <int> { CakeLoai[i] } }; PieChart.Add(data); } PieChartBabyIReal.Series = PieChart; }