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