예제 #1
0
        /*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);
        }
예제 #2
0
        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);
        }
예제 #3
0
        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);
        }