public Boolean dispoOuvrague(String codeOuvrague) { try { cnx.Open(); MySqlCommand dispoOuvrague = cnx.CreateCommand(); dispoOuvrague.CommandText = RequeteOuvrague.etatDispoOuvrague(); dispoOuvrague.Parameters.Add("@cd", MySqlDbType.VarChar).Value = codeOuvrague; dispoOuvrague.ExecuteNonQuery(); return(true); } catch (Exception e) { return(false); } finally { cnx.Dispose(); } }
public String[] rendreOuvrague(Ouvrague ouvrague, int numEmprente) { List <String> listEmail = new List <String>(); try { cnx.Open(); MySqlTransaction tran = cnx.BeginTransaction(); MySqlCommand dispoOuvrague = cnx.CreateCommand(); dispoOuvrague.Transaction = tran; dispoOuvrague.CommandText = RequeteOuvrague.etatDispoOuvrague(); dispoOuvrague.Parameters.Add("@cd", MySqlDbType.VarChar).Value = ouvrague.Code; dispoOuvrague.ExecuteNonQuery(); MySqlCommand rendreOuvrague = cnx.CreateCommand(); rendreOuvrague.Transaction = tran; rendreOuvrague.CommandText = RequeteOuvrague.terminerEmprente(); rendreOuvrague.Parameters.Add("@nmsq", MySqlDbType.VarChar).Value = numEmprente; rendreOuvrague.ExecuteNonQuery(); tran.Commit(); return(listEmailAttente(ouvrague.Code)); } catch (Exception e) { Console.WriteLine(e.Message + "-----" + e.StackTrace); return(null); } finally { cnx.Dispose(); } }