public static IEnumerable <AgentInfo> GetAllAgentInfos(xDatabaseAccessorFactory databaseAccessorFactory) { using (DbConnection connection = databaseAccessorFactory.CreateConnection()) { using (var cmd = connection.CreateCommand()) { cmd.CommandText = GetAllAgentInfosCommandText; using (var reader = cmd.ExecuteReader()) { int pos_Id = reader.GetOrdinal("Id"); int pos_Name = reader.GetOrdinal("Name"); int pos_IsActive = reader.GetOrdinal("IsActive"); List <AgentInfo> result = new List <AgentInfo>(); while (reader.Read()) { var row = new AgentInfo(); object v_0 = reader.GetValue(0); row.Id = reader.GetInt32(pos_Id); row.Name = reader.GetString(pos_Name); row.IsActive = reader.GetBoolean(pos_IsActive); result.Add(row); } return(result); } } } }
public static string GetAgentsDescriptionById(xDatabaseAccessorFactory databaseAccessorFactory, int id) { using (DbConnection connection = databaseAccessorFactory.CreateConnection()) { using (var cmd = connection.CreateCommand()) { cmd.CommandText = GetAgentsDescriptionByIdCommandText; var prm_id = cmd.CreateParameter(); prm_id.ParameterName = "id"; prm_id.DbType = DbType.Int32; prm_id.Value = id; cmd.Parameters.Add(prm_id); using (var reader = cmd.ExecuteReader()) { List <string> result = new List <string>(); while (reader.Read()) { result.Add(reader.GetString(0)); } return(result.FirstOrDefault()); } } } }
public static IEnumerable <int> GetAllAgentIds(xDatabaseAccessorFactory databaseAccessorFactory) { using (DbConnection connection = databaseAccessorFactory.CreateConnection()) { using (var cmd = connection.CreateCommand()) { cmd.CommandText = GetAllAgentIdsCommandText; using (var reader = cmd.ExecuteReader()) { List <int> result = new List <int>(); while (reader.Read()) { result.Add(reader.GetInt32(0)); } return(result); } } } }