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