Exemple #1
0
        private GridFilterModel GetGridFilter(string filterName)
        {
            var wheres = new List <SqlWhere>();

            wheres.Add(new SqlWhere(null, null, "GridFilter", "Name", filterName, null, SqlWhereComparison.SqlComparer.Equal, SqlWhereAndOrOptions.SqlWhereAndOr.And));
            wheres.Add(new SqlWhere(null, null, "GridFilter", "PageName_Key", _page.PageKey(Session["ModelType"].GetType().Name.Replace("Model", "")), null, SqlWhereComparison.SqlComparer.Equal, SqlWhereAndOrOptions.SqlWhereAndOr.And));
            GridFilterModel gridFilter = _coreService.LoadModel <GridFilterModel>(wheres, conName: Session["ConString"].ToString()).FirstOrDefault();

            return(gridFilter);
        }
Exemple #2
0
        public ActionResult LoadFilter(string filter)
        {
            ClearFilter();
            GridFilterModel gridFilter = GetGridFilter(filter);
            IEnumerable <GridFilterWhereModel> filterWheres = GetGridFilterWheres(gridFilter.GridFilter_Key);

            filterlist.AddRange(filterWheres);
            createDisplayList(gridFilter.GridFilter_Key);
            HttpRuntime.Cache["FilterList"] = displaylist;
            return(Json("", JsonRequestBehavior.AllowGet));
        }
Exemple #3
0
        public ActionResult RemoveFilter(string filterName)
        {
            string          db         = Session["ConString"].ToString();
            GridFilterModel gridFilter = GetGridFilter(filterName);
            IEnumerable <GridFilterWhereModel> filterWheres = GetGridFilterWheres(gridFilter.GridFilter_Key);

            foreach (var model in filterWheres)
            {
                _coreService.SprocDelete(model, db);
            }
            _coreService.SprocDelete(gridFilter, db);
            return(Json("", JsonRequestBehavior.AllowGet));
        }
Exemple #4
0
        public ActionResult SaveReportFilter(string filterName)
        {
            string          db           = Session["ConString"].ToString();
            bool            filterExists = false;
            GridFilterModel gridFilter   = GetGridFilter(filterName);

            if (gridFilter == null)
            {
                gridFilter = new GridFilterModel
                {
                    PageName_Key      = _page.PageKey(Session["ModelType"].GetType().Name.Replace("Model", "")),
                    Name              = filterName,
                    CreatedByUser_Key = (int)Session["CurrentUserKey"],
                    UpdatedByUser_Key = (int)Session["CurrentUserKey"],
                    Tenant_Key        = (int)Session["CurrentTenantKey"]
                };
                _coreService.SprocInsert(gridFilter, db);
                gridFilter = GetGridFilter(filterName);
            }
            else
            {
                filterExists = true;
                gridFilter.UpdatedByUser_Key = (int)Session["CurrentUserKey"];
                _coreService.SprocUpdate(gridFilter, db);
            }
            createFilterList(gridFilter.GridFilter_Key);


            if (filterExists)
            {
                IEnumerable <GridFilterWhereModel> filterWheres = GetGridFilterWheres(gridFilter.GridFilter_Key);
                if (filterWheres.Count() > 0)
                {
                    foreach (var row in filterWheres)
                    {
                        _coreService.SprocDelete(row, db);
                    }
                }
            }
            foreach (var row in filterlist)
            {
                _coreService.SprocInsert(row, db);
            }
            return(Json(filterName));
        }
Exemple #5
0
        public ActionResult SaveValidation(string filterName)
        {
            GridFilterModel gridFilter = GetGridFilter(filterName);

            if (gridFilter != null)
            {
                IEnumerable <GridFilterWhereModel> filterWheres = GetGridFilterWheres(gridFilter.GridFilter_Key);
                if (filterWheres.Count() > 0)
                {
                    return(Json(filterName + " exists and has data, do you want to overwrite?", JsonRequestBehavior.AllowGet));
                }
                else
                {
                    return(Json(filterName + " exists, do you want to overwrite?", JsonRequestBehavior.AllowGet));
                }
            }
            else
            {
                SaveReportFilter(filterName);
            }
            return(Json("saved", JsonRequestBehavior.AllowGet));
        }
        public GridAuditoriaModel GetAll(GridFilterModel filtros, string UserName = null, string Entity = null, string Action = null, string Description = null)
        {
            var model = new GridAuditoriaModel
            {
                AuditoriaList = new List <AuditoriaModel>()
            };

            try
            {
                var query = _uow.AuditoriaRepository.All().OrderByDescending(x => x.Date).AsQueryable();

                //Filtros
                if (!String.IsNullOrWhiteSpace(UserName))
                {
                    query = query.Where(x => x.UserName.ToLower().Contains(UserName.ToLower()));
                }
                if (!String.IsNullOrWhiteSpace(Entity))
                {
                    query = query.Where(x => x.Entity.ToLower().Contains(Entity.ToLower()));
                }
                if (!String.IsNullOrWhiteSpace(Action))
                {
                    query = query.Where(x => x.Action.ToLower().Contains(Action.ToLower()));
                }
                if (!String.IsNullOrWhiteSpace(Description))
                {
                    query = query.Where(x => x.Descripcion.ToLower().Contains(Description.ToLower()));
                }
                if (!String.IsNullOrWhiteSpace(filtros.fechaDesde))
                {
                    var      dateSplit      = filtros.fechaDesde.Split(" ")[0].Split("/");
                    DateTime dateFromFilter = new DateTime(int.Parse(dateSplit[2]), int.Parse(dateSplit[1]), int.Parse(dateSplit[0]), 0, 0, 0);
                    query = query.Where(x => x.Date >= dateFromFilter);
                }
                if (!String.IsNullOrWhiteSpace(filtros.fechaHasta))
                {
                    var      dateSplit    = filtros.fechaHasta.Split(" ")[0].Split("/");
                    DateTime dateToFilter = new DateTime(int.Parse(dateSplit[2]), int.Parse(dateSplit[1]), int.Parse(dateSplit[0]), 23, 59, 0);
                    query = query.Where(x => x.Date <= dateToFilter);
                }
                if (!String.IsNullOrWhiteSpace(Action))
                {
                    query = query.Where(x => x.Action.ToLower().Contains(Action.ToLower()));
                }
                //-----

                var totalRows = query.Count();
                query           = query.Skip((filtros.page - 1 ?? 0) * (filtros.rows ?? filtros.rowPerPages)).Take(filtros.rows ?? filtros.rowPerPages);
                model.TotalRows = totalRows;


                var listado = query.OrderByDescending(x => x.Date)

                              .Select(x => new AuditoriaModel()
                {
                    AuditoriaId   = x.AuditoriaId,
                    TransactionId = x.TransactionId,
                    Fecha         = x.Date,
                    UserName      = x.UserName,
                    Entity        = x.Entity,
                    EntityId      = x.EntityId,
                    Action        = x.Action,
                    Descripcion   = x.Descripcion
                }).OrderByDescending(x => x.Fecha).ToList();

                model.AuditoriaList = listado;
                return(model);
            }
            catch (Exception ex)
            {
                _logger.LogErrorException(ex, "Ocurrió un problema al intentar obtener lista completa de Auditoría");
                return(new GridAuditoriaModel());
            }
        }