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; }