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; }