private void PTestsButton_Click(object sender, EventArgs e) { int id = DbConnector.GetInstance().GetPatientProfile(PatientBox.Text).id; string query = String.Format(@"select distinct testtype.name, test.date_time as 'date', test.result as result from test inner join (select medical_card.id from medical_card inner join patient on medical_card.patient_id = {0}) as mc on test.card_id = mc.id inner join testtype on testtype.id = test.id;", id); Form f = new Form(); ReportWindow w = new ReportWindow("Tests of " + PatientBox.Text, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }
private void DSessionsButton_Click(object sender, EventArgs e) { int id = DbConnector.GetInstance().GetEmployeeProfile(DoctorBox.Text).id; string query = String.Format(@"select session.date_time as 'date', proc.name as 'procedure', mc.disease_name as 'disease name', employee.name as 'doctor' , session.total_cost as 'cost' from session inner join employee on session.employee_id = {0} inner join proc on proc.id = session.proc_id inner join medical_card as mc on mc.id = session.card_id;", id); Form f = new Form(); ReportWindow w = new ReportWindow("Procedure sessions by " + DoctorBox.Text, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }
private void PSurveysButton_Click(object sender, EventArgs e) { int id = DbConnector.GetInstance().GetPatientProfile(PatientBox.Text).id; string query = String.Format(@"select distinct surveytype.name as 'survey name', mc.disease_name as disease, survey.result,survey.date_time as 'survey date',employee.name as doctor from survey inner join employee on employee.id = survey.employee_id inner join (select medical_card.id,medical_card.disease_name from medical_card inner join patient on medical_card.patient_id ={0}) as mc on survey.card_id = mc.id inner join surveytype on surveytype.id=survey.type_id;", id); Form f = new Form(); ReportWindow w = new ReportWindow("Surveys of " + PatientBox.Text, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }
private void PSessionsButton_Click(object sender, EventArgs e) { int id = DbConnector.GetInstance().GetPatientProfile(PatientBox.Text).id; string query = String.Format(@"select distinct mc.disease_name as 'disease', diseasetype.name as 'disease type', session.date_time as 'session date',proc.name as 'procedure', employee.name as doctor, session.total_cost as 'cost' from session inner join proc on proc.id=session.proc_id inner join employee on employee.id = session.employee_id inner join (select medical_card.id,medical_card.disease_name,medical_card.type_id from medical_card inner join patient on medical_card.patient_id = {0}) as mc on session.card_id = mc.id inner join diseasetype on diseasetype.id = mc.type_id;" , id); Form f = new Form(); ReportWindow w = new ReportWindow("Sessions of " + PatientBox.Text, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }
private void TestConfirmButton_Click(object sender, EventArgs e) { string startDate = TestStartPicker.Value.ToString("yyyy-MM-dd"); string endDate = TestEndPicker.Value.ToString("yyyy-MM-dd"); string query = string.Format(@"select testtype.name as 'test name', test.date_time as 'date', test.result, mc.disease_name as 'suffered disease', mc.name as 'patient' from test inner join (select medical_card.disease_name, medical_card.id,patient.name from medical_card inner join patient on patient.id=medical_card.patient_id) as mc on mc.id = test.card_id inner join testtype on testtype.id = test.type_id where date_format(test.date_time,'%Y-%m-%d')>=Date('{0}') and date_format(test.date_time,'%Y-%m-%d')<=Date('{1}');", startDate, endDate); Form f = new Form(); ReportWindow w = new ReportWindow("Tests made from " + startDate + " to " + endDate, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }
private void SurveysConfirmButton_Click(object sender, EventArgs e) { string startDate = SurveyStartPicker.Value.ToString("yyyy-MM-dd"); string endDate = SurveyEndPicker.Value.ToString("yyyy-MM-dd"); string query = string.Format(@"select distinct surveytype.name as 'survey name', mc.disease_name as disease, survey.result,survey.date_time as 'survey date',mc.name as 'patient',employee.name as 'doctor' from survey inner join employee on survey.employee_id = employee.id inner join (select medical_card.id,medical_card.disease_name,patient.name from medical_card inner join patient on medical_card.patient_id = patient.id) as mc on survey.card_id = mc.id inner join surveytype on surveytype.id=survey.type_id where date_format(survey.date_time,'%Y-%m-%d')>=('{0}') and date_format(survey.date_time,'%Y-%m-%d')<=('{1}');", startDate, endDate); Form f = new Form(); ReportWindow w = new ReportWindow("Surveys made from " + startDate + " to " + endDate, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }
private void SessionsConfirmButton_Click(object sender, EventArgs e) { string startDate = SessionStartPicker.Value.ToString("yyyy-MM-dd"); string endDate = SessionEndPicker.Value.ToString("yyyy-MM-dd"); string query = string.Format(@"select proc.name as 'procedure', session.date_time as 'date', mc.disease_name as 'treated disease' , employee.name as 'doctor',mc.name as 'patient', session.total_cost as 'cost' from session inner join employee on employee.id = session.employee_id inner join proc on proc.id = session.proc_id inner join (select medical_card.disease_name, medical_card.id,patient.name from medical_card inner join patient on patient.id = medical_card.patient_id) as mc on mc.id = session.card_id where date_format(session.date_time,'%Y-%m-%d')>=('{0}') and date_format(session.date_time,'%Y-%m-%d')<=('{1}');", startDate, endDate); Form f = new Form(); ReportWindow w = new ReportWindow("Procedure sessions made from " + startDate + " to " + endDate, query); f.Controls.Add(w); f.Size = w.Size; f.Show(); }