1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| private void lkAjouterRub_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
if (!IsDocumentValidR())
return;
else
{
double textboxValue;
bool ok = Double.TryParse(txtMontantR.Text, System.Globalization.NumberStyles.Any, new System.Globalization.CultureInfo("fr-FR"), out textboxValue) || Double.TryParse(txtMontantR.Text, System.Globalization.NumberStyles.Any, System.Globalization.CultureInfo.InvariantCulture, out textboxValue);
connection.Open();
if (ok)
{
cmdQ = new SqlCommand("insert into Rubriques(IDR, NumAO, Chap, Art, Reg, Para, Ligne, MontantRub , typeImputation, AnneeImputation) values(@IDR, @NumAO, @Chap, @Art, @Reg, @Para, @Ligne, @MontantRub, @typeImputation, @AnneeImputation)", connection);
cmdQ.Parameters.AddWithValue("@IDR", Guid.NewGuid().ToString());
cmdQ.Parameters.AddWithValue("@NumAO", (cmbAO.SelectedItem as ComboBoxItem).Text);
cmdQ.Parameters.AddWithValue("@Chap", txtChap.Text);
cmdQ.Parameters.AddWithValue("@Art", txtArt.Text);
cmdQ.Parameters.AddWithValue("@Reg", txtReg.Text);
cmdQ.Parameters.AddWithValue("@Para", txtParag.Text);
cmdQ.Parameters.AddWithValue("@Ligne", txtLigne.Text);
cmdQ.Parameters.AddWithValue("@MontantRub", textboxValue);
cmdQ.Parameters.AddWithValue("@typeImputation", cmbTypeImp.SelectedItem.ToString());
cmdQ.Parameters.AddWithValue("@AnneeImputation", Convert.ToInt16(txtAnneeImp.Text));
cmdQ.ExecuteNonQuery();
ClearDataRubriques();
}
else
{
MessageBox.Show("Revoir votre saisie !");
}
connection.Close();
DisplayDataRubriques();
}
} |
Partager