public DataTable SearchCount(TipoDeDietaEntityFilter EntityFilter) { DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("TipoDeDieta_SearchCount"); 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, "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; } }
public DataTable SearchCount(TipoDeDietaEntityFilter EntityFilter) { try { return(this.CreateDataAccess().SearchCount(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public TipoDeDietaEntityInfo.TipoDeDietaEntityInfoList Search(TipoDeDietaEntityFilter EntityFilter, bool NoUtilizar) { try { return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter))); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public void Search(TipoDeDietaEntityFilter EntityFilter, out TipoDeDietaEntityInfo.TipoDeDietaEntityInfoList listaAGenerar) { try { listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }