using System;

​

public class Program

{

    public static void Main()

    {

        var base0 = "INSERT INTO instance_emergency (user_id, entry_date) VALUES (";

        var base1 = "INSERT INTO instance_emergency (user_id, entry_date, exit_date) VALUES (";

        var stringfinal = "";

        Random gen = new Random();

        DateTime start = new DateTime(2019, 6, 1);

        DateTime end = new DateTime(2019, 7, 6);

        int range = (end - start).Days;

        for (int i = 0; i < 300; i++)

        {

            int booleleccion = gen.Next(2);

            string horas = gen.Next(24) + ":" + gen.Next(60) + ":" + gen.Next(60);

            var fechadd = start.AddDays(gen.Next(range)).ToString("yyyy-MM-dd") + " " + horas;

            if (booleleccion == 0)

            {

                stringfinal = base0;

                int binario = gen.Next(2);

                string otro0 = "1, '2019-01-03 5:26:44');";

                stringfinal = stringfinal + gen.Next(1, 21)+",'"+fechadd+"');";

                Console.WriteLine(stringfinal);

            }

​

            if (booleleccion == 1)

            {

                string otro1 = "1, '2019-01-03 5:26:44', '2019-01-03 6:26:44');";

                stringfinal = base1;

                string horas2 = gen.Next(21, 24) + ":" + gen.Next(60) + ":" + gen.Next(60);

                string fechadd2 = fechadd.Substring(0, fechadd.Length - horas.Length) + horas2;

                stringfinal = stringfinal + gen.Next(1, 21)+",'"+fechadd+"','"+fechadd2+"');";

                Console.WriteLine(stringfinal);

            }

        }

    }

}