public IHttpActionResult SearchFlight([FromBody] string search_params)
{
System.Diagnostics.Debug.WriteLine(search_params);
string query_result = CustomerSQLHandler.FindFlight(JsonConvert.DeserializeObject <Flight>(search_params));
return(Ok(query_result));
}
public IHttpActionResult PayFlight([FromBody] string paym_det, [FromUri] string user)
{
CCard card = JsonConvert.DeserializeObject <CCard>(paym_det);
string result = CustomerSQLHandler.PayFlight(card.card_number, card.security_code, user);
return(Ok(result));
}
public IHttpActionResult CheckStudent([FromUri] string username)
{
if (CustomerSQLHandler.IsStudent(username))
{
return(Ok(JSONHandler.BuildMsgJSON(1, "True")));
}
else
{
return(Ok(JSONHandler.BuildMsgJSON(1, "False")));
}
}
public IHttpActionResult AddPaymentMethod([FromBody] string card_details)
{
int query_result = CustomerSQLHandler.AddCreditCard(JsonConvert.DeserializeObject <CCard>(card_details));
if (query_result == 1)
{
return(Ok(JSONHandler.BuildMsgJSON(1, "Success")));
}
else
{
return(CheckQueryResult(500, String.Empty));
}
}
public IHttpActionResult GetFlightDetails([FromUri] string flight)
{
string result = CustomerSQLHandler.GetFlightDetails(flight);
return(Ok(result));
}
public IHttpActionResult GetUserCards([FromUri] string username)
{
string cards_json = CustomerSQLHandler.GetCards(username);
return(Ok(cards_json));
}
public IHttpActionResult GetReservationCost([FromBody] string reservation)
{
Tuple <int, string> cost = CustomerSQLHandler.GetReservationCost(JsonConvert.DeserializeObject <Reservation>(reservation));
return(Ok(cost.Item2));
}
public IHttpActionResult BookFlight([FromBody] string book_det)
{
string query_result = CustomerSQLHandler.BookFlight(JsonConvert.DeserializeObject <Reservation>(book_det));
return(Ok(query_result));
}
public IHttpActionResult GetSales()
{
return(Ok(CustomerSQLHandler.GetFlightSales()));
}
public IHttpActionResult PreCheckCustomer([FromUri] string user, [FromUri] string flight)
{
string query_result = CustomerSQLHandler.PreCheckCustomer(user, flight);
return(Ok(query_result));
}
public IHttpActionResult GetUniversities()
{
string result = CustomerSQLHandler.GetUniversities();
return(Ok(result));
}
public IHttpActionResult CustomerLogin([FromBody] string usr_credentials)
{
int query_result = CustomerSQLHandler.LoginCustomer(JsonConvert.DeserializeObject <Customer>(usr_credentials));
return(CheckQueryResult(query_result, JSONHandler.BuildMsgJSON(1, "Login successful")));
}
public IHttpActionResult GetUserFlights([FromUri] string user)
{
string result = CustomerSQLHandler.GetUserFlights(user);
return(Ok(result));
}
