//Bouton de connection private void connectButton_Click(object sender, EventArgs e) { connectButton.DialogResult = DialogResult.OK; //Vérifie les infos if (checkInfoValiditie()) { SR2DDatabase db = new SR2DDatabase(); //Connecte SR2DMessages m = db.connect(userTextBox.Text, passwordTextBox.Text, pathTextBox.Text, sourceTextBox.Text, portNumUpDown.Value.ToString()); if (m == SR2DMessages.SUC_100) { form.updateStatutOnWorker("Mise a jour de la base de donnée", 35); if (/*db.updateDatabase(pathTextBox.Text)*/ true) { form.setDatabase(db); this.returnStatut = true; this.Close(); } } else { DialogResult failBox = MessageBox.Show("Une erreur est survenue lors de la connection à la base de donnée ! Veuillez vérifier la validité de vos informations de connection.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public userAddForm(usersForm uF, SR2DDatabase db) { InitializeComponent(); this.uF = uF; this.db = db; getRanks(); }
public foodTypeInfoForm(foodTypeForm fTF, SR2DClassBound cB, DataRow refDR) { InitializeComponent(); this.fTF = fTF; this.cB = cB; this.db = cB.db; this.refDR = refDR; init(); }
public usersForm(mainForm mF, SR2DDatabase db) { InitializeComponent(); this.mF = mF; this.db = db; db.Ds.DatabaseUpdatedEvent += new SR2DDataset.EventHandler(update); fillGridView(""); }
public foodAddForm(foodForm fF, SR2DClassBound cB) { InitializeComponent(); this.fF = fF; this.cB = cB; this.db = cB.db; foodTypeIDs = new List <int>(); fill(); }
public foodTypeAddForm(foodTypeForm fTF, SR2DClassBound cB) { InitializeComponent(); this.fTF = fTF; this.cB = cB; this.db = cB.db; othersFoodTypeIDs = new List <int>(); fillChListbox(); }
public foodModifyForm(foodForm fF, SR2DClassBound cB, DataRow refDR) { InitializeComponent(); this.fF = fF; this.cB = cB; this.db = cB.db; this.refDR = refDR; foodTypeIDs = new List <int>(); fill(); }
public userInfosForm(SR2DClassBound cB, userForm cF, DataRow dr) { InitializeComponent(); this.cF = cF; this.cB = cB; this.db = cB.db; this.networkControl = cB.networkControler; this.dr = dr; load(); }
public foodTypeModifyForm(foodTypeForm fTF, SR2DClassBound cB, DataRow refDR) { InitializeComponent(); this.fTF = fTF; this.cB = cB; this.db = cB.db; this.refDR = refDR; othersFoodTypeInitialState = new List <CheckState>(); othersFoodTypeIDs = new List <int>(); fill(); }
public foodTypeForm(foodForm fF, SR2DClassBound cB) { InitializeComponent(); this.fF = fF; this.cB = cB; this.db = cB.db; db.Ds.DatasetUpdatedEvent += new SR2DDataset.EventHandler(update); setServiceMode(); fillGridView(); }
public userForm(MainForm mF, SR2DClassBound cB) { InitializeComponent(); this.mF = mF; this.cB = cB; this.db = cB.db; this.networkControl = cB.networkControler; fillGridView(); db.Ds.DatasetUpdatedEvent += new SR2DDataset.EventHandler(update); }
public MainForm(SR2DClassBound cB, initForm iF) { InitializeComponent(); this.cB = cB; this.database = cB.db; this.networkControler = cB.networkControler; database.Ds.DatasetUpdatedEvent += new SR2DDataset.EventHandler(update); updateHUD(); this.iF = iF; }
public SR2DNetworkClientControl(int port, string ip, SR2DDatabase db) { this.ip = ip; this.port = port; this.db = db; serverValiditieTimer = new System.Timers.Timer(15000); serverValiditieTimer.Elapsed += new ElapsedEventHandler(setDisconnected); serverValiditieTimer.Start(); startClient(); db.Ds.DatabaseUpdatedEvent += new SR2DDataset.EventHandler(requestUpdate); //Register to database update from user }
static public string getNextID(string table, SR2DDatabase db) { DataRowCollection drC = db.Ds.Dataset.Tables[table].Rows; int maxID = 0; foreach (DataRow dr in drC) { if (int.Parse(dr.ItemArray[0].ToString()) > maxID) { maxID = int.Parse(dr.ItemArray[0].ToString()); } } maxID++; return(maxID.ToString()); }
//********** END FONCTION INITIALISATION DES FICHIERS **********// //********** FONCTION INITIALISATION DE LA BASE DE DONNEE **********// public bool initDatabase() { string defaultConnectionName = hasDefaultConnection(); if (defaultConnectionName.Split(';')[0] == "true") { XmlDocument xmlDoc = new XmlDocument(); xmlDoc.Load(SR2DURLs.connectionXmlFile.getUrlFromRoot()); //Load connection file XmlNode root = xmlDoc.DocumentElement; XmlNodeList nodeList = root.ChildNodes; foreach (XmlNode node in nodeList) { if (node.Attributes[0].Value == defaultConnectionName.Split(';')[1]) { db = new SR2DDatabase(); SR2DMessages m = db.connect(node.ChildNodes[1].Attributes[0].Value, node.ChildNodes[2].Attributes[0].Value, node.ChildNodes[0].Attributes[0].Value, node.ChildNodes[4].Attributes[0].Value, node.ChildNodes[3].Attributes[0].Value); if (m != SR2DMessages.SUC_100) { //??? Rajout modification connection (defaut, ajout , supression ...) ???// writeConsole("Impossible de se connecter à la base de donnée"); return(false); } } } } else { //??? Rajout modification connection (defaut, ajout , supression ...) ???// writeConsole("Données de connections invalides"); return(false); } return(true); }
public foodForm(MainForm baseForm, SR2DClassBound cB) { InitializeComponent(); this.networkControler = cB.networkControler; this.db = cB.db; this.baseForm = baseForm; this.cB = cB; this.Height = baseForm.Height - 150; this.Width = baseForm.Width - 200; this.CenterToParent(); db.Ds.DatasetUpdatedEvent += new SR2DDataset.EventHandler(update); setServiceMode(); fillGridView(); }
public ServiceManagerForm(MainForm mF, SR2DClassBound cB) { InitializeComponent(); this.cB = cB; this.db = cB.db; this.mF = mF; db.Ds.DatasetUpdatedEvent += new SR2DDataset.EventHandler(update); #region INIT_CHARTS var mapper = Mappers.Xy <MeasureModel>() .X(model => model.DateTime.Ticks) //use DateTime.Ticks as X .Y(model => model.Value); //use the value property as Y //lets save the mapper globally. Charting.For <MeasureModel>(mapper); //the ChartValues property will store our values array reserv = new ChartValues <MeasureModel>(); retired = new ChartValues <MeasureModel>(); cartesianChart1.Series = new SeriesCollection { new LineSeries { Values = reserv, PointGeometry = null, LineSmoothness = 0.5 } }; cartesianChart1.DataTooltip = null; cartesianChart1.AxisX.Add(new Axis { DisableAnimations = false, LabelFormatter = value => new System.DateTime((long)value).ToString("HH:mm:ss"), Separator = new Separator { Step = TimeSpan.FromSeconds(60).Ticks } }); cartesianChart1.AxisY.Add(new Axis { Separator = new Separator { Step = 1, } }); cartesianChart1.AxisY[0].MinValue = 0; SetAxisLimits(System.DateTime.Now, cartesianChart1); cartesianChart2.Series = new SeriesCollection { new LineSeries { Values = retired, PointGeometry = null, LineSmoothness = 0.5 } }; cartesianChart2.DataTooltip = null; cartesianChart2.AxisX.Add(new Axis { DisableAnimations = false, LabelFormatter = value => new System.DateTime((long)value).ToString("HH:mm:ss"), Separator = new Separator { Step = TimeSpan.FromSeconds(60).Ticks } }); cartesianChart2.AxisY.Add(new Axis { Separator = new Separator { Step = 1, } }); cartesianChart2.AxisY[0].MinValue = 0; SetAxisLimits(System.DateTime.Now, cartesianChart2); guiUpdate(); timer = new Timer { Interval = 5000 }; timer.Tick += timerOnTick; timer.Start(); #endregion #region INIT_LIST objectListView1.CellEditActivation = ObjectListView.CellEditActivateMode.DoubleClick; objectListView1.ShowGroups = true; objectListView1.Sort(2); populateDispList(); updatePrep(); #endregion setServiceMode(); }
private bool threadInit() { updateStatutOnWorker("Chargement des fichiers", 0); if (!checkPathExist(SR2DURLs.mainFolder.getUrlFromRoot())) { if (!createFolder(SR2DURLs.mainFolder.getUrlFromRoot())) { return(false); } } if (!checkFileExist(SR2DURLs.connectionXmlFile.getUrlFromRoot())) { if (!createConnectionFile()) { return(false); } } if (!checkFileExist(SR2DURLs.configXmlFile.getUrlFromRoot())) { if (!createConfigFile()) { return(false); } } if (!updateConfig(SR2DURLs.configXmlFile.getUrlFromRoot())) { return(false); } vars = new SR2DVars(); updateStatutOnWorker("Chargement des connections", 20); string defaultConnectionName = hasDefaultConnection(); updateStatutOnWorker("Mise a jour des fichiers tiers", 25); updateStatutOnWorker("Connection", 30); if (defaultConnectionName.Split(';')[0] == "true") { XmlDocument xmlDoc = new XmlDocument(); try { xmlDoc.Load(SR2DURLs.connectionXmlFile.getUrlFromRoot()); XmlNode root = xmlDoc.DocumentElement; XmlNodeList nodeList = root.ChildNodes; foreach (XmlNode node in nodeList) { if (node.Attributes[0].Value == defaultConnectionName.Split(';')[1]) { database = new SR2DDatabase(); SR2DMessages m = database.connect(node.ChildNodes[1].Attributes[0].Value, node.ChildNodes[2].Attributes[0].Value, node.ChildNodes[0].Attributes[0].Value, node.ChildNodes[4].Attributes[0].Value, node.ChildNodes[3].Attributes[0].Value); if (m != SR2DMessages.SUC_100) { DialogResult failBox = MessageBox.Show("Une erreur est survenue lors de la connection a la base de donnée par defaut !", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); ConnectionForm connectionForm = new ConnectionForm(this); DialogResult r = connectionForm.ShowDialog(); while (r != DialogResult.OK || connectionForm.returnStatut != true) { connectionForm = new ConnectionForm(this); r = connectionForm.ShowDialog(); } Console.WriteLine("conected"); } else { updateStatutOnWorker("Mise a jour de la base de donnée", 35); } } } } catch (Exception e) { Console.WriteLine(e.StackTrace); } } else { ConnectionForm connectionForm = new ConnectionForm(this); DialogResult r = connectionForm.ShowDialog(); while (r != DialogResult.OK && connectionForm.returnStatut != true) { connectionForm = new ConnectionForm(this); r = connectionForm.ShowDialog(); } Console.WriteLine("connected"); } updateStatutOnWorker("Connection au serveur", 50); if (!connectToServer()) { return(false); } updateStatutOnWorker("Aquisition des données", 70); database.initDataset(); updateStatutOnWorker("Lancement", 100); return(true); }
public void setDatabase(SR2DDatabase db) { this.database = db; }
public SR2DClassBound(SR2DDatabase db, SR2DNetworkClientControl controler, SR2DVars vars) { this.db = db; this.networkControler = controler; this.vars = vars; }