public DataTable SearchCountWithPagination(Listado_NutrientesPorEncuestasEntityPaged EntityPaged, Listado_NutrientesPorEncuestasEntityFilter EntityFilter)
{
try
{
return(this.CreateDataAccess().SearchCountWithPagination(EntityPaged, EntityFilter));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
public DataTable SearchCountWithPagination(Listado_NutrientesPorEncuestasEntityPaged EntityPaged, Listado_NutrientesPorEncuestasEntityFilter EntityFilter)
{
DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("Listado_NutrientesPorEncuestas_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, "OpeEncuestaNro", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEncuestaNro));
this.DataBase.AddInParameter(storedProcCommand, "EncuestaNro", DbType.Int32, (object)EntityFilter.EncuestaNro);
this.DataBase.AddInParameter(storedProcCommand, "OpeUserId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeUserId));
this.DataBase.AddInParameter(storedProcCommand, "UserId", DbType.Guid, (object)EntityFilter.UserId);
this.DataBase.AddInParameter(storedProcCommand, "OpeApellido", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeApellido));
this.DataBase.AddInParameter(storedProcCommand, "Apellido", DbType.AnsiString, (object)EntityFilter.Apellido);
this.DataBase.AddInParameter(storedProcCommand, "OpeNombres", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNombres));
this.DataBase.AddInParameter(storedProcCommand, "Nombres", DbType.AnsiString, (object)EntityFilter.Nombres);
this.DataBase.AddInParameter(storedProcCommand, "OpeEmpresa", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEmpresa));
this.DataBase.AddInParameter(storedProcCommand, "Empresa", DbType.AnsiString, (object)EntityFilter.Empresa);
this.DataBase.AddInParameter(storedProcCommand, "OpeHistoriaClinica", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeHistoriaClinica));
this.DataBase.AddInParameter(storedProcCommand, "HistoriaClinica", DbType.AnsiString, (object)EntityFilter.HistoriaClinica);
this.DataBase.AddInParameter(storedProcCommand, "OpeFecha", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeFecha));
if (EntityFilter.FechaDesde.HasValue)
{
DateTime dateTime = DateTime.Parse(EntityFilter.FechaDesde.ToString());
this.DataBase.AddInParameter(storedProcCommand, "FechaDesde", DbType.String, (object)dateTime.ToString("yyyyMMdd' 'HH':'mm':'ss"));
}
else
{
this.DataBase.AddInParameter(storedProcCommand, "FechaDesde", DbType.String, (object)DBNull.Value);
}
if (EntityFilter.FechaHasta.HasValue)
{
DateTime dateTime = DateTime.Parse(EntityFilter.FechaHasta.ToString());
this.DataBase.AddInParameter(storedProcCommand, "FechaHasta", DbType.String, (object)dateTime.ToString("yyyyMMdd' 'HH':'mm':'ss"));
}
else
{
this.DataBase.AddInParameter(storedProcCommand, "FechaHasta", DbType.String, (object)DBNull.Value);
}
this.DataBase.AddInParameter(storedProcCommand, "OpeSexo", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeSexo));
this.DataBase.AddInParameter(storedProcCommand, "Sexo", DbType.AnsiString, (object)EntityFilter.Sexo);
this.DataBase.AddInParameter(storedProcCommand, "OpeEdad", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEdad));
this.DataBase.AddInParameter(storedProcCommand, "Edad", DbType.Int16, (object)EntityFilter.Edad);
this.DataBase.AddInParameter(storedProcCommand, "OpePeso", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpePeso));
this.DataBase.AddInParameter(storedProcCommand, "Peso", DbType.Decimal, (object)EntityFilter.Peso);
this.DataBase.AddInParameter(storedProcCommand, "OpeTalla", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTalla));
this.DataBase.AddInParameter(storedProcCommand, "Talla", DbType.Decimal, (object)EntityFilter.Talla);
this.DataBase.AddInParameter(storedProcCommand, "OpeIMC", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeIMC));
this.DataBase.AddInParameter(storedProcCommand, "IMC", DbType.Decimal, (object)EntityFilter.IMC);
this.DataBase.AddInParameter(storedProcCommand, "OpeTipoDeDieta", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeDieta));
this.DataBase.AddInParameter(storedProcCommand, "TipoDeDieta", DbType.AnsiString, (object)EntityFilter.TipoDeDieta);
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, "OpeCantidadNutriente", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeCantidadNutriente));
this.DataBase.AddInParameter(storedProcCommand, "CantidadNutriente", DbType.Decimal, (object)EntityFilter.CantidadNutriente);
return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
