public IActionResult Edit(Car carModel) { if (ModelState.IsValid) { var brandModelMatching = new CarModelValidation(); if (brandModelMatching.AllowedModelsOnBrand[carModel.Brand.ToLower()].Contains(carModel.Model.ToLower())) { var carFromDb = _dbContext.Car.Find(carModel.CarId); carFromDb.Brand = carModel.Brand; carFromDb.EuroStandard = carModel.EuroStandard; carFromDb.Model = carModel.Model; carFromDb.EngineCC = carModel.EngineCC; carFromDb.Year = carModel.Year; _dbContext.SaveChanges(); return(RedirectToAction("list", "car", new { area = "broker" })); } else { ViewBag.BrandModelMatchingError = $"There is no match between {carModel.Brand} and {carModel.Model} !!!"; return(View(carModel)); // the brand/model combination does not exist } } else { return(View(carModel)); // some validation error occured, return model to the view to render the errors } }
public void UpdateLimitOnAccidentsCover() { using (var _dbContext = new CarInsuranceContextV3()) { var limitRetrieved = _dbContext.Limit.Where(pk => pk.LimitCoverId.Equals(_testedBrokerGuid)).FirstOrDefault(); var listOfLimitValues = new List <int>(); foreach (var limit in limitRetrieved.LimitValues.Split(',', StringSplitOptions.RemoveEmptyEntries)) { listOfLimitValues.Add(int.Parse(limit)); } listOfLimitValues.Add(2000); var newLimitValues = string.Empty; foreach (var limit in listOfLimitValues) { newLimitValues += limit.ToString() + ","; } limitRetrieved.LimitValues = newLimitValues; _dbContext.SaveChanges(); var limitRetrieved2 = _dbContext.Limit.Where(pk => pk.LimitCoverId.Equals(_testedBrokerGuid)).FirstOrDefault(); Assert.AreEqual(limitRetrieved2.LimitValues.Split(',', StringSplitOptions.RemoveEmptyEntries).ToList().Last(), "2000"); } }
public void AddLimitRuleForLimit() { using (var _dbContext = new CarInsuranceContextV3()) { var coverRetrieved = _dbContext.Cover.Where(c => c.CoverBrokerRefId.Equals(_testedBrokerGuid) && c.Type.Equals("theft")) .Include(l => l.Limit) .FirstOrDefault(); var newLimitRule1 = new LimitRule() { LimitRuleCoverId = coverRetrieved.Limit.FirstOrDefault().LimitRuleCoverId, Name = "Equal500", RuleText = "EqualTo500", Multiplier = 0.6f, }; var newLimitRule2 = new LimitRule() { LimitRuleCoverId = coverRetrieved.Limit.FirstOrDefault().LimitRuleCoverId, Name = "Equal1000", RuleText = "EqualTo1000", Multiplier = 0.8f, }; _dbContext.LimitRule.AddRange(newLimitRule1, newLimitRule2); _dbContext.SaveChanges(); } }
//[Ignore("Outdated")] public void AddingLimitAndCheckingItBack() { using (var _dbContext = new CarInsuranceContextV3()) { var brokerTemplate = new BrokerPolicyTemplate() { BrokerReferenceId = _testedBrokerGuid, CarBrokerRefId = _testedBrokerGuid, CoverBrokerRefId = _testedBrokerGuid, CreationDate = DateTime.Now, TemplateReady = false, }; _dbContext.BrokerPolicyTemplate.Add(brokerTemplate); _dbContext.SaveChanges(); var coverAccidents = new Cover() { CoverBrokerRefId = _testedBrokerGuid, AdditionDate = DateTime.Now, LimitCoverId = _testedBrokerGuid, QuestionCoverId = _testedBrokerGuid, Type = "accidents" }; _dbContext.Cover.Add(coverAccidents); _dbContext.SaveChanges(); Limit limit = new Limit { LimitCoverId = _testedBrokerGuid, CoverType = "accidents", LimitRuleCoverId = _testedBrokerGuid, LimitValues = "0,100,500,1000", Name = "AccidentsLimit" }; _dbContext.Limit.Add(limit); var res = _dbContext.SaveChanges(); Assert.AreEqual(res, 1); var retrievedLimit = _dbContext.Limit.Where(pk => pk.LimitCoverId.Equals(_testedBrokerGuid)).FirstOrDefault(); Assert.IsTrue(retrievedLimit.CoverType.Equals("accidents")); } }
public void Update(BrokerPolicyTemplate template) { var templateFromDb = _dbContext.BrokerPolicyTemplate.FirstOrDefault(t => t.CoverBrokerRefId.Equals(template.CoverBrokerRefId)); if (templateFromDb != null) { templateFromDb.TemplateReady = template.TemplateReady; _dbContext.SaveChanges(); } }
public void Update(Cover cover) { var coverFromDb = _dbContext.Cover.FirstOrDefault(c => c.CoverBrokerRefId.Equals(cover.CoverBrokerRefId)); if (coverFromDb != null) { coverFromDb.Limit = cover.Limit; coverFromDb.Question = cover.Question; _dbContext.SaveChanges(); } }
public void Update(Car car) { var carFromDb = _dbContext.Car.FirstOrDefault(c => c.CarBrokerRefId.Equals(car.CarBrokerRefId)); if (carFromDb != null) { carFromDb.Brand = car.Brand; carFromDb.Model = car.Model; carFromDb.EngineCC = car.EngineCC; carFromDb.EuroStandard = car.EuroStandard; carFromDb.Year = car.Year; _dbContext.SaveChanges(); } }
public void AddGoodCover() { using (var _dbContext = new CarInsuranceContextV3()) { var testCover = new Cover() { CoverBrokerRefId = _testedBrokerGuid, AdditionDate = DateTime.Now, LimitCoverId = Guid.NewGuid(), QuestionCoverId = Guid.NewGuid(), Type = "theft" }; _dbContext.Cover.Add(testCover); var result = _dbContext.SaveChanges(); Assert.AreEqual(result, 1); } }
public void AddLimitForCover() { using (var _dbContext = new CarInsuranceContextV3()) { var coverRetrieved = _dbContext.Cover.Where(c => c.CoverBrokerRefId.Equals(_testedBrokerGuid) && c.Type.Equals("theft")).FirstOrDefault(); var newLimit = new Limit() { CoverType = coverRetrieved.Type, LimitCoverId = coverRetrieved.LimitCoverId, LimitRuleCoverId = Guid.NewGuid(), Name = "TheftLimit", LimitValues = "0,100,1000" }; _dbContext.Limit.Add(newLimit); _dbContext.SaveChanges(); } }
public void AddGoodCar() { using (var _dbContext = new CarInsuranceContextV3()) { var car = new Car() { CarBrokerRefId = _testedBrokerGuid, Brand = "Opel", EngineCC = 1600, EuroStandard = "euro4", Model = "astra", Year = DateTime.Parse("05/06/2008"), CarRuleCoverId = Guid.NewGuid() }; _dbContext.Car.Add(car); var result = _dbContext.SaveChanges(); Assert.AreEqual(result, 1); } }
public bool CreateBrokerPolicyTemplate(AppUser user) { int result = 0; if (CheckIsBroker(user) && !CheckBrokerHasPolicyTemplate(user)) { var brokerTemplate = new BrokerPolicyTemplate() { BrokerReferenceId = Guid.Parse(user.Id), CarBrokerRefId = Guid.Parse(user.Id), CoverBrokerRefId = Guid.Parse(user.Id), CreationDate = DateTime.Now, TemplateReady = false }; _dbContext.BrokerPolicyTemplate.Add(brokerTemplate); result = _dbContext.SaveChanges(); } return(result == 1); }
public void CoverAdditionCoverTypeConstraints() { using (var _dbContext = new CarInsuranceContextV3()) { var testCover = new Cover() { CoverBrokerRefId = _testedBrokerGuid, AdditionDate = DateTime.Now, LimitCoverId = Guid.NewGuid(), QuestionCoverId = Guid.NewGuid(), Type = "test" }; try { _dbContext.Cover.Add(testCover); _dbContext.SaveChanges(); } catch (SqlException ex) { Console.WriteLine(ex.Message); } } }
public int Save() { return(_dbContext.SaveChanges()); }