private void txtMasach_KeyUp(object sender, KeyEventArgs e)
{
QuanLyNhaSachDataContext s = new QuanLyNhaSachDataContext();
var vt = from v in s.GIANIEMYETs select v;
foreach (var p in vt)
{
if (p.MaSach.Trim() == txtMasach.Text.Trim())
{
try{
this.txtiatien.Text = (p.GiaTien - p.GiaTien * int.Parse(txtgiamgia.Text) / 100).ToString();
}
catch { MessageBox.Show("Giá giảm không đúng!"); }
}
}
var sach = from sa in s.Saches select sa;
foreach (var ps in sach)
{
if (ps.MaSach.Trim() == txtMasach.Text.Trim())
{
this.txttensach.Text = ps.TenSach;
}
}
}
private void sach_Load(object sender, EventArgs e)
{
QuanLyNhaSachDataContext s = new QuanLyNhaSachDataContext();
var nxb = from nx in s.NXBs select nx;
var nn = from n in s.NGONNGUs select n;
var tl = from t in s.THELOAIs select t;
var vt = from v in s.KeSaches select v;
foreach (var nx in nxb)
{
this.txtnxb.Items.AddRange(new object[] { nx.TenNXB });
}
foreach (var n in nn)
{
this.txtngonngu.Items.AddRange(new object[] { n.NgonNgu1 });
}
foreach (var t in tl)
{
this.txttheloai.Items.AddRange(new object[] { t.TheLoai1 });
}
foreach (var v in vt)
{
this.txtvitri.Items.AddRange(new object[] { v.TenKeSach });
}
LoadData();
grbthongtin.Enabled = false;
}
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 IQueryable timkiem(string ma)
{
QuanLyNhaSachDataContext qlSV = new QuanLyNhaSachDataContext();
var tpQuery = (from t in qlSV.NGONNGUs
where t.MaNgonNgu.Contains(ma) || t.NgonNgu1.Contains(ma)
select t);
return(tpQuery);
}
public IQueryable timkiem(string ma)
{
QuanLyNhaSachDataContext qlSV = new QuanLyNhaSachDataContext();
var tpQuery = (from t in qlSV.Saches
where t.MaSach.Contains(ma) || t.TenSach.Contains(ma)
select t);
return(tpQuery);
}
public IQueryable timkiem(string ma)
{
QuanLyNhaSachDataContext qlSV = new QuanLyNhaSachDataContext();
var tpQuery = (from t in qlSV.TaiKhoanTruyCaps
where t.TenTaiKhoan.Contains(ma) || t.QuyenTruyCap.Contains(ma)
select t);
return(tpQuery);
}
public IQueryable timkiem(string ma)
{
QuanLyNhaSachDataContext qlSV = new QuanLyNhaSachDataContext();
var tpQuery = (from t in qlSV.THELOAIs
where t.MaTheLoai.Contains(ma) || t.TheLoai1.Contains(ma)
select t);
return(tpQuery);
}
public IQueryable timkiem(string ma)
{
QuanLyNhaSachDataContext qlSV = new QuanLyNhaSachDataContext();
var tpQuery = (from t in qlSV.HoaDonNhaps
where t.MaHoaDonNhap.Contains(ma) || t.MaNCC.Contains(ma)
select t);
return(tpQuery);
}
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 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 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 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 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 Them(string Ma, DateTime ngay, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
HoaDonBan s = new HoaDonBan();
s.MaHoaDonBan = Ma;
s.NgayBan = ngay;
qlNS.HoaDonBans.InsertOnSubmit(s);
qlNS.HoaDonBans.Context.SubmitChanges();
return(true);
}
public bool Them(string Ma, int gia, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
GIANIEMYET s = new GIANIEMYET();
s.MaSach = Ma;
s.GiaTien = gia;
qlNS.GIANIEMYETs.InsertOnSubmit(s);
qlNS.GIANIEMYETs.Context.SubmitChanges();
return(true);
}
public bool Them(string Ma, string Ten, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
NXB s = new NXB();
s.MaNXB = Ma;
s.TenNXB = Ten;
qlNS.NXBs.InsertOnSubmit(s);
qlNS.NXBs.Context.SubmitChanges();
return(true);
}
public bool ThemNgonNgu(string maNN, string NN, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
NGONNGU s = new NGONNGU();
s.MaNgonNgu = maNN;
s.NgonNgu1 = NN;
qlNS.NGONNGUs.InsertOnSubmit(s);
qlNS.NGONNGUs.Context.SubmitChanges();
return(true);
}
public bool Them(string Ma, string Ten, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
NHACC s = new NHACC();
s.MaNCC = Ma;
s.NhaCC1 = Ten;
qlNS.NHACCs.InsertOnSubmit(s);
qlNS.NHACCs.Context.SubmitChanges();
return(true);
}
public bool ThemKe(string tenke, string theloai, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
KeSach s = new KeSach();
s.TenKeSach = tenke;
s.TheLoai = theloai;
qlNS.KeSaches.InsertOnSubmit(s);
qlNS.KeSaches.Context.SubmitChanges();
return(true);
}
public bool Them(string Ma, string Ten, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
THELOAI s = new THELOAI();
s.MaTheLoai = Ma;
s.TheLoai1 = Ten;
qlNS.THELOAIs.InsertOnSubmit(s);
qlNS.THELOAIs.Context.SubmitChanges();
return(true);
}
public bool Them(string Ma, DateTime ngay, string MaNCC, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
HoaDonNhap s = new HoaDonNhap();
s.MaHoaDonNhap = Ma;
s.NgayNhap = ngay;
s.MaNCC = MaNCC;
qlNS.HoaDonNhaps.InsertOnSubmit(s);
qlNS.HoaDonNhaps.Context.SubmitChanges();
return(true);
}
public bool Them(string MaHD, string Masach, int Giatien, int soluong, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
SachMuaVao s = new SachMuaVao();
s.MaHoaDonMua = MaHD;
s.MaSach = Masach;
s.GiaTien = Giatien;
s.Soluong = soluong;
qlNS.SachMuaVaos.InsertOnSubmit(s);
qlNS.SachMuaVaos.Context.SubmitChanges();
return(true);
}
public DataTable Layngonngu()
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
var hd = from p in qlNS.NGONNGUs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã ngôn ngữ");
dt.Columns.Add("Ngôn ngữ");
foreach (var p in hd)
{
dt.Rows.Add(p.MaNgonNgu, p.NgonNgu1);
}
return(dt);
}
public DataTable Lay()
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
var hd = from p in qlNS.HoaDonNhaps select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã hóa đơn Nhập");
dt.Columns.Add("Ngày Nhập");
dt.Columns.Add("Mã nhà cung cấp");
foreach (var p in hd)
{
dt.Rows.Add(p.MaHoaDonNhap, p.NgayNhap, p.MaNCC);
}
return(dt);
}
public DataTable Lay()
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
var hd = from p in qlNS.NHACCs select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã nhà cung cấp");
dt.Columns.Add("Tên nhà cung cấp");
foreach (var p in hd)
{
dt.Rows.Add(p.MaNCC, p.NhaCC1);
}
return(dt);
}
public DataTable LayKe()
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
var hd = from p in qlNS.KeSaches select p;
DataTable dt = new DataTable();
dt.Columns.Add("Tên Kệ");
dt.Columns.Add("Thể loại");
foreach (var p in hd)
{
dt.Rows.Add(p.TenKeSach, p.TheLoai);
}
return(dt);
}
public DataTable Lay()
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
var hd = from p in qlNS.HoaDonBans select p;
DataTable dt = new DataTable();
dt.Columns.Add("Mã hóa đơn bán");
dt.Columns.Add("Ngày bán");
foreach (var p in hd)
{
dt.Rows.Add(p.MaHoaDonBan, p.NgayBan);
}
return(dt);
}
public bool Them(string Ten, string matkhau, string quyen, ref string err)
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
TaiKhoanTruyCap s = new TaiKhoanTruyCap();
s.TenTaiKhoan = Ten;
s.MatKhau = matkhau;
s.QuyenTruyCap = quyen;
qlNS.TaiKhoanTruyCaps.InsertOnSubmit(s);
qlNS.TaiKhoanTruyCaps.Context.SubmitChanges();
return(true);
}
public DataTable Lay()
{
QuanLyNhaSachDataContext qlNS = new QuanLyNhaSachDataContext();
var hd = from p in qlNS.TaiKhoanTruyCaps select p;
DataTable dt = new DataTable();
dt.Columns.Add("Tên tài khoản");
dt.Columns.Add("Mật khẩu");
dt.Columns.Add("Quyền truy cập");
foreach (var p in hd)
{
dt.Rows.Add(p.TenTaiKhoan, p.MatKhau, p.QuyenTruyCap);
}
return(dt);
}
