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