public ActionResult Delete(int id) { string query = "Select * from HomeRemedies where HomeRemedies_id=@id"; var parameter = new SqlParameter("@id", id); HomeRemedies selectedHomeRemedies = db.HomeRemedies.SqlQuery(query, parameter).FirstOrDefault(); return(View(selectedHomeRemedies)); }
//once the user clicks on the title, it will show the details of just that remedy.. public ActionResult View(int id) { //fetching the details of that perticular remedy string query = "Select * from HomeRemedies where HomeRemedies_id=@id"; var parameter = new SqlParameter("@id", id); HomeRemedies selectedHomeRemedies = db.HomeRemedies.SqlQuery(query, parameter).FirstOrDefault(); return(View(selectedHomeRemedies)); }
public ActionResult Update(int id) { //query to fetch existed details of the remedy, which you want yo update string query = "select * from HomeRemedies where HomeRemedies_id = @id"; SqlParameter parameter = new SqlParameter("@id", id); HomeRemedies selectedHomeRemedies = db.HomeRemedies.SqlQuery(query, parameter).FirstOrDefault(); //fetching the remedysource which chosen for the remedy through ViewModel string urlQuery = "Select * from RemedySources"; List <RemedySource> selectedsrc = db.RemedySource.SqlQuery(urlQuery).ToList(); var UpdateHomeRemedy = new UpdateHomeRemedy(); UpdateHomeRemedy.HomeRemedies = selectedHomeRemedies; UpdateHomeRemedy.RemedySources = selectedsrc; return(View(UpdateHomeRemedy)); }