protected void btnSearch_Click(object sender, EventArgs e)
{
Expression <Func <Claim, bool> > predicate = null;
List <AdjusterView> adjusters = null;
List <LeadView> leads = null;
predicate = buildPredicate();
using (ClaimManager repository = new ClaimManager()) {
leads = repository.Search(predicate).orderBy("ClaimantLastName").ToList();
}
gvSearchResult.DataSource = leads;
gvSearchResult.DataBind();
if (leads != null && leads.Count > 0)
{
pnlResult.Visible = true;
pnlToolbar.Visible = true;
// load adjusters
adjusters = AdjusterManager.GetClaimAssigned(clientID);
gvAdjusters.DataSource = adjusters;
gvAdjusters.DataBind();
CollectionManager.FillCollection(ddlAdjuster, "AdjusterID", "AdjusterName", adjusters);
}
}
private void bindAdjusters()
{
string streetAddress = null;
string stateName = null;
string handleClaimsType = null;
string[] policyTypes = null;
List <AdjusterMaster> adjusters = AdjusterManager.GetAll(clientID).ToList();
if (adjusters != null && adjusters.Count > 0)
{
hf_adjusters.Value = string.Empty;
foreach (AdjusterMaster adjuster in adjusters)
{
if (adjuster.UseDeploymentAddress ?? false)
{
stateName = adjuster.StateMaster == null ? "" : adjuster.StateMaster.StateName;
streetAddress = string.Format("{0} {1} {2} {3}", adjuster.DeploymentAddress ?? "", adjuster.DeploymentCity ?? "", stateName ?? "", adjuster.DeploymentZipCode ?? "");
}
else
{
stateName = adjuster.StateMaster == null ? "" : adjuster.StateMaster.StateName;
streetAddress = string.Format("{0} {1} {2} {3}", adjuster.Address1 ?? "", adjuster.CityName, stateName ?? "", adjuster.ZipCode ?? "");
}
if (!string.IsNullOrEmpty(streetAddress.Trim()))
{
try {
geoResponse response = Core.bingMapHelper.geocodeAddress(streetAddress);
if (response.status == "ok")
{
if (adjuster.AdjusterHandleClaimType != null)
{
policyTypes = null;
handleClaimsType = null;
policyTypes = (from x in adjuster.AdjusterHandleClaimType
select x.LeadPolicyType.Description
).ToArray();
if (policyTypes != null && policyTypes.Length > 0)
{
handleClaimsType = string.Join(":", policyTypes);
}
}
hf_adjusters.Value += string.Format("{0}|{1}|{2},{3}|{4}$",
adjuster.AdjusterName, streetAddress, response.latitude, response.longitude, handleClaimsType ?? "");
}
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
}
}
}
}
protected void gv_onSorting(object sender, GridViewSortEventArgs e)
{
IQueryable <AdjusterMaster> adjusters = null;
adjusters = AdjusterManager.GetAll(clientID);
List <AdjusterMaster> objListAdjuster = adjusters.ToList();
bool descending = false;
if (ViewState[e.SortExpression] == null)
{
descending = false;
}
else
{
descending = !(bool)ViewState[e.SortExpression];
}
ViewState[e.SortExpression] = descending;
string sortClause = e.SortExpression + (descending ? " Desc " : " Asc ");
gvAdjuster.DataSource = objListAdjuster.sort(sortClause).ToList();
//gvAdjuster.DataSource = adjusters.orderByExtension(e.SortExpression, descending);
gvAdjuster.DataBind();
}
protected void gvAdjuster_RowCommand(object sender, GridViewCommandEventArgs e)
{
int adjusterID = 0;
string encryptedID = null;
if (e.CommandName == "DoEdit")
{
encryptedID = Core.SecurityManager.EncryptQueryString(e.CommandArgument.ToString());
Response.Redirect("~/protected/admin/AdjusterEdit.aspx?q=" + encryptedID);
}
else if (e.CommandName == "DoDelete")
{
adjusterID = Convert.ToInt32(e.CommandArgument.ToString());
AdjusterMaster adjuster = AdjusterManager.GetAdjusterId(adjusterID);
if (adjuster != null)
{
adjuster.Status = false;
AdjusterManager.Save(adjuster);
}
}
DoBind();
}
public void bindData(BusinessRule businessRule)
{
int clientID = SessionHelper.getClientId();
IQueryable <AdjusterMaster> adjusters = null;
adjusters = AdjusterManager.GetAll(clientID);
ddlAdjuster.DataSource = adjusters.ToList();
ddlAdjuster.DataValueField = "AdjusterId";
ddlAdjuster.DataTextField = "adjusterName";
ddlAdjuster.DataBind();
ddlAdjuster.Items.Insert(0, new ListItem("--- Select ---", "0"));
//CollectionManager.FillCollection(ddlAdjuster, "AdjusterId", "adjusterName", adjusters);
ViewState["businessRuleID"] = businessRule.BusinessRuleID.ToString();
clearFields();
if (businessRule.BusinessRuleID == 0)
{
// for new rules only.
cbxActive.Checked = true;
}
else
{
// edit
XElement ruleXML = XElement.Parse(businessRule.RuleXML);
cbxActive.Checked = businessRule.IsActive;
cbxEmailAdjuster.Checked = businessRule.EmailAdjuster;
cbxEmailSupervisor.Checked = businessRule.EmailSupervisor;
txtDescription.Text = businessRule.Description;
using (RuleHelper ruleHelper = new RuleHelper()) {
XElement invoiceCondition = ruleHelper.GetElement(ruleXML, "Claim");
txtNumberOfClaims.Text = invoiceCondition.Element("value").Value;
XElement adjusterCondition = ruleHelper.GetElement(ruleXML, "AdjusterID");
ddlAdjuster.SelectedValue = adjusterCondition.Element("value").Value;
}
//.Where(x => x.Element("property").Value == "Invoice").FirstOrDefault();
}
}
public static void saveAdjusterPhoto(int adjusterID, string filePath)
{
AdjusterMaster adjuster = null;
string photoFileName = null;
string imageFolderPath = null;
string destinationFilePath = null;
// get application path
string appPath = ConfigurationManager.AppSettings["appPath"].ToString();
// get uploaded file
string tempFilePath = HttpContext.Current.Server.MapPath(String.Format("~\\Temp\\{0}", filePath));
adjuster = AdjusterManager.GetAdjusterId(adjusterID);
if (adjuster != null && File.Exists(tempFilePath))
{
try {
imageFolderPath = string.Format("{0}/Adjusters/{1}/Photo", appPath, adjuster.AdjusterId);
if (!Directory.Exists(imageFolderPath))
{
Directory.CreateDirectory(imageFolderPath);
}
photoFileName = adjuster.AdjusterId.ToString() + Path.GetExtension(filePath);
destinationFilePath = string.Format("{0}/{1}", imageFolderPath, photoFileName);
System.IO.File.Copy(tempFilePath, destinationFilePath, true);
// delete temp file
File.Delete(tempFilePath);
adjuster.PhotoFileName = photoFileName;
AdjusterManager.Save(adjuster);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
}
}
private void notifyAdjuster(CRM.Data.Entities.LeadPolicy policy)
{
AdjusterMaster adjuster = null;
string clientName = null;
string claimantName = null;
string emailText = null;
string emailPassword = null;
Leads lead = null;
int leadID = 0;
string[] recipients = null;
string userEmail = null;
string subject = null;
// get adjuster info
adjuster = AdjusterManager.Get(policy.AdjusterID ?? 0);
// retreive lead information
leadID = SessionHelper.getLeadId();
lead = LeadsManager.GetByLeadId(leadID);
if (lead != null && adjuster != null && !string.IsNullOrEmpty(adjuster.email) && (adjuster.isEmailNotification ?? true))
{
recipients = new string[] { adjuster.email };
userEmail = ConfigurationManager.AppSettings["userID"].ToString();
emailPassword = ConfigurationManager.AppSettings["Password"].ToString();
// name of CRM client
clientName = adjuster.Client == null ? "" : adjuster.Client.BusinessName;
claimantName = string.Format("{0} {1}", lead.ClaimantFirstName ?? "", lead.ClaimantLastName ?? "");
subject = string.Format("{0} has assigned {1} to you.", clientName, claimantName);
emailText = string.Format("<br>Claim # {0} was assigned to you.<br>Please review {1} right away to begin the file.<br><br>Thank you.<br><br>http://app.claimruler.com",
policy.ClaimNumber,
claimantName);
Core.EmailHelper.sendEmail(adjuster.email, recipients, null, subject, emailText, null, userEmail, emailPassword);
}
}
protected void btnAssign_Click(object sender, EventArgs e)
{
int adjusterID = 0;
Claim claim = null;
int claimID = 0;
AdjusterMaster adjuster = null;
StringBuilder claimList = new StringBuilder();
if (int.TryParse(ddlAdjuster.SelectedValue, out adjusterID) && adjusterID > 0)
{
adjuster = AdjusterManager.GetAdjusterId(adjusterID);
foreach (GridViewRow row in gvSearchResult.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
CheckBox cbxSelected = row.FindControl("cbxSelected") as CheckBox;
if (cbxSelected.Checked)
{
claimID = (int)gvSearchResult.DataKeys[row.RowIndex].Value;
claim = ClaimsManager.GetByID(claimID);
if (claim != null)
{
claim.AdjusterID = adjusterID;
ClaimsManager.Save(claim);
HyperLink lnkLead = row.FindControl("hlnkLead") as HyperLink;
claimList.Append(string.Format("<tr align=\"center\"><td>{0}</td><td>{1}</td><td>{2}</td></tr>",
lnkLead.Text, claim.AdjusterClaimNumber ?? "", claim.InsurerClaimNumber ?? ""));
}
}
}
} // foreach
notifyAdjuster(adjuster, claimList);
btnSearch_Click(null, null);
}
}
private void DoBind()
{
IQueryable <AdjusterMaster> adjusters = null;
adjusters = AdjusterManager.GetAll(clientID);
gvAdjuster.DataSource = adjusters.ToList();
gvAdjuster.DataBind();
List <StateMaster> states = State.GetAll();
ddlState.DataSource = states;
ddlState.DataBind();
CollectionManager.FillCollection(ddlState, "StateId", "StateName", states);
CollectionManager.FillCollection(ddlServiceStateLicense, "StateId", "StateName", states);
CollectionManager.FillCollection(ddlTypeClaimHandled, "LeadPolicyTypeID", "Description", LeadPolicyTypeManager.GetAll());
}
public void bindData(int businessRuleID)
{
int clientID = SessionHelper.getClientId();
IQueryable <AdjusterMaster> adjusters = null;
adjusters = AdjusterManager.GetAll(clientID);
CollectionManager.FillCollection(ddlAdjuster, "AdjusterId", "adjusterName", adjusters);
ViewState["businessRuleID"] = businessRuleID.ToString();
if (businessRuleID == 0)
{
// for new rules only.
cbxActive.Checked = true;
}
else
{
}
}
private void bindData()
{
// 2014-05-12 tortega
// get client data
int clientID = Core.SessionHelper.getClientId();
List <AdjusterMaster> adjusters = null;
// load adjusters branch with code
List <AdjusterSettingsPayroll> adjusterSettingsPayrolls = new List <AdjusterSettingsPayroll>();
adjusterSettingsPayrolls = AdjusterManager.GetGetAllAdjusterPayrollSetting(clientID).GroupBy(x => x.AdjusterBranch).Select(g => g.FirstOrDefault()).ToList();
// bind adjusters branch and code to DDL
// CollectionManager.FillCollection(ddlBranch, "BranchCode", "AdjusterBranch", adjusterSettingsPayrolls);
// ddlBranch.Items.Insert(0, new ListItem("**All Branches**", "0"));
// load adjusters for client
//adjusters = AdjusterManager.GetAll(clientID).ToList();
//// bind adjusters to DDL
//CollectionManager.FillCollection(ddlAdjusters, "AdjusterId", "AdjusterName", adjusters);
}
protected void btnSaveExpense_Click(object sender, EventArgs e)
{
Claim claim = null;
Claim myClaim = null;
ClaimExpense claimExpense = null;
AdjusterMaster adjuster = null;
CarrierInvoiceProfile CarrierInvoice = null;
int clientID = SessionHelper.getClientId();
int userID = SessionHelper.getUserId();
int claimID = SessionHelper.getClaimID();
int myAdjusterID = 0;
int profileID = 0;
int expenseTypeID = 0;
int id = 0;
Page.Validate("expense");
if (!Page.IsValid)
{
return;
}
id = Convert.ToInt32(ViewState["ClaimExpenseID"]);
ClaimManager cm = new ClaimManager();
myClaim = cm.Get(claimID);
try
{
expenseTypeID = Convert.ToInt32(ddlExpenseType.SelectedValue);
using (TransactionScope scope = new TransactionScope())
{
using (ClaimExpenseManager repository = new ClaimExpenseManager())
{
if (id == 0)
{
claimExpense = new ClaimExpense();
claimExpense.ClaimID = claimID;
}
else
{
claimExpense = repository.Get(id);
}
// populate fields
if (txtExpenseAmount.Visible == false)
{
var x = Session["multiplier"].ToString();
double expenseAmount = Convert.ToDouble(x) * Convert.ToDouble(txtExpenseQty.ValueDecimal); //newOC 10/7/14
claimExpense.ExpenseAmount = Convert.ToDecimal(expenseAmount);
decimal d = Convert.ToDecimal(expenseAmount);
//Session["EmailAmount"] = "$" + Math.Round(d, 2);
Session["EmailAmount"] = String.Format("{0:0.00}", expenseAmount);
// Session["EmailAmount"] = expenseAmount;
}
else
{
claimExpense.ExpenseAmount = txtExpenseAmount.ValueDecimal;
}
claimExpense.ExpenseDate = txtExpenseDate.Date;
claimExpense.ExpenseDescription = txtExpenseDescription.Text.Trim();
claimExpense.ExpenseTypeID = expenseTypeID;
claimExpense.IsReimbursable = cbxExpenseReimburse.Checked;
claimExpense.UserID = userID;
claimExpense.AdjusterID = Convert.ToInt32(hf_expenseAdjusterID.Value);
claimExpense.ExpenseQty = txtExpenseQty.ValueDecimal;
claimExpense.InternalComments = txtMyComments.Text.Trim();
claimExpense.Billed = false;
// claimExpense.IsBillable = cbIsBillable.Checked;
// save expense
claimExpense = repository.Save(claimExpense);
}
// update diary entry
ClaimComment diary = new ClaimComment();
diary.ClaimID = claimID;
diary.CommentDate = DateTime.Now;
diary.UserId = userID;
diary.CommentText = string.Format("Expense: {0}, Description: {1}, Date: {2:MM/dd/yyyy}, Amount: {3:N2}, Adjuster: {4} Qty: {5:N2}",
ddlExpenseType.SelectedItem.Text,
claimExpense.ExpenseDescription,
claimExpense.ExpenseDate,
claimExpense.ExpenseAmount,
txtExpenseAdjuster.Text,
claimExpense.ExpenseQty
);
ClaimCommentManager.Save(diary);
// 2014-05-02 apply rule
using (SpecificExpenseTypePerCarrier ruleEngine = new SpecificExpenseTypePerCarrier())
{
claim = new Claim();
claim.ClaimID = claimID;
RuleException ruleException = ruleEngine.TestRule(clientID, claim, expenseTypeID);
if (ruleException != null)
{
ruleException.UserID = Core.SessionHelper.getUserId();
ruleEngine.AddException(ruleException);
CheckSendMail(ruleException);
}
}
myAdjusterID = Convert.ToInt32(claimExpense.AdjusterID); //Convert.ToInt32(myClaim.AdjusterID);
//EMAIL ADJUSTER OC 10/22/2014
if (myAdjusterID != 0 || myAdjusterID != null)
{
adjuster = AdjusterManager.GetAdjusterId(myAdjusterID);
}
if (cbEmailAdjuster.Checked == true)
{
try
{
notifyAdjuster(adjuster, claimExpense, myClaim);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to send email to adjuster";
lblMessage.CssClass = "error";
}
}
//EMAIL CLIENT CONTACT OC 10/22/2014
if (cbEmailClient.Checked == true) //Dont need to check if invoice Pro ID is empty becuase to get to this point, one has to exist already
{
if (Session["ComingFromAllClaims"] != null) //if the user got here straight from the all claims screen
{
profileID = Convert.ToInt32(Session["CarrierInvoiceID"]);
}
else//coming from claim detail page
{
profileID = Convert.ToInt32(Session["InvoiceProfileID"]);
}
CarrierInvoice = CarrierInvoiceProfileManager.Get(profileID);
try
{
notifyClientContact(CarrierInvoice, claimExpense, myClaim, adjuster);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to send email to client contact";
lblMessage.CssClass = "error";
}
}
//EMAIL TO WHOMEVER OC 10/22/2014
if (txtEmailTo.Text != "")
{
try
{
notifySpecifiedUser(adjuster, claimExpense, myClaim);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to send email to adjuster";
lblMessage.CssClass = "error";
}
}
// complete transaction
scope.Complete();
}
lblMessage.Text = "Expense saved successfully.";
lblMessage.CssClass = "ok";
// refresh grid
gvExpense.DataSource = loadExpenses(claimID);
gvExpense.DataBind();
// keep edit form active
lbtnNewExpense_Click(null, null);
lblAmount.Text = "";
lblAmount.Visible = false;
txtExpenseAmount.Visible = true;
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
lblMessage.Text = "Unable to save claim expense.";
lblMessage.CssClass = "error";
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
int policyTypeID = 0;
int stateID = 0;
int yearExperience = 0;
Expression <Func <AdjusterMaster, bool> > predicate = PredicateBuilder.True <CRM.Data.Entities.AdjusterMaster>();
predicate = predicate.And(x => x.ClientId == clientID);
if (!string.IsNullOrEmpty(txtName.Text))
{
predicate = predicate.And(x => x.FirstName.Contains(txtName.Text) || x.LastName.Contains(txtName.Text));
}
if (!string.IsNullOrEmpty(txtCompanyName.Text))
{
predicate = predicate.And(x => x.CompanyName.Contains(txtCompanyName.Text));
}
if (!string.IsNullOrEmpty(txtStreetAddress.Text))
{
predicate = predicate.And(x => x.Address1.Contains(txtStreetAddress.Text) || x.Address2.Contains(txtStreetAddress.Text));
}
// filter: state
if (ddlState.SelectedIndex > 0)
{
stateID = Convert.ToInt32(ddlState.SelectedValue);
predicate = predicate.And(x => x.StateID == stateID);
}
// filter: city name
if (!string.IsNullOrEmpty(txtCity.Text))
{
predicate = predicate.And(x => x.CityName.Contains(txtCity.Text));
}
// filter: zip code
if (!string.IsNullOrEmpty(txtZipCode.Text))
{
predicate = predicate.And(x => x.ZipCode == txtZipCode.Text);
}
// filter: status
if (ddlStatus.SelectedIndex > 0)
{
predicate = predicate.And(x => x.Status == ddlStatus.SelectedValue.Equals("1"));
}
// filter: credentials
if (!string.IsNullOrEmpty(txtCredentials.Text))
{
predicate = predicate.And(x => x.Certifications.Contains(txtCredentials.Text));
}
// filter: federal tax id
if (!string.IsNullOrEmpty(txtFEIN.Text))
{
predicate = predicate.And(x => x.FederalTaxID.Contains(txtFEIN.Text));
}
// filter: year experience
if (int.TryParse(txtYearExperience.Text, out yearExperience) && yearExperience > 0)
{
predicate = predicate.And(x => x.YearsExperiece == yearExperience);
}
// filter: Geographical Area of Service
if (!string.IsNullOrEmpty(txtServiceArea.Text))
{
predicate = predicate.And(x => x.GeographicalSeriveArea.Contains(txtServiceArea.Text));
}
// filter: w9
if (ddlW9.SelectedIndex > 0)
{
predicate = predicate.And(x => x.isW9 == ddlW9.SelectedValue.Equals("1"));
}
// filter: Types of Claims Handled
if (ddlTypeClaimHandled.SelectedIndex > 0)
{
policyTypeID = Convert.ToInt32(ddlTypeClaimHandled.SelectedValue);
predicate = predicate.And(x => x.AdjusterHandleClaimType.Any(a => a.PolicyTypeID == policyTypeID));
}
// State(s) of Service & Licensure per State
if (ddlServiceStateLicense.SelectedIndex > 0)
{
stateID = Convert.ToInt32(ddlServiceStateLicense.SelectedValue);
predicate = predicate.And(x => x.AdjusterServiceArea.Any(a => a.StateID == stateID));
}
gvAdjuster.DataSource = AdjusterManager.Search(predicate).ToList();
gvAdjuster.DataBind();
}
protected void btnSaveClaimService_Click(object sender, EventArgs e)
{
ClaimService claimService = null;
ClaimComment diary = null;
AdjusterMaster adjuster = null;
Claim myClaim = null;
CarrierInvoiceProfile CarrierInvoice = null;
int userID = SessionHelper.getUserId();
int claimID = SessionHelper.getClaimID();
int id = 0;
int myAdjusterID = 0;
int profileID = 0;
Page.Validate("service");
if (!Page.IsValid)
{
return;
}
id = Convert.ToInt32(ViewState["ClaimServiceID"]);
//Get current claim info to pass through to emails
ClaimManager cm = new ClaimManager();
myClaim = cm.Get(claimID);
//AdjusterManager
try {
using (TransactionScope scope = new TransactionScope())
{
using (ClaimServiceManager repository = new ClaimServiceManager())
{
if (id == 0)
{
claimService = new ClaimService();
claimService.ClaimID = claimID;
}
else
{
claimService = repository.Get(id);
}
claimService.ServiceQty = this.txtServiceQty.Value == null ? 0 : Convert.ToDecimal(txtServiceQty.Value);
claimService.ServiceDate = txtServiceDate.Date;
claimService.ServiceDescription = txtServiceDescription.Text.Trim();
claimService.ServiceTypeID = Convert.ToInt32(this.ddlInvoiceServiceType.SelectedValue);
claimService.UserID = userID;
claimService.AdjusterID = Convert.ToInt32(hf_serviceAdjusterID.Value);
claimService.Activity = ddlActivity.SelectedItem.Text;
claimService.InternalComments = txtMyComments.Text.Trim();
claimService.IsBillable = cbIsBillable.Checked;
claimService.Billed = false;
//save to db
claimService = repository.Save(claimService);
//string EmailService = ddlInvoiceServiceType.SelectedItem.Text;
//string EmailActivity = ddlActivity.SelectedItem.Text;
//string EmailDescription = txtServiceDescription.Text;
//string EmailInternal = txtMyComments.Text;
//string EmailQuantity = txtServiceQty.Text;
//string EmailDate = txtServiceDate.Text;
}
// diary
diary = new ClaimComment();
diary.ClaimID = claimID;
diary.CommentDate = DateTime.Now;
diary.UserId = userID;
diary.ActivityType = ddlActivity.SelectedItem.Text;
diary.InternalComments = txtMyComments.Text.Trim();
diary.CommentText = string.Format("Service: {0}, Description: {1}, Date {2:MM/dd/yyyy}, Qty: {3:N2}, Adjuster: {4}",
ddlInvoiceServiceType.SelectedItem.Text,
claimService.ServiceDescription,
claimService.ServiceDate,
claimService.ServiceQty,
txtServiceAdjuster.Text
);
ClaimCommentManager.Save(diary);
myAdjusterID = Convert.ToInt32(claimService.AdjusterID); //Convert.ToInt32(myClaim.AdjusterID);
//EMAIL ADJUSTER OC 10/21/2014
if (myAdjusterID != 0 || myAdjusterID != null)
{
adjuster = AdjusterManager.GetAdjusterId(myAdjusterID);
}
if (cbEmailAdjuster.Checked == true)
{
try
{
notifyAdjuster(adjuster, claimService, myClaim);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to send email to adjuster";
lblMessage.CssClass = "error";
}
}
//EMAIL CLIENT CONTACT OC 10/22/2014
if (cbEmailClient.Checked == true) //Dont need to check if invoice Pro ID is empty becuase to get to this point, one has to exist already
{
if (Session["ComingFromAllClaims"] != null) //if the user got here straight from the all claims screen
{
profileID = Convert.ToInt32(Session["CarrierInvoiceID"]);
}
else//coming from claim detail page
{
profileID = Convert.ToInt32(Session["InvoiceProfileID"]);
}
CarrierInvoice = CarrierInvoiceProfileManager.Get(profileID);
try
{
notifyClientContact(CarrierInvoice, claimService, myClaim, adjuster);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to send email to client contact";
lblMessage.CssClass = "error";
}
}
//EMAIL TO WHOMEVER
if (txtEmailTo.Text != "")
{
try
{
notifySpecifiedUser(adjuster, claimService, myClaim);
}
catch (Exception ex)
{
lblMessage.Text = "Unable to send email to adjuster";
lblMessage.CssClass = "error";
}
}
scope.Complete();
}
lblMessage.Text = "Service was saved successfully.";
lblMessage.CssClass = "ok";
// keep edit form active
lbtnNewClaimService_Click(null, null);
// refresh grid
gvClaimService.DataSource = loadClaimServices(claimID);
gvClaimService.DataBind();
}
catch (Exception ex)
{
Core.EmailHelper.emailError(ex);
lblMessage.Text = "Unable to save claim service.";
lblMessage.CssClass = "error";
}
//send email to adjuster
}
public void bindData()
{
// main binding routine
List <StatusMaster> statusMasters = null;
List <SubStatusMaster> subStatusMasters = null;
List <StateMaster> states = null;
IQueryable <AdjusterMaster> adjusters = null;
int clientID = SessionHelper.getClientId();
int leadID = Convert.ToInt32(Session["LeadIds"]);
// bind states
states = State.GetAll();
//CollectionManager.FillCollection(ddlState, "StateId", "StateName", CarrierManager.GetCarriers(clientID));
var state = CarrierManager.GetCarriers(clientID);
ddlState.DataSource = state.ToList();
ddlState.DataValueField = "StateId";
ddlState.DataTextField = "StateName";
ddlState.DataBind();
ddlState.Items.Insert(0, new ListItem("--- Select ---", "0"));
if (clientID > 0)
{
adjusters = AdjusterManager.GetAll(clientID);
statusMasters = StatusManager.GetAll(clientID);
subStatusMasters = SubStatusManager.GetAll(clientID);
}
else
{
adjusters = AdjusterManager.GetAll();
statusMasters = StatusManager.GetAll();
subStatusMasters = SubStatusManager.GetAll();
}
//CollectionManager.FillCollection(ddlCarrier, "CarrierId", "CarrierName", CarrierManager.GetCarriers(clientID));
var carrier = CarrierManager.GetCarriers(clientID);
ddlCarrier.DataSource = state.ToList();
ddlCarrier.DataValueField = "CarrierId";
ddlCarrier.DataTextField = "CarrierName";
ddlCarrier.DataBind();
ddlCarrier.Items.Insert(0, new ListItem("--- Select ---", "0"));
bindAgents();
if (this.policyID > 0)
{
// edit existing policy
tabPanelAgent.Visible = true;
tabPanelPolicyNotes.Visible = true;
fillForm();
//bindDocuments(leadID);
//bindContacts();
bindLienHolders();
//fillComments(leadID);
bindLimits();
bindSubLimits();
bindClaims();
activateLinks();
tabPanelLienHolder.Visible = true;
ShowAddCoverage();
SetAddCoverage(this.policyID);
}
else
{
// create blank one
tabPanelAgent.Visible = false;
tabPanelPolicyNotes.Visible = false;
bindLimits();
// create blank one
bindSubLimits();
tabPanelLienHolder.Visible = false;
hf_policyID.Value = "0";
hf_lastStatusID.Value = "0";
clearFields();
HideAddCoverage();
ShowAddCoverageAdd();
}
}
protected void btnUpload_Click(object sender, EventArgs e)
{
string fileExtension = null;
AdjusterMaster adjuster = null;
string firstName = null;
string lastName = null;
AdjusterServiceArea serviceArea = null;
AdjusterLicenseAppointmentType licenseAppointmentType = null;
string licenseNumber = null;
string licenseType = null;
string licenseEffectiveDate = null;
string licenseExpireDate = null;
string appointmentType = null;
StateMaster stateMaster = null;
string str = null;
lblMessage.Text = string.Empty;
if (!fileUpload.HasFile)
{
lblMessage.Text = "No file selected.";
lblMessage.CssClass = "error";
return;
}
// validate file
fileExtension = System.IO.Path.GetExtension(fileUpload.PostedFile.FileName);
if (!fileExtension.Equals(".csv", StringComparison.OrdinalIgnoreCase))
{
lblMessage.Text = "CSV file format allowed only.";
lblMessage.CssClass = "error";
return;
}
try {
//save file in temp folder
string destinationPath = Server.MapPath(string.Format("~//Temp//{0}.csv", Guid.NewGuid()));
fileUpload.SaveAs(destinationPath);
// load file for processing
//DataTable table = CSVReader.ReadCSVFile(Server.MapPath("~//Temp//" + fileUpload.FileName), true);
DataTable table = CSVHelper.ReadCSVFile(destinationPath);
using (TransactionScope scope = new TransactionScope()) {
for (int i = 0; i < table.Rows.Count; i++)
{
#region process each row
adjuster = new AdjusterMaster();
adjuster.ClientId = clientID;
adjuster.Status = true;
adjuster.InsertBy = userID;
adjuster.InsertDate = DateTime.Now;
if (table.Rows[i]["First_Name"] != string.Empty)
{
firstName = table.Rows[i]["First_Name"].ToString();
}
if (table.Rows[i]["Last_Name"] != string.Empty)
{
lastName = table.Rows[i]["Last_Name"].ToString();
}
// skip blank rows
if (string.IsNullOrEmpty(lastName) && string.IsNullOrEmpty(firstName))
{
continue;
}
adjuster.FirstName = firstName.Length < 50 ? firstName : firstName.Substring(0, 50);
adjuster.LastName = lastName.Length < 50 ? lastName : lastName.Substring(0, 50);
if (table.Rows[i]["Middle_Initial"] != string.Empty)
{
str = table.Rows[i]["Middle_Initial"].ToString();
adjuster.MiddleInitial = str.Substring(0, 1);
}
adjuster.AdjusterName = string.Format("{0} {1} {2}", firstName, adjuster.MiddleInitial ?? "", lastName);
if (table.Rows[i]["Suffix"] != string.Empty)
{
adjuster.Suffix = table.Rows[i]["Suffix"].ToString().Substring(0, 1);
}
if (table.Rows[i]["Cell_Phone_Number"] != string.Empty)
{
str = table.Rows[i]["Cell_Phone_Number"].ToString();
if (str.Length > 20)
{
adjuster.PhoneNumber = str.Substring(0, 20);
}
else
{
adjuster.PhoneNumber = str;
}
}
if (table.Rows[i]["Email"] != string.Empty)
{
str = table.Rows[i]["Email"].ToString();
adjuster.email = str.Length < 100 ? str : str.Substring(0, 100);
}
if (table.Rows[i]["Address_Line1"] != string.Empty)
{
str = table.Rows[i]["Address_Line1"].ToString();
adjuster.Address1 = str.Length < 100 ? str : str.Substring(0, 100);
}
if (table.Rows[i]["City"] != string.Empty)
{
str = table.Rows[i]["City"].ToString();
adjuster.Address1 = str.Length < 50 ? str : str.Substring(0, 50);
}
if (table.Rows[i]["State_Code"] != string.Empty)
{
str = table.Rows[i]["State_Code"].ToString();
stateMaster = State.Getstateid(str);
if (stateMaster.StateId > 0)
{
adjuster.StateID = stateMaster.StateId;
}
else
{
adjuster.StateID = null;
}
}
if (table.Rows[i]["ZIP_Code"] != string.Empty)
{
str = table.Rows[i]["ZIP_Code"].ToString();
adjuster.Address1 = str.Length < 10 ? str : str.Substring(0, 10);
}
// save adjuster
adjuster = AdjusterManager.Save(adjuster);
if (table.Rows[i]["License_Type"] != string.Empty)
{
licenseType = table.Rows[i]["License_Type"].ToString();
}
if (table.Rows[i]["License_Number"] != string.Empty)
{
licenseNumber = table.Rows[i]["License_Number"].ToString();
}
if (table.Rows[i]["License_Issue_Date"] != string.Empty)
{
licenseEffectiveDate = table.Rows[i]["License_Issue_Date"].ToString();
}
if (table.Rows[i]["License_Expires_Date"] != string.Empty)
{
licenseExpireDate = table.Rows[i]["License_Expires_Date"].ToString();
}
if (table.Rows[i]["Appointment_Type"] != string.Empty)
{
appointmentType = table.Rows[i]["Appointment_Type"].ToString();
if (!string.IsNullOrEmpty(appointmentType))
{
licenseAppointmentType = AdjusterLicenseAppointmentTypeManager.Get(appointmentType, clientID);
if (licenseAppointmentType == null)
{
licenseAppointmentType = new AdjusterLicenseAppointmentType();
licenseAppointmentType.IsActive = true;
licenseAppointmentType.LicenseAppointmentType = appointmentType;
licenseAppointmentType.ClientID = clientID;
licenseAppointmentType = AdjusterLicenseAppointmentTypeManager.Save(licenseAppointmentType);
}
}
}
if (!string.IsNullOrEmpty(licenseType) && !string.IsNullOrEmpty(licenseNumber) && !string.IsNullOrEmpty(licenseEffectiveDate) &&
!string.IsNullOrEmpty(licenseExpireDate) && !string.IsNullOrEmpty(appointmentType))
{
serviceArea = new AdjusterServiceArea();
serviceArea.AdjusterID = adjuster.AdjusterId;
serviceArea.StateID = adjuster.StateID;
serviceArea.LicenseNumber = licenseNumber.Length < 50 ? licenseNumber : licenseNumber.Substring(0, 50);
serviceArea.LicenseType = licenseType.Length < 20 ? licenseType : licenseType.Substring(0, 20);
DateTime effectiveDate = DateTime.MaxValue;
DateTime expireDate = DateTime.MaxValue;
if (DateTime.TryParse(licenseEffectiveDate, out effectiveDate))
{
serviceArea.LicenseEffectiveDate = effectiveDate;
}
if (DateTime.TryParse(licenseExpireDate, out expireDate))
{
serviceArea.LicenseExpirationDate = expireDate;
}
if (licenseAppointmentType != null)
{
serviceArea.AppointmentTypeID = licenseAppointmentType.LicenseAppointmentTypeID;
}
AdjusterStateLicenseManager.Save(serviceArea);
}
// create notes
if (table.Rows[i]["Adjuster_Status_Code"] != string.Empty)
{
string adjuster_Status_Code = table.Rows[i]["Adjuster_Status_Code"].ToString();
addNote(adjuster.AdjusterId, adjuster_Status_Code);
}
if (table.Rows[i]["Adjuster_Reason_Code"] != string.Empty)
{
string sdjuster_Reason_Code = table.Rows[i]["Adjuster_Reason_Code"].ToString();
addNote(adjuster.AdjusterId, sdjuster_Reason_Code);
}
#endregion
}
scope.Complete();
lblMessage.Text = "Import completed successfully.";
lblMessage.CssClass = "ok";
}
}
catch (Exception ex) {
lblMessage.Text = "Import not completed successfully.";
lblMessage.CssClass = "error";
Core.EmailHelper.emailError(ex);
}
}
public void bindData(int clientID)
{
CollectionManager.FillCollection(ddlAdjuster, "AdjusterId", "AdjusterName", AdjusterManager.GetAll(clientID));
}
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);
}
