public Int64 Insert(DepositDetails Details) { try { Save(Details); Int64 iID = Int64.Parse(base.getLAST_INSERT_ID(this)); TerminalReport clsTerminalReport = new TerminalReport(base.Connection, base.Transaction); clsTerminalReport.UpdateDeposit(Details); CashierReports clsCashierReport = new CashierReports(base.Connection, base.Transaction); clsCashierReport.UpdateDeposit(Details); return(iID); } catch (Exception ex) { throw base.ThrowException(ex); } }
public void Insert(CashCountDetails[] Details) { try { if (Details.Length > 0) { decimal Amount = 0; foreach (CashCountDetails details in Details) { Insert(details); Amount += details.DenominationAmount; } CashierReports clsCashierReport = new CashierReports(base.Connection, base.Transaction); clsCashierReport.UpdateCashCount(Details[0].BranchDetails.BranchID, Details[0].CashierID, Details[0].TerminalNo, Amount); } } catch (Exception ex) { throw base.ThrowException(ex); } }
public CashierReportDetails Details(Int64 CashierID, int BranchID, string TerminalNo) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "SELECT " + "BranchID, " + "TerminalNo, " + "CashierID, " + "NetSales, " + "GrossSales, " + "TotalDiscount, " + "SNRDiscount, " + "PWDDiscount, " + "OtherDiscount, " + "TotalCharge, " + "DailySales, " + "QuantitySold, " + "GroupSales, " + "VATExempt, " + "NonVATableAmount, " + "VAT, " + "VATableAmount, " + "ZeroRatedSales, " + "EVAT, " + "LocalTax, " + "CashSales, " + "ChequeSales, " + "CreditCardSales, " + "CreditSales, " + "RefundCash, " + "RefundCheque, " + "RefundCreditCard, " + "RefundCredit, " + "RefundDebit, " + "CreditPayment, " + "CreditPaymentCash, " + "CreditPaymentCheque, " + "CreditPaymentCreditCard, " + "CreditPaymentDebit, " + "DebitPayment, " + "RewardPointsPayment, " + "RewardConvertedPayment, " + "CashInDrawer, " + "TotalDisburse, " + "CashDisburse, " + "ChequeDisburse, " + "CreditCardDisburse, " + "TotalWithHold, " + "CashWithHold, " + "ChequeWithHold, " + "CreditCardWithHold, " + "TotalPaidOut, " + "TotalDeposit, " + "CashDeposit, " + "ChequeDeposit, " + "CreditCardDeposit, " + "BeginningBalance, " + "VoidSales, " + "RefundSales, " + "ItemsDiscount, " + "SubTotalDiscount, " + "NoOfCashTransactions, " + "NoOfChequeTransactions, " + "NoOfCreditCardTransactions, " + "NoOfCreditTransactions, " + "NoOfCombinationPaymentTransactions, " + "NoOfCreditPaymentTransactions, " + "NoOfDebitPaymentTransactions, " + "NoOfClosedTransactions, " + "NoOfRefundTransactions, " + "NoOfVoidTransactions, " + "NoOfRewardPointsPayment, " + "NoOfTotalTransactions, " + "NoOfConsignmentTransactions, " + "NoOfConsignmentRefundTransactions, " + "NoOfWalkInTransactions, " + "NoOfWalkInRefundTransactions, " + "NoOfOutOfStockTransactions, " + "NoOfOutOfStockRefundTransactions, " + "ConsignmentSales, " + "ConsignmentRefundSales, " + "WalkInSales, " + "WalkInRefundSales, " + "OutOfStockSales, " + "OutOfStockRefundSales, " + "CashCount, " + "LastLoginDate " + "FROM tblCashierReportHistory " + "WHERE BranchID = @BranchID AND TerminalNo = @TerminalNo AND CashierID = @CashierID;"; cmd.Parameters.AddWithValue("@BranchID", BranchID); cmd.Parameters.AddWithValue("@TerminalNo", TerminalNo); cmd.Parameters.AddWithValue("@CashierID", CashierID); cmd.CommandText = SQL; string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName); base.MySqlDataAdapterFill(cmd, dt); CashierReportDetails Details = CashierReports.SetDetails(dt); return(Details); } catch (Exception ex) { throw base.ThrowException(ex); } }