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