private void BtnChangePassword_Click(object sender, EventArgs e)
{
if (TxtGrade.Text == "" || TxtStrand.Text == "" || TxtTrack.Text == "")
{
NotificationFillBlank a = new NotificationFillBlank();
a.ShowDialog();
}
else
{
try
{
GetAccountInfo();
UpdateAccount();
con.Open();
String query = "update voters set grade = @grade, track = @track, strand = @strand where account_id = @id";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@id", user_id);
cmd.Parameters.AddWithValue("@grade", TxtGrade.Text);
cmd.Parameters.AddWithValue("@track", TxtTrack.Text);
cmd.Parameters.AddWithValue("@strand", TxtStrand.Text);
cmd.ExecuteNonQuery();
con.Close();
LogHistoryEdit(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user);
CloseTransparent();
NotificationEditSuccess a = new NotificationEditSuccess();
a.ShowDialog();
}
catch
{
NotificationConnectionError a = new NotificationConnectionError();
a.ShowDialog();
}
}
}
private void BtnAddPosition_Click(object sender, EventArgs e)
{
if (TxtPosition.Text == "")
{
NotificationFillBlank a = new NotificationFillBlank();
a.ShowDialog();
}
else
{
try
{
con.Open();
String query = "insert into partylist (partylist) values (@partylist)";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@partylist", TxtPosition.Text);
cmd.ExecuteNonQuery();
con.Close();
LogHistory(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user);
CloseTransparent();
NotificationAddedSuccess a = new NotificationAddedSuccess();
a.ShowDialog();
}
catch
{
NotificationConnectionError a = new NotificationConnectionError();
a.ShowDialog();
}
}
}
private void BtnAddPosition_Click(object sender, EventArgs e)
{
if (TxtFirstName.Text == "" || TxtMiddleName.Text == "" || TxtLastName.Text == "" || TxtUsername.Text == "" || TxtPassword.Text == "")
{
NotificationFillBlank a = new NotificationFillBlank();
a.ShowDialog();
}
else if (TxtFirstName.Text == "E.G. MERCADO RIZAL" || TxtMiddleName.Text == "E.G. JOSE PROTASIO JR." || TxtLastName.Text == "E.G. ALONSO REALONDA" || TxtUsername.Text == "Username" || TxtPassword.Text == "Password")
{
NotificationFillBlank a = new NotificationFillBlank();
a.ShowDialog();
}
else
{
InserAccount();
GetAccountInfo();
try
{
con.Open();
String query = "insert into voters(account_id, last_name, first_name, middle_name, track, strand) values (@voters_id, @last_name, @first_name, @middle_name, @track, @strand)";
MySqlCommand cmd = new MySqlCommand(query, con);
cmd.Parameters.AddWithValue("@voters_id", user_id);
cmd.Parameters.AddWithValue("@last_name", TxtLastName.Text);
cmd.Parameters.AddWithValue("@first_name", TxtFirstName.Text);
cmd.Parameters.AddWithValue("@middle_name", TxtMiddleName.Text);
cmd.Parameters.AddWithValue("@track", TxtTrack.Text);
cmd.Parameters.AddWithValue("@strand", TxtStrand.Text);
cmd.ExecuteNonQuery();
con.Close();
LogHistory(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user);
CloseTransparent();
NotificationAddedSuccess a = new NotificationAddedSuccess();
a.ShowDialog();
}
catch
{
NotificationConnectionError a = new NotificationConnectionError();
a.ShowDialog();
}
}
}
