public List <BreweryEvent> GetEvents()
{
List <BreweryEvent> events = new List <BreweryEvent>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GET_EVENTS, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BreweryEvent be = RowToObject(reader);
events.Add(be);
}
}
return(events);
}
catch (SqlException ex)
{
throw;
}
}
public List <BreweryEvent> GetEvents(int userId)
{
List <BreweryEvent> events = new List <BreweryEvent>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GET_EVENTS_AUTHENTICATED, conn);
cmd.Parameters.AddWithValue("@userId", userId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BreweryEvent be = RowToObject(reader);
events.Add(be);
}
return(events);
}
}
catch (SqlException ex)
{
throw;
}
}
public BreweryEvent CreateEvent(BreweryEvent breweryEvent)
{
BreweryEvent createdEvent = null;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_CREATE_EVENT, conn);
cmd.Parameters.AddWithValue("@breweryId", breweryEvent.BreweryId);
cmd.Parameters.AddWithValue("@title", breweryEvent.Title);
cmd.Parameters.AddWithValue("@description", breweryEvent.Description);
cmd.Parameters.AddWithValue("@dateAndTime", breweryEvent.DateAndTime);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
createdEvent = RowToObject(reader);
}
return(createdEvent);
}
}
catch (SqlException ex)
{
throw;
}
}
private static BreweryEvent RowToObject(SqlDataReader r)
{
BreweryEvent be = new BreweryEvent();
be.BreweryEventId = Convert.ToInt32(r["brewery_event_id"]);
be.BreweryId = Convert.ToInt32(r["brewery_id"]);
be.Title = Convert.ToString(r["title"]);
be.Description = Convert.ToString(r["description"]);
be.DateAndTime = Convert.ToDateTime(r["date_and_time"]);
be.BreweryName = Convert.ToString(r["brewery_name"]);
return(be);
}
public ActionResult <BreweryEvent> CreateEvent(BreweryEvent breweryEvent)
{
BreweryEvent createdEvent = eventDAO.CreateEvent(breweryEvent);
if (createdEvent != null)
{
return(Created($"{createdEvent.BreweryEventId}", createdEvent));
}
else
{
return(BadRequest());
}
}
