protected void bindData()
{
var carriers = CarrierManager.GetCarriers(clientID).ToList();
//LeadPolicyCoverage[] coverages = new LeadPolicyCoverage[5];
CollectionManager.FillCollection(ddlCarrier, "CarrierID", "CarrierName", carriers);
var states = State.GetAll();
CollectionManager.FillCollection(ddlState, "StateId", "StateName", states);
CollectionManager.FillCollection(ddlInsuredLossState, "StateId", "StateName", states);
CollectionManager.FillCollection(ddlInsuredMailingState, "StateId", "StateName", states);
// coverage
//gvCoverages.DataSource = coverages;
//gvCoverages.DataBind();
// property type
CollectionManager.FillCollection(ddlTypeOfProperty, "TypeOfPropertyId", "TypeOfProperty", TypeOfPropertyManager.GetAll());
// type of damage
Fillchk(chkTypeOfDamage, "TypeOfDamageId", "TypeOfDamage", TypeofDamageManager.GetAll());
}
protected void btnSave_Click(object sender, EventArgs e)
{
lblError.Text = string.Empty;
lblError.Visible = false;
lblSave.Text = string.Empty;
lblSave.Visible = false;
lblMessage.Visible = false;
lblMessage.Text = string.Empty;
Page.Validate("TypeofDamage");
if (!Page.IsValid)
{
return;
}
try {
bool exists = TypeofDamageManager.IsExist(txtTypeofDamage.Text.Trim(), Convert.ToInt32(hdId.Value));
if (exists)
{
lblMessage.Text = "Type Of Damage already exists.";
lblMessage.Visible = true;
txtTypeofDamage.Focus();
return;
}
TypeOfDamageMaster obj = TypeofDamageManager.GetbyTypeOfDamageId(Convert.ToInt32(hdId.Value));
obj.TypeOfDamage = txtTypeofDamage.Text;
if (!string.IsNullOrEmpty(txtSort.Text))
{
obj.Sort = (byte)Convert.ToInt32(txtSort.Text);
}
obj.Status = true;
if (clientID > 0)
{
obj.ClientId = clientID;
}
TypeofDamageManager.Save(obj);
saveMsg = hdId.Value == "0" ? "Record Saved Successfully." : "Record Updated Successfully.";
btnCancel_Click(null, null);
lblSave.Text = saveMsg;
lblSave.Visible = true;
}
catch (Exception ex) {
lblError.Visible = true;
lblError.Text = "Record Not Saved !!!";
}
}
protected void cbxHidden_CheckedChanged(object sender, EventArgs e)
{
ListViewItem lvItem = ((CheckBox)sender).NamingContainer as ListViewItem;
int idx = lvItem.DataItemIndex;
int TypeofDamageId = (int)lvData.DataKeys[idx].Value;
TypeOfDamageMaster damageType = TypeofDamageManager.GetbyTypeOfDamageId(TypeofDamageId);
if (damageType != null)
{
damageType.IsHidden = ((CheckBox)sender).Checked;
TypeofDamageManager.Save(damageType);
DoBind();
}
}
protected void lvData_ItemCommand(object sender, ListViewCommandEventArgs e)
{
lblError.Text = string.Empty;
lblSave.Text = string.Empty;
lblMessage.Text = string.Empty;
lblMessage.Visible = false;
lblError.Visible = false;
lblSave.Visible = false;
if (e.CommandName.Equals("DoEdit"))
{
int Id = Convert.ToInt32(e.CommandArgument);
hdId.Value = Id.ToString();
Label lblTypeOfDamage = (Label)e.Item.FindControl("lblTypeOfDamage");
txtTypeofDamage.Text = lblTypeOfDamage.Text;
Label lblSort = (Label)e.Item.FindControl("lblSort");
txtSort.Text = lblSort.Text;
}
else if (e.CommandName.Equals("DoDelete"))
{
// In Case of delete
try {
//Label lblTypeOfDamage = (Label)e.Item.FindControl("lblTypeOfDamage");
//var list = CheckPrimaryValue.checkTypeofDamage(lblTypeOfDamage.Text);
//if (list.ToList().Count > 0) {
// lblMessage.Text = "Type of Damage is used so you can't delete !!!";
// lblMessage.Visible = true;
// return;
//}
var dt = TypeofDamageManager.GetbyTypeOfDamageId(Convert.ToInt32(e.CommandArgument));
dt.Status = false;
TypeofDamageManager.Save(dt);
DoBind();
lblSave.Text = "Record Deleted Successfully.";
lblSave.Visible = true;
}
catch (Exception ex) {
lblError.Text = "Record Not Deleted.";
lblError.Visible = true;
}
}
}
private void DoBind()
{
List <TypeOfDamageMaster> lst = TypeofDamageManager.GetAll(clientID);
if (lst.Count > 0)
{
dvData.Visible = true;
PagerRow.Visible = true;
lvData.DataSource = lst;
lvData.DataBind();
}
else
{
dvData.Visible = false;
PagerRow.Visible = false;
}
}
private Claim createClaim(int policyID, DataRow dataRow)
{
decimal amount = 0;
AdjusterMaster adjuster = null;
string adjusterName = null;
string causeofLoss = null;
Claim claim = null;
string claimstatus = null;
int clientID = SessionHelper.getClientId();
Contact contact = null;
DateTime dateTime = DateTime.MinValue;
LeadContactType contactType = null;
string ownerManagerName = null;
string ownerManagerEntityName = null;
int severity = 0;
string supervisorName = null;
string teamLead = null;
TypeOfDamageMaster damageType = null;
int userID = SessionHelper.getUserId();
string userFieldName = null;
claim = new Claim();
claim.PolicyID = policyID;
claim.IsActive = true;
// Insurer Claim ID
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Insurer Claim ID");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
claim.InsurerClaimNumber = dataRow[userFieldName].ToString().Trim();
claim.AdjusterClaimNumber = claim.InsurerClaimNumber;
}
// Adjuster Claim Number
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Adjuster Claim Number");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
claim.AdjusterClaimNumber = dataRow[userFieldName].ToString().Trim();
}
// Claim Status
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Claim Status");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
claimstatus = dataRow[userFieldName].ToString().Trim();
if (!string.IsNullOrEmpty(claimstatus))
{
StatusMaster statusMaster = StatusManager.GetByStatusName(clientID, claimstatus);
if (statusMaster.StatusId == 0)
{
statusMaster.StatusName = claimstatus;
statusMaster.clientID = clientID;
statusMaster.Status = true;
statusMaster = StatusManager.Save(statusMaster);
}
claim.StatusID = statusMaster.StatusId;
}
}
#region Dates
// Date of Loss
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date of Loss");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.LossDate = dateTime;
}
}
// Date Reported
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Reported");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateOpenedReported = dateTime;
}
}
// Date First Closed
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date First Closed");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateFirstClosed = dateTime;
}
}
// Date First Reopen
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date First Reopen");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateFirstReOpened = dateTime;
}
}
// Date Assigned
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Assigned");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateAssigned = dateTime;
}
}
// Date Acknowledged
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Acknowledged");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateAcknowledged = dateTime;
}
}
// Date First Contact Attempted
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date First Contact Attempted");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateFirstContactAttempt = dateTime;
}
}
//Date Contacted
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Contacted");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateContacted = dateTime;
}
}
//Date Inspection Scheduled
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Inspection Scheduled");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateInspectionScheduled = dateTime;
}
}
// Date Inspection Completed
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Inspection Completed");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateInspectionCompleted = dateTime;
}
}
// Date Estimate Uploaded
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Estimate Uploaded");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateEstimateUploaded = dateTime;
}
}
// Date of Initial Reserve Change
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date of Initial Reserve Change");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateInitialReserveChange = dateTime;
}
}
// Date Indemnity Payment Requested
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Indemnity Payment Requested");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateIndemnityPaymentRequested = dateTime;
}
}
// Date Indemnity Payment Approved
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Indemnity Payment Approved");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateIndemnityPaymentApproved = dateTime;
}
}
// Date Indemnity Payment Issued
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Indemnity Payment Issued");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateIndemnityPaymentIssued = dateTime;
}
}
// Date Completed
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Completed");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateCompleted = dateTime;
}
}
// Date Closed
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Closed");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateClosed = dateTime;
}
}
// Date Closed
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Date Closed");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (DateTime.TryParse(dataRow[userFieldName].ToString(), out dateTime))
{
claim.DateClosed = dateTime;
}
}
#endregion
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Cycle Time");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (decimal.TryParse(dataRow[userFieldName].ToString(), out amount))
{
claim.CycleTime = amount;
}
}
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "ReOpenCycle Time");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (decimal.TryParse(dataRow[userFieldName].ToString(), out amount))
{
claim.ReopenCycleTime = amount;
}
}
#region adjuster
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Adjuster Name");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
adjusterName = dataRow[userFieldName].ToString().Trim();
adjuster = AdjusterManager.GetByAdjusterName(clientID, adjusterName);
if (adjuster.AdjusterId == 0)
{
// add adjuster
adjuster = new AdjusterMaster();
adjuster.Status = true;
adjuster.AdjusterName = adjusterName.Trim();
adjuster.ClientId = clientID;
adjuster.InsertBy = userID;
adjuster.InsertDate = DateTime.Now;
adjuster.isEmailNotification = true;
adjuster = AdjusterManager.Save(adjuster);
}
claim.AdjusterID = adjuster.AdjusterId;
}
#endregion
#region supervisor
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Supervisor Name");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
supervisorName = dataRow[userFieldName].ToString().Trim();
if (!string.IsNullOrEmpty(supervisorName))
{
contactType = LeadContactTypeManager.Get(clientID, "Supervisor");
if (contactType == null)
{
contactType = addNewContactType(clientID, "Supervisor");
}
contact = ContactManager.Get(clientID, supervisorName);
if (contact == null)
{
contact = addNewContact(clientID, supervisorName, contactType.ID);
}
claim.SupervisorID = contact.ContactID;
}
}
#endregion
#region Team Lead
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Team Lead Name");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
teamLead = dataRow[userFieldName].ToString().Trim();
if (!string.IsNullOrEmpty(teamLead))
{
contactType = LeadContactTypeManager.Get(clientID, "Team Lead");
if (contactType == null)
{
contactType = addNewContactType(clientID, "Team Lead");
}
contact = ContactManager.Get(clientID, teamLead);
if (contact == null)
{
contact = addNewContact(clientID, teamLead, contactType.ID);
}
claim.TeamLeadID = contact.ContactID;
}
}
#endregion
#region Owner Manager Name
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Owner Manager Name");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
ownerManagerName = dataRow[userFieldName].ToString().Trim();
if (!string.IsNullOrEmpty(ownerManagerName))
{
contactType = LeadContactTypeManager.Get(clientID, "Owner Manager");
if (contactType == null)
{
contactType = addNewContactType(clientID, "Owner Manager");
}
contact = ContactManager.Get(clientID, ownerManagerName);
if (contact == null)
{
contact = addNewContact(clientID, ownerManagerName, contactType.ID);
}
claim.ManagerID = contact.ContactID;
}
}
#endregion
#region Owner Manager Entity Name
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Owner Manager Entity Name");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
ownerManagerEntityName = dataRow[userFieldName].ToString().Trim();
if (!string.IsNullOrEmpty(ownerManagerEntityName))
{
contactType = LeadContactTypeManager.Get(clientID, "Owner Manager Entity Name");
if (contactType == null)
{
contactType = addNewContactType(clientID, "Owner Manager Entity Name");
}
contact = ContactManager.Get(clientID, ownerManagerEntityName);
if (contact == null)
{
contact = addNewContact(clientID, ownerManagerEntityName, contactType.ID);
}
claim.ManagerEntityID = contact.ContactID;
}
}
#endregion
// severity
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Severity");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
if (int.TryParse(dataRow[userFieldName].ToString().Trim(), out severity))
{
claim.SeverityNumber = severity;
}
}
// event
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Event Type");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
claim.EventType = dataRow[userFieldName].ToString().Trim();
}
// event name
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Event Name");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
claim.EventName = dataRow[userFieldName].ToString().Trim();
}
// Cause of Loss Description
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Cause of Loss Description");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
causeofLoss = dataRow[userFieldName].ToString().Trim();
damageType = TypeofDamageManager.GetTypeOfDamage(clientID, causeofLoss);
if (damageType.TypeOfDamageId == 0)
{
damageType.ClientId = clientID;
damageType.Status = true;
damageType.TypeOfDamage = causeofLoss;
damageType = TypeofDamageManager.Save(damageType);
}
claim.CauseOfLoss = damageType.TypeOfDamageId.ToString();
}
#region Amounts
// Claim Workflow Type
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Claim Workflow Type");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
claim.ClaimWorkflowType = dataRow[userFieldName].ToString().Trim();
}
// Outstanding Indemnity Reserve
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Outstanding Indemnity Reserve");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.OutstandingIndemnityReserve = amount;
}
// Outstanding LAE Reserves
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Outstanding LAE Reserves");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.OutstandingLAEReserves = amount;
}
// Total Indemnity Paid
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Total Indemnity Paid");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.TotalIndemnityPaid = amount;
}
// Coverage A Paid
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Coverage A Paid");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.CoverageAPaid = amount;
}
// Coverage B Paid
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Coverage B Paid");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.CoverageBPaid = amount;
}
// Coverage C Paid
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Coverage C Paid");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.CoverageCPaid = amount;
}
// Coverage D Paid
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Coverage D Paid");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.CoverageDPaid = amount;
}
// Total Expenses Paid
userFieldName = Core.CSVHelper.getUserFieldName(this.mappedFields, "Total Expenses Paid");
if (!string.IsNullOrEmpty(userFieldName) && dataRow[userFieldName] != null)
{
decimal.TryParse(dataRow[userFieldName].ToString().Trim(), out amount);
claim.TotalExpensesPaid = amount;
}
#endregion
claim = ClaimsManager.Save(claim);
return(claim);
}
static public void loadFieldValues(Claim claim)
{
Leads lead = claim.LeadPolicy.Leads;
LeadPolicy policy = claim.LeadPolicy;
Carrier carrier = policy.Carrier;
Client portal = portal = lead.Client;
PolicyLienholder lienHolder = policy.PolicyLienholder as PolicyLienholder;
//PolicyLienholder lienHolder = policy.PolicyLienholder as PolicyLienholder;
List <vw_ClaimLimit> limits = null;
limits = ClaimLimitManager.GetAll(claim.ClaimID, LimitType.LIMIT_TYPE_PROPERTY);
if (limits != null && limits.Count == 0)
{
limits = primePropertyLimits();
}
List <vw_ClaimLimit> limitsCasuality = ClaimLimitManager.GetAll(claim.ClaimID, LimitType.LIMIT_TYPE_CASUALTY);
if (limitsCasuality != null && limitsCasuality.Count == 0)
{
limitsCasuality = primeCasualtyLimits();
}
//decimal p= limits[0].Depreciation??0;
string policy_number = null;
string claim_number = null;
string insurance_company = null;
string insurance_address = null;
string insurance_address2 = null;
string insurance_city = null;
string insurance_state = null;
string insurance_zipcode = null;
string insurance_phone_number = null;
decimal recovDepreA = 0;
decimal recovDepreB = 0;
decimal recovDepreC = 0;
decimal recovDepreTotal = 0;
decimal nonRecovDepreA = 0;
decimal nonRecovDepreB = 0;
decimal nonRecovDepreC = 0;
decimal nonRecovDepreTotal = 0;
decimal deductibleA = 0;
decimal deductibleB = 0;
decimal deductibleC = 0;
decimal deductibleTotal = 0;
decimal limitA = 0;
decimal limitB = 0;
decimal limitC = 0;
decimal limitD = 0;
decimal limitE = 0;
decimal limitF = 0;
decimal lossAmountRCVA = 0;
decimal lossAmountRCVB = 0;
decimal lossAmountRCVC = 0;
decimal lossAmountRCVD = 0;
decimal totalLossAmountRCVAThruD = 0;
decimal lossAmountACVA = 0;
decimal lossAmountACVB = 0;
decimal lossAmountACVC = 0;
decimal lossAmountACVD = 0;
decimal lossAmountACVE = 0;
decimal lossAmountACVF = 0;
decimal totalLossAmountACVAThruD = 0;
decimal totalLossAmountACVEThruF = 0;
CityMaster cityMaster = null;
StateMaster stateMaster = null;
string loss_date = null;
string dateOpenReported = string.Empty;
string dateContacted = string.Empty;
string dateInspectionCompleted = string.Empty;
if (limits.Count >= 4)
{
recovDepreA = limits[0].Depreciation ?? 0;
recovDepreB = limits[1].Depreciation ?? 0;
recovDepreC = limits[2].Depreciation ?? 0;
recovDepreTotal = recovDepreA + recovDepreB + recovDepreC;
nonRecovDepreA = limits[0].NonRecoverableDepreciation ?? 0;
nonRecovDepreB = limits[1].NonRecoverableDepreciation ?? 0;
nonRecovDepreC = limits[2].NonRecoverableDepreciation ?? 0;
nonRecovDepreTotal = nonRecovDepreA + nonRecovDepreB + nonRecovDepreC;
deductibleA = limits[0].LimitDeductible ?? 0;
deductibleB = limits[1].LimitDeductible ?? 0;
deductibleC = limits[2].LimitDeductible ?? 0;
deductibleTotal = deductibleA + deductibleB + deductibleC;
limitA = limits[0].LimitAmount ?? 0;
limitB = limits[1].LimitAmount ?? 0;
limitC = limits[2].LimitAmount ?? 0;
limitD = limits[3].LimitAmount ?? 0;
lossAmountRCVA = limits[0].LossAmountRCV ?? 0;
lossAmountRCVB = limits[1].LossAmountRCV ?? 0;
lossAmountRCVC = limits[2].LossAmountRCV ?? 0;
lossAmountRCVD = limits[3].LossAmountRCV ?? 0;
totalLossAmountRCVAThruD = lossAmountRCVA + lossAmountRCVB + lossAmountRCVC + lossAmountRCVD;
lossAmountACVA = limits[0].LossAmountACV ?? 0;
lossAmountACVB = limits[1].LossAmountACV ?? 0;
lossAmountACVC = limits[2].LossAmountACV ?? 0;
lossAmountACVD = limits[3].LossAmountACV ?? 0;
totalLossAmountACVAThruD = lossAmountACVA + lossAmountACVB + lossAmountACVC + lossAmountACVD;
}
if (limitsCasuality.Count >= 2)
{
limitE = limitsCasuality[0].LimitAmount ?? 0;
limitF = limitsCasuality[1].LimitAmount ?? 0;
lossAmountACVE = limitsCasuality[0].LossAmountACV ?? 0;
lossAmountACVF = limitsCasuality[1].LossAmountACV ?? 0;
totalLossAmountACVEThruF = lossAmountACVE + lossAmountACVF;
}
// policy info
policy_number = policy.PolicyNumber;
if (carrier != null)
{
insurance_company = carrier.CarrierName;
insurance_address = carrier.AddressLine1;
insurance_address2 = carrier.AddressLine2;
cityMaster = carrier.CityMaster;
insurance_city = cityMaster == null ? "" : cityMaster.CityName;
stateMaster = carrier.StateMaster;
insurance_state = stateMaster == null ? "" : stateMaster.StateName;
insurance_zipcode = carrier.ZipCode;
}
// claim info
claim_number = claim.AdjusterClaimNumber;
if (claim.LossDate != null)
{
loss_date = string.Format("{0:MM-dd-yyyy}", claim.LossDate);
}
if (claim.DateOpenedReported != null)
{
dateOpenReported = string.Format("{0:MM-dd-yyyy}", claim.DateOpenedReported);
}
if (claim.DateContacted != null)
{
dateContacted = string.Format("{0:MM-dd-yyyy}", claim.DateContacted);
}
if (claim.DateInspectionCompleted != null)
{
dateInspectionCompleted = string.Format("{0:MM-dd-yyyy}", claim.DateInspectionCompleted);
}
// remove existing fields
mergeFields.Clear();
mergeFields.Add(new mergeField("TODAYS_DATE", DateTime.Now.ToShortDateString()));
mergeFields.Add(new mergeField("CLAIMANT_FIRST_NAME", lead.ClaimantFirstName));
mergeFields.Add(new mergeField("CLAIMANT_LAST_NAME", lead.ClaimantLastName));
/////
mergeFields.Add(new mergeField("LOSS_ADDRESS", lead.LossAddress));
mergeFields.Add(new mergeField("LOSS_ADDRESS 2", lead.LossAddress2));
mergeFields.Add(new mergeField("LOSS_STATE", lead.StateName));
mergeFields.Add(new mergeField("LOSS_CITY", lead.CityName));
mergeFields.Add(new mergeField("LOSS_ZIPCODE", lead.Zip));
/////
mergeFields.Add(new mergeField("CLAIMANT_MAILING_ADDRESS", lead.MailingAddress));
mergeFields.Add(new mergeField("CLAIMANT_MAILING_STATE", lead.MailingState));
mergeFields.Add(new mergeField("CLAIMANT_MAILING_CITY", lead.MailingCity));
mergeFields.Add(new mergeField("CLAIMANT_MAILING_ZIPCODE", lead.MailingZip));
mergeFields.Add(new mergeField("CLAIMANT_PHONE_NUMBER", lead.PhoneNumber));
mergeFields.Add(new mergeField("CLAIMANT_EMAIL", lead.EmailAddress));
mergeFields.Add(new mergeField("POLICY_NO", policy_number));
mergeFields.Add(new mergeField("CLAIM_NUMBER", claim_number));
mergeFields.Add(new mergeField("INSURANCE_CO", insurance_company));
mergeFields.Add(new mergeField("INSURANCE_ADDRESS", insurance_address));
mergeFields.Add(new mergeField("INSURANCE_ADDRESS2", insurance_address2));
mergeFields.Add(new mergeField("INSURANCE_CITY", insurance_city));
mergeFields.Add(new mergeField("INSURANCE_STATE", insurance_state));
mergeFields.Add(new mergeField("INSURANCE_ZIPCODE", insurance_zipcode));
mergeFields.Add(new mergeField("INSURANCE_PHONE", insurance_phone_number));
mergeFields.Add(new mergeField("HOMEOWNER_POLICY_NO", policy_number));
mergeFields.Add(new mergeField("COMMERCIAL_POLICY_NO", policy_number));
mergeFields.Add(new mergeField("FLOOD_POLICY_NO", policy_number));
mergeFields.Add(new mergeField("EARTHQUAKE_POLICY_NO", policy_number));
mergeFields.Add(new mergeField("HOMEOWNER_CLAIM_NUMBER", claim_number));
mergeFields.Add(new mergeField("COMMERCIAL_CLAIM_NUMBER", claim_number));
mergeFields.Add(new mergeField("FLOOD_CLAIM_NUMBER", claim_number));
mergeFields.Add(new mergeField("EARTHQUAKE_CLAIM_NUMBER", claim_number));
mergeFields.Add(new mergeField("HOMEOWNER_INSURANCE_CO", insurance_company));
mergeFields.Add(new mergeField("HOMEONWER_INSURANCE_ADDRESS", insurance_address));
mergeFields.Add(new mergeField("HOMEONWER_INSURANCE_ADDRESS2", insurance_address2));
mergeFields.Add(new mergeField("HOMEONWER_INSURANCE_CITY", insurance_city));
mergeFields.Add(new mergeField("HOMEONWER_INSURANCE_STATE", insurance_state));
mergeFields.Add(new mergeField("HOMEONWER_INSURANCE_ZIPCODE", insurance_zipcode));
mergeFields.Add(new mergeField("HOMEONWER_INSURANCE_PHONE", insurance_phone_number));
mergeFields.Add(new mergeField("COMMERCIAL_INSURANCE_CO", insurance_company));
mergeFields.Add(new mergeField("COMMERCIAL_INSURANCE_ADDRESS", insurance_address));
mergeFields.Add(new mergeField("COMMERCIAL_INSURANCE_CITY", insurance_city));
mergeFields.Add(new mergeField("COMMERCIAL_INSURANCE_STATE", insurance_state));
mergeFields.Add(new mergeField("COMMERCIAL_INSURANCE_ZIPCODE", insurance_zipcode));
mergeFields.Add(new mergeField("COMMERCIAL_INSURANCE_PHONE", insurance_phone_number));
mergeFields.Add(new mergeField("FLOOD_INSURANCE_CO", insurance_company));
mergeFields.Add(new mergeField("FLOOD_INSURANCE_ADDRESS", insurance_address));
mergeFields.Add(new mergeField("FLOOD_INSURANCE_CITY", insurance_city));
mergeFields.Add(new mergeField("FLOOD_INSURANCE_STATE", insurance_state));
mergeFields.Add(new mergeField("FLOOD_INSURANCE_ZIPCODE", insurance_zipcode));
mergeFields.Add(new mergeField("FLOOD_INSURANCE_PHONE", insurance_phone_number));
mergeFields.Add(new mergeField("EARTHQUAKE_INSURANCE_CO", insurance_company));
mergeFields.Add(new mergeField("EARTHQUAKE_INSURANCE_ADDRESS", insurance_address));
mergeFields.Add(new mergeField("EARTHQUAKE_INSURANCE_CITY", insurance_city));
mergeFields.Add(new mergeField("EARTHQUAKE_INSURANCE_STATE", insurance_state));
mergeFields.Add(new mergeField("EARTHQUAKE_INSURANCE_ZIPCODE", insurance_zipcode));
mergeFields.Add(new mergeField("EARTHQUAKE_INSURANCE_PHONE", insurance_phone_number));
mergeFields.Add(new mergeField("LOSS_DATE", loss_date));
if (!string.IsNullOrEmpty(claim.CauseOfLoss))
{
string[] causeOfLossDescriptions = TypeofDamageManager.GetDescriptions(claim.CauseOfLoss);
mergeFields.Add(new mergeField("DAMAGE_CAUSE", string.Join(",", causeOfLossDescriptions)));
}
if (portal != null)
{
mergeFields.Add(new mergeField("OFFICE_NAME", portal.BusinessName));
mergeFields.Add(new mergeField("FEDERAL_ID_NO", portal.FederalIDNo));
mergeFields.Add(new mergeField("OFFICE_ADDRESS", portal.StreetAddress1 ?? "" + " " + lead.Client.StreetAddress2 ?? ""));
mergeFields.Add(new mergeField("OFFICE_CITY", portal.CityMaster == null ? "" : lead.Client.CityMaster.CityName));
mergeFields.Add(new mergeField("OFFICE_STATE", portal.StateMaster == null ? "" : lead.Client.StateMaster.StateName));
if (portal.ZipCode != null)
{
mergeFields.Add(new mergeField("OFFICE_ZIPCODE", getZipCode(portal.ZipCode)));
}
}
///// ADD BY CHETU TEAM
mergeFields.Add(new mergeField("INSURED_NAME", lead.InsuredName));
mergeFields.Add(new mergeField("INSURER_CLAIM_NUMBER", claim.InsurerClaimNumber));
mergeFields.Add(new mergeField("ESTIMATOR_NAME", claim.AdjusterMaster.AdjusterName));
mergeFields.Add(new mergeField("ESTIMATOR_CELL_PHONE", claim.AdjusterMaster.PhoneNumber));
mergeFields.Add(new mergeField("ESTIMATOR_EMAIL", claim.AdjusterMaster.email));
mergeFields.Add(new mergeField("TYPE_OF_LOSS", claim.TypeofLoss));
string carrierExaminer = ClaimsManager.GetContactByContactID(claim.ManagerID ?? 0);
mergeFields.Add(new mergeField("CARRIER_EXAMINER", carrierExaminer));
mergeFields.Add(new mergeField("RECOVERABLEDEPRECIATION", Convert.ToString(claim.Depreciation)));
mergeFields.Add(new mergeField("NONRECOVERABLEDEPRECIATION", Convert.ToString(claim.NonRecoverableDepreciation)));
mergeFields.Add(new mergeField("MORTGAGEENAME", Convert.ToString(lienHolder.Mortgagee.MortageeName)));
mergeFields.Add(new mergeField("LOANNUMBER", Convert.ToString(lienHolder.LoanNumber)));
/////////////
mergeFields.Add(new mergeField("RECOVERABLEDEPRECIATION_A", Convert.ToString(recovDepreA)));
mergeFields.Add(new mergeField("RECOVERABLEDEPRECIATION_B", Convert.ToString(recovDepreB)));
mergeFields.Add(new mergeField("RECOVERABLEDEPRECIATION_C", Convert.ToString(recovDepreC)));
mergeFields.Add(new mergeField("RECOVERABLEDEPRECIATION_TOTAL", Convert.ToString(recovDepreTotal)));
mergeFields.Add(new mergeField("NONRECOVERABLEDEPRECIATION_A", Convert.ToString(nonRecovDepreA)));
mergeFields.Add(new mergeField("NONRECOVERABLEDEPRECIATION_B", Convert.ToString(nonRecovDepreB)));
mergeFields.Add(new mergeField("NONRECOVERABLEDEPRECIATION_C", Convert.ToString(nonRecovDepreC)));
mergeFields.Add(new mergeField("NONRECOVERABLEDEPRECIATION_Total", Convert.ToString(nonRecovDepreTotal)));
mergeFields.Add(new mergeField("DEDUCTIBLE_A", Convert.ToString(deductibleA)));
mergeFields.Add(new mergeField("DEDUCTIBLE_B", Convert.ToString(deductibleB)));
mergeFields.Add(new mergeField("DEDUCTIBLE_C", Convert.ToString(deductibleC)));
mergeFields.Add(new mergeField("DEDUCTIBLE_Total", Convert.ToString(deductibleTotal)));
mergeFields.Add(new mergeField("LIMIT_A", Convert.ToString(limitA)));
mergeFields.Add(new mergeField("LIMIT_B", Convert.ToString(limitB)));
mergeFields.Add(new mergeField("LIMIT_C", Convert.ToString(limitC)));
mergeFields.Add(new mergeField("LIMIT_D", Convert.ToString(limitD)));
mergeFields.Add(new mergeField("LOSSAMOUNT_RCV_A", Convert.ToString(lossAmountRCVA)));
mergeFields.Add(new mergeField("LOSSAMOUNT_RCV_B", Convert.ToString(lossAmountRCVB)));
mergeFields.Add(new mergeField("LOSSAMOUNT_RCV_C", Convert.ToString(lossAmountRCVC)));
mergeFields.Add(new mergeField("LOSSAMOUNT_RCV_D", Convert.ToString(lossAmountRCVD)));
mergeFields.Add(new mergeField("TOTAL_LOSS_AMOUNT_A_THRU_DRCV", Convert.ToString(totalLossAmountRCVAThruD)));
mergeFields.Add(new mergeField("LOSSAMOUNT_ACV_A", Convert.ToString(lossAmountACVA)));
mergeFields.Add(new mergeField("LOSSAMOUNT_ACV_B", Convert.ToString(lossAmountACVB)));
mergeFields.Add(new mergeField("LOSSAMOUNT_ACV_C", Convert.ToString(lossAmountACVC)));
mergeFields.Add(new mergeField("LOSSAMOUNT_ACV_D", Convert.ToString(lossAmountACVD)));
mergeFields.Add(new mergeField("TOTAL_LOSS_AMOUNT_A_THRU_DACV", Convert.ToString(totalLossAmountACVAThruD)));
mergeFields.Add(new mergeField("LOSSAMOUNT_ACV_E", Convert.ToString(lossAmountACVE)));
mergeFields.Add(new mergeField("LOSSAMOUNT_ACV_F", Convert.ToString(lossAmountACVF)));
mergeFields.Add(new mergeField("TOTAL_LOSS_AMOUNT_E_THRU_FACV", Convert.ToString(totalLossAmountACVAThruD)));
mergeFields.Add(new mergeField("DATEOPEN_REPORTED", dateOpenReported));
mergeFields.Add(new mergeField("DATE_CONTACTED", dateContacted));
mergeFields.Add(new mergeField("DATE_INSPECTION_COMPLETED", dateInspectionCompleted));
mergeFields.Add(new mergeField("EFFECTIVE_DATE", ""));
mergeFields.Add(new mergeField("EXPIRY_DATE", ""));
// build field name arrays
fieldNames = mergeFields.Select(x => x.fieldName).ToArray();
// build field value arrays
fieldValues = mergeFields.Select(x => x.fieldValue).ToArray();
}
static protected void exportDemographics(Leads lead, Claim claim)
{
Stream imageStream = null;
string cityName = null;
string stateName = null;
string zipCode = null;
string[] damageType = null;
string imagePath = null;
if (lead == null)
{
return;
}
PdfPTable tblHeader = new PdfPTable(new float[] { 30, 60 });
tblHeader.WidthPercentage = 90;
PdfPCell headerCell = new PdfPCell(new Phrase("Policyholder Information"));
headerCell.Colspan = 2;
headerCell.HorizontalAlignment = PdfPCell.ALIGN_CENTER;
tblHeader.AddCell(headerCell);
doc.Add(tblHeader);
PdfPTable ptable = new PdfPTable(new float[] { 30, 60 });
addTableCell(ptable, "Insured Name");
addTableCell(ptable, lead.InsuredName);
addTableCell(ptable, "First Name");
addTableCell(ptable, lead.ClaimantFirstName);
addTableCell(ptable, "Last Name");
addTableCell(ptable, lead.ClaimantLastName);
addTableCell(ptable, "Business Name");
addTableCell(ptable, lead.BusinessName);
addTableCell(ptable, "Phone");
addTableCell(ptable, lead.PhoneNumber);
addTableCell(ptable, " ");
addTableCell(ptable, lead.SecondaryPhone);
addTableCell(ptable, "Email");
addTableCell(ptable, lead.EmailAddress);
addTableCell(ptable, " ");
addTableCell(ptable, lead.SecondaryEmail);
addTableCell(ptable, "Loss Address");
addTableCell(ptable, lead.LossAddress);
addTableCell(ptable, " ");
addTableCell(ptable, lead.LossAddress2);
cityName = lead.CityName ?? " ";
stateName = lead.StateName ?? " ";
zipCode = lead.Zip ?? " ";
addTableCell(ptable, " ");
addTableCell(ptable, cityName + ", " + stateName + " " + zipCode);
addTableCell(ptable, "Type of Loss");
if (!string.IsNullOrEmpty(claim.CauseOfLoss))
{
string[] causeOfLossDescriptions = TypeofDamageManager.GetDescriptions(claim.CauseOfLoss);
string typeOfLoss = string.Join(",", causeOfLossDescriptions);
addTableCell(ptable, typeOfLoss);
}
//addTableCell(ptable, "Lead Source");
//addTableCell(ptable, lead.LeadSourceMaster == null ? " " : lead.LeadSourceMaster.LeadSourceName);
doc.Add(ptable);
//if (lead.Latitude != null && lead.Longitude != null) {
// imageStream = bingMapHelper.getMapImage(lead.Latitude, lead.Longitude);
// // add areal map to pdf
// if (imageStream != null) {
// Image img = iTextSharp.text.Image.GetInstance(imageStream);
// PdfPTable maptable = new PdfPTable(new float[] { 90 });
// maptable.WidthPercentage = 90;
// PdfPCell filler = new PdfPCell(new Phrase(" "));
// filler.Border = 0;
// maptable.AddCell(filler);
// PdfPCell imageHeader = new PdfPCell(new Phrase("Loss Map"));
// imageHeader.HorizontalAlignment = PdfPCell.ALIGN_CENTER;
// imageHeader.VerticalAlignment = PdfPCell.ALIGN_CENTER;
// //imageHeader.PaddingBottom = 10f;
// //imageHeader.PaddingTop = 10f;
// maptable.AddCell(imageHeader);
// img.ScaleToFit(500f, 400f);
// PdfPCell cellp = new PdfPCell(img, false);
// cellp.HorizontalAlignment = PdfPCell.ALIGN_MIDDLE;
// cellp.VerticalAlignment = PdfPCell.ALIGN_TOP;
// cellp.Padding = 2f;
// //cellp.PaddingBottom = 2;
// //cellp.PaddingRight = 2;
// cellp.BorderWidthLeft = 1f;
// cellp.BorderWidthRight = 1f;
// cellp.BorderWidthTop = 1f;
// cellp.BorderWidthBottom = 1f;
// maptable.AddCell(cellp);
// doc.Add(maptable);
// }
//}
}
