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 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 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 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 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 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 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 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);
}
}
/// <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 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);
}
}
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);
}
}
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);
}
}
public void CreateVaultCassettesCurrentTransactionReport(usp_Vault_FillVaultResult Vault, string TransactionType)
{
try
{
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowVaultCurrentTransactionSlip(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), TransactionType);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.ShowDialog();
}
LogManager.WriteLog("Show Vault Transaction Slip Report Successfull", LogManager.enumLogLevel.Info);
}
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 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 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);
}
}
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 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 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;
}
}
