public static List <ViewAbleCandidates> GetViewAbleCandidates(int seatId) { List <ViewAbleCandidates> vCandidate = new List <ViewAbleCandidates>(); List <Candidates> candidates = DatabaseHandler.GetAllCandidates(); List <Seats> lSeats = DatabaseHandler.GetAllSeats(); List <Teams> lTeam = DatabaseHandler.GetAllTeams(); ViewAbleCandidates vCan; string seatName = ""; foreach (Seats s in lSeats) { if (s.SeatId == seatId) { seatName = s.SeatName; break; } } foreach (Candidates can in candidates) { if (can.SeatId == seatId) { vCan = new ViewAbleCandidatesAdmin(); vCan.CandidateName = can.CandidateName; vCan.SeatName = seatName; foreach (Teams t in lTeam) { if (t.TeamId == can.TeamId) { vCan.TeamName = t.TeamName; vCan.Symbol = t.Symbol; break; } } vCan.CandidateId = can.CandidateId; vCandidate.Add(vCan); } } return(vCandidate); }
public static List <ViewAbleCandidatesAdmin> GetViewAbleCandidatesAdmin(string seatName) { List <ViewAbleCandidatesAdmin> vCandidateAdmin = new List <ViewAbleCandidatesAdmin>(); List <Candidates> candidates = DatabaseHandler.GetAllCandidates(); List <Seats> lSeats = DatabaseHandler.GetAllSeats(); List <Teams> lTeam = DatabaseHandler.GetAllTeams(); ViewAbleCandidatesAdmin vCanAd; int seatId = 0; foreach (Seats seat in lSeats) { if (seat.SeatName == seatName) { seatId = seat.SeatId; break; } } foreach (Candidates can in candidates) { if (can.SeatId == seatId) { vCanAd = new ViewAbleCandidatesAdmin(); vCanAd.CandidateName = can.CandidateName; vCanAd.SeatName = seatName; foreach (Teams t in lTeam) { if (t.TeamId == can.TeamId) { vCanAd.TeamName = t.TeamName; vCanAd.Symbol = t.Symbol; break; } } vCanAd.CandidateId = can.CandidateId; vCanAd.ObtainedVotes = can.ObtainedVotes; vCandidateAdmin.Add(vCanAd); } } return(vCandidateAdmin); }