/*       public IQueryable<TinViecLam> timKiemTinViecLam(SearchHomeModel searchModel)
         *     {
         *         var result = db.TinViecLams.AsQueryable();
         *         IEnumerable<CongTy> congTies = db.CongTies.Where(t => t.ID_ThanhPho == searchModel.ID_ThanhPho).AsEnumerable();
         *
         *         TinViecLam tinViecLam = db.TinViecLams.Where
         *
         *         if (searchModel != null)
         *         {
         *
         *             if (searchModel.ID_NganhNghe.HasValue)
         *                 result = result.Where(x => x.ID_NganhNghe == searchModel.ID_NganhNghe && x.ID_CongTy = (congTies.));
         *
         *
         *
         *             result = result.Where(x => x.ID_CongTy);
         *
         *
         *
         *
         *
         *
         *         }
         *         return result;
         *             }
         */
        public SearchHomeModel listHome()
        {
            CongTyDAO     congTyDAO      = new CongTyDAO();
            NganhNgheDAO  ngheDAO        = new NganhNgheDAO();
            ThanhPhoDAO   thanhPhoDAO    = new ThanhPhoDAO();
            TinViecLamDAO tinViecLamDAO  = new TinViecLamDAO();
            var           CongTyList     = congTyDAO.dsCongTy();
            var           NganhNGheList  = ngheDAO.dsNganhNghe();
            var           thanhPhoList   = thanhPhoDAO.dsThanhPho();
            var           tinviecLamList = tinViecLamDAO.dsTinViecLam();

            var cV_UngViens = db.CV_UngVien.ToList();
            var UngViens    = db.UngViens.ToList();


            var model = new SearchHomeModel()
            {
                CvUngviens  = cV_UngViens,
                Ungviens    = UngViens,
                ThanhPhos   = thanhPhoList,
                NganhNghes  = NganhNGheList,
                CongTys     = CongTyList,
                TinViecLams = tinviecLamList
            };

            return(model);
        }
Esempio n. 2
0
        public HomeView ListDetail(int?id)
        {
            if (db.TinViecLams.Find(id) == null)
            {
                return(null);
            }
            TinViecLam tinViecLam = db.TinViecLams.Find(id);
            var        congty     = db.CongTies.Find(tinViecLam.ID_CongTy);
            var        thanhPho   = db.ThanhPhoes.Find(congty.ID_ThanhPho);
            var        nganhNghe  = db.NganhNghes.Find(tinViecLam.ID_NganhNghe);
            var        trinhdo    = db.TrinhDoes.Find(tinViecLam.ID_TrinhDo);
            var        kinhnghiem = db.KinhNghiems.Find(tinViecLam.ID_KinhNghiem);
            var        vitri      = db.ViTriUngTuyens.Find(tinViecLam.ID_ViTri);

            CongTyDAO     congTyDAO      = new CongTyDAO();
            NganhNgheDAO  ngheDAO        = new NganhNgheDAO();
            ThanhPhoDAO   thanhPhoDAO    = new ThanhPhoDAO();
            TinViecLamDAO tinViecLamDAO  = new TinViecLamDAO();
            var           CongTyList     = congTyDAO.dsCongTy();
            var           tinviecLamList = tinViecLamDAO.dsTinViecLam();
            var           model          = new HomeView
            {
                CongTy        = congty,
                ThanhPho      = thanhPho,
                NganhNghe     = nganhNghe,
                TrinhDo       = trinhdo,
                KinhNghiem    = kinhnghiem,
                ViTriUngTuyen = vitri,
                TinViecLam    = tinViecLam,
                TinViecLams   = tinviecLamList,
                CongTies      = CongTyList,
            };

            return(model);
        }