public static string PrepareSearchResponse(string searchRequest)
{
string[] searchParams = searchRequest.Split('?');
string departureDate = searchParams[(int)SearchParam.DepartureDate];
string fromStation = searchParams[(int)SearchParam.FromStation];
string toStation = searchParams[(int)SearchParam.ToStation];
Console.WriteLine($" Search input: \n" +
$"departureDate: {departureDate}\n" +
$"fromStation: {fromStation}\n" +
$"toStation: {toStation}\n");
RouteRepository routeRepository = new RouteRepository();
List <TrainConnection> result = routeRepository.SearchForTrainConnection(Convert.ToDateTime(departureDate), fromStation, toStation);
result.Sort(new TrainConnectionComparator());
string resultString = "";
foreach (TrainConnection r in result)
{
SearchResponse searchResponse
= new SearchResponse(
r.travel_id,
r.train_name,
r.departure_date.ToString(),
r.departure_hour.ToString(),
r.total_price.ToString(),
r.total_duration.ToString());
resultString += searchResponse.ToString() + ';';
}
resultString = resultString.Remove(resultString.Length - 1, 1);
return(resultString);
}
public static string PrepareTicketResponse(string ticketRequest)
{
string userId = ticketRequest;
Console.WriteLine($" Ticket input: \n" +
$"userId: {userId}\n");
SaleRepository saleRepository = new SaleRepository();
List <Sale> saleResults = saleRepository.GetUserSales(Convert.ToInt32(userId));
RouteRepository routeRepository = new RouteRepository();
string resultString = "";
foreach (Sale sale in saleResults)
{
Route route = routeRepository.Get(sale.route_id);
List <TrainConnection> result = routeRepository.SearchForTrainConnection(route.departure_date, sale.from_station, sale.to_station);
decimal price = 0;
TimeSpan time = new TimeSpan();
TimeSpan hour = new TimeSpan();
foreach (TrainConnection r in result)
{
if (r.travel_id == route.id)
{
price = r.total_price;
time = r.total_duration;
hour = r.departure_hour;
}
}
string saleTicketNameAmountPercentage = saleRepository.GetSaleTicketNameAmountPercentage(sale.id);
string[] saleTicketNameAmountPercentagArray = saleTicketNameAmountPercentage.Split(',');
var ticketName = saleTicketNameAmountPercentagArray[0];
var ticketsAmount = saleTicketNameAmountPercentagArray[1];
var ticketPercentage = saleTicketNameAmountPercentagArray[2];
var totalPrice = price * (Convert.ToInt32(ticketsAmount)) * (Convert.ToDecimal(ticketPercentage) / 100);
//(Convert.ToInt32(ticketPercentage) / 100.0) *
TicketResponse ticketResponse
= new TicketResponse(
route.train_name.ToString(),
sale.from_station,
sale.to_station,
sale.sale_date.ToString(),
route.departure_date.ToString(),
hour.ToString(),
totalPrice.ToString(),
time.ToString(),
sale.payment_status.ToString(),
ticketName,
ticketsAmount);
resultString += ticketResponse.ToString() + ';';
}
resultString = resultString.Remove(resultString.Length - 1, 1);
return(resultString);
}