public void LoadCategoryByid(int id)
{
List <Drink> drinks = DrinkDAO.GetDrinksByCategory(id);
cbDrink.DataSource = drinks;
cbDrink.DisplayMember = "Name";
}
// lay ra nuoc theo tung nhom
private void LoadDrink(int id)
{
List <Drink> drinks = DrinkDAO.GetDrinksByCategory(id);
cbDrink.DataSource = drinks;
cbDrink.DisplayMember = "Name";
}
private void btnDeleteDrink_Click(object sender, EventArgs e)
{
int id = Convert.ToInt32(txtID.Text);
if (DrinkDAO.DeleteDrinks(id))
{
LoadListDrinks();
MessageBox.Show("Xóa món thành công.");
if (delete != null)
{
delete(this, new EventArgs());
}
}
else
{
MessageBox.Show("Xóa món thất bại.");
}
}
private void btnAddDrink_Click(object sender, EventArgs e)
{
string name = txtName.Text;
int idCategory = (cboType.SelectedItem as Category).ID;
float prices = float.Parse(txtPrices.Text.ToString());
if (DrinkDAO.InsertDrink(name, idCategory, prices))
{
LoadListDrinks();
MessageBox.Show("Thêm món thành công.");
if (insert != null)
{
insert(this, new EventArgs());
}
}
else
{
MessageBox.Show("Thêm món thất bại.");
}
}
private void btnEditDrink_Click(object sender, EventArgs e)
{
string name = txtName.Text;
int idCategory = (cboType.SelectedItem as Category).ID;
float prices = float.Parse(txtPrices.Text.ToString());
int id = Convert.ToInt32(txtID.Text);
if (DrinkDAO.UpdateDrink(id, name, idCategory, prices))
{
LoadListDrinks();
MessageBox.Show("Sửa món thành công.");
if (updatedrink != null)
{
updatedrink(this, new EventArgs());
}
}
else
{
MessageBox.Show("Sửa món thất bại.");
}
}
public Form1()
{
InitializeComponent();
DrinkDAO.Get_DB();
}
/*public void LoadListAccount()
* {
* string query = "EXEC dbo.USP_GetAccountByUserName @userName";
* clsData data = new clsData();
* dtgvAccount.DataSource = data.ExecuteQuery(query, new object[] { "Nguyễn Thị Thuý Nga" });
* }*/
public void LoadListDrinks()
{
listDrinks.DataSource = DrinkDAO.GetDrinks();
}
List <Drink> SearchFoodByName(string name)
{
List <Drink> listFood = DrinkDAO.SearchDrinkByName(name);
return(listFood);
}
public static List <DrinkDTO> GetListDrinkByID(int id)
{
return(DrinkDAO.GetListDrinkByID(id));
}
public static int GetIDTypeDrinkByIDDrink(int id)
{
return(DrinkDAO.GetIDTypeDrinkByIDDrink(id));
}
public static bool UpdateDrink(DrinkDTO sp)
{
return(DrinkDAO.UpdateDrink(sp));
}
public static bool DeleteDrink(DrinkDTO sp)
{
return(DrinkDAO.DeleteDrink(sp));
}
public static int GetIDDrinkMax()
{
return(DrinkDAO.GetIDDrinkMax());
}
public static bool InsertDrink(DrinkDTO sp)
{
return(DrinkDAO.InsertDrink(sp));
}
public static List <DrinkDTO> GetAllListDrink()
{
return(DrinkDAO.GetAllListDrink());
}
public static List <DrinkDTO> GeDrinkByName(string name)
{
return(DrinkDAO.GeDrinkByName(name));
}
public static List <DrinkDTO> GetListDrinkByIDTypeDrink(int id, int status)
{
return(DrinkDAO.GetListDrinkByIDTypeDrink(id, status));
}
