private void BtnVote_Click(object sender, EventArgs e) { BtnUnVote.Visible = true; BtnVote.Visible = false; GlobalVar.candidate_id = lblcandidateid.Text; GlobalVar.position = lblposition.Text; GlobalVar.fullname = lblfullname.Text; DeleteVote(); try { con.Open(); String query = "insert into votes (voters_id,candidate_id,position) values (@voters_id, @candidate_id, @position)"; MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("@voters_id", GlobalVar.voters_id); cmd.Parameters.AddWithValue("@candidate_id", GlobalVar.candidate_id); cmd.Parameters.AddWithValue("@position", GlobalVar.position); cmd.ExecuteNonQuery(); con.Close(); LogHistoryUnVote(GlobalVar.account_id, GlobalVar.user_type, GlobalVar.user); NotificationAddedSuccess a = new NotificationAddedSuccess(); 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 BtnRegisterTeacher_Click(object sender, EventArgs e) { try { con.Open(); MemoryStream ms = new MemoryStream(); StudentPicture.Image.Save(ms, StudentPicture.Image.RawFormat); byte[] a = ms.GetBuffer(); ms.Close(); String query = "insert into candidate(img, last_name, first_name, middle_name, birthdate, gender, age, grade, track, strand, partylist, position, platform) values (@img, @last_name, @first_name, @middle_name, @birthdate, @gender, @age, @grade, @track, @strand, @partylist, @position, @platform)"; MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.Add("@img", MySqlDbType.LongBlob).Value = a; cmd.Parameters.AddWithValue("@last_name", TxtStudentLName.Text); cmd.Parameters.AddWithValue("@first_name", TxtStudentFName.Text); cmd.Parameters.AddWithValue("@middle_name", TxtStudentMName.Text); cmd.Parameters.AddWithValue("@birthdate", TxtBirthdate.Text); if (GenderFemaleCheckBox.Checked) { cmd.Parameters.AddWithValue("@gender", "Female"); } else if (GenderMaleCheckBox.Checked) { cmd.Parameters.AddWithValue("@gender", "Male"); } cmd.Parameters.AddWithValue("@age", TxtAge.Text); cmd.Parameters.AddWithValue("@grade", TxtGrade.Text); cmd.Parameters.AddWithValue("@track", TxtTrack.Text); cmd.Parameters.AddWithValue("@strand", TxtStrand.Text); cmd.Parameters.AddWithValue("@partylist", TxtPartylist.Text); cmd.Parameters.AddWithValue("@position", TxtPosition.Text); cmd.Parameters.AddWithValue("@platform", TxtPlatform.Text); cmd.ExecuteNonQuery(); con.Close(); NotificationAddedSuccess b = new NotificationAddedSuccess(); b.ShowDialog(); LogHistory(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user); CloseTransparent(); } 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(); } } }