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