Page MenuHomeDevCentral
Files F24894598

MainForm.cs
No OneTemporary
Actions

MainForm.cs
View Options

This document is not UTF8. It was detected as ISO-8859-1 (Latin 1) and converted to UTF8 for display.
using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using System.ServiceProcess;
using System.Text;
using System.IO;
namespace Sycorax.ControlCenter {
/// <summary>
/// Application Main form
/// </summary>
public partial class MainForm {
public MainForm () {
InitializeComponent();
//Autoupdate :: we need to initialize our ServiceController
sc = new ServiceController("SycoraxAutoUpdate");
//Config tab :: initializes the controls, reading options
RefreshOptionsArea();
}
/// <summary>
/// SycoraxAutoUpdate Service Controller
/// </summary>
private ServiceController sc;
/// <summary>
/// Indique si les options ont été modifiées
/// </summary>
private bool optionsHasBeenModified;
/// <summary>
/// Indique si les options ont été modifiées
/// </summary>
public bool OptionsHasBeenModified {
get {
return optionsHasBeenModified;
}
set {
//Si les options ont été modifiées, alors le bouton enregistrer est activé.
buttonEnregistrerOptions.Enabled = optionsHasBeenModified = value;
}
}
/// <summary>
/// Handles the Enter event of the tabPageAutoUpdate control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void tabPageAutoUpdate_Enter (object sender, EventArgs e) {
//Mise à jour de la zone du haut, càd du contrôleur de service
ProbeService();
}
/// <summary>
/// Vérifie l'état du service
/// </summary>
private void ProbeService () {
try {
switch (sc.Status) {
//Affichage de l'état dans labelStatutAutoUpdateServiceResult
//Les tags que nous définissons correspondent aux opérations
//attendues pour ces liens.
case ServiceControllerStatus.ContinuePending:
labelStatutAutoUpdateServiceResult.Text = "Reprise en cours";
linkLabelServicePauseContinue.Tag = "Pause";
linkLabelServicePlayStop.Tag = "Stop";
break;
case ServiceControllerStatus.Paused:
labelStatutAutoUpdateServiceResult.Text = "Pause";
linkLabelServicePauseContinue.Tag = "Continue";
linkLabelServicePlayStop.Tag = "Stop";
break;
case ServiceControllerStatus.PausePending:
labelStatutAutoUpdateServiceResult.Text = "Pause en cours";
linkLabelServicePauseContinue.Tag = "Continue";
linkLabelServicePlayStop.Tag = "Stop";
break;
case ServiceControllerStatus.Running:
labelStatutAutoUpdateServiceResult.Text = "Actif";
linkLabelServicePauseContinue.Tag = "Pause";
linkLabelServicePlayStop.Tag = "Stop";
break;
case ServiceControllerStatus.StartPending:
labelStatutAutoUpdateServiceResult.Text = "Lancement en cours";
linkLabelServicePauseContinue.Tag = "Pause";
linkLabelServicePlayStop.Tag = "Stop";
break;
case ServiceControllerStatus.Stopped:
labelStatutAutoUpdateServiceResult.Text = "Arrêté";
linkLabelServicePauseContinue.Tag = "";
linkLabelServicePlayStop.Tag = "Start";
break;
case ServiceControllerStatus.StopPending:
labelStatutAutoUpdateServiceResult.Text = "Arrêt en cours";
linkLabelServicePauseContinue.Tag = "";
linkLabelServicePlayStop.Tag = "Start";
break;
}
labelStatutAutoUpdateServiceResult.ForeColor = (sc.Status == ServiceControllerStatus.Running) ? Color.DarkGreen : SystemColors.ControlText;
//Mise à jour du texte des liens
UpdateServiceLinks();
} catch (Exception e) {
if (Program.options.DebugMode) {
PrintException(e);
}
labelAutoUpdateException.Text = e.Message;
//En cas d'erreur sur le service, les liens ne servent pas à grand chose
linkLabelServicePlayStop.Hide();
linkLabelServicePauseContinue.Hide();
}
}
/// <summary>
/// Updates the service links.
/// </summary>
private void UpdateServiceLinks () {
//Lien Start/Stop
//TODO : Lang
//Mise à jour du nom du lien
linkLabelServicePlayStop.Text = linkLabelServicePlayStop.Tag.ToString();
//Lien Pause/Continue
if (linkLabelServicePauseContinue.Tag.ToString() == "") {
//Pas de tag (le service étant à l'arrêt ou en cours d'arrêt), le lien disparaît.
linkLabelServicePauseContinue.Hide();
} else {
//On réaffiche éventuellement le tag
linkLabelServicePauseContinue.Show();
//TODO : Lang
//Mise à jour du nom du lien
linkLabelServicePauseContinue.Text = linkLabelServicePauseContinue.Tag.ToString();
}
}
/// <summary>
/// Prints an exception.
/// </summary>
/// <param name="e">The exception.</param>
private void PrintException (Exception e) {
//Affichage de l'exception dans textBoxException
StringBuilder sb = new StringBuilder();
sb.AppendLine(e.Message);
sb.AppendLine();
sb.AppendLine();
sb.AppendLine(e.StackTrace);
textBoxException.Text = sb.ToString();
//Si le tab n'était pas encore présent, affichons-le
if (!tabControlMain.Controls.Contains(tabPageDebug)) {
//On ajoute l'onglet debug à droite
this.tabControlMain.Controls.Add(tabPageDebug);
//On zappe dessus
//Attention : si l'on zappe systématiquement sur ce tab
//dés qu'une exception survient, il ne sera pas possible
//de voir correctement les autres onglets si l'exception
//se reproduit dés qu'on entre dans un de ceux-ci comme
//c'est par ex. le cas si le service n'est pas installé.
tabControlMain.SelectedTab = tabPageDebug;
}
}
/// <summary>
/// Handles the LinkClicked event of the linkLabelServicePlayStop control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void linkLabelServicePlayStop_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) {
try {
LinkLabel linkLabel = (LinkLabel)sender;
if (linkLabel.Tag.ToString() == "Play") {
//Démarrage du service
sc.Start();
} else {
//Arrêt du service
sc.Stop();
}
} catch (Exception ex) {
if (Program.options.DebugMode) {
PrintException(ex);
}
labelAutoUpdateException.Text = ex.Message;
return;
}
ProbeService();
}
/// <summary>
/// Handles the LinkClicked event of the linkLabelServicePause control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void linkLabelServicePause_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) {
LinkLabel linkLabel = (LinkLabel)sender;
//Pas de tag ? il ne se passe rien (n'est pas sensé arrivé grâce à UpdateServiceLinks)
if (linkLabel.Tag.ToString() == "") return;
try {
//Lisons le tag du lien pour déterminer le comportement à adopter (pause ou continue)
if (linkLabel.Tag.ToString() == "Pause") {
//Démarrage du service
sc.Pause();
} else {
//Arrêt du service
sc.Continue();
}
} catch (Exception ex) {
if (Program.options.DebugMode) {
PrintException(ex);
}
labelAutoUpdateException.Text = ex.Message;
return;
}
ProbeService();
}
/// <summary>
/// Handles the CheckedChanged event of the checkBoxDeleteTunesIfOrphans control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void checkBoxDeleteTunesIfOrphans_CheckedChanged (object sender, EventArgs e) {
CheckBox checkBox = (CheckBox)sender;
Program.options.DeleteTunesIfOrphans = checkBox.Checked;
OptionsHasBeenModified = true;
}
/// <summary>
/// Handles the CheckedChanged event of the checkBoxDebugMode control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void checkBoxDebugMode_CheckedChanged (object sender, EventArgs e) {
CheckBox checkBox = (CheckBox)sender;
Program.options.DebugMode = checkBox.Checked;
OptionsHasBeenModified = true;
}
/// <summary>
/// Handles the Click event of the buttonEnregistrerOptions control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void buttonEnregistrerOptions_Click (object sender, EventArgs e) {
SaveOptions();
}
/// <summary>
/// Saves the options.
/// </summary>
private void SaveOptions () {
try {
Program.options.Save(MainOptions.DefaultOptionsFile);
OptionsHasBeenModified = false;
} catch (Exception ex) {
if (Program.options.DebugMode) PrintException(ex);
if (MessageBox.Show(ex.Message, "Impossible de sauvegader les options.", MessageBoxButtons.RetryCancel, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Retry) {
//Ok, let's retry
SaveOptions();
}
}
}
private void checkedListBoxFolders_SelectedIndexChanged (object sender, EventArgs e) {
CheckedListBox checkedListBox = (CheckedListBox)sender;
//Activons le bouton suppression si au moins une case est sélectionnée
buttonDeleteSelectedFolders.Enabled = (checkedListBox.CheckedItems.Count > 0);
}
private void textBoxFolderToAdd_TextChanged (object sender, EventArgs e) {
TextBox textBox = (TextBox)sender;
//Activons le bouton suppression si il y a du texte que c'est un dossier existant
buttonAddFolder.Enabled = Directory.Exists(textBox.Text) || textBox.Text == "---";
}
private void buttonAddFolder_Click (object sender, EventArgs e) {
if (textBoxFolderToAdd.Text == "---") {
checkedListBoxFolders.Items.Clear();
Program.options.FoldersToWatch = new string[] { };
textBoxFolderToAdd.Clear();
} else {
if (!Directory.Exists(textBoxFolderToAdd.Text)) {
DialogResult result = MessageBox.Show("Le dossier " + textBoxFolderToAdd.Text + " n'existe pas, voulez-vous vraiment l'ajouter, au risque de compromettre le bon fonctionnement de l'indexation ?", "Dossier non existant", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (result != DialogResult.Yes) return;
}
AddFolder(textBoxFolderToAdd.Text);
}
}
private void AddFolder (string path) {
//Ajout dans la liste
checkedListBoxFolders.Items.Add(path, CheckState.Unchecked);
//On efface le texte de la textBox
textBoxFolderToAdd.Clear();
//On l'ajoute dans les options
Program.options.AddFolder(path);
}
private void buttonBrowse_Click (object sender, EventArgs e) {
FolderBrowserDialog dialog = new FolderBrowserDialog();
dialog.Description = "Sélectionnez le dossier à surveiller";
if (Directory.Exists(textBoxFolderToAdd.Text)) {
dialog.SelectedPath = textBoxFolderToAdd.Text;
}
dialog.ShowNewFolderButton = true;
if (dialog.ShowDialog() == DialogResult.OK) {
textBoxFolderToAdd.Text = dialog.SelectedPath;
}
}
private void buttonDeleteSelectedFolders_Click (object sender, EventArgs e) {
/*
* Instinctivement, le code suivant peut s'imposer :
*
* foreach (object o in checkedListBoxFolders.SelectedItems) {
* DelFolder(o.ToString());
* }
*
* Autrement dit :
*
* foreach (object o in checkedListBoxFolders.SelectedItems) {
* checkedListBoxFolders.Items.Remove(path);
* //...
* }
*
* Le souci est que nous modifions la liste des items de checkedListBoxFolders
* au fur et à mesure que nous parcourons la boucle foreach, ce qui provoquera
* une exception InvalidOperationOperation tout à fait justifiée.
*
* La solution est assez simple, il suffit de copier les items sélectionnées
* dans un tableau temporaire et de parcourir non pas notre liste d'items sé-
* lectionnés mais ce tableau où nous venons de les copier.
*/
//Copions les items sélectionnés dans un tableau
object[] itemsToDel = new object[checkedListBoxFolders.SelectedItems.Count];
checkedListBoxFolders.SelectedItems.CopyTo(itemsToDel, 0);
//Supprimons-les
foreach (object o in itemsToDel) {
DelFolder(o.ToString());
}
}
/// <summary>
/// Deletes the folder.
/// </summary>
/// <param name="path">The folder path.</param>
private void DelFolder (string path) {
//Ajout dans la liste
checkedListBoxFolders.Items.Remove(path);
//On le supprime dans les options
Program.options.DelFolder(path);
}
/// <summary>
/// Handles the Click event of the buttonRAZOptions control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void buttonRAZOptions_Click (object sender, EventArgs e) {
if (MessageBox.Show(
"Êtes-vous sûr de vouloir restaurer les préférences par défaut.\n\nSi vous répondez oui, votre liste de dossiers à surveiller sera perdue.",
"Remise à zéro des préférences",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2) == DialogResult.Yes
) {
//Ok, let's RAZ
Program.options.SetDefaults();
//Enregistrons directement
Program.options.Save();
//Hop on met à jour l'interface
RefreshOptionsArea();
}
}
#region Auto Update :: Manual auto update
/// <summary>
/// Handles the LinkClicked event of the linkInternalAutoUpdateUp control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void linkInternalAutoUpdateUp_LinkClicked (object sender, LinkLabelLinkClickedEventArgs e) {
try {
if (labelInternalAutoUpdateStatus.Text == "Off") {
//Start our internal auto update
if (Program.internalAutoUpdate == null) {
Program.internalAutoUpdate = new InternalAutoUpdate();
Program.databaseUpdate.LogEntry += new EventHandler<TimestampMessageEventArgs>(databaseUpdate_LogEntry);
}
Program.internalAutoUpdate.Enabled = true;
} else {
//Stop our interal auto update
Program.internalAutoUpdate.Enabled = false;
}
RefreshInternalAutoUpdateLinks();
} catch (Exception ex) {
if (Program.options.DebugMode) {
PrintException(ex);
}
return;
}
}
void databaseUpdate_LogEntry (object sender, MessageEventArgs e) {
textBoxLog.Text += DateTime.Now.ToLongTimeString();
textBoxLog.Text += Environment.NewLine;
}
public void RefreshInternalAutoUpdateLinks () {
if (Program.internalAutoUpdate == null || !Program.internalAutoUpdate.Enabled) {
//internal AutoUpdate off
labelInternalAutoUpdateStatus.Text = "Off";
linkInternalAutoUpdateUp.Text = "Démarrer";
} else {
//internal AutoUpdate on
labelInternalAutoUpdateStatus.Text = "On";
linkInternalAutoUpdateUp.Text = "Arrêter";
}
}
#endregion
#region Page Rebuild index
/// <summary>
/// Handles the Click event of the buttonStartRebuildIndex control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void buttonStartRebuildIndex_Click (object sender, EventArgs e) {
//If we don't have any folder watched, alert the user he's going to destroy index
if (Program.options.FoldersToWatch.Length == 0) {
DialogResult result = MessageBox.Show(
"Vous vous apprêtez à détruire l'intégralité de votre index.\n\nVous n'avez défini aucun dossier en vue d'une réindexation.\n\nConfirmez-vous cette ordre de totale destruction de l'index ?",
"Confirmation avant auto-destruction",
MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2
);
if (result == DialogResult.No) {
//No ? We cancel
return;
}
}
//Rebuild index
try {
RebuildIndex();
} catch (Exception ex) {
MessageBox.Show(
String.Format(
"L'index n'a pu être correctement regénéré.\n\nException : {0}\n\n{1}Nous vous invitons à signaler ce bug sur http://bugzilla.espace-win.org/",
ex.Message,
Program.options.DebugMode ? ex.StackTrace + "\n\n" : ""
),
"Erreur durant l'indexation", MessageBoxButtons.OK, MessageBoxIcon.Stop
);
}
}
/// <summary>
/// Rebuilds the index.
/// </summary>
private void RebuildIndex () {
//Start
buttonStartRebuildIndex.Enabled = false;
progressBarRebuild.Visible = true;
List<string> FilesToIndex = new List<string>();
//Let's go
foreach (string folder in Program.options.FoldersToWatch) {
//get the audio file contained in each folder to watch
FilesToIndex.AddRange(GetAudioFiles(folder, true));
}
//Now, we've to index all those file
if (Program.databaseUpdate == null) Program.databaseUpdate = new DatabaseUpdate(Program.options.ConnectionString);
Program.databaseUpdate.TruncateIndex();
for (int i = 0 ; i < FilesToIndex.Count ; i++) {
//Add file to index
Program.databaseUpdate.AddFile(FilesToIndex[i]);
//Update progress bar
progressBarRebuild.Value = (i + 1) * 100 / FilesToIndex.Count;
}
//End
buttonStartRebuildIndex.Enabled = true;
progressBarRebuild.Visible = false;
}
/// <summary>
/// Gets the audio files contained in specified folders.
/// </summary>
/// <param name="folder">The folder.</param>
/// <param name="recursive">if set to <c>true</c> get also audio files in subfolders.</param>
/// <returns>List of audio files</returns>
private List<string> GetAudioFiles (string folder, bool recursive) {
List<string> files = new List<string>();
foreach (string file in Directory.GetFiles(folder)) {
if (Program.options.isExtensionWatched(Path.GetExtension(file))) {
files.Add(file);
}
}
if (recursive) {
foreach (string subfolder in Directory.GetDirectories(folder)) {
files.AddRange(GetAudioFiles(subfolder, true));
}
}
return files;
}
#endregion
#region Page Config
/// <summary>
/// Handles the Enter event of the tabPageConfig control.
/// Set available options page and fill controls from our options
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void tabPageConfig_Enter (object sender, EventArgs e) {
listBoxOptions.Items.Clear();
listBoxOptions.Items.AddRange(new object[] {
GetPageOption(AvailablePageOption.General),
GetPageOption(AvailablePageOption.Directories),
GetPageOption(AvailablePageOption.Extensions),
GetPageOption(AvailablePageOption.ID3),
GetPageOption(AvailablePageOption.Database),
GetPageOption(AvailablePageOption.Queries),
});
}
/// <summary>
/// Met à jour la zone des options du tab AutoUpdate
/// </summary>
private void RefreshOptionsArea () {
//Page General
checkBoxDebugMode.Checked = Program.options.DebugMode;
checkBoxDeleteTunesIfOrphans.Checked = Program.options.DeleteTunesIfOrphans;
//Page Database
textBoxConnectionString.Text = Program.options.ConnectionString;
//Page Directories
checkedListBoxFolders.Items.AddRange(Program.options.FoldersToWatch);
//Page Extensions
//Page ID3
//Page Queries
}
/// <summary>
/// Handles the SelectedIndexChanged event of the listBoxOptions control.
/// Show the correct control in right area
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void listBoxOptions_SelectedIndexChanged (object sender, EventArgs e) {
ListBox listBox = (ListBox)sender;
//Clear current option control
splitContainer1.Panel2.Controls.Clear();
//Set the new control
PageOption pageOption = (PageOption)listBox.SelectedItem;
splitContainer1.Panel2.Controls.Add(pageOption.ControlToShow);
}
/// <summary>
/// Option page description
/// </summary>
private class PageOption {
/// <summary>
/// Initializes a new instance of the <see cref="T:PageOption"/> class.
/// </summary>
/// <param name="title">The title.</param>
/// <param name="controlToShow">The control to show.</param>
public PageOption (string title, Control controlToShow) {
Title = title;
ControlToShow = controlToShow;
}
/// <summary>
/// Initializes a new instance of the <see cref="T:PageOption"/> class.
/// </summary>
public PageOption () {
}
/// <summary>
/// Title of the option page
/// </summary>
public string Title;
/// <summary>
/// Control to show in the right area
/// </summary>
public Control ControlToShow;
/// <summary>
/// Returns the title of the option page.
/// </summary>
/// <returns>
/// A <see cref="T:System.String"></see> that represents the current <see cref="T:System.Object"></see>.
/// </returns>
public override string ToString () {
return Title;
}
}
/// <summary>
/// Options page
/// </summary>
private enum AvailablePageOption {
/// <summary>
/// Main options - Options générales
/// </summary>
General,
/// <summary>
/// Extensions
/// </summary>
Extensions,
/// <summary>
/// Directories to watch - Répertoires à surveiller
/// </summary>
Directories,
/// <summary>
/// ID3v1/ID3v2 tags
/// </summary>
ID3,
/// <summary>
/// Database (MySQL config)
/// </summary>
Database,
/// <summary>
/// SQL Queries - Requêtes SQL
/// </summary>
Queries
}
/// <summary>
/// Gets the page option informations.
/// </summary>
/// <param name="aPageOption">An available page option.</param>
/// <exception cref="T:System.ArgumentException">Throw if aPageOption is not defined</exception>
/// <returns>Instance of PageOption with correct title and control to show</returns>
private PageOption GetPageOption (AvailablePageOption aPageOption) {
PageOption pageOption = new PageOption();
#region switch définissant pageOption.Title et pageOption.ControlToShow
switch (aPageOption) {
case AvailablePageOption.Database:
pageOption.Title = "Serveur MySQL";
pageOption.ControlToShow = panelConfigDatabase;
break;
case AvailablePageOption.Directories:
pageOption.Title = "Dossiers à surveiller";
pageOption.ControlToShow = tableLayoutPanelConfigDirectories;
break;
case AvailablePageOption.Extensions:
pageOption.Title = "Extensions audio/vidéo";
pageOption.ControlToShow = labelNotYetDefinedPanel;
break;
case AvailablePageOption.General:
pageOption.Title = "Options générales";
pageOption.ControlToShow = panelConfigMainOptions;
break;
case AvailablePageOption.ID3:
pageOption.Title = "Tags ID3";
pageOption.ControlToShow = labelNotYetDefinedPanel;
break;
case AvailablePageOption.Queries:
pageOption.Title = "Requêtes SQL";
pageOption.ControlToShow = labelNotYetDefinedPanel;
break;
default:
throw new ArgumentException("This option page must be defined in MainForm.GetPageOption(aPageOption) method.");
}
#endregion
return pageOption;
}
#endregion
#region Page Config :: Paramètres MySQL
/// <summary>
/// Handles the Click event of the buttonApplyMySQLParameters control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void buttonApplyMySQLParameters_Click (object sender, EventArgs e) {
#region StringBuilder ConnectionString
StringBuilder sb = new StringBuilder();
//Host
if (textBoxMySQLHost.Text.Length == 0) {
textBoxMySQLHost.Text = "localhost";
}
sb.Append("Server=");
sb.Append(textBoxMySQLHost.Text);
//Port
if (textBoxMySQLPort.Text.Length > 0) {
//TODO : check if parameter name Port is correct
sb.Append(";Port=");
sb.Append(textBoxMySQLPort.Text);
}
//Login
if (textBoxMySQLLogin.Text.Length == 0) {
textBoxMySQLLogin.Text = "root";
}
sb.Append(";Uid=");
sb.Append(textBoxMySQLLogin.Text);
//Pass
if (textBoxMySQLPassword.Text.Length > 0) {
sb.Append(";Pwd=");
sb.Append(textBoxMySQLPassword.Text);
}
//Database
sb.Append(";Database=");
sb.Append(textBoxMySQLDatabase.Text);
#endregion
//Ok, our string is built, let's apply it
textBoxConnectionString.Text = Program.options.ConnectionString = sb.ToString();
//If database is omitted, user must append the string. Let's notice him
if (textBoxMySQLDatabase.Text.Length == 0) {
MessageBox.Show(
"La chaîne de connexion se termine actuellement par DataBase=\n\nAjoutez le nom de la base de données contenant l'index.",
"ConnectionString incomplète",
MessageBoxButtons.OK,
MessageBoxIcon.Warning
);
}
}
/// <summary>
/// Handles the TextChanged event of the textBoxConnectionString control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void textBoxConnectionString_TextChanged (object sender, EventArgs e) {
TextBox textBox = (TextBox)sender;
Program.options.ConnectionString = textBox.Text;
OptionsHasBeenModified = true;
}
/// <summary>
/// Handles the Click event of the buttonProbeConnect control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param>
private void buttonProbeConnect_Click (object sender, EventArgs e) {
ProbeMySqlConnectionForm frm = new ProbeMySqlConnectionForm(Program.options.ConnectionString);
frm.ShowDialog();
}
#endregion
}
}

File Metadata

Mime Type
text/plain
Expires
Wed, Mar 18, 12:59 (1 d, 16 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3539900
Default Alt Text
MainForm.cs (26 KB)

Event Timeline

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator