private void confirm_Click(object sender, EventArgs e) { //if (textBoxAnnee.Text != "" && comboBoxTrimestre.Text != "" && textBoxNewIndex.Text != "" && textBoxPrevIndex.Text != "" && comboBoxNpolice.Text != "" && textBoxAdress.Text != "" && textBoxNCompt.Text != "" ) //{ // if (MessageBox.Show("Voulez vous vraiment confirmer!", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) // { // if (textBoxMotif.Text == "") // dataGridView1.Rows.Add(comboBoxNpolice.Text, textBoxAdress.Text, textBoxAnnee.Text, comboBoxTrimestre.Text, textBoxNewIndex.Text, textBoxPrevIndex.Text, textBoxConsommation.Text, textBoxNetPayer.Text); // else // dataGridView1.Rows.Add(comboBoxNpolice.Text, textBoxAdress.Text, textBoxAnnee.Text, comboBoxTrimestre.Text, textBoxNewIndex.Text, textBoxPrevIndex.Text, textBoxConsommation.Text, textBoxNetPayer.Text, textBoxMotif.Text); // } //} //else // MessageBox.Show("Veuillez remplir tous les champs!", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); var All_Ok = true; foreach (Control control in Controls.OfType <TextBox>()) { if (control.Text == "") { All_Ok = false; break; } } if (comboBoxTrimestre.Text == "" || (textBoxMotif.Visible && textBoxMotif.Text == "")) { All_Ok = false; } if (!All_Ok) { ErrorMbox("Veuiller remplir tous les champs!"); } else if (MessageBox.Show("Voulez vous vraiment confirmer!", "Confirmation", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes) { using (var db = new FacturationEntities()) { db.RelveeEaux.Add(new RelveeEau { Eau_NPolice = comboBoxNpolice.Text, Annee = short.Parse(textBoxAnnee.Text), Trimestre = int.Parse(comboBoxTrimestre.Text), NIndex = int.Parse(textBoxNewIndex.Text), PIndex = int.Parse(textBoxPrevIndex.Text), NPayer = float.Parse(textBoxNetPayer.Text), Rapport = textBoxMotif.Visible ? textBoxMotif.Text : null }); db.SaveChanges(); } comboBoxNpolice_SelectedIndexChanged(sender, e); } }
private void dellete_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { var eau = db.Eaux.SingleOrDefault(ea => ea.NPolice == textBoxPolice.Text); if (eau == null) { return; } db.Eaux.Remove(eau); db.SaveChanges(); } }
private void del_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { var Telecommunication = db.TeleCommunications.SingleOrDefault(ea => ea.NPolice == textBoxPolice.Text); if (Telecommunication == null) { return; } db.TeleCommunications.Remove(Telecommunication); db.SaveChanges(); } }
// Modifier un Eau private void edit_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { var eau = db.Eaux.SingleOrDefault(ea => ea.NPolice == textBoxPolice.Text); eau.Etat_id = (int)comboBoxEtat.SelectedValue; eau.TypeEau_id = (int)comboBoxType.SelectedValue; eau.Annee = short.Parse(textBoxAnnee.Text); db.SaveChanges(); FillDataGridView(db.Eaux); } }
private void edit_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { var Telecommunication = db.TeleCommunications.SingleOrDefault(ea => ea.NPolice == textBoxPolice.Text); Telecommunication.Etat = db.Etats.Single(et => et.id == (int)comboBoxEtat.SelectedValue); Telecommunication.TypeTelecommunication = db.TypeTelecommunications.Single(te => te.id == (int)comboBoxType.SelectedValue); Telecommunication.Tel = textBoxTel.Text; Telecommunication.Date = dateTimePickerTelecom.Value; Telecommunication.MD = textBoxMD.Text; Telecommunication.Adresse = textBoxAdresse.Text; Telecommunication.Montant = short.Parse(textBoxPrice.Text); Telecommunication.Forfait = int.Parse(textBoxForfait.Text); db.SaveChanges(); } }
private void edit_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { var eau = db.Eaux.SingleOrDefault(ea => ea.NPolice == textBoxPolice.Text); eau.Etat = db.Etats.Single(et => et.id == (int)comboBoxEtat.SelectedValue); eau.TypeEau = db.TypeEaux.Single(te => te.id == (int)comboBoxType.SelectedValue); eau.NCompteur = textBoxNcompteur.Text; eau.Tel = textBoxTeli.Text; eau.Date = dateTimePickerElec.Value; eau.Reference = textBoxReference.Text; eau.Adresse = textBoxAdresse.Text; eau.Annee = short.Parse(textBoxAnnee.Text); db.SaveChanges(); } }
//Ajouter private void add_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { db.Eaux.Add(new Eau { NPolice = textBoxPolice.Text, Etat = db.Etats.Single(et => et.id == (int)comboBoxEtat.SelectedValue), TypeEau = db.TypeEaux.Single(te => te.id == (int)comboBoxType.SelectedValue), NCompteur = textBoxNcompteur.Text, Tel = textBoxTeli.Text, Date = dateTimePickerElec.Value, Reference = textBoxReference.Text, Adresse = textBoxAdresse.Text, Annee = short.Parse(textBoxAnnee.Text) }); db.SaveChanges(); } }
private void add_Click(object sender, EventArgs e) { using (var db = new FacturationEntities()) { db.TeleCommunications.Add(new TeleCommunication { NPolice = textBoxPolice.Text, Etat = db.Etats.Single(et => et.id == (int)comboBoxEtat.SelectedValue), TypeTelecommunication = db.TypeTelecommunications.Single(te => te.id == (int)comboBoxType.SelectedValue), Tel = textBoxTel.Text, Date = dateTimePickerTelecom.Value, MD = textBoxMD.Text, Adresse = textBoxAdresse.Text, Forfait = int.Parse(textBoxForfait.Text), Montant = double.Parse(textBoxPrice.Text) }); db.SaveChanges(); } }