private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
if (lstReadReport.Items.Count <= 0)
{
MessageBox.ShowBox("MessageID526", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
ReadLiquidationReportRecords lstReadLiqRecords = lstReadReport.SelectedItem as ReadLiquidationReportRecords;
if (lstReadLiqRecords == null)
{
MessageBox.ShowBox("MessageID527", BMC_Icon.Information);
return;
}
cReportViewer.ShowLiquidationReportForRead(null, lstReadLiqRecords.ReadId);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateOutstandingVaultdropReport()
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowOutstandingVaultReport(false);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("Show Undeclared Drop Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateVaultEventDetailsReport(int Vault_Id, string Type, int No_Of_Records, string SearchKey, DateTime StartDate, DateTime EndDate)
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowVaultEventDetailReport(Vault_Id, Type, No_Of_Records, SearchKey, StartDate, EndDate);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("Show Undeclared Drop Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
DataTable dtHistory = null;
if (cmb_SelectTop.SelectedValue.ToString() == "All")
{
dtHistory = objVaultBiz.GetFillHistory(0, 0, ((rsp_Vault_GetTransactionTypesResult)cmbTransType.SelectedItem).TYPE_ID);
}
else
{
dtHistory = objVaultBiz.GetFillHistory(0, int.Parse(cmb_SelectTop.SelectedValue.ToString()), ((rsp_Vault_GetTransactionTypesResult)cmbTransType.SelectedItem).TYPE_ID);
}
if (dtHistory.Rows.Count == 0 || dtHistory.Rows.Count == 0)
{
LogManager.WriteLog("No Records found for the selected criteria - Return", LogManager.enumLogLevel.Info);
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
if (cmb_SelectTop.SelectedValue.ToString() == "All")
{
cReportViewer.ShowVaultFillHistory(dtHistory, 0, 0);
}
else
cReportViewer.ShowVaultFillHistory(dtHistory, 0, int.Parse(cmb_SelectTop.SelectedValue.ToString()));
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("ShowLiquidationReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
void PrintDrop(DataRow drBalance)
{
try
{
if (drBalance != null)
{
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowVaultCurrentDropSlip(int.Parse(cmb_DeviceName.SelectedValue.ToString()), drBalance["Name"].ToString(), drBalance["Serial_NO"].ToString(), drBalance["Manufacturer_Name"].ToString(),
drBalance["Type_Prefix"].ToString(), SecurityHelper.CurrentUser.DisplayName, Convert.ToDateTime(drBalance["CreatedDate"]), Convert.ToBoolean(drBalance["IsWebServiceEnabled"]),
Convert.ToDecimal(drBalance["FillAmount"]), Convert.ToDecimal(drBalance["TotalAmountOnFill"]), Convert.ToDecimal(drBalance["CurrentBalance"]), _IsFinalDrop);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
}
}
catch (Exception Ex)
{
ExceptionManager.Publish(Ex);
}
}
public void CreateVaultCurrentBalanceSlipReport(int Vault_Id, string VaultName, string Serial_No, string Manufacturer_Name, string Type_Prefix, string LoginUser,
DateTime CreatedDate, bool IsWebServiceEnabled, decimal FillAmount, decimal TotalAmountOnFill, decimal CurrentBalance)
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowVaultCurrentBalanceSlip(Vault_Id, VaultName, Serial_No, Manufacturer_Name, Type_Prefix, LoginUser, CreatedDate,
IsWebServiceEnabled, Convert.ToDecimal(FillAmount), Convert.ToDecimal(TotalAmountOnFill), Convert.ToDecimal(CurrentBalance));
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("Show Vault Current Balance Slip Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateVaultEventDetailsReport(int Vault_Id, string Type, int No_Of_Records, string SearchKey, DateTime StartDate, DateTime EndDate)
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowVaultEventDetailReport(Vault_Id, Type, No_Of_Records, SearchKey, StartDate, EndDate);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("Show Undeclared Drop Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateOutstandingVaultdropReport()
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowOutstandingVaultReport(false);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("Show Undeclared Drop Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void btnBalancing_Click(object sender, RoutedEventArgs e)
{
try
{
btnBalancing.IsEnabled = false;
if (StartDate > EndDate)
{
MessageBox.ShowBox("MessageID282", BMC_Icon.Information);
return;
}
if (StartDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID283", BMC_Icon.Information);
return;
}
if (EndDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID284", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet SystemBalancingDetails = null;
switch (URoleBased.Count)
{
case 0:
{
if (Security.SecurityHelper.CurrentUser.User_No == UserNo)
{
SystemBalancingDetails = objReports.GetSystemBalancingDetails(StartDate, EndDate, UserNo, iRoute_No);
}
break;
}
case 1:
{
if (UserNo == 0)
{
SystemBalancingDetails = objReports.GetSystemBalancingDetails(StartDate, EndDate, 0, iRoute_No);
}
else
{
SystemBalancingDetails = objReports.GetSystemBalancingDetails(StartDate, EndDate, UserNo, iRoute_No);
}
break;
}
}
if (SystemBalancingDetails.Tables[0].Rows.Count == 0)
{
LogManager.WriteLog("No Records found for the selected criteria - Return", LogManager.enumLogLevel.Info);
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowSystemBalancingReport(SystemBalancingDetails, StartDate, EndDate);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("ShowSystemBalancingReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
finally
{
btnBalancing.IsEnabled = true;
}
}
private void btnTicketAnomalies_Click(object sender, RoutedEventArgs e)
{
try
{
if (StartDate > EndDate)
{
MessageBox.ShowBox("MessageID282", BMC_Icon.Information);
return;
}
if (StartDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID283", BMC_Icon.Information);
return;
}
if (EndDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID284", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet TicketAnomalies = null;
TicketAnomalies = objReports.GetTicketAnomalies(StartDate, EndDate);
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database Ticket Anomalies Report", LogManager.enumLogLevel.Info);
cReportViewer.ShowTicketAnomaliesReport(StartDate, EndDate);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("Ticket Anomalies Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
btnPrint.IsEnabled = false;
if (_worker.IsBusy)
{
MessageBox.ShowBox("MessageID368", BMC_Icon.Information);
return;
}
if (StartDate > EndDate)
{
MessageBox.ShowBox("MessageID282", BMC_Icon.Information);
return;
}
if (StartDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID283", BMC_Icon.Information);
return;
}
if (EndDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID284", BMC_Icon.Information);
return;
}
if (isDateChanged)
{
btnProcess_Click(sender, e);
}
IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet CashdeskDetails = null;
String UserName = string.Empty;
User lstUser = cboUser.SelectedItem as User;
if (lstUser == null || String.IsNullOrEmpty(lstUser.UserName))
{
UserName = SecurityHelper.CurrentUser.UserName;
}
else
{
UserName = lstUser.UserName;
}
CashdeskDetails = new DataSet();
//Add this list in order amount/count
CashdeskDetails.Tables.Add("CDSummary");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPaidAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPaidCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPrintedAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CDPrintedCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("HandPayAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("HandPayCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("JackpotAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("JackpotCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ProgAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ProgCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ShortPayAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ShortPayCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("OfflineVoucherAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("OfflineVoucherCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPaidAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPaidCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPrintAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("MCPrintCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ActiveCashableVoucherAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ActiveCashableVoucherCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidTicketsAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidTicketsCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidVoucherAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("VoidVoucherCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CancelledAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CancelledCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ExpiredAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("ExpiredCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketInExceptionAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketInExceptionCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketOutExceptionAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("TicketOutExceptionCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CashableVoucherLiabilityAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("CashableVoucherLiabilityCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("PromoCashableAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("PromoCashableCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableINAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableINCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableOutAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("NonCashableOutCount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("OutstandingHandpaysAmount");
CashdeskDetails.Tables["CDSummary"].Columns.Add("OutstandingHandpaysCount");
CashdeskDetails.Tables["CDSummary"].Rows.Add(CashdeskDetails.Tables["CDSummary"].NewRow());
foreach (rsp_CDM_GetCashierTransactionsSummary item in _CashierHistory.Summary)
{
if (CashdeskDetails.Tables["CDSummary"].Columns.IndexOf(item.Summary_Type) < 0)
continue;
CashdeskDetails.Tables["CDSummary"].Rows[0][item.Summary_Type] = item.Amount.ToString();
CashdeskDetails.Tables["CDSummary"].Rows[0][CashdeskDetails.Tables["CDSummary"].Columns.IndexOf(item.Summary_Type) + 1] = item.Count_Summary.ToString();
}
//= objReports.GetCashDeskReconcilationDetails(StartDate, EndDate);
// CashdeskDetails = objReports.GetCashierTransactions(StartDate, EndDate, UserNo, iRoute_No);
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowCashierTransactionsHistoryReport(CashdeskDetails, StartDate, EndDate, UserNo, UserName, sRoute_Name, iRoute_No, CashdeskDetails.GetXml());
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("ShowCashDeskReconcilationReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
finally
{
btnPrint.IsEnabled = true;
}
}
private void btnConfirm_Click(object sender, RoutedEventArgs e)
{
try
{
if (objCommonLiquidation.ProfitShareGroupId <= 0)
{
MessageBox.ShowBox("MessageID490", BMC_Icon.Information);
return;
}
if (string.IsNullOrEmpty(txtAdvanceToRetailer.Text))
{
MessageBox.ShowBox("MessageID370", BMC_Icon.Information);
return;
}
decimal dAdvanceToRetailer = 0.0M;
if (!CheckForValidAdvanceToRetailValue(out dAdvanceToRetailer))
{
MessageBox.ShowBox("MessageID434", BMC_Icon.Information);
return;
}
System.Windows.Forms.DialogResult dr = MessageBox.ShowBox("MessageID371", BMC_Icon.Question, BMC_Button.YesNo);
if (dr.ToString() == "Yes")
{
//Calculate the retailer negative net
CalculateRetailerNegative();
if (oReadLiquidationConfiguration.SaveLiquidation(objCommonLiquidation) == 0)
{
MessageBox.ShowBox("MessageID488", BMC_Icon.Information);
Audit(true, objCommonLiquidation.Read_No);
System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID251", BMC_Icon.Question, BMC_Button.YesNo);
if (res == System.Windows.Forms.DialogResult.Yes)
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowLiquidationReportForRead(null, objCommonLiquidation.Read_No);
cReportViewer.SetOwner(this);
cReportViewer.Show();
}
}
}
else
{
MessageBox.ShowBox("MessageID489", BMC_Icon.Information);
return;
}
this.Close();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateBatchWinLossReport()
{
try
{
//IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowExceptionSummaryReport(_BatchID);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("ShowExceptionSummaryReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
LogManager.WriteLog("Report" + ex.Message, LogManager.enumLogLevel.Info);
}
}
private void ShowCollectionReport()
{
try
{
LogManager.WriteLog("ShowCollectionReport Start", LogManager.enumLogLevel.Info);
if (IsCommonCDO)
{
using (CReportViewer cReportViewer = new CReportViewer(_ExchangeConnectionString, _TicketingConnectionString))
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
if (_BatchID > 0)
{
cReportViewer.ShowCollectionReport(_BatchID, 0);
}
cReportViewer.Show();
}
}
else
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
if (_BatchID > 0)
{
cReportViewer.ShowCollectionReport(_BatchID, 0);
}
cReportViewer.Show();
}
}
LogManager.WriteLog("ShowCollectionReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateVarianceReport()
{
try
{
//IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet ExceptionDetails = objReports.GetExceptionSummary(_BatchID);
if (ExceptionDetails.Tables[0].Rows.Count == 0)
{
LogManager.WriteLog("No Records found for the selected criteria - Return", LogManager.enumLogLevel.Info);
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
if(IsCommonCDO)
{
using (CReportViewer cReportViewer = new CReportViewer(_ExchangeConnectionString, _TicketingConnectionString))
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowVarianceReport(_BatchID, _ExchangeConnectionString, _TicketingConnectionString);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
}
else
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowVarianceReport(_BatchID);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
}
LogManager.WriteLog("ShowExceptionSummaryReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
LogManager.WriteLog("Report" + ex.Message, LogManager.enumLogLevel.Info);
}
}
private void CreateLiquidationReport()
{
try
{
//IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet LiquidationDetails = objReports.GetLiquidationDetails(_BatchID);
DataSet LiquidationSummaryDetails = objReports.GetLiquidationSummaryDetails(_BatchID);
if (LiquidationDetails.Tables[0].Rows.Count == 0 || LiquidationSummaryDetails.Tables[0].Rows.Count == 0)
{
LogManager.WriteLog("No Records found for the selected criteria - Return", LogManager.enumLogLevel.Info);
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowLiquidationReport(LiquidationDetails, LiquidationSummaryDetails, _BatchID);
cReportViewer.SetOwner(System.Windows.Window.GetWindow(this));
cReportViewer.Show();
}
LogManager.WriteLog("ShowLiquidationReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
LogManager.WriteLog("Report" + ex.Message, LogManager.enumLogLevel.Info);
}
}
