/// <summary>
/// Constructeur du service (initialisation des composants et de la connexion)
/// </summary>
public ServiceGSB()
{
InitializeComponent();
connect = ConnexionSql.getInstance("10.30.0.113", "DUBOST", "DUBOST", "mdubost");
/* +---------+-------------+-----------------+
| | Lycée | Maison |
+---------+-------------+-----------------+
| Adresse | 10.30.0.113 | slam.siolms.pro |
+---------+-------------+-----------------+ */
}
/// <summary>
/// Affichage du formulaire et initialisation de la connexion
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form1_Load(object sender, EventArgs e)
{
connect = ConnexionSql.getInstance("10.30.0.113", "DUBOST", "DUBOST", "mdubost");
/* +---------+-------------+-----------------+
| | Lycée | Maison |
+---------+-------------+-----------------+
| Adresse | 10.30.0.113 | slam.siolms.pro |
+---------+-------------+-----------------+ */
afficher();
}
/// <summary>
/// Méthode de création d'une instance de connexion si elle n'existe pas (Singleton)
/// </summary>
/// <param name="unProvider"></param>
/// <param name="uneDataBase"></param>
/// <param name="unUid"></param>
/// <param name="unMdp"></param>
/// <returns></returns>
public static ConnexionSql getInstance(string unProvider, string uneDataBase, string unUid, string unMdp)
{
lock ((mylock))
{
try
{
if (connection == null)
{
connection = new ConnexionSql(unProvider, uneDataBase, unUid, unMdp);
}
}
catch (Exception emp)
{
MessageBox.Show(emp.Message);
}
return(connection);
}
}