/* ========================== * SWITCHBOXES * ==========================*/ public List <SwitchboxInfo> GetAllSwitchboxes() { // Init list List <SwitchboxInfo> switchboxList = new List <SwitchboxInfo>(); using (SqlConnection connection = new SqlConnection(connectString)) using (SqlCommand cmd = new SqlCommand("SELECT sid, name, num_switches FROM Switchboxes ORDER BY name asc", connection)) { connection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { SwitchboxInfo s = new SwitchboxInfo(); s.sid = reader.GetInt32(reader.GetOrdinal("sid")); s.name = reader.GetString(reader.GetOrdinal("name")); s.numSwitches = reader.GetInt32(reader.GetOrdinal("num_switches")); switchboxList.Add(s); } } } connection.Close(); } // return lsit return(switchboxList); }
public void InsertSwitchbox(SwitchboxInfo newSwitchbox) { using (SqlConnection connection = new SqlConnection(connectString)) using (SqlCommand cmd = new SqlCommand("INSERT INTO Switchboxes (name,num_switches) VALUES(@Name, @NumSwitches)", connection)) { // Add parameters cmd.Parameters.AddWithValue("@Name", newSwitchbox.name); cmd.Parameters.AddWithValue("@NumSwitches", newSwitchbox.numSwitches); // Open connection and insert connection.Open(); cmd.ExecuteNonQuery(); // Disconnect connection.Close(); } }
public void UpdateSwitchbox(SwitchboxInfo updateSwitchbox) { using (SqlConnection connection = new SqlConnection(connectString)) using (SqlCommand cmd = new SqlCommand("UPDATE Switchboxes SET name = @Name, num_switches = @NumSwitches WHERE sid = @Sid", connection)) { // Add parameters cmd.Parameters.AddWithValue("@Sid", updateSwitchbox.sid); cmd.Parameters.AddWithValue("@Name", updateSwitchbox.name); cmd.Parameters.AddWithValue("@NumSwitches", updateSwitchbox.numSwitches); // Open connection and insert connection.Open(); cmd.ExecuteNonQuery(); // Disconnect connection.Close(); } }
public void UpdateSwitchbox(SwitchboxInfo updateSwitchbox) { using (SqlConnection connection = new SqlConnection(connectString)) using (SqlCommand cmd = new SqlCommand("UPDATE Switchboxes SET name = @Name, num_switches = @NumSwitches WHERE sid = @Sid", connection)) { // Add parameters cmd.Parameters.AddWithValue("@Sid", updateSwitchbox.sid); cmd.Parameters.AddWithValue("@Name", updateSwitchbox.name); cmd.Parameters.AddWithValue("@NumSwitches", updateSwitchbox.numSwitches); // Open connection and insert connection.Open(); cmd.ExecuteNonQuery(); // Disconnect connection.Close(); } }
public void InsertSwitchbox(SwitchboxInfo newSwitchbox) { using (SqlConnection connection = new SqlConnection(connectString)) using (SqlCommand cmd = new SqlCommand("INSERT INTO Switchboxes (name,num_switches) VALUES(@Name, @NumSwitches)", connection)) { // Add parameters cmd.Parameters.AddWithValue("@Name", newSwitchbox.name); cmd.Parameters.AddWithValue("@NumSwitches", newSwitchbox.numSwitches); // Open connection and insert connection.Open(); cmd.ExecuteNonQuery(); // Disconnect connection.Close(); } }
/* ========================== * SWITCHBOXES * ==========================*/ public List<SwitchboxInfo> GetAllSwitchboxes() { // Init list List<SwitchboxInfo> switchboxList = new List<SwitchboxInfo>(); using (SqlConnection connection = new SqlConnection(connectString)) using (SqlCommand cmd = new SqlCommand("SELECT sid, name, num_switches FROM Switchboxes ORDER BY name asc", connection)) { connection.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { SwitchboxInfo s = new SwitchboxInfo(); s.sid = reader.GetInt32(reader.GetOrdinal("sid")); s.name = reader.GetString(reader.GetOrdinal("name")); s.numSwitches = reader.GetInt32(reader.GetOrdinal("num_switches")); switchboxList.Add(s); } } } connection.Close(); } // return lsit return switchboxList; }