示例#1
0
        public T004_SEMANA buscarSemana()
        {
            RepositoryT004_SEMANA _semana = new RepositoryT004_SEMANA();


            return(_semana.ObterTodos().Where(x => x.T004_DT_INICIO <= DateTime.Now.Date && x.T004_DT_FIM >= DateTime.Now.Date).FirstOrDefault());
        }
        public ActionResult carregaForm(int?COORDENACAO)
        {
            IEnumerable <VW001_INFORME_ATUAL> viewInforme  = new List <VW001_INFORME_ATUAL>();
            IEnumerable <T002_INFORME>        informe      = new List <T002_INFORME>();
            RepositoryT002_INFORME            _dbInforme   = new RepositoryT002_INFORME();
            RepositoryVW001_INFORME_ATUAL     _dbVwInforme = new RepositoryVW001_INFORME_ATUAL();
            RepositoryT004_SEMANA             _semana      = new RepositoryT004_SEMANA();
            string competencia = _semana.ObterTodos().OrderByDescending(x => x.T004_ID_SEMANA).FirstOrDefault().T004_COMPETENCIA;
            var    semana      = _semana.ObterTodos().Where(x => x.T004_DT_FIM >= DateTime.Now.Date).FirstOrDefault().T004_NR_SEMANA_MES;

            ViewBag.coord  = COORDENACAO;
            ViewBag.Mat    = "DESKTOP-FABIA";
            ViewBag.comp   = competencia;
            ViewBag.semana = semana;

            informe = _dbInforme.ObterTodos();
            informe = informe.Where(i => i.T004_NR_SEMANA == semana && i.T003_ID_COORDENACAO == COORDENACAO && i.T002_COMPETENCIA == competencia).Take(2);

            viewInforme = _dbVwInforme.ObterTodos().Where(i => i.T003_ID_COORDENACAO == COORDENACAO).OrderByDescending(i => i.T002_ID_INFORME).Take(2);


            return(View("_carregaForm", viewInforme));
        }