public KHACHHANG GetByMaKhachHang(string maKH)
{
var KH = new QuanLyQuanAnDbContext().Database.SqlQuery <KHACHHANG>("select * from KHACHHANG where MAKHACHHANG='" + maKH + "'").First();
KH.GetThongTinAccount();
return(KH);
}
public int TinhTongSoTienLuongChuaThanhToan()
{
try
{
double S = new QuanLyQuanAnDbContext().Database.SqlQuery <double>("Sp_NHANVIEN_TinhTongSoTienLuongChuaThanhToan @maNhanVien='" + MANHANVIEN + "'").First();
return((int)S);
}
catch { return(0); }
}
public static List <NUOCGIAIKHAT> GetAllNuocGiaiKhat()
{
var list = new QuanLyQuanAnDbContext().Database.SqlQuery <NUOCGIAIKHAT>("select * from NUOCGIAIKHAT").ToList();
foreach (var item in list)
{
item.GetAllRefInfo();
}
return(list);
}
public static List <NHANVIEN> GetAllConHoatDong()
{
var list = new QuanLyQuanAnDbContext().Database.SqlQuery <NHANVIEN>("select * from NHANVIEN where TRANGTHAI=1").ToList();
foreach (var item in list)
{
item.GetAllRefInfo();
}
return(list);
}
public static List <MONAN> GetAllMonAn()
{
var list = new QuanLyQuanAnDbContext().Database.SqlQuery <MONAN>("select * from MONAN").ToList();
foreach (var item in list)
{
item.GetAllRefInfo();
}
return(list);
}
public static List <NGUYENLIEU> GetAllNguyenLieu()
{
List <NGUYENLIEU> list = new QuanLyQuanAnDbContext().Database.SqlQuery <NGUYENLIEU>("Select * from NGUYENLIEU").ToList();
foreach (var item in list)
{
item.GetAllRefInfo();
}
return(list);
}
public List <MATHANG> GetAllNuocGiaiKhat_MonAn()
{
List <MATHANG> list = new QuanLyQuanAnDbContext().Database.SqlQuery <MATHANG>("Sp_MATHANG_GetAll_NuocGiaiKhat_MonAn").ToList();
foreach (MATHANG item in list)
{
item.GetInforMatHang();
}
return(list);
}
public static List <MENUMONAN> GetAll()
{
var list = new QuanLyQuanAnDbContext().Database.SqlQuery <MENUMONAN>("select * from MENUMONAN inner join MATHANG on MATHANG.MAMATHANG=MENUMONAN.MAMONAN order by TRANGTHAI DESC, TENMATHANG ASC").ToList();
foreach (var item in list)
{
item.GetAllRefInfo();
}
return(list);
}
public string GetTrangThaiThanhToanLuongHomNay()
{
string date = DateTime.Now.ToString("yyyy/MM/dd");
int dem = new QuanLyQuanAnDbContext().Database.SqlQuery <int>("select count(*) from CHAMCONGNHANVIEN where NGAYCHAMCONG='" + date + "' and MANHANVIEN='" + MANHANVIEN + "'").First();
if (dem > 0)
{
return("Đã chấm công");
}
else
{
return("Chưa chấm công");
}
}
public static List <LOAIMATHANG> GetAllLoaiMatHangNhap()
{
List <LOAIMATHANG> list = new QuanLyQuanAnDbContext().Database.SqlQuery <LOAIMATHANG>("Sp_LOAIMATHANG_GetAllLoaiMatHangNhap").ToList();
return(list);
}
