public async Task <ActionResult> Save(OrderTicketVM orderTicketVM)
{
bool returnOK = await _db.settInn(orderTicketVM);
if (!returnOK)
{
_log.LogInformation("FEILMELDING HER!");
return(BadRequest("FEILMELDNG HER!"));
}
return(Ok("OPERASJON VELLYKKET HER!"));
}
public async Task <OrderTicketVM> getPrice(OrderTicketVM order)
{
OrderTicketVM orderTicketVM = new OrderTicketVM();
//local variables
float adultsTotal = 0;
float studentsTotal = 0;
float kidsTotal = 0;
float seniorTotal = 0;
//float total = 0;
//
orderTicketVM.departure = order.departure;
orderTicketVM.arrival = order.arrival;
orderTicketVM.tripId = order.tripId;
orderTicketVM.numberOfAdults = order.numberOfAdults;
orderTicketVM.numberOfStudents = order.numberOfStudents;
orderTicketVM.numberOfKids = order.numberOfKids;
orderTicketVM.numberOfSeniors = order.numberOfSeniors;
try
{
var selectedTrip = await _db.Trips.FirstOrDefaultAsync(s => s.TripID == order.tripId);
if (selectedTrip == null)
{
return(orderTicketVM);
}
else
{
adultsTotal = order.numberOfAdults * selectedTrip.AdultPrice;
}
studentsTotal = order.numberOfStudents * selectedTrip.StudentPrice;
kidsTotal = order.numberOfKids * selectedTrip.ChildPrice;
seniorTotal = order.numberOfSeniors * selectedTrip.SeniorPrice;
orderTicketVM.totalPrice = adultsTotal + studentsTotal + kidsTotal + seniorTotal;
orderTicketVM.tripId = selectedTrip.TripID;
return(orderTicketVM);;
}
catch (IOException e)
{
if (e.Source != null)
{
Console.WriteLine("IOException source: {0}", e.Source);
}
throw;
}
}
public async Task <List <TripVM> > FindTrip(OrderTicketVM orderTicketVM)
{
var departureStation = await _db.Stations.FirstOrDefaultAsync(s => s.StationName == orderTicketVM.selectedDeparture);
var arrivalStation = _db.Stations.FirstOrDefault(s => s.StationName == orderTicketVM.selectedAarrival);
{
try
{
var query = from t in _db.Trips
orderby t.TripDate
where
t.Departure == departureStation.StationName &&
t.Arrival == arrivalStation.StationName &&
t.TripDate >= orderTicketVM.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(OrderTicketVM order)
{
var nyBestilling = new OrderTicket()
{
Date = DateTime.Now,
NumberOfAdults = order.numberOfAdults,
NumberOfStudents = order.numberOfStudents,
NumberOfKids = order.numberOfKids,
NumberOfSeniors = order.numberOfSeniors,
Departure = order.departure,
Arrival = order.arrival,
TotalPrice = order.totalPrice,
KontoNo = order.kontoNo,
PinKode = order.pinKode,
MobilNo = order.mobilNo,
TripID = order.tripId,
HarBetalt = true
};
try
{
var selectedTrip = await _db.Trips.FirstOrDefaultAsync(s => s.TripID == order.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;
}
}
public ActionResult OrderTicket(OrderTicketVM model)
{
ViewBag.TrainId = new SelectList(db.TrainsModels, "Id", "TrainName");
ViewBag.StationFrom = new SelectList(db.StationModels, "Id", "StationName");
ViewBag.StationTo = new SelectList(db.StationModels, "Id", "StationName");
if (ModelState.IsValid)
{
var ticket = new TicketModel {
TrainId = model.TrainId, CustomerID = User.Identity.Name, OrderDate = model.OrderDate, StationFrom = model.StationFrom, StationTo = model.StationTo, TravelDate = model.TravelDate
};
db.TicketModels.Add(ticket);
db.SaveChanges();
ViewBag.Success = "Your Ticket Successfully Order Thank you...!!!";
return(View());
}
return(View(model));
}
public async Task <OrderTicketVM> GetPrice(OrderTicketVM orderTicketVM)
{
return(await _db.getPrice(orderTicketVM));
}
public async Task <List <TripVM> > FindTrip(OrderTicketVM orderTicketVM)
{
Console.WriteLine(orderTicketVM.selectedDeparture);
Console.WriteLine(orderTicketVM.selectedAarrival);
return(await _db.FindTrip(orderTicketVM));
}
