/// <summary> /// Select process method and sub method include get by patientId or assesssmentid /// </summary> /// <param name="assessmentId"></param> /// <returns></returns> private clsPatientModel GetByAssessmentId(int assessmentId) { clsPatientModel result = new clsPatientModel(); DataTable dataTable = new DataTable(); connect = new clsConnectorData(); connect.Link(); connect.con.Open(); connect.cmd.CommandText = clsQuery.GetAssessementEntryByAssessmentId; connect.cmd.Parameters.Add(new System.Data.OleDb.OleDbParameter("@assessment", assessmentId)); connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd); connect.dta.Fill(dataTable); connect.con.Close(); if (dataTable.Rows.Count > 0) { result.PatientId = Convert.ToInt32(dataTable.Rows[0][1]); result.Assessment = new List <clsAssessmentModel>() { new clsAssessmentModel() { AssessementId = Convert.ToInt32(dataTable.Rows[0][0]), AssessmentDate = Convert.ToDateTime(dataTable.Rows[0][2]) } }; } return(result); }
private void btnSearch_Click(object sender, EventArgs e) { try { patients = new List <clsPatientModel>(); appointment = new clsAppointment(); patientDetails = new clsPatientDetails(); DateTime from = Convert.ToDateTime(dpFrom.Value); DateTime to = Convert.ToDateTime(dpTo.Value); if ((from > to) || (from == to)) { throw new Exception("Invalid date"); } var patientsRow = appointment.Retrieve(); if (patientsRow.Count > 0) { foreach (var item in patientsRow) { item.PatientDetails = new clsPatientDetailsModel(); item.PatientDetails = patientDetails.GetByPatientId(item.PatientId); } } foreach (var item in patientsRow) { foreach (var appointment in item.Appointments) { if ((appointment.Appointment.Date >= from.Date) && (appointment.Appointment.Date <= to.Date)) { clsPatientModel sort = new clsPatientModel { PatientDetails = new clsPatientDetailsModel(), Appointments = new List <clsAppointmentModel>(), PatientId = item.PatientId }; sort.PatientDetails = item.PatientDetails; sort.Appointments.Add(appointment); patients.Add(sort); } } } AssignToGrid(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// Navigation /// </summary> private void Navigation() { if (selectedPatient == 0) { this.Close(); } patientDetail = new clsPatientDetails(); dateEntry = new clsDateEntry(); medicalRecord = new clsMedicalRecord(); assessment = new clsAssessment(); appointment = new clsAppointment(); prescription = new clsPrescription(); patient = new clsPatientModel() { Appointments = new List <clsAppointmentModel>(), Assessment = new List <clsAssessmentModel>(), DateEntry = new clsDateEntryModel(), MedicalRecords = new clsPatientMedicalRecordModel(), PatientDetails = new clsPatientDetailsModel(), PatientId = selectedPatient, Prescription = new clsPrescriptionModel() }; switch (navigateFrom) { case NavigationType.Appointments: case NavigationType.Patients: case NavigationType.Search: patient.PatientDetails = patientDetail.GetByPatientId(selectedPatient); patient.DateEntry = dateEntry.GetbyPatientId(selectedPatient); patient.MedicalRecords = medicalRecord.GetByPatientId(selectedPatient); patient.Prescription = prescription.GetByPatientId(selectedPatient); patient.Assessment = assessment.GetByPatientId(selectedPatient); patient.Appointments = appointment.GetByPatientId(selectedPatient); break; case NavigationType.NewPatient: break; case NavigationType.RnageOfMotion: break; case NavigationType.ViewPatient: break; default: break; } }
private void btnClear_Click(object sender, EventArgs e) { patient = new clsPatientModel() { Appointments = new List <clsAppointmentModel>(), Assessment = new List <clsAssessmentModel>(), DateEntry = new clsDateEntryModel(), MedicalRecords = new clsPatientMedicalRecordModel(), PatientDetails = new clsPatientDetailsModel(), PatientId = 0, Prescription = new clsPrescriptionModel() }; ///Patient details txtSurname.Clear(); txtName.Clear(); txtTel.Clear(); txtMobile1.Clear(); txtMobile2.Clear(); txtAge.Clear(); txtOccupation.Clear(); ///medical record txtDiagnosis.Clear(); txtBriefHistory.Clear(); txtPastMedicalHistory.Clear(); cbxSwelling.Checked = false; cbxTenderness.Checked = false; cbxSensation.Checked = false; txtSensation.Clear(); ///motion grdAssessement.DataSource = null; grdAssessement.Columns.Clear(); grdAssessement.Rows.Clear(); grdAssessement.DataBindings.Clear(); if (patient != null) { if (patient.Assessment != null) { patient.Assessment = new List <clsAssessmentModel>(); } } ///prescription txtAdvise.Clear(); txtPrescription.Clear(); }
public List <clsPatientModel> Retrieve() { List <clsPatientModel> result = new List <clsPatientModel>(); clsPatientModel data = new clsPatientModel(); DataTable dataTable = new DataTable(); connect = new clsConnectorData(); connect.Link(); connect.con.Open(); connect.cmd.CommandText = clsQuery.RetrievePatientDetails; connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd); connect.dta.Fill(dataTable); connect.con.Close(); if (dataTable != null || dataTable.Rows.Count > 0) { foreach (DataRow item in dataTable.Rows) { data = new clsPatientModel() { PatientId = Convert.ToInt32(item[0]), PatientDetails = new clsPatientDetailsModel() { Name = item[1].ToString(), Surname = item[2].ToString(), Tel = item[3].ToString(), Mobile1 = item[4].ToString(), Mobile2 = item[5].ToString(), DOB = string.IsNullOrWhiteSpace(item[6].ToString()) ? DateTime.Now : Convert.ToDateTime(item[6].ToString()), Age = string.IsNullOrWhiteSpace(item[7].ToString()) ? 0 : Convert.ToInt32(item[7].ToString()), Occupation = item[8].ToString() } }; result.Add(data); } } return(result); }
//private void xuiButton1_Click(object sender, EventArgs e) //{ // RangeOfMotion range = new RangeOfMotion(this, NavigationType.Appointments); // range.ShowDialog(); //} //public void SetLabel(string label) //{ // //lblTest.Text = label; //} private void RetrieveTodayAppointment() { patients = new List <clsPatientModel>(); appointment = new clsAppointment(); patientDetails = new clsPatientDetails(); var patientsRow = appointment.Retrieve(); if (patientsRow.Count > 0) { foreach (var item in patientsRow) { item.PatientDetails = new clsPatientDetailsModel(); item.PatientDetails = patientDetails.GetByPatientId(item.PatientId); } } foreach (var item in patientsRow) { foreach (var appointment in item.Appointments) { if (appointment.Appointment.Date == DateTime.Today.Date) { clsPatientModel sort = new clsPatientModel { PatientDetails = new clsPatientDetailsModel(), Appointments = new List <clsAppointmentModel>(), PatientId = item.PatientId }; sort.PatientDetails = item.PatientDetails; sort.Appointments.Add(appointment); patients.Add(sort); } } } }
public List <clsPatientModel> Retrieve() { List <clsPatientModel> result = new List <clsPatientModel>(); DataTable dataTable = new DataTable(); connect = new clsConnectorData(); connect.Link(); connect.con.Open(); connect.cmd.CommandText = clsQuery.RetrieveAppointment; connect.dta = new System.Data.OleDb.OleDbDataAdapter(connect.cmd); connect.dta.Fill(dataTable); connect.con.Close(); if (dataTable != null || dataTable.Rows.Count > 0) { foreach (DataRow item in dataTable.Rows) { clsPatientModel patient = new clsPatientModel() { PatientId = Convert.ToInt32(item[1]), Appointments = new List <clsAppointmentModel>() { new clsAppointmentModel() { AppointmentId = Convert.ToInt32(item[0]), HasAppointment = true, Appointment = Convert.ToDateTime(item[2]) } } }; result.Add(patient); } } return(result); }