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); } }
public Int32 Save(CashierReportDetails Details) { try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandType = System.Data.CommandType.Text; string SQL = "CALL procSaveCashierReportHistory(@BranchID, @TerminalNo, @SyncID, @CashierReportHistoryID, @CashierID, @TerminalID, @NetSales, @GrossSales, @TotalDiscount, @DailySales," + "@QuantitySold, @GroupSales, @VAT, @EVAT, @LocalTax, @CashSales, @ChequeSales, @CreditCardSales," + "@CreditSales, @CreditPayment, @CashInDrawer, @TotalDisburse, @CashDisburse, @ChequeDisburse," + "@CreditCardDisburse, @TotalWithhold, @CashWithhold, @ChequeWithhold, @CreditCardWithhold," + "@TotalPaidOut, @CashPaidOut, @ChequePaidOut, @CreditCardPaidOut, @BeginningBalance," + "@VoidSales, @RefundSales, @ItemsDiscount, @SubtotalDiscount, @NoOfCashTransactions," + "@NoOfChequeTransactions, @NoOfCreditCardTransactions, @NoOfCreditTransactions, " + "@NoOfCombinationPaymentTransactions, @NoOfCreditPaymentTransactions, @NoOfClosedTransactions," + "@NoOfRefundTransactions, @NoOfVoidTransactions, @NoOfTotalTransactions, @CashCount, " + "@LastLoginDate, @TotalDeposit, @CashDeposit, @ChequeDeposit, @CreditCardDeposit, " + "@DebitPayment, @NoOfDebitPaymentTransactions, @TotalCharge, @IsCashCountInitialized," + "@NoOfDiscountedTransactions, @NegativeAdjustments, @NoOfNegativeAdjustmentTransactions," + "@PromotionalItems, @CreditSalesTax, @DebitDeposit, @RewardPointsPayment, @RewardConvertedPayment," + "@NoOfRewardPointsPayment, @CreditPaymentCash, @CreditPaymentCheque," + "@CreditPaymentCreditCard, @CreditPaymentDebit, " + "@RefundCash, @RefundCheque, @RefundCreditCard, @RefundCredit, @RefundDebit, " + "@NoOfConsignmentTransactions, @NoOfConsignmentRefundTransactions, @NoOfWalkInTransactions, " + "@NoOfWalkInRefundTransactions, @NoOfOutOfStockTransactions, @NoOfOutOfStockRefundTransactions," + "@ConsignmentSales, @ConsignmentRefundSales, @WalkInSales," + "@WalkInRefundSales, @OutOfStockSales, @OutOfStockRefundSales," + "@CreatedOn, @LastModified);"; cmd.Parameters.AddWithValue("BranchID", Details.BranchID); cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo); cmd.Parameters.AddWithValue("SyncID", Details.SyncID); cmd.Parameters.AddWithValue("CashierReportHistoryID", Details.CashierReportHistoryID); cmd.Parameters.AddWithValue("CashierID", Details.CashierID); cmd.Parameters.AddWithValue("TerminalID", Details.TerminalID); cmd.Parameters.AddWithValue("NetSales", Details.NetSales); cmd.Parameters.AddWithValue("GrossSales", Details.GrossSales); cmd.Parameters.AddWithValue("TotalDiscount", Details.TotalDiscount); cmd.Parameters.AddWithValue("DailySales", Details.DailySales); cmd.Parameters.AddWithValue("QuantitySold", Details.QuantitySold); cmd.Parameters.AddWithValue("GroupSales", Details.GroupSales); cmd.Parameters.AddWithValue("VAT", Details.VAT); cmd.Parameters.AddWithValue("EVAT", Details.EVAT); cmd.Parameters.AddWithValue("LocalTax", Details.LocalTax); cmd.Parameters.AddWithValue("CashSales", Details.CashSales); cmd.Parameters.AddWithValue("ChequeSales", Details.ChequeSales); cmd.Parameters.AddWithValue("CreditCardSales", Details.CreditCardSales); cmd.Parameters.AddWithValue("CreditSales", Details.CreditSales); cmd.Parameters.AddWithValue("CreditPayment", Details.CreditPayment); cmd.Parameters.AddWithValue("CashInDrawer", Details.CashInDrawer); cmd.Parameters.AddWithValue("TotalDisburse", Details.TotalDisburse); cmd.Parameters.AddWithValue("CashDisburse", Details.CashDisburse); cmd.Parameters.AddWithValue("ChequeDisburse", Details.ChequeDisburse); cmd.Parameters.AddWithValue("CreditCardDisburse", Details.CreditCardDisburse); cmd.Parameters.AddWithValue("TotalWithhold", Details.TotalWithHold); cmd.Parameters.AddWithValue("CashWithhold", Details.CashWithHold); cmd.Parameters.AddWithValue("ChequeWithhold", Details.ChequeWithHold); cmd.Parameters.AddWithValue("CreditCardWithhold", Details.CreditCardWithHold); cmd.Parameters.AddWithValue("TotalPaidOut", Details.TotalPaidOut); cmd.Parameters.AddWithValue("CashPaidOut", Details.CashPaidOut); cmd.Parameters.AddWithValue("ChequePaidOut", Details.ChequePaidOut); cmd.Parameters.AddWithValue("CreditCardPaidOut", Details.CreditCardPaidOut); cmd.Parameters.AddWithValue("BeginningBalance", Details.BeginningBalance); cmd.Parameters.AddWithValue("VoidSales", Details.VoidSales); cmd.Parameters.AddWithValue("RefundSales", Details.RefundSales); cmd.Parameters.AddWithValue("ItemsDiscount", Details.ItemsDiscount); cmd.Parameters.AddWithValue("SubtotalDiscount", Details.SubTotalDiscount); cmd.Parameters.AddWithValue("NoOfCashTransactions", Details.NoOfCashTransactions); cmd.Parameters.AddWithValue("NoOfChequeTransactions", Details.NoOfChequeTransactions); cmd.Parameters.AddWithValue("NoOfCreditCardTransactions", Details.NoOfCreditCardTransactions); cmd.Parameters.AddWithValue("NoOfCreditTransactions", Details.NoOfCreditTransactions); cmd.Parameters.AddWithValue("NoOfCombinationPaymentTransactions", Details.NoOfCombinationPaymentTransactions); cmd.Parameters.AddWithValue("NoOfCreditPaymentTransactions", Details.NoOfCreditPaymentTransactions); cmd.Parameters.AddWithValue("NoOfClosedTransactions", Details.NoOfClosedTransactions); cmd.Parameters.AddWithValue("NoOfRefundTransactions", Details.NoOfRefundTransactions); cmd.Parameters.AddWithValue("NoOfVoidTransactions", Details.NoOfVoidTransactions); cmd.Parameters.AddWithValue("NoOfTotalTransactions", Details.NoOfTotalTransactions); cmd.Parameters.AddWithValue("CashCount", Details.CashCount); cmd.Parameters.AddWithValue("LastLoginDate", Details.LastLoginDate); cmd.Parameters.AddWithValue("TotalDeposit", Details.TotalDeposit); cmd.Parameters.AddWithValue("CashDeposit", Details.CashDeposit); cmd.Parameters.AddWithValue("ChequeDeposit", Details.ChequeDeposit); cmd.Parameters.AddWithValue("CreditCardDeposit", Details.CreditCardDeposit); cmd.Parameters.AddWithValue("DebitPayment", Details.DebitPayment); cmd.Parameters.AddWithValue("NoOfDebitPaymentTransactions", Details.NoOfDebitPaymentTransactions); cmd.Parameters.AddWithValue("TotalCharge", Details.TotalCharge); cmd.Parameters.AddWithValue("IsCashCountInitialized", Details.IsCashCountInitialized); cmd.Parameters.AddWithValue("NoOfDiscountedTransactions", Details.NoOfDiscountedTransactions); cmd.Parameters.AddWithValue("NegativeAdjustments", Details.NegativeAdjustments); cmd.Parameters.AddWithValue("NoOfNegativeAdjustmentTransactions", Details.NoOfNegativeAdjustmentTransactions); cmd.Parameters.AddWithValue("PromotionalItems", Details.PromotionalItems); cmd.Parameters.AddWithValue("CreditSalesTax", Details.CreditSalesTax); cmd.Parameters.AddWithValue("DebitDeposit", Details.DebitDeposit); cmd.Parameters.AddWithValue("RewardPointsPayment", Details.RewardPointsPayment); cmd.Parameters.AddWithValue("RewardConvertedPayment", Details.RewardConvertedPayment); cmd.Parameters.AddWithValue("NoOfRewardPointsPayment", Details.NoOfRewardPointsPayment); cmd.Parameters.AddWithValue("CreditPaymentCash", Details.CreditPaymentCash); cmd.Parameters.AddWithValue("CreditPaymentCheque", Details.CreditPaymentCheque); cmd.Parameters.AddWithValue("CreditPaymentCreditCard", Details.CreditPaymentCreditCard); cmd.Parameters.AddWithValue("CreditPaymentDebit", Details.CreditPaymentDebit); cmd.Parameters.AddWithValue("RefundCash", Details.RefundCash); cmd.Parameters.AddWithValue("RefundCheque", Details.RefundCheque); cmd.Parameters.AddWithValue("RefundCreditCard", Details.RefundCreditCard); cmd.Parameters.AddWithValue("RefundCredit", Details.RefundCredit); cmd.Parameters.AddWithValue("RefundDebit", Details.RefundDebit); cmd.Parameters.AddWithValue("NoOfConsignmentTransactions", Details.NoOfConsignmentTransactions); cmd.Parameters.AddWithValue("NoOfConsignmentRefundTransactions", Details.NoOfConsignmentRefundTransactions); cmd.Parameters.AddWithValue("NoOfWalkInTransactions", Details.NoOfWalkInTransactions); cmd.Parameters.AddWithValue("NoOfWalkInRefundTransactions", Details.NoOfWalkInRefundTransactions); cmd.Parameters.AddWithValue("NoOfOutOfStockTransactions", Details.NoOfOutOfStockTransactions); cmd.Parameters.AddWithValue("NoOfOutOfStockRefundTransactions", Details.NoOfOutOfStockRefundTransactions); cmd.Parameters.AddWithValue("ConsignmentSales", Details.ConsignmentSales); cmd.Parameters.AddWithValue("ConsignmentRefundSales", Details.ConsignmentRefundSales); cmd.Parameters.AddWithValue("WalkInSales", Details.WalkInSales); cmd.Parameters.AddWithValue("WalkInRefundSales", Details.WalkInRefundSales); cmd.Parameters.AddWithValue("OutOfStockSales", Details.OutOfStockSales); cmd.Parameters.AddWithValue("OutOfStockRefundSales", Details.OutOfStockRefundSales); cmd.Parameters.AddWithValue("CreatedOn", Details.CreatedOn == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.CreatedOn); cmd.Parameters.AddWithValue("LastModified", Details.LastModified == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : Details.LastModified); cmd.CommandText = SQL; return(base.ExecuteNonQuery(cmd)); } catch (Exception ex) { throw base.ThrowException(ex); } }