public DataTable SearchCountWithPagination(AlimentoNutrienteEntityPaged EntityPaged, AlimentoNutrienteEntityFilter EntityFilter)
{
DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("AlimentoNutriente_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, "OpeNutrienteId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNutrienteId));
this.DataBase.AddInParameter(storedProcCommand, "NutrienteId", DbType.Int32, (object)EntityFilter.NutrienteId);
this.DataBase.AddInParameter(storedProcCommand, "OpeCantidad", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeCantidad));
this.DataBase.AddInParameter(storedProcCommand, "Cantidad", DbType.Decimal, (object)EntityFilter.Cantidad);
this.DataBase.AddInParameter(storedProcCommand, "OpeFntID", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeFntID));
this.DataBase.AddInParameter(storedProcCommand, "FntID", DbType.AnsiString, (object)EntityFilter.FntID);
return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable Search(vAlimentoNutrienteParaAgregarEntityFilter EntityFilter)
{
DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("vAlimentoNutrienteParaAgregar_Search");
try
{
using (storedProcCommand)
{
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, "OpeNutrienteId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNutrienteId));
this.DataBase.AddInParameter(storedProcCommand, "NutrienteId", DbType.Int32, (object)EntityFilter.NutrienteId);
this.DataBase.AddInParameter(storedProcCommand, "OpeNutrienteNombre", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNutrienteNombre));
this.DataBase.AddInParameter(storedProcCommand, "NutrienteNombre", DbType.AnsiString, (object)EntityFilter.NutrienteNombre);
this.DataBase.AddInParameter(storedProcCommand, "OpeAlimentoNutrienteCantidad", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeAlimentoNutrienteCantidad));
this.DataBase.AddInParameter(storedProcCommand, "AlimentoNutrienteCantidad", DbType.Int32, (object)EntityFilter.AlimentoNutrienteCantidad);
this.DataBase.AddInParameter(storedProcCommand, "OpeNutrienteUDMId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNutrienteUDMId));
this.DataBase.AddInParameter(storedProcCommand, "NutrienteUDMId", DbType.AnsiString, (object)EntityFilter.NutrienteUDMId);
return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable SearchCountWithPagination(TipoDeDietaEntityPaged EntityPaged, TipoDeDietaEntityFilter EntityFilter)
{
DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("TipoDeDieta_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, "OpeTipoDeDietaId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeDietaId));
this.DataBase.AddInParameter(storedProcCommand, "TipoDeDietaId", DbType.Int32, (object)EntityFilter.TipoDeDietaId);
this.DataBase.AddInParameter(storedProcCommand, "OpeTipoDeDieta", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeDieta));
this.DataBase.AddInParameter(storedProcCommand, "TipoDeDieta", DbType.AnsiString, (object)EntityFilter.TipoDeDieta);
return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
