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);
}
