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