static void Main(string[] args)
{
var totalGeneratedNo = 0;
var stopwatch = new Stopwatch();
stopwatch.Start();
var context = new ExposureCoverageContext();
ExecuteFixExistingData(context);
var exposureCoverageService = new ExposureCoverageService(context);
var companieService = new CompanyService(context);
var companies = companieService.GetCompanies();
Console.WriteLine("{0}: {1}", "connected to", context.Database.Connection.DataSource);
using (var tran = new TransactionScope(TransactionScopeOption.Required, TimeSpan.FromMinutes(25)))
{
foreach (var company in companies)
{
Console.WriteLine("{0} company {1}", "processing", company.CompanyName);
foreach (var brand in company.Brands)
{
Console.WriteLine("\t \t brand {0}", brand.Name);
var generatedNo = exposureCoverageService.GenerateExposureCoverages(company.CompanyId, company.Channels, brand.BrandId);
totalGeneratedNo += generatedNo;
Console.WriteLine("\t \t \t records number {0}", generatedNo);
}
}
tran.Complete();
}
stopwatch.Stop();
Console.WriteLine("total records number {0}", totalGeneratedNo);
Console.WriteLine("{0} seconds/ {1} minutes", stopwatch.ElapsedMilliseconds / 1000, stopwatch.ElapsedMilliseconds / 1000 / 60);
Console.ReadLine();
}
public CompanyService(ExposureCoverageContext context) : base(context)
{
SetMappings();
}
protected ServiceBase(ExposureCoverageContext context)
{
Context = context;
}
