public bool AddTheDocGiaAndUser(TheDocGiaDtos DocGia, UserDtos user)
{
try
{
using (var db = new QuanLyThuVienEntities())
{
int ID = TheDocGiaDAO.Instance.IDPlus();
db.THEDOCGIAs.Add(new THEDOCGIA()
{
IDDocGia = ID,
HoTenDG = DocGia.HoTenDG,
DiaChiDG = DocGia.DiaChiDG,
EmailDG = DocGia.EmailDG,
NgaySinhDG = DocGia.NgaySinhDG,
NgayLapThe = DocGia.NgayLapThe,
IDLoaiDG = DocGia.IDLoaiDocGia,
TongNo = 0,
NgayHetHan = TheDocGiaDAO.Instance.countHanThe(DocGia.NgayLapThe),
});
db.USERS.Add(new USER()
{
IDDocGia = ID,
UserName = user.UserName,
Pwd = user.Password,
});
db.SaveChanges();
return(true);
}
}
catch (Exception)
{
return(false);
}
}
//[ChildActionOnly] xu ly tim kiem doc gia
public ActionResult KQTKiem(string TuKhoa, string KieuTim, int?page)
{
QuanLyThuVienEntities data = new QuanLyThuVienEntities();
var kq = from ngd in data.NguoiDungs
where ((ngd.DeleteFlag != 1 || ngd.DeleteFlag == null))
select ngd;
if (KieuTim == "TenDG")
{
kq = from ngd in data.NguoiDungs
where (ngd.HoTen.Contains(TuKhoa) && (ngd.DeleteFlag != 1 || ngd.DeleteFlag == null))
select ngd;
}
if (KieuTim == "MaDG")
{
kq = from ngd in data.NguoiDungs
where (ngd.TenDangNhap.Contains(TuKhoa) && (ngd.DeleteFlag != 1 || ngd.DeleteFlag == null))
select ngd;
}
ViewBag.TuKhoa = TuKhoa;
ViewBag.KieuTim = KieuTim;
kq = kq.OrderBy(s => s.MaNguoiDung);
int pageSize = 4;
int pageNumber = (page ?? 1);
return(View("KQTKiem", kq.ToList().ToPagedList(pageNumber, pageSize)));
}
public List <BaoCaoTinhHinhMuonSachDTO> getListBaoCaoTinhHinhMuonSachToDate(int Thang, int Nam)
{
using (var db = new QuanLyThuVienEntities())
{
var getList = (from a in db.CT_BCTINHHINHMUONSACH
from b in db.BCTINHHINHMUONSACHes
where b.Thang.Equals(Thang) && b.Nam.Equals(Nam) && a.IDBCMuonSach.Equals(b.IDBCMuonSach)
select new BaoCaoTinhHinhMuonSachDTO()
{
IDBCMuonSach = b.IDBCMuonSach,
IDCTBCMuonSach = a.IDCTBCMuonSach,
IDLoaiSach = a.IDLoaiSach,
SoLuotMuon = a.SoLuotMuon,
TiLe = a.TiLe,
}).ToList <BaoCaoTinhHinhMuonSachDTO>();
var getListToDate = (from a in getList
select new BaoCaoTinhHinhMuonSachDTO()
{
IDBCMuonSach = a.IDBCMuonSach,
IDCTBCMuonSach = a.IDCTBCMuonSach,
IDLoaiSach = a.IDLoaiSach,
TenTheLoai = GetDataDAO.Instance.getTenLoaiSachToIDLoaiSach(a.IDLoaiSach),
SoLuotMuon = a.SoLuotMuon,
TiLe = a.TiLe,
}).ToList <BaoCaoTinhHinhMuonSachDTO>();
if (getListToDate.Count() > 0)
{
return(getListToDate);
}
return(new List <BaoCaoTinhHinhMuonSachDTO>());
}
}
//get List Search IDSach
public List <SachDTO> getFormSachSearchIDSach(int IDsach)
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.SACHes
where a.IDSach.Equals(IDsach)
select new SachDTO()
{
IDSach = a.IDSach,
IDDauSach = a.IDDauSach,
IDTacGia = a.IDTacGia,
TenDauSach = GetDataDAO.Instance.getTenDausachToIDDauSach(a.IDDauSach),
TenTG = GetDataDAO.Instance.getTenTacGiaToIDTacGia(a.IDTacGia),
NamXB = a.NamXB,
NhaXB = a.NhaXB,
GiaTien = a.GiaTien,
SoLuongTon = a.SoLuongTon,
}).ToList <SachDTO>();
if (result.Count > 0)
{
return(result);
}
return(new List <SachDTO>());
}
}
// get list CuonSachDTO
public List <CuonSachDTO> getList(string TenDauSach, string TenTacGia)
{
using (var db = new QuanLyThuVienEntities())
{
var list = (from a in db.DAUSACHes
join b in db.SACHes on a.IDDauSach equals b.IDDauSach
join c in db.TACGIAs on b.IDTacGia equals c.IDTacGia
join d in db.CUONSACHes on b.IDSach equals d.IDSach
where a.TenDauSach.Equals(TenDauSach) && c.TenTacGia.Equals(TenTacGia) && d.TinhTrang == "Chưa cho mượn"
select new CuonSachDTO()
{
IDCuonSach = d.IDCuonSach,
IDSach = d.IDSach,
TinhTrang = "Chưa cho mượn",
TenDauSach = TenDauSach,
TenTacGia = TenTacGia,
}).ToList <CuonSachDTO>();
var getList = (from a in list
select new CuonSachDTO()
{
IDCuonSach = a.IDCuonSach,
IDSach = a.IDSach,
TenDauSach = a.TenDauSach,
TenTacGia = a.TenTacGia,
TinhTrang = a.TinhTrang,
}).ToList <CuonSachDTO>();
if (getList.Count > 0)
{
return(getList);
}
return(new List <CuonSachDTO>());
}
}
public List <PhieuMuonDTO> getAllFormPhieuMuonAndCTPhieuMuon()
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.PHIEUMUONs
join b in db.CT_PHIEUMUON on a.IDPhieuMuon equals b.IDPhieuMuon
select new PhieuMuonDTO()
{
IDDocGia = a.IDDocGia,
IDPhieuMuon = a.IDPhieuMuon,
NgayMuon = a.NgayMuon,
HanTra = a.HanTra,
IDCTPhieuMuon = b.IDCTPhieuMuon,
IDCuonSach = b.IDCuonSach,
}).ToList <PhieuMuonDTO>();
var Result = (from c in result
select new PhieuMuonDTO()
{
IDDocGia = c.IDDocGia,
IDPhieuMuon = c.IDPhieuMuon,
IDCTPhieuMuon = c.IDCTPhieuMuon,
IDCuonSach = c.IDCuonSach,
NgayMuon = c.NgayMuon,
HanTra = c.HanTra,
TenNguoiMuon = GetDataDAO.Instance.getTenDocGiaToIDDocGia(c.IDDocGia),
TenDauSach = GetDataDAO.Instance.getTenCuonSach(c.IDCuonSach),
}).ToList <PhieuMuonDTO>();
if (Result.Count > 0)
{
return(Result);
}
return(new List <PhieuMuonDTO>());
}
}
//get List cuonsachDtos to HoTenDG
public List <CuonSachDtos> getListCuonSachDtos(string HoTenDG)
{
using (var db = new QuanLyThuVienEntities())
{
var list = (
from b in db.THEDOCGIAs
from d in db.PHIEUMUONs
from c in db.CUONSACHes
from a in db.CT_PHIEUMUON
where b.HoTenDG.Equals(HoTenDG) && b.IDDocGia.Equals(d.IDDocGia) && d.IDPhieuMuon.Equals(a.IDPhieuMuon) &&
c.IDCuonSach.Equals(a.IDCuonSach) && c.TinhTrang == "Đã cho mượn"
select new CuonSachDtos()
{
IDCuonSach = a.IDCuonSach,
IDSach = c.IDSach,
TinhTrang = c.TinhTrang,
}).ToList <CuonSachDtos>();
var listkq = (from a in list
select new CuonSachDtos()
{
IDCuonSach = a.IDCuonSach,
IDSach = a.IDSach,
TenCuonSach = getTenCuonSach(a.IDCuonSach),
TinhTrang = a.TinhTrang,
}).ToList <CuonSachDtos>();
if (listkq.Count > 0)
{
return(listkq);
}
return(new List <CuonSachDtos>());
}
}
//getList Search TenTacGia From "TacGia"
public List <TacGiaDtos> getFormTacGiaSearchTenTacGia(string TenTacGia)
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.TACGIAs
where a.TenTacGia.ToUpper().Contains(TenTacGia.ToUpper())
select new TacGiaDtos()
{
IDTacGia = a.IDTacGia,
TenTacGia = a.TenTacGia,
NgaySinh = a.NgaySinh,
}).ToList <TacGiaDtos>();
var listSearchTenTG = (from b in result
select new TacGiaDtos()
{
IDTacGia = b.IDTacGia,
TenTacGia = b.TenTacGia,
NgaySinh = b.NgaySinh
}).ToList <TacGiaDtos>();
if (listSearchTenTG.Count > 0)
{
return(listSearchTenTG);
}
return(new List <TacGiaDtos>());
}
}
//getList Search NgaySinhTacGia From "TacGia"
public List <TacGiaDtos> getFormTacGiaSearchNgaySinhTG(DateTime NgaySinh)
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.TACGIAs
where a.NgaySinh.Equals(NgaySinh)
select new TacGiaDtos()
{
IDTacGia = a.IDTacGia,
TenTacGia = a.TenTacGia,
NgaySinh = a.NgaySinh,
}).ToList <TacGiaDtos>();
var listSearchNgaySinhTG = (from b in result
select new TacGiaDtos()
{
IDTacGia = b.IDTacGia,
TenTacGia = b.TenTacGia,
NgaySinh = b.NgaySinh
}).ToList <TacGiaDtos>();
if (listSearchNgaySinhTG.Count > 0)
{
return(listSearchNgaySinhTG);
}
return(new List <TacGiaDtos>());
}
}
//getListSearch IDDocGia From "User"
public List <UserDTO> getFromUserSearchIDDocGia(int ID)
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.USERS
where a.IDDocGia.Equals(ID)
select new UserDtos()
{
UserName = a.UserName,
Password = a.Pwd,
IDDocGia = a.IDDocGia,
}).ToList <UserDtos>();
var Resultkq = (from b in result
select new UserDTO()
{
UserName = b.UserName,
Password = b.Password,
IDDocGia = b.IDDocGia,
HoTenDocGia = GetDataDAO.Instance.getTenDocGiaToIDDocGia(b.IDDocGia),
}).ToList <UserDTO>();
if (Resultkq.Count > 0)
{
return(Resultkq);
}
return(new List <UserDTO>());
}
}
public List <TacGiaDtos> getAllFormTacGia()
{
using (var db = new QuanLyThuVienEntities())
{
var getAll = (from a in db.TACGIAs
select new TacGiaDtos()
{
IDTacGia = a.IDTacGia,
TenTacGia = a.TenTacGia,
NgaySinh = a.NgaySinh,
}).ToList <TacGiaDtos>();
var getALLFormTacGia = (from a in getAll
select new TacGiaDtos()
{
IDTacGia = a.IDTacGia,
TenTacGia = a.TenTacGia,
NgaySinh = a.NgaySinh,
}
).ToList <TacGiaDtos>();
if (getALLFormTacGia.Count > 0)
{
return(getALLFormTacGia);
}
return(new List <TacGiaDtos>());
}
}
public List <BCSachTraTreDtos> loadBaoCaoToThangNam(int Thang, int Nam)
{
using (var db = new QuanLyThuVienEntities())
{
var load = (from a in db.BCSACHTRATREs
where a.NgayThangNam.Month.Equals(Thang) && a.NgayThangNam.Month.Equals(Nam)
select new BCSachTraTreDtos()
{
IDBCSachTre = a.IDBCSachTre,
IDCuonSach = a.IDCuonSach,
IDPhieuMuon = a.IDPhieuMuon,
NgayThangNam = a.NgayThangNam,
SoNgayTraTre = a.SoNgayTraTre,
}
).ToList <BCSachTraTreDtos>();
var LoadBaoCao = (from a in load
select new BCSachTraTreDtos()
{
IDBCSachTre = a.IDBCSachTre,
IDCuonSach = a.IDCuonSach,
IDPhieuMuon = a.IDPhieuMuon,
NgayThangNam = a.NgayThangNam,
SoNgayTraTre = a.SoNgayTraTre,
TenCuonSach = GetDataDAO.Instance.getTenCuonSach(a.IDCuonSach),
}
).ToList <BCSachTraTreDtos>();
if (LoadBaoCao.Count > 0)
{
return(LoadBaoCao);
}
return(new List <BCSachTraTreDtos>());
}
}
public List <BCSachTraTreDtos> loadBaoCaoToDate(DateTime NgayLapBaoCao)
{
using (var db = new QuanLyThuVienEntities())
{
var load = (from a in db.BCSACHTRATREs
where a.NgayThangNam.CompareTo(NgayLapBaoCao) <= 0
select new BCSachTraTreDtos()
{
IDBCSachTre = a.IDBCSachTre,
IDCuonSach = a.IDCuonSach,
IDPhieuMuon = a.IDPhieuMuon,
NgayThangNam = a.NgayThangNam,
SoNgayTraTre = a.SoNgayTraTre,
}
).ToList <BCSachTraTreDtos>();
var LoadBaoCao = (from a in load
select new BCSachTraTreDtos()
{
IDBCSachTre = a.IDBCSachTre,
IDCuonSach = a.IDCuonSach,
IDPhieuMuon = a.IDPhieuMuon,
NgayThangNam = a.NgayThangNam,
SoNgayTraTre = a.SoNgayTraTre,
TenCuonSach = GetDataDAO.Instance.getTenCuonSach(a.IDCuonSach),
}
).ToList <BCSachTraTreDtos>();
if (LoadBaoCao.Count > 0)
{
return(LoadBaoCao);
}
return(new List <BCSachTraTreDtos>());
}
}
public List <BCSachTraTreDtos> getListAllBCSachTraTre()
{
using (var db = new QuanLyThuVienEntities())
{
var getList = (from a in db.BCSACHTRATREs
select new BCSachTraTreDtos()
{
IDBCSachTre = a.IDBCSachTre,
IDCuonSach = a.IDCuonSach,
IDPhieuMuon = a.IDPhieuMuon,
NgayThangNam = a.NgayThangNam,
SoNgayTraTre = a.SoNgayTraTre,
}).ToList <BCSachTraTreDtos>();
var getListAll = (from a in getList
select new BCSachTraTreDtos()
{
IDBCSachTre = a.IDBCSachTre,
IDCuonSach = a.IDCuonSach,
IDPhieuMuon = a.IDPhieuMuon,
NgayThangNam = a.NgayThangNam,
SoNgayTraTre = a.SoNgayTraTre,
TenCuonSach = GetDataDAO.Instance.getTenCuonSach(a.IDCuonSach),
}).ToList <BCSachTraTreDtos>();
if (getListAll.Count > 0)
{
return(getListAll);
}
return(new List <BCSachTraTreDtos>());
}
}
// get List Search NamXuatBan
public List <SachDTO> getFormSachNamXuatBan(string NamXB)
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.SACHes
from b in db.CT_PHIEUNHAPSACH
where a.NamXB.Equals(NamXB) && a.IDSach.Equals(b.IDSach)
select new SachDTO()
{
IDSach = a.IDSach,
IDDauSach = a.IDDauSach,
IDTacGia = a.IDTacGia,
//TenDauSach = GetDataDAO.Instance.getTenDausachToIDDauSach(a.IDDauSach),
//TenTG = GetDataDAO.Instance.getTenTacGiaToIDTacGia(a.IDTacGia),
NamXB = a.NamXB,
NhaXB = a.NhaXB,
GiaTien = a.GiaTien,
SoLuongTon = a.SoLuongTon,
IDCTPhieuNhap = b.IDCTPhieuNhap,
IDPhieuNhap = b.IDPhieuNhap,
DonGia = b.DonGia,
}).ToList <SachDTO>();
if (result.Count > 0)
{
return(result);
}
return(new List <SachDTO>());
}
}
//get List Search IDPhieuMuon
public List <PhieuMuonDTO> getFormPhieuMuonSearchIDPhieuMuon(int ID)
{
using (var db = new QuanLyThuVienEntities())
{
var result = (from a in db.PHIEUMUONs
join b in db.CT_PHIEUMUON on a.IDPhieuMuon equals b.IDPhieuMuon
where a.IDPhieuMuon.Equals(ID)
select new PhieuMuonDTO()
{
IDDocGia = a.IDDocGia,
IDPhieuMuon = ID,
NgayMuon = a.NgayMuon,
HanTra = a.HanTra,
IDCTPhieuMuon = b.IDCTPhieuMuon,
IDCuonSach = b.IDCuonSach,
}).ToList <PhieuMuonDTO>();
var listSearchIDPhieuMuon = (from a in result
select new PhieuMuonDTO()
{
IDDocGia = a.IDDocGia,
IDPhieuMuon = a.IDPhieuMuon,
NgayMuon = a.NgayMuon,
HanTra = a.HanTra,
IDCTPhieuMuon = a.IDCTPhieuMuon,
TenDauSach = GetDataDAO.Instance.getTenDausachToIDDauSach(a.IDCuonSach),
IDCuonSach = a.IDCuonSach,
}).ToList <PhieuMuonDTO>();
if (listSearchIDPhieuMuon.Count > 0)
{
return(listSearchIDPhieuMuon);
}
return(new List <PhieuMuonDTO>());
}
}
//getListSearch NgaySinhDG from "TheDocGia"
public List <TheDocGiaDTO> getFormTheDocGiaSearchNgaySinhDG(DateTime NgaySinh)
{
using (var db = new QuanLyThuVienEntities())
{
var Result = (from a in db.THEDOCGIAs
where a.NgayLapThe.Equals(NgaySinh)
select new TheDocGiaDtos()
{
IDDocGia = a.IDDocGia,
HoTenDG = a.HoTenDG,
EmailDG = a.EmailDG,
DiaChiDG = a.DiaChiDG,
HetHan = a.NgayHetHan,
NgayLapThe = a.NgayLapThe,
IDLoaiDocGia = a.IDLoaiDG,
NgaySinhDG = NgaySinh,
TongNo = a.TongNo,
}).ToList <TheDocGiaDtos>();
var Resultkq = (from b in Result
join c in db.USERS on b.IDDocGia equals c.IDDocGia
select new TheDocGiaDTO()
{
IDDocGia = b.IDDocGia,
HoTenDG = b.HoTenDG,
EmailDG = b.EmailDG,
NgaySinhDG = b.NgaySinhDG,
NgayLapThe = b.NgayLapThe,
NgayHetHan = b.HetHan,
IDLoaiDocGia = b.IDLoaiDocGia,
DiaChiDG = b.DiaChiDG,
TongNo = b.TongNo,
Password = c.Pwd,
UserName = c.UserName,
}).ToList <TheDocGiaDTO>();
var listSearchNgaySinh = (from a in Resultkq
select new TheDocGiaDTO()
{
IDDocGia = a.IDDocGia,
HoTenDG = a.HoTenDG,
EmailDG = a.EmailDG,
NgaySinhDG = a.NgaySinhDG,
DiaChiDG = a.DiaChiDG,
NgayLapThe = a.NgayLapThe,
NgayHetHan = a.NgayHetHan,
TenLoaiDocGia = HelperDAO.Instance.checkLoaiDocGiaFromID(a.IDLoaiDocGia),
Password = a.Password,
IDLoaiDocGia = a.IDLoaiDocGia,
UserName = a.UserName,
TongNo = a.TongNo,
}
).ToList <TheDocGiaDTO>();
if (listSearchNgaySinh.Count > 0)
{
return(listSearchNgaySinh);
}
return(new List <TheDocGiaDTO>());
}
}
public string[] getArrTenDG()
{
using (var db = new QuanLyThuVienEntities())
{
var arr = (from a in db.THEDOCGIAs
select a.HoTenDG.ToString()).ToArray();
return(arr);
}
}
//Goi view Chi Tiet Doc Gia
public ActionResult chitietDGia(int id)
{
QuanLyThuVienEntities data = new QuanLyThuVienEntities();
NguoiDung ngd = (from ngds in data.NguoiDungs
where ngds.MaNguoiDung == id
select ngds).First();
return(View("chitietDGia", ngd));
}
//get list NhaXB
public string[] getArrNhaXB()
{
using (var db = new QuanLyThuVienEntities())
{
var listNhaXB = (from a in db.SACHes
select a.NhaXB.ToString()).ToArray();
return(listNhaXB);
}
}
//get Arr TenDauSach
public String[] getArrTenDauSach()
{
using (var db = new QuanLyThuVienEntities())
{
var ArrTenDauSach = (from a in db.DAUSACHes
select a.TenDauSach.ToString()).ToArray();
return(ArrTenDauSach);
}
}
// get List TenTacGia
public List <string> getListTenTacGia()
{
using (var db = new QuanLyThuVienEntities())
{
var listTenTacGia = (from a in db.TACGIAs
select a.TenTacGia.ToString()).ToList();
return(listTenTacGia);
}
}
//get arr IDDG
public int[] getArrIDDG()
{
using (var db = new QuanLyThuVienEntities())
{
var ArrIDDG = (from a in db.THEDOCGIAs
select a.IDDocGia).ToArray();
return(ArrIDDG);
}
}
//get Array TenTacGia
public string[] getArrayTenTacGia()
{
using (var db = new QuanLyThuVienEntities())
{
var ArrTenTacGia = (from a in db.TACGIAs
select a.TenTacGia).ToArray();
return(ArrTenTacGia);
}
}
//getList TenTheLoai Sach
public List <string> getListTenTheLoaiSach()
{
using (var db = new QuanLyThuVienEntities())
{
var listTenTheLoai = (from a in db.LOAISACHes
select a.TenLoaiSach.ToString()).ToList();
return(listTenTheLoai);
}
}
// get NguoiLapBaoCao
public string getNguoiLapBaoCao()
{
using (var db = new QuanLyThuVienEntities())
{
var NguoiLap = (from a in db.USERADMINs
select a.UserNameAdmin).FirstOrDefault();
return(NguoiLap);
}
}
//get IDPhieuMuon to IDCTPhieuTra
public int getIDPhieuMuonToIDCTPhieuTra(int ID)
{
using (var db = new QuanLyThuVienEntities())
{
var IDPhieuMuon = (from a in db.CT_PHIEUTRA
select a.IDPhieuMuon).FirstOrDefault();
return(IDPhieuMuon);
}
}
//Cập nhật ảnh của người dùng (Từ)
public ActionResult capnhatAnh(string username)
{
QuanLyThuVienEntities data = new QuanLyThuVienEntities();
NguoiDung ngd = (from ngds in data.NguoiDungs
where ngds.TenDangNhap == username
select ngds).First();
return(View("~/Views/DocGia/CapNhatAnh.cshtml", ngd));
}
// get list TheLoaiSach
public List <int> getListTheLoaiSach()
{
using (var db = new QuanLyThuVienEntities())
{
var listTheLoai = (from a in db.LOAISACHes
select a.IDLoaiSach).ToList <int>();
return(listTheLoai);
}
}
public ActionResult capnhatAnh(string id)
{
QuanLyThuVienEntities data = new QuanLyThuVienEntities();
NguoiDung ngd = (from ngds in data.NguoiDungs
where (ngds.TenDangNhap == id)
select ngds).First();
return(View("capnhatAnh", ngd));
}
