/// <summary>
/// Ctor
/// </summary>
public FindRelationVM()
{
FindRelation = new Command(FindRelation_Command, CanFindRelation_Command);
Deep = 5;
using (var db = new ReferenceBookContext())
{
Original = db.Products.GroupBy(p => new { p.VendorCode, p.Brand })
.Select(g => new ProductNode()
{
VendorCode = g.Key.VendorCode,
Brand = g.Key.Brand
})
.OrderBy(p => p.Brand)
.ToList();
Desired = db.Products.GroupBy(p => new { p.AnalogueVendorCode, p.AnalogueBrand })
.Select(g => new ProductNode()
{
VendorCode = g.Key.AnalogueVendorCode,
Brand = g.Key.AnalogueBrand
})
.OrderBy(n => n.Brand)
.ToList();
}
}
public bool IsSearchConitue(ProductNode nodeA, ProductNode nodeB)
{
using (var db = new ReferenceBookContext())
{
var product = db.Products.ToList().FirstOrDefault(p =>
VendorCodeCompare(p.VendorCode, nodeA.VendorCode) &&
BrandCompare(p.Brand, nodeA.Brand) &&
VendorCodeCompare(p.AnalogueVendorCode, nodeB.VendorCode) &&
BrandCompare(p.AnalogueBrand, nodeB.Brand));
return(product?.Trust != 0 ? true : false);
}
}
/// <summary>
/// Ctor
/// </summary>
public MainWindowVM()
{
AddCommand = new Command(Add);
EditСommand = new Command(Edit, o => SelectedProduct != null);
RemoveCommand = new Command(Remove, o => SelectedProduct != null);
FindRelationCommand = new Command(FindRelation);
AcceptCommand = new Command(Accept);
db = new ReferenceBookContext();
db.Products.Load();
Products = db.Products.Local;
}
public IEnumerable <ProductNode> GetNodes(ProductNode node)
{
using (var db = new ReferenceBookContext())
{
return(db.Products
.Where(p => p.VendorCode == node.VendorCode && p.Brand == node.Brand)
.Select(p => new ProductNode()
{
VendorCode = p.AnalogueVendorCode,
Brand = p.AnalogueBrand
})
.ToList());
}
}
