public IEnumerable <BusinessTickets> GetAll(Buses bus)
{
return
((from t in context.Tickets
where t.Flights.Buses.BusId == bus.BusId
select new BusinessTickets
{
TicketId = t.TicketId,
ReleaseDate = t.ReleaseDate,
FlightId = t.FlightId,
FlightNumber = t.Flights.FlightNumber,
CityStart = t.Flights.Cities1.CityName,
CityEnd = t.Flights.Cities.CityName,
DepartureDate = t.Flights.DepartureDate,
DepartureTime = t.Flights.DepartureTime,
ArrivalDate = t.Flights.ArrivalDate,
ArrivaTime = t.Flights.ArrivaTime,
Bus = t.Flights.Buses.BusName,
SeatId = t.SeatId,
NumberSeat = t.Seats.NumberSeat,
Price = t.Flights.Price,
DiscountId = t.DiscountId,
DiscountName = t.Discounts.DiscountName,
PriceWithDiscount = t.Flights.Price - (t.Flights.Price * t.Discounts.Size) / 100,
Sold = t.Sold,
Reserve = t.Reserve,
Canceled = t.Canceled
}
).ToList());
}
private async void NavigationHelper_LoadState(object sender, LoadStateEventArgs e)
{
if (!isLoaded)
{
Constant.Loader(this.resourceLoader.GetString("GlobalLoading"), true);
param = JsonConvert.DeserializeObject <StopNameAllSQL>(e.NavigationParameter.ToString());
this.DefaultViewModel["Title"] = param.name;
this.DefaultViewModel["Favorite"] = Database.IfAllStopsAreFavorite(Int32.Parse(param.id)) ? Constant.FavoriteStar : Constant.UnFavoriteStar;
await Task.Run(() => LoadRoutes(param));
isLoaded = true;
Constant.Loader(this.resourceLoader.GetString("GlobalLoadingSuccess"), false);
await Windows.ApplicationModel.Core.CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.Normal,
async() =>
{
while (true)
{
await Task.Delay(10000);
foreach (var item in Buses)
{
Buses.Where(d => d.d_id == item.d_id).First().Next_Bus = time.getNextBusTime(item.schedule, item.days);
}
foreach (var item in Trolls)
{
Trolls.Where(d => d.d_id == item.d_id).First().Next_Bus = time.getNextBusTime(item.schedule, item.days);
}
foreach (var item in Tramms)
{
Tramms.Where(d => d.d_id == item.d_id).First().Next_Bus = time.getNextBusTime(item.schedule, item.days);
}
}
}
);
}
}
private async void NavigationHelper_LoadState(object sender, LoadStateEventArgs e)
{
if (!isLoaded)
{
Constant.Loader(this.resourceLoader.GetString("GlobalLoading"), true);
this.DefaultViewModel["Title"] = "Route";
await Task.Run(() => LoadRoute());
isLoaded = true;
Constant.Loader(this.resourceLoader.GetString("GlobalLoadingSuccess"), false);
await Windows.ApplicationModel.Core.CoreApplication.MainView.CoreWindow.Dispatcher.RunAsync(CoreDispatcherPriority.Normal,
async() =>
{
while (true)
{
await Task.Delay(10000);
foreach (var item in Buses)
{
Buses.Where(d => d.d_id == item.d_id).First().Next_Bus = time.getNextBusTime(item.schedule, item.days);
}
foreach (var item in Trolls)
{
Trolls.Where(d => d.d_id == item.d_id).First().Next_Bus = time.getNextBusTime(item.schedule, item.days);
}
foreach (var item in Tramms)
{
Tramms.Where(d => d.d_id == item.d_id).First().Next_Bus = time.getNextBusTime(item.schedule, item.days);
}
}
}
);
}
}
void addNewItem_Click(object sender, EventArgs e)
{
switch (flag)
{
case "Buses":
dgvBusStation.EndEdit();
Buses bus = (Buses)binSourceBusStation.Current;
BusRepository rep = new BusRepository();
rep.Create(bus);
Seats seat;
SeatsRepository seatrep = new SeatsRepository();
for (int i = 0; i < bus.CountSeats; i++)
{
seat = new Seats();
seat.BusId = bus.BusId;
seat.NumberSeat = i + 1;
seatrep.Create(seat);
}
break;
default:
dgvBusStation.EndEdit();
T t = (T)binSourceBusStation.Current;
repository.Create(t);
break;
}
}
public IHttpActionResult PutBuses(int id, Buses buses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != buses.BusId)
{
return(BadRequest());
}
db.Entry(buses).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!BusesExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public void RandomBusesAndPassengers()
{
Random rnd = new Random();
//Buses.Add(new Bus(BusStops[0].X, BusStops[0].Y + 76, X, 100, firstLevel, secondLevel));
foreach (var busstop in BusStops)
{
int N = rnd.Next(1, 2);
for (int i = 0; i < N; i++)
{
Buses.Add(new Bus(busstop.X + 127 * i, busstop.Y + 76, X, 100, firstLevel, secondLevel));
}
int P = rnd.Next(4, 7);
for (int i = 0; i < P; i++)
{
busstop.AddPassenger(busstop.X + (108) * i, busstop.Y + 90);
//busstop.Passengers[i].BusStop = busstop;
}
}
Buses[0].Passengers = new List <SimpleMan>();
SimpleMan simpleMan = new SimpleMan();
simpleMan.Bus = Buses[0];
Buses[0].BusStopEvent += simpleMan.FromBus;
Buses[0].FullEvent += simpleMan.CheckOnFull;
Buses[0].Passengers.Add(simpleMan);
background.Start();
}
public void AddBus(int n)
{
List <SimpleMan> newPassengers = new List <SimpleMan>();
for (int i = 0; i < n; i++)
{
newPassengers.Add(new SimpleMan());
}
Random rnd = new Random();
Bus bus = new Bus(BusStops[rnd.Next(0, 2)].X, BusStops[rnd.Next(0, 2)].Y + 76, X, 100, firstLevel, secondLevel, newPassengers);
if (Passengers == null)
{
Passengers = new List <SimpleMan>();
}
Passengers.AddRange(newPassengers);
Buses.Add(bus);
TimeEvent += bus.Time;
//List<SimpleMan> newPassengers = new List<SimpleMan>();
//for (int i = 0; i < n; i++)
//{
// newPassengers.Add(new SimpleMan());
//}
//Bus bus = new Bus(newPassengers);
//if (Passengers == null)
// Passengers = new List<SimpleMan>();
//Passengers.AddRange(newPassengers);
//Buses.Add(bus);
//TimeTickEvent += bus.TimeTick;
}
public async Task <IActionResult> Edit(int id, [Bind("BusId,Name,Age")] Buses buses)
{
if (id != buses.BusId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(buses);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BusesExists(buses.BusId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(buses));
}
//Опис: Методот креира нов бас во базата за Басови
//Прво се проверува дали постои веќе таков бас во база, и ако постои, се јавува грешка
//Влезни параметри: Објект од класата Buses
public void CreateBus(Buses bus)
{
var busExist = _uow.Context.Buses.Find(bus.Code);
if (busExist != null)
{
throw new DuplicateBusException(bus);
}
UrlAttribute.IsValid(bus.Url);
try
{
_uow.Context.Buses.Add(bus);
_uow.Context.SaveChanges();
}
catch (DbUpdateException ex)
{
SqlException s = ex.InnerException.InnerException as SqlException;
if (s != null && s.Number == 2627)
{
throw new DuplicateBusException(bus);
}
}
}
public void Dispose()
{
Buses.Dispose();
BusStatuses.Dispose();
Mechanics.Dispose();
Workshops.Dispose();
}
public void RemoveBus(Bus b)
{
Buses.Remove(b);
foreach (Module m in b.ConnectedModules)
{
m.BusConnections.Remove(b);
}
}
public void MinTimestampWhenBusesAreInCorrectPositionTest()
{
var strings = File.ReadLines(Program.InputTxt).ToList();
var busesStrings = strings.Skip(1).First().Split(',');
var buses = new Buses(busesStrings);
buses.MinTimestampWhenBusesAreInCorrectPosition().Should().Be(415579909629976L);
}
public ActionResult Edit([Bind(Include = "BusId,BusName")] Buses buses)
{
if (ModelState.IsValid)
{
db.Entry(buses).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(buses));
}
public ActionResult Delete(int id)
{
BusdbEntities db = new BusdbEntities();
Buses find = new Buses();
var xx = db.buses.Where(x => x.bid == id).FirstOrDefault();
db.buses.Remove(xx);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void MinNextBusTest()
{
var strings = File.ReadLines(Program.InputTxt).ToList();
var timestamp = long.Parse(strings.First());
var busesStrings = strings.Skip(1).First().Split(',');
var buses = new Buses(busesStrings);
var(bus, nextIn) = buses.MinNextBus(timestamp);
(bus.Frequency * nextIn).Should().Be(3865L);
}
public IActionResult AddEdit(int?id)
{
Buses model = new Buses();
if (id != null)
{
model = _ctx.Buses.Find(id);
}
return(View(model));
}
public void CreateBus(Buses bus)
{
try
{
_busesRepository.CreateBus(bus);
}
catch (DuplicateBusException ex)
{
throw new HttpException(ex.Message);
}
}
public async Task <IActionResult> Create([Bind("BusId,Name,Age")] Buses buses)
{
if (ModelState.IsValid)
{
_context.Add(buses);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(buses));
}
public async Task <IActionResult> Create([Bind("BusId,BusNumb,Capacity,Condition,Handicap,DriverId,RouteId")] Buses buses)
{
if (ModelState.IsValid)
{
_context.Add(buses);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(buses));
}
public IHttpActionResult GetBuses(int id)
{
Buses buses = db.Buses.Find(id);
if (buses == null)
{
return(NotFound());
}
return(Ok(buses));
}
//Opens bus edit dialog on the clicked bus
public void EditBus(object parameter)
{
if (parameter is CSPBus)
{
CSPBusEditDialog editDialog = new CSPBusEditDialog(md);
CSPBusVM busVM = new CSPBusVM((CSPBus)parameter);
editDialog.DataContext = busVM;
editDialog.ShowDialog();
Buses.Refresh();
}
}
//public static IStudentTransactionRepository transactions;
//public IStudentTransactionRepository Transactions => transactions ??= new StudentTransactionRepository();
private static Buses ReadBuses()
{
var buses = DataReader.ReadBuses("Buses")
.Distinct(x => x.RegistrantionNo, x => x.State);
var voucher = new Buses(3000);
foreach (var u in buses)
{
voucher.Add(u);
}
return(voucher);
}
public IHttpActionResult PostBuses(Buses buses)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Buses.Add(buses);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = buses.BusId }, buses));
}
protected virtual IServiceBus SetupServiceBus(Uri uri, Action <ServiceBusConfigurator> configure)
{
IServiceBus bus = ServiceBusFactory.New(x =>
{
x.ReceiveFrom(uri);
configure(x);
});
Buses.Add(bus);
return(bus);
}
static void Main(string[] args)
{
var days = new List <IDay>()
{
ExpenseReport.LoadFromFile("Day01/ExpenseReport.txt"),
PasswordValidator.LoadFromFile("Day02/Passwords.txt"),
Map.LoadFromFile("Day03/Map.txt"),
PassportValidator.LoadFromFile("Day04/PassportData.txt"),
BoardingPasses.LoadFromFile("Day05/Seats.txt"),
Declerations.LoadFromFile("Day06/Declerations.txt"),
LuggageRules.LoadFromFile("Day07/LuggageRules.txt"),
GameConsole.LoadFromFile("Day08/BootCode.txt"),
AdditionSystem.LoadFromFile("Day09/Data.txt"),
JoltAdapters.LoadFromFile("Day10/JoltAdapters.txt"),
SeatingLayout.LoadFromFile("Day11/SeatingLayout.txt"),
Navigation.LoadFromFile("Day12/NavigationInstructions.txt"),
Buses.LoadFromFile("Day13/Buses.txt"),
DockingProgram.LoadFromFile("Day14/DockingProgram.txt"),
MemoryGame.Create("15,12,0,14,3,1"),
TicketAnalyser.LoadFromFile("Day16/TicketData.txt"),
ConwayCube.LoadFromFile("Day17/ConwayCube.txt"),
OperationOrder.LoadFromFile("Day18/Expressions.txt"),
JurassicJigsaw.LoadFromFile("Day20/Tiles.txt"),
Combat.LoadFromFile("Day22/Cards.txt")
};
var invalidCount = 0;
foreach (var day in days)
{
var part1 = day.Part1();
var part2 = day.Part2();
var part1Invalid = !string.IsNullOrWhiteSpace(day.ValidatedPart1) &&
part1 != day.ValidatedPart1;
var part2Invalid = !string.IsNullOrWhiteSpace(day.ValidatedPart2) &&
part2 != day.ValidatedPart2;
invalidCount += part1Invalid ? 1 : 0;
invalidCount += part2Invalid ? 1 : 0;
var part1InvalidString = part1Invalid ? " INVALID" : "";
var part2InvalidString = part2Invalid ? " INVALID" : "";
Console.WriteLine($"Day {day.DayNumber} Part 1: {part1}{part1InvalidString}");
Console.WriteLine($"Day {day.DayNumber} Part 2: {part2}{part2InvalidString}");
}
Console.WriteLine($"{invalidCount} INVALID Results");
}
private List <BusinessTickets> DeleteTicketsFlightsSeats(Buses bus, ref List <BusinessFlights> busFlights, ref List <Seats> listseats)
{
List <BusinessTickets> busTickets = new List <BusinessTickets>();
BusinessTickets obj = new BusinessTickets();
BusinessTicketsRepository busTickRep = new BusinessTicketsRepository();
BusinessFlights objFlights = new BusinessFlights();
BusinessFlightsRepository busFlightsRep = new BusinessFlightsRepository();
Seats seats = new Seats();
SeatsRepository seatsrep = new SeatsRepository();
int countTick = busTickRep.GetAll(bus).ToList().Count;
int countFlight = busFlightsRep.GetAll(bus).ToList().Count;
int countSeat = seatsrep.GetAll().Where(p => p.BusId == bus.BusId).Count();
if (countTick > 0)
{
while (countTick-- > 0)
{
obj = busTickRep.GetAll(bus).First();
busTickets.Add(obj);
busTickRep.Delete(obj);
}
while (countFlight-- > 0)
{
objFlights = busFlightsRep.GetAll(bus).First();
busFlights.Add(objFlights);
busFlightsRep.Delete(objFlights);
}
flagdelete = 1;
}
else
{
while (countFlight-- > 0)
{
objFlights = busFlightsRep.GetAll(bus).First();
busFlights.Add(objFlights);
busFlightsRep.Delete(objFlights);
}
flagdelete = 1;
}
while (countSeat-- > 0)
{
seats = seatsrep.GetAll().Where(p => p.BusId == bus.BusId).First();
listseats.Add(seats);
seatsrep.Delete(seats);
}
return(busTickets);
}
//Opens module edit dialog on the clicked module
public void EditModule(object parameter)
{
Module module = (Module)parameter;
ModuleVM moduleVM = new ModuleVM(module);
ModuleEditDialog editDialog = new ModuleEditDialog(md);
editDialog.DataContext = moduleVM;
editDialog.BusListDataContext = Buses;
editDialog.ShowDialog();
//Forces binding of button text to update
Modules.Refresh();
Buses.Refresh();
}
public ActionResult Details(int id)
{
BusdbEntities db = new BusdbEntities();
Buses find = new Buses();
var xx = db.buses.Where(x => x.bid == id).FirstOrDefault();
find.Busid = xx.bid;
find.BusName = xx.bname;
find.BusType = xx.btype;
find.MaxSeat = xx.max_seats;
return(View(find));
}
public IHttpActionResult DeleteBuses(int id)
{
Buses buses = db.Buses.Find(id);
if (buses == null)
{
return(NotFound());
}
db.Buses.Remove(buses);
db.SaveChanges();
return(Ok(buses));
}
public void GetTestData()
{
Buses.Clear();
Moves.Clear();
Buses.Add(new Bus(Buses.Count() + 1, 10, 10 * Constans.MinutesInHour));
Buses.Add(new Bus(Buses.Count() + 1, 20, 12 * Constans.MinutesInHour));
Moves.Add(new Move(1, 1, 3, 5));
Moves.Add(new Move(1, 3, 1, 7));
Moves.Add(new Move(2, 1, 2, 10));
Moves.Add(new Move(2, 2, 4, 5));
Moves.Add(new Move(2, 4, 1, 20));
SetPeriods();
StationCount = 5;
}
