public BreweryImage CreateImage(BreweryImage brewery)
{
BreweryImage bi = null;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_CREATE_IMAGE, conn);
cmd.Parameters.AddWithValue("@breweryId", brewery.BreweryId);
cmd.Parameters.AddWithValue("@imageUrl", brewery.ImageUrl);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
bi = RowToObject(reader);
}
}
return(bi);
}
catch (SqlException ex)
{
throw;
}
}
public List <BreweryImage> GetImages(int breweryId)
{
List <BreweryImage> images = new List <BreweryImage>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(SQL_GET_IMAGES, conn);
cmd.Parameters.AddWithValue("@breweryId", breweryId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
BreweryImage image = RowToObject(reader);
images.Add(image);
}
}
return(images);
}
catch (SqlException ex)
{
throw;
}
}
private static BreweryImage RowToObject(SqlDataReader reader)
{
BreweryImage bi = new BreweryImage();
bi.BreweryId = Convert.ToInt32(reader["brewery_id"]);
bi.ImageUrl = Convert.ToString(reader["image_url"]);
bi.ImageId = Convert.ToInt32(reader["image_id"]);
return(bi);
}
public ActionResult <BreweryImage> CreateImage(BreweryImage brewery)
{
BreweryImage image = this.breweryImagesDAO.CreateImage(brewery);
if (image != null)
{
return(Created($"{image.BreweryId}/images/{image.ImageId}", image));
}
else
{
return(BadRequest());
}
}
