public void Add(NhaCungCap ncc) { using (QLNTEntities1 db = new QLNTEntities1()) { db.NhaCungCap.Add(ncc); db.SaveChanges(); } }
public void Add(NhanVien nv) { using (QLNTEntities1 db = new QLNTEntities1()) { db.NhanVien.Add(nv); db.SaveChanges(); } }
public void setHuySL(int id) { using (QLNTEntities1 db = new QLNTEntities1()) { PhanBon p = db.PhanBon.Where(c => c.MaPB == id).SingleOrDefault(); p.SoLuong = 0; db.SaveChanges(); } }
public void setHuySL(int id) { using (QLNTEntities1 db = new QLNTEntities1()) { NongSan p = db.NongSan.Where(c => c.MaNS == id).SingleOrDefault(); p.SanLuongTonKho = 0; db.SaveChanges(); } }
public void Delete(int maKH, int maLoai) { using (QLNTEntities1 db = new QLNTEntities1()) { ChiTietKH ct = db.ChiTietKH.Where(c => c.MaKH == maKH && c.MaLoai == maLoai).SingleOrDefault(); db.ChiTietKH.Remove(ct); db.SaveChanges(); } }
public void setHuySL(int id) { using (QLNTEntities1 db = new QLNTEntities1()) { ThuocBaoVeTV p = db.ThuocBaoVeTV.Where(c => c.MaThuoc == id).SingleOrDefault(); p.SoLuong = 0; db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); KhachHang temp = db.KhachHang.Where(p => p.MaKH == ma).SingleOrDefault(); db.KhachHang.Remove(temp); db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); BangThuHoach temp = db.BangThuHoach.Where(p => p.MaBang == ma).SingleOrDefault(); db.BangThuHoach.Remove(temp); db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); NhaCungCap ncc = db.NhaCungCap.Where(p => p.MaNCC == ma).SingleOrDefault(); db.NhaCungCap.Remove(ncc); db.SaveChanges(); } }
public void Edit(int id, string noiDung, string chuThich) { using (QLNTEntities1 db = new QLNTEntities1()) { KeHoach temp = db.KeHoach.Find(id); temp.NoiDung = noiDung; temp.ChuThich = chuThich; db.SaveChanges(); } }
public void setSoLuongCongViec(int MaKH) { using (QLNTEntities1 db = new QLNTEntities1()) { KeHoach k = db.KeHoach.Find(MaKH); int count = (from c in db.ChiTietKH where c.MaKH == MaKH select c).Count(); k.SoLuongCongViec = count; db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); NongSan temp = db.NongSans.Where(p => p.MaNS == ma).SingleOrDefault(); db.NongSans.Remove(temp); db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); NhanVien nv = db.NhanVien.Where(p => p.MaNV == ma).SingleOrDefault(); db.NhanVien.Remove(nv); db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); Cay temp = db.Cay.Where(p => p.MaLoaiCay == ma).SingleOrDefault(); db.Cay.Remove(temp); db.SaveChanges(); } }
public void Delete(string id) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = Convert.ToInt32(id); ThuocBaoVeTV temp = db.ThuocBaoVeTV.Where(p => p.MaThuoc == ma).SingleOrDefault(); db.ThuocBaoVeTV.Remove(temp); db.SaveChanges(); } }
public void Edit(BangThuHoach o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaBang; BangThuHoach temp = db.BangThuHoach.Find(ma); temp.NgayThuHoach = o.NgayThuHoach; temp.MaNV = o.MaNV; db.SaveChanges(); } }
public void setHoanThanh(ChiTietKH ct, bool value) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = ct.MaKH; ChiTietKH temp = db.ChiTietKH.Where(c => c.MaLoai == ct.MaLoai && c.MaKH == ct.MaKH).SingleOrDefault(); temp.HoanThanh = value; db.SaveChanges(); } }
public void Edit(NhaCungCap ncc) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = ncc.MaNCC; NhaCungCap temp = db.NhaCungCap.Find(ma); temp.TenNCC = ncc.TenNCC; temp.SoDienThoai = ncc.SoDienThoai; temp.DiaChi = ncc.DiaChi; db.SaveChanges(); } }
public void Add(int maKH, int maLoai) { using (QLNTEntities1 db = new QLNTEntities1()) { ChiTietKH c = new ChiTietKH(); c.MaKH = maKH; c.MaLoai = maLoai; c.HoanThanh = false; db.ChiTietKH.Add(c); db.SaveChanges(); } }
public void Edit(KhachHang kh) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = kh.MaKH; KhachHang temp = db.KhachHang.Find(ma); temp.TenKH = kh.TenKH; temp.DienThoai = kh.DienThoai; temp.DiaChi = kh.DiaChi; db.SaveChanges(); } }
public void Edit(Cay o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaLoaiCay; Cay temp = db.Cay.Find(ma); temp.TenCay = o.TenCay; temp.SoLuong = o.SoLuong; temp.MuaThuHoach = o.MuaThuHoach; temp.NamTrongCay = o.NamTrongCay; db.SaveChanges(); } }
public void Edit(NongSan o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaNS; NongSan temp = db.NongSan.Find(ma); temp.ThoiGianBaoQuan = o.ThoiGianBaoQuan; temp.SanLuongTonKho = o.SanLuongTonKho; temp.DonGia = o.DonGia; temp.MaLoaiCay = o.MaLoaiCay; db.SaveChanges(); } }
public void Add(ThuocBaoVeTV o) { /*using (QLNTEntities1 db = new QLNTEntities1()) * { * * db.PhanBons.Add(new PhanBon() { TenPB ="Nis", Loai="Vô cơ", NgaySX= new DateTime(2019,7,1),HanSD = new DateTime(2020, 7, 1),SoLuong=12,DonGia=100000,KhoiLuong=500 }); * db.SaveChanges(); * }*/ using (QLNTEntities1 db = new QLNTEntities1()) { db.ThuocBaoVeTV.Add(o); db.SaveChanges(); } }
public void Edit(NhanVien nv) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = nv.MaNV; NhanVien temp = db.NhanVien.Find(ma); temp.TenNV = nv.TenNV; temp.SoDienThoai = nv.SoDienThoai; temp.DiaChi = nv.DiaChi; temp.MatKhau = nv.MatKhau; temp.MaQuyen = nv.MaQuyen; db.SaveChanges(); } }
public void Edit(PhanBon o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaPB; PhanBon temp = db.PhanBons.Find(ma); temp.TenPB = o.TenPB; temp.Loai = o.Loai; temp.SoLuong = o.SoLuong; temp.KhoiLuong = o.KhoiLuong; temp.NgaySX = o.NgaySX; temp.HanSD = o.HanSD; temp.DonGia = o.DonGia; db.SaveChanges(); } }
public void Add(List <int> loai, int idKH) { QLNTEntities1 db = new QLNTEntities1(); List <ChiTietKH> l = new List <ChiTietKH>(); foreach (int i in loai) { ChiTietKH temp = new ChiTietKH(); temp.MaKH = idKH; temp.MaLoai = i; temp.HoanThanh = false; db.ChiTietKH.Add(temp); } db.SaveChanges(); //l.Add(temp); }
public void Edit(ThuocBaoVeTV o) { using (QLNTEntities1 db = new QLNTEntities1()) { int ma = o.MaThuoc; ThuocBaoVeTV temp = db.ThuocBaoVeTV.Find(ma); temp.TenThuoc = o.TenThuoc; temp.ThoiGianCachLy = o.ThoiGianCachLy; temp.NoiSX = o.NoiSX; temp.Dang = o.Dang; temp.SoLuong = o.SoLuong; temp.CongDung = o.CongDung; temp.NgaySX = o.NgaySX; temp.HanSD = o.HanSD; temp.MaDoc = o.MaDoc; db.SaveChanges(); } }
public int Add(KeHoach o, List <int> loai) { int idKH = 0; using (QLNTEntities1 db = new QLNTEntities1()) { db.KeHoach.Add(o); db.SaveChanges(); db.Entry(o).GetDatabaseValues(); idKH = o.MaKeHoach; // thêm trong chi tiết loại kế hoạch ChiTietKHDB ct = new ChiTietKHDB(); ct.Add(loai, idKH); } return(idKH); }