private void PatientScreen_Load(object sender, EventArgs e) { viewControlPanel.Width = 879; viewControlPanel.Height = 365; viewControlPanel.Location = new Point(5, 195); addRecordPanel.Width = 879; addRecordPanel.Height = 365; addRecordPanel.Location = new Point(5, 195); updateRecordPanel.Width = 879; updateRecordPanel.Height = 365; updateRecordPanel.Location = new Point(5, 195); deleteRecordPanel.Width = 879; deleteRecordPanel.Height = 365; deleteRecordPanel.Location = new Point(5, 195); DBConnector dBconn = new DBConnector(); dBconn.connect(); PatientHandler patientHandler = new PatientHandler(); patientGridView.DataSource = patientHandler.getAllPatient(dBconn.getConn()); viewControlPanel.Show(); addRecordPanel.Hide(); updateRecordPanel.Hide(); deleteRecordPanel.Hide(); }
//-----------------------------------------------------------Delete Record----------------------------------------------------------------------------// private void deleteRecordBtn_Click(object sender, EventArgs e) { PatientHandler patientHandler = new PatientHandler(); viewControlPanel.Hide(); addRecordPanel.Hide(); updateRecordPanel.Hide(); deleteRecordPanel.Show(); closeAllTextBox(fullNameDeleteTextBox, nricDeleteTextBox, emailDeleteTextBox, phoneDeleteTextBox, addressDeleteRichTextBox, ageDeleteTextBox, bedsideIdDeleteTextBox, choosePatientIDDeleteComboBox, genderDeleteComboBox); patientHandler.FetchId(choosePatientIDDeleteComboBox); }
private void updatePatientButton_Click(object sender, EventArgs e) { DBConnector dbC = new DBConnector(); dbC.connect(); PatientHandler patientHandler = new PatientHandler(); Patient oldPatientData = new Patient(); if (choosePatientIDUpdateComboBox.SelectedIndex == 0) { MessageBox.Show("Please select valid ID"); return; } if (nricUpdateTextBox.Enabled == false) { MessageBox.Show("Please press 'Enter' to generate data first"); return; } else { oldPatientData = patientHandler.getSpecificPatient(dbC.getConn(), int.Parse(choosePatientIDUpdateComboBox.SelectedItem.ToString())); } if ((oldPatientData.IdentityCard.ToString() != nricUpdateTextBox.Text) || (oldPatientData.FullName != fullNameUpdateTextBox.Text) || (oldPatientData.Email != emailUpdateTextBox.Text) || (oldPatientData.Gender != genderUpdatecomboBox.SelectedItem.ToString()) || (oldPatientData.Phone.ToString() != phoneUpdateTextBox.Text) || (oldPatientData.Address != addressUpdateTextBox.Text) || (oldPatientData.Age.ToString() != ageUpdateTextBox.Text) || (oldPatientData.BedsideId.ToString() != bedsideIdUpdateTextBox.Text)) { Patient newPatientData = new Patient(); newPatientData.Id = int.Parse(choosePatientIDUpdateComboBox.SelectedItem.ToString()); newPatientData.IdentityCard = long.Parse(nricUpdateTextBox.Text); newPatientData.FullName = fullNameUpdateTextBox.Text; newPatientData.Email = emailUpdateTextBox.Text; newPatientData.Gender = genderUpdatecomboBox.SelectedItem.ToString(); newPatientData.Phone = int.Parse(phoneUpdateTextBox.Text); newPatientData.Address = addressUpdateTextBox.Text; newPatientData.Age = int.Parse(ageUpdateTextBox.Text); newPatientData.BedsideId = int.Parse(bedsideIdUpdateTextBox.Text); int updateResult = patientHandler.updatePatientData(dbC.getConn(), newPatientData); if (updateResult == 1) { MessageBox.Show("Update Successfully"); closeAllTextBox(fullNameUpdateTextBox, nricUpdateTextBox, emailUpdateTextBox, phoneTextBox, addressUpdateTextBox, ageUpdateTextBox, bedsideIdUpdateTextBox, choosePatientIDUpdateComboBox, genderUpdatecomboBox); patientHandler.FetchId(choosePatientIDUpdateComboBox); } else { MessageBox.Show("Update Failed"); } } else { MessageBox.Show("Nothing is changes"); } }
public PatientScreen() { InitializeComponent(); genderComboBox.SelectedIndex = 0; DBConnector dBConn = new DBConnector(); dBConn.connect(); PatientHandler patientHandler = new PatientHandler(); patientGridView.DataSource = patientHandler.getAllPatient(dBConn.getConn()); }
private void searchtextBox_TextChanged(object sender, EventArgs e) { DBConnector dBconn = new DBConnector(); dBconn.connect(); PatientHandler patientHandler = new PatientHandler(); if (searchtextBox.Text != "") { patientGridView.DataSource = patientHandler.searchPatientData(dBconn.getConn(), searchtextBox.Text); } }
//-----------------------------------------------------------Add Record----------------------------------------------------------------------------// private void viewRecordBtn_Click(object sender, EventArgs e) { DBConnector dBconn = new DBConnector(); dBconn.connect(); PatientHandler patientHandler = new PatientHandler(); patientGridView.DataSource = patientHandler.getAllPatient(dBconn.getConn()); viewControlPanel.Show(); addRecordPanel.Hide(); updateRecordPanel.Hide(); deleteRecordPanel.Hide(); }
private void choosePatientComboBox_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == (char)Keys.Enter) { if (choosePatientIDUpdateComboBox.SelectedIndex == 0) { MessageBox.Show("Please select valid ID"); } else { nricUpdateTextBox.Enabled = true; fullNameUpdateTextBox.Enabled = true; emailUpdateTextBox.Enabled = true; genderUpdatecomboBox.Enabled = true; phoneUpdateTextBox.Enabled = true; addressUpdateTextBox.Enabled = true; ageUpdateTextBox.Enabled = true; bedsideIdUpdateTextBox.Enabled = true; genderUpdatecomboBox.Items.Add("Male"); genderUpdatecomboBox.Items.Add("Female"); DBConnector dbC = new DBConnector(); dbC.connect(); PatientHandler patientHandler = new PatientHandler(); List <Patient> patientList = new List <Patient>(); patientList = patientHandler.getAllPatient(dbC.getConn()); for (int i = 0; i < patientList.Count; i++) { if (choosePatientIDUpdateComboBox.SelectedItem.ToString() == patientList[i].Id.ToString()) { nricUpdateTextBox.Text = patientList[i].IdentityCard.ToString(); fullNameUpdateTextBox.Text = patientList[i].FullName; emailUpdateTextBox.Text = patientList[i].Email; for (int n = 0; n < genderUpdatecomboBox.Items.Count; n++) { if (patientList[i].Gender == genderUpdatecomboBox.Items[n].ToString()) { genderUpdatecomboBox.SelectedIndex = n; } } phoneUpdateTextBox.Text = patientList[i].Phone.ToString(); addressUpdateTextBox.Text = patientList[i].Address; ageUpdateTextBox.Text = patientList[i].Age.ToString(); bedsideIdUpdateTextBox.Text = patientList[i].BedsideId.ToString(); } } } } }
//-----------------------------------------------------------Add Record----------------------------------------------------------------------------// private void addRecordBtn_Click(object sender, EventArgs e) { DBConnector dBconn = new DBConnector(); dBconn.connect(); PatientHandler patientHandler = new PatientHandler(); patientIdTextBox.Text = patientHandler.getLastRecordID(dBconn.getConn()); genderComboBox.SelectedIndex = 0; viewControlPanel.Hide(); addRecordPanel.Show(); updateRecordPanel.Hide(); deleteRecordPanel.Hide(); }
//public int alterTable(MySqlConnection conn, int id) //{ // string sql = "ALTER TABLE patient AUTO INCREMENT= '" + id + "'"; // MySqlCommand alterCommand = new MySqlCommand(sql, conn); // return alterCommand.ExecuteNonQuery(); //} public void FetchId(ComboBox selectedcomboBox) { selectedcomboBox.Items.Add("--Select ID--"); selectedcomboBox.SelectedIndex = 0; DBConnector dbC = new DBConnector(); dbC.connect(); PatientHandler patientHandler = new PatientHandler(); List <Patient> patientList = new List <Patient>(); patientList = patientHandler.getAllPatient(dbC.getConn()); for (int i = 0; i < patientList.Count; i++) { selectedcomboBox.Items.Add(patientList[i].Id); } }
private void deletePatientRecordBtn_Click(object sender, EventArgs e) { DBConnector dbC = new DBConnector(); dbC.connect(); PatientHandler patientHandler = new PatientHandler(); Patient oldPatientData = new Patient(); if (choosePatientIDDeleteComboBox.SelectedIndex == 0) { MessageBox.Show("Please select valid ID"); return; } if (string.IsNullOrEmpty(nricDeleteTextBox.Text)) { MessageBox.Show("Please press 'Enter' to generate data first"); return; } else { oldPatientData = patientHandler.getSpecificPatient(dbC.getConn(), int.Parse(choosePatientIDDeleteComboBox.SelectedItem.ToString())); } int deleteResult = patientHandler.deletePatientData(dbC.getConn(), oldPatientData.Id); if (deleteResult == 1) { MessageBox.Show("Delete Record Successfully"); closeAllTextBox(fullNameDeleteTextBox, nricDeleteTextBox, emailDeleteTextBox, phoneDeleteTextBox, addressDeleteRichTextBox, ageDeleteTextBox, bedsideIdDeleteTextBox, choosePatientIDDeleteComboBox, genderDeleteComboBox); patientHandler.FetchId(choosePatientIDDeleteComboBox); } else { MessageBox.Show("Delete Failed"); } }
private void savePatientBtn_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(fullNameTextBox.Text)) { MessageBox.Show("Please enter full name"); return; } if (string.IsNullOrEmpty(emailTextBox.Text)) { MessageBox.Show("Please enter email"); return; } if (genderComboBox.SelectedIndex == 0) { MessageBox.Show("Please select gender"); return; } if (string.IsNullOrEmpty(nricTextBox.Text)) { MessageBox.Show("Please enter nric"); return; } if (string.IsNullOrEmpty(addressTextBox.Text)) { MessageBox.Show("Please enter address"); return; } if (string.IsNullOrEmpty(phoneTextBox.Text)) { MessageBox.Show("Please enter phone"); return; } if (string.IsNullOrEmpty(ageTextBox.Text)) { MessageBox.Show("Please enter age"); return; } Patient newPatient = new Patient(); newPatient.FullName = fullNameTextBox.Text; newPatient.IdentityCard = long.Parse(nricTextBox.Text); newPatient.Address = addressTextBox.Text; newPatient.Email = emailTextBox.Text; newPatient.Gender = genderComboBox.SelectedItem.ToString(); newPatient.Phone = int.Parse(phoneTextBox.Text); newPatient.Age = int.Parse(ageTextBox.Text); newPatient.BedsideId = 0; DBConnector dBconn = new DBConnector(); dBconn.connect(); PatientHandler patientHandler = new PatientHandler(); int addResult = patientHandler.addNewPatient(dBconn.getConn(), newPatient); if (addResult == 1) { MessageBox.Show("New Patient Record is inserted"); fullNameTextBox.Text = ""; nricTextBox.Text = ""; addressTextBox.Text = ""; emailTextBox.Text = ""; genderComboBox.SelectedIndex = 0; phoneTextBox.Text = ""; ageTextBox.Text = ""; patientIdTextBox.Text = patientHandler.getLastRecordID(dBconn.getConn()); } }