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));
}
