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