using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Shapes;
using Oregon_Trail.Classes;
using System.Data.SQLite;

namespace Oregon_Trail.Windows
{
    /// <summary>
    /// Interaction logic for NewGame.xaml
    /// </summary>
    public partial class NewGame : Window
    {
        public static int GamenumValue;
        public Continue Prev_win;
        public NewGame(int gamenum, Continue prevwin)
        {
            InitializeComponent();
            GamenumValue = gamenum;
            Prev_win = prevwin;
        }

        private void startbutton_Click(object sender, RoutedEventArgs e)
        {
            int i = GamenumValue;
            bool infosaved = false;

            if (leadertextbox.Text != null && professionbox.SelectedItem != null && pass1textbox.Text != null && pass3textbox.Text != null && pass4textbox.Text != null)
            {

                Game.GameList[i].LeaderName = leadertextbox.Text;

                switch (professionbox.SelectedItem.ToString())
                {
                    case "cbi1":
                        Game.GameList[i].LeaderJob = Classes.Enum.Jobs.Farmer;
                        break;
                    case "cbi2":
                        Game.GameList[i].LeaderJob = Classes.Enum.Jobs.Banker;
                        break;
                    case "cbi3":
                        Game.GameList[i].LeaderJob = Classes.Enum.Jobs.Blacksmith;
                        break;
                    case "cbi4":
                        Game.GameList[i].LeaderJob = Classes.Enum.Jobs.Carpenter;
                        break;
                }

                Game.GameList[i].Person1Name = pass1textbox.Text;
                Game.GameList[i].Person2Name = pass2textbox.Text;
                Game.GameList[i].Person3Name = pass3textbox.Text;
                Game.GameList[i].Person4Name = pass4textbox.Text;

                infosaved = true;
                string msg = SaveNewGame(this);
                MessageBox.Show(msg);
            }
            else
            {
                MessageBox.Show("You must fill in all fields!", "Oregon Trail Error MSG", MessageBoxButton.OK);
                infosaved = false;
            }

            if (infosaved == true)
            {
                Store Store_Win = new Store(GamenumValue);
                Store_Win.Show();
                this.Visibility = Visibility.Hidden;
            }
        }

        private void PreviousPage_Click(object sender, RoutedEventArgs e)
        {
            Prev_win.Visibility = Visibility.Visible;
            this.Visibility = Visibility.Hidden;
        }

        static Classes.Enum.Jobs leaderJob;

        private static string SaveNewGame(NewGame Win)
        {
            string leaderName = Win.leadertextbox.Text;
            var job = Win.professionbox.SelectedIndex;
            switch (job)
            {
                case -1:
                    break;
                case 0:
                    leaderJob = Classes.Enum.Jobs.Farmer;
                    break;
                case 1:
                    leaderJob = Classes.Enum.Jobs.Banker;
                    break;
                case 2:
                    leaderJob = Classes.Enum.Jobs.Blacksmith;
                    break;
                case 3:
                    leaderJob = Classes.Enum.Jobs.Carpenter;
                    break;
            }

            string pass1 = Win.pass1textbox.Text;
            string pass2 = Win.pass2textbox.Text;
            string pass3 = Win.pass3textbox.Text;
            string pass4 = Win.pass4textbox.Text;

            SQLiteCommand cmd = new SQLiteCommand();

            cmd.CommandText = "UPDATE games SET leaderName = @lname, leaderJob = @ljob, person1 = @per1, person2 = @per2, person3 = @per3, person4 = @per4 WHERE Gamenum = @gamenum";
            cmd.Parameters.AddWithValue("@lname", leaderName);
            cmd.Parameters.AddWithValue("@ljob", leaderJob.ToString());
            cmd.Parameters.AddWithValue("@per1", pass1);
            cmd.Parameters.AddWithValue("@per2", pass2);
            cmd.Parameters.AddWithValue("@per3", pass3);
            cmd.Parameters.AddWithValue("@per4", pass4);
            cmd.Parameters.AddWithValue("@gamenum", GamenumValue);

            cmd.Connection = new SQLiteConnection("Data Source=oregontrail.sqlite; version=3");
            cmd.Connection.Open();
            cmd.ExecuteNonQuery();
            cmd.Connection.Close();
            string msg = "Completed";
            return msg;
        }
    }
}