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