private void btnDelete_Click(object sender, RoutedEventArgs e) { DTO_Beverage row = (DTO_Beverage)dgMenu.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 món", Content = new PopupDeleteConfirm(row, this._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(); }
private void btSave_Click(object sender, RoutedEventArgs e) { tbNameValidation.Text = tbPriceValidation.Text = ""; if (tbName.Text == "") { tbNameValidation.Text = "Tên món không được để trống."; return; } if (tbPrice.Text == "") { tbPriceValidation.Text = "Giá không được để trống."; return; } DTO_Beverage beverage = new DTO_Beverage(); beverage.BeverageID = ID; beverage.BeverageName = tbName.Text; beverage.BeverageTypeID = bus.getBeverageTypeID(cbBeverageType.Text); beverage.Price = Int32.Parse(tbPrice.Text); beverage.Link = imageBytes; if (bus.editBevverage(beverage) > 0) { MessageBox.Show($"Đã sửa thông tin của {tbName.Text}"); Window.GetWindow(this).Close(); } else { MessageBox.Show($"Đã có lỗi trong quá trình chỉnh sửa {tbName.Text}"); } }
public PopupDeleteConfirm(DTO_Beverage beverage, MainWindow context) { InitializeComponent(); tblContent.Text = "Dữ liệu về " + beverage.BeverageName + " sẽ bị xóa vĩnh viễn.\nBạn chắc chắn muốn xóa?"; ID = beverage.BeverageID; name = beverage.BeverageName; this._context = context; }
public int createNewBeverage(DTO_Beverage beverage) { int rs = 0; string sql = $"Insert into BeverageName values ('" + beverage.BeverageID + "','" + beverage.BeverageTypeID + "','" + beverage.BeverageName + "'," + beverage.Price + ", false, 'Cup', @image)"; try { SQLiteCommand command = new SQLiteCommand(sql, getConnection()); command.Parameters.Add("@image", DbType.Binary, 20).Value = beverage.Link; command.Connection.Open(); rs = command.ExecuteNonQuery(); } catch (Exception ex) { Console.Error.WriteLine(ex.Message); } return(rs); }
public int editBeverage(DTO_Beverage beverage) { int rs = 0; Console.WriteLine(beverage.BeverageID); string sql = $"Update BeverageName set BeverageTypeID='" + beverage.BeverageTypeID + "', BeverageName='" + beverage.BeverageName + "', Price=" + beverage.Price + ",IsOutOfStock=" + beverage.IsOutOfStock + ",Unit='" + beverage.Unit + $"' , Link=@image Where BeverageID='" + beverage.BeverageID + "'"; try { SQLiteCommand command = new SQLiteCommand(sql, getConnection()); command.Parameters.Add("@image", DbType.Binary, 20).Value = beverage.Link; command.Connection.Open(); rs = command.ExecuteNonQuery(); } catch (Exception ex) { Console.Error.WriteLine(ex.Message); } return(rs); }
private void btnEdit_Click(object sender, RoutedEventArgs e) { DTO_Beverage row = (DTO_Beverage)dgMenu.SelectedItem; var rowView = dgMenu.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 = "Sửa món", Content = new PopupEditMenu(row.BeverageName, row.BeverageTypeID, row.Price.ToString(), row.BeverageID, row.Link, this._context), Width = 460, Height = 620, WindowStartupLocation = WindowStartupLocation.CenterScreen }; window.ShowDialog(); ((MainWindow)App.Current.MainWindow).Opacity = 1; ((MainWindow)App.Current.MainWindow).Effect = null; loadData(); }
public int editBevverage(DTO_Beverage beverage) { return(dalBeverage.editBeverage(beverage)); }
public int createNewBevverage(DTO_Beverage beverage) { return(dalBeverage.createNewBeverage(beverage)); }