using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Finisar.SQLite;

namespace Live_Scoring_V1
{
	class Events
	{

		public int CEID { get; set; }

		public string CommName { get; set; }

		public int position { get; set; }

		public int type { get; set; }

		public int Subs { get; set; }

		public int SubsRequired { get; set; }

		public int Card { get; set; }

		public string Color { get; set; }
		public int Group { get; set; }
		public int Session { get; set; }
		
		public Events GetEvent(int CEID)
		{

			Events Evts = new Events();
			SQLiteDataReader DataReader = null;
			SQLiteConnection sqlite_conn;
			SQLiteCommand sqlite_cmd;
            string dbPath = (Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)) + "\\Sideline Manager\\";

            sqlite_conn = new SQLiteConnection("Data Source="+ dbPath +"Footprint.db;Version=3;");

			sqlite_conn.Open();


			sqlite_cmd = sqlite_conn.CreateCommand();
			
				sqlite_cmd.CommandText = "SELECT * FROM Events Where CEID ='"+ CEID + "' ";
			

			using (DataReader = sqlite_cmd.ExecuteReader())
			{
				while (DataReader.Read())
				{
					int Session = 0;
					try
					{
						Session = Convert.ToInt32(DataReader["Session"]);
					}
					catch { }
					Evts.CEID = Convert.ToInt32(DataReader["CEID"]);
					Evts.CommName = Convert.ToString(DataReader["CommName"]);
					Evts.position = Convert.ToInt32(DataReader["position"]);
					Evts.type = Convert.ToInt32(DataReader["type"]);
					Evts.Subs = Convert.ToInt32(DataReader["Subs"]);
					Evts.SubsRequired = Convert.ToInt32(DataReader["SubsRequired"]);
					Evts.Card = Convert.ToInt32(DataReader["Card"]);
					Evts.Color = Convert.ToString(DataReader["Color"]);
					Evts.Group = Convert.ToInt32(DataReader["Groups"]);
					Evts.Session = Session;
					


				}

			}
			sqlite_conn.Close();
			
			return Evts;

		}
		public List<Events> GetEvents(int Por)
		{

			List<Events> List = new List<Events>();
			SQLiteDataReader DataReader = null;
			SQLiteConnection sqlite_conn;
			SQLiteCommand sqlite_cmd;
            string dbPath = (Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)) + "\\Sideline Manager\\";

            sqlite_conn = new SQLiteConnection("Data Source="+ dbPath +"Footprint.db;Version=3;");

			sqlite_conn.Open();


			sqlite_cmd = sqlite_conn.CreateCommand();
			if (Por == 1)
			{

				sqlite_cmd.CommandText = "SELECT * FROM Events   WHERE Session !=1 ";
			}
			else
			{
				sqlite_cmd.CommandText = "SELECT * FROM Events Where CEID !=53 AND Session !=1 ";
			}

			using (DataReader = sqlite_cmd.ExecuteReader())
			{
				while (DataReader.Read())
				{
					string Cards = (DataReader["Card"]).ToString();
					if (Cards=="") { Cards = "0"; }

					Events Evts = new Events();
					Evts.CEID = Convert.ToInt32(DataReader["CEID"]);
					Evts.CommName = Convert.ToString(DataReader["CommName"]);
					Evts.position = Convert.ToInt32(DataReader["position"]);
					Evts.type = Convert.ToInt32(DataReader["type"]);
					Evts.Subs = Convert.ToInt32(DataReader["Subs"]);
					Evts.SubsRequired = Convert.ToInt32(DataReader["SubsRequired"]);
					Evts.Card = Convert.ToInt32(Cards);
					Evts.Color = Convert.ToString(DataReader["Color"]);
					Evts.Group = Convert.ToInt32(DataReader["Groups"]);
					Console.WriteLine("Line: " + Convert.ToString(Evts.CEID));

					if (Evts.CEID != 56 && Evts.CEID != 57)
					{
                        List.Add(Evts);
                    }					
				}
			}
			sqlite_conn.Close();
			Console.WriteLine("Request DATA: " + Convert.ToString(List));
			return List;

		}






		








	}
}