public static DataTable getAll()
{
string sql = "select t.MaTaiKhoan, t.HoTen, t.SoCMND, t.NgayVaoLam, t.NgaySinh, t.email, t.SoDienThoai, t.Username, t.PassWord," +
"(CASE t.GioiTinh WHEN 1 THEN N'Nam' WHEN 0 THEN N'Nữ' END) AS GioiTinh, (CASE t.Deleted WHEN 0 THEN N'Đang hoạt động' WHEN 1 THEN N'Đã xóa' END) AS Deleted,"
+ " nv.TenLoaiNhanVien, t.Active"
+ " from TaiKhoan t, LOAINHANVIEN nv where t.LoaiTaiKhoan = nv.MaLoaiNV";
return(DTObject.exec(sql));
}
public static bool create(string[] value)
{
string[] col = { "NgayLap", "TongGia", "NhanVien", "Phong", "MaPhieuThue" };
return(DTObject.insert("HOADON", col, value));
}
public static bool create(string[] value)
{
string[] col = { "TenPhieuThue", "TinhTrangPhieuThue", "MaPhong", "NgayLap", "NgayBatDau", "NgayKetThuc", "MaKH" };
return(DTObject.insert("PHIEUTHUE", col, value));
}
public static DataTable getAll()
{
return(DTObject.getAll("PHIEUTHUE"));
}
public static bool create(string[] value)
{
string[] col = { "TenDichVu", "Gia" };
return(DTObject.insert("DICHVU", col, value));
}
public static DataTable getAll()
{
return(DTObject.getAll("DICHVU"));
}
public static DataTable getHoaDon()
{
return(DTObject.getAll("HOADON"));
}
public static bool create(string[] value)
{
string[] col = { "MaHD", "MaDichVu", "NgaySuDung", "Phong" };
return(DTObject.insert("CHITIETHOADON", col, value));
}
public static bool create(string[] value)
{
string[] col = { "HoTen", "SoCMND", "NgayVaoLam", "NgaySinh", "email", "SoDienThoai", "Username", "PassWord", "LoaiTaiKhoan", "GioiTinh", "Deleted", "Active" };
return(DTObject.insert("TAIKHOAN", col, value));
}
public static DataTable get_loainhanvien()
{
return(DTObject.getAll("LOAINHANVIEN"));
}