private void button2_Click(object sender, EventArgs e)
{
this.Close();
ViewDoctor pz = new ViewDoctor();
pz.Show();
}
public ActionResult View(int id)
{
//This method will use a viewmodel. It needs a particular doctor and list of similar doctors.
Debug.WriteLine("I am trying to view record of doctor having id:" + id);
string query = "Select * from doctors where DoctorID=@id";
SqlParameter parameter = new SqlParameter("@id", id);
Doctor selecteddoctor = db.Doctors.SqlQuery(query, parameter).FirstOrDefault();
var speciality = selecteddoctor.SpecialityID;
string secondquery = "Select * from doctors where doctorid!=@id and Doctors.SpecialityID=@speciality";
SqlParameter[] parameters = new SqlParameter[2];
parameters[0] = new SqlParameter("@id", id);
parameters[1] = new SqlParameter("@speciality", speciality);
List <Doctor> similardoctors = db.Doctors.SqlQuery(secondquery, parameters).ToList();
var ViewDoctor = new ViewDoctor();
ViewDoctor.doctor = selecteddoctor;
ViewDoctor.similardoctors = similardoctors;
return(View(ViewDoctor));
/*Select * from doctors where doctorid!=1 and Doctors.SpecialityID=1*/
}
