private void btnSaveNew_Click(object sender, EventArgs e) { PersonalContact personalContact = new PersonalContact(); personalContact.contactFname = tbFname.Text; personalContact.contactLname = tbLname.Text; personalContact.contactTel = tbTel.Text; personalContact.contactEmail = tbEmail.Text; personalContact.contactAddr1 = tbAddr1.Text; personalContact.contactAddr2 = tbAddr2.Text; personalContact.contactCity = tbCity.Text; personalContact.contactPostcode = tbPost.Text; personalContact.contactHomeTel = tbPTel.Text; dbConn.InsertPersonal(personalContact); tbFname.Enabled = false; tbLname.Enabled = false; tbTel.Enabled = false; tbEmail.Enabled = false; tbAddr1.Enabled = false; tbAddr2.Enabled = false; tbCity.Enabled = false; tbPost.Enabled = false; tbPTel.Enabled = false; btnDelete.Enabled = true; btnUpdate.Enabled = true; btnSaveNew.Enabled = false; dGVPersonalRecords.DataSource = dbConn.GetAllPersonal(); }
private void btnSave_Click(object sender, EventArgs e) { int index = Int32.Parse(dGVPersonalRecords.SelectedCells[0].Value.ToString()); PersonalContact personalContact = new PersonalContact(); personalContact.ContactID = index; personalContact.contactFname = tbFname.Text; personalContact.contactLname = tbLname.Text; personalContact.contactTel = tbTel.Text; personalContact.contactEmail = tbEmail.Text; personalContact.contactAddr1 = tbAddr1.Text; personalContact.contactAddr2 = tbAddr2.Text; personalContact.contactCity = tbCity.Text; personalContact.contactPostcode = tbPost.Text; personalContact.contactHomeTel = tbPTel.Text; dbConn.UpdatePersonal(personalContact); dGVPersonalRecords.DataSource = dbConn.GetAllPersonal(); tbFname.Enabled = false; tbLname.Enabled = false; tbTel.Enabled = false; tbEmail.Enabled = false; tbAddr1.Enabled = false; tbAddr2.Enabled = false; tbCity.Enabled = false; tbPost.Enabled = false; tbPTel.Enabled = false; btnDelete.Enabled = true; btnUpdate.Enabled = true; btnSave.Enabled = false; }
public async void InsertPersonal(PersonalContact personalContact)//another one { using (var conn = new MySqlConnection(connString)) { await conn.OpenAsync();//asyncronous code for better performance using (var cmd = new MySqlCommand()) { cmd.Connection = conn; //opens connection cmd.CommandText = "CALL INSERTPersonal(@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);"; //uses the stored procedure cmd.Parameters.AddWithValue("p1", personalContact.contactFname); //explains assignment od information cmd.Parameters.AddWithValue("p2", personalContact.contactLname); cmd.Parameters.AddWithValue("p3", personalContact.contactTel); cmd.Parameters.AddWithValue("p4", personalContact.contactEmail); cmd.Parameters.AddWithValue("p5", personalContact.contactAddr1); cmd.Parameters.AddWithValue("p6", personalContact.contactAddr2); cmd.Parameters.AddWithValue("p7", personalContact.contactCity); cmd.Parameters.AddWithValue("p8", personalContact.contactPostcode); cmd.Parameters.AddWithValue("p9", personalContact.contactHomeTel); await cmd.ExecuteNonQueryAsync();//makes the query run } } }
public async void UpdatePersonal(PersonalContact personalContact)//update a record { using (var conn = new MySqlConnection(connString)) { await conn.OpenAsync(); using (var cmd = new MySqlCommand()) { cmd.Connection = conn; cmd.CommandText = "CALL updatePersonal(@p0,@p1,@p2,@p3,@p4,@p5,@p6,@p7,@p8,@p9);"; cmd.Parameters.AddWithValue("p0", personalContact.ContactID); cmd.Parameters.AddWithValue("p1", personalContact.contactFname); cmd.Parameters.AddWithValue("p2", personalContact.contactLname); cmd.Parameters.AddWithValue("p3", personalContact.contactTel); cmd.Parameters.AddWithValue("p4", personalContact.contactEmail); cmd.Parameters.AddWithValue("p5", personalContact.contactAddr1); cmd.Parameters.AddWithValue("p6", personalContact.contactAddr2); cmd.Parameters.AddWithValue("p7", personalContact.contactCity); cmd.Parameters.AddWithValue("p8", personalContact.contactPostcode); cmd.Parameters.AddWithValue("p9", personalContact.contactHomeTel); await cmd.ExecuteNonQueryAsync(); } } }