public void SelectedCustomerChanged()
{
using var db = new SmartshopDbContext();
Customer = db.Customers.Where(c => c.CompanyName == SelectedCustomer.CompanyName)
.Include(i => i.Invoices)
.FirstOrDefault();
}
public void SelectedInvoiceChanged()
{
if (SelectedInvoice == null)
{
Items = null;
return;
}
else
{
using var db = new SmartshopDbContext();
Items = db.Items.Where(i => i.InvoiceNumber == SelectedInvoice.InvoiceNumber).ToList();
}
}
public async void SaveCustomer()
{
Cust = new Customer()
{
CustomerNumber = ulong.Parse(Utils.GenerateId(IdType.CUSTOMER)),
CompanyName = companyName,
ContactName = contactName,
Email = email,
Phone = phone,
Address = address
};
if (CompanyName != null && ContactName != null && Email != null && Phone != null && Address != null)
{
using var db = new SmartshopDbContext();
await db.AddAsync(Cust);
await db.SaveChangesAsync();
DeleteInputs();
}
}
private List <Customer> LoadCustomers()
{
using var db = new SmartshopDbContext();
return(db.Customers.ToList());
}
private void LoadItems()
{
using var db = new SmartshopDbContext();
Items = db.Items.OrderBy(x => x.Name).Distinct().ToList();
}
private void GetCustomersByName()
{
using var db = new SmartshopDbContext();
Customers = db.Customers.ToList();
}
public void LoginUser()
{
//Dependency Injection Here
using var _db = new SmartshopDbContext();
User = _db.AppUsers.Where(u => u.Id == 1).FirstOrDefault();
}
