public void AddTicket(TicketDetail detail) { try { SqlCommand cmd = new SqlCommand("insert into TicketBooking values(@pi, @pn, @td, @dt, @tc)", SqlCon); cmd.Parameters.AddWithValue("@pi", detail.PassengerId); cmd.Parameters.AddWithValue("@pn", detail.PassengerName); cmd.Parameters.AddWithValue("@td", detail.TravelDate); cmd.Parameters.AddWithValue("@dt", detail.DistanceTravel); CalculateCost(detail); cmd.Parameters.AddWithValue("@tc", detail.TicketCost); cmd.ExecuteNonQuery(); } catch (SqlException e) { Console.WriteLine(e.Message); } }
public void CalculateCost(TicketDetail detail) { if (detail.DistanceTravel <= 100) { detail.TicketCost = detail.DistanceTravel * 1; } else if (detail.DistanceTravel > 100 && detail.DistanceTravel <= 300) { detail.TicketCost = detail.DistanceTravel * 1.5; } else if (detail.DistanceTravel > 300 && detail.DistanceTravel <= 500) { detail.TicketCost = detail.DistanceTravel * 2.5; } else { detail.TicketCost = detail.DistanceTravel - 500 * 4.5; } }