public ProcessDAL()
{
// Create a Settings object with all Defaults
DALSettingsSection dss = new DALSettingsSection();
Settings = new DALSettings(dss);
}
private void MenuItem_Click(object sender, RoutedEventArgs e)
{
lblStatus.Text = "Specify new config";
// Create OpenFileDialog
Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog();
// Set filter for file extension and default file extension
dlg.DefaultExt = ".config";
dlg.Filter = "Config files (*.config)|*.config";
// Display OpenFileDialog by calling ShowDialog method
Nullable <bool> result = dlg.ShowDialog();
// Get the selected file name and display in a TextBox
if (result == true)
{
// Open document
string filename = dlg.FileName;
ExeConfigurationFileMap fm = new ExeConfigurationFileMap();
fm.ExeConfigFilename = filename;
var conf = ConfigurationManager.OpenMappedExeConfiguration(fm, ConfigurationUserLevel.None);
DALSettingsSection dss = (DALSettingsSection)conf.Sections["dalSettings"];
DALSettings settings = new DALSettings(dss);
this.DataContext = settings;
lblStatus.Text = "New Config Loaded";
return;
}
lblStatus.Text = "Ready";
}
static void Main(string[] args)
{
Console.WriteLine("Simple test of constructing the objects...");
DALSettingsSection dss = null;
var config = ConfigurationManager.OpenExeConfiguration(null);
dss = (DALSettingsSection)config.Sections["dalSettings"];
Console.WriteLine("Looking for templates in this folder: " + dss.BaseTemplateFolder);
DALSettings settings = new DALSettings(dss);
ProcessDAL pd = new ProcessDAL(settings);
if (pd.GenerateAllFiles())
{
Console.WriteLine("Files generated successfully.");
Console.WriteLine("Please check the " + dss.BaseOutputFolder + " folder for results.");
}
else
{
Console.WriteLine("There was some sort of processing error.");
Console.WriteLine("Check the log files.");
}
Console.Write("End of test. Press Enter...");
Console.ReadLine();
}
/// <summary>
/// Save the data
/// </summary>
private void _SaveData()
{
if (this.rbSQL.Checked)
{
this._cfg.Server = this.txtServer.Text.Trim();
this._cfg.Database = this.txtDatabase.Text.Trim();
this._cfg.User = this.txtUsername.Text.Trim();
this._cfg.Password = this.txtPassword.Text.Trim();
this._cfg.IntegratedSecurity = false;
}
else
{
this._cfg = null;
this._cfg = new DALSettings(
ProviderType.MSSql2005,
this.txtServer.Text.Trim(),
this.txtDatabase.Text.Trim()
);
}
try {
Configuration.SaveConnectionString(this._cfg.ConnectionString);
}
catch (Exception) {
}
}
// -------------------------------------------------------
// PRIVATE MEMBERS
// -------------------------------------------------------
/// <summary>
/// Load the data
/// </summary>
private void _LoadData()
{
this._cfg = UdlParser.ParseConnectionString(
Configuration.ConnectionString
);
if (this._cfg.IsWindowsAuthentication)
{
this.rbWindows.Checked = true;
this.rbSQL.Checked = false;
this.txtServer.Enabled = true;
this.txtDatabase.Enabled = true;
this.txtUsername.Enabled = false;
this.txtPassword.Enabled = false;
this.txtServer.Text = this._cfg.Server;
this.txtDatabase.Text = this._cfg.Database;
}
else
{
this.rbWindows.Checked = false;
this.rbSQL.Checked = true;
this.txtServer.Enabled = true;
this.txtDatabase.Enabled = true;
this.txtUsername.Enabled = true;
this.txtPassword.Enabled = true;
this.txtServer.Text = this._cfg.Server;
this.txtDatabase.Text = this._cfg.Database;
this.txtUsername.Text = this._cfg.User;
this.txtPassword.Text = this._cfg.Password;
}
}
void worker_DoWork(object sender, DoWorkEventArgs e)
{
DALSettingsSection sect = e.Argument as DALSettingsSection;
DALSettings settings = new DALSettings(sect);
ProcessDAL pd = new ProcessDAL(settings);
e.Result = pd.GenerateAllFiles();
}
public void SetupObjects()
{
// Read the settings from the config file.
// Assume "App" file exists in the output folder
var config = ConfigurationManager.OpenExeConfiguration(".\\App");
_dssConfigured = (DALSettingsSection)config.Sections["dalSettings"];
_settingsConfigured = new DALSettings(_dssConfigured);
_dssDefault = new DALSettingsSection();
_settingsDefault = new DALSettings(_dssDefault);
}
/// <summary>
/// Initializes a new instance of the <see cref="WikipediaParser"/> class.
/// </summary>
/// <param name="connectionString">The connection string.</param>
public WikipediaParser(string connectionString)
{
if(connectionString == null
|| connectionString.Trim() == "") {
throw new ArgumentNullException(
"connectionString",
"The connectionString parameter cannot be null."
);
}
this._cfg = UdlParser.ParseConnectionString(connectionString);
this._db = new DAL(this._cfg);
this._dh = new DataHandler(connectionString);
this._sh = new StaticHandler(connectionString);
}
private void LoadSettingsSection()
{
DALSettingsSection dss = null;
var config = ConfigurationManager.OpenExeConfiguration(null);
dss = (DALSettingsSection)config.Sections["dalSettings"];
Console.WriteLine("Looking for templates in this folder: " + dss.BaseTemplateFolder);
DALSettings settings = new DALSettings(dss);
this.DataContext = settings;
ConfigureWorkerThread();
lblStatus.Text = "Ready";
}
/// <summary>
/// Initializes a new instance of the <see cref="WikipediaParser"/> class.
/// </summary>
/// <param name="connectionString">The connection string.</param>
public WikipediaParser(string connectionString)
{
if (connectionString == null ||
connectionString.Trim() == "")
{
throw new ArgumentNullException(
"connectionString",
"The connectionString parameter cannot be null."
);
}
this._cfg = UdlParser.ParseConnectionString(connectionString);
this._db = new DAL(this._cfg);
this._dh = new DataHandler(connectionString);
this._sh = new StaticHandler(connectionString);
}
/// <summary>
/// Load the file
/// </summary>
/// <exception cref="FileNotFoundException">If the file was not found or is not a file with the Excel2003 format.</exception>
/// <returns></returns>
public bool LoadFile()
{
if (!File.Exists(this._filename))
{
throw new FileNotFoundException(
"The file [" + this._filename + "] does not exist or is not a file with the Microsoft Excel 2003 format.",
this._filename
);
}
this._cfg = new DALSettings(
ProviderType.OleDb,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this._filename + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";"
);
this._db = new DAL(this._cfg);
return(true);
}
// ---------------------------------------------------
// CONSTRUCTORS
// ---------------------------------------------------
/// <summary>
/// Default Ctor
/// </summary>
/// <param name="connectionString"></param>
/// <param name="filename">The filename including the path of the spreadsheet file.</param>
/// <exception cref="ArgumentNullException">If the connectionString or filename parameter is null or empty.</exception>
public OpenDocumentImporter(string connectionString, string filename)
{
if(connectionString == null
|| connectionString.Trim() == "") {
throw new ArgumentNullException(
"connectionString",
"The connectionString parameter canot be null."
);
}
if(filename == null
|| filename.Trim() == "") {
throw new ArgumentNullException(
"filename",
"The filename parameter canot be null."
);
}
this._filename = filename;
this._cfg = UdlParser.ParseConnectionString(connectionString);
this._db = new DAL(this._cfg);
this._dh = new DataHandler(connectionString);
}
// -------------------------------------------------------
// PRIVATE MEMBERS
// -------------------------------------------------------
/// <summary>
/// Load the data
/// </summary>
private void _LoadData()
{
this._cfg = UdlParser.ParseConnectionString(
Configuration.ConnectionString
);
if(this._cfg.IsWindowsAuthentication) {
this.rbWindows.Checked = true;
this.rbSQL.Checked = false;
this.txtServer.Enabled = true;
this.txtDatabase.Enabled = true;
this.txtUsername.Enabled = false;
this.txtPassword.Enabled = false;
this.txtServer.Text = this._cfg.Server;
this.txtDatabase.Text = this._cfg.Database;
}
else {
this.rbWindows.Checked = false;
this.rbSQL.Checked = true;
this.txtServer.Enabled = true;
this.txtDatabase.Enabled = true;
this.txtUsername.Enabled = true;
this.txtPassword.Enabled = true;
this.txtServer.Text = this._cfg.Server;
this.txtDatabase.Text = this._cfg.Database;
this.txtUsername.Text = this._cfg.User;
this.txtPassword.Text = this._cfg.Password;
}
}
/// <summary>
/// Load the file
/// </summary>
/// <exception cref="FileNotFoundException">If the file was not found or is not a file with the Excel2003 format.</exception>
/// <returns></returns>
public bool LoadFile()
{
if(!File.Exists(this._filename)) {
throw new FileNotFoundException(
"The file [" + this._filename + "] does not exist or is not a file with the Microsoft Excel 2003 format.",
this._filename
);
}
this._cfg = new DALSettings(
ProviderType.OleDb,
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + this._filename + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";"
);
this._db = new DAL(this._cfg);
return true;
}
// -------------------------------------------------------
// CONSTRUCTORS
// -------------------------------------------------------
/// <summary>
/// Default constructor
/// </summary>
/// <param name="connectionString"></param>
public StaticHandler(string connectionString)
{
this._cfg = UdlParser.ParseConnectionString(connectionString);
this._db = new DAL(this._cfg);
}
public ProcessDAL(DALSettings settings)
{
this.Settings = settings;
}
// -------------------------------------------------------
// CONSTRUCTORS
// -------------------------------------------------------
/// <summary>
/// Default constructor
/// </summary>
/// <param name="connectionString"></param>
public StaticHandler(string connectionString)
{
this._cfg = UdlParser.ParseConnectionString(connectionString);
this._db = new DAL(this._cfg);
}
private IdentityEFPersistenceBuilder(IConfiguration configuration)
{
_setting = DALSettings.GetSection(configuration ?? throw new DataAccessTierException(nameof(configuration)));
}
/// <summary>
/// Save the data
/// </summary>
private void _SaveData()
{
if(this.rbSQL.Checked) {
this._cfg.Server = this.txtServer.Text.Trim();
this._cfg.Database = this.txtDatabase.Text.Trim();
this._cfg.User = this.txtUsername.Text.Trim();
this._cfg.Password = this.txtPassword.Text.Trim();
this._cfg.IntegratedSecurity = false;
}
else {
this._cfg = null;
this._cfg = new DALSettings(
ProviderType.MSSql2005,
this.txtServer.Text.Trim(),
this.txtDatabase.Text.Trim()
);
}
try {
Configuration.SaveConnectionString(this._cfg.ConnectionString);
}
catch(Exception) {
}
}