bool Login(string username, string pass) { string query = "USP_Login @userName , @pass"; clsData data = new clsData(); DataTable kt = data.ExecuteQuery(query, new object[] { username, pass }); return(kt.Rows.Count > 0); }
public static int GetBillByTable(int id) // id cua ban { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("SELECT * FROM HoaDon WHERE idBan = " + id + " AND TrangThai = 0"); if (data.Rows.Count > 0) { Bill bill = new Bill(data.Rows[0]); return(bill.Id); } return(-1); }
public static List <Drink> GetDrinks() { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("select * from Nuoc"); List <Drink> drinks = new List <Drink>(); foreach (DataRow item in data.Rows) { Drink drink = new Drink(item); drinks.Add(drink); } return(drinks); }
public static List <Drink> GetDrinksByCategory(int id) { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("SELECT * FROM Nuoc WHERE idLoai = " + id); List <Drink> drinks = new List <Drink>(); foreach (DataRow item in data.Rows) { Drink drink = new Drink(item); drinks.Add(drink); } return(drinks); }
public static List <Detail_Bill> GetDetail_Bills(int id) { List <Detail_Bill> listBill = new List <Detail_Bill>(); clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("SELECT D.Ten, B.SoLuong, D.Gia, B.SoLuong*D.Gia AS TongTien FROM HoaDon A, ChiTietHD B, Nuoc D WHERE TrangThai=0 AND B.idHD = A.id AND D.id = B.idNuoc AND A.idBan = " + id); foreach (DataRow item in data.Rows) { Detail_Bill billfo = new Detail_Bill(item); listBill.Add(billfo); } return(listBill); }
public static List <BillInfo> GetListBillInfoByBill(int id) // id cua hoa don { List <BillInfo> listBill = new List <BillInfo>(); clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("SELECT * FROM ChiTietHD WHERE idHD = " + id); foreach (DataRow item in data.Rows) { BillInfo binfo = new BillInfo(item); listBill.Add(binfo); } return(listBill); }
public static List <Category> GetCategory() { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("SELECT * FROM Loai"); List <Category> categories = new List <Category>(); foreach (DataRow item in data.Rows) { Category category = new Category(item); categories.Add(category); } return(categories); }
public List <Table> LoadTable() { List <Table> tablelist = new List <Table>(); clsData dt = new clsData(); DataTable dtable = dt.ExecuteQuery("SELECT * FROM Ban"); foreach (DataRow item in dtable.Rows) { Table tb = new Table(item); tablelist.Add(tb); } return(tablelist); }
public static List <Drink> SearchDrinkByName(string name) { clsData dt = new clsData(); List <Drink> list = new List <Drink>(); string query = string.Format("SELECT * FROM Nuoc WHERE Ten LIKE N'%{0}%'", name); DataTable data = dt.ExecuteQuery(query); foreach (DataRow item in data.Rows) { Drink drink = new Drink(item); list.Add(drink); } return(list); }
public static Category GetCategoryByID(int id) { clsData dt = new clsData(); Category category = null; string query = "select * from Loai where id = " + id; DataTable data = dt.ExecuteQuery(query); foreach (DataRow item in data.Rows) { category = new Category(item); return(category); } return(category); }
public static void InsertBill(int id) { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("EXEC USP_InsertBill @idBan", new object[] { id }); }
internal static void DeleteBillInfoByDrinkID(int idDrink) { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("DELETE ChiTietHD WHERE idNuoc = " + idDrink); }
public static void InsertBillInFo(int idBill, int idDrink, int count) { clsData dt = new clsData(); DataTable data = dt.ExecuteQuery("USP_InsertBillInFo @idHD , @idNuoc , @SL", new object[] { idBill, idDrink, count }); }