//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);
}
private void InsertOfficialReceipt(string accountCode, string accountTitle, decimal amount)
{
var or = new OfficialReceipt
{
MemberCode = MemberCode,
MemberName = MemberName,
AccountCode = accountCode,
AccountTitle = accountTitle
};
if (accountCode == GlobalSettings.CodeOfCashOnHand)
{
// insert denomination details
or.Debit = amount;
#region --- Cash CashAndCheckBreakDown ---
if (CashAndCheckDenomimation != null)
{
//JEA: Since deno09 is not available (0.50), I use it as lieu to 200
or.Deno01 = CashAndCheckDenomimation.Deno01; //1000
or.Deno02 = CashAndCheckDenomimation.Deno02; //500
or.Deno03 = CashAndCheckDenomimation.Deno03; //100
or.Deno04 = CashAndCheckDenomimation.Deno04; //50
or.Deno05 = CashAndCheckDenomimation.Deno05; //20
or.Deno06 = CashAndCheckDenomimation.Deno06; //10
or.Deno07 = CashAndCheckDenomimation.Deno07; //5
or.Deno08 = CashAndCheckDenomimation.Deno08; //1
or.Deno09 = CashAndCheckDenomimation.Deno09; //.5 -> 200
or.Deno10 = CashAndCheckDenomimation.Deno10; //.25
#endregion --- Cash CashAndCheckBreakDown ---
#region --- Check CashAndCheckBreakDown ---
or.BankName1 = CashAndCheckDenomimation.BankName1;
or.BankDate1 = CashAndCheckDenomimation.BankDate1;
or.BankCheck1 = CashAndCheckDenomimation.BankCheck1;
or.BankAmount1 = CashAndCheckDenomimation.BankAmount1;
or.BankName2 = CashAndCheckDenomimation.BankName2;
or.BankDate2 = CashAndCheckDenomimation.BankDate2;
or.BankCheck2 = CashAndCheckDenomimation.BankCheck2;
or.BankAmount2 = CashAndCheckDenomimation.BankAmount2;
or.BankName3 = CashAndCheckDenomimation.BankName3;
or.BankDate3 = CashAndCheckDenomimation.BankDate3;
or.BankCheck3 = CashAndCheckDenomimation.BankCheck3;
or.BankAmount3 = CashAndCheckDenomimation.BankAmount3;
or.BankName4 = CashAndCheckDenomimation.BankName4;
or.BankDate4 = CashAndCheckDenomimation.BankDate4;
or.BankCheck4 = CashAndCheckDenomimation.BankCheck4;
or.BankAmount4 = CashAndCheckDenomimation.BankAmount4;
or.BankName5 = CashAndCheckDenomimation.BankName5;
or.BankDate5 = CashAndCheckDenomimation.BankDate5;
or.BankCheck5 = CashAndCheckDenomimation.BankCheck5;
or.BankAmount5 = CashAndCheckDenomimation.BankAmount5;
}
#endregion
or.AmountInWords = AmountInWords;
or.Amount = TotalAmount;
}
else
{
or.Credit = amount;
}
or.VoucherDate = VoucherDate;
or.VoucherNo = VoucherNumber;
or.VoucherType = VoucherTypes.OR;
or.Collector = CollectorName;
or.IsPosted = true;
if (accountCode == GlobalSettings.CodeOfTimeDeposit)
{
if (TimeDepositDetail != null)
{
or.TimeDepositDetails = TimeDepositDetail;
}
}
or.Create();
}
public Result Destroy()
{
Action delete = () => OfficialReceipt.DeleteAll(_voucherNumber);
return(ActionController.InvokeAction(delete));
}
