internal static void DeleteVendor(VendorViewModel vendor)
{
WarehouseEntities entity = new WarehouseEntities();
var vendorToDelete =
(from vtd in entity.Vendors
where vtd.Name == vendor.Name
select vtd).First();
if (vendorToDelete!=null)
{
var del = vendorToDelete.Products;
foreach (var item in del.ToList())
{
entity.Products.Remove(item);
}
entity.Vendors.Remove(vendorToDelete);
MessageBox.Show("Vendor " + vendor.Name + " deleted", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
else
{
MessageBox.Show("Vendor " + vendor.Name + " doesn't exist", "Confirmation", MessageBoxButton.OK);
}
}
internal static void AddVendor(VendorViewModel vendor)
{
WarehouseEntities entity = new WarehouseEntities();
var vendorToAdd =
from vta in entity.Vendors
where vta.Name.Contains(vendor.Name)
select vta;
if (vendorToAdd.Count()!=0)
{
MessageBox.Show("Vendor " + vendor.Name + " exists", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
else
{
entity.Vendors.Add(new Vendor()
{
Name = vendor.Name
});
MessageBox.Show("Vendor " + vendor.Name + " added", "Confirmation", MessageBoxButton.OK);
entity.SaveChanges();
}
}
public WarehouseViewModel()
{
this.newProductViewModel = new ProductViewModel();
this.newVendorViewModel = new VendorViewModel();
this.newUserViewModel = new UserViewModel();
}
