/// <summary>
    /// Given a player's Genre and the Genre of their attack, determines what Same Type Attack Bonus the player will get.
    /// </summary>
    /// <param name="ofPlayer">The Genre of the player.</param>
    /// <param name="ofAttack">The Genre of the weapon held by that player</param>
    /// <returns>Some bonus/penalty based on the inputs.</returns>
    public static float GetSameTypeBonus(Genre ofPlayer, Genre ofAttack)
    {
        switch (ofPlayer)
        {
            // Each case returns a STAB bonus based on how the attack's type compares to the user's.
            // Same type results in a 1.7x mult, the type that either counters or is countered by the player's type results
            // in a 0.6x mult, and the last "neutral" type results in a 1x mult (no change).
            case Genre.Fantasy:
                if(ofAttack == Genre.Fantasy)
                { return m_positiveSTABBonus; }
                else
                { return m_neutralSTABBonus; }

            case Genre.GraphicNovel:
                if(ofAttack == Genre.GraphicNovel)
                { return m_positiveSTABBonus; }
                else
                { return m_neutralSTABBonus; }

            case Genre.Horror:
                if (ofAttack == Genre.Horror)
                { return m_positiveSTABBonus; }
                else
                { return m_neutralSTABBonus; }

            case Genre.SciFi:
                if (ofAttack == Genre.SciFi)
                { return m_positiveSTABBonus; }
                else 
                { return m_neutralSTABBonus; }

            default:
                return 1f;
        }
    }

        public Genre Update(Genre genre)
        {
            dbContext.Entry(genre).State = EntityState.Modified;
            dbContext.SaveChanges();

            return genre;
        }

 protected void btnAdd_Click(object sender, EventArgs e)
 {
     bool isAlreadyExists;
     using (var context = new MyMoviesContext())
     {
         var genre = new Genre
         {
             Name = tbName.Text,
         };
         isAlreadyExists = context.Genres.FirstOrDefault(x => x.Name == genre.Name) != null;
         if (!isAlreadyExists)
         {
             context.Genres.Add(genre);
             context.SaveChanges();
         }
     }
     if (isAlreadyExists)
     {
         Response.Redirect(Request.Url.AbsoluteUri.Substring(0,
             Request.Url.AbsoluteUri.Count() - Request.Url.Query.Count()) + "?genreAction=exist");
     }
     else
     {
         Response.Redirect("~/Default.aspx");
     }
 }

        public void ShouldCreateGenreWithArtists()
        {
            Genre savedGenre = new Genre { Name = "Pop" };
            List<Artist> artists = new List<Artist> {
                    new Artist { Name = "1" },
                    new Artist { Name = "2" }
                };
            savedGenre.AddArtists(artists);
            Session.SaveOrUpdate(savedGenre);
            m_uow.Commit();
            Session.Clear();

            Genre retrievedGenre = Session.Get<Genre>(1);

            Assert.AreNotEqual(null, retrievedGenre);
            Assert.IsFalse(ReferenceEquals(savedGenre, retrievedGenre));
            Assert.AreEqual(savedGenre.Name, retrievedGenre.Name);
            Assert.AreEqual(savedGenre.Artists.Count, retrievedGenre.Artists.Count);
            Assert.IsFalse(ReferenceEquals(savedGenre.Artists[0], retrievedGenre.Artists[0]));
            Assert.AreEqual(savedGenre.Artists[0].Name, retrievedGenre.Artists[0].Name);
            Assert.IsFalse(ReferenceEquals(savedGenre.Artists[1], retrievedGenre.Artists[1]));
            Assert.AreEqual(savedGenre.Artists[1].Name, retrievedGenre.Artists[1].Name);

            //new PersistenceSpecification<Genre>(Session)
            //    .CheckProperty(g => g.Id, 1) //identity starts at 1 - can't reset to zero
            //    .CheckProperty(g => g.Name, "Genre")
            //    .CheckList(g => g.Artists, artists, (g, a) => g.AddArtist(a))
            //    .VerifyTheMappings();
        }

        public Genre Create(Genre genre)
        {
            dbContext.Genres.Add(genre);
            dbContext.SaveChanges();

            return genre;
        }

        public void TestGenreDelete()
        {
            using (var ctx = new CDCatalogEntities())
            {
                //Test init
                Genre g = new Genre();
                g.GenreID = 0;  // auto incremented and set by add
                g.GenreName = "Test Genre W6YderKT";
                //add it to the context and save to database
                ctx.Genres.Add(g);
                ctx.SaveChanges();

                //Find the list of "Test Genre"
                //in case duplicates were added in the previous tests, delete them all
                var list = ctx.Genres
                .Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
                .Where(n => n.GenreID > 1000);

                ctx.Genres.RemoveRange(list);
                int count = ctx.SaveChanges();
                Assert.IsTrue(count > 0, "No Record Deleted");

                //Test clean-up (none)

            }
        }

 public Movie()
 {
     Genres = new Genre[0];
     ProductionCompanies = new ProductionCompanyInfo[0];
     ProductionCountries = new Country[0];
     SpokenLanguages = new Language[0];
 }

        public void TestGenreAdd()
        {
            //create a new context
            using (var ctx = new CDCatalogEntities())
            {
                //Test init

                //Create a test genre
                Genre g = new Genre();
                g.GenreID = 0;  // auto incremented and set by add
                g.GenreName = "Test Genre W6YderKT";
                //add it to the context
                ctx.Genres.Add(g);
                //verify that records were changed
                int count = ctx.SaveChanges();
                Assert.IsTrue(count > 0 && g.GenreID > 0, "No Records Changed");

                //Test clean-up
                if (count > 0)
                {
                    var list = ctx.Genres
                        .Where(n => n.GenreName.ToLower().Equals("test genre w6yderkt"))
                        .Where(n => n.GenreID > 0);

                    ctx.Genres.RemoveRange(list);
                    ctx.SaveChanges();
                }
            }
        }

		public async Task<Genre> GetGenres( CancellationToken cancellationToken )
		{
			if( _genres == null )
			{
				DateTime cacheModificationDate = await _dataCacheService.GetItemModificationDate( CacheItemName );

				if( (DateTime.Now - cacheModificationDate) < TimeSpan.FromDays( CacheAgeInDays ) )
				{
					try
					{
						_genres = _dataCacheService.GetItem<Genre>( CacheItemName );
					}
					catch (Exception ex)
					{
					    Debug.WriteLine(ex.Message);
					}
				}

				if( _genres == null )
				{
					_genres = await _client.GetGenres( cancellationToken );

					_dataCacheService.PutItem<Genre>( _genres, CacheItemName, cancellationToken );
				}
			}

			return _genres;
		}

        public Story Create(string storyName, string creatorId, IEnumerable<string> genreNames)
        {
            var existingGenres = this.genreRepository.All()
                .Where(x => genreNames.Contains(x.Name))
                .ToList();

            foreach (var genre in genreNames)
            {
                if (!existingGenres.AsQueryable().Select(x => x.Name).Contains(genre))
                {
                    var newGenre = new Genre
                    {
                        Name = genre
                    };

                    existingGenres.Add(newGenre);
                    this.genreRepository.Add(newGenre);
                }
            }

            this.genreRepository.Save();

            var story = new Story
            {
                AuthorId = creatorId,
                Name = storyName,
                Genres = existingGenres
            };

            this.storyRepository.Add(story);
            this.storyRepository.Save();

            return this.storyRepository.All()
                .FirstOrDefault(x => x.Name == story.Name);
        }

 public void AddGenre(GenreDto dto)
 {
     Genre entity = new Genre();
     entity.Name = dto.Name;
     _genreRepository.Add(entity);
     _genreRepository.Save();
 }

        public static Boolean delete(Genre genre)
        {
            Boolean isDelete = false;
            //Connection
            ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"];
            SqlConnection connection = new SqlConnection(connectionStringSettings.ToString());

            String requete = @"DELETE FROM genre WHERE Identifiant = @Identifiant ; ";

            SqlCommand commande = new SqlCommand(requete, connection);

            commande.Parameters.AddWithValue("Identifiant", genre.Identifiant);

            try
            {
                connection.Open();
                commande.ExecuteNonQuery();
                isDelete = true;
            }

            catch (Exception)
            {
                isDelete = false;
            }

            finally
            {
                connection.Close();
            }

            return isDelete;
        }

 public Author(string aFirstName, string aLastName, Genre aGenre)
     : this()
 {
     FirstName = aFirstName;
     LastName = aLastName;
     Genre = aGenre;
 }

 public void OnRoomMusicChange(Genre roomGenre)
 {
     foreach (IMusicEventListener listener in IterateListeners<IMusicEventListener>())
     {
         listener.OnRoomMusicChange(roomGenre);
     }
 }

        public IActionResult Create(
            string title,
            Genre genre,
            DateTime releaseDate,
            string description,
            decimal price,
            bool preorder)
        {
            var modifiedReleaseDate = releaseDate;
            if (releaseDate == null)
            {
                modifiedReleaseDate = DateTime.Today;
            }

            var movie = new Movie
            {
                Title = title,
                Genre = genre,
                ReleaseDate = modifiedReleaseDate,
                Description = description,
                Price = price,
                Preorder = preorder,
            };

            TryValidateModel(movie);
            if (ModelState.IsValid)
            {
                _context.AddMovie(movie);
                _context.SaveChanges();

                return RedirectToAction(actionName: nameof(Index));
            }

            return View(movie);
        }

        private void addSongButton_Click(object sender, EventArgs e)
        {
            var repository = new CDCatalogRepository();
            var formHelper = new FormHelper();

            if (!formHelper.TextBoxHasContents(addSongTxtBoxSongGenre))
            {
                MessageBox.Show("Please enter a genre.", "Input validation error");
                addSongTxtBoxSongGenre.Focus();
            }
            else
            {
                var newGenre = addSongTxtBoxSongGenre.Text.Trim();
                var genres = repository.SearchGenreByGenreName(newGenre);

                if (genres.Count > 0)
                {
                    MessageBox.Show("You wanted to add " + newGenre + ", but " + genres[0].GenreName + " already exsists.", "Genre must be unique");
                    addSongTxtBoxSongGenre.Focus();
                }
                else
                {
                    CreatedGenre = repository.CreateGenre(addSongTxtBoxSongGenre.Text.Trim());
                    Close();
                }
            }
        }

 public Film(string name, Genre genre, int views, int price)
 {
     Name = name;
     FilmGenre = genre;
     Views = views;
     TicketPrice = price;
 }

 public StandardCombatInstance(ResourceAsset playerTeamPrefab, ResourceAsset enemyTeamPrefab, Genre combatGenre, int combatLevel)
 {
     m_playerTeamPrefab = playerTeamPrefab;
     m_enemyTeamPrefab = enemyTeamPrefab;
     m_combatGenre = combatGenre;
     m_combatLevel = combatLevel;
 }

        public static Genre CreateGenre(Genre genre)
        {
            ConnectionStringSettings connectionStringSettings = ConfigurationManager.ConnectionStrings["EntretienSPPPConnectionString"];
            SqlConnection connection = new SqlConnection(connectionStringSettings.ToString());

            String requete = @"Insert INTO genre(libelle) Values (@libelle); SELECT SCOPE_IDENTITY() ; ";

            SqlCommand commande = new SqlCommand(requete, connection);

            commande.Parameters.AddWithValue("libelle",genre.libelle);

              try
            {
                connection.Open();
                Decimal IDENTIFIANTDERNIERAJOUT = (Decimal)commande.ExecuteScalar();
                return GenreDB.Get(Int32.Parse(IDENTIFIANTDERNIERAJOUT.ToString()));

            }

            catch (Exception)
            {
                throw;
            }

            finally
            {
                connection.Close();
            }
        }

        //
        // GET: /Store/Browse/

        public ActionResult Browse()
        {
            //return "Return from Store.Browse";

            /*
            String message = "Store.Browse, Genre = " +
                Server.HtmlEncode(Request.QueryString["Genre"]);
            return Server.HtmlEncode(message);
            //*/

            string genreName = Server.HtmlEncode(Request.QueryString["Genre"]);
            
            var genre = new Genre
            {
                Name = genreName,
            };

            var album = new List<Album>();

            album.Add(new Album { Title = genreName + "Album 1" });
            album.Add(new Album { Title = genreName + "Album 2" });
            album.Add(new Album { Title = genreName + "Album 3" });

            var viewModel = new StoreBrowseViewModel
            {
                genre = genre,
                albums = album
            };

            return View(viewModel);
            

        }