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