public Ticket AddTicket(Ticket item ) { DAL dal = new DAL(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SaveTicket"; cmd.Parameters.AddWithValue("@mobile_number", item.mobileNumber); cmd.Parameters.AddWithValue("@schedule_id", item.schedule_id); int ticketsAdded = dal.ExecuteProcNonQuery(cmd); return item; }
public Passenger AddPassenger(Passenger item) { DAL dal = new DAL(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SavePassenger"; cmd.Parameters.AddWithValue("@mobile_number", item.mobile_number); cmd.Parameters.AddWithValue("@email_address", item.email_address); cmd.Parameters.AddWithValue("@passenger_name", item.passenger_name); int ticketsAdded = dal.ExecuteProcNonQuery(cmd); return item; }