public DataTable SearchCountWithPagination(vAlimentosEntityPaged EntityPaged, vAlimentosEntityFilter EntityFilter)
{
try
{
return(this.CreateDataAccess().SearchCountWithPagination(EntityPaged, EntityFilter));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
public DataTable SearchCountWithPagination(vAlimentosEntityPaged EntityPaged, vAlimentosEntityFilter EntityFilter)
{
DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("vAlimentos_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, "OpeAlimentoId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeAlimentoId));
this.DataBase.AddInParameter(storedProcCommand, "AlimentoId", DbType.Int32, (object)EntityFilter.AlimentoId);
this.DataBase.AddInParameter(storedProcCommand, "OpeCodigo", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeCodigo));
this.DataBase.AddInParameter(storedProcCommand, "Codigo", DbType.AnsiString, (object)EntityFilter.Codigo);
this.DataBase.AddInParameter(storedProcCommand, "OpeNombre", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNombre));
this.DataBase.AddInParameter(storedProcCommand, "Nombre", DbType.AnsiString, (object)EntityFilter.Nombre);
this.DataBase.AddInParameter(storedProcCommand, "OpeTipoDeAlimentoId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeAlimentoId));
this.DataBase.AddInParameter(storedProcCommand, "TipoDeAlimentoId", DbType.Int32, (object)EntityFilter.TipoDeAlimentoId);
this.DataBase.AddInParameter(storedProcCommand, "OpeTipoDeAlimento", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeAlimento));
this.DataBase.AddInParameter(storedProcCommand, "TipoDeAlimento", DbType.AnsiString, (object)EntityFilter.TipoDeAlimento);
this.DataBase.AddInParameter(storedProcCommand, "OpeEstacional", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEstacional));
this.DataBase.AddInParameter(storedProcCommand, "Estacional", DbType.AnsiString, (object)EntityFilter.Estacional);
this.DataBase.AddInParameter(storedProcCommand, "OpePequeña", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpePequeña));
this.DataBase.AddInParameter(storedProcCommand, "Pequeña", DbType.Decimal, (object)EntityFilter.Pequeña);
this.DataBase.AddInParameter(storedProcCommand, "OpeMediana", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeMediana));
this.DataBase.AddInParameter(storedProcCommand, "Mediana", DbType.Decimal, (object)EntityFilter.Mediana);
this.DataBase.AddInParameter(storedProcCommand, "OpeGrande", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeGrande));
this.DataBase.AddInParameter(storedProcCommand, "Grande", DbType.Decimal, (object)EntityFilter.Grande);
this.DataBase.AddInParameter(storedProcCommand, "OpeEstado", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEstado));
this.DataBase.AddInParameter(storedProcCommand, "Estado", DbType.AnsiString, (object)EntityFilter.Estado);
this.DataBase.AddInParameter(storedProcCommand, "OpeOrdenDeVisualizacion", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeOrdenDeVisualizacion));
this.DataBase.AddInParameter(storedProcCommand, "OrdenDeVisualizacion", DbType.Int32, (object)EntityFilter.OrdenDeVisualizacion);
return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
