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