internal static ForwardedBalanceCollection CollectAll() { var dataTable = DatabaseController.ExecuteSelectQuery("SELECT * FROM " + TABLE_NAME); var collection = new ForwardedBalanceCollection(); foreach (DataRow dataRow in dataTable.Rows) { var item = new ForwardedBalance(); item.SetPropertiesFromDataRow(dataRow); collection.Add(item); } return(collection); }
public static ObservableCollection <ForwardedBalance> WhereMemberCodeIs(string memberCode) { var sqlBuilder = new StringBuilder(); sqlBuilder.AppendFormat("SELECT * FROM `{0}` WHERE MEM_CODE = ?MEM_CODE", TABLE_NAME); DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), new SqlParameter("?MEM_CODE", memberCode)); var listRecord = new ObservableCollection <ForwardedBalance>(); foreach (DataRow dataRow in dataTable.Rows) { var foundRecord = new ForwardedBalance(); foundRecord.SetPropertiesFromDataRow(dataRow); listRecord.Add(foundRecord); } return(listRecord); }