public static string[] GetGroupNameList(string prefixText)
{
var dataContext = new DBDataContext();
var result = from element in dataContext.IcdChapters
where element.icdChapterName.ToString().ToLower().StartsWith(prefixText)
select element.icdChapterName.ToString();
return result.ToArray();
}
public static string[] GetPatientList(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.Patients
where element.patientName.ToString().ToLower().StartsWith(prefixText)
select element.patientName.ToString()).Distinct();
return result.ToArray();
}
public static string[] GetDrugList(string prefixText)
{
var dataContext = new DBDataContext();
var result = from element in dataContext.Drugs
where element.drugName.ToString().ToLower().StartsWith(prefixText)
select element.drugName.ToString();
return result.ToArray();
}
public static string[] GetPrescriptionList(string prefixText)
{
var dataContext = new DBDataContext();
var result = from element in dataContext.Prescriptions
where element.prescriptionId.ToString().StartsWith(prefixText)
select element.prescriptionId.ToString();
return result.ToArray();
}
public static string[] GetLabOrderList(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.LabOrders
where element.labOrderId.ToString().ToLower().StartsWith(prefixText)
select element.labOrderId.ToString()).Distinct();
return result.ToArray();
}
public static string[] GetGroupNameList(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.MedicalServiceGroups
where element.medicalServiceGroupName.ToString().ToLower().StartsWith(prefixText)
select element.medicalServiceGroupName.ToString()).Distinct();
return result.ToArray();
}
public static string[] GetLabOrders(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.LabOrders
where element.Doctor.doctorName.ToLower().StartsWith(prefixText)
select element.Doctor.doctorName.ToString());
return result.ToArray();
}
public static string[] GetMedicalServiceGroup(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from n in dataContext.MedicalServiceGroups
where n.medicalServiceGroupName.ToString().ToLower().StartsWith(prefixText.ToLower())
select n.medicalServiceGroupName.ToString());
return result.ToArray();
}
public static string[] GetIcdChapters(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from n in dataContext.IcdChapters
where n.icdChapterName.ToString().ToLower().StartsWith(prefixText.ToLower())
select n.icdChapterName.ToString());
return result.ToArray();
}
public static string[] GetLabOrderDetails(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.LabOrderDetails
where element.MedicalService.medicalServiceName.ToString().ToLower().StartsWith(prefixText)
select element.MedicalService.medicalServiceName.ToString())
.Union(from element in dataContext.LabOrderDetails
where element.labResult.ToString().ToLower().StartsWith(prefixText)
select element.labResult.ToString());
return result.ToArray();
}
public static string[] GetPrescriptionDetails(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.PrescriptionDetails
where element.prescriptionId.ToString().ToLower().StartsWith(prefixText)
select element.prescriptionId.ToString())
.Union(from element in dataContext.PrescriptionDetails
where element.Drug.drugName.ToString().ToLower().StartsWith(prefixText)
select element.Drug.drugName.ToString())
.Union(from element in dataContext.PrescriptionDetails
where element.specialInstruction.ToString().ToLower().StartsWith(prefixText)
select element.specialInstruction.ToString());
return result.ToArray();
}
public static string[] GetIcd(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.Icds
where element.icdName.ToLower().StartsWith(prefixText)
select element.icdName.ToString())
.Union(from element in dataContext.Icds
where element.IcdChapter.icdChapterName.ToString().ToLower().StartsWith(prefixText)
select element.IcdChapter.icdChapterName.ToString())
.Union(from element in dataContext.Icds
where element.icdCode.ToString().ToLower().StartsWith(prefixText)
select element.icdCode.ToString());
return result.ToArray();
}
public static string[] GetHospital(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from n in dataContext.Hospitals
where n.hospitalName.ToString().ToLower().StartsWith(prefixText.ToLower())
select n.hospitalName.ToString())
.Union(from n in dataContext.Hospitals
where n.license.ToString().ToLower().StartsWith(prefixText.ToLower())
select n.license.ToString())
.Union(from n in dataContext.Hospitals
where n.address.ToString().ToLower().StartsWith(prefixText.ToLower())
select n.address.ToString());
return result.ToArray();
}
public static string[] GetPatients(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.Patients
where element.patientName.ToLower().StartsWith(prefixText)
select element.patientName.ToString())
.Union(from element in dataContext.Patients
where element.Gender.genderName.ToString().ToLower().StartsWith(prefixText)
select element.Gender.genderName.ToString())
.Union(from element in dataContext.Patients
where element.dob.ToString().ToLower().StartsWith(prefixText)
select element.dob.ToString())
.Union(from element in dataContext.Patients
where element.address.ToString().ToLower().StartsWith(prefixText)
select element.address.ToString());
return result.ToArray();
}
public static string[] GetDrug(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.Drugs
where element.drugName.ToLower().StartsWith(prefixText)
select element.drugName.ToString())
.Union(from element in dataContext.Drugs
where element.DrugGroup.drugGroupName.ToString().ToLower().StartsWith(prefixText)
select element.DrugGroup.drugGroupName.ToString())
.Union(from element in dataContext.Drugs
where element.drugGenericName.ToString().ToLower().StartsWith(prefixText)
select element.drugGenericName.ToString())
.Union(from element in dataContext.Drugs
where element.unit.ToString().ToLower().StartsWith(prefixText)
select element.unit.ToString())
.Union(from element in dataContext.Drugs
where element.price.ToString().ToLower().StartsWith(prefixText)
select element.price.ToString());
return result.ToArray();
}
protected void Page_Load(object sender, EventArgs e)
{
_dataContext = new DBDataContext();
}
public static string[] GetVisit(string prefixText)
{
var dataContext = new DBDataContext();
var result = (from element in dataContext.Visits
where element.Doctor.doctorName.ToString().ToLower().StartsWith(prefixText)
select element.Doctor.doctorName.ToString()).Distinct()
.Union(from element in dataContext.Visits
where element.Hospital.hospitalName.ToString().ToLower().StartsWith(prefixText)
select element.Hospital.hospitalName.ToString()).Distinct()
.Union(from element in dataContext.Visits
where element.Patient.patientName.ToString().ToLower().StartsWith(prefixText)
select element.Patient.patientName.ToString()).Distinct()
.Union(from element in dataContext.Visits
where element.Icd.icdName.ToString().ToLower().StartsWith(prefixText)
select element.Icd.icdName.ToString()).Distinct()
.Union(from element in dataContext.Visits
where element.Prescription.prescriptionId.ToString().ToLower().StartsWith(prefixText)
select element.Prescription.prescriptionId.ToString()).Distinct()
.Union(from element in dataContext.Visits
where element.LabOrder.labOrderId.ToString().ToLower().StartsWith(prefixText)
select element.LabOrder.labOrderId.ToString()).Distinct()
.Union(from element in dataContext.Visits
where element.outcome.ToString().ToLower().StartsWith(prefixText)
select element.outcome.ToString()).Distinct();
return result.ToArray();
}
