public bool deleteCTPhieuNhap(int maPhieu, int madc)
{
bool check = false;
using (ContextEntites con = new ContextEntites())
{
try
{
var lpn = con.CTPHIEUNHAPs.Where(x => (x.MAPHIEU == maPhieu && x.MADC == madc)).ToList();
foreach (var pn in lpn)
{
con.CTPHIEUNHAPs.Remove(pn);
}
if (con.SaveChanges() > 0)
{
check = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(check);
}
public bool deleteCTHD(int mahd)
{
bool check = false;
using (ContextEntites con = new ContextEntites())
{
try
{
var cts = con.CTHDs.Where(x => (x.MAHD == mahd));
foreach (CTHD ct in cts)
{
con.CTHDs.Remove(ct);
}
if (con.SaveChanges() >= 0)
{
check = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(check);
}
public bool editac(ACCOUNT kh)
{
bool chek = false;
using (ContextEntites context = new ContextEntites())
{
try
{
var s = context.ACCOUNTs.Single(x => x.ID == kh.ID);
s.ID = kh.ID;
s.PASS = kh.PASS;
s.USERNAME = kh.USERNAME;
if (context.SaveChanges() >= 0)
{
chek = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(chek);
//change
}
public int AddHoaDon(HOADON hd)
{
int s = 0;
using (ContextEntites cn = new ContextEntites())
{
try
{
cn.HOADONs.Add(hd);
var bc = cn.BAOCAOs.Where(x => (x.NGAYBAOCAO == hd.NGAYHD.Date));
Console.WriteLine(bc.Count());
if ((bc.Count() == 0))
{
BAOCAO b = new BAOCAO();
b.NGAYBAOCAO = hd.NGAYHD;
b.TONGGIATRI = 0;
cn.BAOCAOs.Add(b);
}
s = cn.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
s = 0;
}
}
return(s);
}
public bool editNV(NHANVIEN kh)
{
bool chek = false;
using (ContextEntites context = new ContextEntites())
{
try
{
var s = context.NHANVIENs.Single(x => x.MANV == kh.MANV);
s.TENNV = kh.TENNV;
s.SDT = kh.SDT;
s.PHAI = kh.PHAI;
s.CMT = kh.CMT;
s.MACV = kh.MACV;
s.NGAYVAOLAM = kh.NGAYVAOLAM;
s.NGAYSINH = kh.NGAYSINH;
s.QUEQUAN = kh.QUEQUAN;
if (context.SaveChanges() >= 0)
{
chek = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(chek);
//change
}
public bool deleteNV(int maNV)
{
bool check = false;
using (ContextEntites con = new ContextEntites())
{
try
{
NHANVIEN kh = con.NHANVIENs.SingleOrDefault(x => x.MANV == maNV);
ACCOUNT ac = con.ACCOUNTs.SingleOrDefault(x => x.ID == maNV);
if (ac != null)
{
con.NHANVIENs.Remove(kh);
//con.SaveChanges();
con.ACCOUNTs.Remove(ac);
con.SaveChanges();
check = true;
return(check);
}
else
{
con.NHANVIENs.Remove(kh);
con.SaveChanges();
check = true;
return(check);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(check);
}
public bool editHD(HOADON hd)
{
bool chek = false;
using (ContextEntites context = new ContextEntites())
{
try
{
var s = context.HOADONs.Single(x => x.MAHD == hd.MAHD);
s.MANV = hd.MANV;
s.NGAYHD = hd.NGAYHD;
s.TRIGIA = hd.TRIGIA;
if (context.SaveChanges() >= 0)
{
var bc = context.BAOCAOs.Where(x => x.NGAYBAOCAO == hd.NGAYHD.Date);
if ((bc.Count() > 0))
{
Console.WriteLine(bc.First().TONGGIATRI);
bc.First().TONGGIATRI += hd.TRIGIA;
Console.WriteLine(bc.First().TONGGIATRI);
}
context.SaveChanges();
chek = true;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(chek);
}
public bool add(NHANVIEN nv, ACCOUNT ac)
{
bool check = false;
using (ContextEntites context = new ContextEntites())
{
NHANVIEN kh = new NHANVIEN();
kh.MANV = nv.MANV;
kh.CMT = nv.CMT;
kh.NGAYSINH = nv.NGAYSINH;
kh.MACV = nv.MACV;
kh.PHAI = nv.PHAI;
kh.QUEQUAN = nv.QUEQUAN;
kh.SDT = nv.SDT;
kh.NGAYVAOLAM = nv.NGAYVAOLAM;
kh.TENNV = nv.TENNV;
context.NHANVIENs.Add(kh);
context.SaveChanges();
ACCOUNT account = new ACCOUNT();
account.ID = kh.MANV;
account.PASS = ac.PASS;
account.USERNAME = ac.USERNAME;
context.ACCOUNTs.Add(account);
context.SaveChanges();
check = true;
}
return(check);
}
public List <NHANVIEN> DSNhanVien()
{
List <NHANVIEN> listNv = new List <NHANVIEN>();
using (ContextEntites context = new ContextEntites())
{
var query = (from c in context.NHANVIENs select new
{ c.CMT, c.MANV, c.NGAYSINH, c.PHAI, c.SDT, c.TENNV, c.QUEQUAN, c.MACV, c.NGAYVAOLAM });
foreach (var a in query)
{
NHANVIEN nv = new NHANVIEN();
nv.CMT = a.CMT;
nv.TENNV = a.TENNV;
nv.SDT = a.SDT;
nv.PHAI = a.PHAI;
nv.MACV = a.MACV;
nv.NGAYSINH = a.NGAYSINH;
nv.MANV = a.MANV;
nv.QUEQUAN = a.QUEQUAN;
nv.NGAYVAOLAM = a.NGAYVAOLAM;
listNv.Add(nv);//
}
}
return(listNv);
}
public List <HOADON> dsHoaDon(DateTime date)
{
using (ContextEntites context = new ContextEntites())
{
List <HOADON> listhd = new List <HOADON>();
try
{
var query = from c in context.HOADONs where c.NGAYHD == date select c;
foreach (var a in query)
{
HOADON hd = new HOADON();
hd.MAHD = a.MAHD;
hd.MANV = a.MANV;
hd.NGAYHD = a.NGAYHD;
hd.TRIGIA = a.TRIGIA;
listhd.Add(hd);
}
return(listhd);
}
catch (Exception ex)
{
HOADON hd = new HOADON();
hd.MAHD = -1;
hd.MANV = -1;
hd.NGAYHD = DateTime.Now;
hd.TRIGIA = 0;
listhd.Add(hd);
return(listhd);
}
}
}
public bool editDC(DOCHOI dc)
{
bool chek = false;
using (ContextEntites context = new ContextEntites())
{
try
{
var s = context.DOCHOIs.Single(x => x.MADC == dc.MADC);
s.TENDC = dc.TENDC;
s.SL = dc.SL;
s.NUOCSX = dc.NUOCSX;
s.LOAI = dc.LOAI;
s.GIA = dc.GIA;
if (context.SaveChanges() >= 0)
{
chek = true;
}
}
catch (Exception ec)
{
Console.WriteLine(ec.ToString());
}
}
return(chek);
}
public List <CTPHIEUNHAP> dsPhieuNhapById(int maphieu)
{
List <CTPHIEUNHAP> listCT = new List <CTPHIEUNHAP>();
using (ContextEntites con = new ContextEntites())
{
try
{
var lct = con.CTPHIEUNHAPs.Where(x => x.MAPHIEU == maphieu);
foreach (var ct in lct)
{
CTPHIEUNHAP ctph = new CTPHIEUNHAP();
ctph.MAPHIEU = ct.MAPHIEU;
ctph.MADC = ct.MADC;
ctph.SL = ct.SL;
ctph.GIANHAP = ct.GIANHAP;
listCT.Add(ctph);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
return(listCT);
}
public int GetMaNVNow()
{
int id;
using (ContextEntites context = new ContextEntites())
{
id = (from c in context.NHANVIENs select c.MANV).Max();
}
return(id);
}
public CTPHIEUNHAP CTPHIEUNHAPbyID(int maphieu, int madc)
{
CTPHIEUNHAP ct = new CTPHIEUNHAP();
using (ContextEntites context = new ContextEntites())
{
var a = context.CTPHIEUNHAPs.SingleOrDefault(x => x.MAPHIEU == maphieu && x.MADC == madc);
ct = a;
}
return(ct);//
}
public ACCOUNT ACCOUNTByID(int ID)
{
ACCOUNT ac = new ACCOUNT();
using (ContextEntites context = new ContextEntites())
{
var a = context.ACCOUNTs.SingleOrDefault(x => x.ID == ID);
ac.ID = a.ID;
ac.USERNAME = a.USERNAME;
ac.PASS = a.PASS;
}
return(ac);
}
public int addCTHDs(List <CTHD> cts)
{
int s = 0;
foreach (CTHD ct in cts)
{
using (ContextEntites context = new ContextEntites())
{
var a = context.CTHDs.Add(ct);
s += context.SaveChanges();
}
}
return(s);
}
public CTHD CTHDbyID(int mahd, int madc)
{
CTHD ct = new CTHD();
using (ContextEntites context = new ContextEntites())
{
var a = context.CTHDs.SingleOrDefault(x => x.MAHD == mahd && x.MADC == madc);
ct.MADC = a.MADC;
ct.GIA = a.GIA;
ct.MAHD = a.MAHD;
ct.SL = a.SL;
}
return(ct);//
}
public int AddCV(CHUCVU ac)
{
int s;
using (ContextEntites context = new ContextEntites())
{
CHUCVU kh = new CHUCVU();
kh.MACV = ac.MACV;
kh.TENCV = ac.TENCV;
context.CHUCVUs.Add(kh);
s = context.SaveChanges();
}
return(s);
}
public HOADON HoaDonById(int id)
{
HOADON hd = new HOADON();
using (ContextEntites context = new ContextEntites())
{
var s = context.HOADONs.SingleOrDefault(x => x.MAHD == id);
hd.MAHD = s.MAHD;
hd.MANV = s.MANV;
hd.NGAYHD = s.NGAYHD;
hd.TRIGIA = s.TRIGIA;
}
return(hd);
}
public DOCHOI DochoiById(int ID)
{
DOCHOI dc = new DOCHOI();
using (ContextEntites context = new ContextEntites())
{
var a = context.DOCHOIs.Single(x => x.MADC == ID);
dc.MADC = a.MADC;
dc.NUOCSX = a.NUOCSX;
dc.SL = a.SL;
dc.TENDC = a.TENDC;
dc.LOAI = a.LOAI;
dc.GIA = a.GIA;
}
return(dc);
}
public int addCTHD(CTHD ct)
{
int s;
CTHD add = new CTHD();
add.MAHD = ct.MAHD;
add.MADC = ct.MADC;
add.SL = ct.SL;
add.GIA = ct.GIA;
using (ContextEntites context = new ContextEntites())
{
var a = context.CTHDs.Add(add);
s = context.SaveChanges();
}
return(s);
}
public List <CHUCVU> DSCHUCVU()
{
List <CHUCVU> listCV = new List <CHUCVU>();
using (ContextEntites context = new ContextEntites())
{
var query = (from c in context.CHUCVUs select c);
foreach (var a in query)
{
CHUCVU cv = new CHUCVU();
cv.MACV = a.MACV;
cv.TENCV = a.TENCV;
listCV.Add(cv);
}
}
return(listCV);
}
public CHUCVU GETChucVuByID(string Macv)
{
CHUCVU cv = new CHUCVU();
try
{
using (ContextEntites context = new ContextEntites())
{
cv = context.CHUCVUs.SingleOrDefault(x => x.MACV == Macv);
}
}catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(cv);
}
public CHUCVU GetCVbyName(string name)
{
CHUCVU cv = new CHUCVU();
try
{
using (ContextEntites context = new ContextEntites())
{
cv = context.CHUCVUs.SingleOrDefault(x => x.TENCV == name);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
return(cv);
}
public List <BAOCAO> dsBAOCAOFromTo(DateTime datefrom, DateTime dateto)
{
List <BAOCAO> listbc = new List <BAOCAO>();
using (ContextEntites context = new ContextEntites())
{
var query = (from c in context.BAOCAOs where (c.NGAYBAOCAO >= datefrom && c.NGAYBAOCAO <= dateto) select c);
foreach (var a in query)
{
BAOCAO bc = new BAOCAO();
bc.TONGGIATRI = a.TONGGIATRI;
bc.NGAYBAOCAO = a.NGAYBAOCAO;
listbc.Add(bc);
}
}
return(listbc);
}
public List <BAOCAO> dsBAOCAO()
{
List <BAOCAO> listbc = new List <BAOCAO>();
using (ContextEntites context = new ContextEntites())
{
var query = (from c in context.BAOCAOs select c);
foreach (var a in query)
{
BAOCAO bc = new BAOCAO();
bc.TONGGIATRI = a.TONGGIATRI;
bc.NGAYBAOCAO = a.NGAYBAOCAO;
listbc.Add(bc);
}
}
return(listbc);
}
public List <ACCOUNT> DSACCOUNT()
{
List <ACCOUNT> listac = new List <ACCOUNT>();
using (ContextEntites context = new ContextEntites())
{
var query = (from c in context.ACCOUNTs select c);
foreach (var a in query)
{
ACCOUNT ac = new ACCOUNT();
ac.ID = a.ID;
ac.USERNAME = a.USERNAME;
ac.PASS = a.PASS;
listac.Add(ac);
}
}
return(listac);
}
public bool AddAc(ACCOUNT ac)
{
bool check = false;
using (ContextEntites context = new ContextEntites())
{
ACCOUNT kh = new ACCOUNT();
kh.ID = ac.ID;
kh.PASS = ac.PASS;
kh.USERNAME = ac.USERNAME;
context.ACCOUNTs.Add(kh);
if (context.SaveChanges() > 0)
{
check = true;
}
}
return(check);
}
public int AddDoChoi(DOCHOI dc)
{
int s = 0;
using (ContextEntites context = new ContextEntites())
{
try
{
context.DOCHOIs.Add(dc);
s = context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
}
return(s);
}
public int AddCTPhieuNhap(CTPHIEUNHAP ct)
{
int s;
using (ContextEntites cn = new ContextEntites())
{
try
{
cn.CTPHIEUNHAPs.Add(ct);
s = cn.SaveChanges();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
s = 0;
}
}
return(s);
}
