public static bool CreateServeur(Serveur serveur, RegistryKey Nkey)
{
try
{
string path = chemin + Constantes.FILE_SEPARATOR + serveur.Adresse;
RegistryKey valKey = Nkey.OpenSubKey(@path, true);
if (valKey == null)
{
Nkey.CreateSubKey(@path);
valKey = Nkey.OpenSubKey(@path, true);
}
valKey.SetValue("adresse", serveur.Adresse);
valKey.SetValue("port", serveur.Port);
valKey.SetValue("database", serveur.Database);
valKey.SetValue("user", serveur.User);
valKey.SetValue("password", serveur.Password);
valKey.SetValue("date_debut", serveur.DateDebut.ToString("dd-MM-yyyy"));
}
catch (Exception e)
{
Messages.Exception("LiaisonDAO (getCreateServeur)", e);
return(false);
}
finally
{
Nkey.Close();
}
return(true);
}
public static Serveur ReturnServeur(string chemin, RegistryKey Nkey)
{
try
{
Serveur serveur = new Serveur();
RegistryKey valKey = Nkey.OpenSubKey(@chemin, true);
if (valKey != null)
{
serveur.Adresse = (string)(valKey.GetValue("adresse") != null ? valKey.GetValue("adresse") : "");
serveur.Port = Convert.ToInt32(valKey.GetValue("port") != null ? valKey.GetValue("port") : 0);
serveur.Database = (string)(valKey.GetValue("database") != null ? valKey.GetValue("database") : "");
serveur.User = (string)(valKey.GetValue("user") != null ? valKey.GetValue("user") : "");
serveur.Password = (string)(valKey.GetValue("password") != null ? valKey.GetValue("password") : "");
serveur.DateDebut = valKey.GetValue("date_debut") != null?Convert.ToDateTime(valKey.GetValue("date_debut")) : DateTime.Now.AddDays(-20);
valKey.Close();
return(serveur);
}
return(null);
}
catch (Exception e)
{
Messages.Exception("LiaisonDAO (getReturnServeur)", e);
return(null);
}
finally
{
Nkey.Close();
}
}
public static List <Serveur> ReturnServeur(RegistryKey Nkey)
{
try
{
List <Serveur> serveurs = new List <Serveur>();
RegistryKey valKey = Nkey.OpenSubKey(@chemin, true);
if (valKey != null ? valKey.GetSubKeyNames().Length > 0 : false)
{
Serveur serveur = null;
foreach (string name in valKey.GetSubKeyNames())
{
serveur = ReturnServeur(chemin + Constantes.FILE_SEPARATOR + name, Nkey);
if (serveur != null)
{
serveurs.Add(serveur);
}
}
}
return(serveurs);
}
catch (Exception e)
{
Messages.Exception("LiaisonDAO (getReturnServeur)", e);
return(null);
}
finally
{
Nkey.Close();
}
}
public void Test_GetRangUn()
{
//Arrange
// Rang 1
Serveur Serveur_Rang1 = new Serveur("Dupont", "Lucas");
ChefRang CR_Rang1 = new ChefRang("Pascal", "Henry");
Table[] Liste_Rang1 = new Table[3];
Rang Expected_Rang = new Rang(Serveur_Rang1, CR_Rang1, Liste_Rang1);
//Rang2
Serveur Serveur_Rang2 = Serveur_Rang1;
ChefRang ChefRang_Rang2 = CR_Rang1;
Table[] Liste_Rang2 = Liste_Rang1;
Rang Rang2 = new Rang(Serveur_Rang2, ChefRang_Rang2, Liste_Rang2);
Carre Carre = new Carre(Expected_Rang, Rang2);
//Action
Rang Actual_Rang = Carre.GetRangUn();
//Assert
Assert.AreEqual(Expected_Rang, Actual_Rang);
}
private void OnCreateMouseClick(object sender, MouseClickEventArgs e)
{
if (box[0].Text().Length > 0 && box[1].Text().Length > 0)
{
name = box[1].Text();
try
{
port = Convert.ToInt32(box[0].Text());
StartButton.MouseClick += OnStartMouseClick;
createButton.MouseClick -= OnCreateMouseClick;
isCreate = true;
box[0].IsSelect = false;
box[1].IsSelect = false;
serveur = new Serveur("test", port, 100);
serveur.Start();
localClient = new Client(name, true);
localClient.Connect("127.0.0.1", port);
localClient.SendData();
localClient.StartReadThread();
//localClient.StartWaitStart();
box.Add(new TextBox(new Vector2(Bounds.X + 20, box[0].Bound.Bottom + 10), 20, 10,
TexturesManager.Menu, Color.Blue, Color.Red));
}
catch (Exception)
{
box[0].RemoveAll();
}
}
}
public void TestMethod1()
{
var groupe1 = new GroupeClient()
{
Vin = true, Eau = true
};
var serveur1 = new Serveur();
groupe1.AttachServeur(serveur1);
Assert.AreEqual(groupe1.PainCorbeille, 3);
//Assert.AreEqual(groupe1.Vin, true);
//Assert.AreEqual(groupe1.Eau, true);
groupe1.PainCorbeille = 0;
groupe1.Vin = false;
Assert.AreEqual(groupe1.PainCorbeille, 1);
Assert.AreEqual(groupe1.Vin, true);
//Assert.AreEqual(groupe1.Eau, true);
}
public static Serveur Insert(Serveur myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("INSERT INTO `Serveur` ");
mySql.Append("(`libelle`, `ipLocale`, ");
mySql.Append("`ipPublique`, `cheminInfosMonitoring` )");
mySql.Append(" VALUES ");
mySql.Append("(@libelle, @ipLocale, ");
mySql.Append("@ipPublique, @cheminInfosMonitoring );");
mySql.Append("SELECT LAST_INSERT_ID(); ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myCommand.Parameters.AddWithValue("@ipLocale", myItem.ipLocale);
myCommand.Parameters.AddWithValue("@ipPublique", myItem.ipPublique);
myCommand.Parameters.AddWithValue("@cheminInfosMonitoring", myItem.cheminInfosMonitoring);
myConnection.Open();
myItem.id = iZyMySQL.GetIntFromDBInt(myCommand.ExecuteScalar());
myConnection.Close();
}
return myItem;
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
int res = 0;
int nbTable = int.Parse(txtNum.Text);
ComboBoxItem selecteditem = (ComboBoxItem)(cmbClient.SelectedValue);
string nServeur = (string)(selecteditem.Content);
ServeurDAO daos = new ServeurDAO();
Serveur s = new Serveur();
s = daos.getByName(nServeur);
int idd = 1;
Commande c = new Commande(id, nbTable, s.IdServeur, idd, DateTime.Now);
try
{
res = cdao.updateCommande(c, id);
if (res == 0)
{
MessageBox.Show("Update non effectue");
}
else
{
MessageBox.Show("Update effectue");
}
}
catch (Exception ex)
{
throw ex;
}
}
private void btnValider_Click(object sender, RoutedEventArgs e)
{
if (platCmd.Items.Count == 0 || lstArticlesCmd.Count == 0 || cmbServ.SelectedIndex == -1 || cmbTable.SelectedIndex == -1 || cmbServ.Text == "Serveur" || cmbTable.Text == "Table")
{
MessageBox.Show("vous devez renseigner tous les champs! ", "Erreur", MessageBoxButton.OK, MessageBoxImage.Stop);
return;
}
else
{
int NumTb = int.Parse(cmbTable.Text.Substring(6));
ServeurDAO daos = new ServeurDAO();
Serveur s = new Serveur();
s = daos.getByName(cmbServ.Text);
int idserv = s.IdServeur;
tobeAdded = new Commande(0, NumTb, idserv, 1, DateTime.Now);
if (daoc.addMultipleArticlesInOneC(lstArticlesCmd, tobeAdded) == 1)
{
MessageBox.Show("inséré");
List <Commande> lstCom = new List <Commande>();
lstCom = daoc.getAll();
dataGrid.DataContext = lstCom;
}
else
{
MessageBox.Show("la table est occupée !");
return;
}
dataGridVente.DataContext = dao.historiqueArticle();
this.PerformRefresh();
}
}
public override void Update(GameTime gameTime)
{
if (firstTime)
{
FondSonore.PlayDefeat();
firstTime = false;
}
mouseRec = new Rectangle(mouse.X, mouse.Y, 5, 5);
if (mouse.LeftButton == ButtonState.Pressed && oldMouse.LeftButton == ButtonState.Released)
{
if (mouseRec.Intersects(boutonQuitter))
{
// Deconnecte du reseau
if (Serveur.clients.Count > 0) // Si on etait le serveur
{
Serveur.Shutdown();
}
if (Client.client != null) // Si on etait un client
{
Client.client.Close();
}
SceneHandler.ResetGameplay();
CrystalGate.FondSonore.Stop();
SceneHandler.gameState = GameState.MainMenu;
}
}
}
private void Init()
{
string etatServeur;
List <Serveur> desServeur;
desServeur = Serveur.GetServeur();
foreach (Serveur s in desServeur)
{
if (s.idServeur != 0)
{
ListViewItem LServeur;
if (s.actif == true)
{
etatServeur = "Actif";
}
else
{
etatServeur = "NonActif";
}
LServeur = new ListViewItem(new String[] { s.idServeur.ToString(), s.nomServeur, s.prenomServeur, etatServeur });
lv_Serveur.Items.Add(LServeur);
}
}
}
public static bool getCreateServeur(Serveur serveur)
{
RegistryKey Nkey = Registry.CurrentUser;
try
{
RegistryKey valKey = Nkey.OpenSubKey(@chemin, true);
if (valKey == null)
{
Nkey.CreateSubKey(@chemin);
valKey = Nkey.OpenSubKey(@chemin, true);
}
valKey.SetValue("adresse", serveur.Adresse);
valKey.SetValue("port", serveur.Port);
valKey.SetValue("database", serveur.Database);
valKey.SetValue("user", serveur.User);
valKey.SetValue("password", serveur.Password);
}
catch (Exception e)
{
Messages.Exception(e);
return(false);
}
finally
{
Nkey.Close();
}
return(true);
}
public static List <Serveur> FindAll()
{
Serveur myItem = null;
List <Serveur> listItem = new List <Serveur>();
StringBuilder mySql = new StringBuilder();
mySql.Append("SELECT ");
mySql.Append(GetSelectFields() + " ");
mySql.Append("FROM `Serveur` serveur ");
mySql.Append("WHERE 1 ");
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myConnection.Open();
using (MySqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
while (myReader.Read())
{
myItem = LoadADO(myReader);
listItem.Add(myItem);
}
}
myReader.Close();
}
myConnection.Close();
}
return(listItem);
}
public static bool CreateServeur(Serveur serveur, RegistryKey Nkey)
{
try
{
RegistryKey valKey = Nkey.OpenSubKey(@chemin, true);
if (valKey == null)
{
Nkey.CreateSubKey(@chemin, RegistryKeyPermissionCheck.Default, Utils.RegistrySecurity());
valKey = Nkey.OpenSubKey(@chemin, true);
}
valKey.SetValue("adresse", serveur.Adresse);
valKey.SetValue("port", serveur.Port);
valKey.SetValue("database", serveur.Database);
valKey.SetValue("user", serveur.User);
valKey.SetValue("password", serveur.Password);
}
catch (Exception e)
{
Messages.Exception("ServeurDAO (CreateServeur)", e);
return(false);
}
finally
{
Nkey.Close();
}
return(true);
}
public static Serveur ReturnServeur(RegistryKey Nkey)
{
try
{
Serveur serveur = new Serveur();
RegistryKey valKey = Nkey.OpenSubKey(@chemin, false);
if (valKey == null)
{
serveur = Serveur.Default();
CreateServeur(serveur);
}
else
{
serveur.Adresse = (string)(valKey.GetValue("adresse") != null ? valKey.GetValue("adresse") : "");
serveur.Port = Convert.ToInt32(valKey.GetValue("port") != null ? valKey.GetValue("port") : 0);
serveur.Database = (string)(valKey.GetValue("database") != null ? valKey.GetValue("database") : "");
serveur.User = (string)(valKey.GetValue("user") != null ? valKey.GetValue("user") : "");
serveur.Password = (string)(valKey.GetValue("password") != null ? valKey.GetValue("password") : "");
valKey.Close();
}
return(serveur);
}
catch (Exception e)
{
Messages.Exception("ServeurDAO (ReturnServeur)", e);
return(null);
}
finally
{
Nkey.Close();
}
}
public async Task <ActionResult <Serveur> > PostServeur(Serveur serveur)
{
_context.Serveurs.Add(serveur);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetServeur", new { id = serveur.Id }, serveur));
}
static void start()
{
Licence.createLicence();
if (Licence.verifyLicence())
{
if (!Utils.verifyParametre())
{
if (!ServeurBLL.CreateServeur(Serveur.getServeurDefault()))
{
return;
}
}
if (Connexion.isConnection())
{
new Acces();
new Form_Parent().Show();
//new Form_Login().Show();
Application.Run();
}
else
{
if (Database.createDb())
{
new Acces();
new Form_Parent().Show();
//new Form_Login().Show();
Application.Run();
}
}
}
else
{
Messages.ShowErreur("Vous devez activer votre compte");
}
}
public async Task <IActionResult> PutServeur(int id, Serveur serveur)
{
if (id != serveur.Id)
{
return(BadRequest());
}
_context.Entry(serveur).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ServeurExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public static Serveur Load(int id)
{
Serveur myItem = null;
StringBuilder mySql = new StringBuilder();
mySql.Append("SELECT ");
mySql.Append(GetSelectFields() + " ");
mySql.Append("FROM `Serveur` serveur ");
mySql.Append("WHERE `id` = @id ");
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@id", id);
myConnection.Open();
using (MySqlDataReader myReader = myCommand.ExecuteReader())
{
if (myReader.HasRows)
{
myReader.Read();
myItem = LoadADO(myReader);
}
myReader.Close();
}
myConnection.Close();
}
return(myItem);
}
public static Serveur Update(Serveur myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("UPDATE `Serveur` SET ");
mySql.Append("`libelle` = @libelle, ");
mySql.Append("`ipLocale` = @ipLocale, ");
mySql.Append("`ipPublique` = @ipPublique, ");
mySql.Append("`cheminInfosMonitoring` = @cheminInfosMonitoring ");
mySql.Append("WHERE `id` = @id ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@id", myItem.id);
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myCommand.Parameters.AddWithValue("@ipLocale", myItem.ipLocale);
myCommand.Parameters.AddWithValue("@ipPublique", myItem.ipPublique);
myCommand.Parameters.AddWithValue("@cheminInfosMonitoring", myItem.cheminInfosMonitoring);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
return(myItem);
}
public static Serveur Insert(Serveur myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("INSERT INTO `Serveur` ");
mySql.Append("(`libelle`, `ipLocale`, ");
mySql.Append("`ipPublique`, `cheminInfosMonitoring` )");
mySql.Append(" VALUES ");
mySql.Append("(@libelle, @ipLocale, ");
mySql.Append("@ipPublique, @cheminInfosMonitoring );");
mySql.Append("SELECT LAST_INSERT_ID(); ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myCommand.Parameters.AddWithValue("@ipLocale", myItem.ipLocale);
myCommand.Parameters.AddWithValue("@ipPublique", myItem.ipPublique);
myCommand.Parameters.AddWithValue("@cheminInfosMonitoring", myItem.cheminInfosMonitoring);
myConnection.Open();
myItem.id = iZyMySQL.GetIntFromDBInt(myCommand.ExecuteScalar());
myConnection.Close();
}
return(myItem);
}
private void PopulateServeur(Serveur s)
{
txt_adresse.Text = s.Adresse;
txt_database.Text = s.Database;
txt_password.Text = s.Password;
txt_port.Text = s.Port.ToString();
txt_users.Text = s.User;
}
public static void newThreadServeur()
{
while (Thread.CurrentThread.IsAlive)
{
Serveur serveur = new Serveur();
//serveur.debarasse();
}
}
public ChefMaster()
{
//Instanciation personnelle
MH = MaitreHotel.GetInstance("Maitre", "Hotel");
CS = CommisSalle.GetInstance("Commis", "Salle");
CR_1 = new ChefRang("CR", "1");
CR_2 = new ChefRang("CR", "2");
CR_3 = new ChefRang("CR", "3");
CR_4 = new ChefRang("CR", "4");
SR_1 = new Serveur("SR", "1");
SR_2 = new Serveur("SR", "2");
SR_3 = new Serveur("SR", "3");
SR_4 = new Serveur("SR", "4");
//Instanciation Salle
TB_Rang1 = new Table[4];
TB_Rang1[0] = Table_4_Rang1_1 = new Table(4, 0, 1);
TB_Rang1[1] = Table_4_Rang1_2 = new Table(4, 0, 2);
TB_Rang1[2] = Table_4_Rang1_3 = new Table(4, 0, 3);
TB_Rang1[3] = Table_4_Rang1_4 = new Table(4, 0, 4);
Rang1 = new Rang(SR_1, CR_1, TB_Rang1);
TB_Rang2 = new Table[4];
TB_Rang2[0] = Table_4_Rang_2_1 = new Table(4, 0, 5);
TB_Rang2[1] = Table_4_Rang_2_2 = new Table(4, 0, 6);
TB_Rang2[2] = Table_4_Rang_2_3 = new Table(4, 0, 7);
TB_Rang2[3] = Table_4_Rang_2_4 = new Table(4, 0, 8);
Rang2 = new Rang(SR_2, CR_2, TB_Rang2);
Carre1 = new Carre(Rang1, Rang2);
TB_Rang3 = new Table[3];
TB_Rang3[0] = Table_8_Rang3_1 = new Table(8, 0, 9);
TB_Rang3[1] = Table_4_Rang3_2 = new Table(4, 0, 10);
TB_Rang3[2] = Table_8_Rang3_3 = new Table(8, 0, 11);
Rang3 = new Rang(SR_3, CR_3, TB_Rang3);
TB_Rang4 = new Table[3];
TB_Rang4[0] = Table_4_Rang_4_1 = new Table(4, 0, 12);
TB_Rang4[1] = Table_8_Rang_4_2 = new Table(8, 0, 13);
TB_Rang4[2] = Table_4_Rang_4_3 = new Table(4, 0, 14);
Rang4 = new Rang(SR_3, CR_3, TB_Rang3);
Carre2 = new Carre(Rang3, Rang4);
Presentoire = new PresentoireSalle();
Salle = Salle.GetInstance(Carre1, Carre2, MH, CS, Presentoire);
Chiffre = 0;
InitializeComponent();
}
private void btn_add_liaison_Click(object sender, EventArgs e)
{
try
{
Serveur serveur = new Serveur();
serveur.Adresse = _ls_adresse.Text;
serveur.Database = _ls_database.Text;
serveur.User = _ls_users.Text;
serveur.Password = _ls_password.Text;
serveur.Port = Convert.ToInt16(_ls_port.Text);
serveur.DateDebut = dtp_date_debut.Value;
if (serveur.Control())
{
Serveur y = liaisons.Find(x => x.Adresse == serveur.Adresse);
if (y != null ? Utils.asString(y.Adresse) ? (liaison != null ? !Utils.asString(liaison.Adresse) : true) : false : false)
{
TOOLS.Messages.ShowErreur("Vous avez deja associé ce serveur");
return;
}
bool continu = true;
if (liaison != null ? Utils.asString(liaison.Adresse) ? !liaison.Adresse.Equals(serveur.Adresse) : false : false)
{
continu = LiaisonBLL.DeleteServeur(liaison);
}
if (continu)
{
if (LiaisonBLL.CreateServeur(serveur))
{
if (liaison != null ? Utils.asString(liaison.Adresse) : false)
{
int index = liaisons.FindIndex(x => x.Adresse == liaison.Adresse);
if (index > -1)
{
liaisons.RemoveAt(index);
}
liaisons.Insert((index > -1 ? index : 0), serveur);
if (!liaison.Adresse.Equals(serveur.Adresse))
{
DeleteLiaison(liaison);
}
UpdateLiaison(serveur);
}
else
{
AddLiaison(serveur);
liaisons.Add(serveur);
}
}
ResetLiaison();
Messages.Succes();
}
}
}
catch (Exception ex)
{
Utils.Exception(ex);
}
}
public Rang(Serveur Serveur, ChefRang ChefRang, Table[] ListeTables)
{
//initialisations par défauts
this.Serveur = Serveur;
this.ChefRang = ChefRang;
this.ListeTables = ListeTables;
Serveur.SetRang(this);
ChefRang.SetRang(this);
}
public void Init(int unId)
{
Serveur unServeur = Serveur.GetInstance(unId);
TB_Nom_Serveur.Text = unServeur.nomServeur.ToString();
TB_Prenom_Serveur.Text = unServeur.prenomServeur.ToString();
CB_Etat_Serveur.Items.Add("NonActif");
CB_Etat_Serveur.Items.Add("Actif");
}
public void commanderEauTest()
{
Serveur serveur = new Serveur();
int StockBase = serveur.StockEau;
//serveur.servirEau();
int stockFinal = serveur.StockEau;
Assert.AreNotEqual(StockBase, stockFinal);
}
public void commanderPainTest()
{
Serveur serveur = new Serveur();
int StockBase = serveur.StockPain;
//serveur.servirPain();
int stockFinal = serveur.StockPain;
Assert.AreNotEqual(StockBase, stockFinal);
}
private void LoadServeur()
{
Serveur s = ServeurBLL.ReturnServeur();
if (s != null)
{
PopulateServeur(s);
}
}
public void ResetLiaison()
{
_ls_adresse.Text = "";
_ls_database.Text = "";
_ls_users.Text = "";
_ls_password.Text = "";
_ls_port.Text = "0";
liaison = new Serveur();
}
public static Serveur Update(Serveur myItem)
{
using (MySqlConnection myConnection = new MySqlConnection(Param.MySQLConnectionString))
{
StringBuilder mySql = new StringBuilder();
mySql.Append("UPDATE `Serveur` SET ");
mySql.Append("`libelle` = @libelle, ");
mySql.Append("`ipLocale` = @ipLocale, ");
mySql.Append("`ipPublique` = @ipPublique, ");
mySql.Append("`cheminInfosMonitoring` = @cheminInfosMonitoring ");
mySql.Append("WHERE `id` = @id ");
MySqlCommand myCommand = new MySqlCommand(mySql.ToString(), myConnection);
myCommand.CommandType = CommandType.Text;
myCommand.Parameters.AddWithValue("@id", myItem.id);
myCommand.Parameters.AddWithValue("@libelle", myItem.libelle);
myCommand.Parameters.AddWithValue("@ipLocale", myItem.ipLocale);
myCommand.Parameters.AddWithValue("@ipPublique", myItem.ipPublique);
myCommand.Parameters.AddWithValue("@cheminInfosMonitoring", myItem.cheminInfosMonitoring);
myConnection.Open();
myCommand.ExecuteNonQuery();
myConnection.Close();
}
return myItem;
}
private static Serveur LoadADO(MySqlDataReader myReader)
{
Serveur myItem = new Serveur();
myItem.id = iZyMySQL.GetIntFromDBInt(myReader["serveur_id"]);
myItem.libelle = iZyMySQL.GetStringFromDBString(myReader["serveur_libelle"]);
myItem.ipLocale = iZyMySQL.GetStringFromDBString(myReader["serveur_ipLocale"]);
myItem.ipPublique = iZyMySQL.GetStringFromDBString(myReader["serveur_ipPublique"]);
myItem.cheminInfosMonitoring = iZyMySQL.GetStringFromDBString(myReader["serveur_cheminInfosMonitoring"]);
return myItem;
}
