// Showing details of poetry
public ActionResult Show(int id)
{
string query = "select * from poetries where poetryid = @id";
var parameter = new SqlParameter("@id", id);
poetry selectedpoetry = db.Poetries.SqlQuery(query, parameter).FirstOrDefault();
return(View(selectedpoetry));
}
//updating a poetry
public ActionResult Update(int id)
{
//query to select selected poetry and displaying data in form
string query = "select * from poetries where poetryid = @id";
var parameter = new SqlParameter("@id", id);
poetry selectedpoetry = db.Poetries.SqlQuery(query, parameter).FirstOrDefault();
return(View(selectedpoetry));
}
