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