public List<Candidate> loadAuditors() { //get id of candidate whose Position is president List<double> pres_can_ids = new List<double>(); List<Candidate> ret_val = new List<Candidate>(); string sql = "SELECT * FROM `aclcsscvotingsystem`.`tbl_position` " + "WHERE pos_name='Auditor';"; double auditor_id = 0d; GLOBAL_VARS.db.execute(sql); if (GLOBAL_VARS.db.reader.HasRows) { GLOBAL_VARS.db.reader.Read(); auditor_id = Convert.ToDouble(GLOBAL_VARS.db.reader["pos_id"].ToString()); } GLOBAL_VARS.db.reader.Close(); //load all presidents candidate sql = "SELECT * FROM `aclcsscvotingsystem`.`tbl_candidate` " + "WHERE pos_id=" + auditor_id + " ORDER BY pty_id ASC;"; GLOBAL_VARS.db.execute(sql); if (GLOBAL_VARS.db.reader.HasRows) { while (GLOBAL_VARS.db.reader.Read()) { pres_can_ids.Add(Convert.ToDouble(GLOBAL_VARS.db.reader["can_id"].ToString())); } } GLOBAL_VARS.db.reader.Close(); //loop and load then return list of President Candidate object foreach (double pres_can_id in pres_can_ids) { Candidate c = new Candidate(); c.loadCandidate(pres_can_id); ret_val.Add(c); } return ret_val; }
private void frmBallot_Load(object sender, EventArgs e) { this.Location = new Point(this.Left, 0); Candidate can; List<Candidate> presidents = new List<Candidate>(); List<Candidate> vpresidents = new List<Candidate>(); List<Candidate> secretaries = new List<Candidate>(); List<Candidate> auditors = new List<Candidate>(); List<Candidate> treasurers = new List<Candidate>(); List<Candidate> senators = new List<Candidate>(); List<Candidate> representatives = new List<Candidate>(); //presidents can = new Candidate(); presidents = can.loadPresidents(); Candidate p1 = presidents[0]; rbPres1.Text = p1.s.lname + ", " + p1.s.fname + " " + p1.s.mname + "."; lblPress1.Text = p1.pty.pty_name; presidentSal.ImageLocation = @"C:\Users\rodz\Desktop\images\" + p1.img.img_image; Candidate p2 = presidents[1]; rbPres2.Text = p2.s.lname + ", " + p2.s.fname + " " + p2.s.mname + "."; lblPres2.Text = p2.pty.pty_name; prisedentSiam.ImageLocation = @"C:\Users\rodz\Desktop\images\" + p2.img.img_image; //vice presidents can = new Candidate(); vpresidents = can.loadVicePresidents(); Candidate vp1 = vpresidents[0]; rbVpres1.Text = vp1.s.lname + ", " + vp1.s.fname + " " + vp1.s.mname + "."; lblVpres1.Text = vp1.pty.pty_name; vpresidentSal.ImageLocation = @"C:\Users\rodz\Desktop\images\" + vp1.img.img_image; Candidate vp2 = vpresidents[1]; rbVpres2.Text = vp2.s.lname + ", " + vp2.s.fname + " " + vp2.s.mname + "."; lblVpres2.Text = vp2.pty.pty_name; vpresidentSiam.ImageLocation = @"C:\Users\rodz\Desktop\images\" + vp2.img.img_image; //auditor can = new Candidate(); auditors = can.loadAuditors(); Candidate au1 = auditors[0]; rbAuditor1.Text = au1.s.lname + ", " + au1.s.fname + " " + au1.s.mname + "."; lblAuditor1.Text = au1.pty.pty_name; auditorSal.ImageLocation = @"C:\Users\rodz\Desktop\images\" + au1.img.img_image; Candidate au2 = auditors[1]; rbAuditor2.Text = au2.s.lname + ", " + au2.s.fname + " " + au2.s.mname + "."; lblAuditor2.Text = au2.pty.pty_name; auditorSiam.ImageLocation = @"C:\Users\rodz\Desktop\images\" + au2.img.img_image; //secretary can = new Candidate(); secretaries = can.loadSecretaries(); Candidate sec1 = secretaries[0]; rbSecretary1.Text = sec1.s.lname + ", " + sec1.s.fname + " " + sec1.s.mname + "."; lblSecretary1.Text = sec1.pty.pty_name; secretarySal.ImageLocation = @"C:\Users\rodz\Desktop\images\" + sec1.img.img_image; Candidate sec2 = secretaries[1]; rbSecretary2.Text = sec2.s.lname + ", " + sec2.s.fname + " " + sec2.s.mname + "."; lblSecretary2.Text = sec2.pty.pty_name; secretarySiam.ImageLocation = @"C:\Users\rodz\Desktop\images\" + sec2.img.img_image; //treasurer can = new Candidate(); treasurers = can.loadTreasurers(); Candidate tres1 = treasurers[0]; rbTreasurer1.Text = tres1.s.lname + ", " + tres1.s.fname + " " + tres1.s.mname + "."; lblTreasurer1.Text = tres1.pty.pty_name; treasurerSal.ImageLocation = @"C:\Users\rodz\Desktop\images\" + tres1.img.img_image; Candidate tres2 = treasurers[1]; rbTreasurer2.Text = tres2.s.lname + ", " + tres2.s.fname + " " + tres2.s.mname + "."; lblTreasurer2.Text = tres2.pty.pty_name; treasurerSiam.ImageLocation = @"C:\Users\rodz\Desktop\images\" + tres2.img.img_image; //senators can = new Candidate(); senators = can.loadSenators(); Candidate salSenator1 = senators[0]; chkSalSen1.Text = salSenator1.s.lname + ", " + salSenator1.s.fname + " " + salSenator1.s.mname + "."; lblSalSen1.Text = salSenator1.pty.pty_name; senatorSal1.ImageLocation = @"C:\Users\rodz\Desktop\images\" + salSenator1.img.img_image; Candidate salSenator2= senators[1]; chkSalSen2.Text = salSenator2.s.lname + ", " + salSenator2.s.fname + " " + salSenator2.s.mname + "."; lblSalSen2.Text = salSenator2.pty.pty_name; senatorSal2.ImageLocation = @"C:\Users\rodz\Desktop\images\" + salSenator2.img.img_image; Candidate salSenator3 = senators[2]; chkSalSen3.Text = salSenator3.s.lname + ", " + salSenator3.s.fname + " " + salSenator3.s.mname + "."; lblSalSen3.Text = salSenator3.pty.pty_name; senatorSal3.ImageLocation = @"C:\Users\rodz\Desktop\images\" + salSenator3.img.img_image; Candidate salSenator4 = senators[3]; chkSalSen4.Text = salSenator4.s.lname + ", " + salSenator4.s.fname + " " + salSenator4.s.mname + "."; lblSalSen4.Text = salSenator4.pty.pty_name; senatorSal4.ImageLocation = @"C:\Users\rodz\Desktop\images\" + salSenator4.img.img_image; Candidate salSenator5 = senators[4]; chkSalSen5.Text = salSenator5.s.lname + ", " + salSenator5.s.fname + " " + salSenator5.s.mname + "."; lblSalSen5.Text = salSenator5.pty.pty_name; senatorSal5.ImageLocation = @"C:\Users\rodz\Desktop\images\" + salSenator5.img.img_image; Candidate salSenator6 = senators[5]; chkSalSen6.Text = salSenator6.s.lname + ", " + salSenator6.s.fname + " " + salSenator6.s.mname + "."; lblSalSen6.Text = salSenator6.pty.pty_name; senatorSal6.ImageLocation = @"C:\Users\rodz\Desktop\images\" + salSenator6.img.img_image; //============================================ start of siam senators ====================================== Candidate siamSenator1 = senators[6]; chkSiamSen1.Text = siamSenator1.s.lname + ", " + siamSenator1.s.fname + " " + siamSenator1.s.mname + "."; lblSiamSen1.Text = siamSenator1.pty.pty_name; senatorSiam1.ImageLocation = @"C:\Users\rodz\Desktop\images\" + siamSenator1.img.img_image; Candidate siamSenator2 = senators[7]; chkSiamSen2.Text = siamSenator2.s.lname + ", " + siamSenator2.s.fname + " " + siamSenator2.s.mname + "."; lblSiamSen2.Text = siamSenator2.pty.pty_name; senatorSiam2.ImageLocation = @"C:\Users\rodz\Desktop\images\" + siamSenator2.img.img_image; Candidate siamSenator3 = senators[8]; chkSiamSen3.Text = siamSenator3.s.lname + ", " + siamSenator3.s.fname + " " + siamSenator3.s.mname + "."; lblSiamSen3.Text = siamSenator3.pty.pty_name; senatorSiam3.ImageLocation = @"C:\Users\rodz\Desktop\images\" + siamSenator3.img.img_image; Candidate siamSenator4 = senators[9]; chkSiamSen4.Text = siamSenator4.s.lname + ", " + siamSenator4.s.fname + " " + siamSenator4.s.mname + "."; lblSiamSen4.Text = siamSenator4.pty.pty_name; senatorSiam4.ImageLocation = @"C:\Users\rodz\Desktop\images\" + siamSenator4.img.img_image; Candidate siamSenator5 = senators[10]; chkSiamSen5.Text = siamSenator5.s.lname + ", " + siamSenator5.s.fname + " " + siamSenator5.s.mname + "."; lblSiamSen5.Text = siamSenator5.pty.pty_name; senatorSiam5.ImageLocation = @"C:\Users\rodz\Desktop\images\" + siamSenator5.img.img_image; Candidate siamSenator6 = senators[11]; chkSiamSen6.Text = siamSenator6.s.lname + ", " + siamSenator6.s.fname + " " + siamSenator6.s.mname + "."; lblSiamSen6.Text = siamSenator6.pty.pty_name; senatorSiam6.ImageLocation = @"C:\Users\rodz\Desktop\images\" + siamSenator6.img.img_image; }