public string GetVisitationByDoctorID(long doctor_id)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var resultSet = database.Scheduled_visitations.Where(visitation => visitation.doctor_id == doctor_id).ToList();
Hospital.Models.ScheduledVisitation findedVisitation = new Hospital.Models.ScheduledVisitation();
if (resultSet.Count > 0)
{
findedVisitation.Map(resultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(findedVisitation));
}
return(JsonConvert.SerializeObject(new { }));
}
public string GetVisitationByDate(string date)
{
HospitalDatabaseEntities database = new HospitalDatabaseEntities();
var ResultSet = database.Scheduled_visitations.Where(history => history.plan_date.ToShortDateString().Equals(date)).ToList();
Hospital.Models.ScheduledVisitation requestedVisitation = new Hospital.Models.ScheduledVisitation();
if (ResultSet.Count == 1)
{
requestedVisitation.Map(ResultSet.FirstOrDefault());
return(JsonConvert.SerializeObject(requestedVisitation));
}
return(JsonConvert.SerializeObject(new { }));
}
