// xóa nhân viên public void xoaSanPham(string masp) { SANPHAM sp = qlch.SANPHAMs.Where(d => d.MASP == masp).FirstOrDefault(); qlch.SANPHAMs.DeleteOnSubmit(sp); qlch.SubmitChanges(); }
public void updateSanPham_saukhiThemCTD(string masp, int soluong) { SANPHAM sp = qlch.SANPHAMs.Where(d => d.MASP == masp).FirstOrDefault(); sp.SOLUONG = soluong; qlch.SubmitChanges(); }
public SANPHAM(SANPHAM sp, string tenloai) { this.MASP = sp.MASP; this.TENSP = sp.TENSP; this.TRANGTHAI = sp.TRANGTHAI; this.TENLSP = tenloai; this.HINHANH = sp.HINHANH; this.GIABAN = sp.GIABAN; this.MALSP = sp.MALSP; }
private bool ktSLNL(SANPHAM sp) { foreach (CT_SANPHAM_NGUYENLIEU item in qlsp.CT_SANPHAM_NGUYENLIEUs.Where(t => t.MASP == sp.MASP)) { NGUYENLIEU nl = qlsp.NGUYENLIEUs.SingleOrDefault(t => t.MANL == item.MANL); if (nl.SOLUONG == 0) { return(false); } } return(true); }
public void suaSanPham(string masp, string maloai, string tenhang, string hinhanh, decimal dongia, int soluong, string baohanh, string mancc) { SANPHAM sp = qlch.SANPHAMs.Where(d => d.MASP == masp).FirstOrDefault(); //diemsv.Diem1 = diem; sp.MALOAI = maloai; sp.MANCC = mancc; sp.TENHANG = tenhang; sp.HINHANH = hinhanh; sp.DONGIA = dongia; sp.SOLUONG = soluong; sp.BAOHANH = baohanh; qlch.SubmitChanges(); }
public void ThemSanPham(string masp, string maloai, string tenhang, string hinhanh, decimal dongia, int soluong, string baohanh, string mancc) { SANPHAM sp = new SANPHAM(); sp.MASP = masp; sp.MALOAI = maloai; sp.MANCC = mancc; sp.TENHANG = tenhang; sp.HINHANH = hinhanh; sp.DONGIA = dongia; sp.SOLUONG = soluong; sp.BAOHANH = baohanh; qlch.SANPHAMs.InsertOnSubmit(sp); qlch.SubmitChanges(); }
public bool themSanPham(SANPHAM sp, List <CT_SANPHAM_NGUYENLIEU> lstNLSP) { try { qlsp.SANPHAMs.InsertOnSubmit(sp); foreach (CT_SANPHAM_NGUYENLIEU item in lstNLSP) { qlsp.CT_SANPHAM_NGUYENLIEUs.InsertOnSubmit(item); } return(true); } catch (Exception) { return(false); throw; } }
public bool xoaSP(string maSP) { SANPHAM sp = qlsp.SANPHAMs.SingleOrDefault(t => t.MASP == maSP); try { if (qlsp.SANPHAMs.Count(t => t.MASP == sp.MASP) != 0) { xoaHetNLcuaSP(sp.MASP); } qlsp.SANPHAMs.DeleteOnSubmit(sp); submitChange(); return(true); } catch (Exception) { return(false); } }
public bool suaSanPham(SANPHAM sp, List <CT_SANPHAM_NGUYENLIEU> lstNLSP) { try { SANPHAM currentSP = qlsp.SANPHAMs.Single(t => t.MASP == sp.MASP); if (currentSP == null) { return(false); } currentSP.TENSP = sp.TENSP; currentSP.GIABAN = sp.GIABAN; currentSP.HINHANH = sp.HINHANH; currentSP.TRANGTHAI = sp.TRANGTHAI; currentSP.MALSP = sp.MALSP; qlsp.SubmitChanges(); if (lstNLSP.Count == 0) { return(true); } // xoa het nguyen lieu cap nhap lai xoaHetNLcuaSP(currentSP.MASP); foreach (CT_SANPHAM_NGUYENLIEU item in lstNLSP) { qlsp.CT_SANPHAM_NGUYENLIEUs.InsertOnSubmit(item); } return(true); } catch (Exception) { return(false); throw; } }
//Lấy tên sản phẩm public string layTenSanPham(int id_sp) { SANPHAM sp = quanLyKho.SANPHAMs.FirstOrDefault(s => s.ID_SP == id_sp); return(sp.TENSP); }