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