internal static MembershipTypeCollection CollectAll()
{
var dataTable = DatabaseController.ExecuteSelectQuery("SELECT * FROM " + TABLE_NAME);
var collection = new MembershipTypeCollection();
foreach (DataRow dataRow in dataTable.Rows)
{
var item = new MembershipType();
item.SetPropertiesFromDataRow(dataRow);
collection.Add(item);
}
return(collection);
}
internal static MembershipType FindByName(string description)
{
MembershipType area = null;
var sqlBuilder = new System.Text.StringBuilder();
sqlBuilder.AppendLine("SELECT * FROM ");
sqlBuilder.AppendLine(TABLE_NAME);
sqlBuilder.AppendLine("WHERE Description = ?Description");
sqlBuilder.AppendLine("LIMIT 1");
var sqlParameter = new SqlParameter("?Description", description);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder, sqlParameter);
if (dataTable.Rows.Count > 0)
{
area = new MembershipType();
foreach (DataRow dataRow in dataTable.Rows)
{
area.SetPropertiesFromDataRow(dataRow);
}
}
return(area);
}
