private void txtSearch_TextChanged(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
switch (cmbSearch.SelectedIndex)
{
case 1:
dgvListOfPatient.DataSource = dbContext.SearchDatePatient(dtpSearch.Value.Date.ToShortDateString());
dtpSearch.Enabled = true;
txtSearch.Visible = false;
txtSearch.Enabled = false;
break;
case 2:
dgvListOfPatient.DataSource = dbContext.SearchIdPatient(txtSearch.Text);
txtSearch.Visible = true;
dtpSearch.Enabled = false;
dtpSearch.Visible = false;
break;
case 3:
dgvListOfPatient.DataSource = dbContext.SearchFullNamePatient(txtSearch.Text);
txtSearch.Visible = true;
dtpSearch.Enabled = false;
dtpSearch.Visible = false;
break;
default:
break;
}
}
private void cmbSearch_SelectedIndexChanged(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
switch (cmbSearch.SelectedIndex)
{
case 0:
dgvListOfPatient.DataSource = dbContext.GetPatientsId();
txtSearch.Enabled = false;
break;
case 1:
dgvListOfPatient.DataSource = dbContext.SearchSerialNoRx(txtSearch.Text);
txtSearch.Enabled = true;
break;
case 2:
dgvListOfPatient.DataSource = dbContext.SearchNameRx(txtSearch.Text);
txtSearch.Enabled = true;
break;
default:
break;
}
}
private void btnSubmitPatient_Click(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
if (btnSubmitPatient.Text == "Submit")
{
//Check if serial is existing
if (IsPatientNoExisting())
{
MessageBox.Show("Patient No. is already used!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (String.IsNullOrWhiteSpace(txtPatientNo.Text) || String.IsNullOrWhiteSpace(txtFirstName.Text) ||
Convert.ToInt32(lblAge.Text) <= 0 || String.IsNullOrWhiteSpace(txtLastName.Text))
{
MessageBox.Show("Please fill in required fields!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
DialogResult result = MessageBox.Show("Do you want to 'Sumbit' this patient?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//Insert Query
byte gender = rbMale.Checked ? (byte)Enums.Gender.Male : (byte)Enums.Gender.Female;
byte isActive = 1;
dbContext.InsertPatient(txtPatientNo.Text, txtFirstName.Text, txtMiddleName.Text,
gender, dtpBirthday.Value, Convert.ToByte(lblAge.Text), txtMobileNo.Text, txtTelephoneNo.Text, txtHouseNo.Text,
txtStreet.Text, txtBarangay.Text, txtCity.Text, DateTime.Now, txtLastName.Text, isActive);
MessageBox.Show("Patient Information has been saved successfully!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
}
}
if (btnSubmitPatient.Text == "Update")
{
if (String.IsNullOrWhiteSpace(txtPatientNo.Text) || String.IsNullOrWhiteSpace(txtFirstName.Text) ||
Convert.ToInt32(lblAge.Text) <= 0 || String.IsNullOrWhiteSpace(txtLastName.Text))
{
MessageBox.Show("Please fill in required fields!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
DialogResult result = MessageBox.Show("Do you want to 'Update' this patient?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
//Update Query
byte gender = rbMale.Checked ? (byte)Enums.Gender.Male : (byte)Enums.Gender.Female;
dbContext.UpdatePatientInformation(Convert.ToInt32(lblPatientId.Text), txtPatientNo.Text, txtFirstName.Text,
txtMiddleName.Text, txtLastName.Text, gender, dtpBirthday.Value, Convert.ToByte(lblAge.Text), txtMobileNo.Text,
txtTelephoneNo.Text, txtHouseNo.Text, txtStreet.Text, txtBarangay.Text, txtCity.Text);
MessageBox.Show("Patient Information has been updated successfully!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
this.Close();
}
}
}
public bool IsPatientNoExisting(bool isPatientNoExisting = false)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
var serialNo = dbContext.GetSerialNumber(txtPatientNo.Text);
foreach (var number in serialNo)
{
isPatientNoExisting = true;
}
return(isPatientNoExisting);
}
private void btnRemove_Click(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
DialogResult result = MessageBox.Show("Are you sure you want to remove this Patient - " + lblPatientName.Text + " ?", "Information", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (result == DialogResult.Yes)
{
dbContext.RemovePatientInformation(Convert.ToInt32(lblPatientId.Text));
PatientLoad();
MessageBox.Show("Patient is already removed!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool IsContactSerialNoExisting(bool isContactSerialNoExisting = false)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
var contactSerialNo = dbContext.GetSerialNumberContactRx(txtSerialNo.Text);
foreach (var number in contactSerialNo)
{
isContactSerialNoExisting = true;
}
return(isContactSerialNoExisting);
}
public void PatientLoad()
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
cmbSearch.SelectedIndex = 0;
dgvListOfPatient.DataSource = dbContext.GetPatientsId();
dgvListOfPatient.Columns[0].HeaderCell.Value = "Id";
dgvListOfPatient.Columns[0].Visible = false;
dgvListOfPatient.Columns[1].HeaderCell.Value = "Patient No.";
dgvListOfPatient.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[2].HeaderCell.Value = "Full Name";
dgvListOfPatient.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
private void btnHistory_Click(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
Forms.FormPatientRecords formPatientRecords = new Forms.FormPatientRecords();
formPatientRecords.txtName.Text = lblPatientName.Text;
formPatientRecords.txtAddress.Text = lblHouseNo.Text + " " + lblStreet.Text + " " + lblBarangay.Text + " " + lblCity.Text;
formPatientRecords.txtMobile.Text = lblMobileNo.Text;
formPatientRecords.txtTelephone.Text = lblTelephoneNo.Text;
formPatientRecords.txtBirthdate.Text = dtpBirthday.Value.Date.ToShortDateString();
formPatientRecords.txtGender.Text = lblGender.Text;
var countOpticalLens = dbContext.CountPatientOpticalLens(Convert.ToInt32(lblPatientId.Text));
foreach (var countPatientOpticalLens in countOpticalLens)
{
count[0] = (int)countPatientOpticalLens;
}
formPatientRecords.lblCountOptical.Text = count[0].ToString();
var countContactLens = dbContext.CountPatientContactLens(Convert.ToInt32(lblPatientId.Text));
foreach (var countPatientContactLens in countContactLens)
{
count[0] = (int)countPatientContactLens;
}
formPatientRecords.lblCountContact.Text = count[0].ToString();
var getPatientLastCheckUpDateOptical = dbContext.GetLastCheckUpDateOpticalLens(Convert.ToInt32(lblPatientId.Text));
foreach (var patientLastCheckUpDateOptical in getPatientLastCheckUpDateOptical)
{
date[0] = patientLastCheckUpDateOptical.ToString();
}
formPatientRecords.lblLastCheckUpDateOptical.Text = date[0].ToString();
var getPatientLastCheckUpDatContact = dbContext.GetLastCheckUpDateContactLens(Convert.ToInt32(lblPatientId.Text));
foreach (var patientLastCheckUpDateContact in getPatientLastCheckUpDatContact)
{
date[0] = patientLastCheckUpDateContact.ToString();
}
formPatientRecords.lblLastCheckUpDateContact.Text = date[0].ToString();
formPatientRecords.dgvPatientOpticalLens.DataSource = dbContext.GetPatientOpticalLens(Convert.ToInt32(lblPatientId.Text));
formPatientRecords.dgvPatientContactLens.DataSource = dbContext.GetPatientContactLens(Convert.ToInt32(lblPatientId.Text));
formPatientRecords.ShowDialog();
}
public void PatientLoad()
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
cmbSearch.SelectedIndex = 0;
dgvListOfPatient.DataSource = dbContext.GetPatients();
dgvListOfPatient.Columns[0].HeaderCell.Value = "Id";
dgvListOfPatient.Columns[0].Visible = false;
dgvListOfPatient.Columns[1].HeaderCell.Value = "Date and Time";
dgvListOfPatient.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[2].HeaderCell.Value = "Patient No.";
dgvListOfPatient.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[3].HeaderCell.Value = "Full Name";
dgvListOfPatient.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgvListOfPatient.Columns[4].HeaderCell.Value = "Gender";
dgvListOfPatient.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[5].HeaderCell.Value = "Birthday";
dgvListOfPatient.Columns[5].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[6].HeaderCell.Value = "Age";
dgvListOfPatient.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[7].HeaderCell.Value = "Mobile No.";
dgvListOfPatient.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[8].HeaderCell.Value = "Telephone No.";
dgvListOfPatient.Columns[8].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[9].HeaderCell.Value = "Address";
dgvListOfPatient.Columns[9].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[10].HeaderCell.Value = "Status";
dgvListOfPatient.Columns[10].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
dgvListOfPatient.Columns[11].Visible = false;
dgvListOfPatient.Columns[12].Visible = false;
dgvListOfPatient.Columns[13].Visible = false;
dgvListOfPatient.Columns[14].Visible = false;
dgvListOfPatient.Columns[15].Visible = false;
dgvListOfPatient.Columns[16].Visible = false;
dgvListOfPatient.Columns[17].Visible = false;
}
private void dtpSearch_ValueChanged(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
dgvListOfPatient.DataSource = dbContext.SearchDatePatient(dtpSearch.Value.Date.ToShortDateString());
}
private void btnSubmit_Click(object sender, EventArgs e)
{
MarikinaOpticalEntities dbContext = new MarikinaOpticalEntities();
var patientLens = "";
var isOpticalLens = false;
var isContactLens = false;
if (String.IsNullOrWhiteSpace(txtSerialNo.Text))
{
MessageBox.Show("Please input Rx - Serial No.!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (IsOpticalSerialNoExisting() || IsContactSerialNoExisting())
{
MessageBox.Show("Serial No. is already used!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return;
}
if (cbOpticalLens.Checked == true || cbContactLens.Checked == true)
{
if (cbOpticalLens.Checked == true)
{
if (String.IsNullOrWhiteSpace(cmbOLRS.Text) && String.IsNullOrWhiteSpace(cmbOLRC.Text) && String.IsNullOrWhiteSpace(cmbOLRA.Text) &&
String.IsNullOrWhiteSpace(cmbOLRPD.Text) && String.IsNullOrWhiteSpace(cmbOLRADD.Text) && String.IsNullOrWhiteSpace(cmbOLRPRISM.Text) &&
String.IsNullOrWhiteSpace(cmbOLRBASE.Text) && String.IsNullOrWhiteSpace(cmbOLROH.Text) && String.IsNullOrWhiteSpace(cmbOLLS.Text) &&
String.IsNullOrWhiteSpace(cmbOLLC.Text) && String.IsNullOrWhiteSpace(cmbOLLA.Text) && String.IsNullOrWhiteSpace(cmbOLLPD.Text) &&
String.IsNullOrWhiteSpace(cmbOLLADD.Text) && String.IsNullOrWhiteSpace(cmbOLLPRISM.Text) && String.IsNullOrWhiteSpace(cmbOLLBASE.Text) &&
String.IsNullOrWhiteSpace(cmbOLLOH.Text))
{
MessageBox.Show("Please select a valid value in the box!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
isOpticalLens = true;
}
if (cbContactLens.Checked == true)
{
if (String.IsNullOrWhiteSpace(cmbCLRS.Text) && String.IsNullOrWhiteSpace(cmbCLRC.Text) && String.IsNullOrWhiteSpace(cmbCLRA.Text) &&
String.IsNullOrWhiteSpace(cmbCLRBC.Text) && String.IsNullOrWhiteSpace(cmbCLRDptr.Text) && String.IsNullOrWhiteSpace(cmbCLLS.Text) &&
String.IsNullOrWhiteSpace(cmbCLLC.Text) && String.IsNullOrWhiteSpace(cmbCLLA.Text) && String.IsNullOrWhiteSpace(cmbCLLBC.Text) &&
String.IsNullOrWhiteSpace(cmbCLLDptr.Text))
{
MessageBox.Show("Please select a valid value in the box!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
isContactLens = true;
}
DialogResult result = MessageBox.Show("Do you want to 'Submit' this Rx to" + txtSerialNo.Text + " - " + txtName.Text + "?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
if (isOpticalLens == true)
{
patientLens = " Optical Lens ";
dbContext.InsertOpticalLensDoctors(txtSerialNo.Text, txtOpthometrist.Text, txtOptician.Text);
dbContext.InsertOpticalLensRemarks(txtSerialNo.Text, txtRemarks.Text);
dbContext.InsertOpticalLens(txtSerialNo.Text, cmbOLRS.Text, cmbOLRC.Text, cmbOLRA.Text, cmbOLRPD.Text,
cmbOLRADD.Text, cmbOLRPRISM.Text, cmbOLRBASE.Text, cmbOLROH.Text, cmbOLLS.Text,
cmbOLLC.Text, cmbOLLA.Text, cmbOLLPD.Text, cmbOLLADD.Text, cmbOLLPRISM.Text, cmbOLLBASE.Text,
cmbOLLOH.Text, DateTime.Now);
dbContext.InsertPatientsOpticalLens(txtSerialNo.Text, Convert.ToInt32(lblPatientId.Text));
}
if (isContactLens == true)
{
patientLens = " Contact Lens ";
dbContext.InsertContactLensDoctors(txtSerialNo.Text, txtOpthometrist.Text, txtOptician.Text);
dbContext.InsertContactLensRemarks(txtSerialNo.Text, txtRemarks.Text);
dbContext.InsertContactLens(txtSerialNo.Text, cmbCLRS.Text, cmbCLRC.Text, cmbCLRA.Text,
cmbCLRBC.Text, cmbCLRDptr.Text, cmbCLLS.Text, cmbCLLC.Text,
cmbCLLA.Text, cmbCLLBC.Text, cmbCLLDptr.Text, DateTime.Now);
dbContext.InsertPatientsContactLens(txtSerialNo.Text, Convert.ToInt32(lblPatientId.Text));
}
if (cbOpticalLens.Checked == true && cbContactLens.Checked == true)
{
patientLens = " Optical and Contact Lens ";
}
MessageBox.Show("Patient Rx" + patientLens + "has been saved successfully!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
Clear();
}
}
else
{
MessageBox.Show("Please select lens for Patient!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
