public IList <ApproveLoans> GetUnApprovedLoans()
{
DataSet ds = repo.GetUnApprovedLoans();
IList <ApproveLoans> loansList = new List <ApproveLoans>();
foreach (DataRow row in ds.Tables[0].Rows)
{
ApproveLoans detail = new ApproveLoans();
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 void approveLoans(ApproveLoans al)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = Constants.connectionString;
con.Open();
try
{
SqlCommand cmd = new SqlCommand("approveloans", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", al.Id);
cmd.Parameters.AddWithValue("@accountno", al.AccountNumber);
cmd.Parameters.AddWithValue("@bal", al.Amount);
cmd.Parameters.AddWithValue("@appAccountNo", al.ApprovingAccountNumber);
cmd.ExecuteNonQuery();
}
finally
{
con.Close();
}
}
