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;
}
/**********************************************************************
*
* Constructors
*
**********************************************************************/
public LineReceivedEventArgs(Client client, string message)
{
_client = client;
_message = message;
}
/**********************************************************************
*
* Constructors
*
**********************************************************************/
public ClientRecivedEventArgs(Client client)
{
_client = client;
}
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)
{
}
}
private void ConnectionRecived(IAsyncResult ar)
{
try
{
Client client = new Client(serverSocket.EndAccept(ar));
if (ClientRecived != null)
{
ClientRecived(this, new ClientRecivedEventArgs(client));
}
clientList.Add(client);
Logg("Client Connected From Ip: " + client.ClientSocket.RemoteEndPoint.ToString());
serverSocket.BeginAccept(new AsyncCallback(ConnectionRecived), this);
}
catch (ObjectDisposedException)
{
}
}
