using System;
using System.Collections.Generic;
using System.Data.SqlTypes;


namespace GeneratorManager
{

    public class Gen
    {
        private static readonly Random Random = new Random();
        private static readonly DateTime LocalDate = DateTime.Now;
        //public static DateTime Datenow = new DateTime(localDate.Year,localDate.Month,localDate.Day);

        private static int Random1(List<String> a)
        {
            var x = Random.Next(a.Count);
            return x;
        }
        private static int Yearrandom(int choose)
        {
            switch (choose)
            {
                case 1:
                    {
                        var x = Random.Next(1960, ((int)LocalDate.Year - 30));
                        return x;
                    }
                case 2:
                    {
                        var x = Random.Next(1, 12);
                        return x;
                    }
            }
            return 0;
            //var x = random.Next(1960,((int)localDate.Year-30));
            //return x;
        }

        private static int Dayrandom(int year, int month)
        {
            if (month == 1 || month == 3 || month == 5 || month == 7 || month == 8 || month == 10 || month == 12)
            {
                var x = Random.Next(1, 31);
                return x;
            }
            if (month == 4 || month == 6 || month == 9 || month == 11)
            {
                var x = Random.Next(1, 30);
                return x;
            }
            if (month == 2 && year % 4 == 0)
            {
                var x = Random.Next(1, 29);
                return x;
            }
            if (month == 2 && year % 4 > 0)
            {
                var x = Random.Next(1, 28);
                return x;
            }
            return 0;
        }

        [Microsoft.SqlServer.Server.SqlFunction]
        public static SqlBoolean WasPlayer()
        {
            Random rng = new Random();
            SqlBoolean randomBool = rng.Next(0, 1)>-1;
            return randomBool;
        }
        public static SqlString Date()
        {
            int rok, miesiac, dzien;
            string mie, dzie;
            rok = Yearrandom(1);
            miesiac = Yearrandom(2);
            dzien = Dayrandom(rok, miesiac);
            if (miesiac < 10)
            {
                mie = "0" + miesiac.ToString();
            }
            else
            {
                mie = miesiac.ToString();
            }
            if (dzien < 10)
            {
                dzie = "0" + dzien.ToString();
            }
            else
            {
                dzie = dzien.ToString();
            }
            SqlString data = rok.ToString() + "-" + mie + "-" + dzie;
            return data;
        }
    }
}