public VegaFlag GetFlag(int flagId)
{
VegaFlag flag = null;
if (GetFlagQuery == null)
{
GetFlagQuery = BuildGetFlagQuery();
}
using (NpgsqlCommand cmd = new NpgsqlCommand(GetFlagQuery, Connection, Transaction))
{
cmd.Parameters.Add(new NpgsqlParameter("VegaFlagId", flagId));
using (NpgsqlDataReader reader = cmd.ExecuteReader())
{
if (!reader.Read())
{
return(null);
}
flag = new VegaFlag
{
Id = reader.GetInt32(0),
Desc = reader.GetString(1)
};
}
}
return(flag);
}
public ICollection <VegaFlag> GetFlags()
{
List <VegaFlag> flags = new List <VegaFlag>();
if (GetFlagsQuery == null)
{
GetFlagsQuery = BuildGetFlagsQuery();
}
using (NpgsqlCommand cmd = new NpgsqlCommand(GetFlagsQuery, Connection, Transaction))
using (NpgsqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
VegaFlag flag = new VegaFlag
{
Id = reader.GetInt32(0),
Desc = reader.GetString(1)
};
flags.Add(flag);
}
}
return(flags);
}
