private static void PrintPremiumDetail(PremiumModel actualPremium, bool isActualpreium = true) { if (isActualpreium) { Console.WriteLine("Actual Premium (Before Update)"); } else { Console.WriteLine("Expected Premium (After Update)"); } Console.WriteLine( "\tBefore Fee = {0}\n" + "\tDuty = {1}\n" + "\tAfter Fee = {2}\n", actualPremium.PremiumBeforeFee, actualPremium.Duty, actualPremium.PremiumAfterFee); }
private static void UpdateInAppItem(DbConnection visConn, PremiumModel premium, string inAppItemId) { PrintPremiumDetail(premium, false); var updateQuery = "UPDATE InsuranceApplicationItem " + "SET TotalBeforeFee = " + premium.PremiumBeforeFee + " ,TotalDuty = " + premium.Duty + " ,TotalAfterFee = " + premium.PremiumAfterFee + " ,ModifiedUsername = '******'" + " WHERE Id = '" + inAppItemId + "'"; 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(); }
public void InitialPremium(PremiumModel premium, string premiumBeforeFee, string duty, string premiumAfterFee) { premium.PremiumBeforeFee = premiumBeforeFee; premium.PremiumAfterFee = premiumAfterFee; premium.Duty = duty; }