public void Update(AssumptionMaster assumptionMaster)
{
try
{
string recordCount = DataBase.DBService.ExecuteCommandScalar(SELECT_COUNT);
DataBase.DBService.BeginTransaction();
if (recordCount != "0")
{
DataBase.DBService.ExecuteCommandString(string.Format(UPDATE_QUERY,
assumptionMaster.RetirementAge,
assumptionMaster.LifeExpectancy,
assumptionMaster.PreRetirementInflactionRate,
assumptionMaster.PostRetirementInflactionRate,
assumptionMaster.EquityReturnRate,
assumptionMaster.DebtReturnRate,
assumptionMaster.OtherReturnRate,
assumptionMaster.IncomeRaiseRatio,
assumptionMaster.OngoingExpRise,
assumptionMaster.NonFinancialRateOfReturn,
assumptionMaster.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
assumptionMaster.UpdatedBy,
assumptionMaster.Id,
assumptionMaster.PostRetirementInvestmentReturnRate,
assumptionMaster.InsuranceReturnRate), true);
}
else
{
DataBase.DBService.ExecuteCommandString(string.Format(INSERT_QUERY,
assumptionMaster.RetirementAge,
assumptionMaster.LifeExpectancy,
assumptionMaster.PreRetirementInflactionRate,
assumptionMaster.PostRetirementInflactionRate,
assumptionMaster.EquityReturnRate,
assumptionMaster.DebtReturnRate,
assumptionMaster.OtherReturnRate,
assumptionMaster.IncomeRaiseRatio,
assumptionMaster.OngoingExpRise,
assumptionMaster.NonFinancialRateOfReturn,
assumptionMaster.CreatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
assumptionMaster.CreatedBy,
assumptionMaster.UpdatedOn.ToString("yyyy-MM-dd hh:mm:ss"),
assumptionMaster.UpdatedBy,
assumptionMaster.Id,
assumptionMaster.PostRetirementInvestmentReturnRate,
assumptionMaster.InsuranceReturnRate), true);
}
Activity.ActivitiesService.Add(ActivityType.UpdatePlannerAssumption, EntryStatus.Success,
Source.Server, assumptionMaster.UpdatedByUserName, "", assumptionMaster.MachineName);
DataBase.DBService.CommitTransaction();
}
catch (Exception ex)
{
DataBase.DBService.RollbackTransaction();
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
throw ex;
}
}
public Result Update(AssumptionMaster assumptionMaster)
{
var result = new Result();
try
{
AssumptionMasterService assumptionService = new AssumptionMasterService();
assumptionService.Update(assumptionMaster);
result.IsSuccess = true;
}
catch (Exception exception)
{
result.IsSuccess = false;
result.ExceptionInfo = exception;
}
return(result);
}
private AssumptionMaster convertToAssumptionMasterObject(DataRow dr)
{
AssumptionMaster assumptionMaster = new AssumptionMaster();
assumptionMaster.Id = dr.Field <int>("ID");
assumptionMaster.RetirementAge = dr.Field <int>("RetirementAge");
assumptionMaster.LifeExpectancy = dr.Field <int>("LifeExpectancy");
assumptionMaster.PreRetirementInflactionRate = dr.Field <decimal>("PreRetirementInflactionRate");
assumptionMaster.PostRetirementInflactionRate = dr.Field <decimal>("PostRetirementInflactionRate");
assumptionMaster.EquityReturnRate = dr.Field <decimal>("EquityReturnRate");
assumptionMaster.DebtReturnRate = dr.Field <decimal>("DebtReturnRate");
assumptionMaster.OtherReturnRate = dr.Field <decimal>("OtherReturnRate");
assumptionMaster.IncomeRaiseRatio = dr.Field <decimal>("IncomeRise");
assumptionMaster.OngoingExpRise = dr.Field <decimal>("OngoingExpRise");
assumptionMaster.NonFinancialRateOfReturn = dr.Field <decimal>("NonFinancialRateOfReturn");
assumptionMaster.UpdatedOn = dr.Field <DateTime>("UpdatedOn");
assumptionMaster.UpdatedBy = dr.Field <int>("UpdatedBy");
assumptionMaster.PostRetirementInvestmentReturnRate = dr.Field <decimal>("PostRetirementInvestmentReturnRate");
assumptionMaster.InsuranceReturnRate = dr.Field <decimal>("InsuranceReturnRate");
return(assumptionMaster);
}
public AssumptionMaster GetAll()
{
try
{
Logger.LogInfo("Get: Assumption master process start");
AssumptionMaster assumptionMaster = new AssumptionMaster();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(SELECT_ALL);
foreach (DataRow dr in dtAppConfig.Rows)
{
assumptionMaster = convertToAssumptionMasterObject(dr);
}
Logger.LogInfo("Get: Assumption master process completed.");
return(assumptionMaster);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
