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();
}
}
}
}
}
