using System;
using System.Text;
using MySql.Data;
using MySql.Data.MySqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;



namespace GestionHotel
{
    public static class Fonctions
    {
        private static String cs = @"server=localhost;userid=root;password=;database=gestionhotelentretien;charset=utf8";
        private static MySqlConnection conn = new MySqlConnection(cs);
     

        public static bool Connexion()
        {
            //Encoding.RegisterProvider(CodePagesEncodingProvider.Instance);
            conn.Open();
            if (conn.State == System.Data.ConnectionState.Open)
            {

                return true;
            }
            else
            {
                return false;
            }
        }
        public static bool Deconnexion()
        {
            conn.Close();
            return (conn.State == System.Data.ConnectionState.Closed);
        }
    }
}