/* Frontend page: Report viewr(Report Page) Title: Get advance unit details(this session) Designed: Kanishk SHM User story: Developed: Kanishk SHM Date created: */ public List<RptAddUnit> AdvanceUnitsDuringSession(string unitIdList) { List<RptAddUnit> AdvanceUnits = new List<RptAddUnit>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@Input", unitIdList }); try { DataSet dataSet = dataHandler.GetDataSet("spGetAdvanceUnitsDuringSession", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { RptAddUnit unit = new RptAddUnit(); unit.LoanId = Convert.ToInt32(dataRow["loan_id"]); unit.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"]).ToString("MM/dd/yyy"); unit.IdentificationNumber = dataRow["identification_number"].ToString(); unit.Year = Convert.ToInt32(dataRow["year"]); unit.Make = dataRow["make"].ToString(); unit.Model = dataRow["model"].ToString(); unit.AdvanceAmount = (dataRow["advance_amount"]) != DBNull.Value ? (Decimal)dataRow["advance_amount"] : (Decimal)0.00M; int status = Convert.ToInt32(dataRow["title_status"]); if (status == 0) { unit.TitleStatus = "Not Received"; } else if (status == 1) { unit.TitleStatus = "Received"; } else if (status == 2) { unit.TitleStatus = "Returned to Dealer"; } AdvanceUnits.Add(unit); } } } catch (Exception ex) { throw ex; } return AdvanceUnits; }
/// <summary> /// CreatedBy:Irfan /// CreatedDate:2016/2/24 /// Get just added units by loan id and user id /// </summary> /// <param name="loanId"></param> /// <returns>list of units</returns> public List<RptAddUnit> GetJustAddedUnitDetails(int userId, int loanId) { List<RptAddUnit> justAddedUnitList = new List<RptAddUnit>(); DataHandler dataHandler = new DataHandler(); List<object[]> paramertList = new List<object[]>(); paramertList.Add(new object[] { "@loan_id", loanId }); paramertList.Add(new object[] { "@user_id", userId }); DataSet dataSet = dataHandler.GetDataSet("spGetJustAddedUnitsByLoanId", paramertList); if (dataSet != null && dataSet.Tables.Count != 0) { foreach (DataRow dataRow in dataSet.Tables[0].Rows) { RptAddUnit justAddedUnit = new RptAddUnit(); justAddedUnit.AddDate = !dataRow.IsNull("created_date") ? Convert.ToDateTime(dataRow["created_date"]).ToString("MM/dd/yyy") : ""; justAddedUnit.AdvanceDate = !dataRow.IsNull("advance_date") ? Convert.ToDateTime(dataRow["advance_date"]).ToString("MM/dd/yyy") : ""; justAddedUnit.IdentificationNumber = dataRow["identification_number"].ToString(); justAddedUnit.Year = Convert.ToInt32(dataRow["year"]); justAddedUnit.Make = dataRow["make"].ToString(); justAddedUnit.Model = dataRow["model"].ToString(); justAddedUnit.PurchasePrice = (dataRow["cost"]) != DBNull.Value ? (Decimal)dataRow["cost"] : (Decimal)0.00M; justAddedUnit.AdvanceAmount = (dataRow["advance_amount"]) != DBNull.Value ? (Decimal)dataRow["advance_amount"] : (Decimal)0.00M; justAddedUnit.UnitStaus = Convert.ToBoolean(dataRow["is_advanced"]) ? "Advanced" : "Not Advanced"; int status = Convert.ToInt32(dataRow["title_status"]); if (status == 0) { justAddedUnit.TitleStatus = "Not Received"; } else if (status == 1) { justAddedUnit.TitleStatus = "Received"; } else if (status == 2) { justAddedUnit.TitleStatus = "Returned to Dealer"; } justAddedUnitList.Add(justAddedUnit); } } return justAddedUnitList; }