public async Task <BestillingVM> getPrice(BestillingVM innBestilling)
{
BestillingVM bestillingVM = new BestillingVM();
//local variables
float adultsTotal = 0;
float studentsTotal = 0;
float kidsTotal = 0;
float seniorTotal = 0;
//float total = 0;
//
bestillingVM.departure = innBestilling.departure;
bestillingVM.arrival = innBestilling.arrival;
bestillingVM.tripId = innBestilling.tripId;
bestillingVM.numberOfAdults = innBestilling.numberOfAdults;
bestillingVM.numberOfStudents = innBestilling.numberOfStudents;
bestillingVM.numberOfKids = innBestilling.numberOfKids;
bestillingVM.numberOfSeniors = innBestilling.numberOfSeniors;
try
{
var selectedTrip = await _db.Trips.FirstOrDefaultAsync(s => s.TripID == innBestilling.tripId);
if (selectedTrip == null)
{
return(bestillingVM);
}
else
{
adultsTotal = innBestilling.numberOfAdults * selectedTrip.AdultPrice;
}
studentsTotal = innBestilling.numberOfStudents * selectedTrip.StudentPrice;
kidsTotal = innBestilling.numberOfKids * selectedTrip.ChildPrice;
seniorTotal = innBestilling.numberOfSeniors * selectedTrip.SeniorPrice;
bestillingVM.totalPrice = adultsTotal + studentsTotal + kidsTotal + seniorTotal;
bestillingVM.tripId = selectedTrip.TripID;
return(bestillingVM);;
}
catch (IOException e)
{
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
}
throw;
}
}
public async Task <List <TripVM> > SugestedTrips(BestillingVM bestillingVM)
{
var departureStation = await _db.Stations.FirstOrDefaultAsync(s => s.StationID == bestillingVM.departure);
var arrivalStation = _db.Stations.FirstOrDefault(s => s.StationID == bestillingVM.arrival);
{
try
{
var query = from t in _db.Trips
orderby t.TripDate
where
t.Departure == departureStation.StationName &&
t.Arrival == arrivalStation.StationName &&
t.TripDate >= bestillingVM.selectedDate
select new TripVM()
{
id = t.TripID,
tripDate = t.TripDate,
StringTripDate = t.TripDate.ToString(),
tripTime = t.TripTime,
StringTripTime = t.TripTime.ToString(),
departure = t.Departure,
arrival = t.Arrival,
adultPrice = t.AdultPrice,
studentPrice = t.StudentPrice,
childPrice = t.ChildPrice,
seniorPrice = t.SeniorPrice
};
return(query.ToList());
}
catch (IOException e)
{
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
}
throw;
}
finally
{
_db.Dispose();
}
//return null;
}
}
public async Task <bool> settInn(BestillingVM innBestilling)
{
var nyBestilling = new Bestilling()
{
Date = DateTime.Now,
NumberOfAdults = innBestilling.numberOfAdults,
NumberOfStudents = innBestilling.numberOfStudents,
NumberOfKids = innBestilling.numberOfKids,
NumberOfSeniors = innBestilling.numberOfSeniors,
Departure = innBestilling.departure,
Arrival = innBestilling.arrival,
TotalPrice = innBestilling.totalPrice,
KontoNo = innBestilling.kontoNo,
PinKode = innBestilling.pinKode,
MobilNo = innBestilling.mobilNo,
TripID = innBestilling.tripId,
HarBetalt = true
};
try
{
var selectedTrip = await _db.Trips.FirstOrDefaultAsync(s => s.TripID == innBestilling.tripId);
if (selectedTrip == null)
{
return(false);
}
else
{
nyBestilling.Trip = selectedTrip;
}
//save a Trip
_db.Bestillings.Add(nyBestilling);
await _db.SaveChangesAsync();
return(true);
}
catch (IOException e)
{
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
}
throw;
}
}
