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 SearchCount(vAlimentoNutrienteParaAgregarEntityFilter EntityFilter)
{
try
{
return(this.CreateDataAccess().SearchCount(EntityFilter));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
public void Search(vAlimentoNutrienteParaAgregarEntityFilter EntityFilter, out vAlimentoNutrienteParaAgregarEntityInfo.vAlimentoNutrienteParaAgregarEntityInfoList listaAGenerar)
{
try
{
listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
private void BindearAddNutrientes()
{
vAlimentoNutrienteParaAgregarBus bus = new vAlimentoNutrienteParaAgregarBus();
vAlimentoNutrienteParaAgregarEntityFilter filter = new vAlimentoNutrienteParaAgregarEntityFilter();
filter.Clear();
filter.OrderBy = "NutrienteNombre";
filter.OpeAlimentoId = Helpers.Operators.Operadores_Int.Igual;
filter.AlimentoId = int.Parse("0" + cboAlimentos.SelectedValue);
if (!string.IsNullOrEmpty(txtFiltro.Text))
{
filter.OpeNutrienteNombre = Helpers.Operators.Operadores_VarChar.QueComienceCon;
filter.NutrienteNombre = txtFiltro.Text.Trim();
}
DataTable dtAddNutrientes = bus.Search(filter);
lvAddNutrientes.DataSource = dtAddNutrientes;
lvAddNutrientes.DataBind();
divAddNutrientes.Visible = true;
btnAgregarNutrientes.Visible = true;
divBtnAddNutrientes.Visible = true;
}
public vAlimentoNutrienteParaAgregarEntityInfo.vAlimentoNutrienteParaAgregarEntityInfoList Search(vAlimentoNutrienteParaAgregarEntityFilter EntityFilter, bool NoUtilizar)
{
try
{
return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)));
}
catch (Exception ex)
{
Helpers.Logger.Logger.LogExceptionStatic(ex);
throw ex;
}
}
