public PolicyMapper(IOrganizationService svc, MappedRow row, PolicyMapperDefaults defaults = null)
{
ThrowIf.Argument.IsNull(svc, "svc");
ThrowIf.Argument.IsNull(row, "row");
_svc = svc;
_template = row.Template;
_attrs = row.Attributes;
if (defaults != null)
{
_defaults = defaults;
}
}
protected void TemplateColumnOnCreate(LocalPluginContext context)
{
var target = context.PluginExecutionContext.InputParameters["Target"] as Entity;
var bxTemplateRef = target.GetAttributeValue <EntityReference>("new_bordereauxtemplate");
if (bxTemplateRef == null)
{
throw new InvalidPluginExecutionException("Bordereau template is empty.");
}
var valueType = target.GetAttributeValue <OptionSetValue>("new_valuetype");
if (valueType == null || valueType.ToEnum <ColumnValueType>() == ColumnValueType.ColumnMapping)
{
// set correct column number based on column label, if number is null
var columnLabel = target.GetAttributeValue <string>("new_columnlabel");
var columnNumber = target.GetAttributeValue <int?>("new_columnnumber");
if (columnNumber == null && !string.IsNullOrEmpty(columnLabel))
{
target["new_columnnumber"] = Utils.LettersToNumber(columnLabel);
}
}
else
{
target["new_columnnumber"] = null;
target["new_columnlabel"] = null;
}
var bxTemplate = context.OrganizationService.Retrieve(bxTemplateRef);
var template = new BordereauTemplate(context.OrganizationService, context.TracingService, bxTemplate);
var numberOfColumns = template.TemplateColumns.Count();
var name = "{0} - {1:000}".FormatWith(bxTemplate.GetAttributeValue <string>("new_name"), numberOfColumns + 1);
target["new_name"] = name;
}
public List <Guid> MapClaim(IOrganizationService svc, MappedRow mappedRow, BordereauTemplate template, BordereauProcess bxProcess)
{
ThrowIf.Argument.IsNull(svc, "svc");
ThrowIf.Argument.IsNull(mappedRow, "mappedRow");
ThrowIf.Argument.IsNull(template, "template");
ThrowIf.Argument.IsNull(bxProcess, "bxProcess");
Guid createdClaimId = Guid.Empty;
List <Guid> createdClaim = new List <Guid>();
try
{
//Get the template columns
var templateColumns = template.TemplateColumns.ToArray();
var country = bxProcess.CountryRef;
//Get the distinct claim orders that will differentiate between multiple claims
var retreievedClaimOrders = templateColumns
.Where(c => c.ClaimOrder != null)
.Select(c => c.ClaimOrder)
.Distinct();
var order = mappedRow.Attributes
.ForEntity("new_claim")
.Where(c => c.TemplateColumn.ClaimOrder != null)
.Select(c => c.TemplateColumn.ClaimOrder)
.Distinct();
//Get all the common fields between all claims
var claimAttributeValue = mappedRow.Attributes
.ForEntity("new_claim")
.ForClaimOrder(null);
mapAttribute.claimStatus = mappedRow.Attributes
.ForAttribute("statuscode")
.FirstOrDefault().AsOptionSet();
CheckClaimAttributes(svc, mappedRow);
foreach (var claimOrder in retreievedClaimOrders)
{
#region Claim
//Get the fileds based on the Claim Order
var claimValueBasedOnClaimOrder = mappedRow.Attributes
.ForEntity("new_claim")
.ForClaimOrder(claimOrder);
var reserveFieldRowValue = claimValueBasedOnClaimOrder
.ForAttribute("new_reserve")
.FirstOrDefault().AsDecimal();
var peril = claimValueBasedOnClaimOrder
.ForAttribute("new_peril1")
.FirstOrDefault().AsString();
var subPeril = claimValueBasedOnClaimOrder
.ForAttribute("new_subperil")
.FirstOrDefault().AsString();
mapAttribute.excess = claimValueBasedOnClaimOrder
.ForAttribute("new_policyexcess")
.FirstOrDefault().AsDecimal();
//If reserve field is empty we dont create a claim
//if (peril != null && peril != "" && subPeril != null && subPeril != "")
if (subPeril != null && subPeril != "")
{
if (reserveFieldRowValue != null && reserveFieldRowValue > 0)
{
//GetClaimValues(svc, mappedRow, claimOrder);
mapAttribute.Reserve = reserveFieldRowValue;
if (claimValueBasedOnClaimOrder.Where(c => c.AttributeName == "new_claimedamount").Select(c => c.Value).FirstOrDefault() != null)
{
mapAttribute.ClaimedAmount = claimValueBasedOnClaimOrder
.ForAttribute("new_claimedamount")
.FirstOrDefault()
.AsDecimal();
}
//Get the broker claim reference
var claimRefValue = mappedRow.Attributes
.ForEntity("new_claim")
.ForAttribute("new_claimreference")
.FirstOrDefault().AsString();
mapAttribute.claimFolderReferenceValue = mappedRow.Attributes
.ForEntity("new_claim")
.ForAttribute("new_claimreference")
.FirstOrDefault().AsString();
mapAttribute.brokerId = bxProcess.BrokerRef.Id;
mapAttribute.bxprocessId = bxProcess.Id;
mapAttribute.lossTypeDescription = claimValueBasedOnClaimOrder
.ForAttribute("new_losstypedescription")
.FirstOrDefault().AsString();
mapAttribute.BrokerClaimReference = claimAttributeValue
.ForAttribute("new_claimreference")
.FirstOrDefault().AsString();
var riskSubClass = mappedRow.Attributes.ForEntity("new_claim").ForClaimOrder(claimOrder).ForAttribute("new_insuredrisk").FirstOrDefault();
//Map the claim fields to be imported
Claim claim = new Claim(svc);
if (riskSubClass.Value != "Buildings and Contents")
{
GetClaimValues(svc, mappedRow, claimOrder, riskSubClass.Value);
claim.CreateOrUpdateClaim(mapAttribute);
}
else
{
GetClaimValues(svc, mappedRow, claimOrder, "Buildings");
claim.CreateOrUpdateClaim(mapAttribute);
GetClaimValues(svc, mappedRow, claimOrder, "Contents");
claim.CreateOrUpdateClaim(mapAttribute);
//continue;
}
//createdClaimId = claim.CreateOrUpdateClaim();
//if (createdClaimId != Guid.Empty)
// createdClaim.Add(createdClaimId);
#endregion Claim
#region Payment
//Get the payment fields and map
ClaimPayment payment = new ClaimPayment(svc, mappedRow, country, claimOrder);
payment.CreateOrUpdatePayment(createdClaimId, mapAttribute.policy.FirstOrDefault());
if (mapAttribute.claimStatus.Value == 100000001)
{
payment.UpdateClaimPaymentStatus(createdClaimId);
}
#endregion Payment
#region Recovery
ClaimRecovery recovery = new ClaimRecovery(svc, mappedRow, country, claimOrder);
recovery.CreateOrUpdateRecovery(createdClaimId, mapAttribute.policy.FirstOrDefault());
if (mapAttribute.claimStatus.Value == 100000001)
{
recovery.UpdateClaimRecoveryStatus(createdClaimId);
//payment.UpdateClaimPaymentStatus(createdClaimId);
}
#endregion
}
}
}
#region RoleInClaim
//var retreievedRoleTypeOrder = templateColumns
// .Where(c => c.ClaimOrder == claimOrder && c.ClaimRoleTypeOrder != null)
// .Select(c => c.ClaimRoleTypeOrder).Distinct();
var retreievedRoleTypeOrder = templateColumns
.Where(c => c.ClaimRoleTypeOrder != null)
.Select(c => c.ClaimRoleTypeOrder).Distinct();
Guid createdVehicleId = Guid.Empty;
Entity roleInClaim = null;
foreach (var roleTypeOrder in retreievedRoleTypeOrder)
{
//var allRoleAttributes = mappedRow.Attributes.ForClaimOrder(claimOrder).ForRoleNumber(roleTypeOrder);
var allRoleAttributes = mappedRow.Attributes.ForRoleNumber(roleTypeOrder);
var contactFirstname = allRoleAttributes.ForAttribute("firstname").FirstOrDefault().AsString();
var contactLastName = allRoleAttributes.ForAttribute("lastname").FirstOrDefault().AsString();
if (contactFirstname != null && contactLastName != null)
{
roleInClaim = CreateRoleInClaim(svc, allRoleAttributes, createdClaimId, country);
}
var riskClass = bxProcess.RiskClassRef.Name;
if (riskClass.ToLower() == "vehicle")
{
var check = allRoleAttributes.Where(c => c.AttributeName == "new_registrationnumber").FirstOrDefault();
if (check != null)
{
var vehicleRegistrationNo = allRoleAttributes.ForAttribute("new_registrationnumber").FirstOrDefault().AsString();
if (vehicleRegistrationNo != null)
{
createdVehicleId = CreateVehicle(svc, allRoleAttributes, createdClaimId);
}
if (createdVehicleId != Guid.Empty)
{
roleInClaim["new_vehicleid"] = new EntityReference("new_vehicle", createdVehicleId);
svc.Update(roleInClaim);
}
}
}
}
#endregion
}
catch (InvalidPluginExecutionException e)
{
throw new InvalidPluginExecutionException(e.Message, e.InnerException);
}
//catch (Exception ex)
//{
// throw new Exception(ex.Message);
//}
return(createdClaim);
}
/// <summary>
/// Creates new Mapped Row instance.
/// </summary>
/// <param name="row">Bordereau import row, which provides string data values.</param>
/// <param name="template">Bordereau template, which is used for processing rows.</param>
public MappedRow(BordereauImportRow row, BordereauTemplate template)
{
_row = row;
_template = template;
}
