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