public static List <Airport> GetAirports()
{
using (var db = new GuestlogixContext())
{
var result = db.Database
.SqlQuery <Airport>("GetAirports").ToList();
return(result);
}
}
public static List <Route> GetRoutes()
{
using (var db = new GuestlogixContext())
{
var result = db.Database
.SqlQuery <Route>("GetRoutes").ToList();
return(result);
}
}
public static Airport GetAirport(string code)
{
using (var db = new GuestlogixContext())
{
var codeParam = new SqlParameter("@Code", code);
var result = db.Database
.SqlQuery <Airport>("GetAirport @Code", codeParam).FirstOrDefault();
return(result);
}
}
public static Route GetRoute(string origin, string destination)
{
using (var db = new GuestlogixContext())
{
var originParam = new SqlParameter("@Origin", origin);
var destParam = new SqlParameter("@Dest", destination);
var result = db.Database
.SqlQuery <Route>("GetRoute @Origin,@Dest", originParam, destParam).FirstOrDefault();
return(result);
}
}
// GET: api/CreateData
public Response Post()
{
var filePath = Path.Combine(HttpRuntime.AppDomainAppPath, "App_Data/routes.csv");
using (var reader = new StreamReader(filePath))
{
using (var csv = new CsvReader(reader))
{
var records = csv.GetRecords <DataVm>().ToList();
var values = new List <Route>();
if (records.Any())
{
using (var db = new GuestlogixContext())
{
foreach (var record in records)
{
//var origin =
// db.Airports.FirstOrDefault(c => c.Iata3.ToLower() == record.Origin.ToLower());
//var destination = db.Airports.FirstOrDefault(c => c.Iata3.ToLower() == record.Destination.ToLower());
//if (origin != null && destination != null)
//{
values.Add(new Route()
{
AirlineId = record.AirlineId,
Origin = record.Origin,
Destination = record.Destination
});
//}
}
if (values.Any())
{
db.Routes.AddRange(values);
db.SaveChanges();
return(new Response()
{
Success = true,
Message = values.Count + " Records Added.",
Data = values
});
}
}
}
return(new Response()
{
Success = false
});
}
}
}
