public void ThemDichVuVaoHD(chitiethoadon cthd)
{
var query = db.chitiethoadons.Where(p => p.mahoadon == cthd.mahoadon && p.madichvu == cthd.madichvu).Count();
if (query == 0)
{
db.chitiethoadons.Add(cthd);
db.SaveChanges();
}
else
{
MessageBox.Show("Bạn đã chọn dịch vụ này!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void ThemDichVu(dichvu dv)
{
var query = db.dichvus.Where(p => p.madichvu == dv.madichvu).Count();
if (query == 0)
{
db.dichvus.Add(dv);
db.SaveChanges();
MessageBox.Show("Thêm thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Lỗi! Nhập thiếu thông tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Delete_NV(int manv)
{
qlchungcuEntities db = new qlchungcuEntities();
var nv = db.nhanviens.Where(p => p.manhanvien == manv).SingleOrDefault();
db.nhanviens.Remove(nv);
db.SaveChanges();
}
public void Delete_TK(int manv)
{
qlchungcuEntities db = new qlchungcuEntities();
var tk = db.taikhoans.Where(p => p.manhanvien == manv).SingleOrDefault();
db.taikhoans.Remove(tk);
db.SaveChanges();
}
public bool Add_TK(taikhoan tk)
{
try
{
var query = db.taikhoans.Where(p => p.tendangnhap == tk.tendangnhap).Count();
if (query == 0)
{
db.taikhoans.Add(tk);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
public bool Add_NV(nhanvien nv)
{
try
{
var query = db.nhanviens.Where(p => p.manhanvien == nv.manhanvien).Count();
if (query == 0)
{
db.nhanviens.Add(nv);
db.SaveChanges();
}
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
public void AddorUpdate(hopdong a)
{
if (db.hopdongs.Where(p => p.mahopdong.Equals(a.mahopdong)).Select(p => p).FirstOrDefault() != null)
{
var l1 = db.hopdongs.Where(p => p.mahopdong.Equals(a.mahopdong)).Select(p => p).FirstOrDefault();
l1.mahopdong = a.mahopdong;
l1.maho = a.maho;
l1.macanho = a.macanho;
l1.giatien = a.giatien;
l1.thoihan = a.thoihan;
l1.manhanvien = a.manhanvien;
l1.ngayki = a.ngayki;
l1.dahuy = a.dahuy;
l1.tenhopdong = a.tenhopdong;
db.SaveChanges();
}
else
{
db.hopdongs.Add(a);
db.SaveChanges();
}
}
public bool Edit_TK(taikhoan tk)
{
try
{
qlchungcuEntities db = new qlchungcuEntities();
var l = (from p in db.taikhoans
where p.tendangnhap == tk.tendangnhap
select p).SingleOrDefault();
l.tendangnhap = tk.tendangnhap;
l.matkhau = tk.matkhau;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
public bool Edit_NV(nhanvien nv)
{
try
{
qlchungcuEntities db = new qlchungcuEntities();
var query = (from p in db.nhanviens
where p.manhanvien == nv.manhanvien
select p).SingleOrDefault();
query.manhanvien = nv.manhanvien;
query.tennhanvien = nv.tennhanvien;
query.ngaysinh = nv.ngaysinh;
query.gioitinh = nv.gioitinh;
query.sdt = nv.sdt;
query.cmnd = nv.cmnd;
query.machucvu = nv.machucvu;
db.SaveChanges();
return(true);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(false);
}
}
public void ADD(hogiadinh a)
{
db.hogiadinhs.Add(a);
db.SaveChanges();
}
