internal static Transports getAllTransports()
{
SqlCommand cmd = new SqlCommand("select t.tid, t.name, p.postID from Transport as t left join Posts as p on t.tid = p.tid", Starter.GetConnection());
SqlDataReader reader = cmd.ExecuteReader();
Transports allTransports = new Transports(); //initialisiere lehre Liste
Transport currentObject = new Transport();
currentObject.transportID = 0;
while (reader.Read())
{
if (currentObject.transportID != reader.GetInt32(0))
{
Transport oneTransport = new Transport();
currentObject = oneTransport;
allTransports.Add(currentObject);
currentObject.transportID = reader.GetInt32(0);
currentObject.transportName = reader.GetString(1);
}
try
{
currentObject.postIDs.Add(reader.GetInt32(2));
}
catch (Exception e)
{
}
}
return(allTransports);
}
public void AddTransport(string name, int level, double posX, double posY, double width,
double height, double vel)
{
Transport transport = new Transport(Transports.Count, name, level, posX, posY, width, height, vel);
Transports.Add(transport);
}
public ServerOptionsViewModel()
{
Host = "localhost";
Port = 1883;
CommunicationTimeout = 10;
Transports.Add(new TransportViewModel("TCP", Transport.TCP));
Transports.Add(new TransportViewModel("WebSocket", Transport.WebSocket));
Transports.SelectedItem = Transports.FirstOrDefault() !;
TlsVersions.Add(new TlsVersionViewModel("no TLS", SslProtocols.None));
TlsVersions.Add(new TlsVersionViewModel("TLS 1.0", SslProtocols.Tls));
TlsVersions.Add(new TlsVersionViewModel("TLS 1.1", SslProtocols.Tls11));
TlsVersions.Add(new TlsVersionViewModel("TLS 1.2", SslProtocols.Tls12));
TlsVersions.Add(new TlsVersionViewModel("TLS 1.3", SslProtocols.Tls13));
TlsVersions.SelectedItem = TlsVersions.FirstOrDefault() !;
}
private async Task <ClientWebSocket> OpenTransport(long?key = 0)
{
long _key = key.HasValue ? key.Value : await Options.KeyGenerator();
ClientWebSocket transport = Transports.ContainsKey(_key) ? Transports[_key] : null;
if (transport != null && transport.State != WebSocketState.Open)
{
if (transport.State != WebSocketState.CloseSent && transport.State != WebSocketState.Aborted)
{
try {
await transport.CloseOutputAsync(WebSocketCloseStatus.NormalClosure,
"Reopening socket",
CancellationToken.None);
} catch (Exception e) {
}
}
Transports.Remove(_key);
transport.Dispose();
}
if (transport == null || transport.State != WebSocketState.Open)
{
transport = new ClientWebSocket();
Uri connectTo = new Uri(Options.BaseConnectionUri, _key.ToString());
await transport.ConnectAsync(connectTo, CancellationToken.None);
if (Transports.ContainsKey(_key))
{
Transports[_key] = transport;
}
else
{
Transports.Add(_key, transport);
}
}
return(transport);
}
public async Task Init()
{
var countries = await _countryService.Get <List <CountryDTO> >(null);
foreach (var country in countries)
{
Countries.Add(country);
}
var hotelData = (await _hotelService.Get <List <HotelDTO> >(null)).OrderByDescending(_ => _.TotalVisits).Take(5);
var tCompanyData = (await _tCompanyService.Get <List <TransportCompanyDTO> >(null)).OrderByDescending(_ => _.TotalReservations).Take(5);
foreach (var hotel in hotelData)
{
Hotels.Add(hotel);
}
foreach (var tcompany in tCompanyData)
{
Transports.Add(tcompany);
}
int visits = 0;
var reservations = await _reservationService.Get <List <ReservationDTO> >(null);
foreach (var item in reservations)
{
visits += item.NumberOfPersons;
}
AllTimeVisits = visits;
//Dictionary<int, int> topOffers = new Dictionary<int, int>();
//Dictionary<int, int> bestHotels = new Dictionary<int, int>();
//Dictionary<int, int> bestTransports = new Dictionary<int, int>();
//#region hotels
//foreach (var hOffer in hOffers)
//{
// var reservations = (await _reservationService.Get<List<ReservationDTO>>(new ReservationSearchRequest { HotelOfferId = hOffer.Id})).Count;
// if (topOffers.ContainsKey(hOffer.HotelId))
// {
// topOffers[hOffer.HotelId] += reservations;
// }
// else
// {
// topOffers.Add(hOffer.HotelId, reservations);
// }
//}
//var offers = bestOffer(ref topOffers, bestHotels);
//foreach (var hotel in offers)
//{
// var bestHotel = await _hotelService.GetById<HotelDTO>(hotel.Key);
// Hotels.Add(bestHotel);
//}
//#endregion
//#region transports
//foreach (var tOffer in tOffers)
//{
// var reservations = (await _reservationService.Get<List<ReservationDTO>>(new ReservationSearchRequest {TransportOfferId = tOffer.Id})).Count;
// if (topOffers.ContainsKey(tOffer.TransportCompanyId))
// {
// topOffers[tOffer.TransportCompanyId] += reservations;
// }
// else
// {
// topOffers.Add(tOffer.TransportCompanyId, reservations);
// }
//}
//offers = bestOffer(ref topOffers, bestTransports);
//foreach (var transport in offers)
//{
// var bestTransport = await _tCompanyService.GetById<TransportCompanyDTO>(transport.Key);
// Transports.Add(bestTransport);
//}
//#endregion
}