public static List<SymbolModel> GetAllSymbols()
{
var symbolsList = new List<SymbolModel>();
const string sql = "COMMIT; SELECT * FROM " + TblSymbols;
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);
}
public static List<SymbolModel> GetSymbolsForUser(int userId)
{
var symbolsList = new List<SymbolModel>();
MySqlDataReader reader=null;
string sql = "SELECT * FROM " + TblSymbolsForUsers
+ " LEFT JOIN " + TblSymbols
+ " ON " + TblSymbolsForUsers + ".SymbolID = "
+ TblSymbols + ".ID" + " WHERE " + TblSymbolsForUsers + ".UserID = '" + userId + "' AND " + TblSymbolsForUsers + ".TNorDN = false ; COMMIT;";
try
{
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();
}
}
finally
{
if (reader != null) reader.Close();
}
return symbolsList;
}
public static List<SymbolModel> GetSymbolsInGroup(int groupId)
{
var symbolsList = new List<SymbolModel>();
string sql = "SELECT * FROM " + TblSymbolsInGroups + " WHERE GroupID = '" + groupId + "' ; COMMIT;";
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;
}
private void ui_buttonX_join_Click(object sender, EventArgs e)
{
var symbCount = ui_listBox_symbols.SelectedItems.Count;
var groupCount = ui_listBox_groups.SelectedItems.Count;
if (symbCount==0)
{
ToastNotification.Show(this, "Please, select symbols");
return;
}
if(groupCount==0)
{
ToastNotification.Show(this, "Please, select groups");
return;
}
for (int i = 0; i < symbCount; i++)
{
var currSmb = ui_listBox_symbols.SelectedItems[i].ToString();
var currSmbId = _symbols.Find(a => a.SymbolName == currSmb).SymbolId;
for (int j = 0; j < groupCount; j++)
{
var currGroup = ui_listBox_groups.SelectedItems[j].ToString();
var currGroupId = _groups.Find(a => a.GroupName == currGroup).GroupId;
var currGroupSymbols = DataNetClientDataManager.GetSymbolsInGroup(currGroupId);
if (!currGroupSymbols.Exists(a => a.SymbolName == currSmb))
{
var sModel = new SymbolModel { SymbolId = currSmbId, SymbolName = currSmb };
DataNetClientDataManager.AddSymbolIntoGroup(currGroupId, sModel);
}
}
ui_listBox_symbolsInGroup.Items.Clear();
var currentGroup = _groups.Find(a => a.GroupName == ui_listBox_groups.SelectedItems[0].ToString());
if (ui_listBox_groups.SelectedItems.Count == 1 && currentGroup.Privilege != GroupPrivilege.UseGroup)
{
var symbolsForCurrGroup = DataNetClientDataManager.GetSymbolsInGroup(currentGroup.GroupId);
foreach (var symbolModel in symbolsForCurrGroup)
{
ui_listBox_symbolsInGroup.Items.Add(symbolModel.SymbolName);
}
}
}
ToastNotification.Show(this, "Joined");
OnUpdateGroupsEvent();
}