private void button1_Click(object sender, EventArgs e) { if (updateImmobilier != null && updateImmobilier.id_categories != 0) { PFE.Entities.Immeubiliers updateImm = db.Immeubiliers.Where(c => c.id_immeubiliers == updateImmobilier.id_immeubiliers).First(); updateImm.id_villes = int.Parse(comboBoxVille.SelectedValue.ToString()); updateImm.id_quartiers = int.Parse(comboBoxQuartier.SelectedValue.ToString()); updateImm.nbr_chambre = int.Parse(textchambre.Text.ToString()); updateImm.superficie = int.Parse(textsype.Text.ToString()); updateImm.tarif = int.Parse(textTarif.Text.ToString()); updateImm.nom_proprietaire = textProp.Text.ToString(); updateImm.tel_proprietaire = textTel.Text.ToString(); updateImm.id_categories = int.Parse(comboBoxCategorie.SelectedValue.ToString()); db.Entry(updateImm).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("modification avec success"); } else { PFE.Entities.Immeubiliers imm = new PFE.Entities.Immeubiliers(); imm.id_categories = int.Parse(comboBoxCategorie.SelectedValue.ToString()); imm.id_villes = int.Parse(comboBoxVille.SelectedValue.ToString()); imm.id_quartiers = int.Parse(comboBoxVille.SelectedValue.ToString()); imm.nbr_chambre = int.Parse(textchambre.Text.ToString()); imm.superficie = int.Parse(textsype.Text.ToString()); imm.tarif = int.Parse(textTarif.Text.ToString()); imm.nom_proprietaire = textProp.Text.ToString(); imm.tel_proprietaire = textTel.Text.ToString(); imm.status = "libre"; db.Immeubiliers.Add(imm); db.SaveChanges(); MessageBox.Show("Vous avez ajouter un nouveau immobilier"); button1_Click(sender, e); } }
public void remplirTextOfDetails(PFE.Entities.Immeubiliers immobilierInf) { remplirComboCat(); remplirComboVille(); comboBoxCategorie.Enabled = true; comboBoxVille.Enabled = true; comboBoxQuartier.Enabled = true; textchambre.Enabled = true; textsype.Enabled = true; textTarif.Enabled = true; textProp.Enabled = true; textDesc.Enabled = true; textTel.Enabled = true; buttonValider.Enabled = false; comboBoxCategorie.SelectedValue = immobilierInf.id_categories; comboBoxVille.SelectedValue = immobilierInf.id_villes; comboBoxQuartier.SelectedValue = immobilierInf.id_quartiers; textchambre.Text = immobilierInf.nbr_chambre.ToString(); textsype.Text = immobilierInf.superficie.ToString(); textTarif.Text = immobilierInf.tarif.ToString(); textProp.Text = immobilierInf.nom_proprietaire.ToString(); textDesc.Text = immobilierInf.description; textTel.Text = immobilierInf.tel_proprietaire; detailImmobilier = immobilierInf; }
public void remplirChampText(PFE.Entities.Immeubiliers immobilierInf) { remplirComboCat(); remplirComboVille(); comboBoxCategorie.SelectedValue = immobilierInf.id_categories; comboBoxVille.SelectedValue = immobilierInf.id_villes; comboBoxQuartier.SelectedValue = immobilierInf.id_quartiers; textchambre.Text = immobilierInf.nbr_chambre.ToString(); textsype.Text = immobilierInf.superficie.ToString(); textTarif.Text = immobilierInf.tarif.ToString(); textProp.Text = immobilierInf.nom_proprietaire.ToString(); textDesc.Text = immobilierInf.description; textTel.Text = immobilierInf.tel_proprietaire; updateImmobilier = immobilierInf; }
private void btModifier_Click(object sender, EventArgs e) { if (dataGridView1.CurrentRow.Index != -1) { int id_imm = Convert.ToInt32(dataGridView1.CurrentRow.Cells["Number"].Value); PFE.Entities.Immeubiliers Objimm = db.Immeubiliers.Where(c => c.id_immeubiliers == id_imm).First(); PFE.Immobiliers.AjouterImmeubilier userModif = new PFE.Immobiliers.AjouterImmeubilier(); userModif.remplirChampText(Objimm); this.Hide(); userModif.Show(); } else { MessageBox.Show("Veuillez choisir un element parmi la liste"); } }
private void button1_Click_1(object sender, EventArgs e) { if (dataGridView1.CurrentRow.Index != -1) { int iddetails = (int)dataGridView1.CurrentRow.Cells["Number"].Value; PFE.Immobiliers.AjouterImmeubilier userModif = new PFE.Immobiliers.AjouterImmeubilier(); PFE.Entities.Immeubiliers ObjectImm = db.Immeubiliers.Where(c => c.id_immeubiliers == iddetails).First(); userModif.remplirTextOfDetails(ObjectImm); this.Hide(); userModif.Show(); } else { MessageBox.Show("Veuillez choisir un element parmi la liste"); } }
private void button1_Click(object sender, EventArgs e) { if (id_immobilier != 0) { PFE.Entities.Immeubiliers immobl = db.Immeubiliers.Where(c => c.id_immeubiliers == id_immobilier).First(); if (immobl.status.Equals("libre")) { PFE.Entities.Reservations addReserv = new PFE.Entities.Reservations(); PFE.Entities.Clients client = null; if (!String.IsNullOrEmpty(nomclt.Text) || !String.IsNullOrEmpty(cinclt.Text) || !String.IsNullOrEmpty(teleclt.Text)) { client = new PFE.Entities.Clients(); client.nom = nomclt.Text; client.cin = cinclt.Text; client.tel = teleclt.Text; db.Clients.Add(client); db.SaveChanges(); } else { int cltid = (int)dataGridUser.CurrentRow.Cells["Numero"].Value; client = db.Clients.Where(c => c.id_clients == cltid).First(); } PFE.Entities.Clients clt = db.Clients.Where(c => c.cin == client.cin).First(); addReserv.id_clients = clt.id_clients; addReserv.id_immeubiliers = immobl.id_immeubiliers; addReserv.nbr_personne = int.Parse(nbrclt.Text.ToString()); addReserv.date_debut = datedebut.Value; addReserv.date_fin = datefin.Value; addReserv.tarif = float.Parse(tarifText.Text.ToString()); addReserv.status = "reserve"; db.Reservations.Add(addReserv); db.SaveChanges(); MessageBox.Show("Reservation bien effectuee"); } } else { PFE.Entities.Reservations addReserv = db.Reservations.Where(c => c.id_reservations == resUpdateObject.id_reservations).First(); PFE.Entities.Clients client = db.Clients.Where(c => c.id_clients == resUpdateObject.id_clients).First(); client.nom = nomclt.Text; client.cin = cinclt.Text; client.tel = teleclt.Text; client.id_clients = addReserv.id_clients; db.Entry(client).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); addReserv.id_clients = addReserv.id_clients; addReserv.id_immeubiliers = addReserv.id_immeubiliers; addReserv.nbr_personne = int.Parse(nbrclt.Text.ToString()); addReserv.date_debut = datedebut.Value; addReserv.date_fin = datefin.Value; addReserv.tarif = float.Parse(tarifText.Text.ToString()); addReserv.status = "reserve"; db.Entry(addReserv).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("Modification bien effectuee"); } }