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