public DataTable LayNhanVien()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.NhanViens select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã");
dt.Columns.Add("HọvàTên");
dt.Columns.Add("Tuổi");
dt.Columns.Add("ĐịaChỉ");
dt.Columns.Add("SĐT");
dt.Columns.Add("GiớiTính");
dt.Columns.Add("Loại");
dt.Columns.Add("Ca LV");
dt.Columns.Add("Lương");
foreach (var p in tps)
{
dt.Rows.Add(p.MaNV, p.HoVaTenNV, p.Tuoi, p.DiaChiNV, p.SDT, p.GioiTinh, p.LoaiNV, p.CaLV, p.LuongCB);
}
return(dt);
}
public DataTable LayMonDaChon(string MaHD, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.MonDaChons where p.MaHD == MaHD select p;
//List<MonDaChon> tps = (from p in qlbhEntity.MonDaChons where p.MaHD == MaHD select p).ToList<MonDaChon>();
//List<object> list = qlbhEntity.MonDaChons.Where(p => p.MaHD == ma).Select(p => new {
// MaMon=p.MaMon,
// TenMon=p.TenMon,
// SoLuong=p.SoLuong.ToString(),
// GiaTien=p.GiaMon
// }).ToList<object>();
DataTable dt = new DataTable();
dt.Columns.Add("MaMon");
dt.Columns.Add("TenMon");
dt.Columns.Add("GiaMon");
dt.Columns.Add("SoLuong");
foreach (var p in tps)
{
dt.Rows.Add(p.MaMon, p.TenMon, p.GiaMon, p.SoLuong);
}
return(dt);
}
public bool XoaMonDaChon(ref string err, string MaHD)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
MonDaChon hd = new MonDaChon();
hd.MaHD = MaHD;
qlbhEntity.MonDaChons.Attach(hd);
qlbhEntity.MonDaChons.Remove(hd);
qlbhEntity.SaveChanges();
return(true);
}
public bool XoaKH(ref string err, string MaKH)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
KhachHang kh = new KhachHang();
kh.MaKH = MaKH;
qlbhEntity.KhachHangs.Attach(kh);
qlbhEntity.KhachHangs.Remove(kh);
qlbhEntity.SaveChanges();
return(true);
}
public bool XoaMon(ref string err, string MaMon)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
ThucDon td = new ThucDon();
td.MaMon = MaMon;
qlbhEntity.ThucDons.Attach(td);
qlbhEntity.ThucDons.Remove(td);
qlbhEntity.SaveChanges();
return(true);
}
public bool XoaMon(ref string err, string MaNV)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
NhanVien nv = new NhanVien();
nv.MaNV = MaNV;
qlbhEntity.NhanViens.Attach(nv);
qlbhEntity.NhanViens.Remove(nv);
qlbhEntity.SaveChanges();
return(true);
}
public bool ThemKH(string MaKH, string TenKH, string DiaChi, string SDT, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
KhachHang kh = new KhachHang();
kh.MaKH = MaKH;
kh.TenKH = TenKH;
kh.DiaChiKH = DiaChi;
kh.SDT = SDT;
qlbhEntity.KhachHangs.Add(kh);
qlbhEntity.SaveChanges();
return(true);
}
public bool ThemMon(string MaMon, string TenMon, string GiaMon, string TheLoai, byte[] HinhAnh, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
ThucDon td = new ThucDon();
td.MaMon = MaMon;
td.TenMon = TenMon;
td.GiaMon = GiaMon;
td.TheLoai = TheLoai;
td.HinhAnh = HinhAnh;
qlbhEntity.ThucDons.Add(td);
qlbhEntity.SaveChanges();
return(true);
}
public bool GhiBangHoaDon(string MaHD, string LoaiHD, string TenKH, string TenNV, string Ngay, string ThanhTien, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
HoaDon mdc = new HoaDon();
mdc.MaHD = MaHD;
mdc.LoaiHD = LoaiHD;
mdc.TenKH = TenKH;
mdc.TenNV = TenNV;
mdc.Ngay = Ngay;
mdc.ThanhTien = ThanhTien;
qlbhEntity.HoaDons.Add(mdc);
qlbhEntity.SaveChanges();
return(true);
}
public bool CapNhatMon(string MaMon, string TenMon, string TheLoai, string GiaMon, byte[] HinhAnh, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tpQuery = (from tp in qlbhEntity.ThucDons where tp.MaMon == MaMon select tp).SingleOrDefault();
if (tpQuery != null)
{
tpQuery.MaMon = MaMon;
tpQuery.TenMon = TenMon;
tpQuery.TheLoai = TheLoai;
tpQuery.GiaMon = GiaMon;
qlbhEntity.SaveChanges();
}
return(true);
}
public bool CapNhatKH(string MaKH, string TenKH, string DiaChi, string SDT, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tpQuery = (from tp in qlbhEntity.KhachHangs where tp.MaKH == MaKH select tp).SingleOrDefault();
if (tpQuery != null)
{
tpQuery.MaKH = MaKH;
tpQuery.TenKH = TenKH;
tpQuery.DiaChiKH = DiaChi;
tpQuery.SDT = SDT;
qlbhEntity.SaveChanges();
}
return(true);
}
public DataTable LayTenNV()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.NhanViens select p;
DataTable dt = new DataTable();
dt.Columns.Add("HoVaTenNV");
foreach (var p in tps)
{
dt.Rows.Add(p.HoVaTenNV);
}
return(dt);
}
public DataTable LayTenKH()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.KhachHangs select p;
DataTable dt = new DataTable();
dt.Columns.Add("TenKH");
foreach (var p in tps)
{
dt.Rows.Add(p.TenKH);
}
return(dt);
}
public DataTable KiemTraTaiKhoan()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.UserLogins select p;
DataTable dt = new DataTable();
dt.Columns.Add("User");
dt.Columns.Add("Password");
foreach (var p in tps)
{
dt.Rows.Add(p.UserName, p.Password);
}
return(dt);
}
public bool CapNhat(string User, string Pass, string Quyen, string Ten, string GioiTinh, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tpQuery = (from tp in qlbhEntity.UserLogins where tp.UserName == User select tp).SingleOrDefault();
if (tpQuery != null)
{
tpQuery.UserName = User;
tpQuery.Password = Pass;
tpQuery.Quyen = Quyen;
tpQuery.TenNguoiDung = Ten;
tpQuery.GioiTinh = GioiTinh;
qlbhEntity.SaveChanges();
}
return(true);
}
public DataTable LayKhachHang()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.KhachHangs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã");
dt.Columns.Add("Tên");
dt.Columns.Add("ĐịaChỉ");
dt.Columns.Add("SĐT");
foreach (var p in tps)
{
dt.Rows.Add(p.MaKH, p.TenKH, p.DiaChiKH, p.SDT);
}
return(dt);
}
public DataTable LayThucDon()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.ThucDons select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã Món");
dt.Columns.Add("Tên Món");
dt.Columns.Add("Giá Món");
dt.Columns.Add("Thể Loại");
dt.Columns.Add("Hình Ảnh");
foreach (var p in tps)
{
dt.Rows.Add(p.MaMon, p.TenMon, p.GiaMon, p.TheLoai, p.HinhAnh);
}
return(dt);
}
public DataTable LayTaiKhoan(string Quyen, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.UserLogins where p.Quyen == Quyen select p;
DataTable dt = new DataTable();
dt.Columns.Add("User");
dt.Columns.Add("Password");
dt.Columns.Add("Quyen");
dt.Columns.Add("TenNguoiDung");
dt.Columns.Add("GioiTinh");
foreach (var p in tps)
{
dt.Rows.Add(p.UserName, p.Password, p.Quyen, p.TenNguoiDung, p.GioiTinh);
}
return(dt);
}
public DataTable LayHoaDon()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.HoaDons select p;
DataTable dt = new DataTable();
dt.Columns.Add("MaHD");
dt.Columns.Add("LoạiHD");
dt.Columns.Add("TênKH");
dt.Columns.Add("TênNV");
dt.Columns.Add("Ngày");
dt.Columns.Add("ThànhTiền");
foreach (var p in tps)
{
dt.Rows.Add(p.MaHD, p.LoaiHD, p.TenKH, p.TenNV, p.Ngay, p.ThanhTien);
}
return(dt);
}
public DataTable LayNhanVien1()
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tps = from p in qlbhEntity.NhanViens select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã");
dt.Columns.Add("HọvàTên");
dt.Columns.Add("GiớiTính");
dt.Columns.Add("Loại");
foreach (var p in tps)
{
dt.Rows.Add(p.MaNV, p.HoVaTenNV, p.GioiTinh, p.LoaiNV);
}
return(dt);
}
public bool ThemNV(string MaNV, string TenNV, string Tuoi, string DiaChi, string SDT, string GioiTinh, string LoaiNV,
string Luong, string CaLV, byte[] HinhAnh, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
NhanVien nv = new NhanVien();
nv.MaNV = MaNV;
nv.HoVaTenNV = TenNV;
nv.Tuoi = Tuoi;
nv.DiaChiNV = DiaChi;
nv.SDT = SDT;
nv.GioiTinh = GioiTinh;
nv.LoaiNV = LoaiNV;
nv.LuongCB = Luong;
nv.CaLV = CaLV;
nv.HinhAnh = HinhAnh;
qlbhEntity.NhanViens.Add(nv);
qlbhEntity.SaveChanges();
return(true);
}
public bool GhiBangMonDaChon(string MaHD, string LoaiHD, string MaMon, string MaNV, string MaKH, string TenNV, string TenKH, string TenMon, string Ngay, string GiaMon, string SoLuong, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
MonDaChon mdc = new MonDaChon();
mdc.MaHD = MaHD;
mdc.LoaiHD = LoaiHD;
mdc.MaMon = MaMon;
mdc.MaNV = MaNV;
mdc.MaKh = MaKH;
mdc.TenNV = TenNV;
mdc.TenKH = TenKH;
mdc.TenMon = TenMon;
mdc.Ngay = Ngay;
mdc.GiaMon = GiaMon;
mdc.SoLuong = SoLuong;
qlbhEntity.MonDaChons.Add(mdc);
qlbhEntity.SaveChanges();
return(true);
}
public bool CapNhatNV(string MaNV, string TenNV, string Tuoi, string DiaChi, string SDT, string GioiTinh, string LoaiNV,
string Luong, string CaLV, byte[] HinhAnh, ref string err)
{
ManagementCoffeeEntities qlbhEntity = new ManagementCoffeeEntities();
var tpQuery = (from tp in qlbhEntity.NhanViens where tp.MaNV == MaNV select tp).SingleOrDefault();
if (tpQuery != null)
{
tpQuery.MaNV = MaNV;
tpQuery.HoVaTenNV = TenNV;
tpQuery.Tuoi = Tuoi;
tpQuery.DiaChiNV = DiaChi;
tpQuery.SDT = SDT;
tpQuery.GioiTinh = GioiTinh;
tpQuery.LoaiNV = LoaiNV;
tpQuery.LuongCB = Luong;
tpQuery.CaLV = CaLV;
tpQuery.HinhAnh = HinhAnh;
qlbhEntity.SaveChanges();
}
return(true);
}
