public void InsertNCC(NHACUNGCAP NCC) { var db = new QLTHONGTINMAYTINHEntities1(); db.NHACUNGCAPs.Add(NCC); db.SaveChanges(); }
public void insertSP(SANPHAM SP) { var db = new QLTHONGTINMAYTINHEntities1(); db.SANPHAMs.Add(SP); db.SaveChanges(); }
public void InsertNV(NHANVIEN NV) { var db = new QLTHONGTINMAYTINHEntities1(); db.NHANVIENs.Add(NV); db.SaveChanges(); }
public void InsertNhaKho(NHAKHO NK) { var db = new QLTHONGTINMAYTINHEntities1(); db.NHAKHOes.Add(NK); db.SaveChanges(); }
public void soLuongSauKhiBan(string _MaSp, int _SoLuong) { var db = new QLTHONGTINMAYTINHEntities1(); db.UpdateSoLuong(_MaSp, amountToDB(_MaSp) - _SoLuong); // Proc SQL db.SaveChanges(); }
public void removeNK(string _MaNK) { var db = new QLTHONGTINMAYTINHEntities1(); NHAKHO NK = db.NHAKHOes.Where(p => p.MANK == _MaNK).SingleOrDefault(); db.NHAKHOes.Remove(NK); db.SaveChanges(); }
public void removeNCC(string _MaNCC) { var db = new QLTHONGTINMAYTINHEntities1(); NHACUNGCAP NCC = db.NHACUNGCAPs.Where(p => p.MANCC == _MaNCC).SingleOrDefault(); db.NHACUNGCAPs.Remove(NCC); db.SaveChanges(); }
public IEnumerable <KHACHHANG> loadSearch(string _strName) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.SeachNameKhachHang(_strName).Select(p => new KHACHHANG() { MAKH = p.MAKH, TENKH = p.TENKH, SDT = p.SDT, DIACHI = p.DIACHI, status = p.status })); }
public IEnumerable <NHANVIEN> loadSeach(string _strName) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.seachName(_strName).Select(p => new NHANVIEN() { MANV = p.MANV, TENNV = p.TENNV, SEX = p.SEX, DIACHI = p.DIACHI, SDT = p.SDT, EMAIL = p.EMAIL })); }
public IEnumerable <NHACUNGCAP> loadSeach(string _strName) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.SeachNameNhaCungCap(_strName).Select(p => new NHACUNGCAP() { MANCC = p.MANCC, TENNCC = p.TENNCC, DIACHI = p.DIACHI, SDT = p.SDT, FAX = p.FAX, EMAIL = p.EMAIL })); }
public IEnumerable <NHAKHO> loadSeach(string _strName) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.SeachNameNhaKHo(_strName).Select(p => new NHAKHO() { MANK = p.MANK, TENNK = p.TENNK, DIACHI = p.DIACHI })); }
public IEnumerable <SANPHAM> loadSearch(string _strName) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.SeachNameSanPham(_strName).Select(p => new SANPHAM() { MASP = p.MASP, TENSP = p.TENSP, THUONGHIEU = p.THUONGHIEU, THONGTIN = p.THONGTIN, LOAISP = p.LOAISP, SOLUONG = p.SOLUONG, GIANHAP = p.GIANHAP, GIABAN = p.GIABAN, TIMENHAP = p.TIMENHAP, MANCC = p.MANCC, MANK = p.MANK, IMAGES = p.IMAGES })); }
public IEnumerable loadInfo(string _strMADH) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.loadINFORDONHANG(_strMADH).Select(p => new cTTDONHANG() { StrMASP = p.MASP, StrTENSP = p.TENSP, ISOLUONG = p.SOLUONG, DGIA = p.GIABAN }).ToList()); }
public IEnumerable loadSP() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.Top_5_SP().Select(p => new SANPHAM() { TENSP = p.TENSP, IMAGES = p.IMAGES }).ToList()); }
public void removeSP(string _MaSP) { try { var db = new QLTHONGTINMAYTINHEntities1(); SANPHAM SP = db.SANPHAMs.Where(p => p.MASP == _MaSP).SingleOrDefault(); db.SANPHAMs.Remove(SP); db.SaveChanges(); } catch { } }
public void insertStatus(string _strMAKH) { var db = new QLTHONGTINMAYTINHEntities1(); var result = db.KHACHHANGs.Where(p => p.MAKH == _strMAKH).SingleOrDefault(); if (result != null) { result.status = 1; db.SaveChanges(); } }
public bool loginSuss(string _ID, string _Pass) { var db = new QLTHONGTINMAYTINHEntities1(); var result = db.NHANVIENs.Where(p => p.MANV == _ID && p.PASSWORD == _Pass).SingleOrDefault(); if (result != null) { return(true); } return(false); }
public void InsertDonHang(DONHANG DH) { try { var db = new QLTHONGTINMAYTINHEntities1(); db.DONHANGs.Add(DH); db.SaveChanges(); } catch (Exception) { MessageBox.Show("Lỗi Khi Thêm Dư Liệu", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Stop); } }
public void removeNV(string _MaNV) { try { var db = new QLTHONGTINMAYTINHEntities1(); NHANVIEN NV = db.NHANVIENs.Where(p => p.MANV == _MaNV).SingleOrDefault(); db.NHANVIENs.Remove(NV); db.SaveChanges(); } catch { } }
public IEnumerable THONGKETHEONTN(DateTime dateTime, string strDate) { var db = new QLTHONGTINMAYTINHEntities1(); if (strDate == "Ngày") { return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Day == dateTime.Day && p.TIMEXUAT.Month == dateTime.Month && p.TIMEXUAT.Year == dateTime.Year).ToList()); } if (strDate == "Tháng") { return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month == dateTime.Month && p.TIMEXUAT.Year == dateTime.Year).ToList()); } if (strDate == "Năm") { return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Year == dateTime.Year).ToList()); } return(db.THONGKEDONHANGDABANs.ToList()); }
public IEnumerable TKQuy(DateTime dateTime, string strDate) { var db = new QLTHONGTINMAYTINHEntities1(); if (strDate == "Quý 1") { return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 1 && p.TIMEXUAT.Month <= 3 && dateTime.Year == p.TIMEXUAT.Year).ToList()); } if (strDate == "Quý 2") { return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 4 && p.TIMEXUAT.Month <= 6 && dateTime.Year == p.TIMEXUAT.Year).ToList()); } if (strDate == "Quý 3") { return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 7 && p.TIMEXUAT.Month <= 9 && dateTime.Year == p.TIMEXUAT.Year).ToList()); } return(db.THONGKEDONHANGDABANs.Where(p => p.TIMEXUAT.Month >= 10 && p.TIMEXUAT.Month <= 12 && dateTime.Year == p.TIMEXUAT.Year).ToList()); }
public int loadQuyen(string _MANV) { var db = new QLTHONGTINMAYTINHEntities1(); var result = db.NHANVIENs.Where(p => p.MANV == _MANV).SingleOrDefault(); if (result != null) { if (result.QUYEN == 1) { return(1); } else { return(0); } } else { return(-1); } }
public int SoLuong() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.THONGTINDONHANGs.Sum(p => p.SOLUONG)); }
public IEnumerable loadInforKhachHang() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.KHACHHANGs.ToList()); }
public IEnumerable loadMANK() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.NHAKHOes.Select(p => p.MANK).ToList()); }
public IEnumerable loadNCC() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.NHACUNGCAPs.ToList()); }
public IEnumerable loadMANCC() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.NHACUNGCAPs.Select(p => p.MANCC).ToList()); }
public IEnumerable listStatus(int _limitMoney) { var db = new QLTHONGTINMAYTINHEntities1(); return(db.THONGKEDONHANGDABAN_1.Where(p => p.THANHTIEN >= _limitMoney).Select(a => a.MAKH).ToList()); }
public IEnumerable loadInfoNhaKho() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.NHAKHOes.ToList()); }
public int SoLuongKH() { var db = new QLTHONGTINMAYTINHEntities1(); return(db.KHACHHANGs.Count()); }