public DataTable SearchCount(vAlimentosDeEncuestasEntityFilter EntityFilter)
{
try
{
return(this.CreateDataAccess().SearchCount(EntityFilter));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
public void Search(vAlimentosDeEncuestasEntityFilter EntityFilter, out vAlimentosDeEncuestasEntityInfo.vAlimentosDeEncuestasEntityInfoList listaAGenerar)
{
try
{
listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
public DataTable Search(vAlimentosDeEncuestasEntityFilter EntityFilter)
{
DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("vAlimentosDeEncuestas_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, "OpeOrden1", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeOrden1));
this.DataBase.AddInParameter(storedProcCommand, "Orden1", DbType.Int32, (object)EntityFilter.Orden1);
this.DataBase.AddInParameter(storedProcCommand, "OpeOrden2", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeOrden2));
this.DataBase.AddInParameter(storedProcCommand, "Orden2", DbType.Int32, (object)EntityFilter.Orden2);
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, "OpeAlimentoCodigo", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeAlimentoCodigo));
this.DataBase.AddInParameter(storedProcCommand, "AlimentoCodigo", DbType.AnsiString, (object)EntityFilter.AlimentoCodigo);
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, "OpeNunca", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeNunca));
this.DataBase.AddInParameter(storedProcCommand, "Nunca", DbType.Int32, (object)EntityFilter.Nunca);
this.DataBase.AddInParameter(storedProcCommand, "OpeVM", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeVM));
this.DataBase.AddInParameter(storedProcCommand, "VM", DbType.Int32, (object)EntityFilter.VM);
this.DataBase.AddInParameter(storedProcCommand, "OpeVS", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeVS));
this.DataBase.AddInParameter(storedProcCommand, "VS", DbType.Int32, (object)EntityFilter.VS);
this.DataBase.AddInParameter(storedProcCommand, "OpeVD", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeVD));
this.DataBase.AddInParameter(storedProcCommand, "VD", DbType.Int32, (object)EntityFilter.VD);
this.DataBase.AddInParameter(storedProcCommand, "OpeP", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeP));
this.DataBase.AddInParameter(storedProcCommand, "P", DbType.Int32, (object)EntityFilter.P);
this.DataBase.AddInParameter(storedProcCommand, "OpeM", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeM));
this.DataBase.AddInParameter(storedProcCommand, "M", DbType.Int32, (object)EntityFilter.M);
this.DataBase.AddInParameter(storedProcCommand, "OpeG", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeG));
this.DataBase.AddInParameter(storedProcCommand, "G", DbType.Int32, (object)EntityFilter.G);
return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]);
}
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public vAlimentosDeEncuestasEntityInfo.vAlimentosDeEncuestasEntityInfoList Search(vAlimentosDeEncuestasEntityFilter EntityFilter, bool NoUtilizar)
{
try
{
return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
