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