public void InsertNhaKho(NHAKHO NK) { var db = new QLTHONGTINMAYTINHEntities1(); db.NHAKHOes.Add(NK); db.SaveChanges(); }
public void InsertNCC(NHACUNGCAP NCC) { var db = new QLTHONGTINMAYTINHEntities1(); db.NHACUNGCAPs.Add(NCC); db.SaveChanges(); }
public void InsertNV(NHANVIEN NV) { var db = new QLTHONGTINMAYTINHEntities1(); db.NHANVIENs.Add(NV); db.SaveChanges(); }
public void insertSP(SANPHAM SP) { var db = new QLTHONGTINMAYTINHEntities1(); db.SANPHAMs.Add(SP); 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 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 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 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 { } }