//////// Working on undo button /////// private void Undo_Click(object sender, EventArgs e) { Modname Bmod = sender as Modname; string connString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=E:\\ITS245\\STEFPROJ\\Database11.accdb"; OleDbConnection connection = new OleDbConnection(connString); OleDbCommand cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = "Update allergyhistorytable set Allergen =" + "'" + Bmod.Allergen + "'" + ",AllergyDescription = " + "'" + Bmod.Allergen + "'" + " where AllergyID=" + listBox1.SelectedItem.ToString(); OleDbDataReader reader = cmd.ExecuteReader(); reader.Read(); reader.Close(); Allergen.ReadOnly = true; Description.ReadOnly = true; Save.Hide(); AddButton.Hide(); }
///////unlocks all the boxes essentially for now ////// private void Modify_Click(object sender, EventArgs e) { Modname Amod = new Modname(Allergen.Text, Description.Text); Undo_Click(Amod, e); this.BackColor = Color.Blue; Allergen.ReadOnly = false; Description.ReadOnly = false; Save.Show(); AddButton.Show(); }
////////////// Modify Button ////////// private void Modify_Click(object sender, EventArgs e) { //// send it the object made from class and leave the e//// Modname mod = new Modname(Fname.Text, Lname.Text, AGE.Text); Undo_Click(mod, e); this.BackColor = Color.Blue; Lname.ReadOnly = false; Fname.ReadOnly = false; AGE.ReadOnly = false; Save.Show(); ADDButton.Show(); }
///////////////// Undo Button //////////////////////// private void Undo_Click(object sender, EventArgs e) { // Interprets sender as modname and sets mode equal to mod// Modname mode = sender as Modname; string connString = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=E:\\ITS245\\STEFPROJ\\Database11.accdb"; OleDbConnection connection = new OleDbConnection(connString); OleDbCommand cmd = connection.CreateCommand(); connection.Open(); cmd.CommandText = "Update patienttable set PtLastName = " + "'" + mode.Tlname + "'" + ",PtFirstname = " + "'" + mode.Tfname + "'" + ",DOB=" + "'" + mode.Dob + "'" + " where PatientID = " + PatientID.Text; OleDbDataReader reader2 = cmd.ExecuteReader(); reader2.Read(); reader2.Close(); cmd.CommandText = "Select PtLastName, PtFirstname, DOB from Patienttable where PatientID=" + PatientID.Text; cmd.Connection = connection; OleDbDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { Lname.Text = reader[0].ToString(); Fname.Text = reader[1].ToString(); AGE.Text = reader[2].ToString(); } reader.Close(); Lname.ReadOnly = true; Fname.ReadOnly = true; AGE.ReadOnly = true; connection.Close(); }