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> 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 List<SymbolModel> GetSymbols() { var symbolsList = new List<SymbolModel>(); Commit(); 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 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); }
private void AddUserAndActivate(CollectorClient user, SymbolModel smb) { _adminService.TickNetSymbolAccesRank[smb.SymbolName].Add(user); try { user.TickNetProxy.ActivateClient(smb.SymbolName); } catch (Exception ex) { Console.WriteLine(ex); ActivateNextClient(smb); } DataManager.AddNewLog(new LogModel { Application = "TickNet", Date = DateTime.Now, Status = 3, Symbol = smb.SymbolName, UserId = _users.Find(oo => oo.Name == user.UserName).Id, LogId = 2, MsgType = 2 }); AddSymbolToBusySymbols(smb); }
private void AddSymbolToBusySymbols(SymbolModel smb) { var bsm = new BusySymbol { ID = smb.SymbolId, IsTickNet = true }; if (!_busySymbols.Exists(a => a.ID == bsm.ID)) _busySymbols.Add(bsm); else { var fsmb = _busySymbols.Find(o => o.ID == bsm.ID); fsmb.IsTickNet = true; } }