public async Task FetchSingleByIDAsync() { int id = 1; var order = await ConnectorOrders.FetchSingleAsync(id); Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); Assert.IsTrue(order?.ID == id); }
public async Task FetchAllAsync() { var orders = await ConnectorOrders.FetchAllAsync(); foreach (var order in orders) { Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); } Assert.IsTrue(orders.Count > 0); }
public async Task FetchSingleBySqlAsync() { int id = 3; string sql = $"SELECT * FROM cat_Orders WHERE Order_Key = {id}"; //this is BAD PRACTICE! always use parameters var order = await ConnectorOrders.FetchSingleAsync(sql); Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); Assert.IsTrue(order?.ID == id); }
public async Task FetchAllBySqlAsync() { string sql = "SELECT TOP(3) * FROM cat_Orders"; var orders = await ConnectorOrders.FetchAllAsync(sql); foreach (var order in orders) { Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); } Assert.IsTrue(orders.Count > 0); }
public async Task SaveNewAsync() { var order = new Order() { CustomerID = 1, Created = DateTime.UtcNow, DeliveryTime = new TimeSpan(3, 20, 35), DeliveryTime2 = DateTime.UtcNow.TimeOfDay }; await ConnectorOrders.SaveAsync(order); Assert.IsTrue(order.ID > 0); }
public async Task FetchSingleByFilterAsync() { int id = 2; var filter = ConnectorOrders.CreateQuery(); filter.Add(x => x.ID, id); var order = await ConnectorOrders.FetchSingleAsync(filter); Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); Assert.AreEqual(id, order?.ID); }
public async Task FetchWhereInEmptyEnumerableAsync() { var request = new DataQuery <Order>(); request.Add(x => x.ID, new int[] { }, ComparisonOperator.In); var orders = await ConnectorOrders.FetchAllAsync(request); foreach (var order in orders) { Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); } Assert.AreEqual(0, orders.Count); }
public async Task FetchWhereInIntAsync() { var request = new DataQuery <Order>(); //request.WhereClause.Add(new DatabaseDataValueColumn("Order_Key", System.Data.SqlDbType.Int, new int[] { 1, 2,3 }, ComparisonOperator.In)); request.Add(x => x.ID, new int[] { 1, 2, 3 }, ComparisonOperator.In); var orders = await ConnectorOrders.FetchAllAsync(request); foreach (var order in orders) { Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); } Assert.IsTrue(orders.Count == 3); }
public async Task FetchSingleBySqlAndFilterAsync() { int id = 3; string sql = $"SELECT * FROM cat_Orders WHERE Order_Key = @orderID"; //this is BAD PRACTICE! always use parameters var filter = ConnectorOrders.CreateQuery(); filter.AddParameter("@orderID", id); var order = await ConnectorOrders.FetchSingleAsync(sql, filter); Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); Assert.IsTrue(order?.ID == id); }
public async Task TestCancellation() { var cts = new CancellationTokenSource(); var filter = new DataQuery <Order>(); cts.Cancel(); try { var orders = await ConnectorOrders.FetchAllAsync(filter, cts.Token); Assert.Fail(); } catch (TaskCanceledException) { } }
public async Task SaveExistingAsync() { //save the order var order = ConnectorOrders.FetchSingle(20); string newComments = DateTime.UtcNow.ToString(); order.Comments = newComments; order.DeliveryTime = null; order.DeliveryTime2 = DateTime.UtcNow.TimeOfDay; ConnectorOrders.Save(order); //retrieve order again from database order = await ConnectorOrders.FetchSingleAsync(20); Assert.AreEqual(newComments, order.Comments); }
public async Task FetchPagingAsync() { var request = new DataQuery <Order>(); request.AddPaging(5, 2); var orders = await ConnectorOrders.FetchAllAsync(request); foreach (var order in orders) { Console.WriteLine($"{order.ID} - {order.Created} - {order.CustomerID}"); } Console.WriteLine("Total number of rows: " + orders.TotalNumberOfRows); Console.WriteLine("Total number of pages: " + orders.TotalNumberOfPages); Assert.IsTrue(orders.Count == request.Paging.NumberOfRows); Assert.IsTrue(request.Paging.TotalNumberOfRows.HasValue); Assert.IsTrue(orders.TotalNumberOfPages.HasValue); Assert.IsTrue(orders.TotalNumberOfRows.HasValue); }
public async Task FetchNotExistingAsync() { var order = await ConnectorOrders.FetchSingleAsync(-1); Assert.IsTrue(order == null); }