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