private void dataGridClt_DoubleClick(object sender, EventArgs e) { int id_clt = Convert.ToInt32(dataGridClt.CurrentRow.Cells[0].Value); PFE.Entities.Clients newClt = db.Clients.Where(x => x.id_clients == id_clt).First(); nomCltTxt.Text = newClt.nom; cinCltText.Text = newClt.cin; nomCltTxt.Text = newClt.tel; }
public void remplirChampUpdate(PFE.Entities.Reservations reservation) { resUpdateObject = reservation; PFE.Entities.Clients clt = db.Clients.Where(c => c.id_clients == reservation.id_clients).First(); nomclt.Text = clt.nom; cinclt.Text = clt.cin; teleclt.Text = clt.tel; datedebut.Text = reservation.date_debut.ToString(); datefin.Text = reservation.date_fin.ToString(); tarifText.Text = reservation.tarif.ToString(); nbrclt.Text = reservation.nbr_personne.ToString(); }
private void modifierBtm_Click(object sender, EventArgs e) { if (dataGridClt.CurrentRow.Index != -1) { int id_clt = Convert.ToInt32(dataGridClt.CurrentRow.Cells[0].Value); PFE.Entities.Clients newClt = db.Clients.Where(x => x.id_clients == id_clt).First(); newClt.nom = nomCltTxt.Text; newClt.cin = nomCltTxt.Text; newClt.tel = nomCltTxt.Text; db.Entry(newClt).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); MessageBox.Show("modification avec success"); remplirGridViewClient(); } }
private void button2_Click(object sender, EventArgs e) { if (!String.IsNullOrEmpty(nomCltTxt.Text) && !String.IsNullOrEmpty(cinCltText.Text) && !String.IsNullOrEmpty(teleClt.Text)) { PFE.Entities.Clients newClt = new PFE.Entities.Clients(); newClt.nom = nomCltTxt.Text.ToString(); newClt.cin = cinCltText.Text.ToString(); newClt.tel = teleClt.Text.ToString(); db.Clients.Add(newClt); db.SaveChanges(); MessageBox.Show("client est ajouter avec succes "); remplirGridViewClient(); } else { MessageBox.Show("Veuillez remplir tous les champs "); } }
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"); } }