/* Frontend page: Curtailment Page Title: Get curtailment shedule details using due date Designed: Irfan Mam User story: Developed: Irfan MAM Date created: 3/17/2016 */ public List<CurtailmentShedule> GetCurtailmentScheduleByDueDate( int loanId , DateTime dueDate) { try { List<CurtailmentShedule> lstCurtailmentShedule = new List<CurtailmentShedule>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); // add the parametets for list paramertList.Add(new object[] { "@loan_id", loanId }); paramertList.Add(new object[] { "@due_date", dueDate }); // executing the stored proceture and get return list of curtailment DataSet dataSet = dataHandler.GetDataSet("spGetCurtailmentSheduleByDueDate", paramertList); //if there is data if (dataSet != null && dataSet.Tables.Count != 0) { // bind the datas to list foreach (DataRow dataRow in dataSet.Tables[0].Rows) { CurtailmentShedule curtailment = new CurtailmentShedule(); curtailment.UnitId = dataRow["unit_id"].ToString(); curtailment.LoanId = int.Parse(dataRow["loan_id"].ToString()); curtailment.Year = int.Parse(dataRow["year"].ToString()); curtailment.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"].ToString()).ToString("MM/dd/yyyy"); curtailment.DueDate = Convert.ToDateTime(dataRow["curt_due_date"].ToString()).ToString("MM/dd/yyyy"); curtailment.Status = Convert.ToInt32(dataRow["curt_status"].ToString()); curtailment.CurtAmount = Convert.ToDecimal(dataRow["curt_amount"].ToString()); curtailment.IDNumber = dataRow["identification_number"].ToString(); curtailment.CurtNumber = int.Parse(dataRow["curt_number"].ToString()); curtailment.Make = dataRow["make"].ToString(); curtailment.Model = dataRow["model"].ToString(); curtailment.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"].ToString()).ToString("MM/dd/yyyy"); lstCurtailmentShedule.Add(curtailment); } return lstCurtailmentShedule; } // if there is no data else { return null; } } catch (Exception ex) { throw ex; } }
/* Frontend page: Report viewr(Report Page) Title: Get curtailment details of units by date range Designed: Kanishk SHM User story: Developed: Kanishk SHM Date created: */ public List<CurtailmentShedule> GetCurtailmentScheduleByDateRange(int loanId, DateTime dueDateStart, DateTime dueDateEnd) { List<CurtailmentShedule> lstCurtailmentShedule = new List<CurtailmentShedule>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); paramertList.Add(new object[] { "@due_date_start", dueDateStart }); paramertList.Add(new object[] { "@due_date_end", dueDateEnd }); decimal totalDue = 0.00M; DataSet dataSet = dataHandler.GetDataSet("spGetCurtailmentSheduleByDateRange", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { CurtailmentShedule curtailment = new CurtailmentShedule(); curtailment.UnitId = dataRow["unit_id"].ToString(); curtailment.LoanId = Convert.ToInt32(dataRow["loan_id"]); curtailment.Year = Convert.ToInt32(dataRow["year"]); curtailment.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"].ToString()).ToString("MM/dd/yyyy"); curtailment.DueDate = Convert.ToDateTime(dataRow["curt_due_date"].ToString()).ToString("MM/dd/yyyy"); curtailment.Status = Convert.ToInt32(dataRow["curt_status"]); curtailment.CurtAmount = Convert.ToDecimal(dataRow["curt_amount"]); curtailment.IDNumber = dataRow["identification_number"].ToString(); curtailment.CurtNumber = Convert.ToInt32(dataRow["curt_number"]); curtailment.Make = dataRow["make"].ToString(); curtailment.Model = dataRow["model"].ToString(); curtailment.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"].ToString()).ToString("MM/dd/yyyy"); curtailment.PurchasePrice = Convert.ToDecimal(dataRow["cost"]); totalDue = totalDue + Convert.ToDecimal(dataRow["curt_amount"]); lstCurtailmentShedule.Add(curtailment); } if (lstCurtailmentShedule.Count > 0) lstCurtailmentShedule[0].TotalAmountDue = totalDue; return lstCurtailmentShedule; } return null; }
/* Frontend page: Report viewr(Report Page) Title: Get curtailment payment details of units by date range Designed: Kanishk SHM User story: Developed: Kanishk SHM Date created: */ public List<CurtailmentShedule> GetCurtailmentPaidDetailsByDateRange(int loanId, DateTime paidDateStart, DateTime paidDateEnd) { List<CurtailmentShedule> lstCurtailmentShedule = new List<CurtailmentShedule>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); paramertList.Add(new object[] { "@paid_date_start", paidDateStart }); paramertList.Add(new object[] { "@paid_date_end", paidDateEnd }); decimal totalpaid = 0.00M; DataSet dataSet = dataHandler.GetDataSet("spGetCurtailmentPaidDetailsByDateRange", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { CurtailmentShedule curtailment = new CurtailmentShedule(); curtailment.LoanId = Convert.ToInt32(dataRow["loan_id"]); curtailment.UnitId = dataRow["UnitId"].ToString(); curtailment.IDNumber = dataRow["identification_number"].ToString(); curtailment.Year = Convert.ToInt32(dataRow["year"]); curtailment.Make = dataRow["make"].ToString(); curtailment.Model = dataRow["model"].ToString(); curtailment.PurchasePrice = Convert.ToDecimal(dataRow["cost"]); curtailment.CurtNumber = Convert.ToInt32(dataRow["curt_number"]); curtailment.PaidDate = Convert.ToDateTime(dataRow["paid_date"].ToString()).ToString("MM/dd/yyyy"); curtailment.CurtAmount = Convert.ToDecimal(dataRow["curt_amount"]); curtailment.PaidCurtAmount = Convert.ToDecimal(dataRow["CurtPaidAmount"]); curtailment.AdvanceDate = Convert.ToDateTime(dataRow["paid_date"].ToString()).ToString("MM/dd/yyyy"); totalpaid = totalpaid + Convert.ToDecimal(dataRow["CurtPaidAmount"]); lstCurtailmentShedule.Add(curtailment); } for (int i = 0; i < lstCurtailmentShedule.Count; i++) lstCurtailmentShedule[i].TotalAmountPaid = totalpaid; } return lstCurtailmentShedule; }
/// <summary> /// CreatedBy: Kanishka /// CreatedDate: 5/28/2016 /// Get unit cost by unit id list /// </summary> /// <param name="xmlDoc"></param> /// <returns></returns> public List<CurtailmentShedule> GetCurtailmentPaidDetailsDuringSession(string xmlDoc) { List<CurtailmentShedule> lstCurtailmentShedule = new List<CurtailmentShedule>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@Input", xmlDoc }); DataSet dataSet = dataHandler.GetDataSet("spGetCurtailmentPaidDetailsDuringSession", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { CurtailmentShedule curtailment = new CurtailmentShedule(); curtailment.UnitId = dataRow["unit_id"].ToString(); curtailment.PurchasePrice = Convert.ToDecimal(dataRow["cost"]); lstCurtailmentShedule.Add(curtailment); } } return lstCurtailmentShedule; }