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