private static void UpdateEndorsementDuty(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("3.2 Update Duty of Endorsement");
Console.WriteLine("========================\n");
var query = "select f.Amount, f.ID from Agreement a inner join InsuranceApplication ia on a.InsuranceApplication_Id=ia.Id inner join InsuranceApplicationItem iai on iai.InsuranceApplication_Id=ia.Id inner join InsuranceApplicationItemFee f on f.InsuranceApplicationPackageItem_Id = iai.Id where a.referencenumber ='" + objEndModel.APENumber +
"' and InsuranceApplicationItemType_Id='213F8708-FCC2-4430-A804-A1D115F718C5' and InsuranceProductCategoryRateConfiguration_Id = 'FCCC43A8-4EEC-40C7-85C3-A2B7C58264CA'";
var reader = visConn.ExecutrQueryReader(query);
var inAppItemFeeId = String.Empty;
if (reader.Read())
{
inAppItemFeeId = reader["ID"].ToString();
}
visConn.CloseConnection();
if (inAppItemFeeId != String.Empty)
{
var updateQuery = "UPDATE InsuranceApplicationItemFee " +
"SET Amount = " + objEndModel.ExpectedPremiumForEndorsement.Duty +
" WHERE Id = '" + inAppItemFeeId + "'";
reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
//var result = reader.Read();
}
}
private static void UpdateEndorsePremium(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("3. Update InsuranceApplicationItem of Endorsement");
Console.WriteLine("========================\n");
var query = "select iai.TotalBeforeFee, iai.TotalDuty, iai.TotalAfterFee, iai.ID from Agreement a inner join InsuranceApplication ia on a.InsuranceApplication_Id=ia.Id inner join InsuranceApplicationItem iai on iai.InsuranceApplication_Id=ia.Id where a.referencenumber = '" + objEndModel.APENumber + "' and InsuranceApplicationItemType_Id='213F8708-FCC2-4430-A804-A1D115F718C5'";
var reader = visConn.ExecutrQueryReader(query);
var inAppItemId = String.Empty;
if (reader.Read())
{
objEndModel.InitialPremium(objEndModel.ActualPremiumForEndorsement,
reader["TotalBeforeFee"].ToString(),
reader["TotalDuty"].ToString(),
reader["TotalAfterFee"].ToString());
inAppItemId = reader["ID"].ToString();
PrintPremiumDetail(objEndModel.ActualPremiumForEndorsement);
}
visConn.CloseConnection();
if (inAppItemId != String.Empty)
{
UpdateInAppItem(visConn, objEndModel.ExpectedPremiumForEndorsement, inAppItemId);
}
}
private static void CalculatePolicyPremium(EndorseModel objEndModel)
{
objEndModel.ExpectedPremiumForPolicy.PremiumBeforeFee =
(objEndModel.PreviousPolicyPremiumBeforeFee + objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee.ToDecimal()).ToString();
objEndModel.ExpectedPremiumForPolicy.Duty =
(objEndModel.PreviousPolicyDuty + objEndModel.ExpectedPremiumForEndorsement.Duty.ToDecimal()).ToString();
objEndModel.ExpectedPremiumForPolicy.PremiumAfterFee =
(objEndModel.ExpectedPremiumForPolicy.PremiumBeforeFee.ToDecimal() + objEndModel.ExpectedPremiumForPolicy.Duty.ToDecimal()).ToString();
}
private static void CallDeletedInsuredSP(DbConnection visConn, EndorseModel objEndModel)
{
var reader = visConn.UpdateInsuredPremium("DivPersonCalculate", objEndModel.PolicyNumber, objEndModel.APENumber);
if (reader.Read())
{
Console.WriteLine(" Adding Inseured premium : " + (reader["TotalNetPremiumEndos"].ToString()));
var amount = reader["TotalNetPremiumEndos"].ToString().ToDecimal();
objEndModel.ExpectedPremiumForDel.PremiumBeforeFee = amount.ToString();
objEndModel.ExpectedPremiumForDel.PremiumAfterFee = objEndModel.ExpectedPremiumForDel.PremiumBeforeFee;
objEndModel.ExpectedPremiumForDel.Duty = "0";
}
visConn.CloseConnection();
}
private static void FindPreviousEndPremiumAndDuty(DbConnection visConn, EndorseModel endorseModel)
{
var query = "SELECT IA1.END_Sequence,iai.TotalBeforeFee,iai.TotalDuty FROM InsuranceApplication IA1 INNER JOIN InsuranceApplication IA2 ON IA2.Id = IA1.ParentId INNER JOIN InsuranceApplicationItem iai on iai.InsuranceApplication_Id=IA1.Id WHERE IA1.PolicyNumber = '" + endorseModel.PolicyNumber + "' AND IA1.END_Sequence = '" + (endorseModel.AuctualEndorseSeq - 1) + "' AND iai.InsuranceApplicationItemType_Id like 'F8%'";
var reader = visConn.ExecutrQueryReader(query);
while (reader.Read())
{
endorseModel.PreviousPolicyPremiumBeforeFee = reader["TotalBeforeFee"].ToString().ToDecimal();
endorseModel.PreviousPolicyDuty = reader["TotalDuty"].ToString().ToDecimal();
Console.WriteLine("\nPrevious Endorsement \n\tEnd_seq: {0} , \n\tTotalBeforeFee: {1}, \n\tDuty: {2}", reader["END_Sequence"], reader["TotalBeforeFee"], reader["TotalDuty"]);
Console.WriteLine("================================================");
}
visConn.CloseConnection();
}
private static void CallPremiumEndorse(EndorseModel objEndModel)
{
objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee = (objEndModel.ExpectedPremiumForAdd.PremiumBeforeFee.ToDecimal() +
objEndModel.ExpectedPremiumForDel.PremiumBeforeFee.ToDecimal()).ToString();
if (objEndModel.ExpectedPremiumForEditCoverage != null)
{
objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee = (objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee.ToDecimal() +
objEndModel.ExpectedPremiumForEditCoverage.PremiumBeforeFee.ToDecimal()).ToString();
}
var duty = (Math.Floor(objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee.ToDecimal() * (0.4M / 100))) + 1;
objEndModel.ExpectedPremiumForEndorsement.Duty = (duty < 0) ? "0" : duty.ToString();
objEndModel.ExpectedPremiumForEndorsement.PremiumAfterFee = (objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee.ToDecimal() + objEndModel.ExpectedPremiumForEndorsement.Duty.ToDecimal()).ToString();
}
private static void FindEndorseSequence(DbConnection visConn, EndorseModel endorseModel)
{
//Find the End_sequnce of the policy
var stringCheckEndSequence = "select a.Id as AgreementId, a.ReferenceNumber, b.END_Sequence, a.InsuranceApplication_Id from Agreement a left join InsuranceApplication b on (a.InsuranceApplication_Id = b.Id) where ReferenceNumber = '" + endorseModel.PolicyNumber + "' and Discriminator = 'InsurancePolicy'";
var reader = visConn.ExecutrQueryReader(stringCheckEndSequence);
while (reader.Read())
{
Console.WriteLine("================================================\nReference Number: " + reader["ReferenceNumber"]);
Console.WriteLine("the number of End_seq in policy: " + reader["END_Sequence"]);
Console.WriteLine("InsuranceApplication Id: " + reader["InsuranceApplication_Id"]);
Console.WriteLine("================================================");
endorseModel.PolicyAgreementId = reader["AgreementId"].ToString();
endorseModel.CurrPolicyEndSeq = Int32.Parse(reader["END_Sequence"].ToString());
endorseModel.PolicyInAppId = reader["InsuranceApplication_Id"].ToString();
}
visConn.CloseConnection();
//Find the number of endorsement
var query = "SELECT IA1.END_Sequence as LastEndSeq, A.ReferenceNumber as ReferenceNumber FROM InsuranceApplication IA1 INNER JOIN InsuranceApplication IA2 ON IA2.Id = IA1.ParentId Inner join Agreement A on (IA1.Id = A.InsuranceApplication_Id) WHERE IA1.PolicyNumber = '" + endorseModel.PolicyNumber + "' ORDER BY IA1.END_Sequence DESC";
reader = visConn.ExecutrQueryReader(query);
if (reader.Read())
{
Console.WriteLine("current number of End_seq: " + reader["LastEndSeq"]);
if (String.IsNullOrEmpty(reader["ReferenceNumber"].ToString()))
{
Console.WriteLine("Some one hasn't done creating an application (Insurance/Endorsement)!!");
}
Console.WriteLine("================================================");
}
visConn.CloseConnection();
//Find the sequence of this endorsement
query = "SELECT IA1.END_Sequence,iai.TotalBeforeFee,iai.TotalDuty FROM InsuranceApplication IA1 INNER JOIN InsuranceApplication IA2 ON IA2.Id = IA1.ParentId Inner join Agreement A on (IA1.Id = A.InsuranceApplication_Id AND A.ReferenceNumber = '" + endorseModel.APENumber + "') INNER JOIN InsuranceApplicationItem iai on iai.InsuranceApplication_Id=IA1.Id WHERE IA1.PolicyNumber = '" + endorseModel.PolicyNumber + "' AND iai.InsuranceApplicationItemType_Id like 'F8%'";
reader = visConn.ExecutrQueryReader(query);
while (reader.Read())
{
Console.WriteLine("current End_seq of This endorsement: " + reader["END_Sequence"]);
Console.WriteLine("\nCurrent Endorsement \n\tEnd_seq: {0} , \n\tTotalBeforeFee: {1}, \n\tDuty: {2}", reader["END_Sequence"], reader["TotalBeforeFee"], reader["TotalDuty"]);
Console.WriteLine("================================================");
endorseModel.AuctualEndorseSeq = Int32.Parse(reader["END_Sequence"].ToString());
}
visConn.CloseConnection();
}
private static void CheckTypesOfThisEndorsement(DbConnection visConn, EndorseModel endorseModel, string addingInsuredTypeGuid, string deletingInsuredTypeGuid, string changeingCoverageInsuredTypeGUID)
{
var query = "select InsuranceApplicationItem.Id, InsuranceApplicationItem.TotalBeforeFee,InsuranceApplicationItem.TotalDuty,InsuranceApplicationItem.TotalAfterFee,ApplicantEndorsementItem.EndorsementType_Id from Agreement inner join ApplicantEndorsementItem on Agreement.Id = ApplicantEndorsementItem.ApplicantEndorsement_Id inner join InsuranceApplicationItem on ApplicantEndorsementItem.InsuranceApplication_Id = InsuranceApplicationItem.InsuranceApplication_Id where Agreement.ReferenceNumber= '" + endorseModel.APENumber + "' and InsuranceApplicationItem.InsuranceApplicationItemType_Id='213F8708-FCC2-4430-A804-A1D115F718C5'";
var reader = visConn.ExecutrQueryReader(query);
var output = String.Empty;
while (reader.Read())
{
if (reader["EndorsementType_Id"].ToString() == addingInsuredTypeGuid.ToLower())
{
endorseModel.IsAdding = true;
endorseModel.InitialPremium(endorseModel.ActualPremiumForAdd,
reader["TotalBeforeFee"].ToString(),
reader["TotalDuty"].ToString(),
reader["TotalAfterFee"].ToString());
endorseModel.InAppItemIdforAdd = reader["Id"].ToString();
output += "Have => Adding Insured Endorsement\n";
}
else if (reader["EndorsementType_Id"].ToString() == deletingInsuredTypeGuid.ToLower())
{
endorseModel.IsDeleting = true;
endorseModel.ActualPremiumForDel.PremiumBeforeFee = reader["TotalBeforeFee"].ToString();
endorseModel.ActualPremiumForDel.PremiumAfterFee = reader["TotalAfterFee"].ToString();
endorseModel.ActualPremiumForDel.Duty = reader["TotalDuty"].ToString();
endorseModel.InAppItemIdforDel = reader["Id"].ToString();
output += "Have => Deleting Insured Endorsement\n";
}
else if (reader["EndorsementType_Id"].ToString() == changeingCoverageInsuredTypeGUID.ToLower())
{
endorseModel.IsChanging = true;
endorseModel.InAppItemIdforChanged = reader["Id"].ToString();
output += "Have => Changeing Coverage Insured Endorsement\n";
}
else
{
endorseModel.HaveOrtherTypeEnd = true;
}
}
Console.WriteLine(output);
Console.WriteLine("\n\n");
visConn.CloseConnection();
}
private static void UpdatePayment(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("4.3 Update Payment of Endorsement");
Console.WriteLine("========================\n");
var updateQuery = "UPDATE ps " +
"SET ps.PremiumAmount = " + objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee +
" ,ps.StampsDutyAmount = " + objEndModel.ExpectedPremiumForEndorsement.Duty +
" ,ps.TotalAmount = " + objEndModel.ExpectedPremiumForEndorsement.PremiumAfterFee +
" from Agreement a " +
" inner join PremiumSchedule ps on ps.InsuranceApplication_Id=a.InsuranceApplication_Id " +
" where a.ReferenceNumber = '" + objEndModel.APENumber + "'";
var reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
//var result = reader.Read();
}
private static void UpdateEndorseItemPremium(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("4.2 Update PolicyItemPremium of Endorsement");
Console.WriteLine("========================\n");
var updateQuery = "UPDATE pip " +
"SET pip.premiumamount = " + objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee +
" ,pip.stampsdutyamount = " + objEndModel.ExpectedPremiumForEndorsement.Duty +
" ,pip.subtotalamount = " + objEndModel.ExpectedPremiumForEndorsement.PremiumAfterFee +
" from Agreement a " +
" inner join PremiumSchedule ps on ps.InsuranceApplication_Id=a.InsuranceApplication_Id " +
" inner join policyitempremium pip on ps.id=pip.premiumschedule_id " +
" where a.ReferenceNumber = '" + objEndModel.APENumber + "'";
var reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
//var result = reader.Read();
}
private static void UpdatePolicyDuty(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("7. Update Duty of Policy");
Console.WriteLine("========================\n");
var updateQuery = "UPDATE iaf " +
" SET iaf.Amount = " + objEndModel.ExpectedPremiumForPolicy.Duty +
" from Agreement a " +
" inner join insuranceapplication ia on a.insuranceapplication_id=ia.id " +
" inner join insuranceapplicationitem iai on iai.insuranceapplication_id=ia.id " +
" inner join InsuranceApplicationItemFee iaf on iaf.InsuranceApplicationPackageItem_Id=iai.Id " +
" where a.id = '" + objEndModel.PolicyAgreementId +
"' and insuranceapplicationitemtype_id='f89579db-7c44-409f-8d50-a0061d29d04e' and iaf.InsuranceProductCategoryRateConfiguration_Id='FCCC43A8-4EEC-40C7-85C3-A2B7C58264CA'";
var reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
//var result = reader.Read();
}
private static void UpdatePremiumSchedule(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("4.1 Update PremiumSchedule of Endorsement");
Console.WriteLine("========================\n");
var query = "SELECT p.TotalBeforefee,p.totalDuty ,p.TotalAfterFee " +
" from Agreement a " +
" inner join PremiumSchedule ps on ps.InsuranceApplication_Id=a.InsuranceApplication_Id " +
" inner join PaymentApplication pa on pa.PremiumSchedule_Id=ps.Id " +
" inner join Payment p on p.Id = pa.Payment_Id " +
" where a.ReferenceNumber = '" + objEndModel.APENumber + "'";
var reader = visConn.ExecutrQueryReader(query);
if (reader.Read())
{
var premiumTemp = new PremiumModel()
{
PremiumBeforeFee = reader["TotalBeforefee"].ToString(),
Duty = reader["totalDuty"].ToString(),
PremiumAfterFee = reader["TotalAfterFee"].ToString()
};
PrintPremiumDetail(premiumTemp);
}
visConn.CloseConnection();
if (objEndModel.IsAdding)
{
var updateQuery = "UPDATE p " +
"SET p.TotalBeforefee = " + objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee +
" ,p.totalDuty = " + objEndModel.ExpectedPremiumForEndorsement.Duty +
" ,p.TotalAfterFee = " + objEndModel.ExpectedPremiumForEndorsement.PremiumAfterFee +
" from Agreement a " +
" inner join PremiumSchedule ps on ps.InsuranceApplication_Id=a.InsuranceApplication_Id " +
" inner join PaymentApplication pa on pa.PremiumSchedule_Id=ps.Id " +
" inner join Payment p on p.Id = pa.Payment_Id " +
" where a.ReferenceNumber = '" + objEndModel.APENumber + "'";
PrintPremiumDetail(objEndModel.ExpectedPremiumForEndorsement, false);
reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
}
//var result = reader.Read();
}
private static void UpdateEndorsementOverview(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("8. Update Endorsement's overview");
Console.WriteLine("========================\n");
var updateQuery = "UPDATE iai " +
"SET iai.Amount = " + objEndModel.ExpectedPremiumForPolicy.PremiumBeforeFee +
" ,iai.TotalBeforeFee = " + objEndModel.ExpectedPremiumForPolicy.PremiumBeforeFee +
" ,iai.TotalDuty = " + objEndModel.ExpectedPremiumForPolicy.Duty +
" ,iai.TotalAfterFee = " + objEndModel.ExpectedPremiumForPolicy.PremiumAfterFee +
" from Agreement a " +
" inner join insuranceapplication ia on a.insuranceapplication_id=ia.id " +
" inner join insuranceapplicationitem iai on iai.insuranceapplication_id=ia.id " +
" where a.ReferenceNumber = '" + objEndModel.ENDNumber +
"' and InsuranceApplicationItemType_Id='F89579DB-7C44-409F-8D50-A0061D29D04E' ";
var reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
//var result = reader.Read();
}
private static void UpdatePolicyItemPremium(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n========================");
Console.WriteLine("6. Update Premium of Policy");
Console.WriteLine("========================\n");
var updateQuery = "UPDATE iai " +
"SET totalbeforefee = " + objEndModel.ExpectedPremiumForPolicy.PremiumBeforeFee +
" ,amount = " + objEndModel.ExpectedPremiumForPolicy.PremiumBeforeFee +
" ,totalduty = " + objEndModel.ExpectedPremiumForPolicy.Duty +
" ,totalafterfee = " + objEndModel.ExpectedPremiumForPolicy.PremiumAfterFee +
" from Agreement a " +
" inner join insuranceapplication ia on a.insuranceapplication_id=ia.id " +
" inner join insuranceapplicationitem iai on iai.insuranceapplication_id=ia.id " +
" where a.id = '" + objEndModel.PolicyAgreementId +
"' and insuranceapplicationitemtype_id='f89579db-7c44-409f-8d50-a0061d29d04e'";
var reader = visConn.ExecutrQueryReader(updateQuery);
visConn.CloseConnection();
//var result = reader.Read();
}
private static void CallInsertInsuredSP(DbConnection visConn, EndorseModel objEndModel)
{
Console.WriteLine("\n================================================");
Console.WriteLine("1. Update Insured's premium ");
Console.WriteLine("================================================\n");
var reader = visConn.UpdateInsuredPremium("InsertPersonCalculate", objEndModel.PolicyNumber, objEndModel.APENumber);
if (reader.Read())
{
var premiumAmount = reader["TotalNetPremiumEndos"].ToString().ToDecimal();
Console.Write("premiumAmount = " + premiumAmount);
premiumAmount = Math.Round(premiumAmount / 2, 2);
Console.WriteLine(" => Math.Round(premiumAmount/2) =" + premiumAmount);
var duty = premiumAmount * (0.4M / 100);
Console.Write("Duty = " + duty);
duty = Math.Ceiling(duty);
Console.WriteLine(" => Math.Ceiling(duty) =" + duty);
//objEndModel.ExpectedPremiumForAdd.PremiumBeforeFee = premiumAmount.ToString();
//objEndModel.ExpectedPremiumForAdd.PremiumAfterFee = (premiumAmount+duty).ToString();
//objEndModel.ExpectedPremiumForAdd.Duty = (duty).ToString();
}
visConn.CloseConnection();
}
private static void FindEndorsementAndPolicyNumber(string apeNo, DbConnection visConn, EndorseModel objEndModel)
{
var query = "select a.ReferenceNumber as APENumber, b.ReferenceNumber as ENDNumber, c.PolicyNumber from Agreement a left join Agreement b on (a.InsuranceApplication_Id = b.InsuranceApplication_Id AND b.Discriminator = 'InsuranceEndorsement') left join InsuranceApplication c on a.InsuranceApplication_Id = c.Id where a.ReferenceNumber = '" + apeNo + "'";
var reader = visConn.ExecutrQueryReader(query);
if (reader.Read())
{
objEndModel.ENDNumber = reader["ENDNumber"].ToString();
objEndModel.PolicyNumber = reader["PolicyNumber"].ToString();
}
visConn.CloseConnection();
}
static void Main(string[] args)
{
var VISconn = new DbConnection("Server='VISDBCentral';Database=VIS_DB;User=vissa;Password=visdbpassword;MultipleActiveResultSets=True");
//DbConnection VISconn = new DbConnection("Server='.';Database=VIS_DB;Integrated Security=True; Trusted_Connection=true");
//var VISconn = new DbConnection("Server='VISHQDB';Database=VIS_DB;User=vissa;Password=visdbpassword;MultipleActiveResultSets=True");
// string polNo = "17181/POL/000017-563";
string apeNo = "18181/APE/000027-563";
//string endNo = "17181/END/000055-563";
string addingInsuredTypeGUID = "A446F001-873E-4439-9397-9D95609143B5";
string deletingInsuredTypeGUID = "C59823FA-4ADF-439B-A281-D7E759CAE307";
string changeingCoverageInsuredTypeGUID = "4B6F241B-3D35-4555-A394-40E0B563831F";
// var objEndModel = new EndorseModel(polNo, apeNo, endNo);
var objEndModel = new EndorseModel(apeNo);
FindEndorsementAndPolicyNumber(apeNo, VISconn, objEndModel);
Console.WriteLine("Policy Number : {0}\n" +
"APE Number : {1}\n" +
"END Number : {2}\n\n", objEndModel.PolicyNumber, objEndModel.APENumber, objEndModel.ENDNumber);
//objEndModel.InitialPremium(objEndModel.ExpectedPremiumForEndorsement, "235047.22", "941", "235988.22");
//objEndModel.InitialPremium(objEndModel.ExpectedPremiumForEndorsement, "16163.64", "65", "16228.64");
//objEndModel.InitialPremium(objEndModel.ExpectedPremiumForAdd, "2398.68", "10", "2408.68");
objEndModel.InitialPremium(objEndModel.ExpectedPremiumForDel, "-2880.00", "0", "-2880.00");
//objEndModel.InitialPremium(objEndModel.ExpectedPremiumForEditCoverage, "132713.12", "531", "133244.12");
//Console.Write("Confirm? (Y/N): ");
//var result = Console.ReadLine();
var result = "Y";
if (result == "Y")
{
FindEndorseSequence(VISconn, objEndModel);
FindPreviousEndPremiumAndDuty(VISconn, objEndModel);
CheckTypesOfThisEndorsement(VISconn, objEndModel, addingInsuredTypeGUID, deletingInsuredTypeGUID, changeingCoverageInsuredTypeGUID);
// 1. Update premium amount of insured that was added
if (objEndModel.IsAdding)
{
//CallInsertInsuredSP(VISconn, objEndModel);
// 2. Update premium amount for Endorsement
UpdateInAppItem(VISconn, objEndModel.ExpectedPremiumForAdd, objEndModel.InAppItemIdforAdd);
}
if (objEndModel.IsDeleting)
{
if (objEndModel.AuctualEndorseSeq == objEndModel.CurrPolicyEndSeq)
{
// CallDeletedInsuredSP(VISconn, objEndModel);
UpdateInAppItem(VISconn, objEndModel.ExpectedPremiumForDel, objEndModel.InAppItemIdforDel);
}
else
{
Console.WriteLine("\n==============\n Can't update the premium of insured who are deleted from the policy!\n b/c the last endorse is not the current endorse \n========================");
}
}
if (objEndModel.IsChanging)
{
UpdateInAppItem(VISconn, objEndModel.ExpectedPremiumForEditCoverage, objEndModel.InAppItemIdforChanged);
}
CallPremiumEndorse(objEndModel);
if (!String.IsNullOrEmpty(objEndModel.ExpectedPremiumForEndorsement.PremiumBeforeFee))
{
// 3. Update the endorsement premium
UpdateEndorsePremium(VISconn, objEndModel);
// 3.2 Update the endorsment fee
UpdateEndorsementDuty(VISconn, objEndModel);
//4. Modify the reciept
//4.1 Update the PremiumSchedule
UpdatePremiumSchedule(VISconn, objEndModel);
//4.2 Update the PolicyItemPremium (only use for have 1 reciept)
UpdateEndorseItemPremium(VISconn, objEndModel);
//4.3 Update the Payment
UpdatePayment(VISconn, objEndModel);
}
/*if (objEndModel.AuctualEndorseSeq != objEndModel.CurrPolicyEndSeq)
* {
* Console.WriteLine(
* "!!! You need to run method interrupt b/c the current End_sequnece doen't match with in the policy !!!");
* var ans = String.Empty;
* do
* {
* Console.Write("Have you run the interupt method? (Y/N): ");
* ans = Console.ReadLine();
* } while (ans != "Y");
*
* }*/
CalculatePolicyPremium(objEndModel);
//6. Update Policy Premium
UpdatePolicyItemPremium(VISconn, objEndModel);
//7. Update Duty
UpdatePolicyDuty(VISconn, objEndModel);
//8. Update overview of Endorsement's Premium
UpdateEndorsementOverview(VISconn, objEndModel);
Console.ReadLine();
}
else
{
Console.WriteLine("You cancel the process!");
}
}
