public LifeQuote LoadQuotationPool(LifeQuote objPolicy) { #region Call API objPolicy = WebApiLogic.GetPostComplexTypeToAPI <LifeQuote>(objPolicy, "LoadQuotationPool", "Policy"); #endregion return(objPolicy); }
public AIA.Life.Models.Opportunity.LifeQuote FetchSAM(LifeQuote objLifeQuote) { //objQuoteList = new QuoteList(); AIA.Life.Business.Prospect.ProspectBusiness objProspectBusiness = new AIA.Life.Business.Prospect.ProspectBusiness(); objLifeQuote = objProspectBusiness.GetSAM(objLifeQuote); return(objLifeQuote); }
public AIA.Life.Models.Opportunity.LifeQuote GetSAM(LifeQuote objLifeQuote) { #region Call API //QuoteList objQuoteList = new QuoteList(); //objQuoteList.objProspect.Age = age; objLifeQuote = WebApiLogic.GetPostComplexTypeToAPI <AIA.Life.Models.Opportunity.LifeQuote>(objLifeQuote, "FetchSAM", "Suspect"); #endregion return(objLifeQuote); }
public AIA.Life.Models.Opportunity.LifeQuote FetchSAM(LifeQuote objLifeQuote) { ProspectLogic objlogic = new ProspectLogic(); int age = objLifeQuote.objProspect.AgeNextBdy ?? 0; int variant = Convert.ToInt32(objLifeQuote.objProductDetials.Variant); objLifeQuote = objlogic.GetSAM(variant, age); return(objLifeQuote); }
public IActionResult Quote(LifeQuote quote) { if (ModelState.IsValid) { quoteService.GenerateLifeQuote(quote); return(RedirectToAction("Insurance", "Confirmation")); } else { logger.LogInformation("Bad model", quote); return(View(quote)); } }
public void GetDrawDownDetails(LifeQuote objLifeQuote) { AVOAIALifeEntities Context = new AVOAIALifeEntities(); string xmlStr = MapQuotePremiumObject(new AIA.Life.Repository.AIAEntity.AVOAIALifeEntities(), objLifeQuote); #region Log Input AVOAIALifeEntities entities = new AVOAIALifeEntities(); tbllogxml objlogxml = new tbllogxml(); objlogxml.Description = "DrawDown xml"; objlogxml.PolicyID = Convert.ToString(objLifeQuote.objProspect.ContactID); objlogxml.UserID = objLifeQuote.UserName; objlogxml.XMlData = xmlStr; objlogxml.CreatedDate = DateTime.Now; entities.tbllogxmls.Add(objlogxml); entities.SaveChanges(); #endregion System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); con.Open(); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.Text; cmd.CommandText = "exec usp_GetDrawDownDetails '" + xmlStr + "'"; //cmd.Parameters.Add("@XmlStr", SqlDbType.VarChar); //cmd.Parameters[0].Value = xmlStr; DataSet ds = new DataSet(); System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd); da.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { //DrawDownDetails ddd = new DrawDownDetails(); tblQuoteDrawDownDetail objtblQuoteDrawDownDetail = new tblQuoteDrawDownDetail(); objtblQuoteDrawDownDetail.LifeQQID = objLifeQuote.LifeQQID; objtblQuoteDrawDownDetail.PaymentFequency = Convert.ToInt32(ds.Tables[0].Rows[i]["PaymentFequency"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["PaymentFequency"]); objtblQuoteDrawDownDetail.DrawDownDiv4 = Convert.ToDecimal(ds.Tables[0].Rows[i]["DrawDownDiv4"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv4"]); objtblQuoteDrawDownDetail.DrawDownDiv8 = Convert.ToDecimal(ds.Tables[0].Rows[i]["DrawDownDiv8"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv8"]); objtblQuoteDrawDownDetail.DrawDownDiv12 = Convert.ToDecimal(ds.Tables[0].Rows[i]["DrawDownDiv12"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv12"]); Context.tblQuoteDrawDownDetails.Add(objtblQuoteDrawDownDetail); } Context.SaveChanges(); }
public IActionResult Quote(LifeQuote quote) { quoteService.GenerateLifeQuote(quote); return(RedirectToAction("Insurance", "Confirmation")); }
public LifeQuote LoadQuotationPoolData(LifeQuote objPolicyData) { AIA.Life.Business.Quote.QuoteBusiness objQuoteBusiness = new AIA.Life.Business.Quote.QuoteBusiness(); objPolicyData = objQuoteBusiness.LoadQuotationPool(objPolicyData); return(objPolicyData); }
public LifeQuote GetIllustration(LifeQuote objLifeQuote) { string xmlStr = MapQuotePremiumObject(new AIA.Life.Repository.AIAEntity.AVOAIALifeEntities(), objLifeQuote); #region Log Input AVOAIALifeEntities entities = new AVOAIALifeEntities(); tbllogxml objlogxml = new tbllogxml(); objlogxml.Description = "Illustration xml"; objlogxml.PolicyID = Convert.ToString(objLifeQuote.objProspect.ContactID); objlogxml.UserID = objLifeQuote.UserName; objlogxml.XMlData = xmlStr; objlogxml.CreatedDate = DateTime.Now; entities.tbllogxmls.Add(objlogxml); entities.SaveChanges(); #endregion System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); con.Open(); System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(); cmd.Connection = con; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "usp_GetIllustration"; cmd.Parameters.Add("@XmlStr", SqlDbType.VarChar); cmd.Parameters[0].Value = xmlStr; DataSet ds = new DataSet(); System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(cmd); da.Fill(ds); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { Illustation ill = new Illustation(); ill.PolicyYear = Convert.ToInt32(ds.Tables[0].Rows[i]["PolicyYear"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["PolicyYear"]); ill.BasicPremium = Convert.ToInt32(ds.Tables[0].Rows[i]["BasicPremium"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["BasicPremium"]); ill.MainBenefitsPremium = Convert.ToInt32(ds.Tables[0].Rows[i]["MainBenefitsPremium"] == DBNull.Value?0: ds.Tables[0].Rows[i]["MainBenefitsPremium"]); ill.AdditionalBenefitsPremiums = Convert.ToInt32(ds.Tables[0].Rows[i]["AdditionalBenefitsPremiums"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["AdditionalBenefitsPremiums"]); ill.TotalPremium = Convert.ToInt32(ds.Tables[0].Rows[i]["TotalPremium"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["TotalPremium"]); ill.FundBalanceDiv4 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv4"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv4"]); ill.SurrenderValueDiv4 = Convert.ToInt64(ds.Tables[0].Rows[i]["SurrenderValueDiv4"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["SurrenderValueDiv4"]); ill.DrawDownDiv4 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv4"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv4"]); ill.PensionBoosterDiv4 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv4_Pensionbooster"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv4_Pensionbooster"]); ill.FundBalanceDiv8 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv8"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv8"]); ill.SurrenderValueDiv8 = Convert.ToInt64(ds.Tables[0].Rows[i]["SurrenderValueDiv8"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["SurrenderValueDiv8"]); ill.DrawDownDiv8 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv8"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv8"]); ill.PensionBoosterDiv8 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv8_Pensionbooster"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv8_Pensionbooster"]); ill.FundBalanceDiv12 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv12"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv12"]); ill.SurrenderValueDiv12 = Convert.ToInt64(ds.Tables[0].Rows[i]["SurrenderValueDiv12"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["SurrenderValueDiv12"]); ill.DrawDownDiv12 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv12"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv12"]); ill.PensionBoosterDiv12 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv12_Pensionbooster"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv12_Pensionbooster"]); ill.FundBalanceDiv5 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv5"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv5"]); ill.FundBalanceDiv6 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv6"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv6"]); ill.FundBalanceDiv7 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv7"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv7"]); ill.FundBalanceDiv9 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv9"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv9"]); ill.FundBalanceDiv10 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv10"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv10"]); ill.FundBalanceDiv11 = Convert.ToInt64(ds.Tables[0].Rows[i]["FundBalanceDiv11"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["FundBalanceDiv11"]); ill.DrawDownDiv5 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv5"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv5"]); ill.DrawDownDiv6 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv6"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv6"]); ill.DrawDownDiv7 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv7"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv7"]); ill.DrawDownDiv9 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv9"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv9"]); ill.DrawDownDiv10 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv10"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv10"]); ill.DrawDownDiv11 = Convert.ToInt64(ds.Tables[0].Rows[i]["DrawDownDiv11"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["DrawDownDiv11"]); ill.UnAllocatedPremium = Convert.ToInt64(ds.Tables[0].Rows[i]["UnAllocatedPremium"] == DBNull.Value ? 0 : ds.Tables[0].Rows[i]["UnAllocatedPremium"]); objLifeQuote.LstIllustation.Add(ill); } return(objLifeQuote); }
public void GenerateLifeQuote(LifeQuote quote) { // todo }