public static Conteneur getInstanceConteneur()
{
if (conteneur == null || conteneur.IsDisposed)
{
conteneur = new Conteneur();
}
return(conteneur);
}
public static void calculer(int devisN)
{
try
{
Conteneur.conn.Open();
SqlDataReader sdr = Produit.select(devisN: devisN);
int quantite = 0;
float total = 0;
while (sdr.Read())
{
int qteProd = Convert.ToInt32(sdr["Quantite"]);
quantite += qteProd;
total += qteProd * Convert.ToInt32(sdr["Prix"]);
}
Console.WriteLine(devisN);
Console.WriteLine(quantite);
Console.WriteLine(total);
sdr.Close();
SqlCommand cmd = Conteneur.conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = $"update Devis set Quantite={quantite}, Total=TRY_PARSE('{total.ToString().Replace(',', '.')}' as float using 'en-US') where DevisN={devisN}";
cmd.ExecuteNonQuery();
Devis devis = Conteneur.getInstanceDevis();
if (devis != null)
{
devis.load_metroGrid();
}
}
catch (Exception e)
{
MetroFramework.MetroMessageBox.Show(Conteneur.conteneur, "La modification des champs Quantite et Total du devis est echouée", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Conteneur.conn.Close();
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
Application.Run(Conteneur.getInstanceConteneur());
}
