private void HandlePropertyChanged(object sender, PropertyChangedEventArgs e)
{
switch (e.PropertyName)
{
case nameof(SelectedSupplier):
{
var suppliersId = _selectedSupplier?.TheEntity.SupplierID ?? -1;
using (var db = new RetailDbContext())
{
_selectableProducts = db
.Products
.Where(product => product.SupplierID == suppliersId)
.OrderBy(n => n.Description)
.Select(n => new ProductVM {
IsNew = false, TheEntity = n
})
.ToList();
}
RaisePropertyChanged(nameof(SelectableProducts));
PO.SetSupplier(SelectedSupplier);
RaisePropertyChanged(nameof(PO));
break;
}
case nameof(SelectedStore):
{
PO.SetStore(SelectedStore);
RaisePropertyChanged(nameof(PO));
break;
}
}
}
private void Approve_Click(object sender, RoutedEventArgs e)
{
using (var db = new RetailDbContext())
{
db.Pos.Add(ViewModel.PO.TheEntity);
db.SaveChanges();
}
DataContext = new POEntryViewModel();
}
public static void SeedHostDb(RetailDbContext context)
{
context.SuppressAutoSetTenantId = true;
//Host seed
new InitialHostDbBuilder(context).Create();
//Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
public static async Task SeedAsync(RetailDbContext dbContext)
{
dbContext.Database.EnsureCreated();
if (!dbContext.Currencies.Any())
{
dbContext.Currencies.AddRange(GerPreconfiguredCurrency());
await dbContext.SaveChangesAsync();
}
}
public static Product CreateProduct(this RetailDbContext db)
{
var id = IdFactory.Next();
var product = new Product
{
ProductName = $"Product {id}",
Active = true,
Price = id * 2 + 0.99m,
SalesPrice = id + 0.99m,
};
db.Add(product);
return(product);
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
using (var context = new RetailDbContext()) {
var productsSelectListItems = new List <SelectListItem>();
var products = context.Products.AsEnumerable();
foreach (Product product in products)
{
productsSelectListItems.Add(new SelectListItem()
{
Text = product.Name,
Value = product.Id.ToString()
});
}
filterContext.Controller.ViewBag.ProductsSelectListItems = productsSelectListItems;
}
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
using (var context = new RetailDbContext()) {
var categorySelectListItems = new List <SelectListItem>();
var categories = context.Categories.AsEnumerable();
foreach (Category category in categories)
{
categorySelectListItems.Add(new SelectListItem()
{
Text = category.Name,
Value = category.Id.ToString()
});
}
filterContext.Controller.ViewBag.CategoriesSelectListItems = categorySelectListItems;
}
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
using (var context = new RetailDbContext()) {
var employeesSelectListItems = new List <SelectListItem>();
var employees = context.Employees.AsEnumerable();
foreach (Employee employee in employees)
{
employeesSelectListItems.Add(new SelectListItem()
{
Text = employee.LastName + ", " + employee.FirstName,
Value = employee.Id.ToString()
});
}
filterContext.Controller.ViewBag.EmployeesSelectListItems = employeesSelectListItems;
}
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
using (var context = new RetailDbContext()) {
var vendorsSelectListItems = new List <SelectListItem>();
var vendors = context.Vendors.AsEnumerable();
foreach (Vendor vendor in vendors)
{
vendorsSelectListItems.Add(new SelectListItem()
{
Text = vendor.Name,
Value = vendor.Id.ToString()
});
}
filterContext.Controller.ViewBag.VendorsSelectListItems = vendorsSelectListItems;
}
}
public void OnActionExecuted(ActionExecutedContext filterContext)
{
using (var context = new RetailDbContext()) {
var customersSelectListItems = new List <SelectListItem>();
var customers = context.Customers.AsEnumerable();
foreach (Customer customer in customers)
{
customersSelectListItems.Add(new SelectListItem()
{
Text = customer.LastName + ", " + customer.FirstName,
Value = customer.Id.ToString()
});
}
filterContext.Controller.ViewBag.CustomersSelectListItems = customersSelectListItems;
}
}
public static Store CreateStore(this RetailDbContext db)
{
var id = IdFactory.Next();
var store = new Store
{
Address = $"{id} Main Street",
City = $"{id}ville",
Province = $"{id} District",
Country = $"{id}land",
PostalCode = $"{id}",
PhoneNumber = $"({id}) {id}-{id}",
StoreName = $"Store {id}",
Active = true,
};
db.Add(store);
return(store);
}
public static Customer CreateCustomer(this RetailDbContext db)
{
var id = IdFactory.Next();
var customer = new Customer
{
FirstName = $"Bob{id}",
LastName = $"Robertson{id}",
Address = $"{id} Main Street",
City = $"{id}ville",
Province = $"{id} District",
Country = $"{id}land",
PostalCode = $"{id}",
PhoneNumber = $"({id}) {id}-{id}",
Active = true,
Discount = 0.0
};
db.Add(customer);
return(customer);
}
public InitialHostDbBuilder(RetailDbContext context)
{
_context = context;
}
public ItemService(RetailDbContext dbContext)
{
_dbContext = dbContext;
}
public LocationService(RetailDbContext dbContext)
{
_dbContext = dbContext;
}
public TestSubscriptionPaymentBuilder(RetailDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public TestDataBuilder(RetailDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public DefaultLanguagesCreator(RetailDbContext context)
{
_context = context;
}
public CurrencyRepository(RetailDbContext dbContext) : base(dbContext)
{
}
public TenantRoleAndUserBuilder(RetailDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public EfRepositoryBase(RetailDbContext dbContext)
{
_dbContext = dbContext ?? throw new ArgumentNullException(nameof(RetailDbContext));
}
public RetailRepository(RetailDbContext dbContext)
{
_dbContext = dbContext;
}
public DefaultSettingsCreator(RetailDbContext context)
{
_context = context;
}
public DefaultEditionCreator(RetailDbContext context)
{
_context = context;
}
public DefaultTenantBuilder(RetailDbContext context)
{
_context = context;
}
public TestOrganizationUnitsBuilder(RetailDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public HostRoleAndUserCreator(RetailDbContext context)
{
_context = context;
}
