public ActionResult Edit(int id = 0)
{
tblJeu jeu = bd.tblJeus.Find(id);
/*var result = from genre in bd.tblGenres
* select new
* {
* genre.idGenre,
* genre.descriptionGenre,
* Checked = ((from jg in bd.JeuGenre where (jg.idJeu == jeu.idJeu)&(jg.idGenre == genre.idGenre) select jg).Count()>0)
* };*/
var checkBoxListGenre = new List <CheckBoxViewModel>();
var checkBoxListTheme = new List <CheckBoxViewModel>();
var checkBoxListClassification = new List <CheckBoxViewModel>();
foreach (tblGenre genre in bd.tblGenres)
{
CheckBoxViewModel newCheckBoxViewModel = new CheckBoxViewModel();
newCheckBoxViewModel.Id = genre.idGenre;
newCheckBoxViewModel.Description = genre.descriptionGenre;
newCheckBoxViewModel.Checked = jeuDansUneListe(genre.tblJeus, jeu);
checkBoxListGenre.Add(newCheckBoxViewModel);
}
foreach (tblTheme theme in bd.tblThemes)
{
CheckBoxViewModel newCheckBoxViewModel = new CheckBoxViewModel();
newCheckBoxViewModel.Id = theme.idTheme;
newCheckBoxViewModel.Description = theme.descriptionTheme;
newCheckBoxViewModel.Checked = jeuDansUneListe(theme.tblJeus, jeu);
checkBoxListTheme.Add(newCheckBoxViewModel);
}
foreach (tblClassification classification in bd.tblClassifications)
{
CheckBoxViewModel newCheckBoxViewModel = new CheckBoxViewModel();
newCheckBoxViewModel.Id = classification.idClassification;
newCheckBoxViewModel.Description = classification.descriptionClassification;
newCheckBoxViewModel.Checked = jeuDansUneListe(classification.tblJeus, jeu);
checkBoxListClassification.Add(newCheckBoxViewModel);
}
var myJeuViewModel = new JeuViewModel();
myJeuViewModel.configurationMinimaleJeu = jeu.configurationMinimaleJeu;
myJeuViewModel.devellopeurJeu = jeu.devellopeurJeu;
myJeuViewModel.descriptionJeu = jeu.descriptionJeu;
myJeuViewModel.nomJeu = jeu.nomJeu;
/*foreach (var genre in result)
* {
* myCheckBoxList.Add(new CheckBoxViewModel { Id = genre.idGenre, Description = genre.descriptionGenre, Checked = genre.Checked });
* }*/
myJeuViewModel.lesGenres = checkBoxListGenre;
myJeuViewModel.lesThemes = checkBoxListTheme;
myJeuViewModel.lesClassifications = checkBoxListClassification;
return(View(myJeuViewModel));
}
public ActionResult Edit(JeuViewModel j)
{
/*tblJeu jeu = bd.tblJeus.Find(j.idJeu);
* jeu.devellopeurJeu = j.devellopeurJeu;
* jeu.descriptionJeu = j.descriptionJeu;
* jeu.configurationMinimaleJeu = j.configurationMinimaleJeu;
* jeu.nomJ0eu = j.nomJeu;
*
* foreach (tblClassification cl in bd.tblClassifications)
* {
* foreach (tblClassification CL in jeu.tblClassifications)
* {
* if(CL.idClassification == cl.idClassification)
* {
* bd.tblClassifications.Find(cl.idClassification).tblJeus.Remove(jeu);
* }
* }
* }
*
* foreach (tblTheme th in bd.tblThemes)
* {
* foreach (tblTheme TH in jeu.tblThemes)
* {
* if (TH.idTheme == th.idTheme)
* {
* bd.tblThemes.Find(th.idTheme).tblJeus.Remove(jeu);
* }
* }
* }
*
* foreach (tblGenre ge in bd.tblGenres)
* {
* foreach (tblGenre GE in jeu.tblGenres)
* {
* if (GE.idGenre == ge.idGenre)
* {
* bd.tblGenres.Find(ge.idGenre).tblJeus.Remove(jeu);
* }
* }
* }
*
* foreach (tblJeu J in bd.tblJeus)
* {
* if (J.idJeu == j.idJeu)
* {
* J.tblGenres.Clear();
* J.tblClassifications.Clear();
* J.tblThemes.Clear();
* }
* }
*
* foreach (var genre in j.lesGenres)
* {
* if(genre.Checked)
* {
*
* tblGenre newGenre = new tblGenre();
* newGenre.descriptionGenre = genre.Description;
* newGenre.idGenre = genre.Id;
*
* bd.tblGenres.Find(genre.Id).tblJeus.Add(jeu);
* bd.tblJeus.Find(jeu.idJeu).tblGenres.Add(newGenre);
* }
* }
*
* foreach (var cl in j.lesClassifications)
* {
* if (cl.Checked)
* {
*
* tblClassification newCL = new tblClassification();
* newCL.descriptionClassification = cl.Description;
* newCL.idClassification = cl.Id;
*
* bd.tblClassifications.Find(cl.Id).tblJeus.Add(jeu);
* bd.tblJeus.Find(jeu.idJeu).tblClassifications.Add(newCL);
* }
* }
*
* foreach (var th in j.lesThemes)
* {
* if (th.Checked)
* {
* tblTheme newTH = new tblTheme();
* newTH.descriptionTheme = th.Description;
* newTH.idTheme = th.Id;
*
* bd.tblThemes.Find(th.Id).tblJeus.Add(jeu);
* bd.tblJeus.Find(jeu.idJeu).tblThemes.Add(newTH);
* }
* }
* /*foreach (tblClassification cl in bd.tblClassifications)
* {
* foreach (tblClassification CL in jeu.tblClassifications)
* {
* if (CL.idClassification == cl.idClassification)
* {
* bd.tblClassifications.Find(cl.idClassification).tblJeus.Remove(jeu);
* }
* }
* }*/
//bd.Entry(jeu).State = System.Data.Entity.EntityState.Modified;*/
try
{
tblJeu jeu = bd.tblJeus.Find(j.idJeu);
jeu.devellopeurJeu = j.devellopeurJeu;
jeu.descriptionJeu = j.descriptionJeu;
jeu.configurationMinimaleJeu = j.configurationMinimaleJeu;
jeu.nomJeu = j.nomJeu;
jeu.tag = jeu.nomJeu + jeu.configurationMinimaleJeu + jeu.descriptionJeu + jeu.devellopeurJeu;
bd.Entry(jeu).State = System.Data.Entity.EntityState.Modified;
bd.SaveChanges();
return(RedirectToAction("Index"));
}
catch
{
return(View(j));
}
}
