private void btnDelete_Click(object sender, EventArgs e) { var id = StudentByMatricNumber.GetMatricNumber(txtSearch.Text); var r = MessageBox.Show(@"Are you sure you want to DELETE? DELETING this record, deletes records in RELATED tables", @"Nacoss eVoting System", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2, MessageBoxOptions.DefaultDesktopOnly); if (r == DialogResult.Yes) { using (_cnn = new SqlConnection(NacossVotingSystem.Properties.Settings.Default.DBConn)) { _cnn.Open(); _myTransaction = _cnn.BeginTransaction(); using (_cmd = new SqlCommand("spDeleteCandidateById", _cnn)) { _cmd.CommandType = CommandType.StoredProcedure; _cmd.Transaction = _myTransaction; _cmd.Parameters.AddWithValue("@candidateID", id); var getCandidateById = new GetAllRecordById(); var deleteById = getCandidateById.GetCandidatesById(txtSearch.Text); try { if (deleteById) { _cmd.ExecuteNonQuery(); _myTransaction.Commit(); MessageBox.Show(@"Record Successfully deleted", @"Nacoss eVoting System"); ClearAll(); notifyIcon1.BalloonTipIcon = ToolTipIcon.Info; notifyIcon1.BalloonTipTitle = @"Delete Data"; notifyIcon1.BalloonTipText = @"Record deleted successfully"; notifyIcon1.ShowBalloonTip(3000); } else MessageBox.Show(@"Record not found in the Database", @"Nacoss eVoting System"); } catch (SqlException ex) { MessageBox.Show(@"The transaction rollbacked due to " +ex.Message); _myTransaction.Rollback(); } } } } }
private void btnUpdate_Click(object sender, EventArgs e) { var id = StudentByMatricNumber.CandidateMatricNumber(txtSearch.Text); var r = MessageBox.Show(@"Are you sure you want to UPDATE THIS RECORD?", @"Nacoss eVoting System", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2, MessageBoxOptions.DefaultDesktopOnly); if (r == DialogResult.Yes && IsValidateData()) { using (_cnn = new SqlConnection(NacossVotingSystem.Properties.Settings.Default.DBConn)) { var getCandidateById = new GetAllRecordById(); var getById = getCandidateById.GetCandidatesById(id.ToString()); _cnn.Open(); _myTransaction = _cnn.BeginTransaction(); using (_cmd = new SqlCommand("spUpdateCandiddatesById", _cnn)) { _cmd.CommandType = CommandType.StoredProcedure; _cmd.Transaction = _myTransaction; _cmd.Parameters.AddWithValue("@firstname", txtFirstName.Text); _cmd.Parameters.AddWithValue("@lastname", txtLastName.Text); _cmd.Parameters.AddWithValue("@Gender", cmbGender.Text); _cmd.Parameters.AddWithValue("@dob", dtDOB.Value); _cmd.Parameters.AddWithValue("@levelID", cmbLevel.Text); _cmd.Parameters.AddWithValue("@matricnumber", txtMatricNumber.Text); _cmd.Parameters.AddWithValue("@phonenumber", txtPhone.Text); _cmd.Parameters.AddWithValue("@email", txtEmailAddress.Text); _cmd.Parameters.AddWithValue("@candidateID", id); _cmd.Parameters.AddWithValue("@position", cmbPost.Text); MemoryStream ms = new MemoryStream(); picImage.Image.Save(ms, ImageFormat.Bmp); byte[] data = ms.ToArray(); _cmd.Parameters.AddWithValue("@image", data); try { int rowsAffected = _cmd.ExecuteNonQuery(); _myTransaction.Commit(); MessageBox.Show(@"Data Updated Successfully!", @"Nacoss eVoting System", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); notifyIcon1.BalloonTipIcon = ToolTipIcon.Info; notifyIcon1.BalloonTipTitle = @"Data Update"; notifyIcon1.BalloonTipText = @"Data Updated Successfully" ; notifyIcon1.ShowBalloonTip(3000); } catch (SqlException ex) { MessageBox.Show(@"Transaction rollbacked due to " + ex.Message); _myTransaction.Rollback(); } } } } }