private void btnEdit_Click(object sender, RoutedEventArgs e) { DTO_Discount row = (Discount)dgDiscount.SelectedItem; if (DateTime.Compare(DateTime.ParseExact(row.EndDate, "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture), DateTime.Now.Date) < 0) { MessageBox.Show("Không thể sửa ưu đãi đã diễn ra"); } else { System.Windows.Media.Effects.BlurEffect objBlur = new System.Windows.Media.Effects.BlurEffect(); ((MainWindow)App.Current.MainWindow).Opacity = 0.5; ((MainWindow)App.Current.MainWindow).Effect = objBlur; Window window = new Window { ResizeMode = ResizeMode.NoResize, WindowStyle = WindowStyle.None, Title = "Sửa ưu đãi", Content = new PopupDiscountEdit(row.DiscountID, row.DiscountName, row.StartDate, row.EndDate, row.DiscountValue.ToString(), _context), Width = 460, Height = 505, Left = (Application.Current.MainWindow.Left + Application.Current.MainWindow.Width - 460) / 2, Top = (Application.Current.MainWindow.Top + Application.Current.MainWindow.Height - 500) / 2, }; window.ShowDialog(); ((MainWindow)App.Current.MainWindow).Opacity = 1; ((MainWindow)App.Current.MainWindow).Effect = null; loadData(); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { DTO_Discount row = (DTO_Discount)dgDiscount.SelectedItem; System.Windows.Media.Effects.BlurEffect objBlur = new System.Windows.Media.Effects.BlurEffect(); ((MainWindow)App.Current.MainWindow).Opacity = 0.5; ((MainWindow)App.Current.MainWindow).Effect = objBlur; Window window = new Window { ResizeMode = ResizeMode.NoResize, WindowStyle = WindowStyle.None, Title = "Xóa ưu đãi", Content = new PopupDeleteConfirm(row, _context), Width = 420, Height = 210, WindowStartupLocation = WindowStartupLocation.CenterScreen }; window.ShowDialog(); ((MainWindow)App.Current.MainWindow).Opacity = 1; ((MainWindow)App.Current.MainWindow).Effect = null; setNumPage(); if (maxNumpage < int.Parse(tbNumPage.Text)) { tbNumPage.Text = (int.Parse(tbNumPage.Text) - 1).ToString(); } loadData(); }
public DTO_Discount findDiscount(string ID) { string sql = $"select * from discount where discountID ='" + ID + "'"; DTO_Discount dto = new DTO_Discount(); try { SQLiteCommand command = new SQLiteCommand(sql, getConnection()); command.Connection.Open(); SQLiteDataReader reader = command.ExecuteReader(); while (reader.Read()) { dto.DiscountID = ID; dto.DiscountName = reader["DiscountName"].ToString(); dto.StartDate = reader["StartDate"].ToString(); dto.EndDate = reader["EndDate"].ToString(); dto.DiscountValue = float.Parse(reader["DiscountValue"].ToString()); } } catch (Exception e) { Console.WriteLine(e); } return(dto); }
public DTO_Discount GetCurrentDiscout() { DataTable discountData = getAllDiscount(); DTO_Discount result = new DTO_Discount(); foreach (DataRow row in discountData.Rows) { DateTime now = DateTime.Now.Date; try { DateTime start = DateTime.ParseExact(row["StartDate"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).Date; if (now < start) { continue; } DateTime end = DateTime.ParseExact(row["EndDate"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture).Date; if (now > end) { continue; } result = new DTO_Discount(row["DiscountID"].ToString(), row["DiscountName"].ToString(), row["StartDate"].ToString(), row["EndDate"].ToString(), float.Parse(row["DiscountValue"].ToString()), ""); } catch { continue; } } return(result); }
private void btSave_Click(object sender, RoutedEventArgs e) { tbNameValidation.Text = tbDateValidation.Text = tbRateValidation.Text = ""; tbDateValidation.HorizontalAlignment = HorizontalAlignment.Right; if (tbName.Text == "") { tbNameValidation.Text = "Tên ưu đãi không được để trống."; return; } if (tbStartDate.SelectedDate == null) { tbDateValidation.Text = "Ngày bắt đầu không được để trống."; tbDateValidation.HorizontalAlignment = HorizontalAlignment.Left; return; } if (DateTime.Compare((DateTime)tbStartDate.SelectedDate, DateTime.Now.Date) <= 0) { tbDateValidation.Text = "Ngày bắt đầu phải sau ngày hiện tại."; tbDateValidation.HorizontalAlignment = HorizontalAlignment.Left; return; } if (tbEndDate.SelectedDate == null) { tbDateValidation.Text = "Ngày kết thúc không được để trống."; return; } if (DateTime.Compare((DateTime)tbStartDate.SelectedDate, (DateTime)tbEndDate.SelectedDate) > 0) { tbDateValidation.Text = "Ngày kết thúc phải sau ngày bắt đầu."; return; } if (tbPrice.Text == "") { tbRateValidation.Text = "Mức ưu đãi không được để trống."; return; } DTO_Discount discount = new DTO_Discount(); discount.DiscountID = ID; discount.DiscountName = tbName.Text; discount.DiscountValue = float.Parse(tbPrice.Text); discount.StartDate = tbStartDate.SelectedDate.Value.ToString("dd/MM/yyyy"); discount.EndDate = tbEndDate.SelectedDate.Value.ToString("dd/MM/yyyy"); if (busDiscount.editDiscount(discount) > 0) { MessageBox.Show($"Đã sửa ưu đãi {tbName.Text}"); Window.GetWindow(this).Close(); } else { MessageBox.Show($"Đã có lỗi trong quá trình sửa {tbName.Text}"); } }
public PopupDeleteConfirm(DTO_Discount discount, MainWindow context) { InitializeComponent(); ID = discount.DiscountID; name = discount.DiscountName; time = DateTime.ParseExact(discount.StartDate, "dd/MM/yyyy", null); tblContent.Text = "Dữ liệu về " + discount.DiscountName + " sẽ bị xóa vĩnh viễn.\nBạn chắc chắn muốn xóa?"; this._context = context; }
public PopupDiscountDetail(string ID) { InitializeComponent(); bus = new BUS_Discount(); dto = bus.findDiscount(ID); tbDiscountName.Text = dto.DiscountName; tbStartDate.Text = dto.StartDate; tbEndDate.Text = dto.EndDate; tbDiscountRate.Text = dto.DiscountValue.ToString(); tbDescription.Text = dto.Description; }
private void btnCash_Click(object sender, RoutedEventArgs e) { if (billItems.Count == 0) { /// return; } if (newReceiptID != "") { MessageBox.Show($"Hóa đơn này đã thanh toán, mã hóa đơn là {newReceiptID}!"); return; } BUS_Discount busDiscount = new BUS_Discount(); DTO_Discount curDiscount = busDiscount.GetCurrentDiscount(); string disID = ""; if (curDiscount.DiscountValue != 0) { disID = curDiscount.DiscountID; } DTO_Receipt newReceipt = new DTO_Receipt("", user, disID); BUS_Receipt busReceipt = new BUS_Receipt(); newReceiptID = busReceipt.CreateReceipt(newReceipt); if (newReceiptID != "") { BUS_ReceiptDetail busReceiptDetail = new BUS_ReceiptDetail(); bool result = true; foreach (BillItem item in billItems) { DTO_ReceiptDetail newReceiptDetail = new DTO_ReceiptDetail(newReceiptID, item.id, item.amount, item.unitCost); result = result & busReceiptDetail.CreateReceiptDetail(newReceiptDetail); } if (result) { MessageBox.Show("Tạo hóa đơn thành công!"); } else { MessageBox.Show("Đã xảy ra lỗi trong quá trình tạo chi tiết hóa đơn!"); } } else { MessageBox.Show("Đã xảy ra lỗi trong quá trình tạo hóa đơn!"); } }
public int createNewDiscount(DTO_Discount dTO_Discount) { int result = 0; string sql = $"Insert into Discount (DiscountID, DiscountName, StartDate, EndDate, DiscountValue, Description) values ('" + createID() + "','" + dTO_Discount.DiscountName + "','" + dTO_Discount.StartDate + "','" + dTO_Discount.EndDate + "'," + dTO_Discount.DiscountValue + ",'" + dTO_Discount.Description + "');"; try { SQLiteCommand sqlite = getConnection().CreateCommand(); sqlite.CommandText = sql; sqlite.Connection.Open(); result = sqlite.ExecuteNonQuery(); } catch (Exception) { Console.WriteLine(sql); } return(result); }
public int editDiscount(DTO_Discount dTO_Discount) { string sql = $"Update Discount set Discountname = '" + dTO_Discount.DiscountName + "', StartDate = '" + dTO_Discount.StartDate + "', EndDate = '" + dTO_Discount.EndDate + "', DiscountValue = " + dTO_Discount.DiscountValue + ", Description = '" + dTO_Discount.Description + "' Where DiscountID = '" + dTO_Discount.DiscountID + "'"; int rs = 0; try { SQLiteCommand sqlite = getConnection().CreateCommand(); sqlite.CommandText = sql; sqlite.Connection.Open(); rs = sqlite.ExecuteNonQuery(); } catch (Exception ex) { Console.WriteLine(sql); } return(rs); }
private void btnWatch_Click(object sender, RoutedEventArgs e) { DTO_Discount row = (DTO_Discount)dgDiscount.SelectedItem; var rowView = dgDiscount.SelectedItem; System.Windows.Media.Effects.BlurEffect objBlur = new System.Windows.Media.Effects.BlurEffect(); ((MainWindow)App.Current.MainWindow).Opacity = 0.5; ((MainWindow)App.Current.MainWindow).Effect = objBlur; Window window = new Window { ResizeMode = ResizeMode.NoResize, WindowStyle = WindowStyle.None, Title = "Chi tiết ưu đãi", Content = new PopupDiscountDetail(row.DiscountID), Width = 460, Height = 440, WindowStartupLocation = WindowStartupLocation.CenterScreen }; window.ShowDialog(); ((MainWindow)App.Current.MainWindow).Opacity = 1; ((MainWindow)App.Current.MainWindow).Effect = null; }
public void LoadData() { tblockUsername.Text = user; newReceiptID = ""; menuItems = new List <MenuBeverage>(); menuItemsDisplay = new List <MenuBeverage>(); billItems = new List <BillItem>(); total = 0; received = 0; discount = 0; tblockChange.Text = "0 VNĐ"; tblockDiscount.Text = "0"; tblockDiscountAmount.Text = "0 VNĐ"; tblockPayAmount.Text = "0 VNĐ"; tblockTotal.Text = "0 VNĐ"; tboxAmountReceived.Text = "0"; BUS_Beverage busBev = new BUS_Beverage(); DataTable BevsData = busBev.getAllBeverage(); foreach (DataRow row in BevsData.Rows) { string id = row["BeverageID"].ToString(); string name = row["BeverageName"].ToString(); string type = row["BeverageTypeName"].ToString(); int price = Int32.Parse(row["Price"].ToString()); byte[] image = (byte[])row["Link"]; bool isOutOfStock; if (row["IsOutOfStock"].ToString() == "0") { isOutOfStock = false; } else { isOutOfStock = true; } menuItems.Add(new MenuBeverage(id, name, type, price, isOutOfStock, image)); menuItemsDisplay.Add(new MenuBeverage(id, name, type, price, isOutOfStock, image)); } filterButtons = new List <FilterButton>(); filterButtons.Add(new FilterButton("Tất cả", "Tất cả")); DataTable BevTypesData = busBev.GetBeverageTypeInfo(); foreach (DataRow row in BevTypesData.Rows) { string id = row["BeverageTypeID"].ToString(); string name = row["BeverageTypeName"].ToString(); filterButtons.Add(new FilterButton(id, name)); } ListViewMenu.ItemsSource = menuItemsDisplay; ListViewMenu.Items.Refresh(); dgBill.ItemsSource = billItems; dgBill.Items.Refresh(); ListFilterButton.ItemsSource = filterButtons; ListFilterButton.Items.Refresh(); BUS_Discount busDiscount = new BUS_Discount(); DTO_Discount curDiscount = busDiscount.GetCurrentDiscount(); tblockDiscount.Text = curDiscount.DiscountValue.ToString() + " %"; discount = curDiscount.DiscountValue; }
public int editDiscount(DTO_Discount dto) { DAL_Discount dal = new DAL_Discount(); return(dal.editDiscount(dto)); }
public int createNewDiscount(DTO_Discount dto) { DAL_Discount dal = new DAL_Discount(); return(dal.createNewDiscount(dto)); }