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