void remplirGrid()
{
using (BiblioEntities context = new BiblioEntities())
{
var demandes = context.demandes.Select(c => new
{
Nom_Eleve = c.eleve.nom + " " + c.eleve.prenom,
Titre_Livre = c.livre.titre,
Date_Prise = c.date_prise,
Date_Retour = c.date_retour,
Validation_Retour = c.valide_Retour,
}).ToList();
bs.DataSource = demandes;
ComboBoxTri.Items.Clear();
for (int i = 0; i < dataGridViewTransfert.Columns.Count - 1; i++)
{
ComboBoxTri.Items.Add(dataGridViewTransfert.Columns[i].Name);
}
dataGridViewTransfert.DataSource = bs;
}
}
private void ComboBoxFilter_SelectedIndexChanged(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
bool val;
if (ComboBoxFilter.Text == "Validé")
{
val = true;
}
else if (ComboBoxFilter.Text == "Non Validé")
{
val = false;
}
else
{
remplirGrid();
return;
}
var demandes = context.demandes.Where(c => c.valide_Retour == val).Select(c => new
{
Nom_Eleve = c.eleve.nom + " " + c.eleve.prenom,
Titre_Livre = c.livre.titre,
Date_Prise = c.date_prise,
Date_Retour = c.date_retour,
Validation_Retour = c.valide_Retour,
}).ToList();
bs.DataSource = demandes;
dataGridViewTransfert.DataSource = bs;
}
}
private void checkboxValidation_CheckedChanged(object sender, EventArgs e)
{
if (checkboxValidation.Checked == true)
{
dateTimePikerRetour.Value = DateTime.Now;
}
else
{
dateTimePikerRetour.Value = dateR;
}
using (BiblioEntities context = new BiblioEntities())
{
int id_eleve = int.Parse(comboEleve.SelectedValue.ToString());
int id_livre = int.Parse(comboLivre.SelectedValue.ToString());
var dem = context.demandes.FirstOrDefault(c => c.id_eleve == id_eleve && c.id_livre == id_livre);
if (dem != null)
{
dem.date_retour = dateTimePikerRetour.Value;
bs.EndEdit();
context.SaveChanges();
}
}
}
//Methode Modifier Entity framework
private void btnModifier_Click(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
int id_eleve = int.Parse(comboEleve.SelectedValue.ToString());
int id_livre = int.Parse(comboLivre.SelectedValue.ToString());
var dem = context.demandes.FirstOrDefault(c => c.id_eleve == id_eleve && c.id_livre == id_livre);
if (dem != null)
{
dem.id_eleve = int.Parse(comboEleve.SelectedValue.ToString());
dem.id_livre = int.Parse(comboLivre.SelectedValue.ToString());
dem.date_prise = dateTimePikerPrise.Value;
dem.date_retour = dateTimePikerRetour.Value;
dem.valide_Retour = checkboxValidation.Checked;
context.SaveChanges();
bs.EndEdit();
MessageBox.Show("Bien Modifier");
remplirGrid();
RemplirCombo();
}
else
{
MessageBox.Show("Cette Demande n'existe pas ");
}
}
}
//Methode Supprimer Entity framework
private void btnAnnuler_Click(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
int id_eleve = int.Parse(comboEleve.SelectedValue.ToString());
int id_livre = int.Parse(comboLivre.SelectedValue.ToString());
var dem = context.demandes.FirstOrDefault(c => c.id_eleve == id_eleve && c.id_livre == id_livre);
if (dem != null)
{
DialogResult rep = MessageBox.Show("Annulation", "Voulez vous Annuler ?", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (rep == DialogResult.Yes)
{
context.demandes.Remove(dem);
context.SaveChanges();
MessageBox.Show("Bien Annuler");
remplirGrid();
RemplirCombo();
}
}
else
{
MessageBox.Show("Cette Demande n'existe pas ");
}
}
}
//Methode Ajouter Entity framework
private void btnAjouter_Click(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
demande d = new demande();
d.id_eleve = int.Parse(comboEleve.SelectedValue.ToString());
d.id_livre = int.Parse(comboLivre.SelectedValue.ToString());
d.date_prise = dateTimePikerPrise.Value;
d.date_retour = dateTimePikerRetour.Value;
d.valide_Retour = checkboxValidation.Checked;
var dem = context.demandes.FirstOrDefault(c => c.id_eleve == d.id_eleve && c.id_livre == d.id_livre);
if (dem == null)
{
context.demandes.Add(d);
context.SaveChanges();
MessageBox.Show("Bien Ajouter");
remplirGrid();
RemplirCombo();
}
else
{
MessageBox.Show("Cette Demande existe déja");
}
}
}
private void btnNouveau_Click(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
demande d = new demande();
d.id_eleve = int.Parse(comboEleve.SelectedValue.ToString());
d.id_livre = int.Parse(comboLivre.SelectedValue.ToString());
d.date_prise = dateTimePikerPrise.Value;
d.date_retour = dateTimePikerRetour.Value;
d.valide_Retour = checkboxValidation.Checked;
context.demandes.Add(d);
context.SaveChanges();
MessageBox.Show("Bien Ajouter");
}
}
void getQuantite()
{
try
{
int code = int.Parse(comboLivre.SelectedValue.ToString());
using (BiblioEntities context = new BiblioEntities())
{
var livre = context.livres.FirstOrDefault(c => c.id == code);
txtQtt.Text = livre.quantite + "";
}
}
catch (Exception)
{
}
}
private void ComboBoxTri_SelectedIndexChanged(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
var demandes = context.demandes.Select(c => new
{
Nom_Eleve = c.eleve.nom + " " + c.eleve.prenom,
Titre_Livre = c.livre.titre,
Date_Prise = c.date_prise,
Date_Retour = c.date_retour,
Validation_Retour = c.valide_Retour,
}).ToList();
switch (ComboBoxTri.SelectedIndex)
{
case 0:
var dem0 = demandes.OrderBy(c => c.Nom_Eleve).ToList();
bs.DataSource = dem0;
break;
case 1:
var dem1 = demandes.OrderBy(c => c.Titre_Livre).ToList();
bs.DataSource = dem1;
break;
case 2:
var dem2 = demandes.OrderByDescending(c => c.Date_Prise).ToList();
bs.DataSource = dem2;
break;
case 3:
var dem3 = demandes.OrderByDescending(c => c.Date_Retour).ToList();
bs.DataSource = dem3;
break;
default:
bs.DataSource = demandes;
break;
}
}
dataGridViewTransfert.DataSource = bs;
}
private void txtliivre_TextChanged_1(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
string txt = txtliivre.Text;
if (txt == "")
{
RemplirCombo(); return;
}
var livres = context.livres.Where(c => c.titre.Contains(txt)).Select(c => new
{
id = c.id,
Titre_Livre = c.titre
});
comboLivre.DataSource = livres.ToList();
comboLivre.DisplayMember = "Titre_Livre";
comboLivre.ValueMember = "id";
}
}
private void txteleve_TextChanged_1(object sender, EventArgs e)
{
using (BiblioEntities context = new BiblioEntities())
{
string txt = txteleve.Text;
if (txt == "")
{
RemplirCombo(); return;
}
var eleves = context.eleves.Where(c => c.nom.Contains(txt) || c.prenom.Contains(txt)).Select(c => new
{
id = c.id,
Nom_Eleve = c.nom + " " + c.prenom
});
comboEleve.DataSource = eleves.ToList();
comboEleve.DisplayMember = "Nom_Eleve";
comboEleve.ValueMember = "id";
}
}
void RemplirCombo()
{
using (BiblioEntities context = new BiblioEntities())
{
var eleves = context.eleves.Select(c => new
{
id = c.id,
Nom_Eleve = c.nom + " " + c.prenom
});
comboEleve.DataSource = eleves.ToList();
comboEleve.DisplayMember = "Nom_Eleve";
comboEleve.ValueMember = "id";
var livres = context.livres.Where(c => c.disponibilite == true && c.quantite > 0).Select(c => new
{
id = c.id,
Titre_Livre = c.titre
});
comboLivre.DataSource = livres.ToList();
comboLivre.DisplayMember = "Titre_Livre";
comboLivre.ValueMember = "id";
}
}