private void setDefaultValueBasedonRemainingYears()
{
for (int i = 0; i <= DEFAULT_YEARS; i++)
{
RiskProfiledReturn riskProfileReturn = new RiskProfiledReturn();
riskProfileReturn.YearRemaining = i;
riskProfileReturn.ForeingInvestmentRatio = 0;
riskProfileReturn.EquityInvestementRatio = 0;
riskProfileReturn.DebtInvestementRatio = 0;
riskProfileReturn.ForeingInvestementReaturn = 0;
riskProfileReturn.EquityInvestementReturn = 0;
riskProfileReturn.DebtInvestementReturn = 0;
DataRow drRiskProfRetun = _dtRiskProfileReturn.NewRow();
drRiskProfRetun["YearRemaining"] = riskProfileReturn.YearRemaining;
drRiskProfRetun["ForeingInvestmentRatio"] = riskProfileReturn.ForeingInvestmentRatio;
drRiskProfRetun["EquityInvestementRatio"] = riskProfileReturn.EquityInvestementRatio;
drRiskProfRetun["DebtInvestementRatio"] = riskProfileReturn.DebtInvestementRatio;
drRiskProfRetun["ForeingInvestementReaturn"] = riskProfileReturn.ForeingInvestementReaturn;
drRiskProfRetun["EquityInvestementReturn"] = riskProfileReturn.EquityInvestementReturn;
drRiskProfRetun["DebtInvestementReturn"] = riskProfileReturn.DebtInvestementReturn;
drRiskProfRetun["AverageInvestementReturn"] = riskProfileReturn.AverageInvestemetReturn;
_dtRiskProfileReturn.Rows.Add(drRiskProfRetun);
}
}
public IList <RiskProfiledReturn> GetAllDetails(int id)
{
try
{
Logger.LogInfo("Get: RiskProfiledReturn process start");
IList <RiskProfiledReturn> lstRiskProfile = new List <RiskProfiledReturn>();
DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ALL_DETAILS, id));
foreach (DataRow dr in dtAppConfig.Rows)
{
RiskProfiledReturn riskPrfile = convertToRiskProfileDetailsObject(dr);
lstRiskProfile.Add(riskPrfile);
}
Logger.LogInfo("Get: RiskProfiledReturn process completed.");
return(lstRiskProfile);
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
MethodBase currentMethodName = sf.GetMethod();
LogDebug(currentMethodName.Name, ex);
return(null);
}
}
private RiskProfiledReturnMaster getRiskProfileData()
{
RiskProfiledReturnMaster rpr = new RiskProfiledReturnMaster();
rpr.Id = _riskProfileId;
rpr.Name = txtRiskProfileName.Text;
rpr.Description = txtDescription.Text;
rpr.UpdatedOn = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"));
rpr.UpdatedBy = Program.CurrentUser.Id;
rpr.UpdatedByUserName = Program.CurrentUser.UserName;
rpr.MachineName = System.Environment.MachineName;
rpr.RiskProfileReturn = new List <RiskProfiledReturn>();
foreach (DataRow dr in _dtRiskProfileReturn.Rows)
{
RiskProfiledReturn riskProfile = new RiskProfiledReturn();
//riskProfile.Id = dr.Field<int>("ID");
riskProfile.RiskProfileId = rpr.Id;
riskProfile.YearRemaining = int.Parse(dr["YearRemaining"].ToString());
riskProfile.ForeingInvestmentRatio = decimal.Parse(dr["ForeingInvestmentRatio"].ToString());
riskProfile.EquityInvestementRatio = decimal.Parse(dr["EquityInvestementRatio"].ToString());
riskProfile.DebtInvestementRatio = decimal.Parse(dr["DebtInvestementRatio"].ToString());
riskProfile.ForeingInvestementReaturn = decimal.Parse(dr["ForeingInvestementReaturn"].ToString());
riskProfile.EquityInvestementReturn = decimal.Parse(dr["EquityInvestementReturn"].ToString());
riskProfile.DebtInvestementReturn = decimal.Parse(dr["DebtInvestementReturn"].ToString());
rpr.RiskProfileReturn.Add(riskProfile);
}
return(rpr);
}
private RiskProfiledReturn convertToRiskProfileDetailsObject(DataRow dr)
{
RiskProfiledReturn riskProfile = new RiskProfiledReturn();
//riskProfile.Id = dr.Field<int>("ID");
riskProfile.RiskProfileId = dr.Field <int>("RiskProfileID");
riskProfile.YearRemaining = dr.Field <int>("YearRemaining");
riskProfile.ForeingInvestmentRatio = dr.Field <decimal>("ForeingInvestmentRatio");
riskProfile.EquityInvestementRatio = dr.Field <decimal>("EquityInvestmentRatio");
riskProfile.DebtInvestementRatio = dr.Field <decimal>("DebtInvestmentRation");
riskProfile.ForeingInvestementReaturn = dr.Field <decimal>("ForeingInvestementReaturn");
riskProfile.EquityInvestementReturn = dr.Field <decimal>("EquityInvestementReaturn");
riskProfile.DebtInvestementReturn = dr.Field <decimal>("DebtInvestementReaturn");
return(riskProfile);
}
private void generateRiskProfileTable(RiskProfiledReturnMaster riskProfiledReturnMaster)
{
for (int i = 0; i <= riskProfiledReturnMaster.MaxYear; i++)
{
RiskProfiledReturn riskProfileReturn = new RiskProfiledReturn();
riskProfileReturn.YearRemaining = i;
DataRow drRiskProfRetun = _dtRiskProfileReturn.NewRow();
drRiskProfRetun["YearRemaining"] = riskProfileReturn.YearRemaining;
float foreingInvRatio, foreingInvReturn;
float equityInvRatio, equityInvReturn;
float debtInvRatio, debtInvReturn;
if (riskProfileReturn.YearRemaining <= riskProfiledReturnMaster.ThresholdYear)
{
drRiskProfRetun["ForeingInvestmentRatio"] = riskProfiledReturnMaster.PreForeingInvestmentRatio;
foreingInvRatio = riskProfiledReturnMaster.PreForeingInvestmentRatio;
drRiskProfRetun["EquityInvestementRatio"] = riskProfiledReturnMaster.PreEquityInvestmentRatio;
equityInvRatio = riskProfiledReturnMaster.PreEquityInvestmentRatio;
drRiskProfRetun["DebtInvestementRatio"] = riskProfiledReturnMaster.PreDebtInvestmentRatio;
debtInvRatio = riskProfiledReturnMaster.PreDebtInvestmentRatio;
}
else
{
drRiskProfRetun["ForeingInvestmentRatio"] = riskProfiledReturnMaster.PostForeingInvestmentRatio;
foreingInvRatio = riskProfiledReturnMaster.PostForeingInvestmentRatio;
drRiskProfRetun["EquityInvestementRatio"] = riskProfiledReturnMaster.PostEquityInvestmentRatio;
equityInvRatio = riskProfiledReturnMaster.PostEquityInvestmentRatio;
drRiskProfRetun["DebtInvestementRatio"] = riskProfiledReturnMaster.PostDebtInvestmentRatio;
debtInvRatio = riskProfiledReturnMaster.PostDebtInvestmentRatio;
}
drRiskProfRetun["ForeingInvestementReaturn"] = riskProfiledReturnMaster.ForeingInvestmentReturn;
foreingInvReturn = riskProfiledReturnMaster.ForeingInvestmentReturn;
drRiskProfRetun["EquityInvestementReturn"] = riskProfiledReturnMaster.EquityInvestmentReturn;
equityInvReturn = riskProfiledReturnMaster.EquityInvestmentReturn;
drRiskProfRetun["DebtInvestementReturn"] = riskProfiledReturnMaster.DebtInvestmentReturn;
debtInvReturn = riskProfiledReturnMaster.DebtInvestmentReturn;
drRiskProfRetun["AverageInvestementReturn"] = (((foreingInvRatio * foreingInvReturn) / 100) + ((equityInvRatio * equityInvReturn) / 100) + ((debtInvRatio * debtInvReturn) / 100));
_dtRiskProfileReturn.Rows.Add(drRiskProfRetun);
}
}
