public void TestGetPurchaseOrders() { using (var ctx = new BadgerData.DataAccess.BadgerDataContext()) { var x = new BadgerData.Models.PurchaseOrder(); x.EmployeeID = 8; x.Expected_Date = DateTime.Today.AddDays(3); x.ShipID = 1; x.Received = false; x.OrderTotal = 1.0m; x.OrderFormat = "Simple"; x.SalesRep = "Little Dicky"; x.SupplierID = 77; x.Taxable = true; x.Tax = 2.0m; x.Job_id = 4; x.Memo = "Long winded talk talk talk --"; x.Shipping = 1.0m; x.OrderDate = DateTime.Today; ctx.Add(x); ctx.SaveChanges(); var parts = ctx.PurchaseOrder.ToList(); Assert.IsTrue(parts.Count > 0); } }
public void TestPurchaseOrder() { using (var ctx = new BadgerData.DataAccess.BadgerDataContext()) { ctx.Database.EnsureCreated(); BadgerData.Models.PurchaseOrder x = new BadgerData.Models.PurchaseOrder(); x.OrderDate = DateTime.Today; x.EmployeeID = 8; x.Expected_Date = DateTime.Today.AddDays(2); x.Job_id = 1023; x.Memo = "Testing 1,2,3"; x.Received = false; x.SupplierID = 1437; x.SubTotal = 0.0m; x.OrderTotal = 0.0m; x.Shipping = 1.0m; x.Tax = 0.0m; x.SalesRep = "Dick"; x.ShipID = 1; x.Shipping = 0.0m; x.Taxable = false; ctx.Add(x); ctx.SaveChanges(); int ordernum = x.PurchaseOrderID; var t = ctx.PurchaseOrder.Where(c => c.PurchaseOrderID == ordernum).First(); var o = ctx.PurchaseOrder.Where(r => r.PurchaseOrderID == t.PurchaseOrderID).First(); Assert.IsTrue(t.PurchaseOrderID > 0); } }