public async Task MaxOnFilteredSet2() { var soh = new SalesOrderHeaders(); var result = await soh.MaxAsync("SalesOrderID", new { TerritoryID = 10 }); Assert.AreEqual(75117, result); }
public void All_NoParameters_Streaming() { var soh = new SalesOrderHeaders(); var allRows = soh.All(); var count = 0; int nonZeroSalesPersonID = 0; foreach (var r in allRows) { count++; Assert.Greater(r.SalesOrderID, 0); if (r.SalesPersonID > 0) { nonZeroSalesPersonID++; Assert.AreNotEqual("", r.PurchaseOrderNumber); } else { Assert.Null(r.PurchaseOrderNumber); } Assert.Greater(r.CustomerID, 0); Assert.Greater(r.Status, 0); } Assert.AreEqual(31465, count); Assert.AreEqual(3806, nonZeroSalesPersonID); }
public async Task <IActionResult> PutSalesOrderHeaders(int id, SalesOrderHeaders salesOrderHeaders) { if (id != salesOrderHeaders.ID) { return(BadRequest()); } _context.Entry(salesOrderHeaders).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!SalesOrderHeadersExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public void Count_TestWhereWrapping() { dynamic soh = new SalesOrderHeaders(); var total = soh.Count(where : "1=1 OR 0=0", CustomerID: 11212); Assert.AreEqual(17, total); }
public void DefaultValue() { var soh = new SalesOrderHeaders(false); var value = soh.GetColumnDefault("OrderDate"); Assert.AreEqual(typeof(DateTime), value.GetType()); }
public void Query_Filter() { var soh = new SalesOrderHeaders(); var filteredRows = soh.Query("SELECT * FROM Sales.SalesOrderHeader WHERE CustomerID=@0", 30052).ToList(); Assert.AreEqual(4, filteredRows.Count); }
public void Count_WhereSpecification_FromArgs() { var soh = new SalesOrderHeaders(); var total = soh.Count(where : "WHERE CustomerId=@0", args: 11212); Assert.AreEqual(17, total); }
public async Task All_NoParameters() { var soh = new SalesOrderHeaders(); var allRows = await(await soh.AllAsync()).ToListAsync(); Assert.AreEqual(31465, allRows.Count); }
public async Task All_NoParameters_Streaming() { var soh = new SalesOrderHeaders(); var allRows = await soh.AllAsync(); var count = 0; int nonZeroSalesPersonID = 0; await allRows.ForEachAsync(r => { count++; Assert.Greater(r.SalesOrderID, 0); if (r.SalesPersonID > 0) { nonZeroSalesPersonID++; Assert.AreNotEqual("", r.PurchaseOrderNumber); } else { Assert.Null(r.PurchaseOrderNumber); } Assert.Greater(r.CustomerID, 0); Assert.Greater(r.Status, 0); }); Assert.AreEqual(31465, count); Assert.AreEqual(3806, nonZeroSalesPersonID); }
public async Task Count_TestWhereWrapping() { dynamic soh = new SalesOrderHeaders(); var total = await soh.CountAsync(where : "1=1 OR 0=0", CustomerID : 11212); Assert.AreEqual(17, total); }
public async Task Count_WhereSpecification_FromNameValuePairs() { dynamic soh = new SalesOrderHeaders(); var total = await soh.CountAsync(new { CustomerID = 11212, ModifiedDate = new DateTime(2013, 10, 10) }); Assert.AreEqual(2, total); }
public async Task Count_NoSpecification() { var soh = new SalesOrderHeaders(); var total = await soh.CountAsync(); Assert.AreEqual(31465, total); }
public async Task Query_Filter() { var soh = new SalesOrderHeaders(); var filteredRows = await(await soh.QueryAsync("SELECT * FROM Sales.SalesOrderHeader WHERE CustomerID=@0", 30052)).ToListAsync(); Assert.AreEqual(4, filteredRows.Count); }
public async Task Query_AllRows() { var soh = new SalesOrderHeaders(); var allRows = await(await soh.QueryAsync("SELECT * FROM Sales.SalesOrderHeader")).ToListAsync(); Assert.AreEqual(31465, allRows.Count); }
public void EmptyElement_ProtoType() { var soh = new SalesOrderHeaders(); dynamic defaults = soh.New(); Assert.IsTrue(defaults.OrderDate > DateTime.MinValue); }
public async Task All_LimitSpecification() { var soh = new SalesOrderHeaders(); var allRows = await(await soh.AllAsync(limit: 10)).ToListAsync(); Assert.AreEqual(10, allRows.Count); }
public void Query_AllRows() { var soh = new SalesOrderHeaders(); var allRows = soh.Query("SELECT * FROM Sales.SalesOrderHeader").ToList(); Assert.AreEqual(31465, allRows.Count); }
public async Task Find_OneColumn() { dynamic soh = new SalesOrderHeaders(); SalesOrderHeader singleInstance = await soh.FindAsync(SalesOrderID: 43666, columns: "SalesOrderID"); Assert.AreEqual(43666, singleInstance.SalesOrderID); Assert.AreEqual(0, singleInstance.CustomerID); }
public void Count_NoSpecification() { var soh = new SalesOrderHeaders(); var total = soh.Count(); Assert.AreEqual(31465, total); }
public void All_WhereClause() { var soh = new SalesOrderHeaders(); var allRows = soh.All(where : "WHERE CustomerId=@0", args: 30052).ToList(); Assert.AreEqual(4, allRows.Count); }
public void Count_WhereSpecification_FromArgsPlusNameValue() { dynamic soh = new SalesOrderHeaders(); var total = soh.Count(where : "WHERE CustomerId=@0", args: 11212, ModifiedDate: new DateTime(2013, 10, 10)); Assert.AreEqual(2, total); }
public void MaxOnFilteredSet() { var soh = new SalesOrderHeaders(); var result = soh.Max(columns: "SalesOrderID", where : "SalesOrderID < @0", args: 100000); Assert.AreEqual(75123, result); }
public void Count_WhereSpecification_FromNameValuePairs() { var soh = new SalesOrderHeaders(); var total = soh.Count(new { CustomerID = 11212, ModifiedDate = new DateTime(2013, 10, 10) }); Assert.AreEqual(2, total); }
public void All_WhereParams() { var soh = new SalesOrderHeaders(); var allRows = soh.All(new { CustomerId = 30052 }).ToList(); Assert.AreEqual(4, allRows.Count); }
public void All_NoParameters() { var soh = new SalesOrderHeaders(); var allRows = soh.All().ToList(); Assert.AreEqual(31465, allRows.Count); }
public void MaxOnFilteredSet2() { var soh = new SalesOrderHeaders(); var result = soh.Max("SalesOrderID", new { TerritoryID = 10 }); Assert.AreEqual(75117, result); }
public void All_LimitSpecification() { var soh = new SalesOrderHeaders(); var allRows = soh.All(limit: 10).ToList(); Assert.AreEqual(10, allRows.Count); }
public void First_AllColumns() { dynamic soh = new SalesOrderHeaders(); var singleInstance = soh.First(SalesOrderID: 43666); Assert.AreEqual(43666, singleInstance.SalesOrderID); }
public async Task <ActionResult <SalesOrderHeaders> > PostSalesOrderHeaders(SalesOrderHeaders salesOrderHeaders) { _context.SalesOrder_Headers.Add(salesOrderHeaders); await _context.SaveChangesAsync(); return(CreatedAtAction("GetSalesOrderHeaders", new { id = salesOrderHeaders.ID }, salesOrderHeaders)); }
public async Task First_AllColumns() { dynamic soh = new SalesOrderHeaders(); var singleInstance = await soh.FirstAsync(SalesOrderID : 43666); Assert.AreEqual(43666, singleInstance.SalesOrderID); }