public override void AddParticipantToConversation(User participant, Conversation conversation) { try { OracleCommand command = CreateCommand("insertar_Usuario_Grupo"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("id_usuarioV", OracleDbType.Int32) { Value = participant.ID }, new OracleParameter("id_grupoV", OracleDbType.Int32) { Value = conversation.ID } }; command.Parameters.Add(parameters); _connection.Open(); command.ExecuteReader(); } catch (Exception e) { throw e; } finally { _connection.Close(); } }
public override void AddParticipantToEvent(User participant, Event e) { try { OracleCommand command = CreateCommand("insertar_Invitado_Evento"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("id_usuarioV", OracleDbType.Int32) { Value = participant.ID }, new OracleParameter("id_eventoV", OracleDbType.Int32) { Value = e.ID } }; command.Parameters.Add(parameters); _connection.Open(); command.ExecuteReader(); } catch (Exception ex) { throw ex; } finally { _connection.Close(); } }
public void AddParticipantToConversation(User participant, Conversation conversation) { CheckConnection(); try { _activeDB.AddParticipantToConversation(participant,conversation); } catch (Exception e) { Console.WriteLine("[EXCEPTION AddParticipantToConversation] Message={0}", e.Message); } }
public void AddFriend(User user, String friend) { CheckConnection(); try { _activeDB.AddFriend(user, friend); } catch (Exception e) { Console.WriteLine("[EXCEPTION AddFriend] Message={0}", e.Message); } }
public void AddParticipantToEvent(User participant, Event e) { CheckConnection(); try { _activeDB.AddParticipantToEvent(participant, e); } catch (Exception ex) { Console.WriteLine("[EXCEPTION AddParticipantToEvent] Message={0}", ex.Message); } }
public SocketClient(SocketServer server, Socket client) { this.server = server; this.client = client; this.da = new DataAccess(); this.user = new User(); this.dataReceived = 0; userSerializer = new DataContractJsonSerializer(typeof(User)); messageSerializer = new DataContractJsonSerializer(typeof(Message)); stream = new MemoryStream(); Thread thread = new Thread(StartReceivingData); thread.Start(); }
public override void AddFriend(User user, String friend) { try { OracleCommand command = CreateCommand("insertar_Amigo"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("id_usuarioV", OracleDbType.Int32) { Value = user.ID }, new OracleParameter("username_amigoV", OracleDbType.Varchar2) { Value = friend } }; command.Parameters.AddRange(parameters); _connection.Open(); command.ExecuteReader(); } catch (Exception e) { throw e; } finally { _connection.Close(); } }
public override void AddFriend(User user, String friend) { try { SqlCommand command = CreateCommand("insertar_Amigo"); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@id_usuarioV", DbType.String) { Value = user.ID }, new SqlParameter("@usernameV", DbType.String) { Value = friend } }; command.Parameters.AddRange(parameters); _connection.Open(); command.ExecuteReader(); } catch (Exception e) { throw e; } finally { _connection.Close(); } }
public abstract void AddParticipantToEvent(User participant, Event e);
public override int CreateUser(User user) { int userID = -1; try { OracleCommand command = CreateCommand("insertar_Usuario"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("id_usuarioP", OracleDbType.Int32) { Direction = ParameterDirection.Output }, new OracleParameter("passwordV", OracleDbType.Varchar2) { Value = user.Password }, new OracleParameter("usernameV", OracleDbType.Varchar2) { Value = user.Username }, new OracleParameter("emailV", OracleDbType.Varchar2) { Value = user.Email }, new OracleParameter("nombreV", OracleDbType.Varchar2) { Value = user.Name }, new OracleParameter("primer_apellidoV", OracleDbType.Varchar2) { Value = user.LastName1 }, new OracleParameter("segundo_apellidoV", OracleDbType.Varchar2) { Value = user.LastName2 } }; command.Parameters.AddRange(parameters); _connection.Open(); command.ExecuteReader(); userID = (Int32)parameters[0].Value; } catch (Exception e) { throw e; } finally { _connection.Close(); } return userID; }
public User CreateUser(User user) { user.ID = _da.CreateUser(user); Console.WriteLine("[Create User] ID={0} Username={1}", user.ID, user.Username); return user; }
public void AddFriend(User user, String friend) { _da.AddFriend(user, friend); Console.WriteLine("[Add Friend] User={0} Friend={1}", user.Username, friend); }
public Authentication() { _user = null; _state = false; }
public override int CreateUser(User user) { int userID = -1; try { SqlCommand command = CreateCommand("insertar_Usuario"); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@id_usuarioV", DbType.Int32) { Direction = ParameterDirection.Output }, new SqlParameter("@passwordV", DbType.String) { Value = user.Password }, new SqlParameter("@usernameV", DbType.String) { Value = user.Username }, new SqlParameter("@emailV", DbType.String) { Value = user.Email }, new SqlParameter("@nombreV", DbType.String) { Value = user.Name }, new SqlParameter("@segundo_apellidoV", DbType.String) { Value = user.LastName1 }, new SqlParameter("@primer_apellidoV", DbType.String) { Value = user.LastName2 } }; command.Parameters.Add(parameters); _connection.Open(); command.ExecuteReader(); userID = (Int32) parameters[0].Value; } catch (Exception e) { throw e; } finally { _connection.Close(); } return userID; }
public User[] GetFriends(int id) { User[] friends = new User[0]; CheckConnection(); try { friends = _activeDB.GetFriends(id); } catch (Exception e) { Console.WriteLine("[EXCEPTION GetFriends] Message={0}", e.Message); } return friends; }
private void HandleData(string data) { if (dataReceived++ == 0) { user = DeserializeUser(data); Console.WriteLine("[Socket User] ID={0} Username={1}", user.ID, user.Username); } else { Message message = DeserializeMessage(data); message.ID = da.CreateMessage(message); if (message.Type == Message.FILE) { Utilities.SaveFileMessage(message); message.ClearBytes(); Console.WriteLine("[Save File] Path={0}", message.Content); } foreach (int receiver in message.Receivers) { SocketClient client = server.GetSocketClient(receiver); if (client != null) { client.SendMessage(message); } } Console.WriteLine("[Socket Message] ID={0} Date={1} Content={2}", message.ID, message.Date, message.Content); } }
public User[] GetConversationParticipants(Conversation conversation) { User[] participants = new User[0]; CheckConnection(); try { participants = _activeDB.GetConversationParticipants(conversation); } catch (Exception e) { Console.WriteLine("[EXCEPTION GetConversationParticipants] Message={0}", e.Message); } return participants; }
public User GetUserWithAuthentication(string username, string passwordHash) { User user = new User(); CheckConnection(); try { user = _activeDB.GetUserWithAuthentication(username, passwordHash); } catch (Exception e) { Console.WriteLine("[EXCEPTION GetUserWithAuthentication] Message={0}", e.Message); } return user; }
public abstract void AddParticipantToConversation(User participant, Conversation conversation);
public abstract void AddFriend(User user, String friend);
protected User GetCurrentUser(DbDataReader reader) { int colID = reader.GetOrdinal("id_usuario"); int colUsername = reader.GetOrdinal("username"); int colEmail = reader.GetOrdinal("email"); int colName = reader.GetOrdinal("nombre"); int colLastName1 = reader.GetOrdinal("primer_apellido"); int colLastName2 = reader.GetOrdinal("segundo_apellido"); User user = new User(); if (!reader.IsDBNull(colID)) { user.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colUsername)) { user.Username = reader.GetString(colUsername); } if (!reader.IsDBNull(colEmail)) { user.Email = reader.GetString(colEmail); } if (!reader.IsDBNull(colName)) { user.Name = reader.GetString(colName); } if (!reader.IsDBNull(colLastName1)) { user.LastName1 = reader.GetString(colLastName1); } if (!reader.IsDBNull(colLastName2)) { user.LastName2 = reader.GetString(colLastName2); } return user; }
public abstract int CreateUser(User user);
public int CreateUser(User user) { int userID = -1; CheckConnection(); try { userID = _activeDB.CreateUser(user); } catch (Exception e) { Console.WriteLine("[EXCEPTION CreateUser] Message={0}", e.Message); } return userID; }