public void TestClaimItems()
{
using (var ctx = new BadgerData.DataAccess.BadgerDataContext())
{
BadgerData.Models.Claim x = new BadgerData.Models.Claim();
x.ClaimDate = DateTime.Today;
x.EmployeeID = 8;
x.PurchaseOrderID = 5001;
x.SupplierOrder = "12234R3";
ctx.Add(x);
ctx.SaveChanges();
for (int i = 0; i < 3; i++)
{
var item = new BadgerData.Models.ClaimItem();
item.ClaimID = x.ClaimID;
item.Bcode = "1-34-12-111" + i.ToString();
item.LineID = 1234 + i;
item.Description = "Description" + i.ToString();
item.DefectDescription = "Brocken";
item.PartID = 1234;
ctx.Add(item);
ctx.SaveChanges();
}
ctx.SaveChanges();
var testItems = ctx.ClaimItem.ToList();
Assert.IsTrue(testItems.Count > 0);
var rm = ctx.ClaimItem.ToList();
ctx.RemoveRange(rm);
ctx.SaveChanges();
var tm = ctx.Claim.ToList();
ctx.RemoveRange(tm);
ctx.SaveChanges();
}
}
public void TestClaim()
{
using (var ctx = new BadgerData.DataAccess.BadgerDataContext())
{
BadgerData.Models.Claim x = new BadgerData.Models.Claim();
x.ClaimDate = DateTime.Today;
x.EmployeeID = 8;
x.PurchaseOrderID = 5001;
x.SupplierOrder = "12234R3";
ctx.Add(x);
ctx.SaveChanges();
var t = ctx.Claim.Where(c => c.PurchaseOrderID == 5001).First();
var parts = ctx.Claim.ToList();
Assert.IsTrue(parts.Count > 0);
Assert.AreEqual(t.EmployeeID, 8);
Assert.AreEqual(t.SupplierOrder, "12234R3");
Assert.IsTrue(t.ClaimID > 0);
ctx.Remove(t);
ctx.SaveChanges();
parts = ctx.Claim.ToList();
Assert.IsTrue(parts.Count == 0);
}
}
