public DataTable SearchCount(aspnet_RolesEntityFilter EntityFilter) { DbCommand storedProcCommand = this.DataBase.GetStoredProcCommand("aspnet_Roles_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, "OpeApplicationId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeApplicationId)); this.DataBase.AddInParameter(storedProcCommand, "ApplicationId", DbType.Guid, (object)EntityFilter.ApplicationId); this.DataBase.AddInParameter(storedProcCommand, "OpeRoleId", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeRoleId)); this.DataBase.AddInParameter(storedProcCommand, "RoleId", DbType.Guid, (object)EntityFilter.RoleId); this.DataBase.AddInParameter(storedProcCommand, "OpeRoleName", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeRoleName)); this.DataBase.AddInParameter(storedProcCommand, "RoleName", DbType.String, (object)EntityFilter.RoleName); this.DataBase.AddInParameter(storedProcCommand, "OpeLoweredRoleName", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeLoweredRoleName)); this.DataBase.AddInParameter(storedProcCommand, "LoweredRoleName", DbType.String, (object)EntityFilter.LoweredRoleName); this.DataBase.AddInParameter(storedProcCommand, "OpeDescription", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeDescription)); this.DataBase.AddInParameter(storedProcCommand, "Description", DbType.String, (object)EntityFilter.Description); this.DataBase.AddInParameter(storedProcCommand, "OpeLongDescription", DbType.String, (object)ConvertirOperadores.ConvertirOperador(EntityFilter.OpeLongDescription)); this.DataBase.AddInParameter(storedProcCommand, "LongDescription", DbType.AnsiString, (object)EntityFilter.LongDescription); return(this.DataBase.ExecuteDataSet(storedProcCommand).Tables[0]); } } catch (SqlException ex) { throw ex; } catch (Exception ex) { throw ex; } }
public aspnet_RolesEntityInfo.aspnet_RolesEntityInfoList Search(aspnet_RolesEntityFilter EntityFilter, bool NoUtilizar) { try { return(this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter))); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public DataTable SearchCount(aspnet_RolesEntityFilter EntityFilter) { try { return(this.CreateDataAccess().SearchCount(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }
public void Search(aspnet_RolesEntityFilter EntityFilter, out aspnet_RolesEntityInfo.aspnet_RolesEntityInfoList listaAGenerar) { try { listaAGenerar = this.DataTableToListOfEntityInfo(this.CreateDataAccess().Search(EntityFilter)); } catch (Exception ex) { Helpers.Logger.Logger.LogExceptionStatic(ex); throw ex; } }