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