private void UpdateDGPContactsUserList(Client user)
{
Database db = new Database(DB_SERVER, DB_DATABASE, DB_USERNAME, DB_PASSWORD);
string [] contactIds = (string []) db.getDGPContacts(user.Id).ToArray(typeof(string));
for( int i = 0; i < contactIds.Length; i++)
{
foreach(Client client in clientList)
{
if(client.Id == contactIds[i])
{
string message = "UPDATE_FRIEND " + user.Id + '\n' +
user.DisplayName + '\n' + user.Status;
client.Send(message);
}
}
}
db.close();
}
private void SetUserOnlineStatus(char status, Client client)
{
client.Status = status;
Database db = new Database(DB_SERVER, DB_DATABASE, DB_USERNAME, DB_PASSWORD);
db.setUserOnlineStatus(status, client.Id);
db.close();
}
public bool testNameAndPassword(string name, string password, Client client)
{
try
{
int itsInloggId;
itsCommand = new OdbcCommand("",itsConnection);
itsCommand.CommandText = "SELECT userID FROM users WHERE email=\'"+ name + "\'";
itsDataReader = itsCommand.ExecuteReader();
if(itsDataReader.Read())
{
itsInloggId = itsDataReader.GetInt32(0);
itsDataReader.Close();
}
else
{
itsCommand.Dispose();
itsDataReader.Close();
return false;
}
itsCommand.CommandText = "SELECT password FROM users WHERE userID=\'"+ itsInloggId.ToString() + "\'";
itsDataReader = itsCommand.ExecuteReader();
itsDataReader.Read();
string databasePassword = itsDataReader.GetString(0);
if(string.Compare(databasePassword, password, true) == 0)
{
itsDataReader.Close();
itsCommand.CommandText = "SELECT * FROM users WHERE userID=\'"+ itsInloggId.ToString() + "\'";
itsDataReader = itsCommand.ExecuteReader();
itsDataReader.Read();
client.Id = itsDataReader.GetString(0);
client.Email = name;
//client.IpNumber = itsDataReader.GetString(3);
client.DisplayName = itsDataReader.GetString(4);
itsCommand.Dispose();
itsDataReader.Close();
return true;
}
else
{
itsCommand.Dispose();
itsDataReader.Close();
return false;
}
}
catch (OdbcException MyOdbcException)//Catch any ODBC exception ..
{
this.handleException(MyOdbcException);
}
return false;
}
private void ConnectionRecived(IAsyncResult ar)
{
try
{
Client client = new Client(serverSocket.EndAccept(ar));
client.LineReceived += new LineReceivedEventHandler(ClientLineReceived);
clientList.Add(client);
Console.WriteLine("Client Connected From Ip: " + client.ClientSocket.RemoteEndPoint.ToString());
serverSocket.BeginAccept(new AsyncCallback(ConnectionRecived), this);
}
catch (ObjectDisposedException)
{
}
}
/**********************************************************************
*
* Constructors
*
**********************************************************************/
public LineReceivedEventArgs(Client client, string message)
{
_client = client;
_message = message;
}
