public async Task <GetMerchantWorkflowResponse> Handle(GetMerchantWorkflowQuery request, CancellationToken cancellationToken)
{
var data = from mw in _context.MerchantWorkflows.AsEnumerable()
join m in _context.Merchants.AsEnumerable() on mw.MerchantID equals m.ID
join w in _context.Workflows.AsEnumerable() on mw.WorkflowID equals w.ID
join ws in _context.WorkflowSteps.AsEnumerable() on mw.WorkflowID equals ws.WorkflowID
join ct in _context.CorrespondenceTypes.AsEnumerable() on ws.CorrespondenceTypeID equals ct.ID
join c in _context.Customers.AsEnumerable() on request.CustomerID equals c.ID
join ml in _context.MerchantLocations.AsEnumerable() on new { request.MerchantID, ws.CorrespondenceTypeID, IsDefault = true } equals new { ml.MerchantID, ml.CorrespondenceTypeID, ml.IsDefault } into tmp_ml
from ml in tmp_ml.DefaultIfEmpty()
join ca in _context.CustomerAddresses.AsEnumerable() on new { request.CustomerID, ws.CorrespondenceTypeID, IsDefault = true } equals new { ca.CustomerID, ca.CorrespondenceTypeID, ca.IsDefault } into tmp_ca
from ca in tmp_ca.DefaultIfEmpty()
join mi in _context.MerchantImages.AsEnumerable() on new { MerchantID = m.ID, IsDefault = true } equals new { mi.MerchantID, mi.IsDefault } into tmp_mi
from mi in tmp_mi.DefaultIfEmpty()
where mw.MerchantID == request.MerchantID && mw.IsDefault
select new { mw, ws, c, ca, ml, mi };
if (data == null || data.FirstOrDefault() == null)
{
return(new GetMerchantWorkflowResponse());
}
var model = new GetMerchantWorkflowResponse();
model.Workflow = _mapper.Map <MerchantWorkflowModel>(data.First().mw);
model.Customer = data.First().c != null
? _mapper.Map <WorkflowCustomerModel>(data.First().c)
: new WorkflowCustomerModel();
foreach (var m in data.OrderBy(s => s.ws.Step))
{
var step = _mapper.Map <WorkflowStepModel>(m.ws);
var address = new WorkflowStepAddressModel();
if (m.ml != null)
{
step.Address = _mapper.Map <WorkflowStepAddressModel>(m.ml);
}
else if (m.ca != null)
{
step.Address = _mapper.Map <WorkflowStepAddressModel>(m.ca);
}
//TODO: calculate default scheduled at time based on correspondence time, steps, etc.
step.ScheduledAt = DateTime.Now.AddDays(2);
model.Steps.Add(step);
if (m.mi != null && !string.IsNullOrEmpty(m.mi.ImageUrl) &&
string.IsNullOrEmpty(model.Workflow.MerchantDefaultImageUrl))
{
model.Workflow.MerchantDefaultImageUrl = m.mi.ImageUrl;
}
}
await Task.FromResult(0);
return(model);
}
public WorkflowStepModel()
{
Address = new WorkflowStepAddressModel();
}
