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; } }