public List <ClientPremium> GetAllClients() { TALPremiumInsuranceDbContext db = new TALPremiumInsuranceDbContext(); var clients = db.ClientPremiums.Where(c => c.IsActive == true).ToList(); return(clients); }
public void CreateClientPremium(ClientPremium clientPremium) { TALPremiumInsuranceDbContext db = new TALPremiumInsuranceDbContext(); db.ClientPremiums.Add(clientPremium); db.SaveChanges(); }
public decimal CalculateClientMonthlyPremium(decimal deathSumInsured, int age, int occupationId) { TALPremiumInsuranceDbContext db = new TALPremiumInsuranceDbContext(); int occupationRatingId = db.Occupations.Find(occupationId).OccupationRatingId; var factor = db.OccupationRatings.Find(occupationRatingId).Factor; var monthlyPremiumAmount = Math.Round(((deathSumInsured * factor * age) / 1000) * 12, 2); return(monthlyPremiumAmount); }