public IList <AdminViewLoans> GetLoans()
{
DataSet ds = repo.GetLoans();
IList <AdminViewLoans> loansList = new List <AdminViewLoans>();
foreach (DataRow row in ds.Tables[0].Rows)
{
AdminViewLoans detail = new AdminViewLoans();
detail.AccountNumber = Convert.ToInt64(row["account_no"]);
detail.Id = Convert.ToInt32(row["Id"]);
detail.Username = Convert.ToString(row["username"]);
detail.Approval = Convert.ToString(row["approved"]);
detail.ApprovedTime = Convert.ToString(row["approved_time"]);
//detail.ApprovedTime = row["approved_time"] != DBNull.Value ? (DateTime)row["approved_time"] : (DateTime?)null;
detail.LoanAmount = Convert.ToString(row["loan_amount"]);
detail.City = Convert.ToString(row["city"]);
detail.EmpType = Convert.ToString(row["Emp_Type"]);
detail.LoanType = Convert.ToString(row["LoanType"]);
detail.Income = Convert.ToString(row["Income"]);
loansList.Add(detail);
}
return(loansList);
}
public AdminViewLoans VerifierViewLoans(int id)
{
DataSet ds = repo.VerifierGetLoans(id);
// AdminViewLoans loansList = new AdminViewLoans();
AdminViewLoans detail = new AdminViewLoans();
detail.Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Id"]);
detail.Username = Convert.ToString(ds.Tables[0].Rows[0]["username"]);
// detail.Approval = Convert.ToString(row["approved"]);
// detail.ApprovedTime = Convert.ToString(row["approved_time"]);
//detail.ApprovedTime = row["approved_time"] != DBNull.Value ? (DateTime)row["approved_time"] : (DateTime?)null;
detail.AccountNumber = Convert.ToInt64(ds.Tables[0].Rows[0]["account_no"]);
detail.LoanAmount = Convert.ToString(ds.Tables[0].Rows[0]["loan_amount"]);
// detail.City = Convert.ToString(row["city"]);
//detail.EmpType = Convert.ToString(row["Emp_Type"]);
detail.LoanType = Convert.ToString(ds.Tables[0].Rows[0]["LoanType"]);
detail.Income = Convert.ToString(ds.Tables[0].Rows[0]["Income"]);
detail.status = Convert.ToString(ds.Tables[0].Rows[0]["status"]);
detail.withdrawn = Convert.ToString(ds.Tables[0].Rows[0]["withdrawn"]);
return(detail);
}
