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