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(); } }