public IHttpActionResult PostTrip(Trip trip)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.Trip.Add(trip);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = trip.id }, trip));
}
public IHttpActionResult SaveCart(SuperTripViewModel superTripVM)
{
string user_id = User.Identity.GetUserId();
AspNetUsers user = (from o in db.AspNetUsers
where o.Id == user_id
select o).FirstOrDefault();
Orders ordertodelete = (from o in db.Orders
where o.AspNetUsers == user && o.status == 0
select o).FirstOrDefault();
if (ordertodelete != null)
{
db.Orders.Remove(ordertodelete);
}
Orders order = new Orders {
id_supertrip = superTripVM.SupertripId, id_user = user_id, quantity = superTripVM.Quantity
};
db.Orders.Add(order);
db.SaveChanges();
return(Ok(superTripVM));
}
private static void AddSuperTrip(SuperTrip superTrip)
{
TrainCommanderEntities db = new TrainCommanderEntities();
if (!db.SuperTrip.Any(o =>
o.id_departure_station == superTrip.id_departure_station &&
o.id_arrival_station == superTrip.id_arrival_station &&
o.departure_date == superTrip.departure_date))
{
db.SuperTrip.Add(superTrip);
}
db.SaveChanges();
}
public IHttpActionResult GetStationSNCFId(string name)
{
string idSncf;
var search = (from o in db.Station
where o.name.ToLower() == name.ToLower()
select o).FirstOrDefault();
if (search.id_sncf == null)
{
idSncf = JourneyProvider.GetIDFromPlace(name);
search.id_sncf = idSncf;
db.SaveChanges();
}
return(Ok(search.id_sncf));
}
public static string GetStationSNCFId(string name)
{
TrainCommanderEntities db = new TrainCommanderEntities();
string idSncf;
var search = (from o in db.Station
where o.name.ToLower() == name.ToLower()
select o).FirstOrDefault();
if (search.id_sncf == null)
{
idSncf = GetIDFromPlace(name);
search.id_sncf = idSncf;
db.SaveChanges();
}
return(search.id_sncf);
}
public static Station GetStationBySNCFName(string name)
{
TrainCommanderEntities db = new TrainCommanderEntities();
Station station = new Station();
var query = (from o in db.Station
where o.name == name
select o).FirstOrDefault();
if (query == null)
{
station.name = name;
db.Station.Add(station);
db.SaveChanges();
}
else
{
station = query;
}
return(station);
}
private static void AddTrips(List <Trip> trips)
{
TrainCommanderEntities db = new TrainCommanderEntities();
DateTime departure_date = trips.First().departure_date;
DateTime arrival_date = trips.Last().arrival_date;
foreach (Trip trip in trips)
{
if (!db.Trip.Any(o =>
o.id_departure_station == trip.id_departure_station &&
o.id_arrival_station == trip.id_arrival_station &&
o.departure_date == trip.departure_date))
{
SuperTrip supertrip = (from o in db.SuperTrip
where o.departure_date == departure_date && o.arrival_date == arrival_date
select o).FirstOrDefault();
trip.SuperTrip.Add(supertrip);
trip.Train = AddTrain();
db.Trip.Add(trip);
db.SaveChanges();
}
}
}
