public int LaySTTSachMuon(int MaxiMum)
{
int Temp = 0;
KetNoi = new Data.QuanLyThuVienDataContext();
var Query = (from DK in KetNoi.TempTable_MuonSaches
select DK).FirstOrDefault();
if (Query == null)
{
return(Temp = 1);
}
else
{
Temp = (from linq in KetNoi.TempTable_MuonSaches
select linq.STT).Max();
if (Temp < MaxiMum)
{
return(Temp + 1);
}
else
{
return(Temp = 0);
}
}
}
public void LapTheDocGia(TheDocGia TheDocGia)
{
Data.LapPhieu Temp = new Data.LapPhieu();
Data.DocGia Temp2 = new Data.DocGia();
Temp.IdNguoiLap = TheDocGia.IdNguoiLap;
Temp.MaPhieu = TheDocGia.MaVe;
Temp2.IdDocGia = TheDocGia.IdDocGia;
Temp2.TenDocGia = TheDocGia.HoTen;
Temp2.NgaySinh = TheDocGia.NgaySinh;
Temp2.CMND = TheDocGia.CMND;
Temp2.GioiTinh = TheDocGia.GioiTinh;
Temp2.DiaChi = TheDocGia.DiaChi;
Temp2.SDT = TheDocGia.Phone;
Temp2.Email = TheDocGia.Mail;
Temp2.LoaiDocGia = TheDocGia.LoaiDocGia;
Temp2.NgayLap = TheDocGia.NgayLapThe;
Temp2.MaPhieu = TheDocGia.MaVe;
KetNoi = new Data.QuanLyThuVienDataContext();
KetNoi.LapPhieus.InsertOnSubmit(Temp);
KetNoi.DocGias.InsertOnSubmit(Temp2);
KetNoi.SubmitChanges();
}
public IQueryable ComboxSach_FrmPhieuMuon()
{
KetNoi = new Data.QuanLyThuVienDataContext();
IQueryable sql = (from i in KetNoi.Saches
select i);
return(sql);
}
public void UpdateAvatar(string IdNguoiDung, Binary AnhNguoiDung)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Anh Temp2 = new Data.Anh();
Temp2 = KetNoi.Anhs.Where(s => s.IdNguoiDung == IdNguoiDung).Single();
Temp2.Images = AnhNguoiDung;
KetNoi.SubmitChanges();
}
public IQueryable DGVCaiDat()
{
KetNoi = new Data.QuanLyThuVienDataContext();
IQueryable sql = (from T in KetNoi.CaiDats
select new { T.TuoiMuonSach, T.HanSuDungThe, T.NgayMuonToiDa, T.SoLuongSachMuonToiDa });
return(sql);
}
public void CapNhatSachTrongKho(int SoLuong, string MaSach)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Sach Temp2 = new Data.Sach();
Temp2 = KetNoi.Saches.Where(s => s.MaSach == MaSach).Single();
Temp2.SoLuong = SoLuong;
KetNoi.SubmitChanges();
}
//
public TheDocGia InfoPhieuDocGia(int IdDocGia)
{
TheDocGia Temp = new TheDocGia();
KetNoi = new Data.QuanLyThuVienDataContext();
//LayTen
Temp.HoTen = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.TenDocGia).Single();
//LayGioiTinh
Temp.GioiTinh = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.GioiTinh).Single();
//LayNgaySinh
Temp.NgaySinh = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.NgaySinh).Single();
//LayDienThoai
Temp.Phone = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.SDT).Single();
//LayDiaChi
Temp.DiaChi = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.DiaChi).Single();
//LayCMND
Temp.CMND = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.CMND).Single();
//LayMail
Temp.Mail = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.Email).Single();
//LayNgayLap
Temp.NgayLapThe = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.NgayLap).Single();
//LayMaPhieu
Temp.MaVe = (from linq in KetNoi.DocGias
where linq.IdDocGia == IdDocGia
select linq.MaPhieu).Single();
return(Temp);
}
//
public IQueryable DataViewDanhSachSach()
{
KetNoi = new Data.QuanLyThuVienDataContext();
IQueryable sql = (from DG in KetNoi.Saches
select DG) /*new { DG.IdDocGia, DG.TenDocGia, DG.NgaySinh, DG.CMND, DG.GioiTinh, DG.DiaChi, DG.SDT, DG.Email, DG.LoaiDocGia, DG.NgayLap, DG.MaPhieu })*/;
return(sql);
}
//view
public IQueryable InfoSach_DgvTemp()
{
KetNoi = new Data.QuanLyThuVienDataContext();
IQueryable sql = (from T in KetNoi.TempTable_MuonSaches
select new { T.STT, T.Sach, T.TacGia, T.TheLoai });
return(sql);
}
public IList TraCuuSach(string str)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var sql = (from timkiem in KetNoi.Saches
where timkiem.TheLoai.Contains(str) ||
timkiem.TenSach.Contains(str)
select timkiem).ToList();
return(sql);
}
public void RemoveSach_DgvTemp(int STT)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.TempTable_MuonSach Temp = new Data.TempTable_MuonSach();
Temp = KetNoi.TempTable_MuonSaches.Where(s => s.STT == STT).Single();
KetNoi.TempTable_MuonSaches.DeleteOnSubmit(Temp);
KetNoi.SubmitChanges();
}
//
public void XoaSach(string MaSach)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Sach Temp1 = new Data.Sach();
Temp1 = KetNoi.Saches.Where(s => s.MaSach == MaSach.ToString()).Single();
KetNoi.Saches.DeleteOnSubmit(Temp1);
KetNoi.SubmitChanges();
}
public IList LayMaSach(string MaMuon)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var sql = (from b in KetNoi.Saches
from c in KetNoi.ChiTietMuonSaches
where b.MaSach == c.MaSach && c.MaMuon == MaMuon
select b.MaSach).ToList();
return(sql);
}
public Stream ReadImage(string IdNguoiDung)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var Query = (from p in KetNoi.Anhs
where p.IdNguoiDung == IdNguoiDung
select p.Images).First();
return(new MemoryStream(Query.ToArray()));
}
//Dếm Sách Mượn Tạm Trong Bảng TempView
public int DemSachTemp()
{
KetNoi = new Data.QuanLyThuVienDataContext();
int Temp = (from sql in KetNoi.TempTable_MuonSaches
select sql.STT).Count();
// KetNoi.TempTable_MuonSaches.Count(); Count * form ......
return(Temp);
}
//Cộng SoLuongSach
public void Plus_SoLuongSach(string MaSach)
{
Class.XuLyThuVien KiemTra = new Class.XuLyThuVien();
int SoLuong = KiemTra.LaySoLuongSach(MaSach);
KetNoi = new Data.QuanLyThuVienDataContext();
Data.Sach Temp2 = new Data.Sach();
Temp2 = KetNoi.Saches.Where(s => s.MaSach == MaSach).Single();
Temp2.SoLuong = SoLuong + 1;
KetNoi.SubmitChanges();
}
// Lấy Mã Sách
public string LayMaSach_TempView(int STT)
{
KetNoi = new Data.QuanLyThuVienDataContext();
string MaSach;
MaSach = (from linq in KetNoi.TempTable_MuonSaches
where linq.STT == STT
select linq.MaSach).Single();
return(MaSach);
}
public void XoaTheDocGia(int IdDocGia)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.DocGia Temp2 = new Data.DocGia();
Data.LapPhieu Temp1 = new Data.LapPhieu();
Temp2 = KetNoi.DocGias.Where(s => s.IdDocGia == IdDocGia).Single();
Temp1 = KetNoi.LapPhieus.Where(s => s.MaPhieu == IdDocGia.ToString()).Single();
KetNoi.DocGias.DeleteOnSubmit(Temp2);
KetNoi.LapPhieus.DeleteOnSubmit(Temp1);
KetNoi.SubmitChanges();
}
public IQueryable InfoPhieuMuonSach(string MaMuon)
{
KetNoi = new Data.QuanLyThuVienDataContext();
IQueryable sql = (from p in KetNoi.PhieuMuonSaches
from c in KetNoi.ChiTietMuonSaches
from s in KetNoi.Saches
where (p.MaMuon == c.MaMuon) && (c.MaSach == s.MaSach) && (p.MaMuon == MaMuon)
select new { c.SoTT, s.TenSach, s.TheLoai, s.TenTacGia });
return(sql);
}
public IQueryable GVMuonSach()
{
KetNoi = new Data.QuanLyThuVienDataContext();
IQueryable sql = (from p in KetNoi.PhieuMuonSaches
from d in KetNoi.DocGias
from l in KetNoi.LapPhieus
where (p.MaPhieu == l.MaPhieu) && (l.MaPhieu == d.MaPhieu)
select new { d.TenDocGia, p.NgayMuon, p.MaMuon });
return(sql);
}
public void XoaPhieuMuonSach(string MaPhieu)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.PhieuMuonSach Temp = new Data.PhieuMuonSach();
if (MaPhieuMuonTonTai(MaPhieu) == 1)
{
Temp = KetNoi.PhieuMuonSaches.Where(s => s.MaPhieu == MaPhieu).Single();
KetNoi.PhieuMuonSaches.DeleteOnSubmit(Temp);
KetNoi.SubmitChanges();
}
}
public string TenDocGia_PhieuMuon(string MaPhieu)
{
KetNoi = new Data.QuanLyThuVienDataContext();
string temp = (from d in KetNoi.DocGias
from l in KetNoi.LapPhieus
where (d.MaPhieu == l.MaPhieu) && (l.MaPhieu == MaPhieu)
select d.TenDocGia).Single();
return(temp);
}
public void CaiDatThuVien(Class.CaiDat Setting)
{
KetNoi = new Data.QuanLyThuVienDataContext();
Data.CaiDat Temp = new Data.CaiDat();
Temp = KetNoi.CaiDats.Where(s => s.i == 1).Single();
Temp.TuoiMuonSach = Setting.TuoiMuonSach;
Temp.HanSuDungThe = Setting.HanSuDungThe;
Temp.NgayMuonToiDa = Setting.NgayMuonToiDa;
Temp.SoLuongSachMuonToiDa = Setting.SachMuonToiDa;
KetNoi.SubmitChanges();
}
public bool TinhTrangSach(string MaSach)
{
KetNoi = new Data.QuanLyThuVienDataContext();
int Query = Convert.ToInt32((from Test in KetNoi.Saches
where Test.MaSach == MaSach
select Test.SoLuong).Single());
if (Query < 1)
{
return(false);
}
return(true);
}
//XoaPhieuMuonSach
public int MaPhieuMuonTonTai(string MaPhieu)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var Query = (from p in KetNoi.PhieuMuonSaches
where p.MaPhieu == MaPhieu
select p).SingleOrDefault();
if (Query == null)
{
return(0);
}
return(1);
}
public int DangNhap(string Id, string Passwd)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var Query = (from Login in KetNoi.TaiKhoans
where Login.IdNguoiDung == Id.Trim() && Login.PassND == Passwd
select Login).SingleOrDefault();
if (Query == null)
{
return(0);
}
return(1);
}
public bool MaPhieuTonTai(string MaPhieu)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var Query = (from Test in KetNoi.LapPhieus
where Test.MaPhieu == MaPhieu
select Test).SingleOrDefault();
if (Query == null)
{
return(false);
}
return(true);
}
public bool DaMuonSachRoi(string MaMuon)
{
KetNoi = new Data.QuanLyThuVienDataContext();
var Query = (from c in KetNoi.ChiTietMuonSaches
where c.MaMuon == MaMuon
select c).FirstOrDefault();
if (Query == null)
{
return(false);
}
return(true);
}
public void ChiTietMuonSach(string MaSach, int STT, string MaMuon)
{
Data.ChiTietMuonSach ctms = new Data.ChiTietMuonSach();
ctms.SoTT = STT;
ctms.MaSach = MaSach;
ctms.MaMuon = MaMuon;
KetNoi = new Data.QuanLyThuVienDataContext();
KetNoi.ChiTietMuonSaches.InsertOnSubmit(ctms);
KetNoi.SubmitChanges();
}
public void XoaChiTietMuonSach(string MaMuon)
{
KetNoi = new Data.QuanLyThuVienDataContext();
if (DaMuonSachRoi(MaMuon) == true)
{
var Temp = from sql in KetNoi.ChiTietMuonSaches where sql.MaMuon == MaMuon select sql;
foreach (var item in Temp)
{
KetNoi.ChiTietMuonSaches.DeleteOnSubmit(item);
}
KetNoi.SubmitChanges();
}
}
