using System;

public class Program

{

    public static void Main()

    {

    /*

    --(10)--insert into orders values(idorden, fecha de orden, idusuario, estado, idstore);

    insert into ORDERS values(001,'2023-03-06',1455424,'COMPLETE',1);

    --(10)--insert into shipments values(idenvio, isdtore, idcus, direccion, estatus('CANCELLED', 'COMPLETE', 'OPEN', 'PAID', 'REFUNDED', 'SHIPPED','IN-TRANSIT'));

    insert into shipments values(1,1,1,'Calle Manchego 4756','SHIPPED');

    --(aleatorio)--insert into order_items values(idorden, idorderitem, idproducto, preciounitario, cantidad, idenvios);

    insert into ORD_ITEMS values(001,1,100020,1,1);

    */

        int tienda, cliente, valor, idTienda, idOrden, dia, cantidad;

        float costo;

        string[] carnets = new string[] { "5485612","5841245","4854524","8854286","1455424","4525425","1224124","2428424","4282224","8784248","5694253","8542112","8956251","8176929","1745822"};

        string[] estado = new string[] { "CANCELLED","COMPLETE","OPEN","PAID","REFUNDED","SHIPPED"};

        string[] envio = new string[] { "IN-TRANSIT","SHIPPED"};

        string[] geon = new string[] { "Av","Calle","Plaza","Pt","Edf"};

        string[] callen = new string[] { "Las Americas","Libertad","Colon","Valencia","Independencia","La Paz","Santiago","Montenegro","Ballivian","Arce","Pinilla","Murillo","Manchego","Lucio Velasco", "N.Bedregal", "Bahia", "Costanero", "Alfredo gobles" };

        string[] producto = new string[] {"100020","200028","200019","300001","300041","400075","400096","500026","500081","600054"};

        float[] precio = new float[] {51.00f,105.50f,99.99f,60.20f,78.50f,300.00f,380.00f,20.50f,16.30f,30.50f};

        //string[] callen = new string[] { "","","","","",""};

        var random = new Random();

        //random.Next(50,101)

        idTienda = 17;

        idOrden = 11;

        dia = 13;

        for(int i=1; i < 2; i++)

        {

            tienda = random.Next(1,4);

            cliente = random.Next(0,15);

            Console.WriteLine("insert into ORDERS values(" + idOrden +",'03/"+dia+"/23'," + carnets[cliente] + ",'COMPLETE',"+ tienda +");");

            Console.WriteLine("insert into SHIPMENTS values(" + idTienda +","+ tienda +"," + carnets[cliente] + "," + geon[random.Next(0,4)] +" "+ callen[random.Next(0,17)] +" "+ random.Next(1,999) +",'"+ envio[random.Next(0,2)] +"');");

            Console.WriteLine();

            for(int j=1; j < random.Next(5,10);j++)

            {

                valor = random.Next(0,9);

                costo = precio[valor] + random.Next(15,30);

                cantidad = random.Next(1,10);

                //insert into ORD_ITEMS values(001,1,100020,10,5,1);

                //--(aleatorio)--insert into order_items values(idorden, idorderitem, idproducto, preciounitario, cantidad, idenvios);

                Console.WriteLine(" insert into ORD_ITEMS values("+idOrden+","+j+"," + producto[valor] + "," + costo + ","+ cantidad +","+idTienda+");");

                Console.WriteLine();

                Console.WriteLine(" update INVENTORIES");

                Console.WriteLine(" set PRD_INV-="+cantidad+"");

                Console.WriteLine(" WHERE PRD_PRD_id="+producto[valor]+" AND STR_STR_id="+idTienda+";");

                Console.WriteLine();

            }

            idTienda++;

            idOrden++;

            if(i%2==0)

            {

                dia++;

            }

            Console.WriteLine();

        }

    }

}