public async Task <IActionResult> PostAirport([FromBody] Airportt airportt)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
if (airportt.AirportID == Guid.Empty)
{
airportt.AirportID = Guid.NewGuid();
_context.Airportts.Add(airportt);
await _context.SaveChangesAsync();
return(Json(new { success = true, message = "Add new data success." }));
}
else
{
_context.Update(airportt);
await _context.SaveChangesAsync();
return(Json(new { success = true, message = "Edit data success." }));
}
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }));
}
}
public IActionResult AddEdit(Guid id)
{
if (id == Guid.Empty)
{
Airportt airport = new Airportt();
return(View(airport));
}
else
{
return(View(_DBcontext.Airportts.Where(x => x.AirportID.Equals(id)).FirstOrDefault()));
}
}
public IActionResult GetFlight()
{
List<FlightDataTableModel> flights = new List<FlightDataTableModel>();
foreach(Flight f in _context.Flights.ToList())
{
FlightDataTableModel fl = new FlightDataTableModel();
fl.FligthID = f.FligthID;
fl.DepartureDate = f.DepartureDate;
fl.DestinationDate = f.DestinationDate;
fl.AirplaneType = _context.Airplanes.FirstOrDefault(x => x.AirplaneID.Equals(f.AirplaneID)).AirplaneType;
Airportt airportFrom = _context.Airportts.FirstOrDefault(x => x.AirportID.Equals(f.AirportFromAirportID));
Airportt airportTo = _context.Airportts.FirstOrDefault(x => x.AirportID.Equals(f.AirportToAirportID));
fl.AirportFrom = airportFrom.AirportName + "( " + airportFrom.CountryName + ", " + airportFrom.CityName + ")" ;
fl.AirportTo = airportTo.AirportName + "( " + airportTo.CountryName + ", " + airportTo.CityName + ")";
fl.FlightTime = _context.TimeTables.FirstOrDefault(x => x.TimeTableID.Equals(f.TimeTableID)).FlightTime;
fl.PriceFlight = f.PriceFlight;
flights.Add(fl);
}
return Json(new { data = flights });
}
public async Task<IActionResult> PostFlight([FromBody] Flight flight)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
try
{
Airportt airport = _context.Airportts.SingleOrDefault(x => x.AirportID == flight.AirportToAirportID);
flight.AirportToAirportID = airport.AirportID;
if (flight.FligthID == Guid.Empty)
{
flight.FligthID = Guid.NewGuid();
_context.Flights.Add(flight);
await _context.SaveChangesAsync();
return Json(new { success = true, message = "Add new data success." });
}
else
{
_context.Update(flight);
await _context.SaveChangesAsync();
return Json(new { success = true, message = "Edit data success." });
}
}
catch (Exception ex)
{
return Json(new { success = false, message = ex.Message });
}
}
public IActionResult GetTickets()
{
List <TicketDataTableModel> tickets = new List <TicketDataTableModel>();
foreach (Ticket t in _context.Ticket.ToList())
{
TicketDataTableModel model = new TicketDataTableModel();
Flight f = _context.Flights.FirstOrDefault(x => x.FligthID.Equals(t.FlightFligthID));
Airportt airportFrom = _context.Airportts.FirstOrDefault(x => x.AirportID.Equals(f.AirportFromAirportID));
Airportt airportTo = _context.Airportts.FirstOrDefault(x => x.AirportID.Equals(f.AirportToAirportID));
model.TicketID = t.TicketID;
model.Seat = t.Seat;
model.Price = t.Price;
model.OrderDate = t.OrderDate;
model.User = _context.User.FirstOrDefault(x => x.UserId.Equals(t.UserId));
model.AirportFrom = airportFrom.AirportName + "( " + airportFrom.CountryName + ", " + airportFrom.CityName + ")";
model.AirportTo = airportTo.AirportName + "( " + airportTo.CountryName + ", " + airportTo.CityName + ")";
model.DepartureDate = f.DepartureDate;
tickets.Add(model);
}
return(Json(new { data = tickets }));
}
