private void ConfirmBtn_Click(object sender, EventArgs e) { connection.Open(); SqlCommand com = new SqlCommand("Update ContactInformationTable set Address = '" + Address.Text + "' where PatientNo =" + Pnum.ToString(), connection); com.ExecuteNonQuery(); connection.Close(); connection.Open(); SqlCommand com0 = new SqlCommand("Update ContactInformationTable set EmailAdd= '" + EmailAdd.Text + "' where PatientNo =" + Pnum.ToString(), connection); com0.ExecuteNonQuery(); connection.Close(); connection.Open(); SqlCommand com1 = new SqlCommand("Update ContactInformationTable set ContactNo = '" + ContactNo.Text + "' where PatientNo =" + Pnum.ToString(), connection); com1.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Contact Info Successfully Edited!"); View_Detailed_Patient back2 = new View_Detailed_Patient(Pnum); back2.Show(); this.Hide(); }
private void CancelBTN_Click(object sender, EventArgs e) { View_Detailed_Patient back = new View_Detailed_Patient(Pnum); back.Show(); this.Hide(); }
private void ConfirmBtn_Click(object sender, EventArgs e) { connection.Open(); SqlCommand checker = new SqlCommand("Select * from TreatmentHistoryTable where Date='" + Month.Text + "/" + Day.Text + "/" + Year.Text + "'", connection); SqlDataReader read = checker.ExecuteReader(); if (read.HasRows) { MessageBox.Show("There is already a treatment for that day"); Condition.Text = ""; status.Text = ""; treatment.Text = ""; Day.SelectedItem = null; Month.SelectedItem = null; Year.SelectedItem = null; } else { connection.Close(); connection.Open(); SqlCommand com = new SqlCommand("Insert into TreatmentHistoryTable values (" + pnum.ToString() + ",'" + Condition.Text + "','" + treatment.Text + "','" + status.Text + "','" + Month.Text + "/" + Day.Text + "/" + Year.Text + "')", connection); com.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Treatment Successfuly Inserted!"); View_Detailed_Patient back = new View_Detailed_Patient(pnum); back.Show(); this.Hide(); } }
private void UpdatePatientBtn_Click(object sender, EventArgs e) { View_Detailed_Patient view = new View_Detailed_Patient(); view.Show(); this.Hide(); }
private void ConfirmBtn_Click(object sender, EventArgs e) { connection.Open(); SqlCommand com = new SqlCommand("Update TreatmentHistoryTable set status = '" + status.Text + "' where PatientNo =" + Pnum.ToString() + "and Date = '" + Date.Text + "'", connection); com.ExecuteNonQuery(); connection.Close(); MessageBox.Show("Treatment Successfuly Updated!"); View_Detailed_Patient back = new View_Detailed_Patient(Pnum); back.Show(); this.Hide(); }