using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace VideoGameWiki
{
    public partial class _Default : System.Web.UI.Page
    {
        private VideoGamesWikiContainer entities = new VideoGamesWikiContainer();

        private int currentId = 0;

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                RefreshGrid();

                ddlStud.DataTextField = "Name";
                ddlStud.DataValueField = "Id";
                ddlStud.DataSource = entities.Studios.ToList();
                ddlStud.DataBind();

                ShowFirstVideoGame();
            }

        }

        private void ShowFirstVideoGame()
        {
            VideoGames1 vidgame = entities.VideoGames1.FirstOrDefault();
            PopulateForm(vidgame);
        }

        private void PopulateForm(VideoGames1 vidgame)
        {
            hidId.Value = vidgame.Id.ToString();
            txtName.Text = vidgame.Name;
            txtDescr.Text = vidgame.Description;
            txtCoverImage.Text = vidgame.CoverImage;
            txtReldate.Text = vidgame.ReleaseDate.ToString();
            ddlStud.SelectedValue = vidgame.Studios.FirstOrDefault().Id.ToString();
        }

        private void RefreshGrid()
        {
            gvVidGame.DataSource = entities.VideoGames1.ToList();
            gvVidGame.DataBind();
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            VideoGames1 vidgame = new VideoGames1();
            vidgame.Name = txtName.Text;
            vidgame.ReleaseDate = txtReldate.Text;
            vidgame.CoverImage = txtCoverImage.Text;
            vidgame.Description = txtDescr.Text;

            int studId = Convert.ToInt32(ddlStud.SelectedValue);
            Studio stud = entities.Studios.FirstOrDefault(p => p.Id == studId);

            vidgame.Studios.Add(stud);

            entities.VideoGames1.Add(vidgame);

            entities.SaveChanges();

            RefreshGrid();


        }

        protected void btnNext_Click(object sender, EventArgs e)
        {
            int currentId = Convert.ToInt32(hidId.Value);
            VideoGames1 vidgame = entities.VideoGames1.FirstOrDefault(b => b.Id > currentId);

            if (vidgame != null)
            {
                PopulateForm(vidgame);
            }
        }

        protected void btnPrev_Click(object sender, EventArgs e)
        {
            int currentId = Convert.ToInt32(hidId.Value);
            VideoGames1 vidgame = entities.VideoGames1.ToList().LastOrDefault(b => b.Id < currentId);

            if (vidgame != null)
            {
                PopulateForm(vidgame);
            }
        }

        protected void Btn_delete(object sender, EventArgs e)
        {
            int currentId = Convert.ToInt32(hidId.Value);
            VideoGames1 vidgame = entities.VideoGames1.ToList().FirstOrDefault(b => b.Id > currentId);
            int studId = Convert.ToInt32(ddlStud.SelectedValue);
            Studio stud = entities.Studios.ToList().FirstOrDefault(b => b.Id > studId);
            vidgame.Studios.Remove(stud);
            entities.VideoGames1.Remove(vidgame);
            entities.SaveChanges();

            RefreshGrid();
        }
    }
}