public DataTable SearchCountWithPagination(FuenteEntityPaged EntityPaged, FuenteEntityFilter EntityFilter) { DbCommand storedProcCommand = this.Database.GetStoredProcCommand("Fuente_SearchCountWithPagination"); try { using (storedProcCommand) { this.Database.AddInParameter(storedProcCommand, "PageSize", DbType.Int32, (object)EntityPaged.pageSize); this.Database.AddInParameter(storedProcCommand, "PageReturn", DbType.Int32, (object)EntityPaged.pageReturn); this.Database.AddInParameter(storedProcCommand, "WhereExtendido", DbType.String, (object)EntityFilter.WhereExtendido); this.Database.AddInParameter(storedProcCommand, "OrdenDeRegistros", DbType.String, (object)EntityFilter.OrderBy); this.Database.AddInParameter(storedProcCommand, "OpeFntID", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeFntID)); this.Database.AddInParameter(storedProcCommand, "FntID", DbType.AnsiString, (object)EntityFilter.FntID); this.Database.AddInParameter(storedProcCommand, "OpeNombre", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNombre)); this.Database.AddInParameter(storedProcCommand, "Nombre", DbType.AnsiString, (object)EntityFilter.Nombre); return(this.Database.ExecuteDataSet(storedProcCommand).Tables[0]); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public DataTable SearchCountWithPagination(FuenteEntityPaged EntityPaged, FuenteEntityFilter EntityFilter) { try { return(this.CreateDataAccess().SearchCountWithPagination(EntityPaged, EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public FuenteEntityInfo.FuenteEntityInfoList Search(FuenteEntityFilter EntityFilter, bool NoUtilizar) { try { return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter))); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public void Search(FuenteEntityFilter EntityFilter, out FuenteEntityInfo.FuenteEntityInfoList listaAGenerar) { try { listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }