public bool Delete(Film film)
{
SqlOperation delete = new SqlOperation
{
query = "delete from film where id = @filmId ",
parameters = new string[] { film.Id.ToString() }
};
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(delete.query, connection))
{
cmd.Parameters.Add(new SqlParameter("filmId", delete.parameters[0]));
return(cmd.ExecuteNonQuery() == 1);
}
}
}
public long Insert(Film film)
{
SqlOperation insert = new SqlOperation
{
query = "insert into Film (title, released, stock, genre) values (@title, @released, @stock, @genre) SELECT SCOPE_IDENTITY();"
};
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
using (SqlCommand cmd = new SqlCommand(insert.query, connection))
{
cmd.Parameters.AddWithValue("title", film.Title);
cmd.Parameters.AddWithValue("released", film.Released);
cmd.Parameters.AddWithValue("stock", film.Stock);
cmd.Parameters.AddWithValue("genre", film.Genre);
int id = Convert.ToInt32(cmd.ExecuteScalar());
return(id);
}
}
}
