public JsonResult GetDoctorName(string term) { HospitalManagementEntities db = new HospitalManagementEntities(); SqlCommand cmd = new SqlCommand("sp_getDoctorName", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@searchText", term); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); List <DoctorNameSpeciality> drNameSpty = new List <DoctorNameSpeciality>(); foreach (DataRow dr in ds.Tables[0].Rows) { drNameSpty.Add(new DoctorNameSpeciality { NameSpecialist = Convert.ToString(dr["name"]) + "-" + Convert.ToString(dr["Specialist"]) }); } List <string> drNameSptyterm = drNameSpty.Select(s => s.NameSpecialist).ToList();; return(Json(drNameSptyterm, JsonRequestBehavior.AllowGet)); }
public JsonResult GetInvestigation() { HospitalManagementEntities db = new HospitalManagementEntities(); List <string> Diseasses; Diseasses = db.InvestigationDetails.Where(m => m.Invistagation != null).Select(m => m.Invistagation).ToList(); return(Json(Diseasses, JsonRequestBehavior.AllowGet)); }
public JsonResult GetMedicine(string term) { HospitalManagementEntities db = new HospitalManagementEntities(); List <string> Medicines; Medicines = db.Medicines.Where(x => x.MedicineName.StartsWith(term)) .Select(y => y.MedicineName).ToList(); return(Json(Medicines, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllDiseasses() { HospitalManagementEntities db = new HospitalManagementEntities(); List <string> Diseasses; Diseasses = db.Diseasses.Where(m => m.DisseaseName != null).Select(m => m.DisseaseName).ToList(); return(Json(Diseasses, JsonRequestBehavior.AllowGet)); }
public static List <SelectListItem> GetAllPatients() { HospitalManagementEntities hospitalEntities = new HospitalManagementEntities(); List <SelectListItem> items = new List <SelectListItem>(); var patientDetails = hospitalEntities.Patients.ToList(); foreach (var patient in patientDetails) { //staffs.Add(staff.MapStaffToStaffDetails()); items.Add(new SelectListItem { Text = patient.PatientName + patient.PatientLastName, Value = patient.PatientKey.ToString() }); } return(items); }
public static List <SelectListItem> GetAllDoctors() { HospitalManagementEntities hospitalEntities = new HospitalManagementEntities(); List <SelectListItem> items = new List <SelectListItem>(); //List<StaffDetails> staffs = new List<StaffDetails>(); var staffDetails = hospitalEntities.Staffs.Where(s => s.RoleSKey == (int)Roles.Doctor).ToList(); foreach (var staff in staffDetails) { //staffs.Add(staff.MapStaffToStaffDetails()); items.Add(new SelectListItem { Text = staff.StaffName + staff.StaffLastName, Value = staff.StaffKey.ToString() }); } return(items); }
public ActionResult CreateAppointment(int id) { HospitalManagementEntities db = new HospitalManagementEntities(); return(View(db.sp_getAppointment().ToList())); }