Esempio n. 1
0
        static void Main(string[] args)
        {
            //string customer = "Generali";
            //double meters = 146.7;
            //double pack = 5; //square meters per package
            //double packPrice = 299.99;

            //double requiredPackages = meters / pack;

            //double ceiledPackages = Math.Ceiling(requiredPackages);

            //double price = ceiledPackages * packPrice;

            //Console.WriteLine("Preventivo: " + price);

            // vorrei un metodo di select che mi restituisca 4 valori.
            // ma i metodi possono restituire un valore solo!
            // quindi un codice come il seguente non esiste!
            // (meters, pack, packPrice, customer) = SelectWithId(3);

            // devo creare delle strutture-dati che INCAPSULANO le informazioni

            Estimate e = SelectWithId(3);

            Print(e);

            Console.Read();

            int    count            = Estimate.numeroDiEstimateInGiro();
            double requiredPackages = e.getRequiredPackages();
        }
Esempio n. 2
0
        static Estimate SelectWithId(int id)
        {
            string connectionString = @"Data Source=TRISRV10\SQLEXPRESS;Initial Catalog=CorsoEuris_Kraus;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False";

            SqlConnection conn = new SqlConnection(connectionString);

            conn.Open();

            SqlCommand command = new SqlCommand();

            command.Connection  = conn;
            command.CommandType = CommandType.Text;

            command.Parameters.Add(new SqlParameter("id", id));
            command.CommandText =
                "select meters, pack, packPrice, customer from Tiles"
                + " where id = @id;";

            Console.WriteLine("La query è: " + command.CommandText);

            SqlDataReader reader = command.ExecuteReader();

            reader.Read();

            Estimate e = new Estimate();

            e.meters    = (double)reader.GetDecimal(0);
            e.pack      = (double)reader.GetDecimal(1);
            e.packPrice = (double)reader.GetDecimal(2);
            e.customer  = reader.GetString(3);

            conn.Close();

            return(e);
        }
Esempio n. 3
0
        static void Print(Estimate e)
        {
            Console.WriteLine("--- Preventivo ---");
            Console.WriteLine($"Cliente: {e.customer}");
            Console.WriteLine($"Metri richiesti: {e.meters}");
            Console.WriteLine($"Metri per package: {e.pack}");
            Console.WriteLine($"Prezzo del singolo package: {e.packPrice}");

            double requiredPackages = e.meters / e.pack;

            Console.WriteLine($"Numero di package richiesti: {requiredPackages}");

            double ceiledPackages = Math.Ceiling(requiredPackages);

            Console.WriteLine($"Numero di package da vendere: {ceiledPackages}");

            double price = ceiledPackages * e.packPrice;

            Console.WriteLine($"PREZZO FINALE: {price}");
        }