public IEnumerable <CustomerFluff> GetActiveCustomers()
{
using (var con = new SqlConnection(connectionString))
{
con.Open();
const string sql = @"SELECT * FROM Customer WHERE IsRetired = 0";
using (var com = new SqlCommand(sql, con))
{
using (var rdr = com.ExecuteReader())
{
while (rdr.Read())
{
var customerFluff = new CustomerFluff()
{
CustomerId = rdr.GetInt32(0),
NameLast = rdr.GetString(1),
NameFirst = rdr.GetString(2),
Comments = rdr.GetString(7)
};
yield return(customerFluff);
}
}
}
}
}
public IEnumerable <CustomerFluff> SearchCustomersByText(string text)
{
using (var con = new SqlConnection(connectionString))
{
con.Open();
const string sql = @"SELECT * FROM Customer WHERE NameLast LIKE '%' + @Text + '%' OR NameFirst LIKE '%' + @Text + '%' OR Comments LIKE '%' + @Text + '%'";
using (var com = new SqlCommand(sql, con))
{
com.Parameters.AddWithValue("Text", text);
using (var rdr = com.ExecuteReader())
{
while (rdr.Read())
{
var customerFluff = new CustomerFluff()
{
CustomerId = rdr.GetInt32(0),
NameLast = rdr.GetString(1),
NameFirst = rdr.GetString(2),
Comments = rdr.GetString(7)
};
yield return(customerFluff);
}
}
}
}
}
