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();
}
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);
}
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}");
}