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();
}
}
