Esempio n. 1
0
        public static void AjoutMateriel(Data_Materiels DataMAt)
        {
            var sql =
                "insert into materiel (id_mat, nom, referenece, descr, date_instal, mtbf, perime, id_type, id_site, id_client) values (NULL, @nom, @referenece, @descr, @date_instal, @mtbf, @perime, @id_type, @id_site, @id_client)";
            var con = Fcts_DB.GetConnection();
            var cmd = new MySqlCommand(sql, con)
            {
                CommandType = CommandType.Text
            };

            cmd.Parameters.Add("@nom", MySqlDbType.VarChar).Value        = DataMAt.Nom;
            cmd.Parameters.Add("@referenece", MySqlDbType.VarChar).Value = DataMAt.Referenece;
            cmd.Parameters.Add("@descr", MySqlDbType.VarChar).Value      = DataMAt.Descr;
            // Conversion du format Text en Date
            cmd.Parameters.Add("@date_instal", MySqlDbType.DateTime).Value = DataMAt.Date_instal;
            // Conversion du format Text en Int32
            cmd.Parameters.Add("@mtbf", MySqlDbType.Int32).Value = DataMAt.Mtbf;
            // Converstion du format Text en Bit
            cmd.Parameters.Add("@perime", MySqlDbType.VarChar).Value  = DataMAt.Perime;
            cmd.Parameters.Add("@id_type", MySqlDbType.Int32).Value   = DataMAt.Id_type;
            cmd.Parameters.Add("@id_site", MySqlDbType.Int32).Value   = DataMAt.Id_site;
            cmd.Parameters.Add("@id_client", MySqlDbType.Int32).Value = DataMAt.Id_client;
            // Try / Catch pour savoir si la requete passe ou non
            try
            {
                cmd.ExecuteNonQuery();
                MessageBox.Show("Le materiel " + DataMAt.Nom + " a bien été ajouté.");
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Esempio n. 2
0
        private void btnEnr_Click(object sender, EventArgs e)
        {
            if (txtNom.Text == "" || txtRef.Text == "" || cbType.SelectedValue == "" || cbClient.SelectedValue == "" ||
                cbSite.SelectedValue == "" || nUpMTBF.Text == "" || txtDescr.Text == "")
            {
                MessageBox.Show("Veuillez remplir les champs.", "Information", MessageBoxButtons.OK,
                                MessageBoxIcon.Information);
            }
            else
            {
                if (btnEnr.Text == "Ajouter")
                {
                    var dataMat = new Data_Materiels(txtNom.Text.Trim(), txtRef.Text.Trim(),
                                                     txtDescr.Text.Trim(), dtpInstal.Text.Trim(),
                                                     nUpMTBF.Text.Trim(), checkbPerime.Checked.ToString(),
                                                     cbType.SelectedValue.ToString(), cbSite.SelectedValue.ToString(),
                                                     cbClient.SelectedValue.ToString());
                    Fcts_Materiels.AjoutMateriel(dataMat);
                }
                else if (btnEnr.Text == "Modifier")
                {
                    var dataMat = new Data_Materiels(txtNom.Text.Trim(), txtRef.Text.Trim(),
                                                     txtDescr.Text.Trim(), dtpInstal.Text.Trim(),
                                                     nUpMTBF.Text.Trim(), checkbPerime.Checked.ToString(),
                                                     cbType.SelectedValue.ToString(), cbSite.SelectedValue.ToString(),
                                                     cbClient.SelectedValue.ToString());
                    Fcts_Materiels.ModifMat(dataMat, id);
                }
            }

            _parent.Display();
        }
Esempio n. 3
0
        public static void ModifMat(Data_Materiels dataMat, string id)
        {
            // Fonction permettant la modification d'une intervention

            var sql =
                "update materiel set nom = @nom, referenece = @referenece, descr = @descr, date_instal = @date_instal, mtbf = @mtbf, perime = @perime, id_type = @id_type, id_site = @id_site, id_client = @id_client where id_mat = @id";
            var con = Fcts_DB.GetConnection();
            var cmd = new MySqlCommand(sql, con)
            {
                CommandType = CommandType.Text
            };

            cmd.Parameters.Add("@id", MySqlDbType.VarChar).Value         = id;
            cmd.Parameters.Add("@nom", MySqlDbType.VarChar).Value        = dataMat.Nom;
            cmd.Parameters.Add("@referenece", MySqlDbType.VarChar).Value = dataMat.Referenece;
            cmd.Parameters.Add("@descr", MySqlDbType.VarChar).Value      = dataMat.Descr;
            // Conversion du format Text en Date
            cmd.Parameters.Add("@date_instal", MySqlDbType.DateTime).Value = dataMat.Date_instal;
            // Conversion du format Text en Int32
            cmd.Parameters.Add("@mtbf", MySqlDbType.Int32).Value = dataMat.Mtbf;
            // Converstion du format Text en Bit
            cmd.Parameters.Add("@perime", MySqlDbType.VarChar).Value  = dataMat.Perime;
            cmd.Parameters.Add("@id_type", MySqlDbType.Int32).Value   = dataMat.Id_type;
            cmd.Parameters.Add("@id_site", MySqlDbType.Int32).Value   = dataMat.Id_site;
            cmd.Parameters.Add("@id_client", MySqlDbType.Int32).Value = dataMat.Id_client;
            // Try / Catch pour savoir si la requete passe ou non
            try
            {
                cmd.ExecuteNonQuery();
                MessageBox.Show("Le materiel " + dataMat.Nom + " a bien été modifié \n");
            }
            catch (MySqlException ex)
            {
                MessageBox.Show(ex.Message);
            }
        }