public IActionResult GetDoctorAppointment(int assignedTo) { EntityConnection con = new EntityConnection("tbl_visit"); Dictionary <string, string> result = new Dictionary <string, string>() { { "assignedTo", assignedTo.ToString() } }; if (con.DoctorsAppoinmentList(assignedTo).Count > 0) { return(Ok(con.DoctorsAppoinmentList(assignedTo))); } else { obj = new { message = "No patients assigned yet" }; return(NotFound(obj)); } }