public void PrintTerminalReportDetailsXRead(Data.TerminalReportDetails Details)
{
Cursor.Current = Cursors.WaitCursor;
try
{
Data.SysConfig clsSysConfig = new Data.SysConfig(mConnection, mTransaction);
mConnection = clsSysConfig.Connection; mTransaction = clsSysConfig.Transaction;
if (Int64.Parse(Details.BeginningORNo) == 0)
msbToPrint.Append("Beginning OR No.".PadRight(21) + ":" + (Details.BeginningORNo.Remove(Details.BeginningORNo.Length - 1) + "1").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
else
msbToPrint.Append("Beginning OR No.".PadRight(21) + ":" + Details.BeginningORNo.PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Ending OR No.".PadRight(21) + ":" + Details.EndingORNo.PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine + Environment.NewLine);
msbToPrint.Append("Gross Sales".PadRight(21) + ":" + ((Details.GrossSales + Details.TotalCharge) * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("(-) Service Charge".PadRight(21) + ":" + (Details.TotalCharge * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("".PadRight(21) + ":" + "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22, ' ') + Environment.NewLine);
msbToPrint.Append("Total Amount".PadRight(21) + ":" + (Details.GrossSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(("(-) " + mclsTerminalDetails.VAT.ToString("##") + "% VAT Exempt").PadRight(21) + ":" + (Details.VATExempt * (mclsTerminalDetails.VAT / 100) * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("(-) Discount".PadRight(21) + ":" + ((Details.SubTotalDiscount + Details.ItemsDiscount) * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("".PadRight(21) + ":" + "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22, ' ') + Environment.NewLine);
msbToPrint.Append("Net Sales".PadRight(21) + ":" + (Details.NetSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
if (mclsTerminalDetails.WillPrintGrandTotal == true)
{
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("OLD GRAND TOTAL".PadRight(21) + ":" + (Details.eSalesOldGrandTotal).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("This Total Amount".PadRight(21) + ":" + (Details.GrossSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("".PadRight(21) + ":" + "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22, ' ') + Environment.NewLine);
msbToPrint.Append("NEW GRAND TOTAL".PadRight(21) + ":" + (Details.eSalesNewGrandTotal).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
mclsSysConfigDetails.WillDeductTFInTerminalReport = clsSysConfig.get_WillDeductTFInTerminalReport();
}
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Taxables Breakdown", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("VAT Exempt".PadRight(21) + ":" + (Details.VATExempt * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("VAT Zero Rated".PadRight(21) + ":" + (Details.ZeroRatedSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("NonVATable Amount".PadRight(21) + ":" + (Details.NonVATableAmount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("VATable Amount".PadRight(21) + ":" + (Details.VATableAmount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("VAT".PadRight(21) + ":" + (Details.VAT * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Local Tax".PadRight(21) + ":" + (Details.LocalTax * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Total Amount Breakdown", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Cash Sales".PadRight(21) + ":" + (Details.CashSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Cheque Sales".PadRight(21) + ":" + (Details.ChequeSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Card Sales".PadRight(21) + ":" + (Details.CreditCardSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit (Charge)".PadRight(21) + ":" + (Details.CreditSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Payment".PadRight(21) + ":" + (Details.CreditPayment * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Cash".PadRight(21) + ":" + (Details.CreditPaymentCash * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Cheque".PadRight(21) + ":" + (Details.CreditPaymentCheque * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Credit Card".PadRight(21) + ":" + (Details.CreditPaymentCreditCard * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Debit".PadRight(21) + ":" + (Details.CreditPaymentDebit * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Debit Sales".PadRight(21) + ":" + (Details.DebitPayment * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("RewardPoints Redeemd".PadRight(21) + ":" + Details.RewardPointsPayment.ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Cash Equivalent".PadRight(21) + ":" + (Details.RewardConvertedPayment * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Employee Acct.".PadRight(21) + ":" + "0.00".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Void Sales".PadRight(21) + ":" + (Details.VoidSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Refund Sales".PadRight(21) + ":" + (Details.RefundSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Cash".PadRight(21) + ":" + (Details.RefundCash * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Cheque".PadRight(21) + ":" + (Details.RefundCheque * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Credit Card".PadRight(21) + ":" + (Details.RefundCreditCard * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Credit".PadRight(21) + ":" + (Details.RefundCredit * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Debit".PadRight(21) + ":" + (Details.RefundDebit * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
Data.SalesTransactions clsSalesTransactions = new Data.SalesTransactions(mConnection, mTransaction);
mConnection = clsSalesTransactions.Connection; mTransaction = clsSalesTransactions.Transaction; // CashierID = 0 ALL
System.Data.DataTable dt = clsSalesTransactions.SalesPerCreditCard(Details.BranchID, Details.TerminalNo, 0, Details.DateLastInitialized, Details.NEXTDateLastInitialized);
clsSalesTransactions.CommitAndDispose();
if (dt.Rows.Count > 0)
{
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Credit Card Breakdown", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
foreach (System.Data.DataRow dr in dt.Rows)
{ msbToPrint.Append(dr["CardTypeCode"].ToString().PadRight(21) + ":" + (Convert.ToDecimal(dr["Amount"].ToString()) * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine); }
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
}
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Discounts", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Items Discount".PadRight(21) + ":" + (Details.ItemsDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Senior Citizen".PadRight(21) + ":" + (Details.SNRItemsDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" PWD".PadRight(21) + ":" + (Details.PWDItemsDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Other".PadRight(21) + ":" + (Details.OtherItemsDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Subtotal Discount".PadRight(21) + ":" + (Details.SubTotalDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Senior Citizen".PadRight(21) + ":" + (Details.SNRDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" PWD".PadRight(21) + ":" + (Details.PWDDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append(" Others".PadRight(21) + ":" + (Details.OtherDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("".PadRight(21) + ":" + "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22, ' ') + Environment.NewLine);
msbToPrint.Append("Total Discounts".PadRight(21) + ":" + (Details.TotalDiscount * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
clsSalesTransactions = new Data.SalesTransactions(mConnection, mTransaction);
mConnection = clsSalesTransactions.Connection; mTransaction = clsSalesTransactions.Transaction;
dt = clsSalesTransactions.Discounts(Details.BranchID, Details.TerminalNo, Details.BeginningTransactionNo, Details.EndingTransactionNo);
clsSalesTransactions.CommitAndDispose();
clsSysConfig.CommitAndDispose();
if (dt.Rows.Count > 0)
{
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Subtotal Discounts Breakdown", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
foreach (System.Data.DataRow dr in dt.Rows)
{ msbToPrint.Append(dr["DiscountCode"].ToString().PadRight(21) + ":" + (Convert.ToDecimal(dr["Discount"].ToString()) * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine); }
}
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Drawer Information", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Beginning Balance".PadRight(21) + ":" + (Details.BeginningBalance).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Cash-In-Drawer".PadRight(21) + ":" + (Details.BeginningBalance + ((Details.CashInDrawer - Details.BeginningBalance) * ((100 - Details.TrustFund) / 100))).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Paid Out", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Paid Out".PadRight(21) + ":" + (Details.TotalPaidOut * ((100 - Details.TrustFund) / 100)).ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("PICK UP / Disburstment", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Cash".PadRight(21) + ":" + (Details.CashDisburse * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Cheque".PadRight(21) + ":" + (Details.ChequeDisburse * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Card".PadRight(21) + ":" + (Details.CreditCardDisburse * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Receive on Account", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Cash".PadRight(21) + ":" + (Details.CashWithHold * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Cheque".PadRight(21) + ":" + (Details.ChequeWithHold * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Card".PadRight(21) + ":" + (Details.CreditCardWithHold * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Customer Deposits", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Cash".PadRight(21) + ":" + (Details.CashDeposit * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Cheque".PadRight(21) + ":" + (Details.ChequeDeposit * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Card".PadRight(21) + ":" + (Details.CreditCardDeposit * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append(CenterString("Transaction Count Breakdown", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
msbToPrint.Append("Cash Transactions".PadRight(21) + ":" + Details.NoOfCashTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Cheque Transactions".PadRight(21) + ":" + Details.NoOfChequeTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Card Trans.".PadRight(21) + ":" + Details.NoOfCreditCardTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Transactions".PadRight(21) + ":" + Details.NoOfCreditTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Debit Payment Trans.".PadRight(21) + ":" + Details.NoOfDebitPaymentTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Refund Transactions".PadRight(21) + ":" + Details.NoOfRefundTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Void Transactions".PadRight(21) + ":" + Details.NoOfVoidTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Combination Tran".PadRight(21) + ":" + Details.NoOfCombinationPaymentTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Credit Payment Trans".PadRight(21) + ":" + Details.NoOfCreditPaymentTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("Reward Points Trans".PadRight(21) + ":" + Details.NoOfRewardPointsPayment.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
// msbToPrint.Append("Employees Acct Trans".PadRight(21) + ":" + "0".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("".PadRight(21) + ":" + "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22, ' ') + Environment.NewLine);
msbToPrint.Append("Total Transactions".PadRight(21) + ":" + Details.NoOfTotalTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
//msbToPrint.Append(CenterString("Misc Amount Breakdown", mclsTerminalDetails.MaxReceiptWidth) + Environment.NewLine);
//msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
//msbToPrint.Append("Consignment".PadRight(21) + ":" + (Details.ConsignmentSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Walk-In".PadRight(21) + ":" + (Details.WalkInSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Out Of Stock".PadRight(21) + ":" + (Details.OutOfStockSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append(" Refund:" + Environment.NewLine);
//msbToPrint.Append("Consignment".PadRight(21) + ":" + (Details.ConsignmentRefundSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Walk-In".PadRight(21) + ":" + (Details.WalkInRefundSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Out Of Stock".PadRight(21) + ":" + (Details.OutOfStockRefundSales * ((100 - Details.TrustFund) / 100)).ToString("#,##0.#0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("".PadRight(21) + ":" + "------------".PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22, ' ') + Environment.NewLine);
//msbToPrint.Append("Consignment Trans".PadRight(21) + ":" + Details.NoOfConsignmentTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Walk-In Trans".PadRight(21) + ":" + Details.NoOfWalkInTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Out Of StockTrans".PadRight(21) + ":" + Details.NoOfOutOfStockTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append(" Refund:" + Environment.NewLine);
//msbToPrint.Append("Consignment Trans".PadRight(21) + ":" + Details.NoOfConsignmentRefundTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Walk-In Trans".PadRight(21) + ":" + Details.NoOfWalkInRefundTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
//msbToPrint.Append("Out Of Stock Trans".PadRight(21) + ":" + Details.NoOfOutOfStockRefundTransactions.ToString("#,##0").PadLeft(mclsTerminalDetails.MaxReceiptWidth - 22) + Environment.NewLine);
msbToPrint.Append("-".PadRight(mclsTerminalDetails.MaxReceiptWidth, '-') + Environment.NewLine);
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Printing terminal report details. Err Description: ");
}
Cursor.Current = Cursors.Default;
}
private void MainWnd_KeyDown(object sender, KeyEventArgs e)
{
try
{
if (e.KeyData == Keys.F1)
{
ShowHelp();
}
else if (mboLocked && e.KeyData == Keys.F2)
{ this.PriceInquiry(); }
else if (e.KeyData == Keys.Escape)
{
if (txtBarCode.Text != string.Empty)
{ txtBarCode.Text = string.Empty; txtBarCode.Focus(); }
else
{ this.Exit(); }
}
else if (mboLocked)
{
if (Control.ModifierKeys == Keys.Control && e.KeyCode == Keys.L)
LoggedOutCashier(true);
else if (e.KeyData == Keys.Enter)
this.DoLogin();
}
else if (!mboLocked)
{
// 15Jun2015 : Do not allow to do anything in Closed Transaction
if (mclsSalesTransactionDetails.TransactionStatus == TransactionStatus.Closed ||
mclsSalesTransactionDetails.TransactionStatus == TransactionStatus.ClosedOutOfStock ||
mclsSalesTransactionDetails.TransactionStatus == TransactionStatus.ClosedWalkIn)
{
e.SuppressKeyPress = true;
if (e.KeyCode != Keys.F7 && e.KeyCode != Keys.Add && e.KeyCode != Keys.Up && e.KeyCode != Keys.Down && e.KeyCode != Keys.Oemplus)
{ return; }
}
if (txtBarCode.Text != string.Empty && e.KeyCode != Keys.Enter) return;
if (Control.ModifierKeys == Keys.Control)
{
switch (e.KeyCode)
{
case Keys.C:
grpRLC.Visible = false;
break;
case Keys.H:
DialogResult loginresult = GetWriteAccessAndLogin(mclsSalesTransactionDetails.CashierID, AccessTypes.PrintTransactionHeader);
if (loginresult == DialogResult.OK)
{
PrintReportHeaderSection(true, DateTime.MinValue);
MessageBox.Show("Transaction header has been printed.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
break;
case Keys.E:
ReleaseItems();
break;
case Keys.L:
LoggedOutCashier(true);
break;
case Keys.O:
OpenTransactionDrawer();
break;
case Keys.P:
PrintCheckOutBill();
break;
case Keys.R:
RefundTransaction();
break;
case Keys.S:
PrintOrderSlip(false);
break;
case Keys.T:
UpdateIsConsignment();
lblConsignment.Visible = mclsSalesTransactionDetails.isConsignment;
break;
case Keys.U:
PackTransaction();
break;
case Keys.Insert:
Float();
break;
case Keys.F2:
ChangeProductCode();
break;
case Keys.F3:
ChangeItemRemarks();
break;
case Keys.F4:
setItemAsDemo();
break;
case Keys.F5:
UpdateContact();
break;
case Keys.F6:
SelectContact(AceSoft.RetailPlus.Data.ContactGroupCategory.AGENT);
break;
case Keys.Enter:
if (!mboIsInTransaction)
{
if (MessageBox.Show("Are you sure you want to reload the default options?", "RetailPlus", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
{
Data.SysConfig clsSysConfig = new Data.SysConfig(mConnection, mTransaction);
mConnection = clsSysConfig.Connection; mTransaction = clsSysConfig.Transaction;
try
{
mclsSysConfigDetails = clsSysConfig.get_SysConfigDetails();
}
catch (Exception ex)
{
clsEvent.AddErrorEventLn(ex);
}
clsSysConfig.CommitAndDispose();
this.LoadOptions();
MessageBox.Show("Done!", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
break;
case Keys.F7:
IssueCreditCard();
break;
case Keys.F8:
RenewCreditCard();
break;
case Keys.F9:
CreditCardReplacement(CreditCardStatus.Replaced_Lost);
break;
case Keys.F10:
CreditCardReplacement(CreditCardStatus.Replaced_Expired);
break;
case Keys.F11:
CreditCardDeclareAsSuspended();
break;
case Keys.F12:
CreditCardReactivate();
break;
}
}
else if (Control.ModifierKeys == Keys.Shift)
{
switch (e.KeyCode)
{
case Keys.Oemplus:
AddItemAttachment();
break;
case Keys.F1:
ShowMallForwarder();
break;
case Keys.F2:
ChangePrice();
break;
case Keys.F4:
ApplyItemDiscountForAllItem();
break;
case Keys.F5:
ApplyTransDiscount();
break;
case Keys.F6:
SelectWaiter();
break;
case Keys.F10:
PaidOut();
break;
case Keys.F11:
Deposit();
break;
case Keys.F12:
ReprintTransaction();
break;
case Keys.Enter:
EnterCreditItemizePayment();
break;
case Keys.Delete:
InitializeZRead(true);
break;
}
}
else if (Control.ModifierKeys == Keys.Alt)
{
switch (e.KeyCode)
{
case Keys.F1:
string strFileName = Application.ExecutablePath.ToUpper().Replace("RETAILPLUS.EXE","") + "print.prn";
RawPrinterHelper.SendFileToPrinter(mclsTerminalDetails.PrinterName, strFileName, "RetailPlus " + "print.prn");
CutPrinterPaper(mclsTerminalDetails.PrinterName);
MessageBox.Show("Done printing 'print.prn'", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
break;
case Keys.Enter:
VerifyCredit();
break;
case Keys.S:
/**********************
* December 18, 2008
* Added to reprint all items that are already printed
* *******************/
PrintOrderSlip(true);
break;
case Keys.U:
UnPackTransaction();
break;
case Keys.F2:
ChangeAmount();
break;
case Keys.F4:
e.SuppressKeyPress = true;
return;
case Keys.F5:
ApplyTransCharge(); //ChargeTypes.Percentage
break;
case Keys.F6:
ApplyTransCharge(); //ChargeTypes.FixedValue
break;
case Keys.F7:
IssueRewardCard();
break;
case Keys.F8:
RenewRewardCard();
break;
case Keys.F9:
RewardCardReplacement(RewardCardStatus.Replaced_Lost);
break;
case Keys.F10:
RewardCardReplacement(RewardCardStatus.Replaced_Expired);
break;
case Keys.F11:
RewardCardDeclareAsLost();
break;
case Keys.F12:
RewardCardReactivate();
break;
case Keys.Insert:
ChangeZeroRated(true);
break;
case Keys.Delete:
ChangeZeroRated(false);
break;
//case Keys.Enter:
// mclsTerminalDetails.TrustFund = 0;
// MessageBox.Show("Done!", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Information);
// break;
}
}
else if (Control.ModifierKeys == (Keys.Control | Keys.Shift))
{
Security.AccessRights clsAccessRights; Security.AccessRightsDetails clsDetails;
switch (e.KeyCode)
{
case Keys.Enter:
clsAccessRights = new Security.AccessRights();
clsDetails = new Security.AccessRightsDetails();
clsDetails = clsAccessRights.Details(mclsSalesTransactionDetails.CashierID, (Int16)AccessTypes.ReprintZRead);
clsAccessRights.CommitAndDispose();
if (clsDetails.Read)
{
UpdateBranchAndTerminalNo();
}
break;
case Keys.F2:
clsAccessRights = new Security.AccessRights();
clsDetails = new Security.AccessRightsDetails();
clsDetails = clsAccessRights.Details(mclsSalesTransactionDetails.CashierID, (Int16)AccessTypes.Contacts);
clsAccessRights.CommitAndDispose();
if (clsDetails.Write)
{
Data.ContactDetails clsContactDetails;
DialogResult addresult = System.Windows.Forms.DialogResult.Cancel;
switch (mclsSysConfigDetails.ContactAddWndType)
{
case ContactAddWndType.ContactAddWnd:
case ContactAddWndType.ContactAddNoLTOWnd:
ContactAddWnd clsContactAddWnd = new ContactAddWnd();
clsContactAddWnd.Caption = "Quickly add new customer.";
clsContactAddWnd.ContactDetails = new Data.ContactDetails();
clsContactAddWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddWnd.SysConfigDetails = mclsSysConfigDetails;
clsContactAddWnd.ShowDialog(this);
addresult = clsContactAddWnd.Result;
clsContactDetails = clsContactAddWnd.ContactDetails;
clsContactAddWnd.Close();
clsContactAddWnd.Dispose();
break;
case ContactAddWndType.ContactAddHCareWnd:
ContactAddHCareWnd clsContactAddHCareWnd = new ContactAddHCareWnd();
clsContactAddHCareWnd.Caption = "Quickly add new customer.";
clsContactAddHCareWnd.ContactDetails = new Data.ContactDetails();
clsContactAddHCareWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddHCareWnd.ShowDialog(this);
addresult = clsContactAddHCareWnd.Result;
clsContactDetails = clsContactAddHCareWnd.ContactDetails;
clsContactAddHCareWnd.Close();
clsContactAddHCareWnd.Dispose();
break;
default:
ContactAddDetWnd clsContactAddDetWnd = new ContactAddDetWnd();
clsContactAddDetWnd.Caption = "Quickly add new customer.";
clsContactAddDetWnd.ContactDetails = new Data.ContactDetails();
clsContactAddDetWnd.TerminalDetails = mclsTerminalDetails;
clsContactAddDetWnd.ShowDialog(this);
addresult = clsContactAddDetWnd.Result;
clsContactDetails = clsContactAddDetWnd.ContactDetails;
clsContactAddDetWnd.Close();
clsContactAddDetWnd.Dispose();
break;
}
if (addresult == DialogResult.OK) LoadContact(Data.ContactGroupCategory.CUSTOMER, clsContactDetails);
}
break;
case Keys.F6:
UpdateContact();
break;
case Keys.F9:
// needs the counter so that it will only show if CTRL+SHIFT+F9 is hit twice
if (miReprintZReadCounter >= 1)
{
clsAccessRights = new Security.AccessRights();
clsDetails = new Security.AccessRightsDetails();
clsDetails = clsAccessRights.Details(mclsSalesTransactionDetails.CashierID, (Int16)AccessTypes.ReprintZRead);
clsAccessRights.CommitAndDispose();
if (clsDetails.Read)
{
ReprintZRead();
}
miReprintZReadCounter = 0;
}
else
{ miReprintZReadCounter += 1; }
break;
}
}
else
{
switch (e.KeyData)
{
case Keys.Add:
case Keys.Oemplus:
AddItemAttachment();
break;
case Keys.Up:
MoveItemUp();
break;
case Keys.Down:
MoveItemDown();
break;
case Keys.Escape:
this.Exit();
break;
case Keys.F1:
ShowHelp();
break;
case Keys.F2:
ChangeQuantity();
break;
case Keys.F3:
ReturnItem();
break;
case Keys.F4:
ApplyItemDiscount();
break;
case Keys.F5:
ApplyTransDiscount();
break;
case Keys.F6:
SelectContact(AceSoft.RetailPlus.Data.ContactGroupCategory.CUSTOMER);
break;
case Keys.F7:
if (!mboIsInTransaction)
{
ResumeClosedTransaction();
}
else
{
SuspendTransaction();
}
break;
case Keys.F8:
ResumeTransaction();
break;
case Keys.F9:
VoidTransaction();
break;
case Keys.F10:
Disburse();
break;
case Keys.F11:
WithHold();
break;
case Keys.F12:
ShowPrintWindow();
break;
case Keys.Enter:
if (!string.IsNullOrEmpty(txtBarCode.Text.Trim()))
if (txtBarCode.Text.Contains(Constants.SWIPE_REWARD_CARD))
{
clsEvent.AddEventLn("[" + lblCashier.Text + "] Selecting customer.", true);
LoadContact(Data.ContactGroupCategory.CUSTOMER, new Data.ContactDetails());
}
else
{
if (txtBarCode.Text.Contains("*") && txtBarCode.Text.Split('*')[0].Contains("-"))
MessageBox.Show("Sorry you cannot enter a negative quantity when selling an item.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
else
ReadBarCode();
}
else if (lblCustomer.Text.Trim().ToUpper() == Constants.C_RETAILPLUS_ORDER_SLIP_CUSTOMER)
CloseTransactionAsOrderSlip();
else
CloseTransaction();
break;
case Keys.Back:
if (string.IsNullOrEmpty(txtBarCode.Text.Trim()))
VoidItem();
break;
case Keys.Insert:
{
if (mclsTerminalDetails.CashCountBeforeReport)
{
if (!mboIsCashCountInitialized)
CashCount();
else
MessageBox.Show("Sorry, cash count has been already initialized for the day. You can only initialize cash count once a day.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else { CashCount(); }
break;
}
case Keys.Delete:
InitializeZRead(false);
break;
case Keys.PageDown:
SelectProduct(false);
break;
case Keys.Right:
SelectProduct(false); // 13May2013 LEAceron: by right, price should be visible.
break;
case Keys.PageUp:
SelectProduct(true);
break;
case Keys.Left:
PriceInquiry();
break;
}
}
}
}
catch (Exception ex)
{
InsertErrorLogToFile(ex, "ERROR!!! Processing event.");
}
}
static void Main()
{
AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException);
System.Windows.Forms.Application.ThreadException += new ThreadExceptionEventHandler(MainWnd_UIThreadException);
Event clsEvent = new Event();
clsEvent.AddEvent("starting.... loading splash screen...");
SplashWnd appsplash = new SplashWnd();
clsEvent.AddEventLn("Done!");
appsplash.prgBar.Maximum = 100;
appsplash.lblStatus.Text = "Checking OS Version... ";
appsplash.prgBar.Value = 10;
appsplash.Show();
appsplash.Refresh();
// get the windows version
clsEvent.AddEvent("Checking windows current version");
OSVersion osVersion = OSInformation.getOSVersion();
switch (osVersion)
{
case OSVersion.Windows95:
case OSVersion.WindowsMe:
clsEvent.AddEventLn(": " + osVersion.ToString("G"));
clsEvent.AddEventLn("This OS platform is not supported. Application will now close.");
MessageBox.Show("FATAL ERROR Level 1.!!! The Operating System : '" + osVersion.ToString("G") + "' is not supported. Application will now close.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Stop);
Application.Exit(); return;
case OSVersion.Windows98:
case OSVersion.Windows98SecondEdition:
case OSVersion.WindowsNT351:
case OSVersion.WindowsNT4:
case OSVersion.Windows2000:
case OSVersion.WindowsXP:
case OSVersion.WindowsVista:
case OSVersion.Windows7:
clsEvent.AddEventLn(": " + osVersion.ToString("G"));
break;
case OSVersion.Unknown:
System.OperatingSystem osInfo = System.Environment.OSVersion;
clsEvent.AddEventLn(": Unidentified: Platform=" + osInfo.Platform.ToString() + " Major Version=" + osInfo.VersionString);
clsEvent.AddEventLn("This OS platform is not supported. Application will now close.");
MessageBox.Show("FATAL ERROR Level 1.!!! The Operating System is unidentified by Retailplus Application. System will now close. Platform=" + osInfo.Platform.ToString() + " Version=" + osInfo.VersionString, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Stop);
Application.Exit(); return;
}
// get the running version
appsplash.lblStatus.Text = "Checking application Version... ";
appsplash.prgBar.Value = 20;
appsplash.Show();
appsplash.Refresh();
clsEvent.AddEvent("Checking application current version");
Version curVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version;
clsEvent.AddEventLn(":" + curVersion.ToString());
#region CopySubGroupsImages
// this should be available only for resto
appsplash.lblStatus.Text = "Copying subgroup images from server... ";
appsplash.prgBar.Value = 25;
getSubGroupImages();
#endregion
Version verNewVersion = GetLatestVersion();
clsEvent.AddEventLn("latest version is " + verNewVersion.ToString(), true);
// compare the versions
if (curVersion.CompareTo(verNewVersion) < 0)
{
clsEvent.AddEventLn("system will now exit then download the latest version.", true);
System.Diagnostics.Process.Start("RetailPlus.VersionChecker.exe", "RestoPlus.exe");
Application.Exit();
return;
}
clsEvent.AddEventLn("This application version is updated.", true);
appsplash.lblStatus.Text = "Checking connections to database... ";
appsplash.prgBar.Value = 30;
appsplash.Refresh();
if (!IsDBAlive())
{
MessageBox.Show("FATAL ERROR Level 1.!!! Cannot connect to database. Please consult your system administrator immediately...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.lblStatus.Text = "Checking Last Initialization of ZREAD... ";
appsplash.prgBar.Value = 50;
appsplash.Show();
appsplash.Refresh();
if (!IsDateLastInitializationOK())
{
MessageBox.Show("FATAL ERROR Level 2.!!! System date is behind ZREAD last initialization date. Please adjust SYSTEM DATE!!!", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.prgBar.Value = 70;
appsplash.lblStatus.Text = "Checking terminal if exist in the database... ";
appsplash.Refresh();
string ErrorMessage;
if (!IsTerminalExist(out ErrorMessage))
{
MessageBox.Show(ErrorMessage, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.prgBar.Value = 100;
appsplash.lblStatus.Text = "Checking terminal if demo is expired... ";
appsplash.Refresh();
if (IsDemoExpired())
{
string stHDSeriano = Key.GetHDSerialNo();
MessageBox.Show(
"This copy has been expired. Please contact your nearest software distributor" + Environment.NewLine +
"Or call RBS Sales @: " + Environment.NewLine +
" Philippines: +63.947.3215979" + Environment.NewLine +
" Philippines: +63.918.9390926" + Environment.NewLine +
" Philippines: +632.998.7722" + Environment.NewLine +
" Singapore: +658.6519601" + Environment.NewLine +
"Or email [email protected]" + Environment.NewLine +
"Your HD Serial No. is: " + stHDSeriano, "RetailPlus™ Demo Version", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.Dispose();
appsplash.Close();
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.BranchID = Constants.TerminalBranchID;
clsAuditDetails.TerminalNo = CompanyDetails.TerminalNo;
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = "******";
clsAuditDetails.IPAddress = System.Net.Dns.GetHostName();
clsAuditDetails.Activity = "Open Terminal";
clsAuditDetails.Remarks = "FE:" + "Open terminal no.:'" + CompanyDetails.TerminalNo + "' @ Branch:" + Constants.TerminalBranchID.ToString();
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
Data.Terminal clsTerminal = new Data.Terminal(clsAuditTrail.Connection, clsAuditTrail.Transaction);
Data.TerminalDetails clsTerminalDetails = clsTerminal.Details(Constants.TerminalBranchID, CompanyDetails.TerminalNo);
//overwrite the companydetails from the database
Data.SysConfig clsSysConfig = new Data.SysConfig(clsAuditTrail.Connection, clsAuditTrail.Transaction);
Data.SysConfigDetails clsSysConfigDetails = clsSysConfig.get_SysConfigDetails();
clsAuditTrail.CommitAndDispose();
CompanyDetails.CompanyCode = string.IsNullOrEmpty(clsSysConfigDetails.CompanyCode) ? CompanyDetails.CompanyCode : clsSysConfigDetails.CompanyCode;
CompanyDetails.CompanyName = string.IsNullOrEmpty(clsSysConfigDetails.CompanyName) ? CompanyDetails.CompanyName : clsSysConfigDetails.CompanyName;
CompanyDetails.Currency = string.IsNullOrEmpty(clsSysConfigDetails.Currency) ? CompanyDetails.Currency : clsSysConfigDetails.Currency;
CompanyDetails.TIN = string.IsNullOrEmpty(clsSysConfigDetails.TIN) ? CompanyDetails.TIN : clsSysConfigDetails.TIN;
CompanyDetails.Address1 = string.IsNullOrEmpty(clsSysConfigDetails.Address1) ? CompanyDetails.Address1 : clsSysConfigDetails.Address1;
CompanyDetails.Address2 = string.IsNullOrEmpty(clsSysConfigDetails.Address2) ? CompanyDetails.Address2 : clsSysConfigDetails.Address2;
CompanyDetails.City = string.IsNullOrEmpty(clsSysConfigDetails.City) ? CompanyDetails.City : clsSysConfigDetails.City;
CompanyDetails.State = string.IsNullOrEmpty(clsSysConfigDetails.State) ? CompanyDetails.State : clsSysConfigDetails.State;
CompanyDetails.Zip = string.IsNullOrEmpty(clsSysConfigDetails.Zip) ? CompanyDetails.Zip : clsSysConfigDetails.Zip;
CompanyDetails.Country = string.IsNullOrEmpty(clsSysConfigDetails.Country) ? CompanyDetails.Country : clsSysConfigDetails.Country;
CompanyDetails.OfficePhone = string.IsNullOrEmpty(clsSysConfigDetails.OfficePhone) ? CompanyDetails.OfficePhone : clsSysConfigDetails.OfficePhone;
CompanyDetails.DirectPhone = string.IsNullOrEmpty(clsSysConfigDetails.DirectPhone) ? CompanyDetails.DirectPhone : clsSysConfigDetails.DirectPhone;
CompanyDetails.FaxPhone = string.IsNullOrEmpty(clsSysConfigDetails.FaxPhone) ? CompanyDetails.FaxPhone : clsSysConfigDetails.FaxPhone;
CompanyDetails.MobilePhone = string.IsNullOrEmpty(clsSysConfigDetails.MobilePhone) ? CompanyDetails.MobilePhone : clsSysConfigDetails.MobilePhone;
CompanyDetails.EmailAddress = string.IsNullOrEmpty(clsSysConfigDetails.EmailAddress) ? CompanyDetails.EmailAddress : clsSysConfigDetails.EmailAddress;
CompanyDetails.WebSite = string.IsNullOrEmpty(clsSysConfigDetails.WebSite) ? CompanyDetails.WebSite : clsSysConfigDetails.WebSite;
try
{
clsEvent.AddEventLn("Running Main Window.", true);
MainRestoWnd appmain = new MainRestoWnd();
appmain.Text = " RestoPlus ™";
/********************************
* Added December 21, 2008
* Enable 2 windows in one computer
* *****************************/
try
{
if (clsTerminalDetails.MultiInstanceEnabled)
{
Application.Run(appmain);
}
else
{
SingleInstance.Run(appmain);
}
}
catch (Exception exMain)
{
clsEvent.AddEventLn("System has excountered an error while loading main screen!" + Environment.NewLine + exMain.ToString(), true);
clsEvent.AddEventLn("System has been exited!", true);
throw (exMain);
}
clsEvent.AddEventLn("System has been exited!", true);
clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.BranchID = Constants.TerminalBranchID;
clsAuditDetails.TerminalNo = CompanyDetails.TerminalNo;
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = "******";
clsAuditDetails.IPAddress = System.Net.Dns.GetHostName();
clsAuditDetails.Activity = "Close Terminal";
clsAuditDetails.Remarks = "FE:" + "Close terminal no.:'" + CompanyDetails.TerminalNo + "' @ Branch:" + Constants.TerminalBranchID.ToString() + ".";
clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
catch (Exception ex)
{
clsEvent.AddErrorEventLn(ex);
MessageBox.Show("FATAL ERROR Level 1.!!! An internal error has occurred in the system. Please consult your system administrator immediately...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
}
public MainWnd()
{
InitializeComponent();
//initialized loadoptions
this.LoadOptions();
this.Lock();
try
{ MarqueeThread = new Thread(new ThreadStart(DrawMovingText)); }
catch { }
grpRLC.Visible = false;
try
{ this.imgIcon.Image = new Bitmap(Application.StartupPath + "/images/MainIcon.jpg"); }
catch { }
try
{ this.imgCompanyLogo.Image = new Bitmap(Application.StartupPath + "/images/CompanyLogo.jpg"); }
catch { }
try
{ this.cmdRLCClose.Image = new Bitmap(Application.StartupPath + "/images/close.gif"); }
catch { }
Data.SysConfig clsSysConfig = new Data.SysConfig(mConnection, mTransaction);
mConnection = clsSysConfig.Connection; mTransaction = clsSysConfig.Transaction;
try
{ mclsSysConfigDetails = clsSysConfig.get_SysConfigDetails(); }
catch (Exception ex)
{ clsEvent.AddErrorEventLn(ex); }
clsSysConfig.CommitAndDispose();
}
private static void ProcessCreditBillWG(string CardTypeName)
{
Event clsEvent = new Event();
clsEvent.AddEventLn("");
Console.WriteLine(ConsoleMonitor() + "");
LocalDB clsLocalDB = new LocalDB();
clsLocalDB.GetConnection(ConnectionTimeOut: 100000);
mConnection = clsLocalDB.Connection; mTransaction = clsLocalDB.Transaction;
Data.Billing clsBilling = new Data.Billing(mConnection, mTransaction);
mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction;
Data.Contacts clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
Data.SysConfig clsSysConfig = new Data.SysConfig(mConnection, mTransaction);
mConnection = clsSysConfig.Connection; mTransaction = clsSysConfig.Transaction;
bool boWillProcessCreditBillerInProgram = clsSysConfig.get_WillProcessCreditBillerInProgram();
Data.CardType clsCardType = new Data.CardType(mConnection, mTransaction);
mConnection = clsCardType.Connection; mTransaction = clsCardType.Transaction;
Data.CardTypeDetails clsCreditCardTypeInfo = clsCardType.Details(CardTypeName);
// check billingdate
Data.ContactColumns clsContactColumns = new Data.ContactColumns() { ContactID = true, ContactCode = true, ContactName = true, CreditDetails = true };
Data.ContactColumns clsSearchColumns = new Data.ContactColumns() { ContactCode = true, ContactName = true };
System.Data.DataTable dtGuarantors;
try
{
if (clsCreditCardTypeInfo.BillingDate == Constants.C_DATE_MIN_VALUE)
{
clsLocalDB.CommitAndDispose();
WriteProcessToMonitor("Will not process group credit bill. There is no BillingDate set in the database. Please contact your System Administrator.");
return;
}
else if (clsCreditCardTypeInfo.BillingDate >= DateTime.Now)
{
WriteProcessToMonitor("Will not process group credit bill. Next processing date must be after BillingDate: [" + clsCreditCardTypeInfo.BillingDate.ToString("dd-MMM-yyyy") + "]. System will only process after billing date.");
WriteProcessToMonitor("Printing unprinted OR's instead. ");
clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
foreach (Data.CardTypeDetails clsCardTypeDetails in clsBilling.ListUnPrintedCreditCardTypes(CreditType.Group))
{
dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCardTypeDetails.CardTypeID);
PrintORsWG(dtGuarantors, clsCardTypeDetails);
}
clsLocalDB.CommitAndDispose();
return;
}
// Check PurchaseEndDate if lower than today then do not execute.
if (clsCreditCardTypeInfo.CreditPurcEndDateToProcess >= DateTime.Now)
{
WriteProcessToMonitor("Will not process group credit bill. CreditPurcEndDateToProcess: " + clsCreditCardTypeInfo.CreditPurcEndDateToProcess.ToString("dd-MMM-yyyy") + " should be lower than current date.");
WriteProcessToMonitor("Printing unprinted OR's instead. ");
clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
foreach (Data.CardTypeDetails clsCardTypeDetails in clsBilling.ListUnPrintedCreditCardTypes(CreditType.Group))
{
dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCardTypeDetails.CardTypeID);
PrintORsWG(dtGuarantors, clsCardTypeDetails);
}
clsLocalDB.CommitAndDispose();
return;
}
// 19Feb2015 : ByPass execution, put in the event instead. Just put the printing here.
if (boWillProcessCreditBillerInProgram)
{
WriteProcessToMonitor("Processing group credit bill for BillingDate: [" + clsCreditCardTypeInfo.BillingDate.ToString("dd-MMM-yyyy") + "]. ");
clsBilling.ProcessCurrentBill(CreditType.Group, clsCreditCardTypeInfo.CardTypeCode);
// print SOA first before closing the billing date to make sure all are printed
clsContacts = new Data.Contacts(mConnection, mTransaction);
mConnection = clsContacts.Connection; mTransaction = clsContacts.Transaction;
dtGuarantors = clsContacts.Guarantors(clsContactColumns, CreditCardTypeID: clsCreditCardTypeInfo.CardTypeID);
clsBilling.CommitAndDispose();
PrintORsWG(dtGuarantors, clsCreditCardTypeInfo);
WriteProcessToMonitor("Closing group current billing date...");
clsBilling = new Data.Billing(mConnection, mTransaction);
mConnection = clsBilling.Connection; mTransaction = clsBilling.Transaction;
clsBilling.CloseCurrentBill(CreditType.Group, clsCreditCardTypeInfo.CardTypeCode);
WriteProcessToMonitor("Done.");
}
else
{
WriteProcessToMonitor("Will not process group credit bill. WillProcessCreditBillerInProgram : false");
WriteProcessToMonitor("Done.");
}
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... PROCESS-CreditBillWithGuarantor error:" + Environment.NewLine + ex.ToString());
clsLocalDB.ThrowException(ex);
}
finally
{
clsLocalDB.CommitAndDispose();
}
}
static void Main(string[] args)
{
try
{
WriteProcessToMonitor("Starting RetailPlus monitoring tool...");
// check if it's already running
if (System.Diagnostics.Process.GetProcessesByName(System.IO.Path.GetFileNameWithoutExtension(System.Reflection.Assembly.GetEntryAssembly().Location)).Count() > 1)
{
WriteProcessToMonitor(" already running. not ok");
return;
}
WriteProcessToMonitor(" ok");
Data.Database clsDatabase = new Data.Database();
back:
WriteProcessToMonitor("Checking connections to server.");
if (IPAddress.IsOpen(AceSoft.RetailPlus.DBConnection.ServerIP(), DBConnection.DBPort()) == false)
{
WriteProcessToMonitor(" cannot connect to server please check.");
goto exit;
}
WriteProcessToMonitor(" ok");
WriteProcessToMonitor("Checking connections to database.");
clsDatabase.GetConnection(username: "******", password: "******");
try
{
bool boIsDBAlive = clsDatabase.IsAlive();
WriteProcessToMonitor(" connected to '" + clsDatabase.Connection.ConnectionString.Split(';')[0].ToString().Replace("Data Source=", "") + "'");
}
catch (Exception ex)
{
WriteProcessToMonitor(" ERROR connecting to database. Exception: " + ex.ToString());
}
#region Timed-Out Process
WriteProcessToMonitor("Checking timed-out process.");
System.Data.DataTable dtProcessList = clsDatabase.getProcessList();
foreach (DataRow dr in dtProcessList.Rows)
{
int iID = int.Parse(dr["ID"].ToString());
string strHost = dr["Host"].ToString();
string strDB = dr["db"].ToString();
int iTime = int.Parse(dr["Time"].ToString());
string strInfo = dr["Info"].ToString();
if (strInfo.ToUpper() != "SHOW PROCESSLIST" || strDB == "pos")
{
WriteProcessToMonitor(" id:" + iID.ToString() + " host:" + strHost + " Time:" + iTime.ToString() + " Info:" + strInfo);
if (iTime > Constants.C_DEFAULT_MYSQL_PROCESS_TIMEOUT && strDB == "pos")
{
WriteProcessToMonitor(" status not ok... killing process id: " + iID.ToString());
clsDatabase.killProcess(iID);
WriteProcessToMonitor(" done.");
}
else if (iTime > 16 && string.IsNullOrEmpty(strInfo))
{
WriteProcessToMonitor(" status idle... killing process id: " + iID.ToString());
clsDatabase.killProcess(iID);
WriteProcessToMonitor(" done.");
}
else if (strInfo.Contains("INSERT INTO tblTransactions") && iTime >= 8)
{
WriteProcessToMonitor(" status not ok... flushing table tblTransactions...process id: " + iID.ToString());
clsDatabase.FlushTable("tblTransactions");
WriteProcessToMonitor(" done.");
}
else if (strInfo.Contains("UPDATE tblTerminalReport") && iTime >= 8)
{
WriteProcessToMonitor(" status not ok... flushing table tblTerminalReport...process id: " + iID.ToString());
clsDatabase.FlushTable("tblTerminalReport");
WriteProcessToMonitor(" done.");
}
else { WriteProcessToMonitor(" status ok"); }
}
}
clsDatabase.CommitAndDispose();
// audit
//clsDatabase = new Data.Database(clsDatabase.Connection, clsDatabase.Transaction);
clsDatabase.GetConnection(username: "******", password: "******");
try
{
bool boIsDBAlive = clsDatabase.IsAlive();
WriteProcessToMonitor(" connected to '" + clsDatabase.Connection.ConnectionString.Split(';')[0].ToString().Replace("Data Source=", "") + "'");
}
catch (Exception ex)
{
WriteProcessToMonitor(" ERROR connecting to database. Exception: " + ex.ToString());
}
WriteProcessToMonitor("Checking Audit timed-out process.");
dtProcessList = clsDatabase.getProcessList();
foreach (DataRow dr in dtProcessList.Rows)
{
int iID = int.Parse(dr["ID"].ToString());
string strHost = dr["Host"].ToString();
string strDB = dr["db"].ToString();
int iTime = int.Parse(dr["Time"].ToString());
string strInfo = dr["Info"].ToString();
if (strInfo.ToUpper() != "SHOW PROCESSLIST" || strDB == "pos")
{
WriteProcessToMonitor(" audit id:" + iID.ToString() + " host:" + strHost + " Time:" + iTime.ToString() + " Info:" + strInfo);
if (iTime > Constants.C_DEFAULT_MYSQL_PROCESS_TIMEOUT && strDB == "pos")
{
WriteProcessToMonitor(" status not ok... killing process id: " + iID.ToString());
clsDatabase.killProcess(iID);
WriteProcessToMonitor(" done.");
}
else { WriteProcessToMonitor(" status ok"); }
}
}
clsDatabase.CommitAndDispose();
WriteProcessToMonitor(" done checking...");
#endregion
string strSyncFunction = "";
try { strSyncFunction = System.Configuration.ConfigurationManager.AppSettings["SyncFunction"].ToString(); }
catch { }
if (strSyncFunction.ToLower().Trim() == "export")
{
#region Export Products
//clsDatabase = new Data.Database(clsDatabase.Connection, clsDatabase.Transaction);
clsDatabase.GetConnection(username: "******", password: "******");
Data.SysConfig clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
DateTime dteLastSyncDateTime = clsSysConfig.get_ProdLastSyncDateTime();
DateTime dteLastSyncDateTimeTo = dteLastSyncDateTime.AddMinutes(clsSysConfig.get_ProdSyncInterval());
if (dteLastSyncDateTimeTo <= DateTime.Now)
{
Data.DBSync clsDBSync = new Data.DBSync(clsDatabase.Connection, clsDatabase.Transaction);
System.Data.DataTable stSyncItems = clsDBSync.ListAsDataTable("tblProducts", dteLastSyncDateTime, dteLastSyncDateTimeTo);
if (stSyncItems.Rows.Count > 0)
{
string xmlFileName = @"C:\RetailPlus\RetailPlus\RetailPlus\temp\uploaded\prodsync\prod_" + dteLastSyncDateTime.ToString("yyyyMMddHHmmss") + ".xml";
if (!System.IO.File.Exists(xmlFileName))
{
XmlTextWriter writer = new XmlTextWriter(xmlFileName, System.Text.Encoding.UTF8);
writer.Formatting = Formatting.Indented;
writer.WriteStartDocument();
writer.WriteComment("This file represents the updated products.");
writer.WriteStartElement("Header");
writer.WriteAttributeString("TableName", stSyncItems.TableName);
writer.WriteAttributeString("LastSyncDateTime", dteLastSyncDateTime.ToString("yyyy-MM-dd HH:mm:ss"));
writer.WriteAttributeString("LastSyncDateTimeTo", dteLastSyncDateTimeTo.ToString("yyyy-MM-dd HH:mm:ss"));
foreach (DataRow dr in stSyncItems.Rows)
{
writer.WriteStartElement("Details");
foreach (DataColumn dc in dr.Table.Columns)
{
if (dc.DataType == System.Type.GetType("System.DateTime"))
writer.WriteAttributeString(dc.ColumnName, DateTime.Parse(dr[dc.ColumnName].ToString()).ToString("yyyy-MM-dd HH:mm:ss"));
else
writer.WriteAttributeString(dc.ColumnName, dr[dc.ColumnName].ToString());
}
writer.WriteEndElement();
}
writer.WriteEndElement();
//Write the XML to file and close the writer
writer.Flush();
writer.Close();
}
}
clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
clsSysConfig.Save(new Data.SysConfigDetails()
{
ConfigName = "ProdLastSyncDateTime",
ConfigValue = dteLastSyncDateTimeTo.ToString("yyyy-MM-dd HH:mm:ss"),
Category = "Sync"
});
}
clsDatabase.CommitAndDispose();
#endregion
}
else if (strSyncFunction.ToLower().Trim() == "import")
{
#region Import Products
XmlTextReader xmlReader = new XmlTextReader(@"C:\RetailPlus\RetailPlus\RetailPlus\temp\uploaded\prodsync\prod_20150629183000.xml");
xmlReader.WhitespaceHandling = WhitespaceHandling.None;
////clsDatabase = new Data.Database(clsDatabase.Connection, clsDatabase.Transaction);
clsDatabase.GetConnection(DBName: "poseamirror", username: "******", password: "******");
clsDatabase.SetForeignKey(false);
Data.SysConfig clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
DateTime dteLastSyncDateTime = clsSysConfig.get_ProdLastSyncDateTime();
DateTime dteLastSyncDateTimeTo = dteLastSyncDateTime.AddMinutes(clsSysConfig.get_ProdSyncInterval());
Data.Products clsProducts = new Data.Products(clsDatabase.Connection, clsDatabase.Transaction);
Data.ProductDetails clsProductDetails = new Data.ProductDetails();
string strTableName = "";
DateTime dteXmlLastSyncDateTime = Constants.C_DATE_MIN_VALUE;
DateTime dteXmlLastSyncDateTimeTo = Constants.C_DATE_MIN_VALUE;
while (xmlReader.Read())
{
switch (xmlReader.NodeType)
{
case XmlNodeType.Element:
if (xmlReader.Name == "Header")
{
strTableName = xmlReader.GetAttribute("TableName").ToString();
dteXmlLastSyncDateTime = DateTime.TryParse(xmlReader.GetAttribute("LastSyncDateTime").ToString(), out dteXmlLastSyncDateTime) ? dteXmlLastSyncDateTime : Constants.C_DATE_MIN_VALUE;
dteXmlLastSyncDateTimeTo = DateTime.TryParse(xmlReader.GetAttribute("LastSyncDateTimeTo").ToString(), out dteXmlLastSyncDateTimeTo) ? dteXmlLastSyncDateTimeTo : Constants.C_DATE_MIN_VALUE;
if (dteLastSyncDateTime >= dteXmlLastSyncDateTime) break;
}
else if (strTableName == "tblProducts" && xmlReader.Name == "Details")
{
clsProductDetails = Data.DBSync.setSyncProductDetails(xmlReader);
clsProducts.Save(clsProductDetails);
}
break;
}
}
if (dteLastSyncDateTime < dteXmlLastSyncDateTime)
{
clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
clsSysConfig.Save(new Data.SysConfigDetails()
{
ConfigName = "ProdLastSyncDateTime",
ConfigValue = dteXmlLastSyncDateTimeTo.ToString("yyyy-MM-dd HH:mm:ss"),
Category = "Sync"
});
}
clsDatabase.SetForeignKey(true);
clsDatabase.CommitAndDispose();
#endregion
}
WriteProcessToMonitor("Waiting for next process...");
System.Threading.Thread.Sleep(20000);
goto back;
exit:
WriteProcessToMonitor("Sytem terminated.");
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... error:" + ex.ToString());
}
}
static void Main()
{
AppDomain.CurrentDomain.UnhandledException += new UnhandledExceptionEventHandler(CurrentDomain_UnhandledException);
System.Windows.Forms.Application.ThreadException += new ThreadExceptionEventHandler(MainWnd_UIThreadException);
Event clsEvent = new Event();
clsEvent.AddEvent("starting.... loading splash screen...");
SplashWnd appsplash = new SplashWnd();
clsEvent.AddEventLn("Done!");
appsplash.prgBar.Maximum = 100;
appsplash.lblStatus.Text = "Checking OS Version... ";
appsplash.prgBar.Value = 10;
appsplash.Show();
appsplash.Refresh();
// get the windows version
clsEvent.AddEvent("Checking windows current version");
OSVersion osVersion = OSInformation.getOSVersion();
switch (osVersion)
{
case OSVersion.Windows95:
case OSVersion.WindowsMe:
clsEvent.AddEventLn(": " + osVersion.ToString("G"));
clsEvent.AddEventLn("This OS platform is not supported. Application will now close.");
MessageBox.Show("FATAL ERROR Level 1.!!! The Operating System : '" + osVersion.ToString("G") + "' is not supported. Application will now close.", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Stop);
Application.Exit(); return;
case OSVersion.Windows98:
case OSVersion.Windows98SecondEdition:
case OSVersion.WindowsNT351:
case OSVersion.WindowsNT4:
case OSVersion.Windows2000:
case OSVersion.WindowsXP:
case OSVersion.WindowsVista:
case OSVersion.Windows7:
clsEvent.AddEventLn(": " + osVersion.ToString("G"));
break;
case OSVersion.Unknown:
System.OperatingSystem osInfo = System.Environment.OSVersion;
clsEvent.AddEventLn(": Unidentified: Platform=" + osInfo.Platform.ToString() + " Major Version=" + osInfo.VersionString);
clsEvent.AddEventLn("This OS platform is not supported. Application will now close.");
MessageBox.Show("FATAL ERROR Level 1.!!! The Operating System is unidentified by Retailplus Application. System will now close. Platform=" + osInfo.Platform.ToString() + " Version=" + osInfo.VersionString, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Stop);
Application.Exit(); return;
}
// get the running version
appsplash.lblStatus.Text = "Checking application Version... ";
appsplash.prgBar.Value = 20;
appsplash.Show();
appsplash.Refresh();
clsEvent.AddEvent("Checking application current version");
Version curVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version;
clsEvent.AddEventLn(":" + curVersion.ToString());
#region CopySubGroupsImages
// this should be available only for resto
appsplash.lblStatus.Text = "Copying subgroup images from server... ";
appsplash.prgBar.Value = 25;
getSubGroupImages();
#endregion
Version verNewVersion = GetLatestVersion();
clsEvent.AddEventLn("latest version is " + verNewVersion.ToString(), true);
// compare the versions
if (curVersion.CompareTo(verNewVersion) < 0)
{
clsEvent.AddEventLn("system will now exit then download the latest version.", true);
System.Diagnostics.Process.Start("RetailPlus.VersionChecker.exe", "RestoPlus.exe");
Application.Exit();
return;
}
clsEvent.AddEventLn("This application version is updated.", true);
appsplash.lblStatus.Text = "Checking connections to database... ";
appsplash.prgBar.Value = 30;
appsplash.Refresh();
if (!IsDBAlive())
{
MessageBox.Show("FATAL ERROR Level 1.!!! Cannot connect to database. Please consult your system administrator immediately...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.lblStatus.Text = "Checking Last Initialization of ZREAD... ";
appsplash.prgBar.Value = 50;
appsplash.Show();
appsplash.Refresh();
if (!IsDateLastInitializationOK())
{
MessageBox.Show("FATAL ERROR Level 2.!!! System date is behind ZREAD last initialization date. Please adjust SYSTEM DATE!!!", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.prgBar.Value = 70;
appsplash.lblStatus.Text = "Checking terminal if exist in the database... ";
appsplash.Refresh();
string ErrorMessage;
if (!IsTerminalExist(out ErrorMessage))
{
MessageBox.Show(ErrorMessage, "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.prgBar.Value = 100;
appsplash.lblStatus.Text = "Checking terminal if demo is expired... ";
appsplash.Refresh();
if (IsDemoExpired())
{
string stHDSeriano = Key.GetHDSerialNo();
MessageBox.Show(
"This copy has been expired. Please contact your nearest software distributor" + Environment.NewLine +
"Or call RBS Sales @: " + Environment.NewLine +
" Philippines: +63.947.3215979" + Environment.NewLine +
" Philippines: +63.918.9390926" + Environment.NewLine +
" Philippines: +632.998.7722" + Environment.NewLine +
" Singapore: +658.6519601" + Environment.NewLine +
"Or email [email protected]" + Environment.NewLine +
"Your HD Serial No. is: " + stHDSeriano, "RetailPlus™ Demo Version", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly);
Application.Exit();
return;
}
appsplash.lblStatus.Text += "DONE!";
appsplash.Refresh();
appsplash.Dispose();
appsplash.Close();
Security.AuditTrailDetails clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.BranchID = Constants.TerminalBranchID;
clsAuditDetails.TerminalNo = CompanyDetails.TerminalNo;
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = "******";
clsAuditDetails.IPAddress = System.Net.Dns.GetHostName();
clsAuditDetails.Activity = "Open Terminal";
clsAuditDetails.Remarks = "FE:" + "Open terminal no.:'" + CompanyDetails.TerminalNo + "' @ Branch:" + Constants.TerminalBranchID.ToString();
Security.AuditTrail clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
Data.Terminal clsTerminal = new Data.Terminal(clsAuditTrail.Connection, clsAuditTrail.Transaction);
Data.TerminalDetails clsTerminalDetails = clsTerminal.Details(Constants.TerminalBranchID, CompanyDetails.TerminalNo);
//overwrite the companydetails from the database
Data.SysConfig clsSysConfig = new Data.SysConfig(clsAuditTrail.Connection, clsAuditTrail.Transaction);
Data.SysConfigDetails clsSysConfigDetails = clsSysConfig.get_SysConfigDetails();
clsAuditTrail.CommitAndDispose();
CompanyDetails.CompanyCode = string.IsNullOrEmpty(clsSysConfigDetails.CompanyCode) ? CompanyDetails.CompanyCode : clsSysConfigDetails.CompanyCode;
CompanyDetails.CompanyName = string.IsNullOrEmpty(clsSysConfigDetails.CompanyName) ? CompanyDetails.CompanyName : clsSysConfigDetails.CompanyName;
CompanyDetails.Currency = string.IsNullOrEmpty(clsSysConfigDetails.Currency) ? CompanyDetails.Currency : clsSysConfigDetails.Currency;
CompanyDetails.TIN = string.IsNullOrEmpty(clsSysConfigDetails.TIN) ? CompanyDetails.TIN : clsSysConfigDetails.TIN;
CompanyDetails.Address1 = string.IsNullOrEmpty(clsSysConfigDetails.Address1) ? CompanyDetails.Address1 : clsSysConfigDetails.Address1;
CompanyDetails.Address2 = string.IsNullOrEmpty(clsSysConfigDetails.Address2) ? CompanyDetails.Address2 : clsSysConfigDetails.Address2;
CompanyDetails.City = string.IsNullOrEmpty(clsSysConfigDetails.City) ? CompanyDetails.City : clsSysConfigDetails.City;
CompanyDetails.State = string.IsNullOrEmpty(clsSysConfigDetails.State) ? CompanyDetails.State : clsSysConfigDetails.State;
CompanyDetails.Zip = string.IsNullOrEmpty(clsSysConfigDetails.Zip) ? CompanyDetails.Zip : clsSysConfigDetails.Zip;
CompanyDetails.Country = string.IsNullOrEmpty(clsSysConfigDetails.Country) ? CompanyDetails.Country : clsSysConfigDetails.Country;
CompanyDetails.OfficePhone = string.IsNullOrEmpty(clsSysConfigDetails.OfficePhone) ? CompanyDetails.OfficePhone : clsSysConfigDetails.OfficePhone;
CompanyDetails.DirectPhone = string.IsNullOrEmpty(clsSysConfigDetails.DirectPhone) ? CompanyDetails.DirectPhone : clsSysConfigDetails.DirectPhone;
CompanyDetails.FaxPhone = string.IsNullOrEmpty(clsSysConfigDetails.FaxPhone) ? CompanyDetails.FaxPhone : clsSysConfigDetails.FaxPhone;
CompanyDetails.MobilePhone = string.IsNullOrEmpty(clsSysConfigDetails.MobilePhone) ? CompanyDetails.MobilePhone : clsSysConfigDetails.MobilePhone;
CompanyDetails.EmailAddress = string.IsNullOrEmpty(clsSysConfigDetails.EmailAddress) ? CompanyDetails.EmailAddress : clsSysConfigDetails.EmailAddress;
CompanyDetails.WebSite = string.IsNullOrEmpty(clsSysConfigDetails.WebSite) ? CompanyDetails.WebSite : clsSysConfigDetails.WebSite;
try
{
clsEvent.AddEventLn("Running Main Window.", true);
MainRestoWnd appmain = new MainRestoWnd();
appmain.Text = " RestoPlus ™";
/********************************
* Added December 21, 2008
* Enable 2 windows in one computer
* *****************************/
try
{
if (clsTerminalDetails.MultiInstanceEnabled)
{ Application.Run(appmain); }
else
{ SingleInstance.Run(appmain); }
}
catch (Exception exMain)
{
clsEvent.AddEventLn("System has excountered an error while loading main screen!" + Environment.NewLine + exMain.ToString(), true);
clsEvent.AddEventLn("System has been exited!", true);
throw (exMain);
}
clsEvent.AddEventLn("System has been exited!", true);
clsAuditDetails = new Security.AuditTrailDetails();
clsAuditDetails.BranchID = Constants.TerminalBranchID;
clsAuditDetails.TerminalNo = CompanyDetails.TerminalNo;
clsAuditDetails.ActivityDate = DateTime.Now;
clsAuditDetails.User = "******";
clsAuditDetails.IPAddress = System.Net.Dns.GetHostName();
clsAuditDetails.Activity = "Close Terminal";
clsAuditDetails.Remarks = "FE:" + "Close terminal no.:'" + CompanyDetails.TerminalNo + "' @ Branch:" + Constants.TerminalBranchID.ToString() + ".";
clsAuditTrail = new Security.AuditTrail();
clsAuditTrail.Insert(clsAuditDetails);
clsAuditTrail.CommitAndDispose();
}
catch (Exception ex)
{
clsEvent.AddErrorEventLn(ex);
MessageBox.Show("FATAL ERROR Level 1.!!! An internal error has occurred in the system. Please consult your system administrator immediately...", "RetailPlus", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
}
static void Main(string[] args)
{
try
{
WriteProcessToMonitor("Starting RetailPlus monitoring tool...");
// check if it's already running
if (System.Diagnostics.Process.GetProcessesByName(System.IO.Path.GetFileNameWithoutExtension(System.Reflection.Assembly.GetEntryAssembly().Location)).Count() > 1)
{
WriteProcessToMonitor(" already running. not ok");
return;
}
WriteProcessToMonitor(" ok");
Data.Database clsDatabase = new Data.Database();
back:
WriteProcessToMonitor("Checking connections to server.");
if (IPAddress.IsOpen(AceSoft.RetailPlus.DBConnection.ServerIP(), DBConnection.DBPort()) == false)
{
WriteProcessToMonitor(" cannot connect to server please check.");
goto exit;
}
WriteProcessToMonitor(" ok");
WriteProcessToMonitor("Checking connections to database.");
clsDatabase.GetConnection(username: "******", password: "******");
try
{
bool boIsDBAlive = clsDatabase.IsAlive();
WriteProcessToMonitor(" connected to '" + clsDatabase.Connection.ConnectionString.Split(';')[0].ToString().Replace("Data Source=", "") + "'");
}
catch (Exception ex)
{
WriteProcessToMonitor(" ERROR connecting to database. Exception: " + ex.ToString());
}
#region Timed-Out Process
WriteProcessToMonitor("Checking timed-out process.");
System.Data.DataTable dtProcessList = clsDatabase.getProcessList();
foreach (DataRow dr in dtProcessList.Rows)
{
int iID = int.Parse(dr["ID"].ToString());
string strHost = dr["Host"].ToString();
string strDB = dr["db"].ToString();
int iTime = int.Parse(dr["Time"].ToString());
string strInfo = dr["Info"].ToString();
if (strInfo.ToUpper() != "SHOW PROCESSLIST" || strDB == "pos")
{
WriteProcessToMonitor(" id:" + iID.ToString() + " host:" + strHost + " Time:" + iTime.ToString() + " Info:" + strInfo);
if (iTime > Constants.C_DEFAULT_MYSQL_PROCESS_TIMEOUT && strDB == "pos")
{
WriteProcessToMonitor(" status not ok... killing process id: " + iID.ToString());
clsDatabase.killProcess(iID);
WriteProcessToMonitor(" done.");
}
else if (iTime > 16 && string.IsNullOrEmpty(strInfo))
{
WriteProcessToMonitor(" status idle... killing process id: " + iID.ToString());
clsDatabase.killProcess(iID);
WriteProcessToMonitor(" done.");
}
else if (strInfo.Contains("INSERT INTO tblTransactions") && iTime >= 8)
{
WriteProcessToMonitor(" status not ok... flushing table tblTransactions...process id: " + iID.ToString());
clsDatabase.FlushTable("tblTransactions");
WriteProcessToMonitor(" done.");
}
else if (strInfo.Contains("UPDATE tblTerminalReport") && iTime >= 8)
{
WriteProcessToMonitor(" status not ok... flushing table tblTerminalReport...process id: " + iID.ToString());
clsDatabase.FlushTable("tblTerminalReport");
WriteProcessToMonitor(" done.");
}
else
{
WriteProcessToMonitor(" status ok");
}
}
}
clsDatabase.CommitAndDispose();
// audit
//clsDatabase = new Data.Database(clsDatabase.Connection, clsDatabase.Transaction);
clsDatabase.GetConnection(username: "******", password: "******");
try
{
bool boIsDBAlive = clsDatabase.IsAlive();
WriteProcessToMonitor(" connected to '" + clsDatabase.Connection.ConnectionString.Split(';')[0].ToString().Replace("Data Source=", "") + "'");
}
catch (Exception ex)
{
WriteProcessToMonitor(" ERROR connecting to database. Exception: " + ex.ToString());
}
WriteProcessToMonitor("Checking Audit timed-out process.");
dtProcessList = clsDatabase.getProcessList();
foreach (DataRow dr in dtProcessList.Rows)
{
int iID = int.Parse(dr["ID"].ToString());
string strHost = dr["Host"].ToString();
string strDB = dr["db"].ToString();
int iTime = int.Parse(dr["Time"].ToString());
string strInfo = dr["Info"].ToString();
if (strInfo.ToUpper() != "SHOW PROCESSLIST" || strDB == "pos")
{
WriteProcessToMonitor(" audit id:" + iID.ToString() + " host:" + strHost + " Time:" + iTime.ToString() + " Info:" + strInfo);
if (iTime > Constants.C_DEFAULT_MYSQL_PROCESS_TIMEOUT && strDB == "pos")
{
WriteProcessToMonitor(" status not ok... killing process id: " + iID.ToString());
clsDatabase.killProcess(iID);
WriteProcessToMonitor(" done.");
}
else
{
WriteProcessToMonitor(" status ok");
}
}
}
clsDatabase.CommitAndDispose();
WriteProcessToMonitor(" done checking...");
#endregion
string strSyncFunction = "";
try { strSyncFunction = System.Configuration.ConfigurationManager.AppSettings["SyncFunction"].ToString(); }
catch { }
if (strSyncFunction.ToLower().Trim() == "export")
{
#region Export Products
//clsDatabase = new Data.Database(clsDatabase.Connection, clsDatabase.Transaction);
clsDatabase.GetConnection(username: "******", password: "******");
Data.SysConfig clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
DateTime dteLastSyncDateTime = clsSysConfig.get_ProdLastSyncDateTime();
DateTime dteLastSyncDateTimeTo = dteLastSyncDateTime.AddMinutes(clsSysConfig.get_ProdSyncInterval());
if (dteLastSyncDateTimeTo <= DateTime.Now)
{
Data.DBSync clsDBSync = new Data.DBSync(clsDatabase.Connection, clsDatabase.Transaction);
System.Data.DataTable stSyncItems = clsDBSync.ListAsDataTable("tblProducts", dteLastSyncDateTime, dteLastSyncDateTimeTo);
if (stSyncItems.Rows.Count > 0)
{
string xmlFileName = @"C:\RetailPlus\RetailPlus\RetailPlus\temp\uploaded\prodsync\prod_" + dteLastSyncDateTime.ToString("yyyyMMddHHmmss") + ".xml";
if (!System.IO.File.Exists(xmlFileName))
{
XmlTextWriter writer = new XmlTextWriter(xmlFileName, System.Text.Encoding.UTF8);
writer.Formatting = Formatting.Indented;
writer.WriteStartDocument();
writer.WriteComment("This file represents the updated products.");
writer.WriteStartElement("Header");
writer.WriteAttributeString("TableName", stSyncItems.TableName);
writer.WriteAttributeString("LastSyncDateTime", dteLastSyncDateTime.ToString("yyyy-MM-dd HH:mm:ss"));
writer.WriteAttributeString("LastSyncDateTimeTo", dteLastSyncDateTimeTo.ToString("yyyy-MM-dd HH:mm:ss"));
foreach (DataRow dr in stSyncItems.Rows)
{
writer.WriteStartElement("Details");
foreach (DataColumn dc in dr.Table.Columns)
{
if (dc.DataType == System.Type.GetType("System.DateTime"))
{
writer.WriteAttributeString(dc.ColumnName, DateTime.Parse(dr[dc.ColumnName].ToString()).ToString("yyyy-MM-dd HH:mm:ss"));
}
else
{
writer.WriteAttributeString(dc.ColumnName, dr[dc.ColumnName].ToString());
}
}
writer.WriteEndElement();
}
writer.WriteEndElement();
//Write the XML to file and close the writer
writer.Flush();
writer.Close();
}
}
clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
clsSysConfig.Save(new Data.SysConfigDetails()
{
ConfigName = "ProdLastSyncDateTime",
ConfigValue = dteLastSyncDateTimeTo.ToString("yyyy-MM-dd HH:mm:ss"),
Category = "Sync"
});
}
clsDatabase.CommitAndDispose();
#endregion
}
else if (strSyncFunction.ToLower().Trim() == "import")
{
#region Import Products
XmlTextReader xmlReader = new XmlTextReader(@"C:\RetailPlus\RetailPlus\RetailPlus\temp\uploaded\prodsync\prod_20150629183000.xml");
xmlReader.WhitespaceHandling = WhitespaceHandling.None;
////clsDatabase = new Data.Database(clsDatabase.Connection, clsDatabase.Transaction);
clsDatabase.GetConnection(DBName: "poseamirror", username: "******", password: "******");
clsDatabase.SetForeignKey(false);
Data.SysConfig clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
DateTime dteLastSyncDateTime = clsSysConfig.get_ProdLastSyncDateTime();
DateTime dteLastSyncDateTimeTo = dteLastSyncDateTime.AddMinutes(clsSysConfig.get_ProdSyncInterval());
Data.Products clsProducts = new Data.Products(clsDatabase.Connection, clsDatabase.Transaction);
Data.ProductDetails clsProductDetails = new Data.ProductDetails();
string strTableName = "";
DateTime dteXmlLastSyncDateTime = Constants.C_DATE_MIN_VALUE;
DateTime dteXmlLastSyncDateTimeTo = Constants.C_DATE_MIN_VALUE;
while (xmlReader.Read())
{
switch (xmlReader.NodeType)
{
case XmlNodeType.Element:
if (xmlReader.Name == "Header")
{
strTableName = xmlReader.GetAttribute("TableName").ToString();
dteXmlLastSyncDateTime = DateTime.TryParse(xmlReader.GetAttribute("LastSyncDateTime").ToString(), out dteXmlLastSyncDateTime) ? dteXmlLastSyncDateTime : Constants.C_DATE_MIN_VALUE;
dteXmlLastSyncDateTimeTo = DateTime.TryParse(xmlReader.GetAttribute("LastSyncDateTimeTo").ToString(), out dteXmlLastSyncDateTimeTo) ? dteXmlLastSyncDateTimeTo : Constants.C_DATE_MIN_VALUE;
if (dteLastSyncDateTime >= dteXmlLastSyncDateTime)
{
break;
}
}
else if (strTableName == "tblProducts" && xmlReader.Name == "Details")
{
clsProductDetails = Data.DBSync.setSyncProductDetails(xmlReader);
clsProducts.Save(clsProductDetails);
}
break;
}
}
if (dteLastSyncDateTime < dteXmlLastSyncDateTime)
{
clsSysConfig = new Data.SysConfig(clsDatabase.Connection, clsDatabase.Transaction);
clsSysConfig.Save(new Data.SysConfigDetails()
{
ConfigName = "ProdLastSyncDateTime",
ConfigValue = dteXmlLastSyncDateTimeTo.ToString("yyyy-MM-dd HH:mm:ss"),
Category = "Sync"
});
}
clsDatabase.SetForeignKey(true);
clsDatabase.CommitAndDispose();
#endregion
}
WriteProcessToMonitor("Waiting for next process...");
System.Threading.Thread.Sleep(20000);
goto back;
exit:
WriteProcessToMonitor("Sytem terminated.");
}
catch (Exception ex)
{
WriteProcessToMonitor("PLEASE CALL RETAILPLUS IMMEDIATELY... error:" + ex.ToString());
}
}
