public async Task <Sale> InsertSaleAsync(Sale sale)
{
_Context.Add(sale);
try
{
await _Context.SaveChangesAsync();
}
catch (System.Exception exp)
{
_Logger.LogError($"Error in {nameof(InsertSaleAsync)}: " + exp.Message);
}
return(sale);
}
public async Task <bool> UpdateProductAsync(Product product)
{
//Will update all properties of the Customer
_Context.Products.Attach(product);
_Context.Entry(product).State = EntityState.Modified;
try
{
return(await _Context.SaveChangesAsync() > 0 ? true : false);
}
catch (Exception exp)
{
_Logger.LogError($"Error in {nameof(UpdateProductAsync)}: " + exp.Message);
}
return(false);
}
public async Task InsertCustomersSampleData(BikesDBContext db)
{
var customers = GetCustomers();
db.Customers.AddRange(customers);
try
{
int numAffected = await db.SaveChangesAsync();
_Logger.LogInformation($"Saved {numAffected} customers");
}
catch (Exception exp)
{
_Logger.LogError($"Error in {nameof(BikesDBSeeder)}: " + exp.Message);
throw;
}
var products = GetProducts();
db.Products.AddRange(products);
try
{
int numAffected = await db.SaveChangesAsync();
_Logger.LogInformation($"Saved {numAffected} products");
}
catch (Exception exp)
{
_Logger.LogError($"Error in {nameof(BikesDBSeeder)}: " + exp.Message);
throw;
}
var salePersons = GetSalePersons();
db.Salespersons.AddRange(salePersons);
try
{
int numAffected = await db.SaveChangesAsync();
_Logger.LogInformation($"Saved {numAffected} SalePersons");
}
catch (Exception exp)
{
_Logger.LogError($"Error in {nameof(BikesDBSeeder)}: " + exp.Message);
throw;
}
var discounts = GetDiscounts();
db.Discounts.AddRange(discounts);
try
{
int numAffected = await db.SaveChangesAsync();
_Logger.LogInformation($"Saved {numAffected} Discount");
}
catch (Exception exp)
{
_Logger.LogError($"Error in {nameof(BikesDBSeeder)}: " + exp.Message);
throw;
}
var sales = GetSales();
db.Sales.AddRange(sales);
try
{
int numAffected = await db.SaveChangesAsync();
_Logger.LogInformation($"Saved {numAffected} Sale");
}
catch (Exception exp)
{
_Logger.LogError($"Error in {nameof(BikesDBSeeder)}: " + exp.Message);
throw;
}
}
