public async Task Should_Save_AnEntity()
{
// arrange
string code = string.Empty;
RESERVAS1 res = new RESERVAS1();
using (var dbConnection = SqlExecutor.OpenNewDbConnection())
{
var reservas1 = await dbConnection.GetPagedAsync <RESERVAS1>(4, 4);
res = reservas1.FirstOrDefault();
}
Assert.NotNull(res.NUMERO_RES);
// act
var bookingCollection = await _loader.LoadValueAtMostAsync(10, 10);
var firstItem = bookingCollection.FirstOrDefault();
if (firstItem is BookingViewObject value)
{
value.NOTAS_RES1 = "Notes in a paged";
var bookingItem = value.Items.FirstOrDefault();
bookingItem.Concept = 2;
var myBoolean = await _saver.SaveAsync(firstItem);
Assert.IsTrue(myBoolean);
}
}
public async Task Should_Load_ABookingEntity()
{
// prepare
var entityCode = string.Empty;
var singleValue = new RESERVAS1();
var numberOfReservations = 0;
var simpleQuery = string.Empty;
IEnumerable <LIRESER> liresers = new List <LIRESER>();
using (var dbConnection = SqlExecutor.OpenNewDbConnection())
{
var reservas1 = await dbConnection.GetPagedAsync <RESERVAS1>(5, 20);
singleValue = reservas1.FirstOrDefault();
if (singleValue != null)
{
entityCode = singleValue.NUMERO_RES;
IQueryStore store = new QueryStore();
simpleQuery = store.GetCountItems("LIRESER", "NUMERO", singleValue.NUMERO_RES);
var intList = await dbConnection.QueryAsync <int>(simpleQuery);
numberOfReservations = intList.FirstOrDefault();
}
}
Assert.IsNotEmpty(entityCode);
Assert.IsNotEmpty(simpleQuery);
var singleDto = await _loader.LoadValueAsync(entityCode);
var itemReservation = singleDto.Items;
Assert.AreEqual(singleDto.APELLIDO1, singleDto.APELLIDO1);
Assert.AreEqual(itemReservation.Count(), numberOfReservations);
}
/// <summary>
/// Get a new data object
/// </summary>
/// <param name="code">Office code for the booking</param>
/// <returns>Returns if the data is fetched with success.</returns>
public IBookingData GetNewDo(string code)
{
var bookingValue = new RESERVAS1();
var officeCode = code.Substring(0, 2);
var bookingData = new Reservation()
{
Valid = true
};
using (var connection = SqlExecutor.OpenNewDbConnection())
{
if (connection == null)
{
return(bookingData);
}
var bookingNumber = connection.UniqueId <RESERVAS1>(bookingValue, null, null, officeCode);
var bookingDto = new BookingViewObject
{
FECHA_RES1 = DateTime.Now,
HORA_RES1 = DateTime.Now.TimeOfDay,
NUMERO_RES = bookingNumber,
SUBLICEN_RES1 = "00",
OFICINA_RES1 = officeCode,
IsNew = true
};
bookingData.Value = bookingDto;
}
return(bookingData);
}
/// <summary>
/// Generate a new identifier.
/// </summary>
/// <returns></returns>
public string NewId()
{
string uniqueId;
var reservas = new RESERVAS1();
using (var dbConnection = SqlExecutor.OpenNewDbConnection())
{
uniqueId = dbConnection.UniqueId <RESERVAS1>(reservas);
}
return(uniqueId);
}
private async Task <RESERVAS1> FetchValidBooking()
{
var item = new RESERVAS1();
using (var dbConnection = SqlExecutor.OpenNewDbConnection())
{
var connection = await dbConnection.GetPagedAsync <RESERVAS1>(9, 10).ConfigureAwait(false);
item = connection.FirstOrDefault <RESERVAS1>();
}
return(item);
}
/// <summary>
/// Get a new identifier for the reservas
/// </summary>
/// <returns>Returns an unique identifier for the booking. This is the booking number</returns>
public string GetNewId()
{
var bookingValue = new RESERVAS1();
var reservas = string.Empty;
using (var dbConnection = SqlExecutor.OpenNewDbConnection())
{
if (dbConnection != null)
{
reservas = dbConnection.UniqueId <RESERVAS1>(bookingValue);
}
}
return(reservas);
}
public string NewId()
{
string uniqueId = string.Empty;
using (var connection = SqlExecutor.OpenNewDbConnection())
{
if (connection != null)
{
var pet = new RESERVAS1();
uniqueId = connection.UniqueId(pet);
return(uniqueId);
}
}
return(uniqueId);
}
/// <summary>
/// Delete asynchronously the booking data
/// </summary>
/// <param name="data">Data transfer object to delete</param>
/// <returns>Data value</returns>
public async Task <bool> DeleteAsync(BookingViewObject data)
{
var book1 = new RESERVAS1()
{
NUMERO_RES = data.NUMERO_RES
};
var book2 = new RESERVAS2()
{
NUMERO_RES = data.NUMERO_RES
};
var bookItems = _mapper.Map <IEnumerable <BookingItemsViewObject>, IEnumerable <LIRESER> >(data.Items);
var resultValue = await DeleteHelper.DeleteAsync <RESERVAS1, RESERVAS2, LIRESER>(_executor, book1, book2);
return(resultValue);
}
/// <summary>
/// Get a new data object
/// </summary>
/// <param name="code">Code of the new object</param>
/// <returns>Returns if the data is fetched with success.</returns>
public IBookingData GetNewDo(string code)
{
var bookingValue = new RESERVAS1();
var bookingData = new Reservation()
{
Valid = true
};
using (var dbConnection = SqlExecutor.OpenNewDbConnection())
{
var reservations = string.Empty;
if (dbConnection != null)
{
reservations = dbConnection.UniqueId <RESERVAS1>(bookingValue);
}
var bookingDto = new BookingDto {
NUMERO_RES = reservations
};
bookingData.Value = bookingDto;
}
return(bookingData);
}
