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