public static List <KhachHang> GetAllKhachHang() { List <KhachHang> result = new List <KhachHang>(); List <String[]> data = ExecuteQuery.getAll("KhachHang"); for (int i = 0; i < data.Count(); i++) { result.Add(new KhachHang(data[i])); } return(result); }
public static List <HoaDon> GetHDtenKH(String ten) { List <HoaDon> result = new List <HoaDon>(); List <String[]> data = ExecuteQuery.GetHDtenKH(ten); for (int i = 0; i < data.Count(); i++) { result.Add(new HoaDon(data[i])); } return(result); }
public static List <ThietBi> GetAllThietBi() { List <ThietBi> result = new List <ThietBi>(); List <String[]> data = ExecuteQuery.getAll("ThietBi"); for (int i = 0; i < data.Count(); i++) { result.Add(new ThietBi(data[i])); } return(result); }
// Get thiết bị theo loại thiết bị public static List <ThietBi> GetThietBiTheoLoai(String loai) { List <ThietBi> result = new List <ThietBi>(); List <String[]> data = ExecuteQuery.getAll("ThietBi WHERE loai=\'" + loai + "\'"); for (int i = 0; i < data.Count(); i++) { result.Add(new ThietBi(data[i])); } return(result); }
public static List <KhachHang> GetNameKhachhang(string name) { List <KhachHang> result = new List <KhachHang>(); List <String[]> data = ExecuteQuery.getNameKH(name); for (int i = 0; i < data.Count(); i++) { result.Add(new KhachHang(data[i])); } return(result); }
public static List <ChiTietHoaDon> GetAllCTHD() { List <ChiTietHoaDon> result = new List <ChiTietHoaDon>(); List <String[]> data = ExecuteQuery.getAll("CTHoaDon"); for (int i = 0; i < data.Count(); i++) { result.Add(new ChiTietHoaDon(data[i])); } return(result); }
public static HoaDon GetHoaDon(String id) { String[] str = ExecuteQuery.getOne(id, "HoaDon"); if (str.Count() > 0) { return(new HoaDon(str)); } else { return(null); } }
public static int AddHoaDon(HoaDon hd, List <ChiTietHoaDon> cthd) { int i = 0; Console.Out.Write(hd.ToSQLString()); if (ExecuteQuery.AddRows(hd.ToSQLString(), "HoaDon") > 0) { String id = ExecuteQuery.getMahd(); foreach (ChiTietHoaDon x in cthd) { x.Mahd = id; if (CTHDDAO.AddCTHD(x) > 0 && ExecuteQuery.RefeshSL(x.Matb.Matb, x.Soluong) > 0) { i++; } } } return(i); }
public static int DeleteKhachHang(KhachHang kh) { return(ExecuteQuery.DeleteRows(kh.Makh, "KhachHang")); }
public static int DeleteThietBi(ChiTietHoaDon cthd) { return(ExecuteQuery.DeleteRows(cthd.Mahd, "CTHoaDon")); }
public static int AddCTHD(ChiTietHoaDon cthd) { return(ExecuteQuery.AddRows(cthd.ToString(), "CTHoaDon")); }
//Xóa thiết bị public static int DeleteThietBi(ThietBi tb) { return(ExecuteQuery.DeleteRows(tb.Matb, "ThietBi")); }
//Thêm thiết bị public static int AddThietBi(ThietBi tb) { return(ExecuteQuery.AddRows(tb.ToString(), "ThietBi")); }
//Get các loại thiết bị public static String[] LoaiTB() { return(ExecuteQuery.getLoaiTB()); }
public static ThietBi GetThietBi(String id) { return(new ThietBi(ExecuteQuery.getOne(id, "ThietBi"))); }
public static HoaDon GetHoaDon(String id) { return(new HoaDon(ExecuteQuery.getOne(id, "HoaDon"))); }
public static int AddHoaDon(HoaDon hd) { return(ExecuteQuery.AddRows(hd.ToString(), "HoaDon")); }
public static int AddKhachHang(KhachHang kh) { return(ExecuteQuery.AddRows(kh.ToString(), "KhachHang")); }
public static KhachHang GetKhachHang(String id) { return(new KhachHang(ExecuteQuery.getOne(id, "KhachHang"))); }
public static int DeleteHoaDon(HoaDon hd) { return(ExecuteQuery.DeleteRows(hd.Mahd, "HoaDon")); }