public void RefreshSeats() { DateTime dt = DateTime.Now.Date; cbSeats.DataSource = null; BusStationEntities conect = new BusStationEntities(); flight = binSourceBusStation.Current as BusinessFlights; string BussName = flight.Bus; dt = flight.DepartureDate; int Busid = conect.Buses.Where(p => p.BusName == BussName).Select(p => p.BusId).First(); var notSeats = conect.Tickets.Where(p => p.Flights.DepartureDate == dt && p.Flights.BusId == Busid).Select(p => p.SeatId).ToList(); int count = 0; cbSeats.ValueMember = "SeatId"; cbSeats.DisplayMember = "NumberSeat"; var tempSeats = Seatsr.GetAll().Where(p => p.BusId == Busid).ToList(); while (count < notSeats.Count) { tempSeats = tempSeats.Where(p => p.SeatId != notSeats[count]).ToList(); count++; } cbSeats.DataSource = tempSeats; }
public void RefreshSeats() { if (binSourceBusStation.Count != 0) { flight = binSourceBusStation.Current as BusinessFlights; if (flight.CityStart != null) { DateTime dt = DateTime.Now.Date; cbSeats.DataSource = null; BusStationEntities conect = new BusStationEntities(); BusRepository busrep = new BusRepository(); BusinessTicketsRepository btr = new BusinessTicketsRepository(); string BussName = flight.Bus; dt = flight.DepartureDate; int Busid = busrep.GetAll().Where(p => p.BusName == BussName).Select(p => p.BusId).First(); var notSeats = conect.Tickets.Where(p => p.Flights.DepartureDate == dt && p.Flights.BusId == Busid).Select(p => p.SeatId).ToList(); int count = 0; cbSeats.ValueMember = "SeatId"; cbSeats.DisplayMember = "NumberSeat"; var tempSeats = Seatsr.GetAll().Where(p => p.BusId == Busid).ToList(); while (count < notSeats.Count) { tempSeats = tempSeats.Where(p => p.SeatId != notSeats[count]).ToList(); count++; } cbSeats.DataSource = tempSeats; } else { MessageBox.Show("Выберите рейс"); } } }
private void bRoleCreate_Click(object sender, EventArgs e) { FormCreateRole crRole = new FormCreateRole(); crRole.UEForm = this; this.Visible = false; if (crRole.ShowDialog() == DialogResult.OK) { BusStationEntities context = new BusStationEntities(); Roles role = new Roles(); role.RoleName = crRole.tbRoleName.Text; context.Roles.Add(role); context.SaveChanges(); MessageBox.Show("Role Add"); GetRoles(); } }
private void bBuyTicket_Click(object sender, EventArgs e) { BusStationEntities conect = new BusStationEntities(); if (cbCityStart.Text != "" && cbCityEnd.Text != "" && cbSeats.Text != "") { DataBase.DataBaseBuses.Tickets ticket = new DataBase.DataBaseBuses.Tickets(); ticket.ReleaseDate = DateTime.Now.Date; ticket.FlightId = flight.FlightId; ticket.SeatId = Convert.ToInt32(cbSeats.SelectedValue); ticket.DiscountId = Convert.ToInt32(cbDiscount.SelectedValue); ticket.Sold = true; conect.Tickets.Add(ticket); conect.SaveChanges(); MessageBox.Show("Ticket Sold"); RefreshSeats(); } else { MessageBox.Show("Fill in all the fields"); } }