public static List <ViewAbleSeats> GetAllViewAbleSeats()
{
List <Seats> lSeat = DatabaseHandler.GetAllSeats();
List <Districts> lDist = DatabaseHandler.GetAllDistricts();
List <ViewAbleSeats> viewSeats = new List <ViewAbleSeats>();
ViewAbleSeats seat;
foreach (Seats s in lSeat)
{
seat = new ViewAbleSeats();
seat.SeatName = s.SeatName;
foreach (Districts d in lDist)
{
if (d.DistrictId == s.DistrictId)
{
seat.DistrictName = d.DistrictName;
break;
}
}
viewSeats.Add(seat);
}
return(viewSeats);
}
public static List <ViewAbleSeats> GetViewAbleSeats(string districtName)
{
List <Seats> lSeat = DatabaseHandler.GetAllSeats();
List <Districts> lDist = DatabaseHandler.GetAllDistricts();
int id = 0;
foreach (Districts d in lDist)
{
if (d.DistrictName == districtName)
{
id = d.DistrictId;
break;
}
}
List <ViewAbleSeats> viewSeats = new List <ViewAbleSeats>();
ViewAbleSeats seat;
foreach (Seats s in lSeat)
{
if (s.DistrictId == id)
{
seat = new ViewAbleSeats();
seat.SeatName = s.SeatName;
seat.DistrictName = districtName;
viewSeats.Add(seat);
}
}
return(viewSeats);
}
