public string LayCongViecById(int id)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var queryCV = ql.CONGVIECs.Where(x => x.IDCongViec == id).Select(x => x.TenCongViec).SingleOrDefault();
return(queryCV);
}
public bool CapNhatNhanVien(string IDNhanVien, string Ho, int IDCongViec, string Ten, string Email, DateTime NgaySinh, string DiaChi, string DienThoai, string HinhNV)
{
QuanLyNhaHangProjectEntities qlbhEntity = new QuanLyNhaHangProjectEntities();
var nvq = (from nv in qlbhEntity.NHANVIENs
where nv.IDNhanVien == IDNhanVien
select nv).SingleOrDefault();
if (nvq == null)
{
return(false);
}
nvq.IDCongViec = IDCongViec;
nvq.Ho = Ho;
nvq.Ten = Ten;
nvq.Email = Email;
nvq.NgaySinh = NgaySinh;
nvq.DiaChi = DiaChi;
nvq.SDT = DienThoai;
if (HinhNV != string.Empty)
{
nvq.HinhNV = HinhNV;
}
qlbhEntity.SaveChanges();
return(true);
}
int LayIdMonNuocMoiNhat()
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var m = ql.MONANs.OrderByDescending(x => x.IDMonAn).FirstOrDefault();
return(int.Parse(m.IDMonAn.Split('U')[1]));
}
public DataTable LayChiTietHoaDon(string IDHoaDon)
{
QuanLyNhaHangProjectEntities qlCF = new QuanLyNhaHangProjectEntities();
var queryCTHoaDon = from cthd in qlCF.CHITIETHOADONs
join ma in qlCF.MONANs on cthd.IDMonAn equals ma.IDMonAn
where cthd.IDHoaDon == IDHoaDon
select new { cthd.IDHoaDon, ma.TenMon, ma.GiaTien, cthd.SoLuong, ThanhTien = ma.GiaTien * cthd.SoLuong };
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[]
{
new DataColumn("IDHoaDon"),
new DataColumn("TenMon"),
new DataColumn("GiaTien"),
new DataColumn("SoLuong"),
new DataColumn("ThanhTien"),
});;
foreach (var i in queryCTHoaDon)
{
dt.Rows.Add(i.IDHoaDon, i.TenMon, i.GiaTien, i.SoLuong, i.ThanhTien);
}
return(dt);
}
//Hàm lấy bảng các hóa đơn từ ngày batdau đến ngày ketthuc, kích hoạt khi thay đổi value dateTimePicker
public DataTable LayHoaDon(DateTime batdau, DateTime ketthuc)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[]
{
new DataColumn("IDHoaDon"),
new DataColumn("NhanVien"),
new DataColumn("NgayLap"),
new DataColumn("NgayThanhToan"),
new DataColumn("TongTien")
});
DateTime kt = ketthuc.AddDays(1);
var hoadon = ql.HOADONs.OrderBy(x => x.NgayLap).Where(x => (x.NgayLap < kt.Date && x.NgayLap >= batdau.Date)).Select(x => x);
foreach (HOADON hd in hoadon)
{
string ngaylap = hd.NgayLap.ToString("HH:mm dd/MM/yyyy");
string ngaythanhtoan;
if (hd.NgayThanhToan != null)
{
ngaythanhtoan = hd.NgayThanhToan.GetValueOrDefault().ToString("HH:mm dd/MM/yyyy");
}
else
{
ngaythanhtoan = "";
}
dt.Rows.Add(hd.IDHoaDon, hd.IDNhanVien, ngaylap, ngaythanhtoan, hd.TongTien);
}
return(dt);
}
public HOADON LayHoaDonID(string ID) //Không sử dụng
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var hoadon = (ql.HOADONs.Where(x => x.IDHoaDon == ID).Select(x => x)).SingleOrDefault();
return(hoadon);
}
public int LayDonGia(string IDMonAn)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
int gia = (from nu in ql.MONANs
where nu.IDMonAn == IDMonAn
select nu.GiaTien).SingleOrDefault();
return(gia);
}
public string LayIDMonNuoc(string TenMon)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
string id = (from nu in ql.MONANs
where nu.TenMon == TenMon
select nu.IDMonAn).SingleOrDefault();
return(id);
}
public bool TrangThai(int IDBan)
{
QuanLyNhaHangProjectEntities qlCF = new QuanLyNhaHangProjectEntities();
BAN kq = (from tt in qlCF.BANs
where tt.IDBan == IDBan
select tt).SingleOrDefault();
return(kq.TrangThai);
}
//2 hàm trên hỗ trợ việc đưa thời gian vào 2 datetimepicker khi mới mở form
public bool CheckExist()
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
if (ql.HOADONs.Count() > 0)
{
return(true);
}
return(false);
}
//Hàm xóa món ăn dựa trên tên món sử dụng trong frmQuanLyMon
public void XoaMonAn_TenMon(string tenMon)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var m = (from nu in ql.MONANs
where nu.TenMon == tenMon
select nu).SingleOrDefault();
m.TrangThai = true;
ql.SaveChanges();
}
public DateTime layNgayLap(string ID)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
DateTime result = ql.HOADONs.Where(x => x.IDHoaDon == ID).Select(x => x.NgayLap).FirstOrDefault();
if (result != default)
{
return(result);
}
return(DateTime.Now);
}
//Hàm lấy thời gian lập của bill gần nhất
public DateTime TimeOfLastBill()
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
DateTime result = ql.HOADONs.OrderByDescending(x => x.NgayLap).Select(x => x.NgayLap).FirstOrDefault();
if (result != default)
{
return(result.AddDays(1).Date);
}
return(DateTime.Now.Date);
}
public bool XoaNhanVien(string IDNhanVien)
{
QuanLyNhaHangProjectEntities qlbhEntity = new QuanLyNhaHangProjectEntities();
NHANVIEN nv = new NHANVIEN();
nv.IDNhanVien = IDNhanVien;
qlbhEntity.NHANVIENs.Attach(nv);
qlbhEntity.NHANVIENs.Remove(nv);
qlbhEntity.SaveChanges();
return(true);
}
public DataTable LayChiTietHoaDonBan(int IDBan)
{
QuanLyNhaHangProjectEntities qlCF = new QuanLyNhaHangProjectEntities();
var IDHoaDon = qlCF.HOADONs
.Where(x => x.IDBan == IDBan)
.Where(x => x.NgayLap < DateTime.Now)
.Where(x => x.NgayThanhToan == null)
.Select(x => x.IDHoaDon).SingleOrDefault();
return(BLChiTietHoaDon.Instance.LayChiTietHoaDon(IDHoaDon));
}
public bool XoaBan(int idBan)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
BAN ban = new BAN();
ban.IDBan = idBan;
ql.BANs.Attach(ban);
ql.BANs.Remove(ban);
ql.SaveChanges();
return(true);
}
public bool ThanhToanHoaDon(string idHoaDon)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var hd = ql.HOADONs.Find(idHoaDon);
if (hd != null)
{
hd.NgayThanhToan = DateTime.Now;
ql.SaveChanges();
}
return(true);
}
public bool ThemBan(int idBan, string TenBan, int SucChua)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var id = ql.BANs.OrderByDescending(x => x.IDBan).FirstOrDefault();
BAN ban = new BAN();
ban.TenBan = TenBan;
ban.SucChua = SucChua;
ql.BANs.Add(ban);
ql.SaveChanges();
return(true);
}
public string LayIDNhanVien(string taikhoan)
{
QuanLyNhaHangProjectEntities qlCF = new QuanLyNhaHangProjectEntities();
TAIKHOAN tk = (from TK in qlCF.TAIKHOANs
where TK.TaiKhoan1 == taikhoan
select TK).SingleOrDefault();
if (tk != null)
{
return(tk.IDNhanVien);
}
return("");
}
public void ThemMonAn(string tenMon, int danhMucMon, int giaMon, string pathHinh)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var m = ql.MONANs.OrderByDescending(x => x.IDMonAn).FirstOrDefault();
int idMonNuoc = int.Parse(m.IDMonAn.Split('A')[1]);
MONAN ma = new MONAN();
ma.IDMonAn = idMonNuoc >= 100 ? "MA" + (idMonNuoc + 1) : "MA0" + (idMonNuoc + 1);
ma.IDDanhMuc = danhMucMon;
ma.TenMon = tenMon;
ma.GiaTien = giaMon;
ma.HinhMA = pathHinh;
ql.MONANs.Add(ma);
ql.SaveChanges();
}
public void CapNhatMon_TenMon(string tenMon, string tenMonMoi, int giaMon, string pathHinh)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var m = (from nu in ql.MONANs
where nu.TenMon == tenMon
select nu).SingleOrDefault();
m.TenMon = tenMonMoi;
m.GiaTien = giaMon;
if (pathHinh != string.Empty)
{
m.HinhMA = pathHinh;
}
ql.SaveChanges();
}
public void ThayDoiTrangThai(int idBan)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var ban = ql.BANs.Find(idBan);
if (ban != null)
{
ban.TrangThai = !ban.TrangThai;
}
else
{
return;
}
ql.SaveChanges();
}
public bool CapNhatBan(int idBan, string TenBan, int SucChua)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var ban = (from b in ql.BANs
where b.IDBan == idBan
select b).SingleOrDefault();
if (ban == null)
{
return(false);
}
ban.TenBan = TenBan;
ban.SucChua = SucChua;
ql.SaveChanges();
return(true);
}
public bool XoaDanhMuc(int IDDanhMuc)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var dmQuery = (from item
in ql.DANHMUCs
where item.IDDanhMuc == IDDanhMuc
select item).SingleOrDefault();
if (dmQuery != null)
{
ql.DANHMUCs.Attach(dmQuery);
ql.DANHMUCs.Remove(dmQuery);
ql.SaveChanges();
}
return(true);
}
public bool CapNhatDanhMuc(int IDDanhMuc, string TenDanhMuc)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var dmQuery = (from item
in ql.DANHMUCs
where item.IDDanhMuc == IDDanhMuc
select item).SingleOrDefault();
if (dmQuery == null)
{
return(false);
}
dmQuery.TenDanhMuc = TenDanhMuc;
ql.SaveChanges();
return(true);
}
public List <DANHMUC> LayTenDanhMuc()
{
List <DANHMUC> lstTabDanhMuc = new List <DANHMUC>();
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var tdm = from dm in ql.DANHMUCs
where dm.TrangThai == false
select new { dm.IDDanhMuc, dm.TenDanhMuc };
foreach (var item in tdm.ToList())
{
DANHMUC dm = new DANHMUC();
dm.IDDanhMuc = item.IDDanhMuc;
dm.TenDanhMuc = item.TenDanhMuc;
lstTabDanhMuc.Add(dm);
}
return(lstTabDanhMuc);
}
public void ThemChiTietHoaDon(string IDHoaDon, string IDMonNuoc, int SoLuong, int GiaTien)
{
QuanLyNhaHangProjectEntities qlCF = new QuanLyNhaHangProjectEntities();
CHITIETHOADON cthd = new CHITIETHOADON();
cthd.IDHoaDon = IDHoaDon;
cthd.IDMonAn = IDMonNuoc;
cthd.SoLuong = SoLuong;
qlCF.CHITIETHOADONs.Add(cthd);
try
{
qlCF.SaveChanges();
}
catch
{
MessageBox.Show("Đã có lỗi xảy ra, vui lòng thử lại sau!");
}
}
public byte checkLogin(string taikhoan, string matkhau)
{
QuanLyNhaHangProjectEntities qlCF = new QuanLyNhaHangProjectEntities();
TAIKHOAN tk = null;
tk = (from TK in qlCF.TAIKHOANs
where TK.TaiKhoan1 == taikhoan && TK.MatKhau == matkhau
select TK).SingleOrDefault();
if (tk == null)
{
return(0);
}
if (tk != null)
{
return(1);
}
return(0);
}
public DataTable LayCongViecCB()
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var queryCV = ql.CONGVIECs.Select(x => x);
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[]
{
new DataColumn("ID"),
new DataColumn("TenCongViec")
});
foreach (var i in queryCV)
{
dt.Rows.Add(i.IDCongViec, i.TenCongViec);
}
return(dt);
}
public bool DoiMatKhau(string oldPass, string newPass, string idNhanVien)
{
QuanLyNhaHangProjectEntities ql = new QuanLyNhaHangProjectEntities();
var query = ql.TAIKHOANs.Where(x => x.IDNhanVien == idNhanVien).SingleOrDefault();
if (query != null)
{
if (query.MatKhau == oldPass)
{
query.MatKhau = newPass;
ql.SaveChanges();
}
else
{
return(false);
}
}
return(true);
}
