public void saveLimits(int claimID)
{
int claimLimitID = 0;
int limitID = 0;
ClaimLimit limit = null;
foreach (GridViewRow row in gvLimits.Rows) {
if (row.RowType == DataControlRowType.DataRow) {
try {
WebNumericEditor txtLossAmount = row.FindControl("txtLossAmount") as WebNumericEditor;
claimLimitID = (int)gvLimits.DataKeys[row.RowIndex].Values[0];
limitID = (int)gvLimits.DataKeys[row.RowIndex].Values[1];
if (claimLimitID == 0) {
// new record
limit = new ClaimLimit();
limit.ClaimID = claimID;
limit.LimitID = limitID;
}
else
limit = ClaimLimitManager.Get(claimLimitID);
limit.LossAmountACV = txtLossAmount.Value == null ? 0 : Convert.ToDecimal(txtLossAmount.Value);
ClaimLimitManager.Save(limit);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
}
}
}
protected void btnShowLossTemplate_Click(object sender, EventArgs e)
{
//int policyId = 0;
ClaimManager objClaimManager = new ClaimManager();
int policyId = Convert.ToInt32(hdnPolicyIdDetuctible.Value);
List <Claim> lstClaim = objClaimManager.GetPolicyClaim(policyId);
using (TransactionScope scope = new TransactionScope())
{
//delete all claim from claim limit
foreach (var claim in lstClaim)
{
int claimId = claim.ClaimID;
ClaimLimitManager.IsDeleted(claimId);
}
// delete limit,claimlimit,policylimit data which enter as loss details
LimitManager.DeletePolicyLimit(policyId);
//first get all limit
List <Limit> objLimit = LimitManager.GetAllLimit(true);
foreach (var limit in objLimit)
{
//enter in
PolicyLimit objPolicyLimit = new PolicyLimit();
objPolicyLimit.PolicyID = policyId;
objPolicyLimit.LimitID = limit.LimitID;
PolicyLimitManager.Save(objPolicyLimit);
}
//code for enter in all claim in claim limit
foreach (var claim in lstClaim)
{
foreach (var limit in objLimit)
{
ClaimLimit objClaimLimit = new ClaimLimit();
objClaimLimit.ClaimID = claim.ClaimID;
objClaimLimit.LimitID = limit.LimitID;
ClaimLimitManager.Save(objClaimLimit);
}
}
scope.Complete();
}
acrossAllCoverages.Enabled = true;
coverageSpecific.Enabled = true;
txtDeductible.Enabled = true;
propertyLimits.bindData(policyId);
//casualtyLimits.bindData(policyId);
}
public static ClaimLimit Get(int id)
{
ClaimLimit limit = null;
limit = (from x in DbContextHelper.DbContext.ClaimLimit
where x.ClaimLimitID == id
select x).FirstOrDefault <ClaimLimit>();
return(limit);
}
public static ClaimLimit Save(ClaimLimit limit)
{
if (limit.ClaimLimitID == 0)
{
DbContextHelper.DbContext.Add(limit);
}
DbContextHelper.DbContext.SaveChanges();
return(limit);
}
public static ClaimLimit GetLatest2(int PolicyLimitID)//get the claimLimiID when the user enters data in the new fields and "add new" is not selected
{
ClaimLimit Claimlimits = null;
Claimlimits = (from x in DbContextHelper.DbContext.ClaimLimit
where x.PolicyLimitID == PolicyLimitID
orderby x.LimitID descending
select x
).FirstOrDefault();
return(Claimlimits);
}
public static ClaimLimit GetLatest()
{
ClaimLimit Claimlimits = null;
Claimlimits = (from x in DbContextHelper.DbContext.ClaimLimit
//where x.LimitType == limitType && x.IsStatic == true
orderby x.LimitID descending
select x
).FirstOrDefault();
return(Claimlimits);
}
public static bool IsStaticTrue(int claimId)
{
bool isTemplate = false;
ClaimLimit claimLimit = (from s in DbContextHelper.DbContext.ClaimLimit
where s.ClaimID == claimId
select s).FirstOrDefault();
if (claimLimit != null)
{
Limit Limit = (from s in DbContextHelper.DbContext.Limit
where s.LimitID == claimLimit.LimitID
select s).FirstOrDefault();
if (Limit != null)
{
isTemplate = Limit.IsStatic ?? false;
}
}
return(isTemplate);
}
public void saveLimits(int claimID)
{
int claimLimitID = 0;
int limitID = 0;
ClaimLimit limit = null;
foreach (GridViewRow row in gvLimits.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
try {
WebNumericEditor txtLossAmount = row.FindControl("txtLossAmount") as WebNumericEditor;
claimLimitID = (int)gvLimits.DataKeys[row.RowIndex].Values[0];
limitID = (int)gvLimits.DataKeys[row.RowIndex].Values[1];
if (claimLimitID == 0)
{
// new record
limit = new ClaimLimit();
limit.ClaimID = claimID;
limit.LimitID = limitID;
}
else
{
limit = ClaimLimitManager.Get(claimLimitID);
}
limit.LossAmountACV = txtLossAmount.Value == null ? 0 : Convert.ToDecimal(txtLossAmount.Value);
ClaimLimitManager.Save(limit);
}
catch (Exception ex) {
Core.EmailHelper.emailError(ex);
}
}
}
}
protected void btnShowLossTemplate_Click(object sender, EventArgs e)
{
int policyId = 0;
Claim objClaim = null;
ClaimManager objClaimManager = new ClaimManager();
int claimId = Convert.ToInt32(hf_ClaimIdForStatus.Value);
using (TransactionScope scope = new TransactionScope())
{
objClaim = objClaimManager.Get(claimID);
policyId = objClaim.PolicyID;
// delete limit,claimlimit,policylimit data which enter as loss details
LimitManager.DeleteLimit(claimId, policyId);
//ClaimLimitManager.IsDeleted(claimId);
// PolicyLimitManager.IsDeleted(policyId);
//enter claim limit and policy limit
//first get all limit
List<Limit> objLimit = LimitManager.GetAllLimit(true);
foreach (var limit in objLimit)
{
ClaimLimit objClaimLimit = new ClaimLimit();
objClaimLimit.ClaimID = claimId;
objClaimLimit.LimitID = limit.LimitID;
ClaimLimitManager.Save(objClaimLimit);
PolicyLimit objPolicyLimit = new PolicyLimit();
objPolicyLimit.PolicyID = policyId;
objPolicyLimit.LimitID = limit.LimitID;
PolicyLimitManager.Save(objPolicyLimit);
}
Data.Entities.LeadPolicy objLeadPolicy = new Data.Entities.LeadPolicy();
objLeadPolicy.Id = policyId;
objLeadPolicy.ApplyAcrossAllCoverage = false;
objLeadPolicy.ApplyDeductibleSet = false;
LeadPolicyManager.Update(objLeadPolicy);
scope.Complete();
}
//acrossAllCoverages.Enabled = true;
//coverageSpecific.Enabled = true;
txtDeductible.Enabled = true;
propertyLimits.bindData(policyID);
// casualtyLimits.bindData(claimId);
}
protected void btnShowLossTemplate_Click(object sender, EventArgs e)
{
//int policyId = 0;
ClaimManager objClaimManager = new ClaimManager();
int policyId = Convert.ToInt32(hdnPolicyIdDetuctible.Value);
List<Claim> lstClaim =objClaimManager.GetPolicyClaim(policyId);
using (TransactionScope scope = new TransactionScope())
{
//delete all claim from claim limit
foreach (var claim in lstClaim)
{
int claimId = claim.ClaimID;
ClaimLimitManager.IsDeleted(claimId);
}
// delete limit,claimlimit,policylimit data which enter as loss details
LimitManager.DeletePolicyLimit( policyId);
//first get all limit
List<Limit> objLimit = LimitManager.GetAllLimit(true);
foreach (var limit in objLimit)
{
//enter in
PolicyLimit objPolicyLimit = new PolicyLimit();
objPolicyLimit.PolicyID = policyId;
objPolicyLimit.LimitID = limit.LimitID;
PolicyLimitManager.Save(objPolicyLimit);
}
//code for enter in all claim in claim limit
foreach (var claim in lstClaim)
{
foreach (var limit in objLimit)
{
ClaimLimit objClaimLimit = new ClaimLimit();
objClaimLimit.ClaimID = claim.ClaimID;
objClaimLimit.LimitID = limit.LimitID;
ClaimLimitManager.Save(objClaimLimit);
}
}
scope.Complete();
}
acrossAllCoverages.Enabled = true;
coverageSpecific.Enabled = true;
txtDeductible.Enabled = true;
propertyLimits.bindData(policyId);
//casualtyLimits.bindData(policyId);
}
public static string SaveLossDetails(int policyID, string coverage, string type, string policyLimit, string deductible, string applyTo, string itv, string reserve, int acrossall, string catDeductible, string coInsuranceLimit)
{
string json = "";
int limitID = 0;
ClaimLimit claimLimit = null;
PolicyLimit objPolicyLimit = null;
Limit limits = null;
Limit limits2 = null;
int userID = SessionHelper.getUserId();
ClaimManager objClaimManager = new ClaimManager();
try
{
using (TransactionScope scope = new TransactionScope())
{
List<Claim> lstClaim = objClaimManager.GetPolicyClaim(policyID);
bool isTemplate = ClaimLimitManager.PolicyIsStaticTrue(policyID);
if (isTemplate)
{
PolicyLimitManager.IsDeleted(policyID);
//if coverage first time then delete all template data from all claimid
foreach (var claim in lstClaim)
{
int claimId = claim.ClaimID;
ClaimLimitManager.IsDeleted(claimId);
}
}
limits = new Limit();
limits.LimitLetter = coverage;
if (type == "Contacts" || type == "Personal Liability" || type == "Medical Payments")
{
limits.LimitType = 2;
}
else
{
limits.LimitType = 1;
}
limits.LimitDescription = type;
limits.IsStatic = false;
limits2 = LimitManager.Save(limits);
limitID = limits2.LimitID;
objPolicyLimit = new PolicyLimit();
objPolicyLimit.PolicyID = policyID;
objPolicyLimit.LimitID = limitID;
if (!string.IsNullOrEmpty(policyLimit))
{
objPolicyLimit.LimitAmount = Convert.ToDecimal(policyLimit);
}
else
{
objPolicyLimit.LimitAmount = 0;
}
if (!string.IsNullOrEmpty(deductible))
{
objPolicyLimit.LimitDeductible = Convert.ToDecimal(deductible);
}
else
{
objPolicyLimit.LimitDeductible = 0;
}
//new fields add
if (!string.IsNullOrEmpty(catDeductible))
{
objPolicyLimit.CATDeductible = catDeductible;
}
if (!string.IsNullOrEmpty(coInsuranceLimit))
{
objPolicyLimit.ConInsuranceLimit = Convert.ToDecimal(coInsuranceLimit);
}
else
{
objPolicyLimit.LimitDeductible = 0;
}
if (!string.IsNullOrEmpty(itv))
{
objPolicyLimit.ITV = Convert.ToDecimal(itv);
}
else
{
objPolicyLimit.ITV = 0;
}
if (!string.IsNullOrEmpty(reserve))
{
objPolicyLimit.Reserve = Convert.ToDecimal(reserve);
}
else
{
objPolicyLimit.Reserve = 0;
}
objPolicyLimit.IsDeleted = false;
if (acrossall == 1)
{
objPolicyLimit.ApplyAcrossAllCoverage = true;
}
else
{
objPolicyLimit.ApplyAcrossAllCoverage = false;
}
objPolicyLimit.ApplyTo = applyTo;
PolicyLimitManager.Save(objPolicyLimit);
// enter data for each claim
foreach (var claim in lstClaim)
{
claimLimit = new ClaimLimit();
claimLimit.ClaimID = claim.ClaimID;
claimLimit.LimitID = limitID;
claimLimit.LossAmountACV = 0;
claimLimit.LossAmountRCV = 0;
claimLimit.Depreciation = 0;
claimLimit.OverageAmount = 0;
claimLimit.NonRecoverableDepreciation = 0;
claimLimit.IsDeleted = false;
ClaimLimitManager.Save(claimLimit);
}
scope.Complete();
}
json = "Loss details successfully add";
}
catch (Exception ex)
{
Core.EmailHelper.emailError(ex);
}
return json;
}
