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