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 GetAFTAuditReport(DateTime dtFromDate, DateTime dtToDate)
{
try
{
LogManager.WriteLog("Inside GetAFTAuditReport method", LogManager.enumLogLevel.Info);
IReports objReports = ReportsBusinessObject.CreateInstance();
DataSet dtDataset = objReports.GetAFTAuditTrailReport(dtFromDate, dtToDate);
if (dtDataset.Tables[0].Rows.Count == 0)
{
MessageBox.ShowBox("MessageID261", BMC_Icon.Information);
return;
}
using (CReportViewer cReportViewer = new CReportViewer())
{
cReportViewer.ShowAFTAuditTrailReport("AFTAuditTrail", dtDataset, dtFromDate, dtToDate);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
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;
}
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 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 CreatePartCollectionReport(int Noofrecords)
{
try
{
IReports objReports = null;
DataSet dsPartCollDetails = null;
if (isCommonCDO)
{
if (!CollectionHelper.IsServerConnected((cboSiteCode.SelectedItem as SiteConfig).ExchangeConnectionString))
{
return;
}
if (!_collectionHelper.IsAuthorized(SecurityHelper.CurrentUser.SecurityUserID, "BMC.Presentation.CommonCDOforDeclaration"))
{
return;
}
objReports = ReportsBusinessObject.CreateInstance((cboSiteCode.SelectedItem as SiteConfig).ExchangeConnectionString, (cboSiteCode.SelectedItem as SiteConfig).TicketConnectionString);
}
else
{
objReports = ReportsBusinessObject.CreateInstance();
}
dsPartCollDetails = objReports.GetPartCollectionDetails(Noofrecords);
if (dsPartCollDetails.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((cboSiteCode.SelectedItem as SiteConfig).ExchangeConnectionString, (cboSiteCode.SelectedItem as SiteConfig).TicketConnectionString))
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowPartCollection(Noofrecords, (cboSiteCode.SelectedItem as SiteConfig).ExchangeConnectionString, (cboSiteCode.SelectedItem as SiteConfig).TicketConnectionString);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
}
else
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
cReportViewer.ShowPartCollection(Noofrecords);
cReportViewer.SetOwner(Window.GetWindow(this));
cReportViewer.Show();
}
}
LogManager.WriteLog("Show Part Collection Report Successfull", LogManager.enumLogLevel.Info);
}
catch (Exception ex)
{
ExceptionManager.Publish(ex);
}
}
private void ShowBatchWinLossReport()
{
try
{
LogManager.WriteLog("ShowBatchWinLossReport 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)
{
if (Settings.Region.ToUpper() == "UK")
{
cReportViewer.ShowBatchWinLossReportForUK(_BatchID, 0);
}
else
{
cReportViewer.ShowBatchWinLossReport(_BatchID, 0);
}
}
cReportViewer.Show();
}
}
else
{
using (CReportViewer cReportViewer = new CReportViewer())
{
LogManager.WriteLog("Report data fetched successfully from database", LogManager.enumLogLevel.Info);
if (_BatchID > 0)
{
if (Settings.Region.ToUpper() == "UK")
{
cReportViewer.ShowBatchWinLossReportForUK(_BatchID, 0);
}
else
{
cReportViewer.ShowBatchWinLossReport(_BatchID, 0);
}
}
cReportViewer.Show();
}
}
LogManager.WriteLog("ShowBatchWinLossReport 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);
}
}
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);
}
}
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 CreateExceptionSummaryReport()
{
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);
if (Settings.Region.ToUpper() == "UK")
{
cReportViewer.ShowExceptionSummaryReportUK(_BatchID, _ExchangeConnectionString, _TicketingConnectionString);
}
else
{
cReportViewer.ShowExceptionSummaryReport(_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);
if (Settings.Region.ToUpper() == "UK")
{
cReportViewer.ShowExceptionSummaryReportUK(_BatchID);
}
else
{
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 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);
}
}
