public bool CapNhatSach(string maSach, string tensach, string TacGia, string NXB, int SoTrang, string NgonNgu, string TheLoai, string TinhTrang, string ViTri, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.Saches where tp.MaSach == maSach select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaSach = maSach; sQuery.TenSach = tensach; sQuery.TacGia = TacGia; sQuery.NhaXuatBan = NXB; sQuery.SoTrang = SoTrang; sQuery.NgonNgu = NgonNgu; sQuery.TheLoai = TheLoai; sQuery.TinhTrang = TinhTrang; sQuery.ViTri = ViTri; qlNS.SubmitChanges(); } return(true); }
public bool Xoa(ref string err, string Ma) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var tpQuery = from k in qlNS.HoaDonNhaps where k.MaHoaDonNhap == Ma select k; qlNS.HoaDonNhaps.DeleteAllOnSubmit(tpQuery); qlNS.SubmitChanges(); return(true); }
public bool Xoacthdb(ref string err, string MaHD) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var tpQuery = from k in qlNS.SachBanRas where k.MaHoaDonBan == MaHD select k; qlNS.SachBanRas.DeleteAllOnSubmit(tpQuery); qlNS.SubmitChanges(); return(true); }
public bool Xoa(ref string err, string tentruycap) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var tpQuery = from k in qlNS.TaiKhoanTruyCaps where k.TenTaiKhoan == tentruycap select k; qlNS.TaiKhoanTruyCaps.DeleteAllOnSubmit(tpQuery); qlNS.SubmitChanges(); return(true); }
public bool XoaKe(ref string err, string tenke) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var tpQuery = from k in qlNS.KeSaches where k.TenKeSach == tenke select k; qlNS.KeSaches.DeleteAllOnSubmit(tpQuery); qlNS.SubmitChanges(); return(true); }
public bool XoaNgonNgu(ref string err, string MaNN) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var tpQuery = from k in qlNS.NGONNGUs where k.MaNgonNgu == MaNN select k; qlNS.NGONNGUs.DeleteAllOnSubmit(tpQuery); qlNS.SubmitChanges(); return(true); }
public bool Xoa(ref string err, string MaHD, string masach) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var tpQuery = from k in qlNS.SachMuaVaos where k.MaHoaDonMua == MaHD && k.MaSach == masach select k; qlNS.SachMuaVaos.DeleteAllOnSubmit(tpQuery); qlNS.SubmitChanges(); return(true); }
public bool CapNhat(string Ma, DateTime Ngay, string MaNCC, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.HoaDonNhaps where tp.MaHoaDonNhap == Ma select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaHoaDonNhap = Ma; sQuery.NgayNhap = Ngay; sQuery.MaNCC = MaNCC; qlNS.SubmitChanges(); } return(true); }
public bool CapNhat(string Ten, string matkhau, string quyen, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.TaiKhoanTruyCaps where tp.TenTaiKhoan == Ten select tp).SingleOrDefault(); if (sQuery != null) { sQuery.TenTaiKhoan = Ten; sQuery.MatKhau = matkhau; sQuery.QuyenTruyCap = quyen; qlNS.SubmitChanges(); } return(true); }
public bool CapNhatKe(string tenke, string theloai, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.KeSaches where tp.TenKeSach == tenke select tp).SingleOrDefault(); if (sQuery != null) { sQuery.TenKeSach = tenke; sQuery.TheLoai = theloai; qlNS.SubmitChanges(); } return(true); }
public bool CapNhat(string Ma, string Ten, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.NHACCs where tp.MaNCC == Ma select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaNCC = Ma; sQuery.NhaCC1 = Ten; qlNS.SubmitChanges(); } return(true); }
public bool CapNhatNN(string maNN, string NN, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.NGONNGUs where tp.MaNgonNgu == maNN select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaNgonNgu = maNN; sQuery.NgonNgu1 = NN; qlNS.SubmitChanges(); } return(true); }
public bool CapNhat(string MaNXB, string TenNXB, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.NXBs where tp.MaNXB == MaNXB select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaNXB = MaNXB; sQuery.TenNXB = TenNXB; qlNS.SubmitChanges(); } return(true); }
public bool CapNhat(string Ma, int gia, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.GIANIEMYETs where tp.MaSach == Ma select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaSach = Ma; sQuery.GiaTien = gia; qlNS.SubmitChanges(); } return(true); }
public bool CapNhat(string MaHD, string Masach, int Giatien, int soluong, ref string err) { QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext(); var sQuery = (from tp in qlNS.SachMuaVaos where tp.MaHoaDonMua == MaHD && tp.MaSach == Masach select tp).SingleOrDefault(); if (sQuery != null) { sQuery.MaHoaDonMua = MaHD; sQuery.MaSach = Masach; sQuery.GiaTien = Giatien; sQuery.Soluong = soluong; qlNS.SubmitChanges(); } return(true); }