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
}
