private void LoadCashierTransactionData()
        {

            try
            {

                TreasuryTransactions objTT = new TreasuryTransactions();
                _CashierHistory = objTT.GetCashierTransactionsData(StartDate, EndDate, UserNo, iRoute_No);

                foreach (rsp_CDM_GetCashierTransactionsSummary data in _CashierHistory.Summary)
                {
                    switch (data.Summary_Type.ToUpper())
                    {
                        case "CDPAIDAMOUNT":
                            objResult.CDPaidAmount = data.Amount;
                            objResult.CDPaidCount = data.Count_Summary;

                            break;
                        case "CDPRINTEDAMOUNT":
                            objResult.CDPrintedAmount = data.Amount;
                            objResult.CDPrintedCount = data.Count_Summary;
                            break;
                        case "HANDPAYAMOUNT":
                            objResult.HandPayAmount = data.Amount;
                            objResult.HandPayCount = data.Count_Summary;

                            break;
                        case "SHORTPAYAMOUNT":
                            objResult.ShortPayAmount = data.Amount;
                            objResult.ShortPayCount = data.Count_Summary;
                            break;
                        case "JACKPOTAMOUNT":
                            objResult.JackpotAmount = data.Amount;
                            objResult.JackpotCount = data.Count_Summary;
                            //chkjackpot
                            break;
                        case "PROGAMOUNT":
                            objResult.ProgAmount = data.Amount;
                            objResult.ProgCount = data.Count_Summary;
                            //chkProghandpays
                            break;
                        case "VOIDAMOUNT":
                            objResult.VoidAmount = data.Amount;
                            objResult.VoidCount = data.Count_Summary;
                            break;
                        case "MCPAIDAMOUNT":
                            objResult.MCPaidAmount = data.Amount;
                            objResult.MCPaidCount = data.Count_Summary;
                            break;
                        case "MCPRINTAMOUNT":
                            objResult.MCPrintAmount = data.Amount;
                            objResult.MCPrintCount = data.Count_Summary;
                            break;
                        case "ACTIVECASHABLEVOUCHERAMOUNT":
                            objResult.ActiveCashableVoucherAmount = data.Amount;
                            objResult.ActiveCashableVoucherCount = data.Count_Summary;
                            break;
                        case "VOIDTICKETSAMOUNT":
                            objResult.VoidTicketsAmount = data.Amount;
                            objResult.VoidTicketsCount = data.Count_Summary;
                            break;
                        case "VOIDVOUCHERAMOUNT":
                            objResult.VoidVoucherAmount = data.Amount;
                            objResult.VoidVoucherCount = data.Count_Summary;
                            break;
                        case "CANCELLEDAMOUNT":
                            objResult.CancelledAmount = data.Amount;
                            objResult.CancelledCount = data.Count_Summary;
                            break;
                        case "EXPIREDAMOUNT":
                            objResult.ExpiredAmount = data.Amount;
                            objResult.ExpiredCount = data.Count_Summary;
                            break;
                        case "TICKETINEXCEPTIONAMOUNT":
                            objResult.TicketInExceptionAmount = data.Amount;
                            objResult.TicketInExceptionCount = data.Count_Summary;
                            break;
                        case "TICKETOUTEXCEPTIONAMOUNT":
                            objResult.TicketOutExceptionAmount = data.Amount;
                            objResult.TicketOutExceptionCount = data.Count_Summary;
                            break;
                        case "CASHABLEVOUCHERLIABILITYAMOUNT":
                            objResult.CashableVoucherLiabilityAmount = data.Amount;
                            objResult.CashableVoucherLiabilityCount = data.Count_Summary;
                            break;
                        case "PROMOCASHABLEAMOUNT":
                            objResult.PromoCashableAmount = data.Amount;
                            objResult.PromoCashableCount = data.Count_Summary;
                            break;
                        case "NONCASHABLEINAMOUNT":
                            objResult.NonCashableINAmount = data.Amount;
                            objResult.NonCashableINCount = data.Count_Summary;
                            break;
                        case "NONCASHABLEOUTAMOUNT":
                            objResult.NonCashableOutAmount = data.Amount;
                            objResult.NonCashableOutCount = data.Count_Summary;
                            break;
                        case "OFFLINEVOUCHERAMOUNT":
                            objResult.OfflineVoucherAmount = data.Amount;
                            objResult.OfflineVoucherCount = data.Count_Summary;
                            break;
                        case "OUTSTANDINGHANDPAYSAMOUNT":
                            objResult.OutstandingHandpaysAmount = data.Amount;
                            objResult.OutstandingHandpaysCount = data.Count_Summary;
                            break;
                        default:
                            break;
                    }

                }
                Dispatcher.Invoke(new System.Action(
                                () =>
                                {
                                    base.DataContext = null;
                                    base.DataContext = objResult;
                                })
                        );

            }
            catch (Exception Ex)
            {

                ExceptionManager.Publish(Ex);
            }
        }
 public CashierHistory GetCashierTransactionsData(DateTime startDate, DateTime endDate, int UserNo, int iRoute_No)
 {
     LinqDataAccessDataContext objLinq = new LinqDataAccessDataContext(CommonDataAccess.TicketingConnectionString);
     CashierHistory cdo = new CashierHistory();
     var Result = objLinq.GetCashierTransactionsSummary_New(startDate, endDate, UserNo, iRoute_No);
     //cdo.Details = Result.GetResult<rsp_CDM_GetCashierTransactionsDetails_Details>().ToList();
     cdo.Summary = Result.ToList();
     return cdo;
 }