public static void SyncSemiStaticData()
		{
			DatabaseInit._LogHandler.WriteLog("SyncSemiStaticData()", LogSeverity.Information, LogCategory.DataAccess);

			using (var httpHandler = new HttpClientHandler())
			{
				httpHandler.UseDefaultCredentials = true;

				using (var httpClient = new HttpClient(httpHandler))
				{
					httpClient.BaseAddress = new Uri(Properties.Settings.Default.ServicesHostUrl);
					httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/xml"));

					using (var consoleRepository = new ConsoleRepository())
					{

                        DatabaseInit.SyncBrokers(httpClient, consoleRepository);
                        DatabaseInit.SyncNonLondonBrokers(httpClient, consoleRepository);
                        DatabaseInit.SyncCOBs(httpClient, consoleRepository);
                        DatabaseInit.SyncOffices(httpClient, consoleRepository);
                        DatabaseInit.SyncUnderwriters(httpClient, consoleRepository);
                        DatabaseInit.SyncRiskCodes(httpClient, consoleRepository);

                        DatabaseInit.UpdateSipAddresses(consoleRepository);
                        DatabaseInit.UpdateEmailAddresses(consoleRepository);
                        DatabaseInit.UpdateUserPictures(consoleRepository);

						consoleRepository.SaveChanges();
					}
				}
			}            
		}
        public string CreateQuoteSheet(CreateQuoteSheetDto dto, out Submission submission)
        {
            // TODO: use the correct quote sheet...
            var quoteSheetTemplateId = dto.QuoteSheetTemplateId;
            dto.QuoteSheetTemplateUrl = this.ConsoleRepository.Query<QuoteTemplate>()
                                            .FirstOrDefault(qt => qt.Id == dto.QuoteSheetTemplateId).RdlPath;
            dto.QuoteSheetTemplateName = this.ConsoleRepository.Query<QuoteTemplate>()
                                            .FirstOrDefault(qt => qt.Id == dto.QuoteSheetTemplateId).Name;

            submission = this.SubmissionModule.GetSubmissionById(dto.SubmissionId);
            //todo this is done to clear previous context. has to be fixed once softdelet is fixed.
            using (IConsoleRepository consoleRepository = new ConsoleRepository())
            {
                if (submission == null)
                    throw new KeyNotFoundException(string.Format(this.NotFoundMessage, dto.SubmissionId));
                consoleRepository.Attach(submission);
                var currentUser = consoleRepository.Query<User>()
                                      .FirstOrDefault(u => u.DomainLogon == this.HttpContext.CurrentUser.Identity.Name);

                if (currentUser == null)
                    throw new ApplicationException("Current user could not be found");

                var quotesheet = new QuoteSheet
                {
                    Title = string.Format(this.QuoteSheetTitle, submission.Title, submission.InsuredName, DateTime.Now),
                    IssuedBy = currentUser,
                    IssuedById = currentUser.Id,
                    IssuedDate = DateTime.Now,
                    ObjectStore = "Underwriting"
                };

                var content = this.QuoteSheetData.CreateQuoteSheetPdf(dto);

                quotesheet.Guid = this.QuoteSheetData.SaveQuoteSheetToDMS(quotesheet, content, submission);

                var versions = (from version in submission.Options.SelectMany(o => o.OptionVersions)
                                from option in dto.OptionList
                                where version.OptionId == option.OptionId
                                from versionNumber in option.OptionVersionNumberList
                                where version.VersionNumber == versionNumber
                                select version).ToList();

                quotesheet.OptionVersions = versions;

                foreach (var quote in versions.SelectMany(ov => ov.Quotes))
                {
                    quote.OptionVersion.IsLocked = true;

                    quote.SubmissionStatus = "QUOTED";
                }

                consoleRepository.Add(quotesheet);
                consoleRepository.SaveChanges();
                return string.Format(this.QuoteSheetUrl,
                               ConfigurationManager.AppSettings["UWDmsFileDownloadURL"],
                               quotesheet.Guid);
            }

          
        }
 public void Audit(string source, string reference, string title, string description)
 {
     //todo: need to work on dispose
     using (IConsoleRepository consoleRepository = new ConsoleRepository())
     {
         consoleRepository.Add(new AuditTrail
             {
                 Source = source,
                 Reference = reference,
                 Title = title,
                 Description = description
             });
         consoleRepository.SaveChanges();
     }
 }
        public static void Setup(TestContext t)
        {            
            using (IConsoleRepository _rep = new ConsoleRepository())
            {
                Team teamA = new Team() { Title = "Team A", DefaultPolicyType = "MARINE", QuoteExpiryDaysDefault = 30 };
                _rep.Add<Team>(teamA);
                Team teamB = new Team() { Title = "Team B", DefaultPolicyType = "MARINE", QuoteExpiryDaysDefault = 30 };
                _rep.Add<Team>(teamB);
                
                COB aa = new COB() { Id = "AA", Narrative = "AA" };
                COB bb = new COB() { Id = "BB", Narrative = "BB" };
                COB xx = new COB() { Id = "XX", Narrative = "XX" };
                COB yy = new COB() { Id = "YY", Narrative = "YY" };
                COB zz = new COB() { Id = "ZZ", Narrative = "ZZ" };
                _rep.Add<COB>(aa);
                _rep.Add<COB>(bb);
                _rep.Add<COB>(xx);
                _rep.Add<COB>(yy);
                _rep.Add<COB>(zz);

                teamA.RelatedCOBs = new List<COB>();
                teamA.RelatedCOBs.Add(aa);
                teamA.RelatedCOBs.Add(bb);
                teamA.RelatedCOBs.Add(xx);

                teamB.RelatedCOBs = new List<COB>();
                teamB.RelatedCOBs.Add(xx);
                teamB.RelatedCOBs.Add(yy);
                teamB.RelatedCOBs.Add(zz);

                User user1 = new User() { DomainLogon = @"talbot\user1", UnderwriterCode = "AED" };
                _rep.Add<User>(user1);

                _rep.SaveChanges();
                newUserId = user1.Id;
                TeamAId = teamA.Id;
                TeamBId = teamB.Id;
            }
            
            context = new Mock<ICurrentHttpContext>();
            var user = @"talbotdev\MurrayE";
            
            context.Setup(h => h.CurrentUser).Returns(new GenericPrincipal(new GenericIdentity(user), null));
            context.Setup(h => h.Context).Returns(MvcMockHelpers.FakeHttpContextWithSession());            
        }
        public static void Setup(TestContext t)
        {
            using (IConsoleRepository rep = new ConsoleRepository())
            {
                _totalMarketWording = rep.Query<MarketWording>(mw => true).Count();
                _totalTermsNConditionWording = rep.Query<TermsNConditionWording>(mw => true).Count();
                _totalSubjectToClauseWording = rep.Query<SubjectToClauseWording>(mw => true).Count();
                var lon = rep.Query<Office>(off => off.Id == "LON").First();
                var team = new Team
                    {
                        Title = "TestTeam",
                        QuoteExpiryDaysDefault = 30,
                        CreatedBy = "InitialSetup",
                        CreatedOn = DateTime.Now,
                        ModifiedBy = "InitialSetup",
                        ModifiedOn = DateTime.Now,
                        SubmissionTypeId = null,
                        DefaultPolicyType = "MARINE",
                        RelatedOffices = new List<Office> { lon },
                        TeamOfficeSettings =
                            new List<TeamOfficeSetting>
                                {
                                    new TeamOfficeSetting
                                        {
                                            Office = lon,
                                            MarketWordingSettings = new List<MarketWordingSetting>(),
                                            TermsNConditionWordingSettings = new List<TermsNConditionWordingSetting>(),
                                            SubjectToClauseWordingSettings = new List<SubjectToClauseWordingSetting>()
                                        }
                                }
                    };
                rep.Add(team);
                rep.SaveChanges();

            }
            _httpContext = new Mock<ICurrentHttpContext>();
            const string user = @"talbotdev\MurrayE";

            _httpContext.Setup(h => h.CurrentUser).Returns(new GenericPrincipal(new GenericIdentity(user), null));
            _httpContext.Setup(h => h.Context).Returns(MvcMockHelpers.FakeHttpContextWithSession());
        }
        public string CreateQuoteSheet(CreateQuoteSheetDto dto, out Submission submission)
        {
            // TODO: use the correct quote sheet...
            var quoteSheetTemplateId = dto.QuoteSheetTemplateId;
            dto.QuoteSheetTemplateUrl = this.ConsoleRepository.Query<QuoteTemplate>()
                                            .FirstOrDefault(qt => qt.Id == dto.QuoteSheetTemplateId).RdlPath;
            dto.QuoteSheetTemplateName = this.ConsoleRepository.Query<QuoteTemplate>()
                                            .FirstOrDefault(qt => qt.Id == dto.QuoteSheetTemplateId).Name;

            submission = this.SubmissionModule.GetSubmissionById(dto.SubmissionId);
            //todo this is done to clear previous context. has to be fixed once softdelet is fixed.
            using (IConsoleRepository consoleRepository = new ConsoleRepository())
            {
                if (submission == null)
                    throw new KeyNotFoundException(string.Format(this.NotFoundMessage, dto.SubmissionId));
                consoleRepository.Attach(submission);
                var currentUser = consoleRepository.Query<User>()
                                      .FirstOrDefault(u => u.DomainLogon == this.HttpContext.CurrentUser.Identity.Name);

                if (currentUser == null)
                    throw new ApplicationException("Current user could not be found");
                
                var versions = (from version in submission.Options.SelectMany(o => o.OptionVersions)
                                from option in dto.OptionList
                                where version.OptionId == option.OptionId
                                from versionNumber in option.OptionVersionNumberList
                                where version.VersionNumber == versionNumber
                                select version).ToList();

                var isDeclinature = false;
                var submSt = submission.Options.Select(s => s)
                                   .SelectMany(o => o.OptionVersions)
                                   .SelectMany(ov => ov.Quotes)
                                   .Where(q => q.IsSubscribeMaster).Select(s => s.SubmissionStatus).Distinct().ToList();
                if ((submSt.Count == 1) && (submSt.FirstOrDefault().Equals(Settings.Default["DeclinatureSubmissionStatus"].ToString())))
                    isDeclinature = true;

                var quotesheet = new QuoteSheet
                {//Todo: S2Q
                    Title = string.Format(this.QuoteSheetTitle, submission.Title, versions.SelectMany(ov => ov.Quotes).First().InsuredName,  DateTime.Now),
                    IssuedBy = currentUser,
                    IssuedById = currentUser.Id,
                    IssuedDate = DateTime.Now,
                    ObjectStore = Settings.Default["DMSObjectStore"].ToString(),
                    DocumentClass = Settings.Default["DMSDocumentClass"].ToString(),
                    DocumentType = isDeclinature ? Settings.Default["DeclinatureDocType"].ToString() : Settings.Default["QuoteDocType"].ToString()
                };

                var content = this.QuoteSheetData.CreateQuoteSheetPdf(dto, isDeclinature);

                quotesheet.Guid = this.QuoteSheetData.SaveQuoteSheetToDMS(quotesheet, content, submission, isDeclinature);
                
                quotesheet.OptionVersions = versions;

                if (!isDeclinature)
                {
                    foreach (var quote in versions.SelectMany(ov => ov.Quotes))
                    {
                        if (!quote.SubmissionStatus.Equals(Settings.Default["DeclinatureSubmissionStatus"].ToString()))
                        {
                            quote.OptionVersion.IsLocked = true;

                            quote.SubmissionStatus = "QUOTED";
                        }
                    }
                }

                consoleRepository.Add(quotesheet);
                consoleRepository.SaveChanges();
                return string.Format(this.QuoteSheetUrl,
                               ConfigurationManager.AppSettings["UWDmsFileDownloadURL"],
                               quotesheet.Guid);
            }

          
        }