public static void CheckOut(int id)
{
string query = "UPDATE HoaDon SET TrangThai = 1, NgayRa = GETDATE() WHERE id = " + id;
clsData dt = new clsData();
dt.ExecuteNonQuery(query);
}
public static bool UpdateDrink(int id, string name, int idType, float price)
{
clsData dt = new clsData();
string query = string.Format("UPDATE Nuoc SET Ten = N'{0}', idLoai = {1}, Gia = {2} WHERE id = {3} ", name, idType, price, id);
int result = dt.ExecuteNonQuery(query);
return(result > 0);
}
public static bool InsertDrink(string name, int idType, float price)
{
clsData dt = new clsData();
string query = string.Format("INSERT Nuoc (Ten, idLoai, Gia) VALUES ( N'{0}', {1}, {2})", name, idType, price);
int result = dt.ExecuteNonQuery(query);
return(result > 0);
}
public static bool DeleteDrinks(int idDrink)
{
BillInfoDAO.DeleteBillInfoByDrinkID(idDrink);
clsData dt = new clsData();
string query = string.Format("Delete Nuoc where id = {0}", idDrink);
int result = dt.ExecuteNonQuery(query);
return(result > 0);
}
