private void RefreshcbBuses()
{
CitiRepository cityRep = new CitiRepository();
RefreshBindingSourse();
dtpDepartureDate.MinDate = DateTime.Now;
dtpArrivalDate.MinDate = DateTime.Now;
dtpFinalDateFlight.MinDate = DateTime.Now;
cbCityStart.DisplayMember = "CityName";
cbCityStart.ValueMember = "CityId";
cbCityStart.DataSource = cityRep.GetAll();
cbCityEnd.DisplayMember = "CityName";
cbCityEnd.ValueMember = "CityId";
cbCityEnd.DataSource = cityRep.GetAll();
BusRepository busRep = new BusRepository();
FlightRepository flightRep = new FlightRepository();
var busybus = flightRep.GetAll().Select(p => p.BusId).ToList();
int count = 0;
var tempBuses = busRep.GetAll();
while (count < busybus.Count)
{
tempBuses = tempBuses.Where(p => p.BusId != busybus[count]).ToList();
count++;
}
cbBuses.DisplayMember = "BusName";
cbBuses.ValueMember = "BusId";
cbBuses.DataSource = tempBuses;
}
private void EditCity()
{
listbusFlights.Clear();
Cities city = binSourceBusStation.Current as Cities;
CitiRepository cityrep = new CitiRepository();
List <TempFlightId> listFlightId = new List <TempFlightId>();
List <BusinessTickets> busTicketsC = DeleteTicketsANDFlights(city, ref listbusFlights);
cityrep.Delete(city);
Cities newcity = new Cities();
newcity.CityName = city.CityName;
newcity.Information = city.Information;
cityrep.Create(newcity);
if (listbusFlights.Count > 0)
{
BusinessFlights busFlight;
BusinessFlightsRepository busFlightrep = new BusinessFlightsRepository();
TempFlightId ekz;
for (int i = 0; i < listbusFlights.Count; i++)
{
busFlight = new BusinessFlights();
ekz = new TempFlightId();
busFlight.FlightNumber = listbusFlights[i].FlightNumber;
busFlight.CityIdStart = listbusFlights[i].CityIdStart == city.CityId ? newcity.CityId : listbusFlights[i].CityIdStart;
busFlight.CityIdEnd = listbusFlights[i].CityIdEnd == city.CityId ? newcity.CityId : listbusFlights[i].CityIdEnd;
busFlight.DepartureDate = listbusFlights[i].DepartureDate;
busFlight.DepartureTime = listbusFlights[i].DepartureTime;
busFlight.ArrivalDate = listbusFlights[i].ArrivalDate;
busFlight.ArrivaTime = listbusFlights[i].ArrivaTime;
busFlight.BusId = listbusFlights[i].BusId;
busFlight.Price = listbusFlights[i].Price;
busFlightrep.Create(busFlight);
FlightRepository newflight = new FlightRepository();
ekz.oldId = listbusFlights[i].FlightId;
ekz.newId = newflight.GetAll().Select(p => p.FlightId).Last();
listFlightId.Add(ekz);
}
}
if (busTicketsC.Count > 0)
{
BusinessTickets bustick;
BusinessTicketsRepository bustickrep = new BusinessTicketsRepository();
for (int i = 0; i < busTicketsC.Count; i++)
{
bustick = new BusinessTickets();
for (int j = 0; j < listFlightId.Count; j++)
{
if (busTicketsC[i].FlightId == listFlightId[j].oldId)
{
bustick.FlightId = listFlightId[j].newId;
break;
}
}
bustick.ReleaseDate = busTicketsC[i].ReleaseDate;
bustick.SeatId = busTicketsC[i].SeatId;
bustick.DiscountId = busTicketsC[i].DiscountId;
bustick.Sold = busTicketsC[i].Sold;
bustick.Reserve = busTicketsC[i].Reserve;
bustick.Canceled = busTicketsC[i].Canceled;
bustickrep.Create(bustick);
}
}
MessageBox.Show("City Edit");
}