public bool ThemHoaDon(ref string err, string MaHD, string MaBan, string MaNV, DateTime NgayLapHD, double PhuThu, double VAT, bool DaThanhToan)
{
try
{
var hd = new HoaDon()
{
MaHD = MaHD,
MaBan = MaBan,
MaNV = MaNV,
NgayLapHD = NgayLapHD,
PhuThu = PhuThu,
VAT = VAT,
DaThanhToan = DaThanhToan
};
db.HoaDon.Add(hd);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
err = ex.Message;
return(false);
}
}
public void CapNhat(NhanVien nv0)
{
try
{
NhanVien nv = db.NhanVien.Find(nv0.MaNV);
if (nv != null)
{
nv.MaNV = nv0.MaNV;
nv.HoTen = nv0.HoTen;
nv.NgaySinh = nv0.NgaySinh;
nv.Phai = nv0.Phai;
nv.CMND = nv0.CMND;
nv.SDT = nv0.SDT;
nv.DiaChi = nv0.DiaChi;
nv.NgayVaoLam = nv0.NgayVaoLam;
nv.MatKhau = nv0.MatKhau;
nv.Quyen = nv0.Quyen;
nv.Status = nv0.Status;
db.SaveChanges();
}
}
catch
{
}
}
public void Xoa(string MaNV, string MaCa, string MaKV)
{
try
{
PhanCong pc = db.PhanCong.Find(MaNV, MaCa, MaKV);
if (pc != null)
{
db.PhanCong.Remove(pc);
db.SaveChanges();
}
}
catch
{
}
}
public void Xoa(string MaPhieuChi)
{
try
{
PhieuChi pc = db.PhieuChi.Find(MaPhieuChi);
if (pc != null)
{
db.PhieuChi.Remove(pc);
db.SaveChanges();
}
}
catch
{
}
}
public void CapNhatTinhTrangCuaBan(string MaBan, bool TinhTrang)
{
try
{
Ban b = db.Ban.Find(MaBan);
if (b != null)
{
b.TinhTrang = TinhTrang;
db.SaveChanges();
}
}
catch
{
}
}
public void ThemLoaiMon(LoaiMon lm)
{
try
{
var l = new LoaiMon()
{
MaLoaiMon = lm.MaLoaiMon,
TenLoaiMon = lm.TenLoaiMon
};
db.LoaiMon.Add(l);
db.SaveChanges();
}
catch
{
}
}
public void Them(KhuVuc kv)
{
try
{
var k = new KhuVuc()
{
MaKV = kv.MaKV,
TenKV = kv.TenKV
};
db.KhuVuc.Add(k);
db.SaveChanges();
}
catch
{
}
}
public void Them(CaLamViec ca)
{
try
{
var c = new CaLamViec()
{
MaCa = ca.MaCa,
TenCa = ca.TenCa,
GioBatDau = ca.GioBatDau,
GioKetThuc = ca.GioKetThuc,
MucLuong = ca.MucLuong
};
db.CaLamViec.Add(c);
db.SaveChanges();
}
catch
{
}
}
public void ThemLichSu(LichSuHoatDong ls)
{
try
{
var l = new LichSuHoatDong()
{
MaLichSu = ls.MaLichSu,
MaNV = ls.MaNV,
HoTen = ls.HoTen,
HoatDong = ls.HoatDong,
ThoiGian = ls.ThoiGian,
TinhTrang = ls.TinhTrang
};
db.LichSuHoatDong.Add(l);
db.SaveChanges();
}
catch
{
}
}
public void CapNhat(string TenQuan, string DiaChi, string SDT, string Email, byte[] HinhAnh)
{
try
{
ThongTinQuan tt = db.ThongTinQuan.Find("0");
if (tt != null)
{
tt.TenQuan = TenQuan;
tt.DiaChi = DiaChi;
tt.SDT = SDT;
tt.Email = Email;
tt.HinhAnh = HinhAnh;
db.SaveChanges();
}
}
catch
{
}
}
//Cập nhật
public void CapNhat(ChamCong cc)
{
try
{
ChamCong c = db.ChamCong.Find(cc.ID, cc.MaNV, cc.MaCa, cc.MaKV);
if (c != null)
{
c.ID = cc.ID;
c.MaNV = cc.MaNV;
c.MaCa = cc.MaCa;
c.MaKV = cc.MaKV;
c.Thang = cc.Thang;
c.Nam = cc.Nam;
c.TinhTrang = cc.TinhTrang;
db.SaveChanges();
}
}
catch
{
}
}
public bool ThemChiTietHoaDon(string MaHD, string MaMon, double DonGia, int SoLuong, string GhiChu)
{
try
{
var ct = new ChiTietHoaDon()
{
MaHD = MaHD,
MaMon = MaMon,
DonGia = DonGia,
SoLuong = SoLuong,
GhiChu = GhiChu
};
db.ChiTietHoaDon.Add(ct);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}
public bool ThemMon(Mon mon)
{
try
{
var m = new Mon()
{
MaMon = mon.MaMon,
MaLoaiMon = mon.MaLoaiMon,
TenMon = mon.TenMon,
SoLuong = mon.SoLuong,
DonGia = mon.DonGia,
GiaNhap = mon.GiaNhap
};
db.Mon.Add(m);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
}
}