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 UnitOfWork(CarInsuranceContextV3 db)
{
_dbContext = db;
BrokerPolicyTemplateRepository = new BrokerPolicyTemplateRepository(db);
CarRepository = new CarRepository(db);
CoverRepository = new CoverRepository(db);
}
public AccountController(UserManager <AppUser> userManager, SignInManager <AppUser> signInManager, RoleManager <IdentityRole> roleManager, CarInsuranceContextV3 context)
{
this._userManager = userManager;
this._signInManager = signInManager;
this._roleManager = roleManager;
this._dbContext = context;
}
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();
}
}
public PolicyTemplateController(UserManager <AppUser> userManager, SignInManager <AppUser> signInManager,
RoleManager <IdentityRole> roleManager, CarInsuranceContextV3 context,
IBrokerService brokerService, IUnitOfWork unitOfWork)
{
this.userManager = userManager;
this.signInManager = signInManager;
this.roleManager = roleManager;
this._dbContext = context;
this._brokerService = brokerService;
this._unitOfWork = unitOfWork;
}
//[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 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 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 CoverRepository(CarInsuranceContextV3 db) : base(db)
{
_dbContext = db;
}
public Repository(CarInsuranceContextV3 dbContext)
{
_dbContext = dbContext;
dbSet = _dbContext.Set <T>();
}
public DatabaseTesting()
{
_dbContext = new CarInsuranceContextV3();
}
public BrokerService(CarInsuranceContextV3 db)
{
_dbContext = db;
}
public IBrokerServiceTesting()
{
_dbContext = new CarInsuranceContextV3();
}
public BrokerPolicyTemplateRepository(CarInsuranceContextV3 db) : base(db)
{
_dbContext = db;
}
