public Boolean emprenterOuvrague(Compte compte, string codeOuvrague)
{
try
{
cnx.Open();
MySqlTransaction tran = cnx.BeginTransaction();
MySqlCommand emprenterOuvrague = cnx.CreateCommand();
emprenterOuvrague.Transaction = tran;
emprenterOuvrague.CommandText = RequeteOuvrague.emprinterOuvrague();
emprenterOuvrague.Parameters.Add("@nu", MySqlDbType.VarChar).Value = compte.Nom_utilisteur;
emprenterOuvrague.Parameters.Add("@cdO", MySqlDbType.VarChar).Value = codeOuvrague;
int rowAffected = emprenterOuvrague.ExecuteNonQuery();
MySqlCommand changerEtatOuvrague = cnx.CreateCommand();
changerEtatOuvrague.Transaction = tran;
changerEtatOuvrague.CommandText = RequeteOuvrague.etatEmprenterOuvrague();
changerEtatOuvrague.Parameters.Add("@cd", MySqlDbType.VarChar).Value = codeOuvrague;
rowAffected = changerEtatOuvrague.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message + "-----" + e.StackTrace);
return(false);
}
finally
{
cnx.Dispose();
}
}
public Boolean validerReservation(int numeroEmprente, String codeOuvrague)
{
try
{
cnx.Open();
MySqlTransaction tran = cnx.BeginTransaction();
MySqlCommand validerReservation = cnx.CreateCommand();
validerReservation.Transaction = tran;
validerReservation.CommandText = RequeteOuvrague.validerReservation();
validerReservation.Parameters.Add("@nmsq", MySqlDbType.Int64).Value = numeroEmprente;
validerReservation.ExecuteNonQuery();
MySqlCommand changerEtatOuvrague = cnx.CreateCommand();
changerEtatOuvrague.Transaction = tran;
changerEtatOuvrague.CommandText = RequeteOuvrague.etatEmprenterOuvrague();
changerEtatOuvrague.Parameters.Add("@cd", MySqlDbType.VarChar).Value = codeOuvrague;
changerEtatOuvrague.ExecuteNonQuery();
tran.Commit();
return(true);
}
catch (Exception e)
{
Console.WriteLine(e.Message + "-----" + e.StackTrace);
return(false);
}
finally
{
cnx.Dispose();
}
}
