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