コード例 #1
0
ファイル: CashierReport.cs プロジェクト: marioricci/erp-luma
		public void UpdateTransactionSales(CashierReportDetails Details)
		{
			try 
			{
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

				string SQL = "CALL procCashierReportUpdateTransactionSales(@BranchID, @TerminalNo,@CashierID," +
                                    "@NetSales, " +
                                    "@GrossSales, " +
                                    "@TotalDiscount, " +
                                    "@SNRDiscount, " +
                                    "@PWDDiscount, " +
                                    "@OtherDiscount, " +
                                    "@TotalCharge, " +
                                    "@DailySales, " +
                                    "@ItemSold, " +
                                    "@QuantitySold, " +
                                    "@GroupSales, " +
                                    "@VATExempt, " +
                                    "@NonVATableAmount, " +
                                    "@VATableAmount, " +
                                    "@ZeroRatedSales, " +
                                    "@VAT, " +
                                    "@EVATableAmount, " +
                                    "@NonEVATableAmount, " +
                                    "@EVAT, " +
                                    "@LocalTax, " +
                                    "@CashSales, " +
                                    "@ChequeSales, " +
                                    "@CreditCardSales, " +
                                    "@CreditSales, " +
                                    "@CreditPayment, " +
                                    "@CreditPaymentCash, " +
                                    "@CreditPaymentCheque, " +
                                    "@CreditPaymentCreditCard, " +
                                    "@CreditPaymentDebit, " +
                                    "@DebitPayment, " +
                                    "@RewardPointsPayment, " +
                                    "@RewardConvertedPayment, " +
                                    "@CashInDrawer, " +
                                    "@VoidSales, " +
                                    "@RefundSales, " +
                                    "@ItemsDiscount, " +
                                    "@SNRItemsDiscount, " +
                                    "@PWDItemsDiscount, " +
                                    "@OtherItemsDiscount, " +
                                    "@SubTotalDiscount, " +
                                    "@NoOfCashTransactions, " +
                                    "@NoOfChequeTransactions, " +
                                    "@NoOfCreditCardTransactions, " +
                                    "@NoOfCreditTransactions, " +
                                    "@NoOfCombinationPaymentTransactions, " +
                                    "@NoOfCreditPaymentTransactions, " +
                                    "@NoOfDebitPaymentTransactions, " +
                                    "@NoOfClosedTransactions, " +
                                    "@NoOfRefundTransactions, " +
                                    "@NoOfVoidTransactions, " +
                                    "@NoOfRewardPointsPayment, " +
                                    "@NoOfTotalTransactions, " +
                                    "@NoOfDiscountedTransactions, " +
                                    "@NegativeAdjustments, " +
                                    "@NoOfNegativeAdjustmentTransactions, " +
                                    "@NoOfConsignmentTransactions, " +
                                    "@NoOfConsignmentRefundTransactions, " +
                                    "@NoOfWalkInTransactions, " +
                                    "@NoOfWalkInRefundTransactions, " +
                                    "@NoOfOutOfStockTransactions, " +
                                    "@NoOfOutOfStockRefundTransactions, " +
                                    "@PromotionalItems, " +
                                    "@CreditSalesTax);";

                cmd.Parameters.AddWithValue("NetSales", Details.NetSales);
				cmd.Parameters.AddWithValue("GrossSales", Details.GrossSales);
                cmd.Parameters.AddWithValue("TotalDiscount", Details.TotalDiscount);
                cmd.Parameters.AddWithValue("SNRDiscount", Details.SNRDiscount);
                cmd.Parameters.AddWithValue("PWDDiscount", Details.PWDDiscount);
                cmd.Parameters.AddWithValue("OtherDiscount", Details.OtherDiscount);
                cmd.Parameters.AddWithValue("TotalCharge", Details.TotalCharge);
                cmd.Parameters.AddWithValue("DailySales", Details.DailySales);
                cmd.Parameters.AddWithValue("ItemSold", Details.ItemSold);
                cmd.Parameters.AddWithValue("QuantitySold", Details.QuantitySold);
                cmd.Parameters.AddWithValue("GroupSales", Details.GroupSales);
                
                cmd.Parameters.AddWithValue("VATExempt", Details.VATExempt);
                cmd.Parameters.AddWithValue("NonVATableAmount", Details.NonVATableAmount);
                cmd.Parameters.AddWithValue("VATableAmount", Details.VATableAmount);
                cmd.Parameters.AddWithValue("ZeroRatedSales", Details.ZeroRatedSales);
                cmd.Parameters.AddWithValue("VAT", Details.VAT);
                cmd.Parameters.AddWithValue("EVATableAmount", Details.EVATableAmount);
                cmd.Parameters.AddWithValue("NonEVATableAmount", Details.NonEVATableAmount);
                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("CreditPaymentCash", Details.CreditPaymentCash);
                cmd.Parameters.AddWithValue("CreditPaymentCheque", Details.CreditPaymentCheque);
                cmd.Parameters.AddWithValue("CreditPaymentCreditCard", Details.CreditPaymentCreditCard);
                cmd.Parameters.AddWithValue("CreditPaymentDebit", Details.CreditPaymentDebit);
                cmd.Parameters.AddWithValue("DebitPayment", Details.DebitPayment);
                cmd.Parameters.AddWithValue("RewardPointsPayment", Details.RewardPointsPayment);
                cmd.Parameters.AddWithValue("RewardConvertedPayment", Details.RewardConvertedPayment);
                cmd.Parameters.AddWithValue("CashInDrawer", Details.CashInDrawer == 0 ? Details.CashSales : Details.CashInDrawer);
                cmd.Parameters.AddWithValue("VoidSales", Details.VoidSales);
                cmd.Parameters.AddWithValue("RefundSales", Details.RefundSales);
                cmd.Parameters.AddWithValue("ItemsDiscount", Details.ItemsDiscount);
                cmd.Parameters.AddWithValue("SNRItemsDiscount", Details.SNRItemsDiscount);
                cmd.Parameters.AddWithValue("PWDItemsDiscount", Details.PWDItemsDiscount);
                cmd.Parameters.AddWithValue("OtherItemsDiscount", Details.OtherItemsDiscount);
                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("NoOfDebitPaymentTransactions", Details.NoOfDebitPaymentTransactions);
                cmd.Parameters.AddWithValue("NoOfClosedTransactions", Details.NoOfClosedTransactions);
                cmd.Parameters.AddWithValue("NoOfRefundTransactions", Details.NoOfRefundTransactions);
                cmd.Parameters.AddWithValue("NoOfVoidTransactions", Details.NoOfVoidTransactions);
                cmd.Parameters.AddWithValue("NoOfRewardPointsPayment", Details.NoOfRewardPointsPayment);
                cmd.Parameters.AddWithValue("NoOfTotalTransactions", Details.NoOfTotalTransactions);
                cmd.Parameters.AddWithValue("NoOfDiscountedTransactions", Details.NoOfDiscountedTransactions);
                cmd.Parameters.AddWithValue("NegativeAdjustments", Details.NegativeAdjustments);
                cmd.Parameters.AddWithValue("NoOfNegativeAdjustmentTransactions", Details.NoOfNegativeAdjustmentTransactions);
                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("PromotionalItems", Details.PromotionalItems);
                cmd.Parameters.AddWithValue("CreditSalesTax", Details.CreditSalesTax);
                cmd.Parameters.AddWithValue("BranchID", Details.BranchID);
                cmd.Parameters.AddWithValue("TerminalNo", Details.TerminalNo);
                cmd.Parameters.AddWithValue("CashierID", Details.CashierID);

                cmd.CommandText = SQL;
				base.ExecuteNonQuery(cmd);
			}

			catch (Exception ex)
			{
				throw base.ThrowException(ex);
			}	
		}
コード例 #2
0
ファイル: CashierReport.cs プロジェクト: marioricci/erp-luma
        public Int32 Save(CashierReportDetails Details)
        {
            try
            {
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandType = System.Data.CommandType.Text;

                string SQL = "CALL procSaveCashierReport(@BranchID, @TerminalNo, @SyncID, @CashierReportID, @CashierID, @TerminalID, @NetSales, @GrossSales, " +
                                        "@TotalDiscount, @SNRDiscount, @PWDDiscount, @OtherDiscount, @DailySales," +
                                        "@ItemSold, @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, @SNRItemsDiscount, @PWDItemsDiscount, @OtherItemsDiscount, @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("CashierReportID", Details.CashierReportID);
                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("SNRDiscount", Details.SNRDiscount);
                cmd.Parameters.AddWithValue("PWDDiscount", Details.PWDDiscount);
                cmd.Parameters.AddWithValue("OtherDiscount", Details.OtherDiscount);
                cmd.Parameters.AddWithValue("DailySales", Details.DailySales);
                cmd.Parameters.AddWithValue("ItemSold", Details.ItemSold);
                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("SNRItemsDiscount", Details.SNRItemsDiscount);
                cmd.Parameters.AddWithValue("PWDItemsDiscount", Details.PWDItemsDiscount);
                cmd.Parameters.AddWithValue("OtherItemsDiscount", Details.OtherItemsDiscount);
                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);
            }
        }
コード例 #3
0
ファイル: CashierReport.cs プロジェクト: marioricci/erp-luma
        public static CashierReportDetails SetDetails(System.Data.DataTable dt)
        {
            CashierReportDetails Details = new CashierReportDetails();

            foreach (System.Data.DataRow dr in dt.Rows)
            {
                Details.BranchID = Int32.Parse(dr["BranchID"].ToString());
                Details.TerminalNo = dr["TerminalNo"].ToString();
                Details.CashierID = Int64.Parse(dr["CashierID"].ToString());
                Details.NetSales = decimal.Parse(dr["NetSales"].ToString());
                Details.GrossSales = decimal.Parse(dr["GrossSales"].ToString());
                Details.TotalDiscount = decimal.Parse(dr["TotalDiscount"].ToString());
                Details.SNRDiscount = decimal.Parse(dr["SNRDiscount"].ToString());
                Details.PWDDiscount = decimal.Parse(dr["PWDDiscount"].ToString());
                Details.OtherDiscount = decimal.Parse(dr["OtherDiscount"].ToString());
                Details.TotalCharge = decimal.Parse(dr["TotalCharge"].ToString());
                Details.DailySales = decimal.Parse(dr["DailySales"].ToString());
                Details.ItemSold = decimal.Parse(dr["ItemSold"].ToString());
                Details.QuantitySold = decimal.Parse(dr["QuantitySold"].ToString());
                Details.GroupSales = decimal.Parse(dr["GroupSales"].ToString());
                Details.VATExempt = decimal.Parse(dr["VATExempt"].ToString());
                Details.NonVATableAmount = decimal.Parse(dr["NonVATableAmount"].ToString());
                Details.VAT = decimal.Parse(dr["VAT"].ToString());
                Details.VATableAmount = decimal.Parse(dr["VATableAmount"].ToString());
                Details.ZeroRatedSales = decimal.Parse(dr["ZeroRatedSales"].ToString());
                Details.LocalTax = decimal.Parse(dr["LocalTax"].ToString());
                Details.CashSales = decimal.Parse(dr["CashSales"].ToString());
                Details.ChequeSales = decimal.Parse(dr["ChequeSales"].ToString());
                Details.CreditCardSales = decimal.Parse(dr["CreditCardSales"].ToString());
                Details.CreditSales = decimal.Parse(dr["CreditSales"].ToString());
                Details.RefundCash = decimal.Parse(dr["RefundCash"].ToString());
                Details.RefundCheque = decimal.Parse(dr["RefundCheque"].ToString());
                Details.RefundCreditCard = decimal.Parse(dr["RefundCreditCard"].ToString());
                Details.RefundCredit = decimal.Parse(dr["RefundCredit"].ToString());
                Details.RefundDebit = decimal.Parse(dr["RefundDebit"].ToString());
                Details.CreditPayment = decimal.Parse(dr["CreditPayment"].ToString());
                Details.CreditPaymentCash = decimal.Parse(dr["CreditPaymentCash"].ToString());
                Details.CreditPaymentCheque = decimal.Parse(dr["CreditPaymentCheque"].ToString());
                Details.CreditPaymentCreditCard = decimal.Parse(dr["CreditPaymentCreditCard"].ToString());
                Details.CreditPaymentDebit = decimal.Parse(dr["CreditPaymentDebit"].ToString());
                Details.DebitPayment = decimal.Parse(dr["DebitPayment"].ToString());
                Details.RewardPointsPayment = decimal.Parse(dr["RewardPointsPayment"].ToString());
                Details.RewardConvertedPayment = decimal.Parse(dr["RewardConvertedPayment"].ToString());
                Details.CashInDrawer = decimal.Parse(dr["CashInDrawer"].ToString());
                Details.TotalDisburse = decimal.Parse(dr["TotalDisburse"].ToString());
                Details.CashDisburse = decimal.Parse(dr["CashDisburse"].ToString());
                Details.ChequeDisburse = decimal.Parse(dr["ChequeDisburse"].ToString());
                Details.CreditCardDisburse = decimal.Parse(dr["CreditCardDisburse"].ToString());
                Details.TotalWithHold = decimal.Parse(dr["TotalWithHold"].ToString());
                Details.CashWithHold = decimal.Parse(dr["CashWithHold"].ToString());
                Details.ChequeWithHold = decimal.Parse(dr["ChequeWithHold"].ToString());
                Details.CreditCardWithHold = decimal.Parse(dr["CreditCardWithHold"].ToString());
                Details.TotalPaidOut = decimal.Parse(dr["TotalPaidOut"].ToString());
                Details.TotalDeposit = decimal.Parse(dr["TotalDeposit"].ToString());
                Details.CashDeposit = decimal.Parse(dr["CashDeposit"].ToString());
                Details.ChequeDeposit = decimal.Parse(dr["ChequeDeposit"].ToString());
                Details.CreditCardDeposit = decimal.Parse(dr["CreditCardDeposit"].ToString());
                Details.BeginningBalance = decimal.Parse(dr["BeginningBalance"].ToString());
                Details.VoidSales = decimal.Parse(dr["VoidSales"].ToString());
                Details.RefundSales = decimal.Parse(dr["RefundSales"].ToString());
                Details.ItemsDiscount = decimal.Parse(dr["ItemsDiscount"].ToString());
                Details.SNRItemsDiscount = decimal.Parse(dr["SNRItemsDiscount"].ToString());
                Details.PWDItemsDiscount = decimal.Parse(dr["PWDItemsDiscount"].ToString());
                Details.OtherItemsDiscount = decimal.Parse(dr["OtherItemsDiscount"].ToString());
                Details.SubTotalDiscount = decimal.Parse(dr["SubTotalDiscount"].ToString());
                Details.NoOfCashTransactions = Int32.Parse(dr["NoOfCashTransactions"].ToString());
                Details.NoOfChequeTransactions = Int32.Parse(dr["NoOfChequeTransactions"].ToString());
                Details.NoOfCreditCardTransactions = Int32.Parse(dr["NoOfCreditCardTransactions"].ToString());
                Details.NoOfCreditTransactions = Int32.Parse(dr["NoOfCreditTransactions"].ToString());
                Details.NoOfCombinationPaymentTransactions = Int32.Parse(dr["NoOfCombinationPaymentTransactions"].ToString());
                Details.NoOfCreditPaymentTransactions = Int32.Parse(dr["NoOfCreditPaymentTransactions"].ToString());
                Details.NoOfDebitPaymentTransactions = Int32.Parse(dr["NoOfDebitPaymentTransactions"].ToString());
                Details.NoOfClosedTransactions = Int32.Parse(dr["NoOfTotalTransactions"].ToString());
                Details.NoOfRefundTransactions = Int32.Parse(dr["NoOfRefundTransactions"].ToString());
                Details.NoOfVoidTransactions = Int32.Parse(dr["NoOfVoidTransactions"].ToString());
                Details.NoOfRewardPointsPayment = Int32.Parse(dr["NoOfRewardPointsPayment"].ToString());
                Details.NoOfTotalTransactions = Int32.Parse(dr["NoOfTotalTransactions"].ToString());
                Details.NoOfConsignmentTransactions = Int32.Parse(dr["NoOfConsignmentTransactions"].ToString());
                Details.NoOfConsignmentRefundTransactions = Int32.Parse(dr["NoOfConsignmentRefundTransactions"].ToString());
                Details.NoOfWalkInTransactions = Int32.Parse(dr["NoOfWalkInTransactions"].ToString());
                Details.NoOfWalkInRefundTransactions = Int32.Parse(dr["NoOfWalkInRefundTransactions"].ToString());
                Details.NoOfOutOfStockTransactions = Int32.Parse(dr["NoOfOutOfStockTransactions"].ToString());
                Details.NoOfOutOfStockRefundTransactions = Int32.Parse(dr["NoOfOutOfStockRefundTransactions"].ToString());
                Details.ConsignmentSales = decimal.Parse(dr["ConsignmentSales"].ToString());
                Details.ConsignmentRefundSales = decimal.Parse(dr["ConsignmentRefundSales"].ToString());
                Details.WalkInSales = decimal.Parse(dr["WalkInSales"].ToString());
                Details.WalkInRefundSales = decimal.Parse(dr["WalkInRefundSales"].ToString());
                Details.OutOfStockSales = decimal.Parse(dr["OutOfStockSales"].ToString());
                Details.OutOfStockRefundSales = decimal.Parse(dr["OutOfStockRefundSales"].ToString());
                Details.CashCount = decimal.Parse(dr["CashCount"].ToString());
                Details.LastLoginDate = DateTime.Parse(dr["LastLoginDate"].ToString());
            }

            return Details;
        }