public List <Lender> AllLenders() { SqlConnection connection = CurrentConnection(); SqlCommand command; SqlDataReader reader; List <Lender> allLenders = new List <Lender>(); string query = "SELECT * FROM Lender ORDER BY Name"; command = new SqlCommand(query, connection); connection.Open(); reader = command.ExecuteReader(); while (reader.Read()) { Lender newLender = new Lender(); newLender.LenderID = reader["LenderID"].ToString(); newLender.Name = reader["Name"].ToString(); newLender.Address = reader["Address"].ToString(); newLender.City = reader["City"].ToString(); newLender.State = reader["State"].ToString(); newLender.Zip = reader["Zip"].ToString(); newLender.Phone = reader["Phone"].ToString(); newLender.Fax = reader["Fax"].ToString(); newLender.IDType = reader["IDType"].ToString(); newLender.IDNumber = reader["IDNumber"].ToString(); newLender.Notes = reader["Notes"].ToString(); allLenders.Add(newLender); } return(allLenders); }
public Lender(string lenderID) { SqlConnection connection = CurrentConnection(); SqlCommand command; SqlDataReader reader; string query = "SELECT * FROM Lender WHERE LenderID = @LenderID"; Lender newLender = new Lender(); command = new SqlCommand(query, connection); command.Parameters.AddWithValue("@LenderID", lenderID); connection.Open(); reader = command.ExecuteReader(); while (reader.Read()) { newLender.LenderID = lenderID; newLender.Name = reader["Name"].ToString(); newLender.Address = reader["Address"].ToString(); newLender.City = reader["City"].ToString(); newLender.State = reader["State"].ToString(); newLender.Zip = reader["Zip"].ToString(); newLender.Phone = reader["Phone"].ToString(); newLender.Fax = reader["Fax"].ToString(); newLender.IDType = reader["IDType"].ToString(); newLender.IDNumber = reader["IDNumber"].ToString(); newLender.Notes = reader["Notes"].ToString(); } connection.Close(); }