public async Task IsValid_SalesPersonIDCheck() { var soh = new SalesOrderHeaders(); var toValidate = await soh.SingleAsync(new { SalesOrderID = 45816 }); // is invalid Assert.AreEqual(1, soh.IsValid(toValidate).Count); toValidate = await soh.SingleAsync(new { SalesOrderID = 45069 }); // is valid Assert.AreEqual(0, soh.IsValid(toValidate).Count); }
public async Task PrimaryKey_Read_Check() { var soh = new SalesOrderHeaders(); var toValidate = await soh.SingleAsync(new { SalesOrderID = 45816 }); Assert.IsTrue(soh.HasPrimaryKey(toValidate)); var pkValue = soh.GetPrimaryKey(toValidate); Assert.AreEqual(45816, pkValue); }
public async Task Single_Key_ThreeColumns() { var soh = new SalesOrderHeaders(); SalesOrderHeader singleInstance = await soh.SingleAsync(43666, columns: "SalesOrderID, SalesOrderNumber, OrderDate"); Assert.AreEqual(43666, singleInstance.SalesOrderID); Assert.AreEqual("SO43666", singleInstance.SalesOrderNumber); Assert.AreEqual(new DateTime(2011, 5, 31), singleInstance.OrderDate); Assert.Null(singleInstance.PurchaseOrderNumber, ""); Assert.AreEqual(singleInstance.CustomerID, 0); }
public async Task Single_Key_AllColumns() { var soh = new SalesOrderHeaders(); SalesOrderHeader singleInstance = await soh.SingleAsync(43666); Assert.AreEqual(43666, singleInstance.SalesOrderID); Assert.Greater(singleInstance.CustomerID, 0); Assert.Greater(singleInstance.SalesPersonID, 0); Assert.Greater(singleInstance.Status, 0); Assert.AreNotEqual(singleInstance.PurchaseOrderNumber, ""); Assert.Greater(singleInstance.OrderDate, DateTime.MinValue); }