public IHttpActionResult CreateFlight([FromBody] string flight_data)
{
System.Diagnostics.Debug.WriteLine(flight_data);
int query_result = AdminSQLHandler.CreateNewFlight(JsonConvert.DeserializeObject <Flight>(flight_data));
return(CheckInsertionResult(query_result));
}
public IHttpActionResult CloseFlight([FromUri] string flight)
{
int result = AdminSQLHandler.CloseFlight(flight);
if (result == 1)
{
return(Ok(JSONHandler.BuildMsgJSON(1, "Flight Closed Successfully")));
}
else
{
return(Ok(JSONHandler.BuildMsgJSON(0, "Task Failed")));
}
}
public IHttpActionResult LoginAdmin([FromBody] string adm_credentials)
{
System.Diagnostics.Debug.WriteLine(adm_credentials);
int query_result = AdminSQLHandler.LoginAdmin(JsonConvert.DeserializeObject <Admin>(adm_credentials));
switch (query_result)
{
case 200: return(Ok(JSONHandler.BuildMsgJSON(1, "Login Successful")));
case 401: return(Ok(JSONHandler.BuildMsgJSON(0, "Login Failed")));
}
return(Ok(JSONHandler.BuildMsgJSON(0, "There was an internal error")));
}
public IHttpActionResult GetAllAirplanes()
{
string query_result = AdminSQLHandler.GetAirplanes();
return(Ok(query_result));
}
public IHttpActionResult GetAllActiveFlights()
{
string query_result = AdminSQLHandler.GetActiveFlights();
return(Ok(query_result));
}
public IHttpActionResult CreateSale([FromBody] string sale_data)
{
int query_result = AdminSQLHandler.CreateNewSale(JsonConvert.DeserializeObject <Sale>(sale_data));
return(CheckInsertionResult(query_result));
}
public IHttpActionResult CreateCustomer([FromBody] string cust_data)
{
int query_result = AdminSQLHandler.InsertNewCustomer(JsonConvert.DeserializeObject <Customer>(cust_data));
return(CheckInsertionResult(query_result));
}
public IHttpActionResult InsertAirport([FromBody] string ap_details)
{
int query_result = AdminSQLHandler.InsertNewAirport(JsonConvert.DeserializeObject <Airport>(ap_details));
return(CheckInsertionResult(query_result));
}
public IHttpActionResult InsertUniversity([FromBody] string uni)
{
int query_result = AdminSQLHandler.InsertNewUniversity(JsonConvert.DeserializeObject <University>(uni));
return(CheckInsertionResult(query_result));
}
public IHttpActionResult GetFlightReservation([FromUri] string flight)
{
string reservations = AdminSQLHandler.GetFlightReservations(flight);
return(Ok(reservations));
}
