private static void CreateTables() { foreach (var userId in _usersId) { var user = AdminDatabaseManager.GetUserData(userId); AddUser(user); var groups = AdminDatabaseManager.GetGroupsForUser(userId); foreach (var group in groups) { AddGroup(group); AddGroupSymbols(group); _groupIndexer++; } _userIndexer++; } }
private void EditListControl_Load(object sender, EventArgs e) { cmbHistoricalPeriod.SelectedIndex = 0; cmbContinuationType.Items.Clear(); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctNoContinuation); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctStandard); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctStandardByMonth); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctActive); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctActiveByMonth); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctAdjusted); cmbContinuationType.Items.Add(eTimeSeriesContinuationType.tsctAdjustedByMonth); cmbContinuationType.SelectedIndex = 0; var symbolsList = AdminDatabaseManager.GetSymbols(); foreach (var symbol in symbolsList) { lbAvbList.Items.Add(symbol.SymbolName); } }
private static void AddGroupSymbols(GroupModel group) { var symbolList = AdminDatabaseManager.GetSymbolsInGroup(group.GroupId); foreach (var symbol in symbolList) { var symbolValues = new ArrayList { null, _groupIndexer, symbol.SymbolName }; var symbolRow = _userDetails.tableSymbols.NewRow(); symbolRow.ItemArray = symbolValues.ToArray(); _userDetails.tableSymbols.Rows.Add(symbolRow); _userDetails.AcceptChanges(); } }
private void EditListControl_Load(object sender, EventArgs e) { OldGroupName = textBoxXListName.Text; var symbolsList = AdminDatabaseManager.GetSymbols(); foreach (var symbol in symbolsList) { var exist = false; foreach (var item in lbSelList.Items) { if (item.ToString() == symbol.SymbolName) { exist = true; } } if (!exist) { lbAvbList.Items.Add(symbol.SymbolName); } } }
public void Login(DataAdminMessageFactory.LoginMessage loginParams) { var usr = loginParams.UsernameMD5; var psw = loginParams.PasswordMD5; string serverMessage = ""; string msgfail = ""; var users = AdminDatabaseManager.GetUsers(); if (users.Exists(a => a.Name == usr)) // if user in DB { UserModel tempUser = users.Find(a => a.Name == usr); if (tempUser.Password == psw) // if user psw == db.psw { string ipAddress = ""; var match = Regex.Match(CurrentClient.RemoteEndPoint.ToString(), @"\b(\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})\b"); if (match.Success) { ipAddress = match.Captures[0].Value; } if ((ipAddress == tempUser.IpAdress && tempUser.AllowAnyIp == false) || (tempUser.AllowAnyIp)) // if with Ip adress is all good { #region VALIDATION if (loginParams.NetType == 'd' && tempUser.AllowDataNet == false) { serverMessage = "YOUR DATANET CLIENT BLOCKED BY ADMIN"; msgfail = "Client trying to connect from " + CurrentClient.RemoteEndPoint + " but his client blocked by Admin."; Error = true; } if (loginParams.NetType == 't' && tempUser.AllowTickNet == false) { serverMessage = "YOUR TICKNET CLIENT BLOCKED BY ADMIN"; msgfail = DateTime.Now.Date.ToShortDateString() + ": Client trying to connect from " + CurrentClient.RemoteEndPoint + " but his client blocked by Admin."; Error = true; } if (loginParams.NetType == 'e' && tempUser.AllowDexport == false) { serverMessage = "YOUR DATA EXPORT CLIENT BLOCKED BY ADMIN"; msgfail = DateTime.Now.Date.ToShortDateString() + ": Client trying to connect from " + CurrentClient.RemoteEndPoint + " but his client blocked by Admin."; Error = true; } #endregion #region Succes Login if (!Error) { if (loginParams.NetType == 'd' && tempUser.AllowDataNet) { DataNetClientLogin(loginParams, tempUser); } if (loginParams.NetType == 't' && tempUser.AllowTickNet) { TickNetClientLogin(loginParams, tempUser); } if (loginParams.NetType == 'e' && tempUser.AllowDexport) { DataExportClientLogin(loginParams, tempUser); } return; } #endregion } else { serverMessage = "YOUR IP ADDRESS IS NOT ALLOWED"; msgfail = DateTime.Now.Date.ToShortDateString() + ": Client trying connect to server from " + CurrentClient.RemoteEndPoint + " but the IP adress is blocked by Admin."; } } else { serverMessage = "ENTER A CORRECT PASSWORD"; } } else { serverMessage = "YOUR USERNAME IS INCORRECT"; } #region Create Server Message about failed login and send to client if (OnloginFailedLog != null) { new Thread(() => OnloginFailedLog(new DataAdminMessageFactory.LogMessage(), msgfail)).Start(); } var client = CurrentClient; //Get a proxy object to call methods of client when needed var clientProxy = client.GetClientProxy <IDataAdminService>(); var loginFailed = new DataAdminMessageFactory.LoginMessage("", "", 'd') { ServerMessage = serverMessage }; clientProxy.Login(loginFailed); #endregion }