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 AddParticipantToEvent(User participant, Event e) { CheckConnection(); try { _activeDB.AddParticipantToEvent(participant, e); } catch (Exception ex) { Console.WriteLine("[EXCEPTION AddParticipantToEvent] Message={0}", ex.Message); } }
public Event CreateEvent(Event e) { e.ID = _da.CreateEvent(e); foreach (User u in e.Participants) { _da.AddParticipantToEvent(u, e); } Console.WriteLine("[Create Event] ID={0}", e.ID); return e; }
public override int CreateEvent(Event e) { int eventID = -1; try { OracleCommand command = CreateCommand("insertar_Evento"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter("id_eventoV", OracleDbType.Int32) { Direction = ParameterDirection.Output }, new OracleParameter("id_usuarioV", OracleDbType.Int32) { Value = e.Creator }, new OracleParameter("nombreV", OracleDbType.Varchar2) { Value = e.Title }, new OracleParameter("descripcionV", OracleDbType.Varchar2) { Value = e.Description }, new OracleParameter("fecha_iniV", OracleDbType.Date) { Value = e.IniDate }, new OracleParameter("fecha_endV", OracleDbType.Date) { Value = e.FinDate } }; command.Parameters.AddRange(parameters); _connection.Open(); command.ExecuteReader(); eventID = (Int32) parameters[0].Value; } catch (Exception ex) { throw ex; } finally { _connection.Close(); } return eventID; }
protected Event GetCurrentEvent(DbDataReader reader) { int colID = reader.GetOrdinal("id_evento"); int colCreator = reader.GetOrdinal("id_usuario"); int colTitle = reader.GetOrdinal("nombre"); int colDescription = reader.GetOrdinal("descripcion"); int colIniDate = reader.GetOrdinal("fecha_ini"); int colFinDate = reader.GetOrdinal("fecha_end"); Event e = new Event(); if (!reader.IsDBNull(colID)) { e.ID = reader.GetInt32(colID); } if (!reader.IsDBNull(colCreator)) { e.Creator = reader.GetInt32(colCreator); } if (!reader.IsDBNull(colTitle)) { e.Title = reader.GetString(colTitle); } if (!reader.IsDBNull(colDescription)) { e.Description = reader.GetString(colDescription); } if (!reader.IsDBNull(colIniDate)) { e.IniDate = reader.GetDateTime(colIniDate); } if (!reader.IsDBNull(colFinDate)) { e.FinDate = reader.GetDateTime(colFinDate); } return e; }
public abstract int CreateEvent(Event e);
public abstract void AddParticipantToEvent(User participant, Event e);
public int CreateEvent(Event e) { int eventID = -1; CheckConnection(); try { eventID = _activeDB.CreateEvent(e); } catch (Exception ex) { Console.WriteLine("[EXCEPTION CreateEvent] Message={0}", ex.Message); } return eventID; }
public Event[] GetEvents(int id) { Event[] events = new Event[0]; CheckConnection(); try { events = _activeDB.GetEvents(id); } catch (Exception e) { Console.WriteLine("[EXCEPTION GetEvents] Message={0}", e.Message); } return events; }