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 Conversation CreateConversation(Conversation c)
{
c.ID = _da.CreateConversation(c);
foreach (User u in c.Participants)
{
_da.AddParticipantToConversation(u, c);
}
Console.WriteLine("[Create Conversation] ID={0}", c.ID);
return c;
}
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 int CreateConversation(Conversation c)
{
int conversationID = -1;
CheckConnection();
try
{
conversationID = _activeDB.CreateConversation(c);
}
catch (Exception e)
{
Console.WriteLine("[EXCEPTION CreateConversation] Message={0}", e.Message);
}
return conversationID;
}
protected Conversation GetCurrentConversation(DbDataReader reader)
{
int colID = reader.GetOrdinal("grupoid_grupo");
int colName = reader.GetOrdinal("nombre");
Conversation conversation = new Conversation();
if (!reader.IsDBNull(colID))
{
conversation.ID = reader.GetInt32(colID);
}
if (!reader.IsDBNull(colName))
{
conversation.Name = reader.GetString(colName);
}
return conversation;
}
public override User[] GetConversationParticipants(Conversation conversation)
{
List<User> users = new List<User>();
DbDataReader reader = null;
try
{
OracleCommand command = CreateCommand("get_group_users");
OracleParameter[] parameters = new OracleParameter[]
{
new OracleParameter("id_grupoV", OracleDbType.Int32) { Value = conversation.ID },
new OracleParameter("refcursor", OracleDbType.RefCursor, ParameterDirection.Output)
};
command.Parameters.AddRange(parameters);
_connection.Open();
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
users.Add(GetCurrentUser(reader));
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
reader.Close();
_connection.Close();
}
return users.ToArray();
}
public override int CreateConversation(Conversation c)
{
int conversationID = -1;
try
{
OracleCommand command = CreateCommand("crear_Conversacion");
OracleParameter[] parameters = new OracleParameter[]
{
new OracleParameter("id_grupoV", OracleDbType.Int32) { Direction = ParameterDirection.Output },
new OracleParameter("nombreV", OracleDbType.Varchar2) { Value = c.Name }
};
command.Parameters.Add(parameters);
_connection.Open();
command.ExecuteReader();
conversationID = (Int32)parameters[0].Value;
}
catch (Exception e)
{
throw e;
}
finally
{
_connection.Close();
}
return conversationID;
}
public override User[] GetConversationParticipants(Conversation conversation)
{
List<User> users = new List<User>();
DbDataReader reader = null;
try
{
SqlCommand command = CreateCommand("get_group_users");
SqlParameter param = new SqlParameter("@id_grupoV", DbType.Int32) { Value = conversation.ID };
command.Parameters.Add(param);
_connection.Open();
reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
users.Add(GetCurrentUser(reader));
}
}
}
catch (Exception e)
{
throw e;
}
finally
{
reader.Close();
_connection.Close();
}
return users.ToArray();
}
public abstract User[] GetConversationParticipants(Conversation conversation);
public abstract Message[] GetConversationMessages(Conversation conversation);
public abstract int CreateConversation(Conversation c);
public abstract void AddParticipantToConversation(User participant, Conversation conversation);
public Conversation[] GetConversations(int id)
{
Conversation[] conversations = new Conversation[0];
CheckConnection();
try
{
conversations = _activeDB.GetConversations(id);
}
catch (Exception e)
{
Console.WriteLine("[EXCEPTION GetConversations] Message={0}", e.Message);
}
return conversations;
}
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 Message[] GetConversationMessages(Conversation conversation)
{
Message[] conversations = new Message[0];
CheckConnection();
try
{
conversations = _activeDB.GetConversationMessages(conversation);
}
catch (Exception e)
{
Console.WriteLine("[EXCEPTION GetConversationMesages] Message={0}", e.Message);
}
return conversations;
}
