public List<ReportFullInventoryUnit> GetAdvanceUnitByLoanId(int loanId, DateTime advanceDateStart, DateTime advanceDateEnd)
{
List<ReportFullInventoryUnit> units = new List<ReportFullInventoryUnit>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
paramertList.Add(new object[] { "@advance_date_start", advanceDateStart });
paramertList.Add(new object[] { "@advance_date_end", advanceDateEnd });
DataSet dataSet = dataHandler.GetDataSet("spRptAdvanceUnitByDateRange", paramertList);
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
ReportFullInventoryUnit unit = new ReportFullInventoryUnit();
unit.IdentificationNumber = dataRow["identification_number"].ToString();
unit.Year = Convert.ToInt32(dataRow["year"]);
unit.Make = dataRow["make"].ToString();
unit.Model = dataRow["model"].ToString();
unit.PurchasePrice = Convert.ToDecimal(dataRow["cost"]);
unit.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"]).ToString("MM/dd/yyyy");
unit.AdvanceAmount = Convert.ToDecimal(dataRow["advance_amount"]);
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";
}
units.Add(unit);
}
}
return units;
}
/*
Frontend page: Report viewr(Report Page)
Title: Get all active unit details
Designed: Kanishk SHM
User story:
Developed: Kanishk SHM
Date created:
*/
public List<ReportFullInventoryUnit> GetFullInventoryByLoanId(int loanId)
{
List<ReportFullInventoryUnit> units = new List<ReportFullInventoryUnit>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
paramertList.Add(new object[] { "@loan_id", loanId });
DataSet dataSet = dataHandler.GetDataSet("spGetFullInventoryByLoanId", paramertList);
decimal loanBalance = 0.00M;
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
ReportFullInventoryUnit unit = new ReportFullInventoryUnit();
unit.AdvanceDate = Convert.ToDateTime(dataRow["advance_date"]).ToString("MM/dd/yyyy");
unit.IdentificationNumber = dataRow["identification_number"].ToString();
unit.Year = Convert.ToInt32(dataRow["year"]);
unit.Make = dataRow["make"].ToString();
unit.Model = dataRow["model"].ToString();
unit.PurchasePrice = Convert.ToDecimal(dataRow["cost"]);
unit.AdvanceAmount = Convert.ToDecimal(dataRow["advance_amount"]);
unit.TotalCurtPaid = Convert.ToDecimal(dataRow["TotalPaid"]);
unit.BalanceDue = Convert.ToDecimal(dataRow["Balance"]);
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";
}
loanBalance += unit.BalanceDue;
units.Add(unit);
}
if (units.Count > 0)
units[0].LoanBalance = loanBalance;
}
return units;
}