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