public static List<SymbolModel> GetSymbolsInGroup(int groupId) { var symbolsList = new List<SymbolModel>(); string sql = "SELECT * FROM " + TblSymbolsInGroups + " WHERE GroupID = '" + groupId + "' ; COMMIT;"; lock (LockReader) { var reader = GetReader(sql); if (reader != null) { while (reader.Read()) { var symbol = new SymbolModel { SymbolId = reader.GetInt32(2), SymbolName = reader.GetString(3) }; symbolsList.Add(symbol); } reader.Close(); } } return symbolsList; }
public static List<SymbolModel> GetSymbols() { var symbolsList = new List<SymbolModel>(); const string sql = "SELECT * FROM " + TblSymbols; lock (LockReader) { MySqlDataReader reader = GetReader(sql); if (reader != null) { while (reader.Read()) { var symbol = new SymbolModel { SymbolId = reader.GetInt32(0), SymbolName = reader.GetString(1) }; symbolsList.Add(symbol); } reader.Close(); } } return symbolsList; }
public static List<SymbolModel> GetSymbolsForUser(int userId, bool tnOrDN) { var symbolsList = new List<SymbolModel>(); string sql = "SELECT * FROM " + TblSymbolsForUsers + " LEFT JOIN " + TblSymbols + " ON " + TblSymbolsForUsers + ".SymbolID = " + TblSymbols + ".ID" + " WHERE " + TblSymbolsForUsers + ".UserID = '" + userId + "' AND TNorDN = " + tnOrDN + "; COMMIT;"; lock (LockReader) { MySqlDataReader reader = GetReader(sql); if (reader != null) { while (reader.Read()) { var symbol = new SymbolModel { SymbolId = reader.GetInt32(4), SymbolName = reader.GetString(5) }; symbolsList.Add(symbol); } reader.Close(); } } return symbolsList; }
public static bool AddSymbolIntoGroup(int groupId, SymbolModel symbol) { var sql = "INSERT IGNORE INTO " + TblSymbolsInGroups + " (`GroupID`, `SymbolID`, `SymbolName`)" + "VALUES('" + groupId + "'," + " '" + symbol.SymbolId + "'," + " '" + symbol.SymbolName + "');COMMIT;"; return DoSql(sql); }