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