/// <summary>
/// CreatedBy : Nadeeka
/// CreatedDate: 2016/02/09
///
/// retreive Curtailment Detail By CurtailmentId
///
/// argument : curtailment_id (int)
///
/// </summary>
/// <returns>curtailment list</returns>
public List<Curtailment> retreiveCurtailmentByLoanId(int loanId)
{
try
{
List<Curtailment> lstCurtailment = new List<Curtailment>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
DataSet dataSet = dataHandler.GetDataSet("spRetrieveCurtailmentByLoanId", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
Curtailment curtailment = new Curtailment();
curtailment.CurtailmentId = int.Parse(dataRow["curtailment_id"].ToString());
curtailment.LoanId = int.Parse(dataRow["loan_id"].ToString());
curtailment.TimePeriod = Convert.ToInt32(dataRow["time_period"]);
curtailment.Percentage = Convert.ToInt32(dataRow["percentage"].ToString());
lstCurtailment.Add(curtailment);
}
return lstCurtailment;
}
else
{
return null;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// CreatedBy : Nadeeka
/// CreatedDate: 2016/03/15
///
/// Get loan curtailment schedule by loan id
///
/// </summary>
/// <param name="loanId">loan id</param>
/// <returns>curtialment breakdown as a DataSet</returns>
public LoanSetupStep1 GetLoanCurtailmentBreakdown(int loanId)
{
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
DataSet dataSet = dataHandler.GetDataSet("spGetLoanCurtailmentBreakdown", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0)
{
LoanSetupStep1 loan = new LoanSetupStep1();
loan.curtailmetList = new List<Curtailment>();
loan.payOffPeriodType = dataSet.Tables[0].Rows[0]["pay_off_type"].ToString().Equals("d") ? 0 : 1;
//loan.payOffPeriod = Convert.ToInt32(dataSet.Tables[0].Rows[0]["pay_off_period"].ToString());
loan.CurtailmentCalculationBase = dataSet.Tables[0].Rows[0]["curtailment_calculation_type"].ToString();
loan.advancePercentage = Convert.ToInt32(dataSet.Tables[0].Rows[0]["advance"].ToString());
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
Curtailment curtailment = new Curtailment();
curtailment.CurtailmentId = Convert.ToInt32(dataRow["curtailment_id"].ToString());
curtailment.TimePeriod = Convert.ToInt32(dataRow["time_period"].ToString());
curtailment.Percentage = Convert.ToInt32(dataRow["percentage"].ToString());
loan.curtailmetList.Add(curtailment);
}
return loan;
}
else
{
return null;
}
}