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