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