public static ObservableCollection <CashVoucher> WhereDocumentNumberIs(int documentNo)
{
var sqlBuilder = new StringBuilder();
sqlBuilder.AppendFormat("SELECT * FROM `{0}` WHERE DOC_NUM = ?DOC_NUM", TABLE_NAME);
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString(), new SqlParameter("?DOC_NUM", documentNo));
var listRecord = new ObservableCollection <CashVoucher>();
foreach (DataRow dataRow in dataTable.Rows)
{
var foundRecord = new CashVoucher();
foundRecord.SetPropertiesFromDataRow(dataRow);
listRecord.Add(foundRecord);
}
return(listRecord);
}
internal static ObservableCollection <CashVoucher> 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 <CashVoucher>();
foreach (DataRow dataRow in dataTable.Rows)
{
var foundRecord = new CashVoucher();
foundRecord.SetPropertiesFromDataRow(dataRow);
listRecord.Add(foundRecord);
}
return(listRecord);
}
public static List <CashVoucher> FindBy(string columnName, object value)
{
var key = new SqlParameter("?" + columnName, value);
string sql = DatabaseController.GenerateSelectStatement(TABLE_NAME, key);
var list = new List <CashVoucher>();
DataTable dataTable = DatabaseController.ExecuteSelectQuery(sql, key);
foreach (DataRow dataRow in dataTable.Rows)
{
var cv = new CashVoucher();
cv.SetPropertiesFromDataRow(dataRow);
list.Add(cv);
}
return(list);
}
