/*Function which takes two parameters
* 1) The new lab to be inserted into the database
* 2) The name of the patient to assign this lab to
* The Pid is located first
* Query is then executed to insert new lab and return the Scope_ID of the new lab
* The Patient is then associated with the new Lab using connector table Patient_Lab
*/
public static void AddLab(Lab newLab, string Name)
{
LabTableAdapter taLabs = new LabTableAdapter();
PatientTableAdapter patientLookUp = new PatientTableAdapter();
int pid = (int)patientLookUp.GetPatientID(Name);
int scope_id = Convert.ToInt32(taLabs.AddNewLabReturnScopeID(newLab.Weight, newLab.Doc_id, newLab.Date, newLab.Category, newLab.PatientType, newLab.Amount));
Patient_LabTableAdapter labPatientConnect = new Patient_LabTableAdapter();
labPatientConnect.InsertByPidLabID(pid, scope_id);
}
public static List <Lab> GetAllLabs()
{
LabTableAdapter taLabs = new LabTableAdapter();
var dtLabs = taLabs.GetData();
List <Lab> allLabs = new List <Lab>();
foreach (dsUltimateMedDB.LabRow labRow in dtLabs.Rows)
{
Lab currentlab = new Lab
{
Amount = labRow.Amount,
Category = labRow.Category,
Date = labRow.Date,
Doc_id = labRow.Doc_id,
Weight = labRow.Weight,
PatientType = labRow.PatientType
};
allLabs.Add(currentlab);
}
return(allLabs);
}
public static List <Lab> LabsByPatient(string Name)
{
PatientTableAdapter taPatient = new PatientTableAdapter();
int pid = Convert.ToInt32(taPatient.GetPatientID(Name));
LabTableAdapter taPatientLab = new LabTableAdapter();
List <Lab> patientLabs = new List <Lab>();
var dtLabs = taPatientLab.GetLabsByPid(pid);
foreach (UltimateMedDB.Business.dsUltimateMedDB.LabRow labRow in dtLabs)
{
Lab currentLab = new Lab
{
Amount = labRow.Amount,
Category = labRow.Category,
Date = labRow.Date,
Doc_id = labRow.Doc_id,
PatientType = labRow.PatientType,
Weight = labRow.Weight
};
patientLabs.Add(currentLab);
}
return(patientLabs);
}