public IQueryable <RentaCar> GetRentaCarByFlightReservation(int userId)
{
var reservations = new List <FlightReservation>();
var flightsList = new List <Flight>();
using (var context = new AngularEntities4())
{
var flightsRes = from f in context.FlightReservations
where f.UserId == userId
select f;
reservations = flightsRes.ToList();
}
//FlightReservation fr= objEntity.FlightReservations.Where(u => u.UserId == userId).LastOrDefault();
int flightId = reservations.Last().FlightId;
using (var context = new AngularEntities4())
{
var flights = from f in context.Flights
where f.Id == flightId
select f;
flightsList = flights.ToList();
}
//Flight flight = objEntity.Flights.Where(f => f.Id == flightId).FirstOrDefault();
string rentaCarLocation = flightsList.First().MestoSletanja;
try
{
return(objEntity.RentaCars.Where(c => c.City.Contains(rentaCarLocation)));
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult GetReservations(int userId)
{
var flightsRes = new List <Prikaz>();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
var id = userId;
var reservations = new List <FlightReservation>();
using (var context = new AngularEntities4())
{
var flights = from f in context.FlightReservations
where f.UserId == id
select f;
reservations = flights.ToList();
}
foreach (FlightReservation f in reservations)
{
var convert = objEntity.Flights.Find(f.FlightId);
flightsRes.Add(new Prikaz()
{
BrojPresedanja = convert.BrojPresedanja,
BrojSedista = convert.BrojSedista,
Cena = f.Price,
DatumPoletanja = convert.DatumPoletanja,
DatumSletanja = convert.DatumSletanja,
DuzinaPutovanja = convert.DuzinaPutovanja,
Id = convert.Id,
IdAvioKompanije = convert.IdAvioKompanije,
MestoPoletanja = convert.MestoPoletanja,
MestoSletanja = convert.MestoSletanja,
OcenaLeta = convert.OcenaLeta,
VremeTrajanjaLeta = convert.VremeTrajanjaLeta
});
}
}
catch (Exception ex)
{
}
return(Ok(flightsRes));
}
public IHttpActionResult SetUserAsAirlineAdmin(string email)
{
using (var objEntity = new AngularEntities4())
{
var user = from u in objEntity.UserDetails where (u.Email == email) select u;
if (user != null)
{
var us = user.First();
us.UserType = Convert.ToInt32(UserType.AirlineAdmin);
objEntity.SaveChanges();
return(Ok(email));
}
else
{
return(NotFound());
}
}
}
public IHttpActionResult Login(Login lg)
{
AngularEntities4 DB = new AngularEntities4();
var Obj = DB.Usp_Login(lg.Email, lg.Password).ToList <Usp_Login_Result>().FirstOrDefault();
if (Obj == null)
{
Obj = new Usp_Login_Result();
Obj.Status = 0;
Obj.Message = "User not found!";
// return NotFound();
}
else
{
Obj.Status = 1;
}
return(Ok(Obj));
}
public IHttpActionResult CancelReservation(string userId, int flightId)
{
FlightReservation reservation = new FlightReservation();
var id = Convert.ToInt32(userId);
using (var context = new AngularEntities4())
{
var flights = from f in context.FlightReservations
where f.UserId == id && f.FlightId == flightId
select f;
reservation = flights.First();
}
if (!objEntity.FlightReservations.Local.Contains(reservation))
{
objEntity.FlightReservations.Attach(reservation);
}
objEntity.FlightReservations.Remove(reservation);
objEntity.SaveChanges();
return(Ok(reservation));
}
public IHttpActionResult GetFlightByFlightId(int flightId)
{
var check = new Flight();
try
{
using (var context = new AngularEntities4())
{
var flight = from f in context.Flights
where f.Id == flightId
select f;
check = flight.FirstOrDefault();
if (check == null)
{
return(NotFound());
}
}
}
catch (Exception)
{
throw;
}
return(Ok(check));
}
public IHttpActionResult GetFlightsById(int airlineId)
{
var check = new List <Flight>();
try
{
using (var context = new AngularEntities4())
{
var flights = from f in context.Flights
where f.IdAvioKompanije == airlineId
select f;
check = flights.ToList();
if (check == null)
{
return(NotFound());
}
}
}
catch (Exception)
{
throw;
}
return(Ok(check));
}
public IHttpActionResult GetFastReservations()
{
List <Prikaz> reservations = new List <Prikaz>();
Prikaz nova = new Prikaz();
using (var context = new AngularEntities4())
{
var flights = from f in context.Flights
where f.Popust == true
select f;
foreach (Flight f in flights)
{
double razlomak = (double)f.CenaEkonomskeKlase / 100;
double umanjilac = (double)f.ProcenatPopusta * razlomak;
double cena = (double)f.CenaEkonomskeKlase - umanjilac;
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = cena,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta,
MestoNaPopustu = f.MestoNaPopustu
};
}
reservations.Add(nova);
}
return(Ok(reservations));
}
public IHttpActionResult GetUser(string datumPoletanja, string datumPovratka, string mestoPoletanja, string mestoSletanja, string klasa, string pravac, int brojPutnika)
{
Prikaz nova = new Prikaz();
//var check = new List<Flight>();
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
DateTime dt = DateTime.ParseExact(datumPoletanja, "M/dd/yy, h:mm tt", CultureInfo.InvariantCulture);
DateTime dt2 = DateTime.ParseExact(datumPovratka, "M/dd/yy, h:mm tt", CultureInfo.InvariantCulture);
try
{
using (var context = new AngularEntities4())
{
var flights = from f in context.Flights
where f.DatumPoletanja == dt && f.DatumSletanja == dt2 && f.BrojSedista - brojPutnika != 0 && f.MestoPoletanja == mestoPoletanja && f.MestoSletanja == mestoSletanja
select f;
check = flights.ToList();
if (check.Count == 0)
{
nova.Status = 0;
nova.Message = "Nema rezultata za trazeni let";
result.Add(nova);
}
else
{
foreach (var f in check)
{
if (klasa == "Prva klasa")
{
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = f.CenaPrveKlase,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta
};
}
if (klasa == "Ekonomska klasa")
{
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = f.CenaEkonomskeKlase,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta
};
}
if (klasa == "Biznis klasa")
{
nova = new Prikaz()
{
BrojPresedanja = f.BrojPresedanja,
BrojSedista = f.BrojSedista,
Cena = f.CenaBiznisKlase,
DatumPoletanja = f.DatumPoletanja,
DatumSletanja = f.DatumSletanja,
DuzinaPutovanja = f.DuzinaPutovanja,
Id = f.Id,
IdAvioKompanije = f.IdAvioKompanije,
MestoPoletanja = f.MestoPoletanja,
MestoSletanja = f.MestoSletanja,
OcenaLeta = f.OcenaLeta,
VremeTrajanjaLeta = f.VremeTrajanjaLeta
};
}
nova.Status = 2;
result.Add(nova);
}
}
}
}
catch (Exception ex)
{
//nova = new Prikaz();
nova.Status = 1;
nova.Message = "Servis je trenutno nedostupan";
result.Add(nova);
}
}
catch (Exception)
{
//nova = new Prikaz();
nova.Status = 1;
nova.Message = "Servis je trenutno nedostupan";
result.Add(nova);
}
return(Ok(result));
}
