private async Task <bool> CreateAggregateSpreadsheetRow(InqueryHistoryStatusChangedToParsedDomainEvent @event) { logger.CreateLogger(nameof(@event)).LogTrace($"Start: Inquery history aggregate spreadsheet updated. Inquiry history: {@event.InqueryHistory.Id} - spreadsheet: {@event.InqueryHistory.AgentInquiryInfo.AggregateShareableUrl}."); try { InsertRowToSpreadsheetCommand insertRowToSpreadsheetCommand = new InsertRowToSpreadsheetCommand { SpreadSheetId = @event.InqueryHistory.AgentInquiryInfo.AggregateShareableId, WorkSheetName = "Aggregate", ApplicationName = "LeadsPlus", Values = new List <object>() { @event.InqueryHistory.Id, @event.InqueryHistory.CreatedDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), Enum.GetName(typeof(InquiryType), @event.InqueryHistory.InquiryType), "FALSE", "FALSE", "FALSE", "FALSE", @event.InqueryHistory.OrganizationInfo.OrganizationDomain } }; var spreadsheet = mediator.Send(insertRowToSpreadsheetCommand).Result; } catch (Exception ex) { logger.CreateLogger(nameof(@event)).LogTrace(ex.StackTrace); } logger.CreateLogger(nameof(@event)).LogTrace($"End: Inquery history aggregate spreadsheet updated. Inquiry history: {@event.InqueryHistory.Id} - spreadsheet: {@event.InqueryHistory.AgentInquiryInfo.AggregateShareableUrl}."); return(true); }
public async Task Handle(InqueryHistoryStatusChangedToParsedDomainEvent @event, CancellationToken cancellationToken) { InsertRowToSpreadsheetCommand insertRowToSpreadsheetCommand = new InsertRowToSpreadsheetCommand { SpreadSheetId = @event.InqueryHistory.AgentInquiryInfo.SpreadsheetId, WorkSheetName = Enum.GetName(typeof(InquiryType), @event.InqueryHistory.InquiryType), ApplicationName = "LeadsPlus", Values = new List <object>() { @event.InqueryHistory.Id, @event.InqueryHistory.CreatedDate.ToLocalTime().ToString("yyyy-MM-dd HH:mm:ss"), $"{@event.InqueryHistory.CustomerInfo.Firstname} {@event.InqueryHistory.CustomerInfo.Lastname}", @event.InqueryHistory.CustomerInfo.Email, @event.InqueryHistory.CustomerInfo.Phone, @event.InqueryHistory.CustomerInfo.Address, @event.InqueryHistory.CustomerInfo.Aboutme, @event.InqueryHistory.OrganizationInfo.OrganizationDomain, Enum.GetName(typeof(InquiryType), @event.InqueryHistory.InquiryType), @event.InqueryHistory.PropertyInfo.Message, @event.InqueryHistory.PropertyInfo.PropertyAddress, @event.InqueryHistory.PropertyInfo.ReferenceNo, @event.InqueryHistory.PropertyInfo.PropertyUrl, } }; var spreadsheet = mediator.Send(insertRowToSpreadsheetCommand).Result; await CreateAggregateSpreadsheetRow(@event); logger.CreateLogger(nameof(@event)).LogTrace($"Inquery history spreadsheet updated. Inquiry history: {@event.InqueryHistory.Id} - Inquiry from: {@event.InqueryHistory.OrganizationInfo.OrganizationEmail}."); }