public void PFCToolbox_ConnectToContext() { using (var context = new PFCToolboxContext()) { var result = context.Database; Assert.IsNotNull(result); } }
public void PFCToolbox_GetAllSubdepartments() { using (var context = new PFCToolboxContext()) { var results = context.Subdepartments; Assert.IsNotNull(results); Assert.AreNotEqual(0, results.Count()); } }
public void PFCToolbox_GetAllProductUpdateStatuses() { using (var context = new PFCToolboxContext()) { var results = context.ProductUpdateStatuses; Assert.IsNotNull(results); Assert.AreNotEqual(0, results.Count()); } }
public void PFCToolbox_GetAllExpirations() { using (var context = new PFCToolboxContext()) { var results = context.Expirations; Assert.IsNotNull(results); Assert.AreNotEqual(0, results.Count()); } }
public void PFCToolbox_GetAllRequestTypes() { using (var context = new PFCToolboxContext()) { var results = context.RequestTypes; Assert.IsNotNull(results); Assert.AreNotEqual(0, results.Count()); } }
public void Test_InsertUpdateDelete_Methods() { using (var context = new PFCToolboxContext()) { _vendorRepo = new Repo <Vendor>(context); var id = TestInsert(); TestUpdate(id); TestDelete(id); } }
public void Test_GetAll_Method() { using (var context = new PFCToolboxContext()) { var repo = new Repo <Vendor>(context); var results = repo.GetAll(); Assert.IsNotNull(results); Assert.IsTrue(results.Count() > 0); } }
public void Test_Get_Method() { using (var context = new PFCToolboxContext()) { var repo = new Repo <Vendor>(context); var result = repo.Get(1); Assert.IsNotNull(result); Assert.AreEqual("Unfi (TC)", result.VendorName); } }
public void PFCToolbox_GetSpecificProductUpdateStatus() { using (var context = new PFCToolboxContext()) { var result = context.ProductUpdateStatuses .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("1 - Waiting for Manager Review", result.ProductUpdateStatusDescription); } }
public void PFCToolbox_GetSpecificLocation() { using (var context = new PFCToolboxContext()) { var result = context.Locations .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("La Crosse", result.LocationName); } }
public void PFCToolbox_GetSpecificSMSCategory() { using (var context = new PFCToolboxContext()) { var result = context.SMSCategories .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("TEST SUBDEPT (no dept)", result.F1022); } }
public void PFCToolbox_GetSpecificLabelSize() { using (var context = new PFCToolboxContext()) { var result = context.LabelSizes .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("1 - Full Regular Price.lbz", result.LabelSizes); } }
public void PFCToolbox_GetSpecificSubdepartment() { using (var context = new PFCToolboxContext()) { var result = context.Subdepartments .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("01-01 Books & Cards", result.SubdepartmentName); } }
public void Test_Where_Method() { using (var context = new PFCToolboxContext()) { var repo = new Repo <Vendor>(context); var result = repo.Where(x => x.VendorName.Equals("Unfi (TC)")) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual(1, result.ID); } }
public void PFCToolbox_GetSpecificVendor() { using (var context = new PFCToolboxContext()) { var result = context.Vendors .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("Unfi (TC)", result.VendorName); } }
public void PFCToolbox_GetSpecificSMSSubdepartment() { using (var context = new PFCToolboxContext()) { var result = context.SMSSubdepartments .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("TAX PREPARED FOODS", result.F1022); } }
public void PFCToolbox_GetSpecificSMSVendor() { using (var context = new PFCToolboxContext()) { var result = context.SMSVendors .Where(v => v.ID.Equals("1316")) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("UNFI TC", result.F334); } }
public void PFCToolbox_GetSpecificSMSReport() { using (var context = new PFCToolboxContext()) { var result = context.SMSReports .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("Conventional", result.F1024); } }
public void PFCToolbox_GetSpecificSignSize() { using (var context = new PFCToolboxContext()) { var result = context.SignSizes .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("On Sale 2UP", result.SignSizes); } }
public void PFCToolbox_GetSpecificRequestType() { using (var context = new PFCToolboxContext()) { var result = context.RequestTypes .Where(v => v.ID.Equals(1)) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("Product Info Update", result.RequestName); } }
public void PFCToolbox_GetSpecificExpiration() { using (var context = new PFCToolboxContext()) { var result = context.Expirations .Where(v => v.ID.Equals(1)) .Include(v => v.Location) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("test item", result.ExpirationDescription); Assert.AreEqual("La Crosse", result.Location.LocationName); } }
public void PFCToolbox_GetSpecificWriteoff() { using (var context = new PFCToolboxContext()) { var result = context.Writeoffs .Where(v => v.ID.Equals(1)) .Include(x => x.Location) .Include(x => x.Subdepartment) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("blank item", result.WriteoffItemName); Assert.AreEqual("La Crosse", result.Location.LocationName); Assert.AreEqual("01-01 Books & Cards", result.Subdepartment.SubdepartmentName); } }
public void PFCToolbox_GetSpecificPurchase() { using (var context = new PFCToolboxContext()) { var result = context.Purchases .Where(v => v.ID.Equals(221582)) .Include(x => x.Location) .Include(x => x.Subdepartment) .Include(x => x.Vendor) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("19010105", result.InvoiceNumber); Assert.AreEqual("La Crosse", result.Location.LocationName); Assert.AreEqual("03-03 Produce Conv.", result.Subdepartment.SubdepartmentName); Assert.AreEqual("Floating Gardens", result.Vendor.VendorName); } }
public void PFCToolbox_GetSpecificProductUpdate() { using (var context = new PFCToolboxContext()) { var result = context.ProductUpdates .Where(v => v.ID.Equals(29111)) .Include(x => x.Location) .Include(x => x.ProductUpdateStatus) .Include(x => x.RequestType) .FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual("73373907570", result.F01); Assert.AreEqual("Rochester", result.Location.LocationName); Assert.AreEqual("4 - Completed", result.ProductUpdateStatus.ProductUpdateStatusDescription); Assert.AreEqual("Retail pricing, descriptions, etc..", result.RequestType.RequestDescription); } }