public int insertFreeDetailsForPayOffPage(UnitPayOffModel unit, DateTime payday,int userID) { try { string fee_type = ""; string fee_due_method = ""; decimal fee_amount = 0; DateTime fee_billdate = payday; string v_vin = "", v_year = "", v_model = "", v_make = "", v_advance_date = ""; DataHandler dataHandler = new DataHandler(); List<object[]> paramertList1 = new List<object[]>(); paramertList1.Add(new object[] { "@loan_id", unit.LoanId }); DataSet dataSet = dataHandler.GetDataSet("spGetAdvanceFeeData", paramertList1); if (dataSet != null && dataSet.Tables.Count != 0 && dataSet.Tables[0].Rows.Count != 0) { foreach (DataRow row in dataSet.Tables[0].Rows) { fee_due_method = row["payment_due_method"].ToString(); fee_type = row["advance_fee_calculate_type"].ToString(); fee_amount = decimal.Parse(row["advance_fee_amount"].ToString()); } } v_vin = unit.IdentificationNumber; v_make = unit.Make; v_model = unit.Model; v_year = unit.Year.ToString(); v_advance_date = unit.DateAdvanced.ToString("MM/dd/yyyy");// ("MM/dd/yyyy"); string discription = fee_due_method + "," + v_vin + "," + v_year + "," + v_make + "," + v_model + "," + v_advance_date; if (fee_due_method == "Vehicle Payoff") { List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", unit.LoanId }); paramertList.Add(new object[] { "@unit_id", unit.UnitId }); paramertList.Add(new object[] { "@type", "advanceFee" }); paramertList.Add(new object[] { "@description", discription }); paramertList.Add(new object[] { "@amount", fee_amount }); paramertList.Add(new object[] { "@due_date", fee_billdate }); paramertList.Add(new object[] { "@bill_due_date", fee_billdate }); paramertList.Add(new object[] { "@user_id", userID }); dataHandler.ExecuteSQL("spInsertAdvanceFeeForPayoff", paramertList); } return 0; } catch (Exception ex) { throw ex; } }
/// <summary> /// CreatedBy : Kanishka /// CreatedDate: 2016/03/17 /// /// Insert curtailment breakdown details /// /// /// </summary> public List<UnitPayOffModel> GetUnitPayOffList(int loanId) { try { List<UnitPayOffModel> payOffList = new List<UnitPayOffModel>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); DataSet dataSet = dataHandler.GetDataSet("spRetriveUnitPayoff", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { UnitPayOffModel payoff = new UnitPayOffModel(); payoff.LoanId = loanId; payoff.UnitId = dataRow["UnitId"].ToString(); payoff.DateEntered = DateTime.Parse(dataRow["created_date"].ToString()); payoff.IdentificationNumber = dataRow["identification_number"].ToString(); payoff.Year = Convert.ToInt32(dataRow["year"]); payoff.Make = dataRow["make"].ToString(); payoff.Model = dataRow["model"].ToString(); payoff.PurchasePrice = Convert.ToDecimal(dataRow["cost"].ToString()); payoff.Balance = Convert.ToDecimal(dataRow["Balance"].ToString()); payoff.DateAdvanced = Convert.ToDateTime(dataRow["advance_date"].ToString()); payoff.IsAdvancePaid = dataRow["is_paid"] == DBNull.Value || Convert.ToBoolean(dataRow["is_paid"]); payOffList.Add(payoff); } return payOffList; } else { return payOffList; } } catch (Exception ex) { throw ex; } }