public DataTable SearchCount(vAlimentosEntityFilter EntityFilter) { try { return(this.CreateDataAccess().SearchCount(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public void Search(vAlimentosEntityFilter EntityFilter, out vAlimentosEntityInfo.vAlimentosEntityInfoList listaAGenerar) { try { listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public vAlimentosEntityInfo.vAlimentosEntityInfoList Search(vAlimentosEntityFilter EntityFilter, bool NoUtilizar) { try { return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter))); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public DataTable SearchWithPagination(vAlimentosEntityPaged EntityPaged, vAlimentosEntityFilter EntityFilter) { DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("vAlimentos_SearchWithPagination"); 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, "OpeCodigo", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeCodigo)); this.DataBase.AddInParameter(storedProcCommand, "Codigo", DbType.AnsiString, (object)EntityFilter.Codigo); 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, "OpeTipoDeAlimentoId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeTipoDeAlimentoId)); this.DataBase.AddInParameter(storedProcCommand, "TipoDeAlimentoId", DbType.Int32, (object)EntityFilter.TipoDeAlimentoId); 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, "OpeEstacional", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEstacional)); this.DataBase.AddInParameter(storedProcCommand, "Estacional", DbType.AnsiString, (object)EntityFilter.Estacional); this.DataBase.AddInParameter(storedProcCommand, "OpePequeña", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpePequeña)); this.DataBase.AddInParameter(storedProcCommand, "Pequeña", DbType.Decimal, (object)EntityFilter.Pequeña); this.DataBase.AddInParameter(storedProcCommand, "OpeMediana", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeMediana)); this.DataBase.AddInParameter(storedProcCommand, "Mediana", DbType.Decimal, (object)EntityFilter.Mediana); this.DataBase.AddInParameter(storedProcCommand, "OpeGrande", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeGrande)); this.DataBase.AddInParameter(storedProcCommand, "Grande", DbType.Decimal, (object)EntityFilter.Grande); this.DataBase.AddInParameter(storedProcCommand, "OpeEstado", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeEstado)); this.DataBase.AddInParameter(storedProcCommand, "Estado", DbType.AnsiString, (object)EntityFilter.Estado); this.DataBase.AddInParameter(storedProcCommand, "OpeOrdenDeVisualizacion", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeOrdenDeVisualizacion)); this.DataBase.AddInParameter(storedProcCommand, "OrdenDeVisualizacion", DbType.Int32, (object)EntityFilter.OrdenDeVisualizacion); return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } }