/// <summary> /// Get all railway companies. /// </summary> /// <returns>The requested list filled with information.</returns> public List <SwitchboardPanel> GetAll() { string sql = string.Empty; SwitchboardPanel admin; List <SwitchboardPanel> admins = new List <SwitchboardPanel>(); Logger.LogDebug(this, "[CLASS].GetAll()"); try { Connect(); sql = @"SELECT " + SwitchboardPanelManager.SQL_FIELDS_SELECT + @" FROM " + SwitchboardPanelManager.SQL_TABLE + @" ORDER BY name"; using (SQLiteDataReader reader = ExecuteReader(sql)) { while (reader.Read()) { admin = SwitchboardPanelManager.ReadEntityRecord(reader); if (admin != null) { admins.Add(admin); } } } return(admins); } catch (Exception ex) { Logger.LogError(this, ex); throw; } finally { Disconnect(); } }
/// <summary> /// Gets a panel by its name. /// </summary> /// <param name="name">The panel's name.</param> /// <returns>The requested instance of <see cref="SwitchboardPanel"/>.</returns> public SwitchboardPanel GetByName(string name) { string sql = string.Empty; SwitchboardPanel item = null; Logger.LogDebug(this, "[CLASS].GetByName({0})", name); try { Connect(); sql = @"SELECT " + SwitchboardPanelManager.SQL_FIELDS_SELECT + @" FROM " + SwitchboardPanelManager.SQL_TABLE + @" WHERE LCase(name) = @name"; SetParameter("name", name); using (SQLiteDataReader reader = ExecuteReader(sql)) { if (reader.Read()) { item = SwitchboardPanelManager.ReadEntityRecord(reader); } } return(item); } catch (Exception ex) { Logger.LogError(this, ex); throw; } finally { Disconnect(); } }