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 BtnEditTeacher_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 = "update candidate set img = @img, gender = @gender, age = @age, grade = @grade, track = @track, strand = @strand, partylist = @partylist, position = @position, platform = @platform where candidate_id = @id"; MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("@id", lblcandidateid.Text); cmd.Parameters.Add("@img", MySqlDbType.LongBlob).Value = a; 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(); LogHistoryEdit(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user); NotificationEditSuccess d = new NotificationEditSuccess(); d.ShowDialog(); CloseTransparent(); } catch { NotificationConnectionError a = new NotificationConnectionError(); a.ShowDialog(); } }
private void BtnChangePassword_Click(object sender, EventArgs e) { try { con.Open(); String query = "update title set title = @title where title_id = @id"; MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("@id", "1"); cmd.Parameters.AddWithValue("@title", TxtTitle.Text); cmd.ExecuteNonQuery(); con.Close(); LogHistoryEdit(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user); NotificationEditSuccess a = new NotificationEditSuccess(); a.ShowDialog(); } catch { NotificationConnectionError a = new NotificationConnectionError(); a.ShowDialog(); } }
private void BtnChangePassword_Click(object sender, EventArgs e) { try { con.Open(); String query = "update partylist set partylist = @partylist where position_id = @id"; MySqlCommand cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("@id", lblpartylistid.Text); cmd.Parameters.AddWithValue("@position", TxtPosition.Text); cmd.ExecuteNonQuery(); con.Close(); CloseTransparent(); LogHistoryEdit(GlobalVar.user_id, GlobalVar.user_type, GlobalVar.user); NotificationEditSuccess a = new NotificationEditSuccess(); a.ShowDialog(); } catch { NotificationConnectionError a = new NotificationConnectionError(); a.ShowDialog(); } }