Crystal report Drill down tab won't print(WPF)

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Diagnostics;
using System.IO;
using Npgsql;
using DealerBuilt.Data;
using DealerBuilt.Data.Omnis;
using DealerBuilt.Models.Crystal;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
using NpgsqlTypes;
using DealerBuilt.Logging.File;
using CrystalViewer.Models;
namespace CrystalViewer
{
///
/// Interaction logic for MainWindow.xaml
///
public partial class CrystalWindow : Window
{
private string _userName;
private long _lySetupLocationId, _slSetupLocationId, _acSetupLocationId;
private string _newParameterProfileName = null;
private List<string> _availableCategories;
private Data _data;
private UserAccess _userAccess;
private List _reportUsers;
private List _profiles = new List();
private long[] _releaseSeqs = new long[0];
private GridLength _leftPanelWidth = new GridLength(235);
private ReportDocument _currentlyDisplayedReport;
private CrystalReport _currentlyDisplayedReportModel;
private string _basePath;
private SAPBusinessObjects.WPF.Viewer.ReportAlbum currentReportAlbum = null;
private ILog Log = new LogFile("CrystalViewer.{user}.log");
public CrystalWindow(long acSetupLocationId, long lySetupLocationId, long slSetupLocationId, string userName, UserAccess userAccess)
{
Log.Debug($"acSetupLocationId=[{acSetupLocationId}] lySetupLocationId=[{lySetupLocationId}] slSetupLocationId=[{slSetupLocationId}] userAccess=[{userAccess.ToString()}]");
_userAccess = userAccess;
var connectionDatas = DealerData.GetConnectionDatas();
_data = new Data(connectionDatas);
Log.Debug($"Database=[{_data.GetConnection().Database}]");
InitializeComponent();
Initialize(acSetupLocationId, lySetupLocationId, slSetupLocationId, userName);
}
public CrystalWindow(string connectionString, long acSetupLocationId, long lySetupLocationId, long slSetupLocationId, string userName)
{
// for testing
_userAccess = new UserAccess(true);
Log.Debug($"acSetupLocationId=[{acSetupLocationId}] lySetupLocationId=[{lySetupLocationId}] slSetupLocationId=[{slSetupLocationId}] userName=[{userName}]");
_data = new Data(connectionString.CheckSSL());
Log.Debug($"Database=[{_data.GetConnection().Database}]");
InitializeComponent();
Initialize(acSetupLocationId, lySetupLocationId, slSetupLocationId, userName);
}
public SAPBusinessObjects.WPF.Viewer.SearchEventHandler Search;
public void Initialize(long acSetupLocationId, long lySetupLocationId, long slSetupLocationId, string userName)
{
Log.Debug("Starting Initialize()...");
if (string.IsNullOrWhiteSpace(_data.ConnectionString))
{
throw new Exception("Internal error: invalid connection string");
}
_userName = userName;
_lySetupLocationId = lySetupLocationId;
_slSetupLocationId = slSetupLocationId;
_acSetupLocationId = acSetupLocationId;
_availableCategories = new List<string>();
ReportImportPanel.Visibility = Visibility.Hidden;
ReportViewer.ViewerCore.ReuseParameterWhenRefresh = false;
ReportViewer.ViewChange += ReportViewerOnViewChange;
ReportViewer.Owner = this;
ReportViewer.ClickPage += reportViewer_ClickPage;
using (var dbConn = _data.GetOpenConnection())
{
if (!Catalog.IsColumnPresent("crreportsetup", "releaseseq", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = "ALTER TABLE crreportsetup ADD COLUMN releaseseq int8;";
cmd.ExecuteNonQuery();
}
}
if (!Catalog.IsColumnPresent("crreportsetup", "isauthorized", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = "ALTER TABLE crreportsetup ADD COLUMN isauthorized bool;";
cmd.ExecuteNonQuery();
}
}
if (!Catalog.IsTablePresent("crparameterprofiles", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = @"CREATE TABLE public.crparameterprofiles (
seq bigserial NOT NULL,
profilename text NOT NULL,
reportseq int8 NOT NULL,
username text,
CONSTRAINT crparameterprofiles_pkey PRIMARY KEY (seq)
) WITH (OIDS=FALSE);
CREATE INDEX crparameterprofiles_reportseq_idx ON public.crparameterprofiles USING btree (reportseq);";
cmd.ExecuteNonQuery();
}
}
else
{
if (!Catalog.IsIndexPresent("crparameterprofiles_reportseq_idx", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = @"CREATE INDEX crparameterprofiles_reportseq_idx ON public.crparameterprofiles USING btree (reportseq);";
cmd.ExecuteNonQuery();
}
}
}
if (!Catalog.IsTablePresent("crparametervaluelistitems", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = @"CREATE TABLE public.crparametervaluelistitems (
seq bigserial NOT NULL,
parameterseq int8 NOT NULL,
minvalue text,
isminvalueincluded bool NOT NULL,
maxvalue text,
ismaxvalueincluded bool NOT NULL,
singularvalue text,
CONSTRAINT crparametervaluelistitems_pkey PRIMARY KEY (seq)
) WITH (OIDS=FALSE);
CREATE INDEX crparamlistvals_paramseq ON public.crparametervaluelistitems USING btree (parameterseq);";
cmd.ExecuteNonQuery();
}
}
if (!Catalog.IsTablePresent("crparametervalues", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = @"CREATE TABLE public.crparametervalues (
seq bigserial NOT NULL,
profileseq int8 NOT NULL,
parametername text NOT NULL,
isvaluelist bool NOT NULL,
minvalue text,
isminvalueincluded bool NOT NULL,
maxvalue text,
ismaxvalueincluded bool NOT NULL,
singularvalue text,
CONSTRAINT crparametervalues_pkey PRIMARY KEY (seq)
) WITH (OIDS=FALSE);
CREATE INDEX crparametervalues_profileseq_idx ON public.crparametervalues USING btree (profileseq);";
cmd.ExecuteNonQuery();
}
}
else
{
if (!Catalog.IsIndexPresent("crparametervalues_profileseq_idx", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = @"CREATE INDEX crparametervalues_profileseq_idx ON public.crparametervalues USING btree (profileseq);";
cmd.ExecuteNonQuery();
}
}
}
if (!Catalog.IsTablePresent("crsubreports", dbConn))
{
using (var cmd = dbConn.CreateCommand())
{
cmd.CommandText = @"CREATE TABLE public.crsubreports (
seq bigserial NOT NULL,
category text NOT NULL,
name text NOT NULL,
filename text NOT NULL,
CONSTRAINT crsubreports_pkey PRIMARY KEY (seq)
) WITH (OIDS=FALSE);";
cmd.ExecuteNonQuery();
}
}
_basePath = GetBasePath(dbConn);
GetUsers(dbConn);
RefreshReportList(dbConn);
}
if (_userAccess.GrantAdmin)
{
buttonAdmin.Visibility =
buttonSubreportSetup.Visibility =
buttonOptions.Visibility = buttonUpdate.Visibility = Visibility.Visible;
}
}
private string GetBasePath(NpgsqlConnection openConnection)
{
using (var cmd = openConnection.CreateCommand())
{
cmd.CommandText = @"SELECT pref_value FROM mnapp_preference WHERE pref_name = 'PathToCRFolder'";
var o = cmd.ExecuteScalar();
return o == null ? null : (string)o;
}
}
private void reportViewer_ClickPage(object sender, SAPBusinessObjects.WPF.Viewer.PageMouseEventArgs e)
{
try
{
var f = e.ObjectInfo;
if (f.ObjectType == SAPBusinessObjects.WPF.Viewer.ObjectType.DatabaseField &&
!string.IsNullOrWhiteSpace(f.Hyperlink))
{
Process.Start(f.Hyperlink.Substring(0, f.Hyperlink.LastIndexOf(" ", StringComparison.Ordinal)),
f.Hyperlink.Substring(f.Hyperlink.LastIndexOf(" ", StringComparison.Ordinal) + 1));
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
}
private void RefreshReportList(NpgsqlConnection openConnection)
{
buttonRefreshReportList.IsEnabled = false;
if (GetCategories(openConnection))
{
GetReports(openConnection);
}
else
{
// todo: display standard error message, standardize w/ Omnis
MessageBox.Show("Unable to determine report categories");
}
buttonRefreshReportList.IsEnabled = true;
}
private enum NodeType
{
UserReport,
PresentSystemReport,
ReportCategory,
AvailableSection,
Import
}
private class NodeObject
{
public NodeType Type { get; set; }
public object Tag { get; set; }
public NodeObject(NodeType type, object tag)
{
Type = type;
Tag = tag;
}
public override string ToString()
{
switch (Type)
{
case NodeType.PresentSystemReport:
case NodeType.UserReport:
return ((CrystalReport)Tag).ToString();
case NodeType.AvailableSection:
return "App Store";
case NodeType.Import:
return "Import";
default:
return Tag.ToString();
}
}
}
private bool GetCategories(NpgsqlConnection openConnection)
{
_availableCategories.Clear();
CategoryComboBox.Items.Clear();
try
{
TreeViewReports.Items.Clear();
using (var cmd = openConnection.CreateCommand())
{
cmd.Parameters.AddParameterWithValue("IsUserAdmin", _userAccess.GrantAdmin);
cmd.Parameters.AddParameterWithValue("Username", _userName);
cmd.CommandText = @"
SELECT DISTINCT s.reportgroup
FROM crreportsetup AS s
WHERE COALESCE(s.isauthorized, true)=true
AND (@IsUserAdmin=true
OR (CASE WHEN (SELECT COUNT(*) FROM crreportauth a INNER JOIN crreportsetup g on a.report_seq = g.seq WHERE g.reportallowtabusers=true AND g.reportgroup=s.reportgroup AND a.username=@Username)>0 THEN 1 ELSE 0 END = 0 AND reportallowtabusers=true)
OR EXISTS(SELECT 1 FROM crreportauth AS a WHERE a.report_seq=s.seq AND a.username=@Username AND a.report_auth='ALLOW'))
AND NOT EXISTS(SELECT 1 FROM crreportauth AS a WHERE a.report_seq=s.seq AND a.username=@Username AND a.report_auth='DENY')
ORDER BY s.reportgroup
";
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var iconfile = "";
var group = dr["reportgroup"].ToString();
switch (group)
{
case "Accounting":
if (!_userAccess.GrantAccounting)
{
continue;
}
iconfile = "IconBooks.png";
break;
case "Sales":
if (!_userAccess.GrantSales)
{
continue;
}
iconfile = "IconSales.png";
break;
case "Inventory":
if (!_userAccess.GrantInventory)
{
continue;
}
iconfile = "IconInventory16.png";
break;
case "Service":
if (!_userAccess.GrantService)
{
continue;
}
iconfile = "IconTools16.png";
break;
case "Management":
if (!_userAccess.GrantManagement)
{
continue;
}
iconfile = "IconManagement.png";
break;
case "Parts":
if (!_userAccess.GrantParts)
{
continue;
}
iconfile = "IconGears.png";
break;
case "Month End":
if (!_userAccess.GrantMonthEnd)
{
continue;
}
iconfile = "IconCalendar.png";
break;
case "Commissions":
if (!_userAccess.GrantCommissions)
{
continue;
}
iconfile = "IconMoney.png";
break;
case "Financial Statements":
if (!_userAccess.GrantFinancialStatements)
{
continue;
}
iconfile = "IconBank.png";
break;
default:
iconfile = "question-white.png";
break;
}
var item = new TreeViewItem();
item.Header = GetNodeStackPanel(NodeType.ReportCategory, group, iconfile, group);
TreeViewReports.Items.Add(item);
_availableCategories.Add(group);
CategoryComboBox.Items.Add(group);
}
}
}
if (_userAccess.GrantAdmin)
{
var importItem = new TreeViewItem();
importItem.Header = GetNodeStackPanel(NodeType.Import, null, "folder-import.png", "Import");
TreeViewReports.Items.Add(importItem);
}
var newitemsfolder = new TreeViewItem();
newitemsfolder.Header = GetNodeStackPanel(NodeType.AvailableSection, null, "IconStarUnlit.png", "App Store");
newitemsfolder.IsEnabled = false; // todo
TreeViewReports.Items.Add(newitemsfolder);
return true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error loading categories");
return false;
}
}
// TODO: method sets class field as well as getting users. Rename or separate concerns
private void GetUsers(NpgsqlConnection openConnection)
{
using (var cmd = openConnection.CreateCommand())
{
_reportUsers = new List();
cmd.CommandText = @"
SELECT u.firstname, u.lastname, u.username
FROM mn_user AS u
WHERE u.active = 1
ORDER BY u.username
";
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var name = dr["username"].ToString();
_reportUsers.Add(new ReportUser(name));
}
}
cmd.CommandText = @"
SELECT a.report_seq, a.username
FROM crreportauth AS a
WHERE a.report_auth = 'ALLOW'
ORDER BY a.username
";
var dict = new Dictionary<string, long[]>();
using (var dr = cmd.ExecuteReader())
{
var isFirstIteration = true;
string currentUsername = null;
var reportSeqs = new List<long>();
while (dr.Read())
{
var username = dr["username"].ToString();
if (isFirstIteration)
{
isFirstIteration = false;
currentUsername = username;
}
else
{
if (username != currentUsername)
{
dict.Add(currentUsername, reportSeqs.ToArray());
currentUsername = username;
reportSeqs.Clear();
}
}
reportSeqs.Add(dr.GetInt64(dr.GetOrdinal("report_seq")));
}
if (currentUsername == null && reportSeqs.Count > 0)
{
throw new Exception("Internal error");
}
if (currentUsername != null)
{
dict.Add(currentUsername, reportSeqs.ToArray());
}
}
foreach (var reportUser in _reportUsers)
{
if (dict.ContainsKey(reportUser.Name))
{
reportUser.AccessibleReportIds = dict[reportUser.Name];
}
}
}
}
// TODO: method sets class field as well as getting reports. Rename or separate concerns
public void GetReports(NpgsqlConnection openConnection)
{
_profiles.Clear();
foreach (TreeViewItem parentitem in TreeViewReports.Items)
{
var folder = (NodeObject)((StackPanel)parentitem.Header).Tag;
using (var cmd = openConnection.CreateCommand())
{
cmd.Parameters.AddParameterWithValue("UserName", _userName);
if (folder.Type == NodeType.ReportCategory)
{
var categoryName = folder.ToString();
cmd.Parameters.AddParameterWithValue("ReportGroup", categoryName);
cmd.Parameters.AddParameterWithValue("IsUserAdmin", _userAccess.GrantAdmin);
cmd.Parameters.AddParameterWithValue("Username", _userName);
cmd.CommandText = @"
SELECT s.seq, COALESCE(s.releaseseq, 0)::int8 AS releaseseq, s.reporttitle, s.reportpath, s.reportdescription,
COALESCE(s.reportenabled, FALSE) AS reportenabled, COALESCE(s.reportallowtabusers, FALSE) AS reportallowtabusers,
COALESCE(s.isauthorized, FALSE) AS isauthorized
FROM crreportsetup AS s
WHERE s.reportgroup = @ReportGroup
AND COALESCE(s.isauthorized, true) = true
AND (
@IsUserAdmin = true
OR s.reportallowtabusers = true
OR (
EXISTS (SELECT 1 FROM crreportauth AS a WHERE a.report_seq = s.seq AND a.username = @Username AND a.report_auth = 'ALLOW')
AND NOT EXISTS (SELECT 1 FROM crreportauth AS a WHERE a.report_seq = s.seq AND a.username = @Username AND a.report_auth = 'DENY')
)
)
ORDER BY s.reporttitle
";
try
{
try
{
var reportList = new List();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var reportSeq = dr.SafeLongParse("seq");
var reportTitle = dr.SafeStringParse("reporttitle");
var report = new CrystalReport(reportSeq, reportTitle,
dr.SafeStringParse("reportdescription"),
dr.SafeStringParse("reportpath"),
dr.SafeLongParse("releaseseq"),
categoryName);
report.Enabled = dr.SafeBoolParse("reportenabled");
report.AllowTabUsers = dr.SafeBoolParse("reportallowtabusers");
report.IsAuthorized = dr.SafeBoolParse("isauthorized");
report.Description = dr.SafeStringParse("reportdescription");
reportList.Add(report);
_profiles.Add(new ReportAccessItem(reportSeq, reportTitle));
}
}
parentitem.Items.Clear();
foreach (var report in reportList)
{
// Do not add report if the report is not enabled
if (!report.Enabled && !_userAccess.GrantAdmin)
{
continue;
}
var item = new TreeViewItem
{
Margin = new Thickness(0, 2, 0, 0),
Padding = new Thickness(3)
//IsEnabled = !report.Enabled && _userAccess.GrantAdmin
};
if (!report.Enabled && _userAccess.GrantAdmin)
{
item.Opacity = 0.5;
}
StackPanel p;
if (report.ReleaseId == 0)
{
//ReportPencil.png
p = GetNodeStackPanel(NodeType.UserReport, report, "dealer_report.png",
report.Name);
}
else
{
//Report.png
p = GetNodeStackPanel(NodeType.PresentSystemReport, report, "db_report.png",
report.Name);
}
item.Header = p;
item.MouseDoubleClick += item_MouseDoubleClick;
// Add report description(if there is one) as tooltip.
if (!string.IsNullOrEmpty(report.Description))
{
item.ToolTip = report.Description;
}
parentitem.Items.Add(item);
}
}
catch (NpgsqlException ex)
{
if (ex.GetErrorCode() == "42703")
{
MessageBox.Show("System update required. Please contact DealerBuilt support.",
"Unable to continue",
MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
MessageBox.Show(
"There was a problem gathering reports:\n\n" + ex.Message + "\n\n" + ex.StackTrace,
"Unable to continue",
MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
else if (folder.Type == NodeType.AvailableSection || folder.Type == NodeType.Import)
{
continue;
}
else
{
Log.Error($"GetReports failed to process the folder.Type=[{folder.Type.ToString()}]");
MessageBox.Show("There was an error getting report categories. Please contact DealerBuilt support if the problem persists.",
"Internal Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
}
using (var cmd = openConnection.CreateCommand())
{
cmd.CommandText = @"SELECT releaseseq FROM crreportsetup WHERE coalesce(releaseseq, 0) > 0 AND isauthorized = true";
var releaseSeqs = new List<long>();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
releaseSeqs.Add(dr.GetInt64(dr.GetOrdinal("releaseseq")));
}
}
_releaseSeqs = releaseSeqs.ToArray();
}
}
private void item_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
try
{
ExecuteSelectedReport();
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private StackPanel GetNodeStackPanel(NodeType nodetype, object nodeitem, string imagefilename, string text)
{
var n = new NodeObject(nodetype, nodeitem);
var p = new StackPanel { Orientation = Orientation.Horizontal };
var im = new Image
{
Source =
new BitmapImage(new Uri(@"/CrystalViewer;component/Images/" + imagefilename,
UriKind.Relative))
};
im.Width = im.Height = 16;
im.Margin = new Thickness(0, 0, 6, 0);
p.Children.Add(im);
var tb = new TextBlock { Text = text };
p.Children.Add(tb);
p.Tag = n;
return p;
}
private NodeObject GetSelectedNodeObject()
{
return (NodeObject)((StackPanel)((TreeViewItem)TreeViewReports.SelectedItem).Header).Tag;
}
private void treeViewReports_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs<object> e)
{
try
{
var shownothing = false;
if (TreeViewReports.SelectedItem != null)
{
var t = GetSelectedNodeObject();
switch (t.Type)
{
case NodeType.PresentSystemReport:
case NodeType.UserReport:
ReportViewer.Visibility = Visibility.Visible;
ReportImportPanel.Visibility = Visibility.Hidden;
webBrowserMain.Visibility = Visibility.Hidden;
var cr = (CrystalReport)t.Tag;
// todo: if admin
buttonOptions.IsEnabled = true;
buttonRun.IsEnabled = true;
if (_userAccess.GrantAdmin)
{
TreeViewReports.ContextMenu = TreeViewReports.Resources["ReportContext"] as ContextMenu;
}
break;
case NodeType.AvailableSection:
ReportViewer.Visibility = Visibility.Hidden;
ReportImportPanel.Visibility = Visibility.Hidden;
webBrowserMain.Navigate("http://localhost/AppStore?r=" + string.Join(",", _releaseSeqs));
webBrowserMain.Visibility = Visibility.Visible;
TreeViewReports.ContextMenu = null;
break;
case NodeType.Import:
ReportViewer.Visibility = Visibility.Hidden;
webBrowserMain.Visibility = Visibility.Hidden;
ReportImportPanel.Visibility = Visibility.Visible;
TreeViewReports.ContextMenu = null;
break;
default:
shownothing = true;
break;
}
}
else
{
shownothing = true;
}
if (!shownothing)
{
return;
}
// Show nothing
TreeViewReports.ContextMenu = null;
ReportViewer.Visibility = Visibility.Visible;
webBrowserMain.Visibility = Visibility.Hidden;
ReportImportPanel.Visibility = Visibility.Hidden;
buttonRun.IsEnabled = buttonOptions.IsEnabled = false;
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void buttonRun_Click(object sender, RoutedEventArgs e)
{
try
{
ExecuteSelectedReport();
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void ExecuteSelectedReport()
{
Cursor = Cursors.Wait;
try
{
var selectednode = (NodeObject)((StackPanel)((TreeViewItem)TreeViewReports.SelectedItem).Header).Tag;
switch (selectednode.Type)
{
case NodeType.UserReport:
case NodeType.PresentSystemReport:
DisplayReport((CrystalReport)selectednode.Tag);
break;
}
}
catch (Exception ex)
{
Log.Exception(ex);
MessageBox.Show(ex.Message, "Failed to display report");
}
Cursor = null;
}
private ReportDocument GetReportDocument(CrystalReport report)
{
var ret = new ReportDocument();
ret.Load(report.Path, OpenReportMethod.OpenReportByTempCopy);
return ret;
}
private void DisplayReport(CrystalReport report)
{
ReportDocument activeReport;
try
{
activeReport = GetReportDocument(report);
}
catch (CrystalReportsException cre)
{
if (cre.InnerException.HResult == -2147467259)
{
Log.Exception(cre);
MessageBox.Show(cre.InnerException.Message, "Failed to display report");
return;
}
throw;
}
catch (Exception ex)
{
Log.Exception(ex);
MessageBox.Show(ex.Message, "Unable to load report");
return;
}
if (!SetDataConnection(activeReport))
{
MessageBox.Show("Could not create a connection to the report database");
return;
}
try
{
using (var dbConnection = _data.GetOpenConnection())
{
report.Parameters = _data.GetParameters(dbConnection, report).ToArray();
report.ParameterProfiles = _data.GetParameterProfiles(dbConnection, report, _userName).ToArray();
long selectedStoredParameterProfileId = 0;
bool setParameterValues = true;
if (activeReport.DataDefinition.ParameterFields.Count > 0)
{
for (var i = 0; i < activeReport.DataDefinition.ParameterFields.Count; i++)
{
foreach (var param in report.Parameters)
{
if (activeReport.DataDefinition.ParameterFields[i].Name == param.Name)
{
if (param.Prompt != null && param.Prompt.Trim() != "")
{
try
{
activeReport.DataDefinition.ParameterFields[i].PromptText = param.Prompt;
break;
}
catch { }
}
}
}
}
var parametersWindow = new ParametersWindow(report, _data, _userName);
parametersWindow.Owner = this;
Cursor = null;
bool? dialogResult = parametersWindow.ShowDialog();
if (dialogResult != null && dialogResult == true)
{
if (parametersWindow.Result == ParameterWindowResult.Run)
{
setParameterValues = true;
}
else
{
setParameterValues = false;
if (parametersWindow.Result == ParameterWindowResult.CreatePrivate || parametersWindow.Result == ParameterWindowResult.CreatePublic || parametersWindow.Result == ParameterWindowResult.Edit)
{
if (parametersWindow.NewParameterSetName != null)
{
_newParameterProfileName = parametersWindow.NewParameterSetName;
}
}
}
selectedStoredParameterProfileId = parametersWindow.SelectedStoredParametersId;
}
else
{
return;
}
}
if (!ProcessParameters(activeReport, report, selectedStoredParameterProfileId, setParameterValues))
{
return;
}
ReportViewer.ViewerCore.ReportSource = activeReport;
_currentlyDisplayedReport = activeReport;
_currentlyDisplayedReportModel = report;
btnPrint.IsEnabled = true;
}
}
catch (Exception ex)
{
Log.Exception(ex);
MessageBox.Show(ex.Message, "Failed to display report");
return;
}
}
///
/// Sets the Crystal Report data connection to the PostgreSQL server connection
///
/// AT-417; Cloud Jira; Removes the dependency on odbcad32.exe connection setup per user terminal
///
///
private bool SetDataConnection(ReportDocument report)
{
try
{
ConnectionInfo connInfo = new ConnectionInfo
{
ServerName = $"Driver={{PostgreSQL ANSI}};Server={_data?.ConnectionDatas?[0]?.Host};Port={_data?.ConnectionDatas?[0]?.Port};CA={(_data.ConnectionString.Contains("Prefer") ? "prefer" : "disable")};",
DatabaseName = _data?.ConnectionDatas?[0]?.DatabaseName,
UserID = _data?.ConnectionDatas?[0]?.Username,
Password = _data?.ConnectionDatas?[0]?.Password
};
TableLogOnInfo tableLogOnInfo = new TableLogOnInfo
{
ConnectionInfo = connInfo
};
foreach (Table table in report.Database.Tables)
{
table.LogOnInfo.ConnectionInfo.ServerName = connInfo.ServerName;
table.LogOnInfo.ConnectionInfo.DatabaseName = connInfo.DatabaseName;
table.LogOnInfo.ConnectionInfo.UserID = connInfo.UserID;
table.LogOnInfo.ConnectionInfo.Password = connInfo.Password;
table.ApplyLogOnInfo(tableLogOnInfo);
}
report.DataSourceConnections[0].SetConnection(connInfo.ServerName, connInfo.DatabaseName, connInfo.UserID, connInfo.Password);
return true;
}
catch (Exception ex)
{
Log.Exception(ex);
return false;
}
}
// TODO: rename this to what it actually does - StartsWithIgnoreCase
private bool StartsWithIgnoreCase(string s, string prefix)
{
return s.StartsWith(prefix, StringComparison.InvariantCultureIgnoreCase);
}
private bool ProcessParameters(ReportDocument reportDocument, CrystalReport report, long selectedStoredParameterProfileId, bool setValues)
{
var parameterFields = reportDocument.ParameterFields;
var usingStoredProfile = selectedStoredParameterProfileId > 0;
try
{
//This always throws an exception but is a needed work-around for some reports not showing default parameter options properly.
int defaultXmlExportSelection = reportDocument.DefaultXmlExportSelection;
}
catch (Exception) { }
try
{
using (var dbConnection = _data.GetOpenConnection())
{
var storedProfileValues = new Dictionary<string, ParameterValues>();
var legacyParameterSetups = new Dictionary<string, LegacyParameterSetup>();
using (var cmd = dbConnection.CreateCommand())
{
if (usingStoredProfile)
{
cmd.Parameters.AddParameterWithValue("ProfileId", selectedStoredParameterProfileId);
cmd.CommandText = @"
SELECT p.seq, p.parametername, p.singularvalue, p.isvaluelist
FROM crparametervalues AS p
WHERE p.profileseq=@ProfileId
";
using (var da = new NpgsqlDataAdapter(cmd))
{
DataTable dtParameterValues = new DataTable();
da.Fill(dtParameterValues);
if (dtParameterValues != null && dtParameterValues.Rows.Count > 0)
{
foreach (DataRow dr in dtParameterValues.Rows)
{
var pseq = dr["seq"];
var pname = dr["parametername"].ToString();
var pvalue = dr["singularvalue"].ToString();
if (!bool.Parse(dr["isvaluelist"].ToString()))
{
if (storedProfileValues.ContainsKey(pname))
{
storedProfileValues[pname].AddValue(pvalue);
}
else
{
var pvalues = new ParameterValues();
pvalues.AddValue(pvalue);
storedProfileValues.Add(pname, pvalues);
}
}
else
{
using (var cmd2 = dbConnection.CreateCommand())
{
cmd2.CommandText = @"
SELECT singularvalue
FROM crparametervaluelistitems
WHERE parameterseq=@parameterseq
";
cmd2.Parameters.AddWithValue("parameterseq", pseq);
using (var da2 = new Npgsql.NpgsqlDataAdapter(cmd2))
{
DataTable dtParameterValueItems = new DataTable();
da2.Fill(dtParameterValueItems);
if (dtParameterValueItems != null && dtParameterValueItems.Rows.Count > 0)
{
foreach (DataRow dr2 in dtParameterValueItems.Rows)
{
pvalue = dr2["singularvalue"].ToString();
if (storedProfileValues.ContainsKey(pname))
{
storedProfileValues[pname].AddValue(pvalue);
}
else
{
var pvalues = new ParameterValues();
pvalues.AddValue(pvalue);
storedProfileValues.Add(pname, pvalues);
}
}
}
}
}
}
}
}
}
}
// Legacy parameter setups
cmd.Parameters.AddParameterWithValue("ReportId", report.ReportId);
cmd.CommandText = @"
SELECT p.param_name, p.param_default_id, p.param_dynamic, p.param_dynamic_table_column
FROM crreportparams AS p
WHERE p.report_seq=@ReportId
";
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
legacyParameterSetups.Add(dr.String("param_name"),
new LegacyParameterSetup((LegacyParameterDefaultOption)dr.Long("param_default_id"),
dr.String("param_dynamic_table_column")));
}
}
}
//var parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields;
List<string> namesDone = new List<string>();
for (var i = 0; i < parameterFields.Count; i++)
{
ParameterDiscreteValue discreteVal = null;
var name = parameterFields[i].Name ?? "";
var parameterFieldDefinition = reportDocument.DataDefinition.ParameterFields[name];
var promptText = parameterFields[i].PromptText ?? "";
if (usingStoredProfile)
{
if (storedProfileValues.ContainsKey(name))
{
if (setValues)
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
{
if (!namesDone.Contains(name))
{
reportDocument.SetParameterValue(name, storedProfileValues[name]);
namesDone.Add(name);
}
}
}
}
}
// Prompt Text = automatic value
if (StartsWithIgnoreCase(promptText, "#UserLySetupLocationId"))
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
{
if (!namesDone.Contains(name))
{
reportDocument.SetParameterValue(name, _lySetupLocationId);
namesDone.Add(name);
}
}
}
else if (StartsWithIgnoreCase(promptText, "#UserSlSetupLocationId"))
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
{
if (!namesDone.Contains(name))
{
reportDocument.SetParameterValue(name, _slSetupLocationId);
namesDone.Add(name);
}
}
}
else if (StartsWithIgnoreCase(promptText, "#UserAcSetupLocationId"))
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
{
if (!namesDone.Contains(name))
{
reportDocument.SetParameterValue(name, _acSetupLocationId);
namesDone.Add(name);
}
}
}
/*
"Current user\'s [Login ID] - String",
"Current user\'s [Full Name] - String",
"Current company [DBA Name] - String",
"Current company [Legal Name] - String",
"Current company [location] - Integer",
*/
// Name = defaults
else if (StartsWithIgnoreCase(name, "#AcSetupLocationId"))
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue)
{
if (!namesDone.Contains(name))
{
discreteVal = new ParameterDiscreteValue() { Value = GetAcSetupLocations(dbConnection) };
parameterFields[i].DefaultValues.Clear();
parameterFields[i].DefaultValues.Add(discreteVal);
namesDone.Add(name);
}
}
}
else if (StartsWithIgnoreCase(name, "#LySetupLocationId"))
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue)
{
if (!namesDone.Contains(name))
{
discreteVal = new ParameterDiscreteValue() { Value = GetLySetupLocations(dbConnection) };
parameterFields[i].DefaultValues.Clear();
parameterFields[i].DefaultValues.Add(discreteVal);
namesDone.Add(name);
}
}
}
else if (StartsWithIgnoreCase(name, "#SlSetupLocationId"))
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue)
{
if (!namesDone.Contains(name))
{
discreteVal = new ParameterDiscreteValue() { Value = GetSlSetupLocations(dbConnection) };
parameterFields[i].DefaultValues.Clear();
parameterFields[i].DefaultValues.Add(discreteVal);
namesDone.Add(name);
}
}
}
else
{
parameterFields[i].DefaultValues.Clear();
}
/*
"Current user\'s [Login ID] - String",
"Current user\'s [Full Name] - String",
"Current company [DBA Name] - String",
"Current company [Legal Name] - String",
"Current company [location] - Integer",
"Today\'s Date - Date",
"Yesterday\'s Date - Date",
"First day of this month - Date",
"Last day of this month - Date",
"First day of previous month - Date",
"Last day of previous month - Date",
"Beginning of this year - Date",
"End of this year - Date",
"Beginning of last year - Date",
"End of last year - Date",
*/
var pvalues = new ParameterValues();
if (legacyParameterSetups.ContainsKey(name))
{
switch (legacyParameterSetups[name].LegacyParameterDefaultOption)
{
case LegacyParameterDefaultOption.NotSet:
break;
case LegacyParameterDefaultOption.CurrentUserLoginIdString:
pvalues.Add(new ParameterDiscreteValue
{
Value = _userName,
Description = "Current User Login Id"
});
break;
case LegacyParameterDefaultOption.CurrentUserFullNameString:
pvalues.Add(new ParameterDiscreteValue
{
Value = GetUsersFullName(dbConnection),
Description = "Current User Full Name"
});
break;
case LegacyParameterDefaultOption.CurrentCompanyDbaNameString:
pvalues.Add(new ParameterDiscreteValue
{
Value = GetCompanyDbaName(dbConnection),
Description = "Current Store Name"
});
break;
case LegacyParameterDefaultOption.CurrentCompanyLegalNameString:
pvalues.Add(new ParameterDiscreteValue
{
Value = GetCompanyLegalName(dbConnection),
Description = "Current Company Legal Name"
});
break;
case LegacyParameterDefaultOption.CurrentCompanyLocationInteger:
pvalues.Add(new ParameterDiscreteValue
{
Value = _lySetupLocationId,
Description = "Current Store Location ID"
});
break;
case LegacyParameterDefaultOption.ShowListOfAuthorizedCompanyLocationsInteger:
pvalues = GetLySetupLocations(dbConnection);
break;
case LegacyParameterDefaultOption.CurrentServiceLocationInteger:
pvalues.Add(new ParameterDiscreteValue
{
Value = _slSetupLocationId,
Description = "Current Service Location ID"
});
break;
case LegacyParameterDefaultOption.ShowListOfAuthorizedServiceLocationsInteger:
pvalues = GetSlSetupLocations(dbConnection);
break;
case LegacyParameterDefaultOption.TodaysDateDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Today,
Description = "Today's Date"
});
break;
case LegacyParameterDefaultOption.YesterdaysDateDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Today.AddDays(-1),
Description = "Yesterday's Date"
});
break;
case LegacyParameterDefaultOption.FirstDayOfThisMonthDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.ToString("MM/01/yyyy")),
Description = "First Day Of This Month"
});
break;
case LegacyParameterDefaultOption.LastDayOfThisMonthDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.AddMonths(1).ToString("MM/01/yyyy")).AddDays(-1),
Description = "Last Day Of This Month"
});
break;
case LegacyParameterDefaultOption.FirstDayOfPreviousMonthDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.AddMonths(-1).ToString("MM/01/yyyy")),
Description = "First Day Of Previous Month"
});
break;
case LegacyParameterDefaultOption.LastDayOfPreviousMonthDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.ToString("MM/01/yyyy")).AddDays(-1),
Description = "Last Day Of Previous Month"
});
break;
case LegacyParameterDefaultOption.BeginningOfThisYearDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.ToString("01/01/yyyy")),
Description = "Beginning Of This Year"
});
break;
case LegacyParameterDefaultOption.EndOfThisYearDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.AddYears(1).ToString("01/01/yyyy")).AddDays(-1),
Description = "End Of This Year"
});
break;
case LegacyParameterDefaultOption.BeginningOfLastYearDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.AddYears(-1).ToString("01/01/yyyy")),
Description = "Beginning Of Last Year"
});
break;
case LegacyParameterDefaultOption.EndOfLastYearDateTime:
pvalues.Add(new ParameterDiscreteValue
{
Value = DateTime.Parse(DateTime.Today.ToString("01/01/yyyy")).AddDays(-1),
Description = "End Of Last Year"
});
break;
case LegacyParameterDefaultOption.ValueString:
break;
case LegacyParameterDefaultOption.ValueInteger:
break;
case LegacyParameterDefaultOption.CCPADisclousureMessage:
pvalues.Add(new ParameterDiscreteValue
{
Value = GetDisclousureMessage(dbConnection),
Description = "CCPA Disclosure Message"
});
break;
}
}
if (usingStoredProfile && _newParameterProfileName != null && _newParameterProfileName.Trim() != "")
{
if (storedProfileValues.ContainsKey(name))
{
if (!setValues)
{
foreach (var storedProfileValue in storedProfileValues[name])
{
bool exists = false;
foreach (var pvalue in pvalues)
{
if (((ParameterDiscreteValue)pvalue).Value.ToString() == ((ParameterDiscreteValue)storedProfileValue).Value.ToString())
{
exists = true;
break;
}
}
if (!exists)
{
pvalues.Add(new ParameterDiscreteValue
{
Value = ((ParameterDiscreteValue)storedProfileValue).Value,
Description = _newParameterProfileName
});
}
}
}
}
}
/* param_default_id
0 [Not Set]
1 Current user's [Login ID] - String
2 Current user's [Full Name] - String
3 Current company [DBA Name] - String
4 Current company [Legal Name] - String
5 Current company [location] - Integer
6 Show list of authorized company locations - Integer
7 Current service location - Integer
8 Show list of authorized service locations - Integer
9 Today's Date - Date
10 Yesterday's Date - Date
11 First day of this month - Date
12 Last day of this month - Date
13 First day of previous month - Date
14 Last day of previous month - Date
15 Beginning of this year - Date
16 End of this year - Date
17 Beginning of last year - Date
18 End of last year - Date
19 String Value - String
20 Integer Value - Integer
*/
if (pvalues.Count > 0)
{
if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
{
bool allowUserToChange = false;
foreach (var param in report.Parameters)
{
if (param.Name == parameterFieldDefinition.Name)
{
allowUserToChange = param.AllowUserToChange;
break;
}
}
if (allowUserToChange)
{
if (parameterFieldDefinition.EnableAllowEditingDefaultValue)
{
if (!namesDone.Contains(name))
{
parameterFields[i].DefaultValues.Clear();
parameterFields[i].DefaultValues.AddRange(pvalues);
namesDone.Add(name);
}
}
}
else
{
if (!namesDone.Contains(name))
{
parameterFieldDefinition.ApplyCurrentValues(pvalues);
namesDone.Add(name);
}
}
}
}
}
}
}
catch (Exception ex)
{
Log.Exception(ex);
}
return true;
}
private void Focus_Attained()
{
MessageBox.Show("heyyyyyy");
}
private class LegacyParameterSetup
{
public LegacyParameterDefaultOption LegacyParameterDefaultOption { get; set; }
public string DynamicColumn { get; set; }
public LegacyParameterSetup(LegacyParameterDefaultOption defaultOption, string dynamicColumn)
{
LegacyParameterDefaultOption = defaultOption;
DynamicColumn = string.IsNullOrWhiteSpace(dynamicColumn) ? null : dynamicColumn;
}
}
private enum LegacyParameterDefaultOption
{
NotSet = 0,
CurrentUserLoginIdString = 1,
CurrentUserFullNameString = 2,
CurrentCompanyDbaNameString = 3,
CurrentCompanyLegalNameString = 4,
CurrentCompanyLocationInteger = 5,
ShowListOfAuthorizedCompanyLocationsInteger = 6,
CurrentServiceLocationInteger = 7,
ShowListOfAuthorizedServiceLocationsInteger = 8,
TodaysDateDateTime = 9,
YesterdaysDateDateTime = 10,
FirstDayOfThisMonthDateTime = 11,
LastDayOfThisMonthDateTime = 12,
FirstDayOfPreviousMonthDateTime = 13,
LastDayOfPreviousMonthDateTime = 14,
BeginningOfThisYearDateTime = 15,
EndOfThisYearDateTime = 16,
BeginningOfLastYearDateTime = 17,
EndOfLastYearDateTime = 18,
ValueString = 19,
ValueInteger = 20,
CCPADisclousureMessage = 21
}
public void goToPage_Click(object sender, SAPBusinessObjects.WPF.Viewer.PageMouseEventArgs e)
{
MessageBox.Show(e.ObjectInfo.Text);
}
private ParameterValues GetAcSetupLocations(NpgsqlConnection dbConnection)
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = @"
SELECT locationid::int8, companyname
FROM acsetup
ORDER BY locationid
";
using (var dr = dbCommand.ExecuteReader())
{
var defaultValues = new ParameterValues();
while (dr.Read())
{
defaultValues.Add(new ParameterDiscreteValue
{
Value = dr.GetInt64(dr.GetOrdinal("locationid")),
Description = dr["companyname"].ToString()
});
}
return defaultValues;
}
}
}
private ParameterValues GetLySetupLocations(NpgsqlConnection dbConnection)
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = @"
SELECT locationid::int8, coconame
FROM lysetup
ORDER BY lpad(locationid, 2, '0')::int2
";
using (var dr = dbCommand.ExecuteReader())
{
var defaultValues = new ParameterValues();
while (dr.Read())
{
defaultValues.Add(new ParameterDiscreteValue
{
Value = dr.GetInt64(dr.GetOrdinal("locationid")),
Description = dr["coconame"].ToString()
});
}
return defaultValues;
}
}
}
private ParameterValues GetSlSetupLocations(NpgsqlConnection dbConnection)
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = @"
SELECT locationid, name
FROM slsetup
ORDER BY lpad(locationid::text, 2, '0')::int2
";
using (var dr = dbCommand.ExecuteReader())
{
var defaultValues = new ParameterValues();
while (dr.Read())
{
defaultValues.Add(new ParameterDiscreteValue
{
Value = dr.GetInt64(dr.GetOrdinal("locationid")),
Description = dr["name"].ToString()
});
}
return defaultValues;
}
}
}
private string GetUsersFullName(NpgsqlConnection dbConnection)
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = "SELECT ltrim(rtrim(firstname || ' ' || lastname)) AS fullname FROM mn_user WHERE username = @username LIMIT 1;";
dbCommand.Parameters.AddWithValue("username", _userName);
return dbCommand.ExecuteScalar().ToString();
}
}
private string GetCompanyDbaName(NpgsqlConnection dbConnection)
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = "SELECT coconame FROM lysetup WHERE locationid = @locationid LIMIT 1;";
dbCommand.Parameters.AddWithValue("username", _lySetupLocationId.ToString());
return dbCommand.ExecuteScalar().ToString();
}
}
private string GetCompanyLegalName(NpgsqlConnection dbConnection)
{
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = "SELECT legalname FROM lysetup WHERE locationid = @locationid LIMIT 1;";
dbCommand.Parameters.AddWithValue("username", _lySetupLocationId.ToString());
return dbCommand.ExecuteScalar().ToString();
}
}
private string GetDisclousureMessage(NpgsqlConnection dbConnection)
{
string disclousureMessage = string.Empty;
using (var dbCommand = dbConnection.CreateCommand())
{
dbCommand.CommandText = "SELECT pref_value FROM mnapp_preference WHERE pref_name = 'CCPAReportDisclosure'";
var value = dbCommand.ExecuteScalar();
if (value != DBNull.Value)
{
disclousureMessage = value.ToString();
}
}
return disclousureMessage;
}
private void buttonAdmin_Click(object sender, RoutedEventArgs e)
{
try
{
var accessWindow = new AccessWindow(_data, _reportUsers, _profiles, _userName, _userAccess);
accessWindow.Owner = this;
bool? result = accessWindow.ShowDialog();
if (result != null && result == true)
{
_reportUsers = accessWindow.ReportUsers;
_profiles = accessWindow.ReportAccessItems;
}
using (var db = _data.GetOpenConnection())
{
GetUsers(db);
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void buttonRefreshReportList_Click(object sender, RoutedEventArgs e)
{
try
{
using (var db = _data.GetOpenConnection())
{
RefreshReportList(db);
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private static void SaveFile(Stream saveFile, string localFilePath)
{
const int bufferSize = 65536; // 64K
using (var outfile = new FileStream(localFilePath, FileMode.Create))
{
byte[] buffer = new byte[bufferSize];
int bytesRead = saveFile.Read(buffer, 0, bufferSize);
while (bytesRead > 0)
{
outfile.Write(buffer, 0, bytesRead);
bytesRead = saveFile.Read(buffer, 0, bufferSize);
}
}
}
private void ButtonReportFileSelect_OnClick(object sender, RoutedEventArgs e)
{
try
{
var reportPath = Tools.GetUserReportPath();
if (reportPath == null)
return;
ReportFilePath.Text = reportPath;
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void ButtonImport_OnClick(object sender, RoutedEventArgs e)
{
try
{
string reportGroup = "";
string sourcePath = ReportFilePath.Text;
if (CategoryComboBox.SelectedValue != null && CategoryComboBox.SelectedValue.ToString().Trim() != "")
{
reportGroup = CategoryComboBox.SelectedValue.ToString();
}
else if (CategoryComboBox.Text != null && CategoryComboBox.Text.Trim() != "")
{
reportGroup = CategoryComboBox.Text;
}
else
{
MessageBox.Show("Please select a report category", "Required Field Missing", MessageBoxButton.OK, MessageBoxImage.Stop);
return;
}
var destinationPath = _basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray()) + "\\" + System.IO.Path.GetFileName(sourcePath);
if (sourcePath.ToLower() != destinationPath.ToLower())
{
try
{
if (!Directory.Exists(_basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray())))
{
Directory.CreateDirectory(_basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray()));
}
if (sourcePath.ToLower() != destinationPath.ToLower()) //Don't copy if the destination matches the source.
{
File.Copy(sourcePath, destinationPath);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Unable to copy report file", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
using (var dbConn = _data.GetOpenConnection())
{
try
{
using (var cmd = dbConn.CreateCommand())
{
cmd.Parameters.AddParameterWithValue("ReportPath", destinationPath);
cmd.Parameters.AddParameterWithValue("ReportTitle", ReportTitle.Text);
cmd.Parameters.AddParameterWithValue("ReportDescription", ReportDescription.Text);
cmd.Parameters.AddParameterWithValue("ReportGroup", reportGroup);
cmd.CommandText = @"
INSERT INTO crreportsetup (reportpath, reporttitle, reportdescription, reportgroup, reportenabled)
VALUES (@ReportPath, @ReportTitle, @ReportDescription, @ReportGroup, true)
";
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Unable to import report file", MessageBoxButton.OK,
MessageBoxImage.Error);
return;
}
RefreshReportList(dbConn);
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void EditReport_Click(object sender, RoutedEventArgs e)
{
try
{
EditSelectedReport();
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void UpdateReport_Click(object sender, RoutedEventArgs e)
{
try
{
UpdateSelectedReport();
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void EditSelectedReport()
{
var sno = GetSelectedNodeObject();
var s = new ReportOptionsWindow(_data, (CrystalReport)sno.Tag, _availableCategories, _reportUsers);
s.Owner = this;
s.ShowDialog();
sno.Tag = s._report;
}
private void UpdateSelectedReport()
{
var reportPath = Tools.GetUserReportPath();
if (reportPath != null)
{
var report = (CrystalReport)GetSelectedNodeObject().Tag;
var reportGroup = report.CategoryName;
var filename = System.IO.Path.GetFileName(report.Path);
var destinationPath = _basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray()) + "\\" + filename;
try
{
if (destinationPath.ToLower() != reportPath.ToLower())
{
File.Copy(reportPath, destinationPath, true);
MessageBox.Show("Report updated", "Success", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
else
{
MessageBox.Show("Report not updated. Source file path is the same as destination file path.", "Success", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Unable to copy report file", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
}
private void DeleteReport_Click(object sender, RoutedEventArgs e)
{
try
{
var report = (CrystalReport)GetSelectedNodeObject().Tag;
var question = string.Format("Delete {0}?", report.Name);
if (MessageBox.Show(question, "Delete Report", MessageBoxButton.YesNo, MessageBoxImage.Question) ==
MessageBoxResult.Yes)
{
using (var db = _data.GetOpenConnection())
{
DeleteReport(db, report.ReportId);
RefreshReportList(db);
}
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void DeleteReport(NpgsqlConnection openConnection, long reportId)
{
try
{
_data.DeleteProfiles(openConnection, reportId);
// todo: everything to the end of the try should be in the same tranaction as the above profile deletion
string path;
using (var command = openConnection.CreateCommand())
{
command.Parameters.AddWithValue("ReportId", reportId);
command.CommandText = @"
DELETE FROM crreportsetup WHERE seq=@ReportId RETURNING reportpath
";
path = (string)command.ExecuteScalar();
}
//File.Delete(path); //Per Sherri, she does not want the .rpt file itself to be deleted, just remove from the viewer.
}
catch (Exception ex)
{
MessageBox.Show(
"The following error occured while attempting to delete the selected report:\n\n" + ex.Message,
"Report Not Deleted", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
}
}
private void ReportViewerOnViewChange(object sender, RoutedEventArgs routedEventArgs)
{
try
{
if (routedEventArgs != null && routedEventArgs.OriginalSource != null)
{
currentReportAlbum = (SAPBusinessObjects.WPF.Viewer.ReportAlbum)routedEventArgs.OriginalSource;
}
else
{
currentReportAlbum = null;
}
if (_newParameterProfileName == null)
return;
using (var connection = _data.GetOpenConnection())
{
using (var transaction = connection.BeginTransaction())
{
try
{
using (var cmd = connection.CreateCommand())
{
long profileId = 0;
cmd.Parameters.AddParameterWithValue("ProfileName", _newParameterProfileName);
cmd.Parameters.AddParameterWithValue("UserName", _userName);
cmd.Parameters.AddParameterWithValue("ReportSeq", _currentlyDisplayedReportModel.ReportId);
cmd.CommandText = @"
SELECT seq FROM crparameterprofiles
WHERE (reportseq = @ReportSeq)
AND (username = @UserName)
AND (profilename = @ProfileName)
LIMIT 1;
";
object ob = cmd.ExecuteScalar();
if (ob != null && ob.ToString() != "")
{
long.TryParse(ob.ToString(), out profileId);
}
if (profileId <= 0) //INSERT crparameterprofiles
{
cmd.CommandText = @"
INSERT INTO crparameterprofiles (profilename, username, reportseq)
VALUES (@ProfileName, @UserName, @ReportSeq)
RETURNING seq;
";
ob = cmd.ExecuteScalar();
if (ob != null && ob.ToString() != "")
{
long.TryParse(ob.ToString(), out profileId);
}
}
//else //UPDATE crparameterprofiles (not necessary)
cmd.Parameters.AddParameterWithValue("ProfileId", profileId);
cmd.Parameters.AddParameterWithValue("ParameterName", NpgsqlDbType.Text, "");
cmd.Parameters.AddParameterWithValue("IsValueList", NpgsqlDbType.Boolean, false);
cmd.Parameters.AddParameterWithValue("SingularValue", NpgsqlDbType.Text, "");
cmd.Parameters.AddParameterWithValue("MinValue", NpgsqlDbType.Text, "");
cmd.Parameters.AddParameterWithValue("IsMinValueIncluded", NpgsqlDbType.Boolean, false);
cmd.Parameters.AddParameterWithValue("MaxValue", NpgsqlDbType.Text, "");
cmd.Parameters.AddParameterWithValue("IsMaxValueIncluded", NpgsqlDbType.Boolean, false);
cmd.Parameters.AddParameterWithValue("paramvalueId", NpgsqlDbType.Bigint, 0);
for (var i = 0; i < _currentlyDisplayedReport.ParameterFields.Count; i++)
{
long paramvalueId = 0;
var parameterField = _currentlyDisplayedReport.ParameterFields[i];
if (parameterField.CurrentValues.Count == 0)
continue;
bool isList = parameterField.CurrentValues.Count > 1;
cmd.Parameters.SetValue("ParameterName", parameterField.Name);
cmd.CommandText = @"
SELECT seq
FROM crparametervalues
WHERE (profileseq = @ProfileId)
AND (parametername = @ParameterName)
LIMIT 1;
";
ob = cmd.ExecuteScalar();
if (ob != null && ob.ToString() != "")
{
long.TryParse(ob.ToString(), out paramvalueId);
}
if (paramvalueId <= 0) //INSERT crparametervalues and crparametervaluelistitems
{
cmd.CommandText = @"
INSERT INTO crparametervalues (profileseq, parametername, isvaluelist, singularvalue, minvalue, isminvalueincluded, maxvalue, ismaxvalueincluded)
VALUES (@ProfileId, @ParameterName, @IsValueList, @SingularValue, @MinValue, @IsMinValueIncluded, @MaxValue, @IsMaxValueIncluded)
RETURNING seq;
";
}
else //UPDATE crparametervalues and crparametervaluelistitems
{
cmd.Parameters.SetValue("paramvalueId", paramvalueId);
cmd.CommandText = @"
UPDATE crparametervalues
SET isvaluelist = @IsValueList, singularvalue = @SingularValue, minvalue = @MinValue, isminvalueincluded = @IsMinValueIncluded, maxvalue = @MaxValue, ismaxvalueincluded = @IsMaxValueIncluded
WHERE (seq = @paramvalueId)
RETURNING seq;
";
}
if (!isList)
{
// Singular value
cmd.Parameters.SetValue("IsValueList", isList);
cmd.Parameters.SetValue("MinValue", 0);
cmd.Parameters.SetValue("IsMinValueIncluded", true);
cmd.Parameters.SetValue("MaxValue", 0);
cmd.Parameters.SetValue("IsMaxValueIncluded", true);
cmd.Parameters.SetValue("SingularValue", ((ParameterDiscreteValue)parameterField.CurrentValues[0]).Value);
ob = cmd.ExecuteScalar();
if (ob != null && ob.ToString() != "")
{
long.TryParse(ob.ToString(), out paramvalueId);
}
cmd.Parameters.SetValue("paramvalueId", paramvalueId);
cmd.CommandText = @"
DELETE FROM crparametervaluelistitems
WHERE (parameterseq = @paramvalueId);
";
cmd.ExecuteNonQuery();
}
else
{
// Value list
cmd.Parameters.SetValue("IsValueList", isList);
cmd.Parameters.SetValue("MinValue", 0);
cmd.Parameters.SetValue("IsMinValueIncluded", false);
cmd.Parameters.SetValue("MaxValue", 0);
cmd.Parameters.SetValue("IsMaxValueIncluded", false);
cmd.Parameters.SetValue("SingularValue", "");
ob = cmd.ExecuteScalar();
if (ob != null && ob.ToString() != "")
{
long.TryParse(ob.ToString(), out paramvalueId);
}
cmd.Parameters.SetValue("paramvalueId", paramvalueId);
cmd.CommandText = @"
DELETE FROM crparametervaluelistitems
WHERE (parameterseq = @paramvalueId);
";
cmd.ExecuteNonQuery();
for (var j = 0; j < parameterField.CurrentValues.Count; j++)
{
cmd.CommandText = @"
INSERT INTO crparametervaluelistitems (parameterseq, singularvalue, minvalue, isminvalueincluded, maxvalue, ismaxvalueincluded)
VALUES (@paramvalueId, @SingularValue, @MinValue, @IsMinValueIncluded, @MaxValue, @IsMaxValueIncluded)
";
cmd.Parameters.SetValue("paramvalueId", paramvalueId);
cmd.Parameters.SetValue("MinValue", 0);
cmd.Parameters.SetValue("IsMinValueIncluded", false);
cmd.Parameters.SetValue("MaxValue", 0);
cmd.Parameters.SetValue("IsMaxValueIncluded", false);
cmd.Parameters.SetValue("SingularValue", ((ParameterDiscreteValue)parameterField.CurrentValues[j]).Value);
cmd.ExecuteNonQuery();
}
}
}
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
MessageBox.Show(
"The following error occured while attempting to save report parameters:\n\n" + ex.Message,
"Profile not saved", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
return;
}
}
}
_newParameterProfileName = null;
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void buttonOptions_Click(object sender, RoutedEventArgs e)
{
try
{
EditSelectedReport();
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void WebBrowserMain_OnNavigating(object sender, NavigatingCancelEventArgs e)
{
try
{
string scheme = null;
try
{
scheme = e.Uri.Scheme;
}
catch
{
return;
}
if (scheme == "install")
{
using (var connection = _data.GetOpenConnection())
{
using (var cmd = connection.CreateCommand())
{
cmd.Parameters.AddParameterWithValue("ReleaseSeq", long.Parse(e.Uri.Host));
cmd.CommandText = @"
UPDATE crreportsetup SET isauthorized=true WHERE releaseseq=@ReleaseSeq
";
cmd.ExecuteNonQuery();
GetReports(connection);
}
}
webBrowserMain.Navigate("http://localhost/AppStore?r=" + string.Join(",", _releaseSeqs));
}
else if (scheme == "uninstall")
{
using (var connection = _data.GetOpenConnection())
{
using (var cmd = connection.CreateCommand())
{
cmd.Parameters.AddParameterWithValue("ReleaseSeq", long.Parse(e.Uri.Host));
cmd.CommandText = @"
UPDATE crreportsetup SET isauthorized=false WHERE releaseseq=@ReleaseSeq
";
cmd.ExecuteNonQuery();
GetReports(connection);
}
}
webBrowserMain.Navigate("http://localhost/AppStore?r=" + string.Join(",", _releaseSeqs));
}
else if (scheme != "http")
{
e.Cancel = true;
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void Control_OnMouseDoubleClick(object sender, MouseButtonEventArgs e)
{
try
{
if (LeftPanel.Visibility == Visibility.Collapsed)
{
ColumnDefinitionLeft.Width = _leftPanelWidth;
ColumnDefinitionLeft.MinWidth = 235;
LeftPanel.Visibility = Visibility.Visible;
RectangleCollapsed.Visibility = Visibility.Hidden;
return;
}
_leftPanelWidth = ColumnDefinitionLeft.Width;
ColumnDefinitionLeft.Width = new GridLength(0);
ColumnDefinitionLeft.MinWidth = 0;
LeftPanel.Visibility = Visibility.Collapsed;
RectangleCollapsed.Visibility = Visibility.Visible;
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void TreeViewReports_OnMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
{
try
{
var treeView = sender as TreeView;
if (treeView != null && treeView.SelectedItem != null)
{
var item = (TreeViewItem)treeView.SelectedItem;
item.IsSelected = false;
treeView.Focus();
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void TreeViewReports_OnPreviewMouseRightButtonDown(object sender, MouseButtonEventArgs e)
{
try
{
var treeViewItem = VisualUpwardSearch(e.OriginalSource as DependencyObject);
if (treeViewItem == null)
return;
treeViewItem.Focus();
e.Handled = true;
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
static TreeViewItem VisualUpwardSearch(DependencyObject source)
{
while (source != null && !(source is TreeViewItem))
source = VisualTreeHelper.GetParent(source);
return source as TreeViewItem;
}
private void buttonSubreportSetup_Click(object sender, RoutedEventArgs e)
{
try
{
var w = new SubreportWindow(_availableCategories, _data, _basePath);
w.Owner = this;
w.ShowDialog();
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void Focus_Attained(object sender, RoutedEventArgs e)
{
}
private void btnPrint_Click(object sender, RoutedEventArgs e)
{
try
{
try
{
if (currentReportAlbum != null)
{
try
{
currentReportAlbum.PrintReport();
}
catch
{
ReportViewer.ViewerCore.PrintReport();
}
}
else if (_currentlyDisplayedReport != null)
{
doPrint(_currentlyDisplayedReport);
}
}
catch
{
if (_currentlyDisplayedReport != null)
{
doPrint(_currentlyDisplayedReport);
}
else if (currentReportAlbum != null)
{
currentReportAlbum.PrintReport();
}
}
}
catch (Exception ex1)
{
Log.Exception(ex1);
}
}
private void doPrint(ReportDocument reportDocument)
{
using (System.Windows.Forms.PrintDialog dialog = new System.Windows.Forms.PrintDialog())
{
dialog.AllowCurrentPage = true;
dialog.AllowSelection = true;
dialog.AllowSomePages = true;
dialog.AllowPrintToFile = true;
if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
reportDocument.PrintToPrinter(dialog.PrinterSettings, new System.Drawing.Printing.PageSettings(dialog.PrinterSettings), false);
}
}
}
}
public class MyParameterType : ParameterDiscreteValue
{
public MyParameterType(int i)
{
Value = i;
}
public override string ToString()
{
return "five";
}
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
1. using System;
2. using System.Collections.Generic;
3. using System.Data;
4. using System.Linq;
5. using System.Windows;
6. using System.Windows.Controls;
7. using System.Windows.Input;
8. using System.Windows.Media;
9. using System.Windows.Media.Imaging;
10. using System.Windows.Navigation;
11. using System.Diagnostics;
12. using System.IO;
13. using Npgsql;
14. using DealerBuilt.Data;
15. using DealerBuilt.Data.Omnis;
16. using DealerBuilt.Models.Crystal;
17. using CrystalDecisions.CrystalReports.Engine;
18. using CrystalDecisions.Shared;
19. using NpgsqlTypes;
20. using DealerBuilt.Logging.File;
21. using CrystalViewer.Models;
23. namespace CrystalViewer
24. {
25. ///
26. /// Interaction logic for MainWindow.xaml
27. ///
28. public partial class CrystalWindow : Window
29. {
30. private string _userName;
31. private long _lySetupLocationId, _slSetupLocationId, _acSetupLocationId;
32. private string _newParameterProfileName = null;
33. private List<string> _availableCategories;
34. private Data _data;
35. private UserAccess _userAccess;
36. private List _reportUsers;
37. private List _profiles = new List();
38. private long[] _releaseSeqs = new long[0];
39. private GridLength _leftPanelWidth = new GridLength(235);
40. private ReportDocument _currentlyDisplayedReport;
41. private CrystalReport _currentlyDisplayedReportModel;
43. private string _basePath;
45. private SAPBusinessObjects.WPF.Viewer.ReportAlbum currentReportAlbum = null;
47. private ILog Log = new LogFile("CrystalViewer.{user}.log");
49. public CrystalWindow(long acSetupLocationId, long lySetupLocationId, long slSetupLocationId, string userName, UserAccess userAccess)
50. {
51. Log.Debug($"acSetupLocationId=[{acSetupLocationId}] lySetupLocationId=[{lySetupLocationId}] slSetupLocationId=[{slSetupLocationId}] userAccess=[{userAccess.ToString()}]");
53. _userAccess = userAccess;
54. var connectionDatas = DealerData.GetConnectionDatas();
55. _data = new Data(connectionDatas);
57. Log.Debug($"Database=[{_data.GetConnection().Database}]");
59. InitializeComponent();
61. Initialize(acSetupLocationId, lySetupLocationId, slSetupLocationId, userName);
62. }
64. public CrystalWindow(string connectionString, long acSetupLocationId, long lySetupLocationId, long slSetupLocationId, string userName)
65. {
66. // for testing
67. _userAccess = new UserAccess(true);
69. Log.Debug($"acSetupLocationId=[{acSetupLocationId}] lySetupLocationId=[{lySetupLocationId}] slSetupLocationId=[{slSetupLocationId}] userName=[{userName}]");
71. _data = new Data(connectionString.CheckSSL());
73. Log.Debug($"Database=[{_data.GetConnection().Database}]");
75. InitializeComponent();
77. Initialize(acSetupLocationId, lySetupLocationId, slSetupLocationId, userName);
78. }
80. public SAPBusinessObjects.WPF.Viewer.SearchEventHandler Search;
82. public void Initialize(long acSetupLocationId, long lySetupLocationId, long slSetupLocationId, string userName)
83. {
84. Log.Debug("Starting Initialize()...");
86. if (string.IsNullOrWhiteSpace(_data.ConnectionString))
87. {
88. throw new Exception("Internal error: invalid connection string");
89. }
91. _userName = userName;
92. _lySetupLocationId = lySetupLocationId;
93. _slSetupLocationId = slSetupLocationId;
94. _acSetupLocationId = acSetupLocationId;
96. _availableCategories = new List<string>();
97. ReportImportPanel.Visibility = Visibility.Hidden;
99. ReportViewer.ViewerCore.ReuseParameterWhenRefresh = false;
100. ReportViewer.ViewChange += ReportViewerOnViewChange;
102. ReportViewer.Owner = this;
103. ReportViewer.ClickPage += reportViewer_ClickPage;
105. using (var dbConn = _data.GetOpenConnection())
106. {
107. if (!Catalog.IsColumnPresent("crreportsetup", "releaseseq", dbConn))
108. {
109. using (var cmd = dbConn.CreateCommand())
110. {
111. cmd.CommandText = "ALTER TABLE crreportsetup ADD COLUMN releaseseq int8;";
112. cmd.ExecuteNonQuery();
113. }
114. }
116. if (!Catalog.IsColumnPresent("crreportsetup", "isauthorized", dbConn))
117. {
118. using (var cmd = dbConn.CreateCommand())
119. {
120. cmd.CommandText = "ALTER TABLE crreportsetup ADD COLUMN isauthorized bool;";
121. cmd.ExecuteNonQuery();
122. }
123. }
125. if (!Catalog.IsTablePresent("crparameterprofiles", dbConn))
126. {
127. using (var cmd = dbConn.CreateCommand())
128. {
129. cmd.CommandText = @"CREATE TABLE public.crparameterprofiles (
130. seq bigserial NOT NULL,
131. profilename text NOT NULL,
132. reportseq int8 NOT NULL,
133. username text,
134. CONSTRAINT crparameterprofiles_pkey PRIMARY KEY (seq)
135. ) WITH (OIDS=FALSE);
137. CREATE INDEX crparameterprofiles_reportseq_idx ON public.crparameterprofiles USING btree (reportseq);";
138. cmd.ExecuteNonQuery();
139. }
140. }
141. else
142. {
143. if (!Catalog.IsIndexPresent("crparameterprofiles_reportseq_idx", dbConn))
144. {
145. using (var cmd = dbConn.CreateCommand())
146. {
147. cmd.CommandText = @"CREATE INDEX crparameterprofiles_reportseq_idx ON public.crparameterprofiles USING btree (reportseq);";
148. cmd.ExecuteNonQuery();
149. }
150. }
151. }
153. if (!Catalog.IsTablePresent("crparametervaluelistitems", dbConn))
154. {
155. using (var cmd = dbConn.CreateCommand())
156. {
157. cmd.CommandText = @"CREATE TABLE public.crparametervaluelistitems (
158. seq bigserial NOT NULL,
159. parameterseq int8 NOT NULL,
160. minvalue text,
161. isminvalueincluded bool NOT NULL,
162. maxvalue text,
163. ismaxvalueincluded bool NOT NULL,
164. singularvalue text,
165. CONSTRAINT crparametervaluelistitems_pkey PRIMARY KEY (seq)
166. ) WITH (OIDS=FALSE);
168. CREATE INDEX crparamlistvals_paramseq ON public.crparametervaluelistitems USING btree (parameterseq);";
169. cmd.ExecuteNonQuery();
170. }
171. }
173. if (!Catalog.IsTablePresent("crparametervalues", dbConn))
174. {
175. using (var cmd = dbConn.CreateCommand())
176. {
177. cmd.CommandText = @"CREATE TABLE public.crparametervalues (
178. seq bigserial NOT NULL,
179. profileseq int8 NOT NULL,
180. parametername text NOT NULL,
181. isvaluelist bool NOT NULL,
182. minvalue text,
183. isminvalueincluded bool NOT NULL,
184. maxvalue text,
185. ismaxvalueincluded bool NOT NULL,
186. singularvalue text,
187. CONSTRAINT crparametervalues_pkey PRIMARY KEY (seq)
188. ) WITH (OIDS=FALSE);
190. CREATE INDEX crparametervalues_profileseq_idx ON public.crparametervalues USING btree (profileseq);";
191. cmd.ExecuteNonQuery();
192. }
193. }
194. else
195. {
196. if (!Catalog.IsIndexPresent("crparametervalues_profileseq_idx", dbConn))
197. {
198. using (var cmd = dbConn.CreateCommand())
199. {
200. cmd.CommandText = @"CREATE INDEX crparametervalues_profileseq_idx ON public.crparametervalues USING btree (profileseq);";
201. cmd.ExecuteNonQuery();
202. }
203. }
204. }
206. if (!Catalog.IsTablePresent("crsubreports", dbConn))
207. {
208. using (var cmd = dbConn.CreateCommand())
209. {
210. cmd.CommandText = @"CREATE TABLE public.crsubreports (
211. seq bigserial NOT NULL,
212. category text NOT NULL,
213. name text NOT NULL,
214. filename text NOT NULL,
215. CONSTRAINT crsubreports_pkey PRIMARY KEY (seq)
216. ) WITH (OIDS=FALSE);";
217. cmd.ExecuteNonQuery();
218. }
219. }
221. _basePath = GetBasePath(dbConn);
222. GetUsers(dbConn);
223. RefreshReportList(dbConn);
224. }
226. if (_userAccess.GrantAdmin)
227. {
228. buttonAdmin.Visibility =
229. buttonSubreportSetup.Visibility =
230. buttonOptions.Visibility = buttonUpdate.Visibility = Visibility.Visible;
231. }
232. }
234. private string GetBasePath(NpgsqlConnection openConnection)
235. {
236. using (var cmd = openConnection.CreateCommand())
237. {
238. cmd.CommandText = @"SELECT pref_value FROM mnapp_preference WHERE pref_name = 'PathToCRFolder'";
239. var o = cmd.ExecuteScalar();
241. return o == null ? null : (string)o;
242. }
243. }
245. private void reportViewer_ClickPage(object sender, SAPBusinessObjects.WPF.Viewer.PageMouseEventArgs e)
246. {
247. try
248. {
249. var f = e.ObjectInfo;
251. if (f.ObjectType == SAPBusinessObjects.WPF.Viewer.ObjectType.DatabaseField &&
252. !string.IsNullOrWhiteSpace(f.Hyperlink))
253. {
254. Process.Start(f.Hyperlink.Substring(0, f.Hyperlink.LastIndexOf(" ", StringComparison.Ordinal)),
255. f.Hyperlink.Substring(f.Hyperlink.LastIndexOf(" ", StringComparison.Ordinal) + 1));
256. }
257. }
258. catch (Exception ex)
259. {
260. Log.Exception(ex);
261. }
262. }
264. private void RefreshReportList(NpgsqlConnection openConnection)
265. {
266. buttonRefreshReportList.IsEnabled = false;
268. if (GetCategories(openConnection))
269. {
270. GetReports(openConnection);
271. }
272. else
273. {
274. // todo: display standard error message, standardize w/ Omnis
275. MessageBox.Show("Unable to determine report categories");
276. }
278. buttonRefreshReportList.IsEnabled = true;
279. }
281. private enum NodeType
282. {
283. UserReport,
284. PresentSystemReport,
285. ReportCategory,
286. AvailableSection,
287. Import
288. }
290. private class NodeObject
291. {
292. public NodeType Type { get; set; }
293. public object Tag { get; set; }
295. public NodeObject(NodeType type, object tag)
296. {
297. Type = type;
298. Tag = tag;
299. }
301. public override string ToString()
302. {
303. switch (Type)
304. {
305. case NodeType.PresentSystemReport:
306. case NodeType.UserReport:
307. return ((CrystalReport)Tag).ToString();
308. case NodeType.AvailableSection:
309. return "App Store";
310. case NodeType.Import:
311. return "Import";
312. default:
313. return Tag.ToString();
314. }
315. }
316. }
318. private bool GetCategories(NpgsqlConnection openConnection)
319. {
320. _availableCategories.Clear();
321. CategoryComboBox.Items.Clear();
323. try
324. {
325. TreeViewReports.Items.Clear();
327. using (var cmd = openConnection.CreateCommand())
328. {
329. cmd.Parameters.AddParameterWithValue("IsUserAdmin", _userAccess.GrantAdmin);
330. cmd.Parameters.AddParameterWithValue("Username", _userName);
332. cmd.CommandText = @"
333. SELECT DISTINCT s.reportgroup
334. FROM crreportsetup AS s
335. WHERE COALESCE(s.isauthorized, true)=true
336. AND (@IsUserAdmin=true
337. OR (CASE WHEN (SELECT COUNT(*) FROM crreportauth a INNER JOIN crreportsetup g on a.report_seq = g.seq WHERE g.reportallowtabusers=true AND g.reportgroup=s.reportgroup AND a.username=@Username)>0 THEN 1 ELSE 0 END = 0 AND reportallowtabusers=true)
338. OR EXISTS(SELECT 1 FROM crreportauth AS a WHERE a.report_seq=s.seq AND a.username=@Username AND a.report_auth='ALLOW'))
339. AND NOT EXISTS(SELECT 1 FROM crreportauth AS a WHERE a.report_seq=s.seq AND a.username=@Username AND a.report_auth='DENY')
340. ORDER BY s.reportgroup
341. ";
342. using (var dr = cmd.ExecuteReader())
343. {
344. while (dr.Read())
345. {
346. var iconfile = "";
347. var group = dr["reportgroup"].ToString();
349. switch (group)
350. {
351. case "Accounting":
352. if (!_userAccess.GrantAccounting)
353. {
354. continue;
355. }
357. iconfile = "IconBooks.png";
358. break;
359. case "Sales":
360. if (!_userAccess.GrantSales)
361. {
362. continue;
363. }
365. iconfile = "IconSales.png";
366. break;
367. case "Inventory":
368. if (!_userAccess.GrantInventory)
369. {
370. continue;
371. }
373. iconfile = "IconInventory16.png";
374. break;
375. case "Service":
376. if (!_userAccess.GrantService)
377. {
378. continue;
379. }
381. iconfile = "IconTools16.png";
382. break;
383. case "Management":
384. if (!_userAccess.GrantManagement)
385. {
386. continue;
387. }
389. iconfile = "IconManagement.png";
390. break;
391. case "Parts":
392. if (!_userAccess.GrantParts)
393. {
394. continue;
395. }
397. iconfile = "IconGears.png";
398. break;
399. case "Month End":
400. if (!_userAccess.GrantMonthEnd)
401. {
402. continue;
403. }
405. iconfile = "IconCalendar.png";
406. break;
407. case "Commissions":
408. if (!_userAccess.GrantCommissions)
409. {
410. continue;
411. }
413. iconfile = "IconMoney.png";
414. break;
415. case "Financial Statements":
416. if (!_userAccess.GrantFinancialStatements)
417. {
418. continue;
419. }
421. iconfile = "IconBank.png";
422. break;
423. default:
424. iconfile = "question-white.png";
425. break;
426. }
428. var item = new TreeViewItem();
429. item.Header = GetNodeStackPanel(NodeType.ReportCategory, group, iconfile, group);
430. TreeViewReports.Items.Add(item);
432. _availableCategories.Add(group);
433. CategoryComboBox.Items.Add(group);
434. }
435. }
436. }
438. if (_userAccess.GrantAdmin)
439. {
440. var importItem = new TreeViewItem();
441. importItem.Header = GetNodeStackPanel(NodeType.Import, null, "folder-import.png", "Import");
442. TreeViewReports.Items.Add(importItem);
443. }
445. var newitemsfolder = new TreeViewItem();
446. newitemsfolder.Header = GetNodeStackPanel(NodeType.AvailableSection, null, "IconStarUnlit.png", "App Store");
447. newitemsfolder.IsEnabled = false; // todo
448. TreeViewReports.Items.Add(newitemsfolder);
450. return true;
451. }
452. catch (Exception ex)
453. {
454. MessageBox.Show(ex.Message, "Error loading categories");
455. return false;
456. }
457. }
459. // TODO: method sets class field as well as getting users. Rename or separate concerns
460. private void GetUsers(NpgsqlConnection openConnection)
461. {
462. using (var cmd = openConnection.CreateCommand())
463. {
464. _reportUsers = new List();
466. cmd.CommandText = @"
467. SELECT u.firstname, u.lastname, u.username
468. FROM mn_user AS u
469. WHERE u.active = 1
470. ORDER BY u.username
471. ";
472. using (var dr = cmd.ExecuteReader())
473. {
474. while (dr.Read())
475. {
476. var name = dr["username"].ToString();
477. _reportUsers.Add(new ReportUser(name));
478. }
479. }
481. cmd.CommandText = @"
482. SELECT a.report_seq, a.username
483. FROM crreportauth AS a
484. WHERE a.report_auth = 'ALLOW'
485. ORDER BY a.username
486. ";
488. var dict = new Dictionary<string, long[]>();
490. using (var dr = cmd.ExecuteReader())
491. {
492. var isFirstIteration = true;
493. string currentUsername = null;
494. var reportSeqs = new List<long>();
495. while (dr.Read())
496. {
497. var username = dr["username"].ToString();
498. if (isFirstIteration)
499. {
500. isFirstIteration = false;
501. currentUsername = username;
502. }
503. else
504. {
505. if (username != currentUsername)
506. {
507. dict.Add(currentUsername, reportSeqs.ToArray());
508. currentUsername = username;
509. reportSeqs.Clear();
510. }
511. }
512. reportSeqs.Add(dr.GetInt64(dr.GetOrdinal("report_seq")));
513. }
515. if (currentUsername == null && reportSeqs.Count > 0)
516. {
517. throw new Exception("Internal error");
518. }
520. if (currentUsername != null)
521. {
522. dict.Add(currentUsername, reportSeqs.ToArray());
523. }
524. }
526. foreach (var reportUser in _reportUsers)
527. {
528. if (dict.ContainsKey(reportUser.Name))
529. {
530. reportUser.AccessibleReportIds = dict[reportUser.Name];
531. }
532. }
533. }
534. }
536. // TODO: method sets class field as well as getting reports. Rename or separate concerns
537. public void GetReports(NpgsqlConnection openConnection)
538. {
539. _profiles.Clear();
541. foreach (TreeViewItem parentitem in TreeViewReports.Items)
542. {
543. var folder = (NodeObject)((StackPanel)parentitem.Header).Tag;
545. using (var cmd = openConnection.CreateCommand())
546. {
547. cmd.Parameters.AddParameterWithValue("UserName", _userName);
549. if (folder.Type == NodeType.ReportCategory)
550. {
551. var categoryName = folder.ToString();
553. cmd.Parameters.AddParameterWithValue("ReportGroup", categoryName);
554. cmd.Parameters.AddParameterWithValue("IsUserAdmin", _userAccess.GrantAdmin);
555. cmd.Parameters.AddParameterWithValue("Username", _userName);
557. cmd.CommandText = @"
558. SELECT s.seq, COALESCE(s.releaseseq, 0)::int8 AS releaseseq, s.reporttitle, s.reportpath, s.reportdescription,
559. COALESCE(s.reportenabled, FALSE) AS reportenabled, COALESCE(s.reportallowtabusers, FALSE) AS reportallowtabusers,
560. COALESCE(s.isauthorized, FALSE) AS isauthorized
561. FROM crreportsetup AS s
562. WHERE s.reportgroup = @ReportGroup
563. AND COALESCE(s.isauthorized, true) = true
564. AND (
565. @IsUserAdmin = true
566. OR s.reportallowtabusers = true
567. OR (
568. EXISTS (SELECT 1 FROM crreportauth AS a WHERE a.report_seq = s.seq AND a.username = @Username AND a.report_auth = 'ALLOW')
569. AND NOT EXISTS (SELECT 1 FROM crreportauth AS a WHERE a.report_seq = s.seq AND a.username = @Username AND a.report_auth = 'DENY')
570. )
571. )
572. ORDER BY s.reporttitle
573. ";
574. try
575. {
576. try
577. {
578. var reportList = new List();
580. using (var dr = cmd.ExecuteReader())
581. {
582. while (dr.Read())
583. {
584. var reportSeq = dr.SafeLongParse("seq");
585. var reportTitle = dr.SafeStringParse("reporttitle");
586. var report = new CrystalReport(reportSeq, reportTitle,
587. dr.SafeStringParse("reportdescription"),
588. dr.SafeStringParse("reportpath"),
589. dr.SafeLongParse("releaseseq"),
590. categoryName);
591. report.Enabled = dr.SafeBoolParse("reportenabled");
592. report.AllowTabUsers = dr.SafeBoolParse("reportallowtabusers");
593. report.IsAuthorized = dr.SafeBoolParse("isauthorized");
594. report.Description = dr.SafeStringParse("reportdescription");
595. reportList.Add(report);
596. _profiles.Add(new ReportAccessItem(reportSeq, reportTitle));
597. }
598. }
600. parentitem.Items.Clear();
601. foreach (var report in reportList)
602. {
603. // Do not add report if the report is not enabled
604. if (!report.Enabled && !_userAccess.GrantAdmin)
605. {
606. continue;
607. }
609. var item = new TreeViewItem
610. {
611. Margin = new Thickness(0, 2, 0, 0),
612. Padding = new Thickness(3)
613. //IsEnabled = !report.Enabled && _userAccess.GrantAdmin
614. };
616. if (!report.Enabled && _userAccess.GrantAdmin)
617. {
618. item.Opacity = 0.5;
619. }
621. StackPanel p;
622. if (report.ReleaseId == 0)
623. {
624. //ReportPencil.png
625. p = GetNodeStackPanel(NodeType.UserReport, report, "dealer_report.png",
626. report.Name);
627. }
628. else
629. {
630. //Report.png
631. p = GetNodeStackPanel(NodeType.PresentSystemReport, report, "db_report.png",
632. report.Name);
633. }
635. item.Header = p;
637. item.MouseDoubleClick += item_MouseDoubleClick;
638. // Add report description(if there is one) as tooltip.
639. if (!string.IsNullOrEmpty(report.Description))
640. {
641. item.ToolTip = report.Description;
642. }
644. parentitem.Items.Add(item);
645. }
646. }
647. catch (NpgsqlException ex)
648. {
649. if (ex.GetErrorCode() == "42703")
650. {
651. MessageBox.Show("System update required. Please contact DealerBuilt support.",
652. "Unable to continue",
653. MessageBoxButton.OK, MessageBoxImage.Error);
654. return;
655. }
656. }
657. }
658. catch (Exception ex)
659. {
660. Log.Exception(ex);
661. MessageBox.Show(
662. "There was a problem gathering reports:\n\n" + ex.Message + "\n\n" + ex.StackTrace,
663. "Unable to continue",
664. MessageBoxButton.OK, MessageBoxImage.Error);
665. return;
666. }
667. }
668. else if (folder.Type == NodeType.AvailableSection || folder.Type == NodeType.Import)
669. {
670. continue;
671. }
672. else
673. {
674. Log.Error($"GetReports failed to process the folder.Type=[{folder.Type.ToString()}]");
675. MessageBox.Show("There was an error getting report categories. Please contact DealerBuilt support if the problem persists.",
676. "Internal Error", MessageBoxButton.OK, MessageBoxImage.Error);
677. return;
678. }
679. }
680. }
682. using (var cmd = openConnection.CreateCommand())
683. {
684. cmd.CommandText = @"SELECT releaseseq FROM crreportsetup WHERE coalesce(releaseseq, 0) > 0 AND isauthorized = true";
685. var releaseSeqs = new List<long>();
687. using (var dr = cmd.ExecuteReader())
688. {
689. while (dr.Read())
690. {
691. releaseSeqs.Add(dr.GetInt64(dr.GetOrdinal("releaseseq")));
692. }
693. }
694. _releaseSeqs = releaseSeqs.ToArray();
695. }
696. }
698. private void item_MouseDoubleClick(object sender, MouseButtonEventArgs e)
699. {
700. try
701. {
702. ExecuteSelectedReport();
703. }
704. catch (Exception ex1)
705. {
706. Log.Exception(ex1);
707. }
708. }
710. private StackPanel GetNodeStackPanel(NodeType nodetype, object nodeitem, string imagefilename, string text)
711. {
712. var n = new NodeObject(nodetype, nodeitem);
714. var p = new StackPanel { Orientation = Orientation.Horizontal };
715. var im = new Image
716. {
717. Source =
718. new BitmapImage(new Uri(@"/CrystalViewer;component/Images/" + imagefilename,
719. UriKind.Relative))
720. };
721. im.Width = im.Height = 16;
722. im.Margin = new Thickness(0, 0, 6, 0);
723. p.Children.Add(im);
725. var tb = new TextBlock { Text = text };
726. p.Children.Add(tb);
727. p.Tag = n;
729. return p;
730. }
732. private NodeObject GetSelectedNodeObject()
733. {
734. return (NodeObject)((StackPanel)((TreeViewItem)TreeViewReports.SelectedItem).Header).Tag;
735. }
737. private void treeViewReports_SelectedItemChanged(object sender, RoutedPropertyChangedEventArgs<object> e)
738. {
739. try
740. {
741. var shownothing = false;
743. if (TreeViewReports.SelectedItem != null)
744. {
745. var t = GetSelectedNodeObject();
746. switch (t.Type)
747. {
748. case NodeType.PresentSystemReport:
749. case NodeType.UserReport:
750. ReportViewer.Visibility = Visibility.Visible;
751. ReportImportPanel.Visibility = Visibility.Hidden;
752. webBrowserMain.Visibility = Visibility.Hidden;
753. var cr = (CrystalReport)t.Tag;
754. // todo: if admin
755. buttonOptions.IsEnabled = true;
756. buttonRun.IsEnabled = true;
758. if (_userAccess.GrantAdmin)
759. {
760. TreeViewReports.ContextMenu = TreeViewReports.Resources["ReportContext"] as ContextMenu;
761. }
762. break;
764. case NodeType.AvailableSection:
765. ReportViewer.Visibility = Visibility.Hidden;
766. ReportImportPanel.Visibility = Visibility.Hidden;
767. webBrowserMain.Navigate("http://localhost/AppStore?r=" + string.Join(",", _releaseSeqs));
768. webBrowserMain.Visibility = Visibility.Visible;
769. TreeViewReports.ContextMenu = null;
770. break;
772. case NodeType.Import:
773. ReportViewer.Visibility = Visibility.Hidden;
774. webBrowserMain.Visibility = Visibility.Hidden;
775. ReportImportPanel.Visibility = Visibility.Visible;
776. TreeViewReports.ContextMenu = null;
777. break;
779. default:
780. shownothing = true;
781. break;
782. }
783. }
784. else
785. {
786. shownothing = true;
787. }
789. if (!shownothing)
790. {
791. return;
792. }
794. // Show nothing
795. TreeViewReports.ContextMenu = null;
796. ReportViewer.Visibility = Visibility.Visible;
797. webBrowserMain.Visibility = Visibility.Hidden;
798. ReportImportPanel.Visibility = Visibility.Hidden;
799. buttonRun.IsEnabled = buttonOptions.IsEnabled = false;
800. }
801. catch (Exception ex1)
802. {
803. Log.Exception(ex1);
804. }
805. }
807. private void buttonRun_Click(object sender, RoutedEventArgs e)
808. {
809. try
810. {
811. ExecuteSelectedReport();
812. }
813. catch (Exception ex1)
814. {
815. Log.Exception(ex1);
816. }
817. }
819. private void ExecuteSelectedReport()
820. {
821. Cursor = Cursors.Wait;
822. try
823. {
824. var selectednode = (NodeObject)((StackPanel)((TreeViewItem)TreeViewReports.SelectedItem).Header).Tag;
826. switch (selectednode.Type)
827. {
828. case NodeType.UserReport:
829. case NodeType.PresentSystemReport:
830. DisplayReport((CrystalReport)selectednode.Tag);
831. break;
833. }
834. }
835. catch (Exception ex)
836. {
837. Log.Exception(ex);
838. MessageBox.Show(ex.Message, "Failed to display report");
839. }
841. Cursor = null;
842. }
844. private ReportDocument GetReportDocument(CrystalReport report)
845. {
846. var ret = new ReportDocument();
847. ret.Load(report.Path, OpenReportMethod.OpenReportByTempCopy);
848. return ret;
849. }
851. private void DisplayReport(CrystalReport report)
852. {
853. ReportDocument activeReport;
855. try
856. {
857. activeReport = GetReportDocument(report);
858. }
859. catch (CrystalReportsException cre)
860. {
861. if (cre.InnerException.HResult == -2147467259)
862. {
863. Log.Exception(cre);
864. MessageBox.Show(cre.InnerException.Message, "Failed to display report");
865. return;
866. }
868. throw;
869. }
870. catch (Exception ex)
871. {
872. Log.Exception(ex);
873. MessageBox.Show(ex.Message, "Unable to load report");
874. return;
875. }
877. if (!SetDataConnection(activeReport))
878. {
879. MessageBox.Show("Could not create a connection to the report database");
880. return;
881. }
883. try
884. {
885. using (var dbConnection = _data.GetOpenConnection())
886. {
887. report.Parameters = _data.GetParameters(dbConnection, report).ToArray();
888. report.ParameterProfiles = _data.GetParameterProfiles(dbConnection, report, _userName).ToArray();
890. long selectedStoredParameterProfileId = 0;
891. bool setParameterValues = true;
893. if (activeReport.DataDefinition.ParameterFields.Count > 0)
894. {
895. for (var i = 0; i < activeReport.DataDefinition.ParameterFields.Count; i++)
896. {
897. foreach (var param in report.Parameters)
898. {
899. if (activeReport.DataDefinition.ParameterFields[i].Name == param.Name)
900. {
901. if (param.Prompt != null && param.Prompt.Trim() != "")
902. {
903. try
904. {
905. activeReport.DataDefinition.ParameterFields[i].PromptText = param.Prompt;
906. break;
907. }
908. catch { }
909. }
910. }
911. }
912. }
914. var parametersWindow = new ParametersWindow(report, _data, _userName);
915. parametersWindow.Owner = this;
916. Cursor = null;
917. bool? dialogResult = parametersWindow.ShowDialog();
919. if (dialogResult != null && dialogResult == true)
920. {
921. if (parametersWindow.Result == ParameterWindowResult.Run)
922. {
923. setParameterValues = true;
924. }
925. else
926. {
927. setParameterValues = false;
928. if (parametersWindow.Result == ParameterWindowResult.CreatePrivate || parametersWindow.Result == ParameterWindowResult.CreatePublic || parametersWindow.Result == ParameterWindowResult.Edit)
929. {
930. if (parametersWindow.NewParameterSetName != null)
931. {
932. _newParameterProfileName = parametersWindow.NewParameterSetName;
933. }
934. }
935. }
937. selectedStoredParameterProfileId = parametersWindow.SelectedStoredParametersId;
938. }
939. else
940. {
941. return;
942. }
943. }
945. if (!ProcessParameters(activeReport, report, selectedStoredParameterProfileId, setParameterValues))
946. {
947. return;
948. }
950. ReportViewer.ViewerCore.ReportSource = activeReport;
951. _currentlyDisplayedReport = activeReport;
952. _currentlyDisplayedReportModel = report;
953. btnPrint.IsEnabled = true;
954. }
955. }
956. catch (Exception ex)
957. {
958. Log.Exception(ex);
959. MessageBox.Show(ex.Message, "Failed to display report");
960. return;
961. }
962. }
964. ///
965. /// Sets the Crystal Report data connection to the PostgreSQL server connection
966. ///
967. /// AT-417; Cloud Jira; Removes the dependency on odbcad32.exe connection setup per user terminal
968. ///
969. ///
970. private bool SetDataConnection(ReportDocument report)
971. {
972. try
973. {
974. ConnectionInfo connInfo = new ConnectionInfo
975. {
976. ServerName = $"Driver={{PostgreSQL ANSI}};Server={_data?.ConnectionDatas?[0]?.Host};Port={_data?.ConnectionDatas?[0]?.Port};CA={(_data.ConnectionString.Contains("Prefer") ? "prefer" : "disable")};",
977. DatabaseName = _data?.ConnectionDatas?[0]?.DatabaseName,
978. UserID = _data?.ConnectionDatas?[0]?.Username,
979. Password = _data?.ConnectionDatas?[0]?.Password
980. };
982. TableLogOnInfo tableLogOnInfo = new TableLogOnInfo
983. {
984. ConnectionInfo = connInfo
985. };
987. foreach (Table table in report.Database.Tables)
988. {
989. table.LogOnInfo.ConnectionInfo.ServerName = connInfo.ServerName;
990. table.LogOnInfo.ConnectionInfo.DatabaseName = connInfo.DatabaseName;
991. table.LogOnInfo.ConnectionInfo.UserID = connInfo.UserID;
992. table.LogOnInfo.ConnectionInfo.Password = connInfo.Password;
993. table.ApplyLogOnInfo(tableLogOnInfo);
994. }
996. report.DataSourceConnections[0].SetConnection(connInfo.ServerName, connInfo.DatabaseName, connInfo.UserID, connInfo.Password);
998. return true;
999. }
1000. catch (Exception ex)
1001. {
1002. Log.Exception(ex);
1003. return false;
1004. }
1005. }
1007. // TODO: rename this to what it actually does - StartsWithIgnoreCase
1008. private bool StartsWithIgnoreCase(string s, string prefix)
1009. {
1010. return s.StartsWith(prefix, StringComparison.InvariantCultureIgnoreCase);
1011. }
1013. private bool ProcessParameters(ReportDocument reportDocument, CrystalReport report, long selectedStoredParameterProfileId, bool setValues)
1014. {
1015. var parameterFields = reportDocument.ParameterFields;
1016. var usingStoredProfile = selectedStoredParameterProfileId > 0;
1018. try
1019. {
1020. //This always throws an exception but is a needed work-around for some reports not showing default parameter options properly.
1021. int defaultXmlExportSelection = reportDocument.DefaultXmlExportSelection;
1022. }
1023. catch (Exception) { }
1025. try
1026. {
1027. using (var dbConnection = _data.GetOpenConnection())
1028. {
1029. var storedProfileValues = new Dictionary<string, ParameterValues>();
1030. var legacyParameterSetups = new Dictionary<string, LegacyParameterSetup>();
1032. using (var cmd = dbConnection.CreateCommand())
1033. {
1034. if (usingStoredProfile)
1035. {
1036. cmd.Parameters.AddParameterWithValue("ProfileId", selectedStoredParameterProfileId);
1037. cmd.CommandText = @"
1038. SELECT p.seq, p.parametername, p.singularvalue, p.isvaluelist
1039. FROM crparametervalues AS p
1040. WHERE p.profileseq=@ProfileId
1041. ";
1042. using (var da = new NpgsqlDataAdapter(cmd))
1043. {
1044. DataTable dtParameterValues = new DataTable();
1045. da.Fill(dtParameterValues);
1046. if (dtParameterValues != null && dtParameterValues.Rows.Count > 0)
1047. {
1048. foreach (DataRow dr in dtParameterValues.Rows)
1049. {
1050. var pseq = dr["seq"];
1051. var pname = dr["parametername"].ToString();
1052. var pvalue = dr["singularvalue"].ToString();
1053. if (!bool.Parse(dr["isvaluelist"].ToString()))
1054. {
1055. if (storedProfileValues.ContainsKey(pname))
1056. {
1057. storedProfileValues[pname].AddValue(pvalue);
1058. }
1059. else
1060. {
1061. var pvalues = new ParameterValues();
1062. pvalues.AddValue(pvalue);
1063. storedProfileValues.Add(pname, pvalues);
1064. }
1065. }
1066. else
1067. {
1068. using (var cmd2 = dbConnection.CreateCommand())
1069. {
1070. cmd2.CommandText = @"
1071. SELECT singularvalue
1072. FROM crparametervaluelistitems
1073. WHERE parameterseq=@parameterseq
1074. ";
1075. cmd2.Parameters.AddWithValue("parameterseq", pseq);
1076. using (var da2 = new Npgsql.NpgsqlDataAdapter(cmd2))
1077. {
1078. DataTable dtParameterValueItems = new DataTable();
1079. da2.Fill(dtParameterValueItems);
1080. if (dtParameterValueItems != null && dtParameterValueItems.Rows.Count > 0)
1081. {
1082. foreach (DataRow dr2 in dtParameterValueItems.Rows)
1083. {
1084. pvalue = dr2["singularvalue"].ToString();
1085. if (storedProfileValues.ContainsKey(pname))
1086. {
1087. storedProfileValues[pname].AddValue(pvalue);
1088. }
1089. else
1090. {
1091. var pvalues = new ParameterValues();
1092. pvalues.AddValue(pvalue);
1093. storedProfileValues.Add(pname, pvalues);
1094. }
1095. }
1096. }
1097. }
1098. }
1099. }
1100. }
1101. }
1102. }
1103. }
1105. // Legacy parameter setups
1107. cmd.Parameters.AddParameterWithValue("ReportId", report.ReportId);
1109. cmd.CommandText = @"
1110. SELECT p.param_name, p.param_default_id, p.param_dynamic, p.param_dynamic_table_column
1111. FROM crreportparams AS p
1112. WHERE p.report_seq=@ReportId
1113. ";
1114. using (var dr = cmd.ExecuteReader())
1115. {
1116. while (dr.Read())
1117. {
1118. legacyParameterSetups.Add(dr.String("param_name"),
1119. new LegacyParameterSetup((LegacyParameterDefaultOption)dr.Long("param_default_id"),
1120. dr.String("param_dynamic_table_column")));
1121. }
1122. }
1123. }
1126. //var parameterFieldDefinitions = reportDocument.DataDefinition.ParameterFields;
1127. List<string> namesDone = new List<string>();
1128. for (var i = 0; i < parameterFields.Count; i++)
1129. {
1130. ParameterDiscreteValue discreteVal = null;
1131. var name = parameterFields[i].Name ?? "";
1132. var parameterFieldDefinition = reportDocument.DataDefinition.ParameterFields[name];
1133. var promptText = parameterFields[i].PromptText ?? "";
1135. if (usingStoredProfile)
1136. {
1137. if (storedProfileValues.ContainsKey(name))
1138. {
1139. if (setValues)
1140. {
1141. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
1142. {
1143. if (!namesDone.Contains(name))
1144. {
1145. reportDocument.SetParameterValue(name, storedProfileValues[name]);
1146. namesDone.Add(name);
1147. }
1148. }
1149. }
1150. }
1151. }
1153. // Prompt Text = automatic value
1154. if (StartsWithIgnoreCase(promptText, "#UserLySetupLocationId"))
1155. {
1156. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
1157. {
1158. if (!namesDone.Contains(name))
1159. {
1160. reportDocument.SetParameterValue(name, _lySetupLocationId);
1161. namesDone.Add(name);
1162. }
1163. }
1164. }
1165. else if (StartsWithIgnoreCase(promptText, "#UserSlSetupLocationId"))
1166. {
1167. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
1168. {
1169. if (!namesDone.Contains(name))
1170. {
1171. reportDocument.SetParameterValue(name, _slSetupLocationId);
1172. namesDone.Add(name);
1173. }
1174. }
1175. }
1176. else if (StartsWithIgnoreCase(promptText, "#UserAcSetupLocationId"))
1177. {
1178. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
1179. {
1180. if (!namesDone.Contains(name))
1181. {
1182. reportDocument.SetParameterValue(name, _acSetupLocationId);
1183. namesDone.Add(name);
1184. }
1185. }
1186. }
1187. /*
1188. "Current user\'s [Login ID] - String",
1189. "Current user\'s [Full Name] - String",
1190. "Current company [DBA Name] - String",
1191. "Current company [Legal Name] - String",
1192. "Current company [location] - Integer",
1193. */
1195. // Name = defaults
1196. else if (StartsWithIgnoreCase(name, "#AcSetupLocationId"))
1197. {
1198. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue)
1199. {
1200. if (!namesDone.Contains(name))
1201. {
1202. discreteVal = new ParameterDiscreteValue() { Value = GetAcSetupLocations(dbConnection) };
1203. parameterFields[i].DefaultValues.Clear();
1204. parameterFields[i].DefaultValues.Add(discreteVal);
1205. namesDone.Add(name);
1206. }
1207. }
1208. }
1209. else if (StartsWithIgnoreCase(name, "#LySetupLocationId"))
1210. {
1211. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue)
1212. {
1213. if (!namesDone.Contains(name))
1214. {
1215. discreteVal = new ParameterDiscreteValue() { Value = GetLySetupLocations(dbConnection) };
1216. parameterFields[i].DefaultValues.Clear();
1217. parameterFields[i].DefaultValues.Add(discreteVal);
1218. namesDone.Add(name);
1219. }
1220. }
1221. }
1222. else if (StartsWithIgnoreCase(name, "#SlSetupLocationId"))
1223. {
1224. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue && parameterFieldDefinition.EnableAllowEditingDefaultValue)
1225. {
1226. if (!namesDone.Contains(name))
1227. {
1228. discreteVal = new ParameterDiscreteValue() { Value = GetSlSetupLocations(dbConnection) };
1229. parameterFields[i].DefaultValues.Clear();
1230. parameterFields[i].DefaultValues.Add(discreteVal);
1231. namesDone.Add(name);
1232. }
1233. }
1234. }
1235. else
1236. {
1237. parameterFields[i].DefaultValues.Clear();
1238. }
1240. /*
1241. "Current user\'s [Login ID] - String",
1242. "Current user\'s [Full Name] - String",
1243. "Current company [DBA Name] - String",
1244. "Current company [Legal Name] - String",
1245. "Current company [location] - Integer",
1246. "Today\'s Date - Date",
1247. "Yesterday\'s Date - Date",
1248. "First day of this month - Date",
1249. "Last day of this month - Date",
1250. "First day of previous month - Date",
1251. "Last day of previous month - Date",
1252. "Beginning of this year - Date",
1253. "End of this year - Date",
1254. "Beginning of last year - Date",
1255. "End of last year - Date",
1256. */
1258. var pvalues = new ParameterValues();
1259. if (legacyParameterSetups.ContainsKey(name))
1260. {
1261. switch (legacyParameterSetups[name].LegacyParameterDefaultOption)
1262. {
1263. case LegacyParameterDefaultOption.NotSet:
1264. break;
1265. case LegacyParameterDefaultOption.CurrentUserLoginIdString:
1266. pvalues.Add(new ParameterDiscreteValue
1267. {
1268. Value = _userName,
1269. Description = "Current User Login Id"
1270. });
1271. break;
1272. case LegacyParameterDefaultOption.CurrentUserFullNameString:
1273. pvalues.Add(new ParameterDiscreteValue
1274. {
1275. Value = GetUsersFullName(dbConnection),
1276. Description = "Current User Full Name"
1277. });
1278. break;
1279. case LegacyParameterDefaultOption.CurrentCompanyDbaNameString:
1280. pvalues.Add(new ParameterDiscreteValue
1281. {
1282. Value = GetCompanyDbaName(dbConnection),
1283. Description = "Current Store Name"
1284. });
1285. break;
1286. case LegacyParameterDefaultOption.CurrentCompanyLegalNameString:
1287. pvalues.Add(new ParameterDiscreteValue
1288. {
1289. Value = GetCompanyLegalName(dbConnection),
1290. Description = "Current Company Legal Name"
1291. });
1292. break;
1293. case LegacyParameterDefaultOption.CurrentCompanyLocationInteger:
1294. pvalues.Add(new ParameterDiscreteValue
1295. {
1296. Value = _lySetupLocationId,
1297. Description = "Current Store Location ID"
1298. });
1299. break;
1300. case LegacyParameterDefaultOption.ShowListOfAuthorizedCompanyLocationsInteger:
1301. pvalues = GetLySetupLocations(dbConnection);
1302. break;
1303. case LegacyParameterDefaultOption.CurrentServiceLocationInteger:
1304. pvalues.Add(new ParameterDiscreteValue
1305. {
1306. Value = _slSetupLocationId,
1307. Description = "Current Service Location ID"
1308. });
1309. break;
1310. case LegacyParameterDefaultOption.ShowListOfAuthorizedServiceLocationsInteger:
1311. pvalues = GetSlSetupLocations(dbConnection);
1312. break;
1313. case LegacyParameterDefaultOption.TodaysDateDateTime:
1314. pvalues.Add(new ParameterDiscreteValue
1315. {
1316. Value = DateTime.Today,
1317. Description = "Today's Date"
1318. });
1319. break;
1320. case LegacyParameterDefaultOption.YesterdaysDateDateTime:
1321. pvalues.Add(new ParameterDiscreteValue
1322. {
1323. Value = DateTime.Today.AddDays(-1),
1324. Description = "Yesterday's Date"
1325. });
1326. break;
1327. case LegacyParameterDefaultOption.FirstDayOfThisMonthDateTime:
1328. pvalues.Add(new ParameterDiscreteValue
1329. {
1330. Value = DateTime.Parse(DateTime.Today.ToString("MM/01/yyyy")),
1331. Description = "First Day Of This Month"
1332. });
1333. break;
1334. case LegacyParameterDefaultOption.LastDayOfThisMonthDateTime:
1335. pvalues.Add(new ParameterDiscreteValue
1336. {
1337. Value = DateTime.Parse(DateTime.Today.AddMonths(1).ToString("MM/01/yyyy")).AddDays(-1),
1338. Description = "Last Day Of This Month"
1339. });
1340. break;
1341. case LegacyParameterDefaultOption.FirstDayOfPreviousMonthDateTime:
1342. pvalues.Add(new ParameterDiscreteValue
1343. {
1344. Value = DateTime.Parse(DateTime.Today.AddMonths(-1).ToString("MM/01/yyyy")),
1345. Description = "First Day Of Previous Month"
1346. });
1347. break;
1348. case LegacyParameterDefaultOption.LastDayOfPreviousMonthDateTime:
1349. pvalues.Add(new ParameterDiscreteValue
1350. {
1351. Value = DateTime.Parse(DateTime.Today.ToString("MM/01/yyyy")).AddDays(-1),
1352. Description = "Last Day Of Previous Month"
1353. });
1354. break;
1355. case LegacyParameterDefaultOption.BeginningOfThisYearDateTime:
1356. pvalues.Add(new ParameterDiscreteValue
1357. {
1358. Value = DateTime.Parse(DateTime.Today.ToString("01/01/yyyy")),
1359. Description = "Beginning Of This Year"
1360. });
1361. break;
1362. case LegacyParameterDefaultOption.EndOfThisYearDateTime:
1363. pvalues.Add(new ParameterDiscreteValue
1364. {
1365. Value = DateTime.Parse(DateTime.Today.AddYears(1).ToString("01/01/yyyy")).AddDays(-1),
1366. Description = "End Of This Year"
1367. });
1368. break;
1369. case LegacyParameterDefaultOption.BeginningOfLastYearDateTime:
1370. pvalues.Add(new ParameterDiscreteValue
1371. {
1372. Value = DateTime.Parse(DateTime.Today.AddYears(-1).ToString("01/01/yyyy")),
1373. Description = "Beginning Of Last Year"
1374. });
1375. break;
1376. case LegacyParameterDefaultOption.EndOfLastYearDateTime:
1377. pvalues.Add(new ParameterDiscreteValue
1378. {
1379. Value = DateTime.Parse(DateTime.Today.ToString("01/01/yyyy")).AddDays(-1),
1380. Description = "End Of Last Year"
1381. });
1382. break;
1383. case LegacyParameterDefaultOption.ValueString:
1384. break;
1385. case LegacyParameterDefaultOption.ValueInteger:
1386. break;
1387. case LegacyParameterDefaultOption.CCPADisclousureMessage:
1388. pvalues.Add(new ParameterDiscreteValue
1389. {
1390. Value = GetDisclousureMessage(dbConnection),
1391. Description = "CCPA Disclosure Message"
1392. });
1393. break;
1394. }
1395. }
1397. if (usingStoredProfile && _newParameterProfileName != null && _newParameterProfileName.Trim() != "")
1398. {
1399. if (storedProfileValues.ContainsKey(name))
1400. {
1401. if (!setValues)
1402. {
1403. foreach (var storedProfileValue in storedProfileValues[name])
1404. {
1405. bool exists = false;
1406. foreach (var pvalue in pvalues)
1407. {
1408. if (((ParameterDiscreteValue)pvalue).Value.ToString() == ((ParameterDiscreteValue)storedProfileValue).Value.ToString())
1409. {
1410. exists = true;
1411. break;
1412. }
1413. }
1414. if (!exists)
1415. {
1416. pvalues.Add(new ParameterDiscreteValue
1417. {
1418. Value = ((ParameterDiscreteValue)storedProfileValue).Value,
1419. Description = _newParameterProfileName
1420. });
1421. }
1422. }
1423. }
1424. }
1425. }
1427. /* param_default_id
1429. 0 [Not Set]
1430. 1 Current user's [Login ID] - String
1431. 2 Current user's [Full Name] - String
1432. 3 Current company [DBA Name] - String
1433. 4 Current company [Legal Name] - String
1434. 5 Current company [location] - Integer
1435. 6 Show list of authorized company locations - Integer
1436. 7 Current service location - Integer
1437. 8 Show list of authorized service locations - Integer
1438. 9 Today's Date - Date
1439. 10 Yesterday's Date - Date
1440. 11 First day of this month - Date
1441. 12 Last day of this month - Date
1442. 13 First day of previous month - Date
1443. 14 Last day of previous month - Date
1444. 15 Beginning of this year - Date
1445. 16 End of this year - Date
1446. 17 Beginning of last year - Date
1447. 18 End of last year - Date
1448. 19 String Value - String
1449. 20 Integer Value - Integer
1451. */
1453. if (pvalues.Count > 0)
1454. {
1455. if (parameterFieldDefinition.DiscreteOrRangeKind == DiscreteOrRangeKind.DiscreteValue)
1456. {
1457. bool allowUserToChange = false;
1458. foreach (var param in report.Parameters)
1459. {
1460. if (param.Name == parameterFieldDefinition.Name)
1461. {
1462. allowUserToChange = param.AllowUserToChange;
1463. break;
1464. }
1465. }
1466. if (allowUserToChange)
1467. {
1468. if (parameterFieldDefinition.EnableAllowEditingDefaultValue)
1469. {
1470. if (!namesDone.Contains(name))
1471. {
1472. parameterFields[i].DefaultValues.Clear();
1473. parameterFields[i].DefaultValues.AddRange(pvalues);
1474. namesDone.Add(name);
1475. }
1476. }
1477. }
1478. else
1479. {
1480. if (!namesDone.Contains(name))
1481. {
1482. parameterFieldDefinition.ApplyCurrentValues(pvalues);
1483. namesDone.Add(name);
1484. }
1485. }
1486. }
1487. }
1488. }
1489. }
1490. }
1491. catch (Exception ex)
1492. {
1493. Log.Exception(ex);
1494. }
1496. return true;
1497. }
1499. private void Focus_Attained()
1500. {
1501. MessageBox.Show("heyyyyyy");
1502. }
1504. private class LegacyParameterSetup
1505. {
1506. public LegacyParameterDefaultOption LegacyParameterDefaultOption { get; set; }
1507. public string DynamicColumn { get; set; }
1509. public LegacyParameterSetup(LegacyParameterDefaultOption defaultOption, string dynamicColumn)
1510. {
1511. LegacyParameterDefaultOption = defaultOption;
1512. DynamicColumn = string.IsNullOrWhiteSpace(dynamicColumn) ? null : dynamicColumn;
1513. }
1514. }
1516. private enum LegacyParameterDefaultOption
1517. {
1518. NotSet = 0,
1519. CurrentUserLoginIdString = 1,
1520. CurrentUserFullNameString = 2,
1521. CurrentCompanyDbaNameString = 3,
1522. CurrentCompanyLegalNameString = 4,
1523. CurrentCompanyLocationInteger = 5,
1524. ShowListOfAuthorizedCompanyLocationsInteger = 6,
1525. CurrentServiceLocationInteger = 7,
1526. ShowListOfAuthorizedServiceLocationsInteger = 8,
1527. TodaysDateDateTime = 9,
1528. YesterdaysDateDateTime = 10,
1529. FirstDayOfThisMonthDateTime = 11,
1530. LastDayOfThisMonthDateTime = 12,
1531. FirstDayOfPreviousMonthDateTime = 13,
1532. LastDayOfPreviousMonthDateTime = 14,
1533. BeginningOfThisYearDateTime = 15,
1534. EndOfThisYearDateTime = 16,
1535. BeginningOfLastYearDateTime = 17,
1536. EndOfLastYearDateTime = 18,
1537. ValueString = 19,
1538. ValueInteger = 20,
1539. CCPADisclousureMessage = 21
1540. }
1542. public void goToPage_Click(object sender, SAPBusinessObjects.WPF.Viewer.PageMouseEventArgs e)
1543. {
1544. MessageBox.Show(e.ObjectInfo.Text);
1545. }
1547. private ParameterValues GetAcSetupLocations(NpgsqlConnection dbConnection)
1548. {
1549. using (var dbCommand = dbConnection.CreateCommand())
1550. {
1551. dbCommand.CommandText = @"
1552. SELECT locationid::int8, companyname
1553. FROM acsetup
1554. ORDER BY locationid
1555. ";
1556. using (var dr = dbCommand.ExecuteReader())
1557. {
1558. var defaultValues = new ParameterValues();
1560. while (dr.Read())
1561. {
1562. defaultValues.Add(new ParameterDiscreteValue
1563. {
1564. Value = dr.GetInt64(dr.GetOrdinal("locationid")),
1565. Description = dr["companyname"].ToString()
1566. });
1567. }
1569. return defaultValues;
1570. }
1571. }
1572. }
1574. private ParameterValues GetLySetupLocations(NpgsqlConnection dbConnection)
1575. {
1576. using (var dbCommand = dbConnection.CreateCommand())
1577. {
1578. dbCommand.CommandText = @"
1579. SELECT locationid::int8, coconame
1580. FROM lysetup
1581. ORDER BY lpad(locationid, 2, '0')::int2
1582. ";
1583. using (var dr = dbCommand.ExecuteReader())
1584. {
1585. var defaultValues = new ParameterValues();
1587. while (dr.Read())
1588. {
1589. defaultValues.Add(new ParameterDiscreteValue
1590. {
1591. Value = dr.GetInt64(dr.GetOrdinal("locationid")),
1592. Description = dr["coconame"].ToString()
1593. });
1594. }
1596. return defaultValues;
1597. }
1598. }
1599. }
1601. private ParameterValues GetSlSetupLocations(NpgsqlConnection dbConnection)
1602. {
1603. using (var dbCommand = dbConnection.CreateCommand())
1604. {
1605. dbCommand.CommandText = @"
1606. SELECT locationid, name
1607. FROM slsetup
1608. ORDER BY lpad(locationid::text, 2, '0')::int2
1609. ";
1610. using (var dr = dbCommand.ExecuteReader())
1611. {
1612. var defaultValues = new ParameterValues();
1614. while (dr.Read())
1615. {
1616. defaultValues.Add(new ParameterDiscreteValue
1617. {
1618. Value = dr.GetInt64(dr.GetOrdinal("locationid")),
1619. Description = dr["name"].ToString()
1620. });
1621. }
1623. return defaultValues;
1624. }
1625. }
1626. }
1628. private string GetUsersFullName(NpgsqlConnection dbConnection)
1629. {
1630. using (var dbCommand = dbConnection.CreateCommand())
1631. {
1632. dbCommand.CommandText = "SELECT ltrim(rtrim(firstname || ' ' || lastname)) AS fullname FROM mn_user WHERE username = @username LIMIT 1;";
1633. dbCommand.Parameters.AddWithValue("username", _userName);
1634. return dbCommand.ExecuteScalar().ToString();
1635. }
1636. }
1638. private string GetCompanyDbaName(NpgsqlConnection dbConnection)
1639. {
1640. using (var dbCommand = dbConnection.CreateCommand())
1641. {
1642. dbCommand.CommandText = "SELECT coconame FROM lysetup WHERE locationid = @locationid LIMIT 1;";
1643. dbCommand.Parameters.AddWithValue("username", _lySetupLocationId.ToString());
1644. return dbCommand.ExecuteScalar().ToString();
1645. }
1646. }
1648. private string GetCompanyLegalName(NpgsqlConnection dbConnection)
1649. {
1650. using (var dbCommand = dbConnection.CreateCommand())
1651. {
1652. dbCommand.CommandText = "SELECT legalname FROM lysetup WHERE locationid = @locationid LIMIT 1;";
1653. dbCommand.Parameters.AddWithValue("username", _lySetupLocationId.ToString());
1654. return dbCommand.ExecuteScalar().ToString();
1655. }
1656. }
1658. private string GetDisclousureMessage(NpgsqlConnection dbConnection)
1659. {
1660. string disclousureMessage = string.Empty;
1661. using (var dbCommand = dbConnection.CreateCommand())
1662. {
1663. dbCommand.CommandText = "SELECT pref_value FROM mnapp_preference WHERE pref_name = 'CCPAReportDisclosure'";
1664. var value = dbCommand.ExecuteScalar();
1665. if (value != DBNull.Value)
1666. {
1667. disclousureMessage = value.ToString();
1668. }
1669. }
1670. return disclousureMessage;
1671. }
1673. private void buttonAdmin_Click(object sender, RoutedEventArgs e)
1674. {
1675. try
1676. {
1677. var accessWindow = new AccessWindow(_data, _reportUsers, _profiles, _userName, _userAccess);
1678. accessWindow.Owner = this;
1680. bool? result = accessWindow.ShowDialog();
1681. if (result != null && result == true)
1682. {
1683. _reportUsers = accessWindow.ReportUsers;
1684. _profiles = accessWindow.ReportAccessItems;
1685. }
1686. using (var db = _data.GetOpenConnection())
1687. {
1688. GetUsers(db);
1689. }
1690. }
1691. catch (Exception ex1)
1692. {
1693. Log.Exception(ex1);
1694. }
1695. }
1697. private void buttonRefreshReportList_Click(object sender, RoutedEventArgs e)
1698. {
1699. try
1700. {
1701. using (var db = _data.GetOpenConnection())
1702. {
1703. RefreshReportList(db);
1704. }
1705. }
1706. catch (Exception ex1)
1707. {
1708. Log.Exception(ex1);
1709. }
1710. }
1712. private static void SaveFile(Stream saveFile, string localFilePath)
1713. {
1714. const int bufferSize = 65536; // 64K
1716. using (var outfile = new FileStream(localFilePath, FileMode.Create))
1717. {
1718. byte[] buffer = new byte[bufferSize];
1719. int bytesRead = saveFile.Read(buffer, 0, bufferSize);
1721. while (bytesRead > 0)
1722. {
1723. outfile.Write(buffer, 0, bytesRead);
1724. bytesRead = saveFile.Read(buffer, 0, bufferSize);
1725. }
1726. }
1727. }
1729. private void ButtonReportFileSelect_OnClick(object sender, RoutedEventArgs e)
1730. {
1731. try
1732. {
1733. var reportPath = Tools.GetUserReportPath();
1735. if (reportPath == null)
1736. return;
1738. ReportFilePath.Text = reportPath;
1739. }
1740. catch (Exception ex1)
1741. {
1742. Log.Exception(ex1);
1743. }
1744. }
1746. private void ButtonImport_OnClick(object sender, RoutedEventArgs e)
1747. {
1748. try
1749. {
1750. string reportGroup = "";
1751. string sourcePath = ReportFilePath.Text;
1752. if (CategoryComboBox.SelectedValue != null && CategoryComboBox.SelectedValue.ToString().Trim() != "")
1753. {
1754. reportGroup = CategoryComboBox.SelectedValue.ToString();
1755. }
1756. else if (CategoryComboBox.Text != null && CategoryComboBox.Text.Trim() != "")
1757. {
1758. reportGroup = CategoryComboBox.Text;
1759. }
1760. else
1761. {
1762. MessageBox.Show("Please select a report category", "Required Field Missing", MessageBoxButton.OK, MessageBoxImage.Stop);
1763. return;
1764. }
1766. var destinationPath = _basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray()) + "\\" + System.IO.Path.GetFileName(sourcePath);
1768. if (sourcePath.ToLower() != destinationPath.ToLower())
1769. {
1770. try
1771. {
1772. if (!Directory.Exists(_basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray())))
1773. {
1774. Directory.CreateDirectory(_basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray()));
1775. }
1776. if (sourcePath.ToLower() != destinationPath.ToLower()) //Don't copy if the destination matches the source.
1777. {
1778. File.Copy(sourcePath, destinationPath);
1779. }
1780. }
1781. catch (Exception ex)
1782. {
1783. MessageBox.Show(ex.Message, "Unable to copy report file", MessageBoxButton.OK, MessageBoxImage.Error);
1784. return;
1785. }
1786. }
1787. using (var dbConn = _data.GetOpenConnection())
1788. {
1789. try
1790. {
1791. using (var cmd = dbConn.CreateCommand())
1792. {
1793. cmd.Parameters.AddParameterWithValue("ReportPath", destinationPath);
1794. cmd.Parameters.AddParameterWithValue("ReportTitle", ReportTitle.Text);
1795. cmd.Parameters.AddParameterWithValue("ReportDescription", ReportDescription.Text);
1796. cmd.Parameters.AddParameterWithValue("ReportGroup", reportGroup);
1798. cmd.CommandText = @"
1799. INSERT INTO crreportsetup (reportpath, reporttitle, reportdescription, reportgroup, reportenabled)
1800. VALUES (@ReportPath, @ReportTitle, @ReportDescription, @ReportGroup, true)
1801. ";
1802. cmd.ExecuteNonQuery();
1803. }
1804. }
1805. catch (Exception ex)
1806. {
1807. MessageBox.Show(ex.Message, "Unable to import report file", MessageBoxButton.OK,
1808. MessageBoxImage.Error);
1809. return;
1810. }
1812. RefreshReportList(dbConn);
1813. }
1814. }
1815. catch (Exception ex1)
1816. {
1817. Log.Exception(ex1);
1818. }
1819. }
1821. private void EditReport_Click(object sender, RoutedEventArgs e)
1822. {
1823. try
1824. {
1825. EditSelectedReport();
1826. }
1827. catch (Exception ex1)
1828. {
1829. Log.Exception(ex1);
1830. }
1831. }
1833. private void UpdateReport_Click(object sender, RoutedEventArgs e)
1834. {
1835. try
1836. {
1837. UpdateSelectedReport();
1838. }
1839. catch (Exception ex1)
1840. {
1841. Log.Exception(ex1);
1842. }
1843. }
1845. private void EditSelectedReport()
1846. {
1847. var sno = GetSelectedNodeObject();
1848. var s = new ReportOptionsWindow(_data, (CrystalReport)sno.Tag, _availableCategories, _reportUsers);
1849. s.Owner = this;
1850. s.ShowDialog();
1851. sno.Tag = s._report;
1852. }
1854. private void UpdateSelectedReport()
1855. {
1856. var reportPath = Tools.GetUserReportPath();
1857. if (reportPath != null)
1858. {
1859. var report = (CrystalReport)GetSelectedNodeObject().Tag;
1860. var reportGroup = report.CategoryName;
1861. var filename = System.IO.Path.GetFileName(report.Path);
1863. var destinationPath = _basePath.TrimEnd("\\".ToCharArray()) + "\\" + reportGroup.TrimEnd("\\".ToCharArray()) + "\\" + filename;
1865. try
1866. {
1867. if (destinationPath.ToLower() != reportPath.ToLower())
1868. {
1869. File.Copy(reportPath, destinationPath, true);
1870. MessageBox.Show("Report updated", "Success", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
1871. }
1872. else
1873. {
1874. MessageBox.Show("Report not updated. Source file path is the same as destination file path.", "Success", MessageBoxButton.OK, MessageBoxImage.Information, MessageBoxResult.OK);
1875. }
1876. }
1877. catch (Exception ex)
1878. {
1879. MessageBox.Show(ex.Message, "Unable to copy report file", MessageBoxButton.OK, MessageBoxImage.Error);
1880. return;
1881. }
1882. }
1883. }
1885. private void DeleteReport_Click(object sender, RoutedEventArgs e)
1886. {
1887. try
1888. {
1889. var report = (CrystalReport)GetSelectedNodeObject().Tag;
1890. var question = string.Format("Delete {0}?", report.Name);
1891. if (MessageBox.Show(question, "Delete Report", MessageBoxButton.YesNo, MessageBoxImage.Question) ==
1892. MessageBoxResult.Yes)
1893. {
1894. using (var db = _data.GetOpenConnection())
1895. {
1896. DeleteReport(db, report.ReportId);
1897. RefreshReportList(db);
1898. }
1899. }
1900. }
1901. catch (Exception ex1)
1902. {
1903. Log.Exception(ex1);
1904. }
1905. }
1907. private void DeleteReport(NpgsqlConnection openConnection, long reportId)
1908. {
1909. try
1910. {
1912. _data.DeleteProfiles(openConnection, reportId);
1914. // todo: everything to the end of the try should be in the same tranaction as the above profile deletion
1916. string path;
1918. using (var command = openConnection.CreateCommand())
1919. {
1920. command.Parameters.AddWithValue("ReportId", reportId);
1921. command.CommandText = @"
1922. DELETE FROM crreportsetup WHERE seq=@ReportId RETURNING reportpath
1923. ";
1924. path = (string)command.ExecuteScalar();
1925. }
1927. //File.Delete(path); //Per Sherri, she does not want the .rpt file itself to be deleted, just remove from the viewer.
1928. }
1929. catch (Exception ex)
1930. {
1931. MessageBox.Show(
1932. "The following error occured while attempting to delete the selected report:\n\n" + ex.Message,
1933. "Report Not Deleted", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
1934. }
1935. }
1937. private void ReportViewerOnViewChange(object sender, RoutedEventArgs routedEventArgs)
1938. {
1939. try
1940. {
1941. if (routedEventArgs != null && routedEventArgs.OriginalSource != null)
1942. {
1943. currentReportAlbum = (SAPBusinessObjects.WPF.Viewer.ReportAlbum)routedEventArgs.OriginalSource;
1944. }
1945. else
1946. {
1947. currentReportAlbum = null;
1948. }
1950. if (_newParameterProfileName == null)
1951. return;
1953. using (var connection = _data.GetOpenConnection())
1954. {
1955. using (var transaction = connection.BeginTransaction())
1956. {
1957. try
1958. {
1959. using (var cmd = connection.CreateCommand())
1960. {
1961. long profileId = 0;
1962. cmd.Parameters.AddParameterWithValue("ProfileName", _newParameterProfileName);
1963. cmd.Parameters.AddParameterWithValue("UserName", _userName);
1964. cmd.Parameters.AddParameterWithValue("ReportSeq", _currentlyDisplayedReportModel.ReportId);
1965. cmd.CommandText = @"
1966. SELECT seq FROM crparameterprofiles
1967. WHERE (reportseq = @ReportSeq)
1968. AND (username = @UserName)
1969. AND (profilename = @ProfileName)
1970. LIMIT 1;
1971. ";
1972. object ob = cmd.ExecuteScalar();
1973. if (ob != null && ob.ToString() != "")
1974. {
1975. long.TryParse(ob.ToString(), out profileId);
1976. }
1978. if (profileId <= 0) //INSERT crparameterprofiles
1979. {
1980. cmd.CommandText = @"
1981. INSERT INTO crparameterprofiles (profilename, username, reportseq)
1982. VALUES (@ProfileName, @UserName, @ReportSeq)
1983. RETURNING seq;
1984. ";
1985. ob = cmd.ExecuteScalar();
1986. if (ob != null && ob.ToString() != "")
1987. {
1988. long.TryParse(ob.ToString(), out profileId);
1989. }
1990. }
1991. //else //UPDATE crparameterprofiles (not necessary)
1993. cmd.Parameters.AddParameterWithValue("ProfileId", profileId);
1994. cmd.Parameters.AddParameterWithValue("ParameterName", NpgsqlDbType.Text, "");
1995. cmd.Parameters.AddParameterWithValue("IsValueList", NpgsqlDbType.Boolean, false);
1996. cmd.Parameters.AddParameterWithValue("SingularValue", NpgsqlDbType.Text, "");
1997. cmd.Parameters.AddParameterWithValue("MinValue", NpgsqlDbType.Text, "");
1998. cmd.Parameters.AddParameterWithValue("IsMinValueIncluded", NpgsqlDbType.Boolean, false);
1999. cmd.Parameters.AddParameterWithValue("MaxValue", NpgsqlDbType.Text, "");
2000. cmd.Parameters.AddParameterWithValue("IsMaxValueIncluded", NpgsqlDbType.Boolean, false);
2001. cmd.Parameters.AddParameterWithValue("paramvalueId", NpgsqlDbType.Bigint, 0);
2003. for (var i = 0; i < _currentlyDisplayedReport.ParameterFields.Count; i++)
2004. {
2005. long paramvalueId = 0;
2006. var parameterField = _currentlyDisplayedReport.ParameterFields[i];
2007. if (parameterField.CurrentValues.Count == 0)
2008. continue;
2010. bool isList = parameterField.CurrentValues.Count > 1;
2011. cmd.Parameters.SetValue("ParameterName", parameterField.Name);
2013. cmd.CommandText = @"
2014. SELECT seq
2015. FROM crparametervalues
2016. WHERE (profileseq = @ProfileId)
2017. AND (parametername = @ParameterName)
2018. LIMIT 1;
2019. ";
2020. ob = cmd.ExecuteScalar();
2021. if (ob != null && ob.ToString() != "")
2022. {
2023. long.TryParse(ob.ToString(), out paramvalueId);
2024. }
2026. if (paramvalueId <= 0) //INSERT crparametervalues and crparametervaluelistitems
2027. {
2028. cmd.CommandText = @"
2029. INSERT INTO crparametervalues (profileseq, parametername, isvaluelist, singularvalue, minvalue, isminvalueincluded, maxvalue, ismaxvalueincluded)
2030. VALUES (@ProfileId, @ParameterName, @IsValueList, @SingularValue, @MinValue, @IsMinValueIncluded, @MaxValue, @IsMaxValueIncluded)
2031. RETURNING seq;
2032. ";
2033. }
2034. else //UPDATE crparametervalues and crparametervaluelistitems
2035. {
2036. cmd.Parameters.SetValue("paramvalueId", paramvalueId);
2037. cmd.CommandText = @"
2038. UPDATE crparametervalues
2039. SET isvaluelist = @IsValueList, singularvalue = @SingularValue, minvalue = @MinValue, isminvalueincluded = @IsMinValueIncluded, maxvalue = @MaxValue, ismaxvalueincluded = @IsMaxValueIncluded
2040. WHERE (seq = @paramvalueId)
2041. RETURNING seq;
2042. ";
2043. }
2045. if (!isList)
2046. {
2047. // Singular value
2048. cmd.Parameters.SetValue("IsValueList", isList);
2049. cmd.Parameters.SetValue("MinValue", 0);
2050. cmd.Parameters.SetValue("IsMinValueIncluded", true);
2051. cmd.Parameters.SetValue("MaxValue", 0);
2052. cmd.Parameters.SetValue("IsMaxValueIncluded", true);
2053. cmd.Parameters.SetValue("SingularValue", ((ParameterDiscreteValue)parameterField.CurrentValues[0]).Value);
2054. ob = cmd.ExecuteScalar();
2055. if (ob != null && ob.ToString() != "")
2056. {
2057. long.TryParse(ob.ToString(), out paramvalueId);
2058. }
2060. cmd.Parameters.SetValue("paramvalueId", paramvalueId);
2061. cmd.CommandText = @"
2062. DELETE FROM crparametervaluelistitems
2063. WHERE (parameterseq = @paramvalueId);
2064. ";
2065. cmd.ExecuteNonQuery();
2066. }
2067. else
2068. {
2069. // Value list
2070. cmd.Parameters.SetValue("IsValueList", isList);
2071. cmd.Parameters.SetValue("MinValue", 0);
2072. cmd.Parameters.SetValue("IsMinValueIncluded", false);
2073. cmd.Parameters.SetValue("MaxValue", 0);
2074. cmd.Parameters.SetValue("IsMaxValueIncluded", false);
2075. cmd.Parameters.SetValue("SingularValue", "");
2076. ob = cmd.ExecuteScalar();
2077. if (ob != null && ob.ToString() != "")
2078. {
2079. long.TryParse(ob.ToString(), out paramvalueId);
2080. }
2082. cmd.Parameters.SetValue("paramvalueId", paramvalueId);
2083. cmd.CommandText = @"
2084. DELETE FROM crparametervaluelistitems
2085. WHERE (parameterseq = @paramvalueId);
2086. ";
2087. cmd.ExecuteNonQuery();
2089. for (var j = 0; j < parameterField.CurrentValues.Count; j++)
2090. {
2091. cmd.CommandText = @"
2092. INSERT INTO crparametervaluelistitems (parameterseq, singularvalue, minvalue, isminvalueincluded, maxvalue, ismaxvalueincluded)
2093. VALUES (@paramvalueId, @SingularValue, @MinValue, @IsMinValueIncluded, @MaxValue, @IsMaxValueIncluded)
2094. ";
2095. cmd.Parameters.SetValue("paramvalueId", paramvalueId);
2096. cmd.Parameters.SetValue("MinValue", 0);
2097. cmd.Parameters.SetValue("IsMinValueIncluded", false);
2098. cmd.Parameters.SetValue("MaxValue", 0);
2099. cmd.Parameters.SetValue("IsMaxValueIncluded", false);
2100. cmd.Parameters.SetValue("SingularValue", ((ParameterDiscreteValue)parameterField.CurrentValues[j]).Value);
2101. cmd.ExecuteNonQuery();
2102. }
2103. }
2104. }
2105. }
2106. transaction.Commit();
2108. }
2109. catch (Exception ex)
2110. {
2111. transaction.Rollback();
2113. MessageBox.Show(
2114. "The following error occured while attempting to save report parameters:\n\n" + ex.Message,
2115. "Profile not saved", MessageBoxButton.OK, MessageBoxImage.Error, MessageBoxResult.OK);
2117. return;
2118. }
2120. }
2121. }
2123. _newParameterProfileName = null;
2124. }
2125. catch (Exception ex1)
2126. {
2127. Log.Exception(ex1);
2128. }
2129. }
2131. private void buttonOptions_Click(object sender, RoutedEventArgs e)
2132. {
2133. try
2134. {
2135. EditSelectedReport();
2136. }
2137. catch (Exception ex1)
2138. {
2139. Log.Exception(ex1);
2140. }
2141. }
2143. private void WebBrowserMain_OnNavigating(object sender, NavigatingCancelEventArgs e)
2144. {
2145. try
2146. {
2147. string scheme = null;
2149. try
2150. {
2151. scheme = e.Uri.Scheme;
2152. }
2153. catch
2154. {
2155. return;
2156. }
2158. if (scheme == "install")
2159. {
2160. using (var connection = _data.GetOpenConnection())
2161. {
2162. using (var cmd = connection.CreateCommand())
2163. {
2164. cmd.Parameters.AddParameterWithValue("ReleaseSeq", long.Parse(e.Uri.Host));
2165. cmd.CommandText = @"
2166. UPDATE crreportsetup SET isauthorized=true WHERE releaseseq=@ReleaseSeq
2167. ";
2168. cmd.ExecuteNonQuery();
2170. GetReports(connection);
2171. }
2172. }
2173. webBrowserMain.Navigate("http://localhost/AppStore?r=" + string.Join(",", _releaseSeqs));
2174. }
2175. else if (scheme == "uninstall")
2176. {
2177. using (var connection = _data.GetOpenConnection())
2178. {
2179. using (var cmd = connection.CreateCommand())
2180. {
2181. cmd.Parameters.AddParameterWithValue("ReleaseSeq", long.Parse(e.Uri.Host));
2182. cmd.CommandText = @"
2183. UPDATE crreportsetup SET isauthorized=false WHERE releaseseq=@ReleaseSeq
2184. ";
2185. cmd.ExecuteNonQuery();
2186. GetReports(connection);
2187. }
2188. }
2189. webBrowserMain.Navigate("http://localhost/AppStore?r=" + string.Join(",", _releaseSeqs));
2190. }
2191. else if (scheme != "http")
2192. {
2193. e.Cancel = true;
2194. }
2195. }
2196. catch (Exception ex1)
2197. {
2198. Log.Exception(ex1);
2199. }
2200. }
2202. private void Control_OnMouseDoubleClick(object sender, MouseButtonEventArgs e)
2203. {
2204. try
2205. {
2206. if (LeftPanel.Visibility == Visibility.Collapsed)
2207. {
2208. ColumnDefinitionLeft.Width = _leftPanelWidth;
2209. ColumnDefinitionLeft.MinWidth = 235;
2210. LeftPanel.Visibility = Visibility.Visible;
2211. RectangleCollapsed.Visibility = Visibility.Hidden;
2212. return;
2213. }
2214. _leftPanelWidth = ColumnDefinitionLeft.Width;
2215. ColumnDefinitionLeft.Width = new GridLength(0);
2216. ColumnDefinitionLeft.MinWidth = 0;
2217. LeftPanel.Visibility = Visibility.Collapsed;
2218. RectangleCollapsed.Visibility = Visibility.Visible;
2219. }
2220. catch (Exception ex1)
2221. {
2222. Log.Exception(ex1);
2223. }
2224. }
2226. private void TreeViewReports_OnMouseLeftButtonDown(object sender, MouseButtonEventArgs e)
2227. {
2228. try
2229. {
2230. var treeView = sender as TreeView;
2231. if (treeView != null && treeView.SelectedItem != null)
2232. {
2233. var item = (TreeViewItem)treeView.SelectedItem;
2234. item.IsSelected = false;
2235. treeView.Focus();
2236. }
2237. }
2238. catch (Exception ex1)
2239. {
2240. Log.Exception(ex1);
2241. }
2242. }
2244. private void TreeViewReports_OnPreviewMouseRightButtonDown(object sender, MouseButtonEventArgs e)
2245. {
2246. try
2247. {
2248. var treeViewItem = VisualUpwardSearch(e.OriginalSource as DependencyObject);
2250. if (treeViewItem == null)
2251. return;
2253. treeViewItem.Focus();
2254. e.Handled = true;
2255. }
2256. catch (Exception ex1)
2257. {
2258. Log.Exception(ex1);
2259. }
2260. }
2262. static TreeViewItem VisualUpwardSearch(DependencyObject source)
2263. {
2264. while (source != null && !(source is TreeViewItem))
2265. source = VisualTreeHelper.GetParent(source);
2267. return source as TreeViewItem;
2268. }
2270. private void buttonSubreportSetup_Click(object sender, RoutedEventArgs e)
2271. {
2272. try
2273. {
2274. var w = new SubreportWindow(_availableCategories, _data, _basePath);
2275. w.Owner = this;
2276. w.ShowDialog();
2277. }
2278. catch (Exception ex1)
2279. {
2280. Log.Exception(ex1);
2281. }
2282. }
2284. private void Focus_Attained(object sender, RoutedEventArgs e)
2285. {
2287. }
2289. private void btnPrint_Click(object sender, RoutedEventArgs e)
2290. {
2291. try
2292. {
2293. try
2294. {
2295. if (currentReportAlbum != null)
2296. {
2297. try
2298. {
2299. currentReportAlbum.PrintReport();
2300. }
2301. catch
2302. {
2303. ReportViewer.ViewerCore.PrintReport();
2304. }
2305. }
2306. else if (_currentlyDisplayedReport != null)
2307. {
2308. doPrint(_currentlyDisplayedReport);
2309. }
2310. }
2311. catch
2312. {
2313. if (_currentlyDisplayedReport != null)
2314. {
2315. doPrint(_currentlyDisplayedReport);
2316. }
2317. else if (currentReportAlbum != null)
2318. {
2319. currentReportAlbum.PrintReport();
2320. }
2321. }
2322. }
2323. catch (Exception ex1)
2324. {
2325. Log.Exception(ex1);
2326. }
2327. }
2329. private void doPrint(ReportDocument reportDocument)
2330. {
2331. using (System.Windows.Forms.PrintDialog dialog = new System.Windows.Forms.PrintDialog())
2332. {
2333. dialog.AllowCurrentPage = true;
2334. dialog.AllowSelection = true;
2335. dialog.AllowSomePages = true;
2336. dialog.AllowPrintToFile = true;
2337. if (dialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
2338. {
2339. reportDocument.PrintToPrinter(dialog.PrinterSettings, new System.Drawing.Printing.PageSettings(dialog.PrinterSettings), false);
2340. }
2341. }
2342. }
2343. }
2345. public class MyParameterType : ParameterDiscreteValue
2346. {
2347. public MyParameterType(int i)
2348. {
2349. Value = i;
2350. }
2352. public override string ToString()
2353. {
2354. return "five";
2355. }
2356. }
2357. }