private void btn_valcat_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { short selectedItem1 = short.Parse(listBox1.Items[listBox1.SelectedIndex].ToString()); var Categ = (from s in context.tcategories where s.idCat == selectedItem1 select s).First(); Categ.libcat = textBox1.Text; // executes the commands to implement the changes to the database context.SaveChanges(); } RefreshContent(); }
private void btn_val_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { short selectedItem1 = short.Parse(CompteBox.Items[CompteBox.SelectedIndex].ToString()); var Categ = (from s in context.tcomptes where s.idCompte == selectedItem1 select s).First(); Categ.identifiant = IDBox.Text; Categ.password = MDPBox.Text; // executes the commands to implement the changes to the database context.SaveChanges(); } RefreshContent(); }
private void btn_val_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { tcategory categ = new tcategory(); // fields to be insert short num = (from tcategory in context.tcategories select tcategory.idCat).Max(); num += 1; categ.idCat = num; categ.libcat = tb_libcat.Text; context.tcategories.Add(categ); // executes the commands to implement the changes to the database context.SaveChanges(); this.Close(); } }
private void btn_val_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { short selectedItem1 = short.Parse(lb_salle.Items[lb_salle.SelectedIndex].ToString()); var Categ = (from s in context.tsalles where s.idsalle == selectedItem1 select s).First(); Categ.libsalle = tb_nsalle.Text; Categ.prixsalle = decimal.Parse(tb_psalle.Text); Categ.perssalle = short.Parse(tb_permax.Text); Categ.idCat = short.Parse(tb_icateg.Text); // executes the commands to implement the changes to the database context.SaveChanges(); } RefreshContent(); }
private void btn_val_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { tcompte compte = new tcompte(); // fields to be insert int num = (from tcompte in context.tcomptes select tcompte.idCompte).Max(); num += 1; compte.idCompte = num; compte.identifiant = tb_id.Text; compte.password = tb_mdp.Text; context.tcomptes.Add(compte); // executes the commands to implement the changes to the database context.SaveChanges(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { tsalle salle = new tsalle(); // fields to be insert short num = (from tsalle in context.tsalles select tsalle.idsalle).Max(); num += 1; salle.idsalle = num; salle.libsalle = tb_lib.Text; salle.prixsalle = decimal.Parse(tb_px.Text); salle.perssalle = short.Parse(tb_pers.Text); context.tsalles.Add(salle); // executes the commands to implement the changes to the database context.SaveChanges(); this.Close(); } }
private void button1_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { short selectedItem1 = short.Parse(listBox1.Items[listBox1.SelectedIndex].ToString()); var Categ = (from s in context.tligues where s.idligue == selectedItem1 select s).First(); Categ.nomligue = NomBox.Text; Categ.adrligue = AdrBox.Text; Categ.villeligue = VilleBox.Text; Categ.cpligue = CPBox.Text; Categ.telligue = TelBox.Text; Categ.mailligue = MailBox.Text; Categ.intitligue = IntBox.Text; // executes the commands to implement the changes to the database context.SaveChanges(); } RefreshContent(); }
private void btn_val_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { tligue ligue = new tligue(); // fields to be insert int num = (from tligue in context.tligues select tligue.idligue).Max(); num += 1; ligue.idligue = num; ligue.nomligue = tb_name.Text; ligue.adrligue = tb_ad.Text; ligue.villeligue = tb_ville.Text; ligue.cpligue = tb_cp.Text; ligue.telligue = tb_tel.Text; ligue.mailligue = tb_mail.Text; ligue.intitligue = tb_intit.Text; context.tligues.Add(ligue); // executes the commands to implement the changes to the database context.SaveChanges(); this.Close(); } }