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 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);
}
}