//public static int FirstDocumentNo()
//{
// var sqlBuilder = new StringBuilder();
// sqlBuilder.AppendFormat("SELECT MIN(DOC_NUM) FROM `{0}`", TableName);
// var dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString());
// var docNum = 0;
// if (dataTable.Rows.Count > 0)
// {
// docNum = DataConverter.ToInteger(dataTable.Rows[0][0]);
// }
// return docNum;
//}
//public static int LastDocumentNo()
//{
// var sqlBuilder = new StringBuilder();
// sqlBuilder.AppendFormat("SELECT MAX(DOC_NUM) FROM `{0}`", TableName);
// var dataTable = DatabaseController.ExecuteSelectQuery(sqlBuilder.ToString());
// var docNum = 0;
// if (dataTable.Rows.Count > 0)
// {
// docNum = DataConverter.ToInteger(dataTable.Rows[0][0]);
// }
// return docNum;
//}
public static ObservableCollection <OfficialReceipt> 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 <OfficialReceipt>();
foreach (DataRow dataRow in dataTable.Rows)
{
var foundRecord = new OfficialReceipt();
foundRecord.SetPropertiesFromDataRow(dataRow);
listRecord.Add(foundRecord);
}
return(listRecord);
}
public static ObservableCollection <OfficialReceipt> 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 <OfficialReceipt>();
foreach (DataRow dataRow in dataTable.Rows)
{
var foundRecord = new OfficialReceipt();
foundRecord.SetPropertiesFromDataRow(dataRow);
listRecord.Add(foundRecord);
}
return(listRecord);
}
