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