private void lb_salle_SelectedIndexChanged(object sender, EventArgs e) { short selectedItem1 = short.Parse(lb_salle.Items[lb_salle.SelectedIndex].ToString()); using (TravailLigueEntities context = new TravailLigueEntities()) { var listesal = from s in context.tsalles where s.idsalle == selectedItem1 select s; foreach (tsalle s in listesal) { string selectedItem = s.libsalle; tb_nsalle.Text = selectedItem; string selectedItem4 = s.prixsalle.ToString(); tb_psalle.Text = selectedItem4; string selectedItem2 = s.perssalle.ToString(); tb_permax.Text = selectedItem2; string selectedItem3 = s.idCat.ToString(); tb_icateg.Text = selectedItem3; } } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { short selectedItem1 = short.Parse(listBox1.Items[listBox1.SelectedIndex].ToString()); using (TravailLigueEntities context = new TravailLigueEntities()) { var listeligue = from s in context.tligues where s.idligue == selectedItem1 select s; foreach (tligue s in listeligue) { string selectedItem = s.nomligue; NomBox.Text = selectedItem; string selectedItem2 = s.adrligue; AdrBox.Text = selectedItem2; string selectedItem3 = s.villeligue; VilleBox.Text = selectedItem3; string selectedItem4 = s.cpligue; CPBox.Text = selectedItem4; string selectedItem5 = s.telligue; TelBox.Text = selectedItem5; string selectedItem6 = s.mailligue; MailBox.Text = selectedItem6; string selectedItem7 = s.intitligue; IntBox.Text = selectedItem7; } } }
public void RefreshContent() { datagrid_salles.Rows.Clear(); datagrid_reservations.Rows.Clear(); datagrid_ligues.Rows.Clear(); using (TravailLigueEntities context = new TravailLigueEntities()) { var listeSalle = from s in context.tsalles select s; foreach (tsalle s in listeSalle) { datagrid_salles.Rows.Add(s.idsalle, s.libsalle, s.prixsalle, s.perssalle); } var listeReservations = from r in context.treservs select r; foreach (treserv s in listeReservations) { datagrid_reservations.Rows.Add(s.idreserv, s.idLigue, s.idsalle, s.datereserv); } var listeLigues = from r in context.tligues select r; foreach (tligue s in listeLigues) { datagrid_ligues.Rows.Add(s.idligue, s.nomligue, s.adrligue, s.villeligue, s.cpligue, s.telligue, s.mailligue, s.intitligue); } /* WIP */ } }
private void lstCateg_SelectedIndexChanged(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { var results = from s in context.tcategories select s; } }
private void RefreshContent() { using (TravailLigueEntities context = new TravailLigueEntities()) { var listeCat = from s in context.tcategories select s; foreach (tcategory s in listeCat) { listBox1.Items.Add(s.idCat); } } }
private void RefreshContent() { using (TravailLigueEntities context = new TravailLigueEntities()) { lb_salle.Items.Clear(); var listesal = from s in context.tsalles select s; foreach (tsalle s in listesal) { lb_salle.Items.Add(s.idsalle); } } }
private void RefreshContent() { using (TravailLigueEntities context = new TravailLigueEntities()) { CompteBox.Items.Clear(); var listeCompte = from s in context.tcomptes select s; foreach (tcompte s in listeCompte) { CompteBox.Items.Add(s.idCompte); } } }
private void RefreshContent() { using (TravailLigueEntities context = new TravailLigueEntities()) { listBox1.Items.Clear(); var listeligue = from s in context.tligues select s; foreach (tligue s in listeligue) { listBox1.Items.Add(s.idligue); } } }
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 listBox1_SelectedIndexChanged(object sender, EventArgs e) { short selectedItem1 = short.Parse(listBox1.Items[listBox1.SelectedIndex].ToString()); using (TravailLigueEntities context = new TravailLigueEntities()) { var listeCat = from s in context.tcategories where s.idCat == selectedItem1 select s; foreach (tcategory s in listeCat) { string selectedItem = s.libcat; textBox1.Text = selectedItem; } } }
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 CompteBox_SelectedIndexChanged(object sender, EventArgs e) { short selectedItem1 = short.Parse(CompteBox.Items[CompteBox.SelectedIndex].ToString()); using (TravailLigueEntities context = new TravailLigueEntities()) { var listeCompte = from s in context.tcomptes where s.idCompte == selectedItem1 select s; foreach (tcompte s in listeCompte) { string selectedItem = s.identifiant; IDBox.Text = selectedItem; string selectedItem2 = s.password; MDPBox.Text = selectedItem2; } } }
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 button1_Click(object sender, EventArgs e) { using (TravailLigueEntities context = new TravailLigueEntities()) { var results = from s in context.tcomptes where s.identifiant.Equals(tb_id.Text) where s.password.Equals(tb_mdp.Text) select s; if (results.Count() > 0) { this.Hide(); Form mainForm = new Affichage(); mainForm.ShowDialog(); } else { MessageBox.Show("Erreur authentification !", "L'identifiant/mot de passe est incorrect !", MessageBoxButtons.RetryCancel); } } }
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(); } }