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