public ActionResult Delete(int id) { string query = "Select * from SocialServiceClubs where SocialServiceClubs_id=@id"; var parameter = new SqlParameter("@id", id); SocialServiceClubs selectedSocialServiceClub = db.SocialServiceClubs.SqlQuery(query, parameter).FirstOrDefault(); return(View(selectedSocialServiceClub)); }
public ActionResult Update(int id) { //fetch existed details of the remedy string query = "select * from SocialServiceClubs where SocialServiceClubs_id = @id"; var parameter = new SqlParameter("@id", id); SocialServiceClubs selectedSocialServiceClub = db.SocialServiceClubs.SqlQuery(query, parameter).FirstOrDefault(); return(View(selectedSocialServiceClub)); }