public MotionPicture GetMotionPictureByID(int id)
{
MotionPicture motionPicture = new MotionPicture();
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand command = new SqlCommand("select * from MotionPictures where ID = @id", conn);
command.Parameters.AddWithValue("@id", id);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
motionPicture = GetMotionPictureFromReader(reader);
}
}
}
catch (Exception e)
{
throw e;
}
return(motionPicture);
}
private MotionPicture GetMotionPictureFromReader(SqlDataReader reader)
{
MotionPicture motionPicture = new MotionPicture()
{
ID = Convert.ToInt32(reader["ID"]),
Name = Convert.ToString(reader["Name"]),
Description = Convert.ToString(reader["Description"]),
ReleaseYear = Convert.ToInt32(reader["Release_Year"])
};
return(motionPicture);
}
public ActionResult <MotionPicture> PostPicture(MotionPicture picture)
{
try
{
motionPictureDAO.PostMotionPicture(picture);
}
catch (Exception e)
{
StatusCode(500, e.Message);
}
return(Created($"/api/MotionPicture/{picture.ID}", picture));
}
public ActionResult <MotionPicture> UpdatePicture(int id, MotionPicture updatedPicture)
{
if (!ModelState.IsValid || updatedPicture.ID != id)
{
return(BadRequest());
}
else
{
try
{
motionPictureDAO.EditMotionPicture(updatedPicture);
}
catch (Exception e)
{
return(StatusCode(500, e.Message));
}
return(Ok(updatedPicture));
}
}
public int PostMotionPicture(MotionPicture newPicture)
{
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand command = new SqlCommand("insert into MotionPictures (Name, Description, Release_Year) values (@name, @description, @release_year); select scope_identity();", conn);
command.Parameters.AddWithValue("@name", newPicture.Name);
command.Parameters.AddWithValue("@description", newPicture.Description);
command.Parameters.AddWithValue("@release_year", newPicture.ReleaseYear);
newPicture.ID = Convert.ToInt32(command.ExecuteScalar());
}
}
catch (Exception e)
{
throw e;
}
return(newPicture.ID);
}
public ActionResult <MotionPicture> GetPictureByID(int id)
{
MotionPicture picture = new MotionPicture();
try
{
picture = motionPictureDAO.GetMotionPictureByID(id);
}
catch (Exception e)
{
return(StatusCode(500, e.Message));
}
if (picture.Name != null)
{
return(Ok(picture));
}
else
{
return(BadRequest());
}
}
public bool EditMotionPicture(MotionPicture editedMotionPicture)
{
int rowsAffected = 0;
try
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
conn.Open();
SqlCommand command = new SqlCommand("update MotionPictures set Name = @name, Description = @description, Release_Year = @releaseYear where ID = @id;", conn);
command.Parameters.AddWithValue("@name", editedMotionPicture.Name);
command.Parameters.AddWithValue("@description", editedMotionPicture.Description);
command.Parameters.AddWithValue("@releaseYear", editedMotionPicture.ReleaseYear);
command.Parameters.AddWithValue("@id", editedMotionPicture.ID);
rowsAffected = command.ExecuteNonQuery();
}
}
catch (Exception e)
{
throw e;
}
return(rowsAffected > 0);
}
