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
{
}
}