public void xoaSanPham(string pMaSP) { QLSanPham item = QLCH.QLSanPhams.Where(sp => sp.MaSP == pMaSP).FirstOrDefault(); QLCH.QLSanPhams.DeleteOnSubmit(item); QLCH.SubmitChanges(); }
public void updateSanPham(string ma, string ten, int gia, int soLuong, string maNCC, string maNSX, string baohanh, string loaisp, string mota) { QLSanPham sp = QLCH.QLSanPhams.Where(kh => kh.MaSP == ma).FirstOrDefault(); sp.TenSP = ten; sp.DonGia = gia; sp.SoLuong = soLuong; sp.MaNCC = maNCC; sp.MaNSX = maNSX; sp.ThongTinBH = baohanh; sp.LoaiSP = loaisp; sp.MoTa = mota; QLCH.SubmitChanges(); }
public void ThemSanPham(string ma, string ten, int gia, int soLuong, string maNCC, string maNSX, string baohanh, string loaisp, string mota) { QLSanPham sp = new QLSanPham(); sp.MaSP = ma; sp.TenSP = ten; sp.DonGia = gia; sp.SoLuong = soLuong; sp.MaNCC = maNCC; sp.MaNSX = maNSX; sp.ThongTinBH = baohanh; sp.LoaiSP = loaisp; sp.MoTa = mota; QLCH.QLSanPhams.InsertOnSubmit(sp); QLCH.SubmitChanges(); loadDSSanPham(); }
partial void DeleteQLSanPham(QLSanPham instance);
partial void UpdateQLSanPham(QLSanPham instance);
partial void InsertQLSanPham(QLSanPham instance);