public static List <GroupZone> GetZones(int group)
{
var listGroupZone = new List <GroupZone>();
using (var con = new OdbcConnection(ConnString))
using (var cmd = new OdbcCommand(SelectCmd, con))
{
cmd.Parameters.AddWithValue("GroupID", group);
try
{
con.Open();
using (var db = cmd.ExecuteReader())
{
while (db.Read())
{
var zone = new GroupZone(Convert.ToInt32(db["GroupID"]),
Convert.ToInt32(db["ZoneID"]),
db["Location"].ToString());
listGroupZone.Add(zone);
}
}
}
catch
{
}
}
return(listGroupZone);
}
public static void InsertZone(GroupZone zone)
{
using (var con = new OdbcConnection(ConnString))
using (var cmd = new OdbcCommand(InsertCmd, con))
{
cmd.Parameters.AddWithValue("GroupID", zone.GroupID);
cmd.Parameters.AddWithValue("ZoneID", zone.ZoneID);
try
{
con.Open();
cmd.ExecuteNonQuery();
}
catch
{
}
}
}
