public List <hospitaldata> hospitals()
{
database_class database = new database_class();
var hospitals = from i in database.Hospitals select i;
List <hospitaldata> hosp = new List <hospitaldata>();
foreach (var j in hospitals)
{
hospitaldata hd = new hospitaldata();
hd.hospitalId = j.HospitalId;
hd.hospitalName = j.HospitalName;
hd.MobileNumber = j.MobileNumber;
hd.Address = j.Address;
hosp.Add(hd);
}
return(hosp);
}
public List <hospitaldata> chooshosp(int spid)
{
database_class database = new database_class();
var sps = (from i in database.Doctors where i.SpecialistId == spid select i.HospitalId).Distinct();
List <hospitaldata> hosp = new List <hospitaldata>();
foreach (var i in sps)
{
var hospital = from k in database.Hospitals where k.HospitalId == i select k;
foreach (var j in hospital)
{
hospitaldata hd = new hospitaldata();
hd.hospitalId = j.HospitalId;
hd.hospitalName = j.HospitalName;
hd.MobileNumber = j.MobileNumber;
hd.Address = j.Address;
hosp.Add(hd);
}
}
return(hosp);
}