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