public IFreeList GetTrainFromBD(IBookingValue bookingValue) { freeTrainCar = Base.GetTrain(bookingValue, freeTrainCar); allFreeTrainInfo = repository.InsertInAllFreeTrainInfo(freeTrainCar, bookingValue); return(allFreeTrainInfo); }
public FreeTrainCar GetTrain(IBookingValue bookingValue, FreeTrainCar freeTrainCar) { using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["RW"].ConnectionString)) { var sql = "exec [FindPlaceProc] @StationFrom, @StationTo, @Date,@Time"; var values = new { bookingValue.StationFrom, bookingValue.StationTo, bookingValue.Date, bookingValue.Time }; using (var multi = connection.QueryMultiple(sql, values)) { freeTrainCar.freeTrain = multi.Read <FreeTrainInfo>().ToList(); freeTrainCar.freeCar = multi.Read <FreeCarInfo>().ToList(); } } return(freeTrainCar); }