/// <summary>
/// CreatedBy:Irfan MAM
/// CreatedDate:2016/2/9
/// getting all unit types
/// </summary>
/// <returns>IList<UnitType></returns>
/// UpdatedBy:Asanka Senarathna
///
internal IList<UnitType> getAllUnitTypes()
{
List<UnitType> unitTypes = new List<UnitType>();
DataHandler dataHandler = new DataHandler();
try
{
DataSet dataSet = dataHandler.GetDataSet("spGetAllUnitTypes", null);
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
UnitType unitType = new UnitType();
unitType.unitTypeName = dataRow["unit_type_name"].ToString();
unitType.unitTypeId = int.Parse(dataRow["unit_type_id"].ToString());
unitType.isSelected = false;
unitTypes.Add(unitType);
}
return unitTypes;
}
else
{
return null;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="loanId"></param>
/// <returns></returns>
public IList<UnitType> RptGetUnitTypes(int loanId)
{
IList<UnitType> unittypes = new List<UnitType>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]> { new object[] { "@loan_id", loanId } };
DataSet dataSet = dataHandler.GetDataSet("spGetLoanUnitTypesByLoanId ", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
UnitType unitType = new UnitType();
unitType.unitTypeId = Convert.ToInt32((dataRow["unit_type_id"]));
unitType.unitTypeName = dataRow["unit_type_name"].ToString();
unittypes.Add(unitType);
}
}
return unittypes;
}
/// <summary>
/// CreatedBy: Kanishka
/// CreatedDate:02/29/2016
/// get loan details by loan code
/// </summary>
/// <param name="loanCode"></param>
/// <returns></returns>
internal LoanSetupStep1 GetLoanDetailsByLoanCode(string loanCode)
{
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ConnectionString))
{
try
{
using (SqlCommand cmd = new SqlCommand("spGetLoanDetailsByLoanCode", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@loan_code", SqlDbType.VarChar).Value = loanCode;
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1();
while (reader.Read())
{
loanSetupStep1.loanId = Convert.ToInt32(reader["loan_id"]);
loanSetupStep1.advancePercentage = int.Parse(reader["advance"].ToString());
loanSetupStep1.autoReminderEmail = reader["auto_remind_email"].ToString();
loanSetupStep1.autoReminderPeriod = int.Parse(reader["auto_remind_period"].ToString());
loanSetupStep1.defaultUnitType = int.Parse(reader["default_unit_type"].ToString());
loanSetupStep1.isEditAllowable = Convert.ToBoolean(reader["is_edit_allowable"].ToString());
loanSetupStep1.isInterestCalculate = Convert.ToBoolean(reader["is_interest_calculate"].ToString());
loanSetupStep1.loanAmount = Convert.ToDecimal(reader["loan_amount"].ToString());
loanSetupStep1.loanNumber = reader["loan_number"].ToString();
loanSetupStep1.maturityDate = Convert.ToDateTime(reader["maturity_date"].ToString());
loanSetupStep1.nonRegisteredBranchId = int.Parse(reader["non_reg_branch_id"].ToString());
loanSetupStep1.paymentMethod = reader["payment_method"].ToString();
loanSetupStep1.startDate = Convert.ToDateTime(reader["start_date"].ToString());
loanSetupStep1.RegisteredBranchId = Convert.ToInt32(reader["branch_id"].ToString());
loanSetupStep1.LoanStatus = Convert.ToBoolean(reader["loan_status"]);
loanSetupStep1.RegisteredBranchCode = reader["r_branch_code"].ToString();
loanSetupStep1.RegisteredCompanyCode = reader["company_code"].ToString();
if(reader["curtailment_due_date"].ToString()== "EoM") {
loanSetupStep1.CurtailmentDueDate = "End of Month";
}
else {
string dueDate = reader["curtailment_due_date"].ToString();
if (dueDate.Length > 0)
{
if (dueDate.Length == 1)
{
if (dueDate.Contains("1"))
{
loanSetupStep1.CurtailmentDueDate = dueDate+ "st of each month";
}
else if (dueDate.Contains("2"))
{
loanSetupStep1.CurtailmentDueDate = dueDate + "nd of each month";
}
else if (dueDate.Contains("3"))
{
loanSetupStep1.CurtailmentDueDate = dueDate + "rd of each month";
}
else
{
loanSetupStep1.CurtailmentDueDate = dueDate + "th of each month";
}
}
else if(dueDate.Length > 1)
{
if (!dueDate.ElementAt(dueDate.Length - 2).ToString().Contains("1"))
{
if (dueDate.ElementAt(dueDate.Length - 1).ToString().Contains("1"))
{
loanSetupStep1.CurtailmentDueDate = dueDate + "st of each month";
}
else if (dueDate.ElementAt(dueDate.Length - 1).ToString().Contains("2"))
{
loanSetupStep1.CurtailmentDueDate = dueDate + "nd of each month";
}
else if (dueDate.ElementAt(dueDate.Length - 1).ToString().Contains("3"))
{
loanSetupStep1.CurtailmentDueDate = dueDate + "rd of each month";
}
else
{
loanSetupStep1.CurtailmentDueDate = dueDate + "th of each month";
}
}
else
{
loanSetupStep1.CurtailmentDueDate = dueDate + "th of each month";
}
}
}
//loanSetupStep1.CurtailmentDueDate = reader["curtailment_due_date"].ToString()+"th of each month";
}
//loanSetupStep1.CurtailmentDueDate = reader["curtailment_due_date"].ToString();
}
reader.Close();
IList<UnitType> unittypes = new List<UnitType>();
using (SqlCommand cmd2 = new SqlCommand("spGetLoanUnitTypesByLoanId", con))
{
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanSetupStep1.loanId;
//con.Open();
SqlDataReader reader2 = cmd2.ExecuteReader();
while (reader2.Read())
{
UnitType unitType = new UnitType();
unitType.unitTypeId = int.Parse(reader2["unit_type_id"].ToString());
unitType.unitTypeName = reader2["unit_type_name"].ToString();
unittypes.Add(unitType);
}
loanSetupStep1.selectedUnitTypes = unittypes;
return loanSetupStep1;
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
con.Dispose();
}
}
}
internal LoanSetupStep1 GetLoanStepOne(int loanId)
{
LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1();
IList<UnitType> unittypes = new List<UnitType>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
try
{
DataSet dataSet = dataHandler.GetDataSet("spGetLoanStepOneByLoanId", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0)
{
DataRow dataRow = dataSet.Tables[0].Rows[0];
loanSetupStep1.advancePercentage = int.Parse(dataRow["advance"].ToString());
//loanSetupStep1.allUnitTypes
loanSetupStep1.autoReminderEmail = dataRow["auto_remind_email"].ToString();
loanSetupStep1.autoReminderPeriod = int.Parse(dataRow["auto_remind_period"].ToString());
loanSetupStep1.defaultUnitType = int.Parse(dataRow["default_unit_type"].ToString());
loanSetupStep1.isEditAllowable = Convert.ToBoolean(dataRow["is_edit_allowable"].ToString());
loanSetupStep1.isInterestCalculate = Convert.ToBoolean(dataRow["is_interest_calculate"].ToString());
loanSetupStep1.loanAmount = Convert.ToDecimal(dataRow["loan_amount"].ToString());
loanSetupStep1.loanNumber = dataRow["loan_number"].ToString();
//loanSetupStep1.loanNumberForDisplay = loanSetupStep1.loanNumber;
loanSetupStep1.maturityDate = Convert.ToDateTime(dataRow["maturity_date"].ToString());
loanSetupStep1.nonRegisteredBranchId = int.Parse(dataRow["non_reg_branch_id"].ToString());
loanSetupStep1.paymentMethod = dataRow["payment_method"].ToString();
//loanSetupStep1.payOffPeriod = int.Parse(dataRow["pay_off_period"].ToString());
//loanSetupStep1.payOffPeriodType = (Convert.ToChar(dataRow["pay_off_type"].ToString()) == 'd') ? 0 : 1;
//loanSetupStep1.selectedUnitTypes
loanSetupStep1.startDate = Convert.ToDateTime(dataRow["start_date"].ToString());
loanSetupStep1.loanCode = dataRow["loan_code"].ToString();
}
DataSet dataSet2 = dataHandler.GetDataSet("spGetLoanUnitTypesByLoanId", paramertList);
if (dataSet2 != null && dataSet2.Tables.Count != 0 && dataSet2.Tables[0].Rows.Count != 0)
{
foreach (DataRow dataRow2 in dataSet2.Tables[0].Rows)
{
UnitType unitType = new UnitType();
unitType.unitTypeId = int.Parse(dataRow2["unit_type_id"].ToString());
unitType.unitTypeName = dataRow2["unit_type_name"].ToString();
unittypes.Add(unitType);
}
loanSetupStep1.selectedUnitTypes = unittypes;
}
return loanSetupStep1;
}
catch (Exception ex)
{
throw ex;
}
//using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["AutoDealersConnection"].ConnectionString))
//{
// try
// {
// using (SqlCommand cmd = new SqlCommand("spGetLoanStepOneByLoanId", con))
// {
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanId;
// con.Open();
// SqlDataReader reader = cmd.ExecuteReader();
// LoanSetupStep1 loanSetupStep1 = new LoanSetupStep1();
// while (reader.Read())
// {
// loanSetupStep1.advancePercentage = int.Parse(reader["advance"].ToString());
// //loanSetupStep1.allUnitTypes
// loanSetupStep1.autoReminderEmail = reader["auto_remind_email"].ToString();
// loanSetupStep1.autoReminderPeriod = int.Parse(reader["auto_remind_period"].ToString());
// loanSetupStep1.defaultUnitType = int.Parse(reader["default_unit_type"].ToString());
// loanSetupStep1.isEditAllowable = Convert.ToBoolean(reader["is_edit_allowable"].ToString());
// loanSetupStep1.isInterestCalculate = Convert.ToBoolean(reader["is_interest_calculate"].ToString());
// loanSetupStep1.loanAmount = Convert.ToDecimal(reader["loan_amount"].ToString());
// loanSetupStep1.loanNumber = reader["loan_number"].ToString();
// loanSetupStep1.loanNumberForDisplay = loanSetupStep1.loanNumber;
// loanSetupStep1.maturityDate = Convert.ToDateTime(reader["maturity_date"].ToString());
// loanSetupStep1.nonRegisteredBranchId = int.Parse(reader["non_reg_branch_id"].ToString());
// loanSetupStep1.paymentMethod = reader["payment_method"].ToString();
// loanSetupStep1.payOffPeriod = int.Parse(reader["pay_off_period"].ToString());
// loanSetupStep1.payOffPeriodType = (Convert.ToChar(reader["pay_off_type"].ToString()) == 'd') ? 0 : 1;
// //loanSetupStep1.selectedUnitTypes
// loanSetupStep1.startDate = Convert.ToDateTime(reader["start_date"].ToString());
// loanSetupStep1.loanCode = reader["loan_code"].ToString();
// }
// reader.Close();
// IList<UnitType> unittypes = new List<UnitType>();
// using (SqlCommand cmd2 = new SqlCommand("spGetLoanUnitTypesByLoanId", con))
// {
// cmd2.CommandType = CommandType.StoredProcedure;
// cmd2.Parameters.Add("@loan_id", SqlDbType.Int).Value = loanId;
// //con.Open();
// SqlDataReader reader2 = cmd2.ExecuteReader();
// while (reader2.Read())
// {
// UnitType unitType = new UnitType();
// unitType.unitTypeId = int.Parse(reader2["unit_type_id"].ToString());
// unitType.unitTypeName = reader2["unit_type_name"].ToString();
// unittypes.Add(unitType);
// }
// loanSetupStep1.selectedUnitTypes = unittypes;
// return loanSetupStep1;
// }
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
// finally
// {
// con.Close();
// }
//}
}