private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
IReports objReports = ReportsBusinessObject.CreateInstance();
using (CReportViewer objReportViewer = new CReportViewer())
{
DataSet dtTISPromotionalDetails = objReports.GetTISPromotionalDetails(this.StartDate, this.EndDate, NoOfRecordsInPage);
if (dtTISPromotionalDetails != null)
{
objReportViewer.PrintTISDetailsReport(dtTISPromotionalDetails, this.StartDate, this.EndDate, NoOfRecordsInPage);
objReportViewer.SetOwner(this);
objReportViewer.ShowDialog();
}
else
{
MessageBox.ShowBox("MessageID550", BMC_Icon.Information);
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
IReports objReports = ReportsBusinessObject.CreateInstance();
using (CReportViewer objReportViewer = new CReportViewer())
{
DataSet dtPromotionalHistory = objReports.GetPromotionalTicketHistory();
if (dtPromotionalHistory != null)
{
objReportViewer.PrintPromotionalHistoryReport(dtPromotionalHistory);
objReportViewer.SetOwner(Window.GetWindow(this));
objReportViewer.ShowDialog();
}
else
{
MessageBox.ShowBox("MessageID550", BMC_Icon.Information);
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void ShowExpenseDetailsReport(DateTime reportDate, string reportPeriod,bool IsGamingDayBasedReport,string SiteCode)
{
try
{
LogManager.WriteLog("Inside ShowExpenseDetailsReport method", LogManager.enumLogLevel.Info);
if (reportDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID281", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet expenseDetails = objReports.GetExpenseDetails(reportDate, reportPeriod, IsGamingDayBasedReport);
if (expenseDetails.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.ShowExpenseDetailsReport(expenseDetails, reportDate, reportPeriod, IsGamingDayBasedReport,SiteCode);
cReportViewer.ShowDialog();
}
LogManager.WriteLog("ShowExpenseDetailsReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void ShowStackerLevelDetailReport(int StackerLevel)
{
try
{
IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet dsStackerDetails = objReports.GetStackerDetails(StackerLevel);
//if (dsStackerDetails.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.ShowStackerLevelDetailReport(dsStackerDetails, StackerLevel,SiteCode);
cReportViewer.ShowDialog();
}
LogManager.WriteLog("ShowStackerLevelDetailReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void GetRedeemedTicketByDeviceReport(DateTime dtFromDate,DateTime dtToDate, string sDeviceType)
{
try
{
LogManager.WriteLog("Inside GetRedeemedTicketByDeviceReport method", LogManager.enumLogLevel.Info);
if (dtFromDate > dtToDate)
{
MessageBox.ShowBox("MessageID286", BMC_Icon.Information);
return;
}
if (dtFromDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID287", BMC_Icon.Information);
return;
}
if (dtToDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID288", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDataset = objReports.GetRedeemedTicketByDevice(dtFromDate, dtToDate, sDeviceType);
//if (dtDataset.Tables[0].Rows.Count == 0)
//{
// MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
// return;
//}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowRedeemedTicketByDevice("RedeemedTicketByDevice", dtDataset, dtFromDate, dtToDate, sDeviceType,SiteCode);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
public void CreateVaultCassettesCurrentDropReport(usp_Vault_DropResult Vault)
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowVaultCurrentDropSlip(Vault.Vault_ID, Vault.Name, Vault.Serial_NO, Vault.Manufacturer_Name, Vault.Type_Prefix, SecurityHelper.CurrentUser.DisplayName,
Convert.ToDateTime(Vault.CreatedDate), Vault.IsWebServiceEnabled, Convert.ToDecimal(Vault.FillAmount),
Convert.ToDecimal(Vault.TotalAmountOnFill), Convert.ToDecimal(Vault.CurrentBalance), _isfinaldrop);
cReportViewer.ShowDialog();
}
LogManager.WriteLog("Show Vault Drop Transaction Slip Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void ShowCrossPropertyLiabilityTransferSummaryReport(DateTime StartDate, DateTime EndDate)
{
try
{
LogManager.WriteLog("Inside ShowCrossPropertyLiabilityTransferSummaryReport method", LogManager.enumLogLevel.Info);
if (StartDate > EndDate)
{
MessageBox.ShowBox("MessageID286", BMC_Icon.Information);
return;
}
if (StartDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID287", BMC_Icon.Information);
return;
}
if (EndDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID288", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDataset = objReports.GetCrossPropertyLiabilityTransferSummaryReport(StartDate, EndDate);
if (dtDataset.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowCrossPropertyLiabilityTransferSummaryReport("CrossPropertyLiabilityTransferDetailsReport", dtDataset, StartDate, EndDate);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void GetIssuedTicketReport(DateTime dtFromDate, DateTime dtToDate, string sStatus, string sSlot)
{
try
{
LogManager.WriteLog("Inside GetIssuedTicketReport method", LogManager.enumLogLevel.Info);
if (dtFromDate > dtToDate)
{
MessageBox.ShowBox("MessageID286", BMC_Icon.Information);
return;
}
if (dtFromDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID287", BMC_Icon.Information);
return;
}
if (dtToDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID288", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDataset = objReports.GetVoucherListingReport(dtFromDate, dtToDate, sStatus,sSlot);
if (dtDataset.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowVoucherListingReport("VoucherListingReport", dtDataset, dtFromDate, dtToDate, sStatus,sSlot);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void PrintSpotCheckReport()
{
Installations objInstallationDetails = tvMachineList.SelectedItem as Installations;
if (objInstallationDetails == null) return;
List<SpotCheck> lstSpotCheck = new List<SpotCheck>();
lstSpotCheck = lstSpotCheckSummaryDetails.Where(item => item.InstallationNo == objInstallationDetails.Installation_No).ToList();
if (lstSpotCheck == null || lstSpotCheck.Count <= 0) return;
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowSpotCheckReport(
objInstallationDetails.Bar_Position_Name,
objInstallationDetails.Zone_Name.IsNullOrEmpty() ? string.Empty : objInstallationDetails.Zone_Name,
objInstallationDetails.GameTitle,//(Convert.ToDecimal(objInstallationDetails.POP) / 100).ToString(),
(Convert.ToDecimal(objInstallationDetails.POP)).ToString(),
lstSpotCheck[0].DateTimeStamp,
(lstSpotCheck[0].CashIn - lstSpotCheck[0].CashOut),
lstSpotCheck[0].CashIn,
Convert.ToDecimal(lstSpotCheck[0].Payout),
Convert.ToDecimal(lstSpotCheck[0].CoinsDrop.ToString("#,##0.00")),
lstSpotCheck[0].HandPay,
lstSpotCheck[0].Date,
Settings.SiteCode
);
cReportViewer.ShowDialog();
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
IReports objReports = ReportsBusinessObject.CreateInstance();
using (CReportViewer objReportViewer = new CReportViewer())
{
DataSet dtPromotionalHistory = objReports.GetPromotionalTicketHistory();
if (dtPromotionalHistory != null)
{
objReportViewer.PrintPromotionalHistoryReport(dtPromotionalHistory);
objReportViewer.SetOwner(Window.GetWindow(this));
objReportViewer.ShowDialog();
}
else
{
MessageBox.ShowBox("MessageID550", BMC_Icon.Information);
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
bool TicketShow = true;
if (!Security.SecurityHelper.HasAccess("BMC.Presentation.CashDeskManager.UserControls.CashDeskManagerAllDetails.lvViewAll.TicketValue"))
{
TicketShow = false;
}
btnPrint.IsEnabled = false;
//DataSet _DtDetails = BMC.Common.Utilities.CollectionExtensions.ToDataSet<CashierTransactionsDetails>(lstCashierTransactionsDetails, "DetailsView");
BMC.Business.CashDeskOperator.Reports objReports = new BMC.Business.CashDeskOperator.Reports();
//DataSet _DtDetails = objReports.GetCashierTransactionsDetails(true, true, true, true,
// true, true, true, true,
// true, true,
// true, true, true, true,
// true, true,
// true, true,
// StartDate, EndDate, user, iRoute_No);
if (dtTickets.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID47");
return;
}
using (CReportViewer objReportViewer = new CReportViewer())
{
objReportViewer.showDetailedReport(dtTickets, StartDate, EndDate, sFooterText, TicketShow);
objReportViewer.SetOwner(this);
objReportViewer.ShowDialog();
}
}
finally
{
btnPrint.IsEnabled = true;
}
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
IReports objReports = ReportsBusinessObject.CreateInstance();
using (CReportViewer objReportViewer = new CReportViewer())
{
DataSet dtTISPromotionalDetails= objReports.GetTISPromotionalDetails(this.StartDate,this.EndDate,NoOfRecordsInPage);
if (dtTISPromotionalDetails != null)
{
objReportViewer.PrintTISDetailsReport(dtTISPromotionalDetails, this.StartDate, this.EndDate, NoOfRecordsInPage);
objReportViewer.SetOwner(this);
objReportViewer.ShowDialog();
}
else
{
MessageBox.ShowBox("MessageID550", BMC_Icon.Information);
}
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
/// <summary>
/// Displays the Exception Summary Report for selected collection batch in a new dialog
/// </summary>
private void CreateExceptionSummaryReport()
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
if (!string.IsNullOrEmpty(ExchangeConst) && !string.IsNullOrEmpty(TicketConst))
cReportViewer.ShowExceptionSummaryReport(_BatchID, ExchangeConst, TicketConst);
else
cReportViewer.ShowExceptionSummaryReport(_BatchID);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateWeeklyExceptionSummaryReport(int WeekID)
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowWeeklyExceptionSummary(WeekID);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void CreateLiquidationReport()
{
try
{
if (Settings.SGVI_Enabled)
{
CreateSGVILiquidationReport();
return;
}
IReports objReports = isCommonCDOforDeclaration ? ReportsBusinessObject.CreateInstance(ExchangeConst, TicketConst) : ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Check whether the Liquidation performed for the batch or not-Starts", LogManager.enumLogLevel.Info);
int? iLiquidationPerformed = 0;
int isLiquidationPerformedForBatch = objReports.CheckLiquidationPerformed(_BatchID, ref iLiquidationPerformed);
if (isLiquidationPerformedForBatch == 0)
{
MessageBox.ShowBox("MessageID891", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Launch the liquidation report", LogManager.enumLogLevel.Info);
cReportViewer.ShowLiquidationReportForRead(_BatchID, null);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.ShowDialog();
}
LogManager.WriteLog("ShowLiquidationReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void ShowJackpotSlipSummaryReport(DateTime reportStartDateTime, DateTime reportEndDateTime)
{
try
{
LogManager.WriteLog("Inside ShowJackportSlipSummaryReport method", LogManager.enumLogLevel.Info);
if (reportStartDateTime > reportEndDateTime)
{
MessageBox.ShowBox("MessageID282", BMC_Icon.Information);
return;
}
if (reportStartDateTime > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID283", BMC_Icon.Information);
return;
}
if (reportEndDateTime > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID288", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
DataSet jackpotSlipSummaryDetails = objReports.GetJackpotSlipSummaryDetails(reportStartDateTime,
reportEndDateTime,chkIncludeHandpay.IsChecked,chkIncludeJackpot.IsChecked);
if (jackpotSlipSummaryDetails.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.ShowJackpotSlipSummaryReport(jackpotSlipSummaryDetails, reportStartDateTime, reportEndDateTime,
chkIncludeHandpay.IsChecked,chkIncludeJackpot.IsChecked);
cReportViewer.ShowDialog();
}
LogManager.WriteLog("ShowJackportSlipSummaryReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void ShowMeterListReport(string installationNo, string assetNo)
{
DataSet dsMeterDetails = null;
DataSet dsMeterDetail = null;
try
{
LogManager.WriteLog("Inside ShowMeterListReport method", LogManager.enumLogLevel.Info);
dsMeterDetails = new DataSet();
IReports objReports = ReportsBusinessObject.CreateInstance();
if (installationNo == "ALL")
{
LogManager.WriteLog("Fetching Asset Numbers from database....", LogManager.enumLogLevel.Info);
DataTable dtAssetNumbers = objReports.GetAssetNumberforActiveInstallations();
if (dtAssetNumbers.Rows.Count > 0)
{
LogManager.WriteLog("Asset Numbers fetched successfully from database", LogManager.enumLogLevel.Info);
foreach (DataRow dataRow in dtAssetNumbers.Rows)
{
LogManager.WriteLog(string.Format("{0} - {1}", "Fetching report data from database for Installation No",
dataRow["InstallationNo"].ToString()), LogManager.enumLogLevel.Info);
dsMeterDetail = objReports.GetMeterDetails(Convert.ToInt32(dataRow["InstallationNo"]));
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
LogManager.WriteLog("Merging dataset...", LogManager.enumLogLevel.Info);
dsMeterDetails.Merge(dsMeterDetail);
LogManager.WriteLog("Merge dataset Successfull", LogManager.enumLogLevel.Info);
if (dsMeterDetail != null) { dsMeterDetail = null; }
}
}
else
{
LogManager.WriteLog("Asset Number not available - Return", LogManager.enumLogLevel.Info);
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
}
else
{
LogManager.WriteLog("Fetching report data from database...", LogManager.enumLogLevel.Info);
dsMeterDetails = objReports.GetMeterDetails(Convert.ToInt32(installationNo));
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
}
if (dsMeterDetails.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())
{
cReportViewer.ShowMeterListReport(dsMeterDetails, assetNo);
cReportViewer.ShowDialog();
}
LogManager.WriteLog("ShowMeterListReport Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void btnConfirm_Click(object sender, RoutedEventArgs e)
{
try
{
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")
{
//Update advance retailer value
//UpdateAdvanceRetailer();
//Calculate the retailer negative net
//CalculateRetailerNegative();
//CalculateCarriedForwardAmount();
if (Entity.ProfitShareGroupId > 0)
{
//Sp call for profit share details
CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString);
int LiquidationProfitShareResult = objCommonLiquidation.PerformLiquidationForProfitShare(null,
_BatchNo,
_entity.ProfitShareGroupId,
_entity.ExpenseShareGroupID,
_entity.ExpenseShareAmount,
_entity.WriteOffAmount,
_entity.PayPeriodId,
_entity.Gross,
_entity.Tickets_Expected,
_entity.Net_Percentage,
_entity.Retailer_Negative_Net,
_entity.Net_Percentage,
_entity.Tickets_Paid,
_entity.Advance_To_Retailer,
_entity.Retailer_Share,
_entity.Balance_Due,
_entity.Retailer,
_entity.RetailerShareBeforeFixedExpense,
_entity.CarriedForwardExpense,
_entity.RetailerExpenseShareAmount,
_entity.FixedExpenseAmount,
_entity.PrevCarriedForwardExpense);
//Report
MessageBox.ShowBox("MessageID488", BMC_Icon.Information);
//calling Audit Method
Audit(true, _BatchNo);
System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID491", 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(_BatchNo, null);
cReportViewer.ShowDialog();
}
}
}
else
{
MessageBox.ShowBox("MessageID490", BMC_Icon.Information);
return;
}
this.Close();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void ShowExceptionVoucherDetailReport(DateTime dtFromDate, DateTime dtToDate, Int32 BatchNumber,string SiteCode)
{
try
{
LogManager.WriteLog("Inside GetExceptionVoucherDetailReport method", LogManager.enumLogLevel.Info);
if (dtFromDate > dtToDate)
{
MessageBox.ShowBox("MessageID286", BMC_Icon.Information);
return;
}
if (dtFromDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID287", BMC_Icon.Information);
return;
}
if (dtToDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID288", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDataset = objReports.GetExceptionVoucherDetails(dtFromDate, dtToDate, chkDropBased.IsChecked, BatchNumber);
if (dtDataset.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowExceptionVoucherDetail("ExceptionVoucherDetails", dtDataset, dtFromDate, dtToDate, chkDropBased.IsChecked, BatchNumber,SiteCode);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void btnConfirm_Click(object sender, RoutedEventArgs e)
{
try
{
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")
{
//Update advance retailer value
//UpdateAdvanceRetailer();
//Calculate the retailer negative net
//CalculateRetailerNegative();
//CalculateCarriedForwardAmount();
if (Entity.ProfitShareGroupId > 0)
{
//Sp call for profit share details
CommonLiquidationDataContext objCommonLiquidation = new CommonLiquidationDataContext(CommonUtilities.ExchangeConnectionString);
int LiquidationProfitShareResult = objCommonLiquidation.PerformLiquidationForProfitShare(null,
_BatchNo,
_entity.ProfitShareGroupId,
_entity.ExpenseShareGroupID,
_entity.ExpenseShareAmount,
_entity.WriteOffAmount,
_entity.PayPeriodId,
_entity.Gross,
_entity.Tickets_Expected,
_entity.Net_Percentage,
_entity.Retailer_Negative_Net,
_entity.Net_Percentage,
_entity.Tickets_Paid,
_entity.Advance_To_Retailer,
_entity.Retailer_Share,
_entity.Balance_Due,
_entity.Retailer,
_entity.RetailerShareBeforeFixedExpense,
_entity.CarriedForwardExpense,
_entity.RetailerExpenseShareAmount,
_entity.FixedExpenseAmount,
_entity.PrevCarriedForwardExpense);
//Report
MessageBox.ShowBox("MessageID488", BMC_Icon.Information);
//calling Audit Method
Audit(true,_BatchNo);
System.Windows.Forms.DialogResult res = MessageBox.ShowBox("MessageID491", 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(_BatchNo, null);
cReportViewer.ShowDialog();
}
}
}
else
{
MessageBox.ShowBox("MessageID490", BMC_Icon.Information);
return;
}
this.Close();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void ShowAccountingWinLossReport(int ZoneNo, int MachineCategoryNo, DateTime StartDate, DateTime EndDate, string ZoneName, string Category, bool IncludeNonCashable)
{
try
{
LogManager.WriteLog("Inside ShowAccountingWinLossReport method", LogManager.enumLogLevel.Info);
if (StartDate > EndDate)
{
MessageBox.ShowBox("MessageID286", BMC_Icon.Information);
return;
}
if (StartDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID287", BMC_Icon.Information);
return;
}
if (EndDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID288", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDataset = objReports.GetAccountingWinLossReport(ZoneNo,MachineCategoryNo,StartDate, EndDate, IncludeNonCashable);
if (dtDataset.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowAccountingWinLossReport("AccountingWinLossReport", dtDataset, ZoneNo, MachineCategoryNo, StartDate, EndDate, ZoneName, Category, IncludeNonCashable);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
//
private void Print(IList<UndeclaredCollectionRecord> collectionRecords, string userName)
{
int batchNo = 0;
int nMachineCount = 0;
string sDropType = string.Empty;
string sExchangeConnectionString = string.Empty;
string sTicketConnectionString = string.Empty;
DataSet DSDeclaration;
ILiquidationDetails details = LiquidationBusinessObject.CreateInstance();
try
{
batchNo = ((UndeclaredCollection)cboMachineType.SelectedItem).Collection_Batch_No;
nMachineCount = collectionRecords.Count - 1;
sDropType = string.Empty;
foreach (UndeclaredCollectionRecord Collection in collectionRecords)
{
/*if (sDropType == string.Empty)
{
sDropType = Collection.Type == "Defloat" ? "Final" : "Standard";
}
else*/
{
switch (Collection.Type)
{
case "Defloat":
if (!sDropType.Contains("Final"))
sDropType = sDropType + (sDropType.Length >0?", ":"") + "Final";
break;
case "Total":
break;
default:
if (!sDropType.Contains("Standard"))
sDropType = sDropType + (sDropType.Length > 0 ? ", " : "") + "Standard";
break;
}
}
}
if (collectionRecords.Count >1)
{
if (collectionRecords[1].CollectionBatchNo == 0)
{
sDropType = "Part";
}
}
bool bAddShortPay = false;
try
{ bAddShortPay = Convert.ToBoolean(details.GetSetting("AddShortpayInVoucherOut")); }
catch{}
DSDeclaration = GetBatchDataset(collectionRecords, bAddShortPay);
if (DSDeclaration.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
if (isCommonCDOforDeclaration)
{
sExchangeConnectionString = (cboSiteCode.SelectedItem as SiteConfig).ExchangeConnectionString;
sTicketConnectionString = (cboSiteCode.SelectedItem as SiteConfig).TicketConnectionString;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowDeclarationReport(DSDeclaration, userName, batchNo, nMachineCount, sDropType,
sExchangeConnectionString, sTicketConnectionString);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void PrintonDrop(IList<UndeclaredCollectionRecord> collectionRecords, string userName)
{
// DataSet DeclarationPrint = CollectionExtensions.ToDataSet<UndeclaredCollectionRecord>(((IEnumerable<UndeclaredCollectionRecord>)Source), "DeclarationPrint");
int batchNo = 0;
int nMachineCount = 0;
string sDropType = string.Empty;
var lineHeader = new DataTable();
var lineItem = new DataTable("DeclarationPrint");
var isFirstRecord = true;
ILiquidationDetails details = LiquidationBusinessObject.CreateInstance();
bool bSGVIEnable = false;
string sAutoTicketDeclare = string.Empty;
lineHeader.Columns.Add("Date");
lineHeader.Columns.Add("DropNo");
lineHeader.Columns.Add("NoOfMachine");
lineHeader.Columns.Add("user");
lineHeader.Columns.Add("Bills");
lineHeader.Columns.Add("CoinsIn");
lineHeader.Columns.Add("TicketsIn");
lineHeader.Columns.Add("EFTIn");
lineHeader.Columns.Add("TotalCashIn");
lineHeader.Columns.Add("TicketsOut");
lineHeader.Columns.Add("EFTOut");
lineHeader.Columns.Add("CancelledCredits");
lineHeader.Columns.Add("Jackpots");
lineHeader.Columns.Add("CoinsOut");
lineHeader.Columns.Add("TotalCashOut");
lineHeader.Columns.Add("Asset");
lineHeader.Columns.Add("Pos");
//lineHeader.Columns.Add("NetWin");
lineItem.Columns.Add("Asset", typeof(string));
lineItem.Columns.Add("Pos", typeof(string));
lineItem.Columns.Add("Bills", typeof(decimal));
lineItem.Columns.Add("CoinsIn", typeof(decimal));
lineItem.Columns.Add("TicketsIn", typeof(decimal));
lineItem.Columns.Add("EFTIn", typeof(decimal));
lineItem.Columns.Add("TotalCashIn", typeof(decimal));
lineItem.Columns.Add("TicketsOut");
//lineItem.Columns.Add("EFTOut");
lineItem.Columns.Add("CancelledCredits", typeof(decimal));
//lineItem.Columns.Add("Jackpots");
//lineItem.Columns.Add("CoinsOut");
//lineItem.Columns.Add("TotalCashOut");
//lineItem.Columns.Add("NetWin");
try
{
batchNo = _batchnumberfordropPrint;
nMachineCount = collectionRecords.Count - 1;
bSGVIEnable = (Convert.ToBoolean(details.GetSetting("SGVI_Enabled")) && (details.GetSetting("Client") == "SGVI"));
sAutoTicketDeclare = Convert.ToString(details.GetSetting("TicketDeclarationMethod"));
foreach (var collectionRecord in collectionRecords)
{
//var dr = isFirstRecord ? lineHeader.NewRow() : lineItem.NewRow();
//if (isFirstRecord) { isFirstRecord = false;
// continue;
//}
var dr = lineItem.NewRow();
sDropType = collectionRecord.Type == "defloat" ? "Final" : "Standard";
dr["Bills"] = collectionRecord.TotalBillValue;
dr["CoinsIn"] = collectionRecord.TotalCoinsValue;
dr["TicketsIn"] = collectionRecord.TicketsInValue;
dr["EFTIn"] = collectionRecord.EFTInValue;
dr["TotalCashIn"] = (collectionRecord.TotalBillValue + collectionRecord.TotalCoinsValue + collectionRecord.TicketsInValue);
//dr["TotalCashIn"] = (collectionRecord.TotalBillValue + collectionRecord.TotalCoinsValue + collectionRecord.TicketsInValue)+ collectionRecord.EFTInValue);
if (bSGVIEnable)
{
dr["TicketsOut"] = collectionRecord.TicketsOutValue;// + collectionRecord.ShortPayValue);
dr["CancelledCredits"] = collectionRecord.AttendantPayValue;
}
else
{
if (sAutoTicketDeclare.ToUpper() == "AUTO")
dr["TicketsOut"] = collectionRecord.TicketsOutValue;
else
dr["TicketsOut"] = (collectionRecord.TicketsOutValue + collectionRecord.ShortPayValue);
dr["CancelledCredits"] = collectionRecord.AttendantPayValue + collectionRecord.JackpotValue;
}
//dr["Jackpots"] = collectionRecord.Jackpot;
//dr["CoinsOut"] = ((decimal)collectionRecord.CoinOutValue).GetUniversalCurrencyFormatWithSymbol();
//dr["EFTOut"] = ((decimal)0).GetUniversalCurrencyFormatWithSymbol();
//dr["TotalCashOut"] = (collectionRecord.TicketsOutValue + collectionRecord.ShortPayValue + collectionRecord.HandpayValue + collectionRecord.JackpotValue + collectionRecord.CoinOutValue).GetUniversalCurrencyFormatWithSymbol();
//dr["NetWin"] = ((collectionRecord.TotalBillValue + collectionRecord.TotalCoinsValue + collectionRecord.TicketsInValue + collectionRecord.EFTInValue)
// - (collectionRecord.TicketsOutValue + collectionRecord.HandpayValue + collectionRecord.JackpotValue + collectionRecord.ShortPayValue + collectionRecord.CoinOutValue)).GetUniversalCurrencyFormatWithSymbol();
//if (isFirstRecord)
//{
// dr["Date"] = DateTime.Now.GetUniversalDateFormat();
// dr["DropNo"] = collectionRecords[1].CollectionBatchNo == 0
// ? (object)"Interm Collection"
// : collectionRecords[1].CollectionBatchNo;
// dr["NoOfMachine"] = collectionRecords.Count - 1;
// dr["user"] = userName;
// lineHeader.Rows.Add(dr);
//}
//else
//{
dr["Asset"] = collectionRecord.AssetNo;
dr["Pos"] = collectionRecord.Position;
lineItem.Rows.Add(dr);
// }
isFirstRecord = false;
}
DataSet DSDeclaration = new DataSet("DeclarationPrint");
DSDeclaration.Tables.Add(lineItem);
IReports objReports = ReportsBusinessObject.CreateInstance();
if (DSDeclaration.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.DropSummaryReport(DSDeclaration, userName, batchNo, nMachineCount, sDropType);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}
private void GetVoucherCouponLiabilityReport(DateTime dtIssueDate,string sDeviceType,string sVoucherStatus )
{
try
{
LogManager.WriteLog("Inside GetVoucherCouponLiabilityReport method", LogManager.enumLogLevel.Info);
if (dtIssueDate > System.DateTime.Now)
{
MessageBox.ShowBox("MessageID285", BMC_Icon.Information);
return;
}
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDetails = objReports.GetVoucherCouponLiabilityReport(dtIssueDate, sDeviceType, sVoucherStatus);
if (dtDetails.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowVoucherCouponLiabilityReport("VoucherCouponLiabilityReport", dtDetails, dtIssueDate, sDeviceType, sVoucherStatus);
cReportViewer.ShowDialog();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
MessageBox.ShowBox("MessageID262", BMC_Icon.Error);
}
}