public static List <Object> getRelaysForMap() { List <Object> relays = new List <Object>(); var cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); using (cn) { DataTable questionTable = new DataTable(); DataRowCollection rows; string _sql = @"SELECT station_id, station_isActive, isGateway, region, queueLimit FROM RelayStation"; var cmd = new SqlCommand(_sql, cn); cn.Open(); questionTable.Load(cmd.ExecuteReader()); rows = questionTable.Rows; foreach (DataRow row in rows) { Relay tempRelay = new Relay(); tempRelay.ipAddress = Convert.ToString(row["station_id"]); tempRelay.id = Convert.ToString(row["station_id"]); tempRelay.region = Convert.ToString(row["region"]); tempRelay.isActive = Convert.ToBoolean(row["station_isActive"]); tempRelay.isGateway = Convert.ToBoolean(row["isGateway"]); tempRelay.queueLimit = Convert.ToInt32(row["queueLimit"]); if (tempRelay.id.Equals(PROCESSINGCENTERIP, StringComparison.Ordinal)) { tempRelay.group = PROCESSINGCENTERGROUP; } else { tempRelay.group = RELAYGROUP; } relays.Add(tempRelay); } } return(relays); }
public static void addStore(int weight, string ipAddress, string relayIP, string storeName) { string region = Relay.getRegion(relayIP); var cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString); using (cn) { string _sql = @"INSERT INTO Store (store_id, store_name, region) VALUES(@IPAddress, @StoreName, @Region)"; var cmd = new SqlCommand(_sql, cn); cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar).Value = ipAddress; cmd.Parameters.Add("@StoreName", SqlDbType.VarChar).Value = storeName; cmd.Parameters.Add("@Region", SqlDbType.VarChar).Value = region; cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } Connection.addConnection(weight, ipAddress, relayIP); }