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 List<SymbolModel> GetSymbolsInGroup(int groupId)
{
var symbolsList = new List<SymbolModel>();
string sql = "SELECT * FROM " + TblSymbolsInGroups + " WHERE GroupID = '" + groupId + "' ORDER BY SymbolName " + (SortingModeIsAsc ? "ASC" : "DESC");
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 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, bool isTickNet)
{
var symbolsList = new List<SymbolModel>();
string sql = "SELECT * FROM " + TblSymbolsForUsers
+ " LEFT JOIN " + TblSymbols
+ " ON " + TblSymbolsForUsers + ".SymbolID = "
+ TblSymbols + ".ID" + " WHERE " + TblSymbolsForUsers + ".UserID = '" + userId + "' AND " + TblSymbolsForUsers + ".TNorDN = " + (isTickNet ? "true" : "false") + " ORDER BY SymbolName " + (SortingModeIsAsc ? "ASC" : "DESC");
MySqlDataReader reader = GetReader(sql);
if (reader != null)
{
while (reader.Read())
{
try
{
var symbol = new SymbolModel { SymbolId = reader.GetInt32(4), SymbolName = reader.GetString(5) };
symbolsList.Add(symbol);
}
catch (Exception ex)
{
Console.WriteLine("Exception.DatabaseManager.GetSymbolsForUser Msg: " + ex.Message);
}
}
reader.Close();
}
return symbolsList;
}
public static List<SymbolModel> GetAllSymbols()
{
var symbolsList = new List<SymbolModel>();
Commit();
string sql = "SELECT * FROM " + TblSymbols + " ORDER BY SymbolName " + (SortingModeIsAsc ? "ASC" : "DESC");
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;
}
private void ui_buttonX_join_Click(object sender, EventArgs e)
{
var message = "";
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 currGroupName = ui_listBox_groups.SelectedItems[j].ToString();
var currGrp = _groups.Find(a => a.GroupName == currGroupName);
var currGroupId = currGrp.GroupId;
var currGroupSymbols = ClientDatabaseManager.GetSymbolsInGroup(currGroupId);
if (!currGroupSymbols.Exists(a => a.SymbolName == currSmb))
{
var sModel = new SymbolModel { SymbolId = currSmbId, SymbolName = currSmb };
if (GetCntTypeOfSymbol(currSmb) == currGrp.CntType)
ClientDatabaseManager.AddSymbolIntoGroup(currGroupId, sModel);
else
message += " Symbol: '" + currSmb + "' can't be added to '" + currGroupName + "' group";
}
}
/*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 = DatabaseManager.GetSymbolsInGroup(currentGroup.GroupId);
foreach (var symbolModel in symbolsForCurrGroup)
{
ui_listBox_symbolsInGroup.Items.Add(symbolModel.SymbolName);
}
}*/
}
ToastNotification.Show(this, "Joined.");
if (!String.IsNullOrEmpty(message))
ToastNotification.Show(this, message);
OnUpdateGroupsEvent();
}
private void buttonAddToGroup_Click(object sender, EventArgs e)
{
var message = "";
var symbCount = listBoxSymbols.SelectedItems.Count;
var groupCount = listViewGroups.SelectedItems.Count;
if (!_isSingleGroup)
{
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 = listBoxSymbols.SelectedItems[i].ToString();
var currSmbId = _symbols.Find(a => a.SymbolName == currSmb).SymbolId;
for (int j = 0; j < groupCount; j++)
{
var currGroupName = listViewGroups.SelectedItems[j].SubItems[0].Text;
var currGrp = _groups.Find(a => a.GroupName == currGroupName);
var currGroupId = currGrp.GroupId;
var currGroupSymbols = ClientDatabaseManager.GetSymbolsInGroup(currGroupId);
if (!currGroupSymbols.Exists(a => a.SymbolName == currSmb))
{
var sModel = new SymbolModel { SymbolId = currSmbId, SymbolName = currSmb };
if (GetCntTypeOfSymbol(currSmb) == currGrp.CntType)
{
ClientDatabaseManager.AddSymbolIntoGroup(currGroupId, sModel);
listViewSymbolsForGroup.Items.Add(sModel.SymbolName);
}
else
message += " Symbol: '" + currSmb + "' can't be added to '" + currGroupName + "' group";
}
}
}
}
else
{
if (symbCount == 0)
{
ToastNotification.Show(this, "Please, select symbols");
return;
}
for (int i = 0; i < symbCount; i++)
{
var currSmb = listBoxSymbols.SelectedItems[i].ToString();
var currSmbId = _symbols.Find(a => a.SymbolName == currSmb).SymbolId;
var currGroupName = _group.GroupName;
var currGrp = _group;
var currGroupId = currGrp.GroupId;
var currGroupSymbols = ClientDatabaseManager.GetSymbolsInGroup(currGroupId);
if (!currGroupSymbols.Exists(a => a.SymbolName == currSmb))
{
var sModel = new SymbolModel { SymbolId = currSmbId, SymbolName = currSmb };
if (GetCntTypeOfSymbol(currSmb) == currGrp.CntType)
{
ClientDatabaseManager.AddSymbolIntoGroup(currGroupId, sModel);
listViewSymbolsForGroup.Items.Add(sModel.SymbolName);
}
else
message += " Symbol: '" + currSmb + "' can't be added to '" + currGroupName + "' group";
}
}
}
ToastNotification.Show(this, "Joined.");
if (!String.IsNullOrEmpty(message))
ToastNotification.Show(this, message);
}
private void buttonGroupADD_Click(object sender, EventArgs e)
{
if (_symbolsList.Count == 0)
{
if (textBoxGroupsFilter.Text == "" || textBoxGroupsFilter.Text.Contains(" ")) return;
if (comboBoxConType.SelectedItem == null) return;
if (comboBoxTF.SelectedItem == null) return;
var groups = ClientDatabaseManager.GetGroupsForUser(_userID, ApplicationType.DataNet);
var group = new GroupModel
{
GroupName = textBoxGroupsFilter.Text,
TimeFrame = comboBoxTF.SelectedItem.ToString(),
Start = new DateTime(),
End = new DateTime(),
CntType = comboBoxConType.SelectedItem.ToString(),
IsAutoModeEnabled = false,
};
if (!groups.Exists(oo => oo.GroupName == group.GroupName) &&
!ClientDatabaseManager.GetAllGroups(ApplicationType.DataNet)
.Exists(a => a.GroupName == group.GroupName))
{
if (ClientDatabaseManager.AddGroupOfSymbols(group))
{
group.GroupId = ClientDatabaseManager.GetGroupIdByName(group.GroupName);
ClientDatabaseManager.AddGroupForUser(_userID, group, ApplicationType.DataNet);
_groups = ClientDatabaseManager.GetGroupsForUser(_userID, ApplicationType.DataNet);
//todo ClientServiceProxy
ListViewItem item = new ListViewItem(group.GroupName);
item.SubItems.Add(group.TimeFrame);
item.SubItems.Add(group.CntType);
item.SubItems.Add(group.GroupId.ToString());
listViewGroups.Items.Add(item);
}
}
else
{
ToastNotification.Show(this, "This group alredy exist");
}
}
else
{
if (textBoxGroupsFilter.Text == "" || textBoxGroupsFilter.Text.Contains(" "))
{
ToastNotification.Show(this, @"Please, enter group name");
return;
}
if (comboBoxTF.SelectedItem == null)
{
ToastNotification.Show(this, @"Please, chose TF");
return;
}
var groups = ClientDatabaseManager.GetGroupsForUser(_userID, ApplicationType.DataNet);
var conType = eTimeSeriesContinuationType.tsctNoContinuation.ToString();
if (_isStandart)
{
conType = eTimeSeriesContinuationType.tsctStandard.ToString();
}
var group = new GroupModel
{
GroupName = textBoxGroupsFilter.Text,
TimeFrame = comboBoxTF.SelectedItem.ToString(),
Start = new DateTime(),
End = new DateTime(),
CntType = conType,
IsAutoModeEnabled = false,
};
if (!groups.Exists(oo => oo.GroupName == group.GroupName) &&
!ClientDatabaseManager.GetAllGroups(ApplicationType.DataNet)
.Exists(a => a.GroupName == group.GroupName))
{
if (ClientDatabaseManager.AddGroupOfSymbols(group))
{
group.GroupId = ClientDatabaseManager.GetGroupIdByName(group.GroupName);
ClientDatabaseManager.AddGroupForUser(_userID, group, ApplicationType.DataNet);
_groups = ClientDatabaseManager.GetGroupsForUser(_userID, ApplicationType.DataNet);
//todo ClientServiceProxy
ListViewItem item = new ListViewItem(group.GroupName);
item.SubItems.Add(group.TimeFrame);
item.SubItems.Add(group.CntType);
item.SubItems.Add(group.GroupId.ToString());
listViewGroups.Items.Add(item);
for (int i = 0; i < _symbolsList.Count; i++)
{
var currSmb = _symbolsList[i];
var currSmbId = _symbols.Find(a => a.SymbolName == currSmb).SymbolId;
//var currGroupName = group.GroupName;
var currGrp = group;
var currGroupId = currGrp.GroupId;
var sModel = new SymbolModel { SymbolId = currSmbId, SymbolName = currSmb };
if (GetCntTypeOfSymbol(currSmb) == currGrp.CntType)
{
ClientDatabaseManager.AddSymbolIntoGroup(currGroupId, sModel);
}
}
_symbolsList.Clear();
buttonCopy.Text = "Copy";
}
else
{
ToastNotification.Show(this, "This group alredy exist");
}
}
}
textBoxGroupsFilter.Text = "";
}