public IQueryable loadcbbtacgia()
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_TacGias
select a.TenTacGia);
}
public IQueryable loadcbbnxb()
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_NhaXuatBans
select a.TenNXB);
}
public IQueryable loadcbbncc()
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_NhaCungCaps
select a.TenNCC);
}
public IQueryable loadcbbvitri()
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_ViTris
select a.TenViTri);
}
public IQueryable loadcbbtailieu()
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_TaiLieus
select a.TenTaiLieu);
}
public bool SuaTaiLieu(string machitiet, string tenchitiet, string ncc, string nxb, string tacgia, string vitri, string soluong, string link, string sotrang, byte[] anhQR, byte[] anhTaiLieu, string giabia, string gianhap)
{
QLTVDataContext qltv = new QLTVDataContext();
string manxb = (from a in qltv.QL_NhaXuatBans
where a.TenNXB == nxb
select a.MaNXB).FirstOrDefault();
string matg = (from b in qltv.QL_TacGias
where b.TenTacGia == tacgia
select b.MaTacGia).FirstOrDefault();
string mavitri = (from c in qltv.QL_ViTris
where c.TenViTri == vitri
select c.MaViTri).FirstOrDefault();
string mancc = (from d in qltv.QL_NhaCungCaps
where d.TenNCC == ncc
select d.MaNCC).FirstOrDefault();
QL_ChiTietTaiLieu edit = qltv.QL_ChiTietTaiLieus.Where(p => p.MaCTTL.Equals(machitiet)).SingleOrDefault();
edit.TenChiTiet = tenchitiet;
edit.MaNCC = mancc;
edit.MaNXB = manxb;
edit.MaTG = matg;
edit.MaViTri = mavitri;
edit.SoLuong = int.Parse(soluong);
edit.Link = link;
edit.SoTrang = sotrang;
edit.AnhTaiLieu = anhTaiLieu;
edit.AnhQR = anhQR;
edit.GiaBia = decimal.Parse(giabia);
edit.GiaNhap = decimal.Parse(gianhap);
qltv.SubmitChanges();
return(true);
}
public IQueryable loadcbbtentheloai()
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_ChiTietTaiLieus
select a.TenChiTiet);
}
public string loadTenDanhMuc(string matailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
return((from a in qltv.QL_TaiLieus
where a.MaTaiLieu == matailieu
select a.TenTaiLieu).FirstOrDefault());
}
public string laymatailieu(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
return((from a in qltv.QL_TaiLieus
where a.TenTaiLieu == tentailieu
select a.MaTaiLieu).FirstOrDefault());
}
public string loadsoluongtailieu(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
return((from r in qltv.QL_ChiTietTaiLieus
where r.TenChiTiet == tentailieu
select r.SoLuong).FirstOrDefault().ToString());
}
public string layMaDG(string sdt)
{
QLTVDataContext qltv = new QLTVDataContext();
string ma = (from a in qltv.QL_DocGias
where a.SoDienThoai == sdt
select a.MaDocGia).FirstOrDefault();
return(ma);
}
public bool xoanhom(string manhom, string tennhom)
{
QLTVDataContext qltv = new QLTVDataContext();
QL_NhomCuaNguoiDung delete = qltv.QL_NhomCuaNguoiDungs.Where(d => d.MaNhom.Equals(manhom)).SingleOrDefault();
qltv.QL_NhomCuaNguoiDungs.DeleteOnSubmit(delete);
qltv.SubmitChanges();
return(true);
}
public bool suanhom(string manhom, string tennhom)
{
QLTVDataContext qltv = new QLTVDataContext();
QL_NhomCuaNguoiDung edit = qltv.QL_NhomCuaNguoiDungs.Where(d => d.MaNhom.Equals(manhom)).SingleOrDefault();
edit.TenNhom = tennhom;
qltv.SubmitChanges();
return(true);
}
public string loadMaChiTietTaiLieu(string tentailieu)
{
string matailieu;
QLTVDataContext qltv = new QLTVDataContext();
return(matailieu = (from a in qltv.QL_ChiTietTaiLieus
where a.TenChiTiet == tentailieu
select a.MaCTTL).FirstOrDefault().ToString());
}
public bool xoaTaiLieu(string machitiet)
{
QLTVDataContext qltv = new QLTVDataContext();
QL_ChiTietTaiLieu delete = qltv.QL_ChiTietTaiLieus.Where(p => p.MaCTTL.Equals(machitiet)).SingleOrDefault();
qltv.QL_ChiTietTaiLieus.DeleteOnSubmit(delete);
qltv.SubmitChanges();
return(true);
}
public byte[] loadAnhTaiLieu(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
var abc = (from tl in qltv.QL_ChiTietTaiLieus
where tl.TenChiTiet == tentailieu
select tl.AnhTaiLieu).FirstOrDefault();
byte[] anh = abc.ToArray();
return(anh);
}
public string loadgiabia(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
string giabia;
return(giabia = (from f in qltv.QL_ChiTietTaiLieus
where f.TenChiTiet == tentailieu
select f.GiaBia).FirstOrDefault().ToString());
}
public bool tinhTongSoLuongTL(string matailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
string tongsoluong = (qltv.QL_ChiTietTaiLieus.Where(a => a.MaTaiLieu == matailieu).Sum(d => d.SoLuong)).ToString();
QL_TaiLieu edit = qltv.QL_TaiLieus.Where(d => d.MaTaiLieu.Equals(matailieu)).SingleOrDefault();
edit.TongSoLuong = tongsoluong;
qltv.SubmitChanges();
return(true);
}
public bool tinhTongGiaNhap(string matailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
string tongiatien = (qltv.QL_ChiTietTaiLieus.Where(a => a.MaTaiLieu == matailieu).Sum(d => d.GiaNhap)).ToString();
QL_TaiLieu edit = qltv.QL_TaiLieus.Where(d => d.MaTaiLieu.Equals(matailieu)).SingleOrDefault();
edit.TongGiaTien = tongiatien;
qltv.SubmitChanges();
return(true);
}
public byte[] loadAnhDocGia(string madocgia)
{
QLTVDataContext qltv = new QLTVDataContext();
var abc = (from tl in qltv.QL_DocGias
where tl.MaDocGia == madocgia
select tl.AnhDocGia).FirstOrDefault();
byte[] anhDocGia = abc.ToArray();
return(anhDocGia);
}
public bool kiemTra(string tendangnhap)
{
QLTVDataContext qltv = new QLTVDataContext();
QL_NguoiDung nd = qltv.QL_NguoiDungs.Where(t => t.TenDangNhap == tendangnhap).FirstOrDefault();
if (nd != null)
{
return(true);
}
return(false);
}
public string taoMaTuDong()
{
QLTVDataContext qltv = new QLTVDataContext();
var item = qltv.QL_DocGias.Max(d => d.MaDocGia);
if (item == null)
{
item = "0";
}
return(item.ToString());
}
public string taoMaTuDong()
{
QLTVDataContext qltv = new QLTVDataContext();
var item = qltv.QL_ChiTietTaiLieus.Max(d => d.MaCTTL);
if (item == null)
{
item = 0;
}
return(item.ToString());
}
public bool themnhom(string manhom, string tennhom)
{
QLTVDataContext qltv = new QLTVDataContext();
QL_NhomCuaNguoiDung insert = new QL_NhomCuaNguoiDung();
insert.MaNhom = manhom;
insert.TenNhom = tennhom;
qltv.QL_NhomCuaNguoiDungs.InsertOnSubmit(insert);
qltv.SubmitChanges();
return(true);
}
public string taoMaTuDong()
{
QLTVDataContext qltv = new QLTVDataContext();
var item = qltv.QL_HoaDons.Max(d => d.MaHD);
if (item == null)
{
item = 0;
}
return(item.ToString());
}
public string laytenloaidg(string sdt)
{
QLTVDataContext qltv = new QLTVDataContext();
string maloaidg = (from a in qltv.QL_DocGias
where a.SoDienThoai == sdt
select a.LoaiDocGia).FirstOrDefault();
string tenloaidg = (from b in qltv.QL_LoaiDocGias
where b.MaLoaiDocGia == maloaidg
select b.TenLoaiDocGia).FirstOrDefault();
return(tenloaidg);
}
public IQueryable kiemTraTenDangNhap(string tendangnhap)
{
QLTVDataContext qltv = new QLTVDataContext();
return(from a in qltv.QL_NguoiDungs.Where(p => p.TenDangNhap.CompareTo(tendangnhap) == 0)
select new
{
a.TenDangNhap,
a.MatKhau,
a.MaNhom
});
}
public string loadncc(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
string mancc = (from tl in qltv.QL_ChiTietTaiLieus
where tl.TenChiTiet == tentailieu
select tl.MaNCC).FirstOrDefault();
string tenvitri;
return(tenvitri = (from f in qltv.QL_NhaCungCaps
where f.MaNCC == mancc
select f.TenNCC).FirstOrDefault());
}
public string loadtacgia(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
string matacgia = (from tl in qltv.QL_ChiTietTaiLieus
where tl.TenChiTiet == tentailieu
select tl.MaTG).FirstOrDefault();
string tentacgia;
return(tentacgia = (from f in qltv.QL_TacGias
where f.MaTacGia == matacgia
select f.TenTacGia).FirstOrDefault());
}
public string loadvitri(string tentailieu)
{
QLTVDataContext qltv = new QLTVDataContext();
string mavitri = (from tl in qltv.QL_ChiTietTaiLieus
where tl.TenChiTiet == tentailieu
select tl.MaViTri).FirstOrDefault();
string tenvitri;
return(tenvitri = (from f in qltv.QL_ViTris
where f.MaViTri == mavitri
select f.TenViTri).FirstOrDefault());
}
