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