using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;

namespace MagusEvents
{
    class Zones
    {
		public int ZID { get; set; }
		public int AID { get; set; }
		public int Number { get; set; }
		public string Name { get; set; }
		public string Color { get; set; }
		public int Hidden { get; set; }
		public string FromTime { get; set; }
		public string ToTime { get; set; }
		public int Lock { get; set; }
		public int Active { get; set; }
		public string Icon { get; set; }
		public int ZTID { get; set; }
		

		public  Zones GetRow(string ID)
		{
			Zones Zone = new Zones();


			Database Data = new Database();
			
			string sql = "SELECT * FROM Zones WHERE ZID = '" + ID + "' ";
			
			Zones DataReader = Data.GetZone(sql);
			Zone.ZID = DataReader.ZID;
			Zone.AID = DataReader.AID;
			Zone.Number = DataReader.Number;
			Zone.Hidden = DataReader.Hidden;
			Zone.Lock = DataReader.Lock;
			Zone.Active = DataReader.Active;
			Zone.Icon = DataReader.Icon;
			Zone.ZTID = DataReader.ZTID;
			Zone.Name = DataReader.Name;
			Zone.Color = DataReader.Color;
			Zone.FromTime = DataReader.FromTime;
			Zone.ToTime = DataReader.ToTime;

			return Zone;
		}

		public List<Zones> GetActive(string ID)
		{
		
			Database Data = new Database();
			

			List<Zones> DataReader = Data.GetActiveZones(ID);
			

			return DataReader;
		}

		public List<Zones> GetActiveByArray(string IDs,string AID)
		{

			Database Data = new Database();


			List<Zones> DataReader = Data.GetActiveZonesByArray(IDs, AID);


			return DataReader;
		}
		public List<Zones> GetActiveByArrayLocked(string IDs, string AID)
		{

			Database Data = new Database();


			List<Zones> DataReader = Data.GetActiveZonesByArrayLocked(IDs, AID);


			return DataReader;
		}

		public List<Zones> GetByArray(string IDs,int hidden)
		{

			Database Data = new Database();


			List<Zones> DataReader = Data.GetZonesByArray(IDs, hidden);


			return DataReader;
		}

	}
}