public int try1()
{
try
{
dtReferenceDoctor = dc.getData("GetPatientDoctor", dictionary);
int a = int.Parse(dtReferenceDoctor.Rows[0][0].ToString());
return(a);
}
catch
{
int a = 0;
return(a);
}
}
private void PatientAssesment_Load(object sender, EventArgs e)
{
DatabaseConnector dc = new DatabaseConnector();
dictionary = createGetPatientDictionary(PatientAssesmentPatientId);
dtPatient = dc.getData("GetPatient", dictionary);
label11.Text = dtPatient.Rows[0][0].ToString();
String regDate = dtPatient.Rows[0][1].ToString();
DateTime dte1 = Convert.ToDateTime(regDate);
label13.Text = dte1.Year.ToString() + "-" + dte1.Month + "-" + dte1.Day;
label5.Text = dtPatient.Rows[0][2].ToString();
label4.Text = dtPatient.Rows[0][3].ToString();
String dob = dtPatient.Rows[0][4].ToString();
DateTime dte2 = Convert.ToDateTime(dob);
label8.Text = dte2.Year.ToString() + "-" + dte2.Month + "-" + dte2.Day;
label9.Text = dtPatient.Rows[0][5].ToString();
textBox1.Enabled = false;
txt_cheifcomplaint.Enabled = false;
this.getPatientEMRDatesTableAdapter.Fill(dataSetGetEMRDatesIntoComboBox.GetPatientEMRDates, patid);
}
private void PatientAssesment_Load(object sender, EventArgs e)
{
DatabaseConnector dc = new DatabaseConnector();
dictionary = createGetPatientDictionary(PatientAssesmentPatientId);
dtPatient = dc.getData("GetPatient", dictionary);
label11.Text = dtPatient.Rows[0][0].ToString();
String regDate = dtPatient.Rows[0][1].ToString();
DateTime dte1 = Convert.ToDateTime(regDate);
label13.Text = dte1.Year.ToString() + "-" + dte1.Month + "-" + dte1.Day;
label5.Text = dtPatient.Rows[0][2].ToString();
label4.Text = dtPatient.Rows[0][3].ToString();
String dob = dtPatient.Rows[0][4].ToString();
DateTime dte2 = Convert.ToDateTime(dob);
label8.Text = dte2.Year.ToString() + "-" + dte2.Month + "-" + dte2.Day;
label9.Text = dtPatient.Rows[0][5].ToString();
textBox1.Enabled = false;
txt_cheifcomplaint.Enabled = false;
this.getPatientEMRDatesTableAdapter.Fill(dataSetGetEMRDatesIntoComboBox.GetPatientEMRDates, patid);
}
public DataTable getPatientEMRAccordingToDate(Dictionary <String, String> dict, DatabaseConnector conn)
{
DataTable dataTable;
dataTable = conn.getData("GetPatientEMRAccordingToDate", dict);
return(dataTable);
}
public void getEmployees()
{
Dictionary <String, String> param = new Dictionary <string, string>();
DatabaseConnector dconn = new DatabaseConnector();
EmployeeTable = dconn.getData("getEmployees", param);
}
private void CreateDemForm_Load(object sender, EventArgs e)
{
dictionary = new Dictionary <string, string>();
dictionary.Add("@patientId", patientId.ToString());
dc = new DatabaseConnector();
dtPatient = dc.getData("GetPatient", dictionary);
dtPatientEmail = dc.getData("GetPatientEmail", dictionary);
dtPatientAddress = dc.getData("GetPatientAddress", dictionary);
dtPatientPhone = dc.getData("GetPatientPhone", dictionary);
dtReferenceDoctor = dc.getData("GetPatientDoctor", dictionary);
dtAllergy = dc.getData("GetAllery", dictionary);
dtPatientAddress = dc.getData("GetPatientAddress", dictionary);
dtInsurance = dc.getData("GetPatientOHIPInsurance", dictionary);
txtLname.Text = dtPatient.Rows[0][2].ToString();
txtFname.Text = dtPatient.Rows[0][3].ToString();
string sourceDateTex = dtPatient.Rows[0][4].ToString();
DateTime dt = Convert.ToDateTime(sourceDateTex);
sourceDateTex = dt.Year.ToString() + "/" + dt.Month + "/" + dt.Day;
patDob.Text = sourceDateTex;
cmbGender.Text = dtPatient.Rows[0][5].ToString();
txtRefDoctor.Text = dtReferenceDoctor.Rows[0][0].ToString();
txtBillingCode.Text = dtReferenceDoctor.Rows[0][1].ToString();
txtAlergyName.Text = dtAllergy.Rows[0][1].ToString();
txtAlergyCategory.Text = dtAllergy.Rows[0][2].ToString();
txtInsNum.Text = dtInsurance.Rows[0][2].ToString();
txtInsVersion.Text = dtInsurance.Rows[0][3].ToString();
string sourceDateText = dtInsurance.Rows[0][4].ToString();
DateTime dte = Convert.ToDateTime(sourceDateText);
sourceDateText = dte.Year.ToString() + "/" + dte.Month + "/" + dte.Day;
txtExpDate.Text = sourceDateText;
cmbAddType.Text = dtPatientAddress.Rows[0][2].ToString();
txtAdd.Text = dtPatientAddress.Rows[0][3].ToString();
txtCity.Text = dtPatientAddress.Rows[0][4].ToString();
txtProvince.Text = dtPatientAddress.Rows[0][5].ToString();
txtPostalCode.Text = dtPatientAddress.Rows[0][6].ToString();
txtCountry.Text = dtPatientAddress.Rows[0][7].ToString();
txtPhone.Text = dtPatientPhone.Rows[0][3].ToString();
cmbPhoneType.Text = dtPatientPhone.Rows[0][2].ToString();
txtEmail.Text = dtPatientEmail.Rows[0][3].ToString();
cmbEmailType.Text = dtPatientEmail.Rows[0][2].ToString();
}
private void getAllDoctors(String Date) {
Dictionary<String, String> param = new Dictionary<string, string>();
param.Add("date", Date);
DatabaseConnector dconn = new DatabaseConnector();
doctors = dconn.getData("getAllDoctor2", param);
cmbDoctor.DataSource = doctors;
cmbDoctor.DisplayMember = "doctorName";
cmbDoctor.ValueMember = "doctorID";
}
public void editEmployee(String employeeID, String UserName, String Password, String Role, String FirstName, String LastName, String Gender)
{
// more error checking needed
if (String.IsNullOrEmpty(employeeID))
{
throw new System.ArgumentNullException("employeeID");
}
else if (String.IsNullOrEmpty(UserName))
{
throw new System.ArgumentNullException("User Name");
}
else if (String.IsNullOrEmpty(Password))
{
throw new System.ArgumentNullException("Password");
}
if (String.IsNullOrEmpty(Role))
{
throw new System.ArgumentNullException("Role");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("First Name");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("Last Name");
}
else
{
Dictionary <String, String> param = new Dictionary <string, string>();
param.Add("employeeID", employeeID);
param.Add("userName", UserName);
param.Add("role", Role);
param.Add("firstName", FirstName);
param.Add("lastName", LastName);
param.Add("gender", Gender);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("editEmployee", param);
if (!String.IsNullOrEmpty(Password))
{
Password = Encrypt.MD5(Password);
param = new Dictionary <string, string>();
param.Add("employeeID", employeeID);
param.Add("password", Password);
dconn = new DatabaseConnector();
results = dconn.getData("editEmployeePassword", param);
}
}
}
public void addToSchedule(String ScheduleID, String DoctorID, String DoctorName, String Date, String PatientID, String LastName, String FirstName)
{
Dictionary<String, String> param = new Dictionary<string, string>();
param.Add("scheduleID", ScheduleID);
param.Add("doctorID", DoctorID);
param.Add("doctorName", DoctorName);
param.Add("date", Date);
param.Add("patientID", PatientID);
param.Add("lastName", LastName);
param.Add("firstName", FirstName);
DatabaseConnector dconn = new DatabaseConnector();
DataTable result = dconn.getData("addToSchedule", param);
}
private void getAllDoctors(String Date)
{
Dictionary <String, String> param = new Dictionary <string, string>();
param.Add("date", Date);
DatabaseConnector dconn = new DatabaseConnector();
doctors = dconn.getData("getAllDoctor2", param);
cmbDoctor.DataSource = doctors;
cmbDoctor.DisplayMember = "doctorName";
cmbDoctor.ValueMember = "doctorID";
}
private void btn_Save_Click(object sender, EventArgs e)
{
Dictionary <String, String> dict = new Dictionary <string, string>();
dict.Add("@patientID", patId.ToString());
DatabaseConnector dc = new DatabaseConnector();
DataTable dtPatient = dc.getData("try1", dict);
docID = int.Parse(dtPatient.Rows[0][0].ToString());
String myDiag = comboBox1.Text;
Dictionary <String, String> dic = new Dictionary <string, string>();
dic.Add("@diagnosisId", myDiag);
dic.Add("@patId", patId.ToString());
//string fromFormat = "yyyy/mm/dd";
//DateTime newDate = DateTime.ParseExact(System.DateTime.Today.ToShortDateString(), fromFormat, null);
;
string[] formats = { "MM/dd/yyyy" };
DateTime parsedDateTime;
DateTime.TryParseExact(System.DateTime.Today.ToShortDateString(), formats, new CultureInfo("en-US"),
DateTimeStyles.None, out parsedDateTime);
dic.Add("@myTodays", "2012/12/12");
dic.Add("@docId", docID.ToString());
dc.getData("SaveEMRDaignosis", dic);
}
public void addToSchedule(String ScheduleID, String DoctorID, String DoctorName, String Date, String PatientID, String LastName, String FirstName)
{
Dictionary <String, String> param = new Dictionary <string, string>();
param.Add("scheduleID", ScheduleID);
param.Add("doctorID", DoctorID);
param.Add("doctorName", DoctorName);
param.Add("date", Date);
param.Add("patientID", PatientID);
param.Add("lastName", LastName);
param.Add("firstName", FirstName);
DatabaseConnector dconn = new DatabaseConnector();
DataTable result = dconn.getData("addToSchedule", param);
}
public void deleteEmployee(String employeeID)
{
if (String.IsNullOrEmpty(employeeID))
{
throw new System.ArgumentNullException("employeeID");
}
else
{
Dictionary <String, String> param = new Dictionary <string, string>();
param.Add("employeeID", employeeID);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("deleteEmployee", param);
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
dc = new DatabaseConnector();
DateTime d = DateTime.Today;
dic = new Dictionary <string, string>();
dic.Add("@patientId", patId.ToString());
dtDoctor = dc.getData("try1", dic);
docId = int.Parse(dtDoctor.Rows[0][0].ToString());
dictionary = new Dictionary <string, string>();
dictionary.Add("@patientId", patId.ToString());
dictionary.Add("@doctorId", docId.ToString());
dictionary.Add("@timestamp", d.ToShortDateString());// if you need date time please convert d.ToString()
//d.ToShortDateString()
//dictionary.Add("@patientId", patientId.ToString());
dictionary.Add("@blooppressure", txt_Bp.Text);
dictionary.Add("@respiratoryrate", txt_Rr.Text);
dictionary.Add("@pulserate ", txt_Pr.Text);
dictionary.Add("@temperature", txt_temp.Text);
dictionary.Add("@height", txt_Height.Text);
dictionary.Add("@weight", txt_Weight.Text);
dictionary.Add("@painscale", txt_PainScale.Text);
dictionary.Add("@clinicalimpression", txt_Clinical.Text);
dictionary.Add("@chiefcomplaint", txt_cheifcomplaint.Text);
dc.getData("EnterAssesment", dictionary);
MessageBox.Show("Record Saved Successfully");
}
catch
{
MessageBox.Show("Failed to save record please check if the patient is already been assessed");
}
}
public Dictionary<String, String> getEmployee(String employeeID)
{
Dictionary<String, String> param = new Dictionary<string, string>();
param.Add("employeeID", employeeID);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("getEmployeeByID", param);
Dictionary<String, String> r = new Dictionary<string, string>();
r.Add("userName", results.Rows[0]["userName"].ToString());
r.Add("role", results.Rows[0]["role"].ToString());
r.Add("firstName", results.Rows[0]["firstName"].ToString());
r.Add("lastName", results.Rows[0]["lastName"].ToString());
r.Add("gender", results.Rows[0]["gender"].ToString());
return r;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
String myDiag = comboBox1.Text;
Dictionary <String, String> dic = new Dictionary <string, string>();
dic.Add("@myDaignosisName", myDiag);
DatabaseConnector dc = new DatabaseConnector();
DataTable dtPatient = dc.getData("GetDaignosisDescription", dic);
if (dtPatient.Rows.Count > 0)
{
txt_DiagnosisDescription.Text = dtPatient.Rows[0][0].ToString();
}
}
private int getDoctorIdfromDoctorTbl1()
{
try
{
dictionary = new Dictionary <string, string>();
dictionary.Add("@billingCode", txtDoctorBillingCode.Text);
dc = new DatabaseConnector();
dtDoctor = dc.getData("GetDoctorID1", dictionary);
int doctorID = int.Parse(dtDoctor.Rows[0][0].ToString());
return(doctorID);
}
catch
{
int doctorID = 0;
return(doctorID);
}
}
private int getAllergyIdfromAllergyTbl1()
{
try
{
dictionary = new Dictionary <string, string>();
dictionary.Add("@allergyName", txtAllergyName.Text);
dc = new DatabaseConnector();
dtAllergy = dc.getData("GetAllergyID1", dictionary);
int allergyID = int.Parse(dtAllergy.Rows[0][0].ToString());
return(allergyID);
}
catch
{
int allergyID = 0;
return(allergyID);
}
}
public Dictionary <String, String> getEmployee(String employeeID)
{
Dictionary <String, String> param = new Dictionary <string, string>();
param.Add("employeeID", employeeID);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("getEmployeeByID", param);
Dictionary <String, String> r = new Dictionary <string, string>();
r.Add("userName", results.Rows[0]["userName"].ToString());
r.Add("role", results.Rows[0]["role"].ToString());
r.Add("firstName", results.Rows[0]["firstName"].ToString());
r.Add("lastName", results.Rows[0]["lastName"].ToString());
r.Add("gender", results.Rows[0]["gender"].ToString());
return(r);
}
public void addEmployee(String UserName, String Password, String HireDate, String Role, String FirstName, String LastName, String DateOfBirth, String Gender)
{
// error checking needed
if (String.IsNullOrEmpty(UserName))
{
throw new System.ArgumentNullException("User Name");
}
else if (String.IsNullOrEmpty(Password))
{
throw new System.ArgumentNullException("Password");
}
if (String.IsNullOrEmpty(Role))
{
throw new System.ArgumentNullException("Role");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("First Name");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("Last Name");
}
else
{
Password = Encrypt.MD5(Password);
Dictionary<String, String> param = new Dictionary<string, string>();
param.Add("userName", UserName);
param.Add("password", Password);
param.Add("hireDate", HireDate);
param.Add("role", Role);
param.Add("firstName", FirstName);
param.Add("lastName", LastName);
param.Add("dateOfBirth", DateOfBirth);
param.Add("gender", Gender);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("addEmployee", param);
}
}
public void addEmployee(String UserName, String Password, String HireDate, String Role, String FirstName, String LastName, String DateOfBirth, String Gender)
{
// error checking needed
if (String.IsNullOrEmpty(UserName))
{
throw new System.ArgumentNullException("User Name");
}
else if (String.IsNullOrEmpty(Password))
{
throw new System.ArgumentNullException("Password");
}
if (String.IsNullOrEmpty(Role))
{
throw new System.ArgumentNullException("Role");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("First Name");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("Last Name");
}
else
{
Password = Encrypt.MD5(Password);
Dictionary <String, String> param = new Dictionary <string, string>();
param.Add("userName", UserName);
param.Add("password", Password);
param.Add("hireDate", HireDate);
param.Add("role", Role);
param.Add("firstName", FirstName);
param.Add("lastName", LastName);
param.Add("dateOfBirth", DateOfBirth);
param.Add("gender", Gender);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("addEmployee", param);
}
}
public void Login(String UserName, String Password)
{
if (String.IsNullOrEmpty(UserName))
{
throw new System.ArgumentNullException("UserName");
}
else if (String.IsNullOrEmpty(Password))
{
throw new System.ArgumentNullException("Password");
}
else {
Password = Encrypt.MD5(Password);
Dictionary<String, String> param = new Dictionary<string,string>();
param.Add("userName", UserName);
DatabaseConnector dconn = new DatabaseConnector();
DataTable result = dconn.getData("getEmployeeByUser", param);
if (result.Rows.Count == 1)
{
String p = result.Rows[0]["password"].ToString();
if (Object.Equals(p, Password))
{
ID = (int)result.Rows[0]["employeeID"];
Role = (int)result.Rows[0]["role"];
FirstName = result.Rows[0]["firstName"].ToString();
LastName = result.Rows[0]["lastName"].ToString();
}
else
{
throw new System.ArgumentException("Passwords do not match.");
}
}
else
{
throw new System.ArgumentException("UserName does not exist in system.");
}
}
}
private void btn_update_Click(object sender, EventArgs e)
{
String errors = checkErrors(txtFname.Text, txtLname.Text, txtInsNum.Text, txtInsVersion.Text);
if (errors != null)
{
MessageBox.Show(errors);
}
else
{
dictionary = createUpdatePatientDictionary(patientId.ToString(), txtFname.Text, txtLname.Text, patDob.Text, cmbGender.Text);
dc.getData("UpdatePatient", dictionary);
dictionary = createUpdateInsuranceDictionary(patientId.ToString(), txtInsNum.Text, txtInsVersion.Text, txtExpDate.Text);
dc.getData("UpdateInsurance", dictionary);
dictionary = createUpdatePatientAllergyDictionary(patientId.ToString(), "0", txtAlergyName.Text, txtAlergyCategory.Text);
dc.getData("updatePatientAllergy", dictionary);
dictionary = createUpdatePatientReferalDoctorDictionary(patientId.ToString(), "0", txtRefDoctor.Text, txtBillingCode.Text);
dc.getData("updatePatientDoctor", dictionary);
dictionary = createUpdatePatientPhoneDictionary(patientId.ToString(), txtPhone.Text, cmbPhoneType.Text);
dc.getData("UpdatePatientPhone", dictionary);
dictionary = createUpdatePatientEmailDictionary(patientId.ToString(), txtEmail.Text, cmbEmailType.Text);
dc.getData("UpdatePatientEmail", dictionary);
dictionary = createUpdatePatientAddressDictionary(patientId.ToString(), cmbAddType.Text, txtAdd.Text, txtCity.Text, txtProvince.Text, txtPostalCode.Text, txtCountry.Text);
dc.getData("UpdatePatientAddress", dictionary);
MessageBox.Show("Patient Update Successful!!");
forEdit = false;
BtnEditDemo.Show();
enableFields();
btn_update.Hide();
}
}
private void EnterAssesment_Load(object sender, EventArgs e)
{
dc = new DatabaseConnector();
dictionary = new Dictionary <string, string>();
// patId = int.Parse();
dictionary.Add("@patientId", patId.ToString());
dtPatient = dc.getData("GetPatient", dictionary);
label11.Text = dtPatient.Rows[0][0].ToString();
String regDate = dtPatient.Rows[0][1].ToString();
DateTime dte1 = Convert.ToDateTime(regDate);
label13.Text = dte1.Year.ToString() + "-" + dte1.Month + "-" + dte1.Day;
label5.Text = dtPatient.Rows[0][2].ToString();
label4.Text = dtPatient.Rows[0][3].ToString();
String dob = dtPatient.Rows[0][4].ToString();
DateTime dte2 = Convert.ToDateTime(dob);
label8.Text = dte2.Year.ToString() + "-" + dte2.Month + "-" + dte2.Day;
label9.Text = dtPatient.Rows[0][5].ToString();
}
private int getDoctorIdfromDoctorTbl1()
{
try
{
dictionary = new Dictionary<string, string>();
dictionary.Add("@billingCode", txtDoctorBillingCode.Text);
dc = new DatabaseConnector();
dtDoctor = dc.getData("GetDoctorID1", dictionary);
int doctorID = int.Parse(dtDoctor.Rows[0][0].ToString());
return doctorID;
}
catch
{
int doctorID = 0;
return doctorID;
}
}
public void editEmployee(String employeeID, String UserName, String Password, String Role, String FirstName, String LastName, String Gender)
{
// more error checking needed
if (String.IsNullOrEmpty(employeeID))
{
throw new System.ArgumentNullException("employeeID");
}
else if (String.IsNullOrEmpty(UserName))
{
throw new System.ArgumentNullException("User Name");
}
else if (String.IsNullOrEmpty(Password))
{
throw new System.ArgumentNullException("Password");
}
if (String.IsNullOrEmpty(Role))
{
throw new System.ArgumentNullException("Role");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("First Name");
}
else if (String.IsNullOrEmpty(FirstName))
{
throw new System.ArgumentNullException("Last Name");
}
else
{
Dictionary<String, String> param = new Dictionary<string, string>();
param.Add("employeeID", employeeID);
param.Add("userName", UserName);
param.Add("role", Role);
param.Add("firstName", FirstName);
param.Add("lastName", LastName);
param.Add("gender", Gender);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("editEmployee", param);
if (!String.IsNullOrEmpty(Password))
{
Password = Encrypt.MD5(Password);
param = new Dictionary<string, string>();
param.Add("employeeID", employeeID);
param.Add("password", Password);
dconn = new DatabaseConnector();
results = dconn.getData("editEmployeePassword", param);
}
}
}
public void getEmployees()
{
Dictionary<String, String> param = new Dictionary<string,string>();
DatabaseConnector dconn = new DatabaseConnector();
EmployeeTable = dconn.getData("getEmployees", param);
}
public void deleteEmployee(String employeeID)
{
if (String.IsNullOrEmpty(employeeID))
{
throw new System.ArgumentNullException("employeeID");
}
else
{
Dictionary<String, String> param = new Dictionary<string, string>();
param.Add("employeeID", employeeID);
DatabaseConnector dconn = new DatabaseConnector();
DataTable results = dconn.getData("deleteEmployee", param);
}
}
public DataTable createGetPatient(Dictionary <String, String> dic)
{
DataTable dTab = dc.getData("GetPatient", dic);
return(dTab);
}
private void ViewDemography_Load(object sender, EventArgs e)
{
dictionary = createDictionary(patientId.ToString());
dc = new DatabaseConnector();
dtPatient = dc.getData("GetPatient", dictionary);
dtPatientEmail = dc.getData("GetPatientEmail", dictionary);
dtPatientAddress = dc.getData("GetPatientAddress", dictionary);
dtPatientPhone = dc.getData("GetPatientPhone", dictionary);
dtReferenceDoctor = dc.getData("GetPatientDoctor", dictionary);
dtAllergy = dc.getData("GetAllery", dictionary);
dtInsurance = dc.getData("GetPatientOHIPInsurance", dictionary);
lblLastName.Text = dtPatient.Rows[0][2].ToString();
lblFirstName.Text = dtPatient.Rows[0][3].ToString();
string dob = dtPatient.Rows[0][4].ToString();
DateTime dt = Convert.ToDateTime(dob);
dob = dt.Year.ToString() + "-" + dt.Month + "-" + dt.Day;
lblDOB.Text = dob;
lblGender.Text = dtPatient.Rows[0][5].ToString();
lblPatientID.Text = patientId.ToString();
if (try1() != 0)
{
lblReferralDoctor.Text = dtReferenceDoctor.Rows[0][2].ToString();
lblBillingCode.Text = dtReferenceDoctor.Rows[0][1].ToString();
}
if (try2() != 0)
{
lblAllergyName.Text = dtAllergy.Rows[0][1].ToString();
lblAllergyCategory.Text = dtAllergy.Rows[0][2].ToString();
}
lblInsNo.Text = dtInsurance.Rows[0][2].ToString() + " " + dtInsurance.Rows[0][3].ToString();
string date = dtInsurance.Rows[0][4].ToString();
DateTime edt = Convert.ToDateTime(date);
date = edt.Year.ToString() + "-" + edt.Month + "-" + edt.Day;
lblExpDate.Text = date;
if (try3() != 0)
{
lblAddressType.Text = dtPatientAddress.Rows[0][2].ToString();
lblAddress.Text = dtPatientAddress.Rows[0][3].ToString();
lblCity.Text = dtPatientAddress.Rows[0][4].ToString();
lblProvince.Text = dtPatientAddress.Rows[0][5].ToString();
lblPostalCode.Text = dtPatientAddress.Rows[0][6].ToString();
}
if (try4() != 0)
{
lblPhone.Text = dtPatientPhone.Rows[0][3].ToString();
lblPhoneType.Text = dtPatientPhone.Rows[0][2].ToString();
}
if (try5() != 0)
{
lblEmailType.Text = dtPatientEmail.Rows[0][2].ToString();
lblEmail.Text = dtPatientEmail.Rows[0][3].ToString();
}
}
private void btnAddRecord_Click(object sender, EventArgs e)
{
bool DOB_valid;
bool exp_valid;
bool pass = false;
//check whether Insurance numer exits
dictionary = new Dictionary <string, string>();
dictionary.Add("@insuranceNumber", txtInsuranceNumber.Text);
dc = new DatabaseConnector();
dtInsurance = dc.getData("CheckInsuranceExists", dictionary);
int ins_exist = int.Parse(dtInsurance.Rows[0][0].ToString());
//create new patient
Patient patient = new Patient();
patient.firstName = txtFirstName.Text;
patient.lastName = txtLastName.Text;
patient.dob = txtDOB.Text;
patient.gender = cmbxGender.GetItemText(cmbxGender.SelectedItem);
//create new insurance
Insurance insurance = new Insurance();
insurance.timestamp = System.DateTime.Today.ToShortDateString();
insurance.insNumber = txtInsuranceNumber.Text;
insurance.versionCode = txtVersionCode.Text;
insurance.expDate = txtInsuranceExpDate.Text;
//create new allergy
Allergy allergy = new Allergy();
allergy.name = txtAllergyName.Text;
allergy.category = txtAllergyCatergory.Text;
//create new allergy-patient
PatientAllergy ptAllgergy = new PatientAllergy();
//
Doctor doctor = new Doctor();
doctor.billingCode = txtDoctorBillingCode.Text;
doctor.name = txtReferralDoctor.Text;
//
ReferralDoctor refDoctor = new ReferralDoctor();
//ins number : number only
//ins vc : character only
//no blank: name, dob
Phone phone = new Phone();
phone.type = cmbxPhoneType.GetItemText(cmbxPhoneType.SelectedItem);
phone.phoneNumber = txtPhoneNumber.Text;
Email email = new Email();
email.type = cmbxEmailType.GetItemText(cmbxEmailType.SelectedItem);
email.email = txtEmail.Text;
Address address = new Address();
address.type = cmbxAddressType.GetItemText(cmbxAddressType.SelectedItem);
address.address = txtAddress.Text;
address.city = txtCity.Text;
address.province = txtProvince.Text;
address.postalCode = txtPostalCode.Text;
DOB_valid = DOB_validation();
exp_valid = exp_validation();
if (DOB_valid == true && exp_valid == true && ins_exist == 0 && txtInsuranceNumber.TextLength == 10)
{
pass = true;
}
if (pass == true)
{
insertPatient(patient);
patient.patientID = getPtIdfromPatienTbl();
insurance.patientID = patient.patientID;
phone.patientID = patient.patientID;
email.patientID = patient.patientID;
address.patientID = patient.patientID;
insertInsurance(insurance);
if (txtAllergyCatergory.Text != "" && txtAllergyName.Text != "")
{
if (getAllergyIdfromAllergyTbl1() != 0)
{
ptAllgergy.patientId = patient.patientID;
ptAllgergy.allergyId = getAllergyIdfromAllergyTbl1();
insertPatientAllergy(ptAllgergy);
}
else
{
insertAllergy(allergy);
ptAllgergy.patientId = patient.patientID;
ptAllgergy.allergyId = getAllergyIdfromAllergyTbl2();
insertPatientAllergy(ptAllgergy);
}
}
if (txtPhoneNumber.Text != "")
{
insertPhone(phone);
}
if (txtAddress.Text != "")
{
insertAdress(address);
}
if (txtEmail.Text != "")
{
insertEmail(email);
}
if (txtReferralDoctor.Text != "")
{
refDoctor.patientID = patient.patientID;
refDoctor.doctorID = getDoctorIdfromDoctorTbl1();
insertReferralDoctor(refDoctor);
}
/* if (txtDoctorBillingCode.Text != "" && txtReferralDoctor.Text != "")
* {
*
* if (getDoctorIdfromDoctorTbl1() != 0)
* {
* refDoctor.patientID = patient.patientID;
* refDoctor.doctorID = getDoctorIdfromDoctorTbl1();
* insertReferralDoctor(refDoctor);
* }
* else
* {
* insertDoctor(doctor);
* refDoctor.patientID = patient.patientID;
* refDoctor.doctorID = getDoctorIdfromDoctorTbl2();
* insertReferralDoctor(refDoctor);
* }
* }*/
clearText();
MessageBox.Show("Patient was registed");
DialogResult result = MessageBox.Show("Go to patient demography?", "Patient registed", MessageBoxButtons.OKCancel,
MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
this.Hide();
ViewDemography viewDemo = new ViewDemography();
viewDemo.patientId = patient.patientID;
viewDemo.Show();
}
else if (result == DialogResult.Cancel)
{
this.Close();
}
}
else if (txtInsuranceNumber.TextLength != 10) //number incorrect of left blank
{
MessageBox.Show("Please insert correct insurance number");
}
else if (ins_exist != 0)
{
MessageBox.Show("Insurance Number already exists");
}
else if (DOB_valid == false)
{
MessageBox.Show("D.O.B not valid");
}
else if (exp_valid == false)
{
MessageBox.Show("Insurance Expiry Date not valid");
}
}
public DataTable checkPatientExists(Dictionary <String, String> dic)
{
DataTable dTab = dc.getData("CheckPatientExists", dic);
return(dTab);
}
public DataTable createGetDoctorDaySchedule(Dictionary <String, String> dic)
{
DataTable dTab = dc.getData("GetDoctorDaySchedule", dic);
return(dTab);
}
private void ViewDemography_Load(object sender, EventArgs e)
{
dictionary = createDictionary(patientId.ToString());
dc = new DatabaseConnector();
dtPatient = dc.getData("GetPatient", dictionary);
dtPatientEmail = dc.getData("GetPatientEmail", dictionary);
dtPatientAddress = dc.getData("GetPatientAddress", dictionary);
dtPatientPhone = dc.getData("GetPatientPhone", dictionary);
dtReferenceDoctor = dc.getData("GetPatientDoctor", dictionary);
dtAllergy = dc.getData("GetAllery", dictionary);
dtInsurance = dc.getData("GetPatientOHIPInsurance", dictionary);
lblLastName.Text = dtPatient.Rows[0][2].ToString();
lblFirstName.Text = dtPatient.Rows[0][3].ToString();
string dob = dtPatient.Rows[0][4].ToString();
DateTime dt = Convert.ToDateTime(dob);
dob = dt.Year.ToString() + "-" + dt.Month + "-" + dt.Day;
lblDOB.Text = dob;
lblGender.Text = dtPatient.Rows[0][5].ToString();
lblPatientID.Text = patientId.ToString();
if (try1() != 0)
{
lblReferralDoctor.Text = dtReferenceDoctor.Rows[0][2].ToString();
lblBillingCode.Text = dtReferenceDoctor.Rows[0][1].ToString();
}
if (try2() != 0)
{
lblAllergyName.Text = dtAllergy.Rows[0][1].ToString();
lblAllergyCategory.Text = dtAllergy.Rows[0][2].ToString();
}
lblInsNo.Text = dtInsurance.Rows[0][2].ToString() + " " + dtInsurance.Rows[0][3].ToString();
string date = dtInsurance.Rows[0][4].ToString();
DateTime edt = Convert.ToDateTime(date);
date = edt.Year.ToString() + "-" + edt.Month + "-" + edt.Day;
lblExpDate.Text = date;
if (try3() != 0)
{
lblAddressType.Text = dtPatientAddress.Rows[0][2].ToString();
lblAddress.Text = dtPatientAddress.Rows[0][3].ToString();
lblCity.Text = dtPatientAddress.Rows[0][4].ToString();
lblProvince.Text = dtPatientAddress.Rows[0][5].ToString();
lblPostalCode.Text = dtPatientAddress.Rows[0][6].ToString();
}
if (try4() != 0)
{
lblPhone.Text = dtPatientPhone.Rows[0][3].ToString();
lblPhoneType.Text = dtPatientPhone.Rows[0][2].ToString();
}
if (try5() != 0)
{
lblEmailType.Text = dtPatientEmail.Rows[0][2].ToString();
lblEmail.Text = dtPatientEmail.Rows[0][3].ToString();
}
}
private void btnAddRecord_Click(object sender, EventArgs e)
{
bool DOB_valid;
bool exp_valid;
bool pass=false;
//check whether Insurance numer exits
dictionary = new Dictionary<string, string>();
dictionary.Add("@insuranceNumber", txtInsuranceNumber.Text);
dc = new DatabaseConnector();
dtInsurance = dc.getData("CheckInsuranceExists", dictionary);
int ins_exist = int.Parse(dtInsurance.Rows[0][0].ToString());
//create new patient
Patient patient = new Patient();
patient.firstName = txtFirstName.Text;
patient.lastName = txtLastName.Text;
patient.dob = txtDOB.Text;
patient.gender = cmbxGender.GetItemText(cmbxGender.SelectedItem);
//create new insurance
Insurance insurance = new Insurance();
insurance.timestamp = System.DateTime.Today.ToShortDateString();
insurance.insNumber = txtInsuranceNumber.Text;
insurance.versionCode = txtVersionCode.Text;
insurance.expDate = txtInsuranceExpDate.Text;
//create new allergy
Allergy allergy = new Allergy();
allergy.name = txtAllergyName.Text;
allergy.category = txtAllergyCatergory.Text;
//create new allergy-patient
PatientAllergy ptAllgergy = new PatientAllergy();
//
Doctor doctor = new Doctor();
doctor.billingCode = txtDoctorBillingCode.Text;
doctor.name = txtReferralDoctor.Text;
//
ReferralDoctor refDoctor = new ReferralDoctor();
//ins number : number only
//ins vc : character only
//no blank: name, dob
Phone phone = new Phone();
phone.type = cmbxPhoneType.GetItemText(cmbxPhoneType.SelectedItem);
phone.phoneNumber = txtPhoneNumber.Text;
Email email = new Email();
email.type = cmbxEmailType.GetItemText(cmbxEmailType.SelectedItem);
email.email = txtEmail.Text;
Address address = new Address();
address.type = cmbxAddressType.GetItemText(cmbxAddressType.SelectedItem);
address.address = txtAddress.Text;
address.city = txtCity.Text;
address.province = txtProvince.Text;
address.postalCode = txtPostalCode.Text;
DOB_valid = DOB_validation();
exp_valid = exp_validation();
if (DOB_valid == true && exp_valid == true && ins_exist == 0 && txtInsuranceNumber.TextLength == 10)
{
pass = true;
}
if (pass == true )
{
insertPatient(patient);
patient.patientID = getPtIdfromPatienTbl();
insurance.patientID = patient.patientID;
phone.patientID = patient.patientID;
email.patientID = patient.patientID;
address.patientID = patient.patientID;
insertInsurance(insurance);
if (txtAllergyCatergory.Text != "" && txtAllergyName.Text != "")
{
if (getAllergyIdfromAllergyTbl1() != 0)
{
ptAllgergy.patientId = patient.patientID;
ptAllgergy.allergyId = getAllergyIdfromAllergyTbl1();
insertPatientAllergy(ptAllgergy);
}
else
{
insertAllergy(allergy);
ptAllgergy.patientId = patient.patientID;
ptAllgergy.allergyId = getAllergyIdfromAllergyTbl2();
insertPatientAllergy(ptAllgergy);
}
}
if (txtPhoneNumber.Text != "")
insertPhone(phone);
if (txtAddress.Text != "")
insertAdress(address);
if (txtEmail.Text != "")
insertEmail(email);
if (txtReferralDoctor.Text != "")
{
refDoctor.patientID = patient.patientID;
refDoctor.doctorID = getDoctorIdfromDoctorTbl1();
insertReferralDoctor(refDoctor);
}
/* if (txtDoctorBillingCode.Text != "" && txtReferralDoctor.Text != "")
{
if (getDoctorIdfromDoctorTbl1() != 0)
{
refDoctor.patientID = patient.patientID;
refDoctor.doctorID = getDoctorIdfromDoctorTbl1();
insertReferralDoctor(refDoctor);
}
else
{
insertDoctor(doctor);
refDoctor.patientID = patient.patientID;
refDoctor.doctorID = getDoctorIdfromDoctorTbl2();
insertReferralDoctor(refDoctor);
}
}*/
clearText();
MessageBox.Show("Patient was registed");
DialogResult result = MessageBox.Show("Go to patient demography?", "Patient registed", MessageBoxButtons.OKCancel,
MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
this.Hide();
ViewDemography viewDemo = new ViewDemography();
viewDemo.patientId = patient.patientID;
viewDemo.Show();
}
else if (result == DialogResult.Cancel)
this.Close();
}
else if (txtInsuranceNumber.TextLength != 10) //number incorrect of left blank
{
MessageBox.Show("Please insert correct insurance number");
}
else if (ins_exist != 0)
{
MessageBox.Show("Insurance Number already exists");
}
else if (DOB_valid == false)
{
MessageBox.Show("D.O.B not valid");
}
else if (exp_valid == false)
{
MessageBox.Show("Insurance Expiry Date not valid");
}
}
private int getAllergyIdfromAllergyTbl1()
{
try
{
dictionary = new Dictionary<string, string>();
dictionary.Add("@allergyName", txtAllergyName.Text);
dc = new DatabaseConnector();
dtAllergy = dc.getData("GetAllergyID1", dictionary);
int allergyID = int.Parse(dtAllergy.Rows[0][0].ToString());
return allergyID;
}
catch
{
int allergyID = 0;
return allergyID;
}
}
private void CreateDemForm_Load(object sender, EventArgs e)
{
dictionary = new Dictionary<string, string>();
dictionary.Add("@patientId", patientId.ToString());
dc = new DatabaseConnector();
dtPatient = dc.getData("GetPatient", dictionary);
dtPatientEmail = dc.getData("GetPatientEmail", dictionary);
dtPatientAddress = dc.getData("GetPatientAddress", dictionary);
dtPatientPhone = dc.getData("GetPatientPhone", dictionary);
dtReferenceDoctor = dc.getData("GetPatientDoctor", dictionary);
dtAllergy = dc.getData("GetAllery", dictionary);
dtPatientAddress = dc.getData("GetPatientAddress", dictionary);
dtInsurance = dc.getData("GetPatientOHIPInsurance", dictionary);
txtLname.Text = dtPatient.Rows[0][2].ToString();
txtFname.Text = dtPatient.Rows[0][3].ToString();
string sourceDateTex = dtPatient.Rows[0][4].ToString();
DateTime dt = Convert.ToDateTime(sourceDateTex);
sourceDateTex = dt.Year.ToString() + "-" + dt.Month + "-" + dt.Day;
patDob.Text = sourceDateTex;
cmbGender.Text = dtPatient.Rows[0][5].ToString();
txtRefDoctor.Text = dtReferenceDoctor.Rows[0][0].ToString();
txtBillingCode.Text = dtReferenceDoctor.Rows[0][1].ToString();
txtAlergyName.Text = dtAllergy.Rows[0][1].ToString();
txtAlergyCategory.Text = dtAllergy.Rows[0][2].ToString();
txtInsNum.Text = dtInsurance.Rows[0][2].ToString();
txtInsVersion.Text = dtInsurance.Rows[0][3].ToString();
string sourceDateText = dtInsurance.Rows[0][4].ToString();
DateTime dte = Convert.ToDateTime(sourceDateText);
sourceDateText = dte.Year.ToString() + "-" + dte.Month + "-" + dte.Day;
txtExpDate.Text = sourceDateText;
cmbAddType.Text=dtPatientAddress.Rows[0][2].ToString();
txtAdd.Text=dtPatientAddress.Rows[0][3].ToString();
txtCity.Text = dtPatientAddress.Rows[0][4].ToString();
txtProvince.Text = dtPatientAddress.Rows[0][5].ToString();
txtPostalCode.Text = dtPatientAddress.Rows[0][6].ToString();
txtCountry.Text = dtPatientAddress.Rows[0][7].ToString();
txtPhone.Text=dtPatientPhone.Rows[0][3].ToString();
cmbPhoneType.Text = dtPatientPhone.Rows[0][2].ToString();
txtEmail.Text = dtPatientEmail.Rows[0][3].ToString();
cmbEmailType.Text = dtPatientEmail.Rows[0][2].ToString();
}
private void btn_SearchPatient_Click(object sender, EventArgs e)
{
dictionary = new Dictionary <string, string>();
dc = new DatabaseConnector();
if (txt_Output.Text != "")
{
bool temp = false;
int temp1;
try
{
temp1 = Convert.ToInt32(txt_Output.Text);
temp = true;
}
catch (Exception ex)
{
temp = false;
}
if (cm_Options.SelectedIndex == 1 && temp == true)
{
dictionary.Add("@patientId", txt_Output.Text);
dtPatient = dc.getData("CheckPatientExists", dictionary);
if (int.Parse(dtPatient.Rows[0][0].ToString()) != 0)
{
dataGridView2.Hide();
dataGridView1.Show();
this.getPatientByIdTableAdapter.Fill(getPatientByIdDataSet.GetPatientById, txt_Output.Text);
}
else
{
MessageBox.Show("Patient does not exist.");
DialogResult result = MessageBox.Show("Create New Patient Demography?", "New Demography", MessageBoxButtons.OKCancel,
MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
CreateDemForm create = new CreateDemForm();
create.Show();
}
}
}
else if (cm_Options.SelectedIndex == 2)
{
dictionary.Add("@patientName", txt_Output.Text);
dtPatient = dc.getData("CheckPatientExistsByName", dictionary);
if (dtPatient.Rows.Count != 0)
{
dataGridView1.Hide();
dataGridView2.Show();
this.getPatientByNameTableAdapter.Fill(getPatientByNameDataSet.GetPatientByName, txt_Output.Text.ToString());
}
else
{
MessageBox.Show("Patient does not exist.");
DialogResult result = MessageBox.Show("Create New Patient Demography?", "New Demography", MessageBoxButtons.OKCancel,
MessageBoxIcon.Question);
if (result == DialogResult.OK)
{
CreateDemForm create = new CreateDemForm();
create.Show();
}
}
}
else
{
MessageBox.Show("Please proper search text!");
txt_Output.Focus();
}
}
}
public DataTable getPatientEMRAccordingToDate(Dictionary<String, String> dict, DatabaseConnector conn)
{
DataTable dataTable;
dataTable= conn.getData("GetPatientEMRAccordingToDate", dict);
return dataTable;
}
