public DbContextOptions <DiscountContext> SetupWithDiscountCriteria()
{
var options = new DbContextOptionsBuilder <DiscountContext>()
.UseInMemoryDatabase(databaseName: "PaylocityDiscountDb")
.Options;
using (var context = new DiscountContext(options))
{
var newDiscountCriteria = new DiscountCriteria
{
BaseDependentBenefitCost = 500.00m,
BaseEmployeeBenefitCost = 1000.00m,
DiscountPerctentageRate = .1m,
DiscountQualifier = 'A',
EmployeeBiWeeklyBasePay = 2000.00m,
TotalYearlyCheckDisbursment = 26,
CreatedOn = DateTime.UtcNow,
UpdatedOn = DateTime.UtcNow
};
context.Add(newDiscountCriteria);
context.SaveChanges();
}
return(options);
}
public void ApplyDiscount(int orderId)
{
var order = _db.Orders.Single(c => c.Id == orderId);
foreach (var orderItem in order.Items)
{
var discount = _db.Discounts.Where(d => d.Product.Id == orderItem.Product.Id).ToList();
foreach (var discount in discounts)
{
orderItem.Total = orderItem.Qty * orderItem.Product.Price * (1 - discount.Value / 100);
}
}
_db.SaveChanges();
}
//Save changes in database method
public void Save()
{
db.SaveChanges();
}
//New discount code creating
public void Create(DiscountCode context)
{
db.DiscountCodes.Add(context);
db.SaveChanges();
}
