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