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