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 getVoterById = new GetAllRecordById();
var id = StudentByMatricNumber.GetMatricNumber(txtSearch.Text);
bool getId = getVoterById.GetVotersById(id.ToString());
if (getId)
{
using (_cnn = new SqlConnection(Settings.Default.DBConn))
{
_cnn.Open();
_myTransaction = _cnn.BeginTransaction();
using (_cmd = new SqlCommand("spUpdateVotersById", _cnn))
{
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Transaction = _myTransaction;
_cmd.Parameters.AddWithValue("@firstname", txtFirstName.Text);
_cmd.Parameters.AddWithValue("@lastname", txtLastName.Text);
_cmd.Parameters.AddWithValue("@sex", cmbGender.Text);
_cmd.Parameters.AddWithValue("@dob", dtDOB.Value);
_cmd.Parameters.AddWithValue("@levelID", cmbLevel.Text);
_cmd.Parameters.AddWithValue("@matricnumber", txtMatricNumber.Text);
_cmd.Parameters.AddWithValue("@phonenumber", txtPhoneNumber.Text);
_cmd.Parameters.AddWithValue("@email", txtEmailAddress.Text);
_cmd.Parameters.AddWithValue("@voterID", id);
MemoryStream ms = new MemoryStream();
picImage.Image.Save(ms, ImageFormat.Bmp);
byte[] data = ms.ToArray();
_cmd.Parameters.AddWithValue("@image", data);
//try
//{
var r = MessageBox.Show(@"Are you sure you want to SUBMIT?", @"Nacoss eVoting System",
MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2,
MessageBoxOptions.DefaultDesktopOnly);
if (r == DialogResult.Yes && IsValidateData(true))
{
int rowsAffected = _cmd.ExecuteNonQuery();
_myTransaction.Commit();
MessageBox.Show(@"Record has been Updated!", @"Nacoss eVoting System");
notifyIcon1.BalloonTipIcon = ToolTipIcon.Info;
notifyIcon1.BalloonTipTitle = @"Updated";
notifyIcon1.BalloonTipText = @"Record has been updated Successfully";
notifyIcon1.ShowBalloonTip(3000);
}
//}
//catch (SqlException ex)
//{
// MessageBox.Show(ex.Message);
// _myTransaction.Rollback();
//}
}
}
}
else
{
MessageBox.Show(@"Record cannot be update, It does not exist", @"Nacoss eVoting System");
notifyIcon1.BalloonTipIcon = ToolTipIcon.Warning;
notifyIcon1.BalloonTipTitle = @"Update Data";
notifyIcon1.BalloonTipText = @"No record to update" + Environment.NewLine +
@"Enter the right data";
notifyIcon1.ShowBalloonTip(3000);
}
}
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(Settings.Default.DBConn))
{
_cnn.Open();
_myTransaction = _cnn.BeginTransaction();
using (_cmd = new SqlCommand("spDeleteVotersById", _cnn))
{
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Transaction = _myTransaction;
_cmd.Parameters.AddWithValue("@voterID", id);
var getAll = new GetAllRecordById();
var getById = getAll.GetVotersById(txtSearch.Text);
if (getById)
{
try
{
_cmd.ExecuteNonQuery();
_myTransaction.Commit();
MessageBox.Show(@"Record has been deleted!", @"Nacoss eVoting System");
ClearAll();
notifyIcon1.BalloonTipIcon = ToolTipIcon.Info;
notifyIcon1.BalloonTipTitle = @"Delete Data";
notifyIcon1.BalloonTipText = @"Data has been deleted" + Environment.NewLine +
@"Successfully";
notifyIcon1.ShowBalloonTip(3000);
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
_myTransaction.Rollback();
}
}
else
{
MessageBox.Show(@"Record cannot be deleted!, Voters Id not found", @"Nacoss eVoting System");
notifyIcon1.BalloonTipIcon = ToolTipIcon.Error;
notifyIcon1.BalloonTipTitle = @"Delete Data";
notifyIcon1.BalloonTipText = @"Record cannot be deleted";
notifyIcon1.ShowBalloonTip(3000);
}
}
}
}
}
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();
}
}
}
}
}