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); }