public static bool ExecuteSqlWithTransaction(ref string erreur, string Connect, List <SqlCommand> cmds)
{
ConnexionDB.MaConn = new SqlConnection(Connect);
ConnexionDB.connect();
transaction = MaConn.BeginTransaction("SampleTransaction");
try
{
//foreach (var sql in cm)
//{
// sqlCmd.CommandText = sql;
// sqlCmd.CommandType = CommandType.Text;
// sqlCmd.ExecuteNonQuery();
//}
foreach (var cmd in cmds)
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd = MaConn.CreateCommand();
sqlCmd.Transaction = transaction;
sqlCmd.CommandText = cmd.CommandText;
foreach (SqlParameter p in cmd.Parameters)
{
sqlCmd.Parameters.AddWithValue(p.ParameterName, p.Value);
}
sqlCmd.ExecuteNonQuery();
}
transaction.Commit();
ConnexionDB.deconnect();
return(true);
}
catch (Exception ex)
{
Console.WriteLine();
try
{
transaction.Rollback();
transaction.Dispose();
erreur = ex.Message;
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
ConnexionDB.deconnect();
return(false);
}
}
public static bool ExecuteSqlWithTransactionbluck(ref string erreur, string Connect, string table, DataRow[] rowArray)
{
ConnexionDB.MaConn = new SqlConnection(Connect);
ConnexionDB.connect();
transaction = MaConn.BeginTransaction("SampleTransaction");
try
{
using (SqlBulkCopy bulkCopy = new SqlBulkCopy(Connect))
{
bulkCopy.DestinationTableName = table;
//try
//{
// Write the array of rows to the destination.
bulkCopy.WriteToServer(rowArray);
//}
//catch (Exception ex)
//{
// Console.WriteLine(ex.Message);
//}
}
transaction.Commit();
ConnexionDB.deconnect();
return(true);
}
catch (Exception ex)
{
Console.WriteLine();
try
{
transaction.Rollback();
transaction.Dispose();
erreur = ex.Message;
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
ConnexionDB.deconnect();
return(false);
}
}
// RECIP /INIT des fichiers de config
#region Fichier de config d'entrée environnement et client a conserver.
private XmlEnvironnementSession GetXmlEnvironnementSession(string sPath)
{
XmlEnvironnementSession xmlEnvironnementSession = null;
if (File.Exists(sPath))
{
xmlEnvironnementSession = FastSerialisation.Instance().GetSaveStructInCurrentDirectory <XmlEnvironnementSession>(sPath);
return(xmlEnvironnementSession);
}
else
{
GlobalLog.Instance().AjouteLog("SingleSessionConfig", "@GetXmlEnvironnementSession : Path n'EXISTE PAS : "******"", listEnvironnementExecutionDefault = new List <EnvironnementExecution>()
};
EnvironnementExecution environnementExecution = new EnvironnementExecution()
{
IsDefault = true, NomEnvironnement = "DEV1", listConnexionDB = new List <ConnexionDB>()
};
ConnexionDB connexionDB = new ConnexionDB()
{
NomConnectionBDD = "BDDProcess", ToConnect = true, ModeConnectionString = true, NomServeur = "FAUVEL-PORTABLE\\SQLEXPRESS", NomDB = "XXPackingProcessV3", NomModel = "BdModel.ModelDBxxProcessV3", ExtraConnectionStringOdbc = ""
};
environnementExecution.listConnexionDB.Add(connexionDB);
environnementExecution.connexionServeurPrint = new ConnexionServeurPrint()
{
ToConnect = true, sServeurWCF = "127.0.0.1", pathConfigSerciceMoteur = "D:\\ServiceMoteurImpression\fichierini.config", IsMoteurOnThisHost = true, VersionGestionnaire = "V1", ListNomImprimanteToConnect = new List <string>()
};
environnementExecution.configWebInterface = new ConfigWebInterface()
{
ListeMenuVisibles = new List <string>(), ListeShortButton = new List <ConfigShortButton>()
};
environnementExecution.configWebInterface.ListeMenuVisibles.Add("showProcess");
environnementExecution.configWebInterface.ListeMenuVisibles.Add("showPrinterData");
environnementExecution.configWebInterface.ListeShortButton.Add(new ConfigShortButton()
{
BtnName = "TPrint", BtnClick = "Printer"
});
xmlEnvironnementSession.listEnvironnementExecutionDefault.Add(environnementExecution);
string statutMes = FastSerialisation.Instance().SaveStructInCurrentDirectory <XmlEnvironnementSession>(xmlEnvironnementSession, sPath);
SingleLogFileAsXml.Instance().AjouteLog("SingleSessionConfig", "@GetXmlEnvironnementSession : Config n'existe pas : creation : " + sPath + " : " + statutMes);
return(xmlEnvironnementSession);
}
//public static bool ExecuteSqlWithTransaction(List<string> listSql, string Connect, ListBox ListLogTXT)
//{
// ConnexionDB.MaConn = new SqlConnection(Connect);
// ConnexionDB.connect();
// transaction = MaConn.BeginTransaction("SampleTransaction");
// SqlCommand sqlCmd = new SqlCommand();
// sqlCmd = MaConn.CreateCommand();
// sqlCmd.Transaction = transaction;
// try
// {
// foreach (var sql in listSql)
// {
// sqlCmd.CommandText = sql;
// sqlCmd.CommandType = CommandType.Text;
// sqlCmd.ExecuteNonQuery();
// }
// transaction.Commit();
// ConnexionDB.deconnect();
// return true;
// }
// catch (Exception ex)
// {
// Console.WriteLine();
// ListLogTXT.Items.Add("Erreur Dintégration !! "+ ex.Message );
// try
// {
// transaction.Rollback();
// transaction.Dispose();
// }
// catch (Exception ex2)
// {
// // This catch block will handle any errors that may have occurred
// // on the server that would cause the rollback to fail, such as
// // a closed connection.
// Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
// Console.WriteLine(" Message: {0}", ex2.Message);
// }
// ConnexionDB.deconnect();
// return false;
// }
//}
public static bool ExecuteSqlWithTransaction(List <string> listSql, string Connect)
{
ConnexionDB.MaConn = new SqlConnection(Connect);
ConnexionDB.connect();
transaction = MaConn.BeginTransaction("SampleTransaction");
SqlCommand sqlCmd = new SqlCommand();
sqlCmd = MaConn.CreateCommand();
sqlCmd.Transaction = transaction;
try
{
foreach (var sql in listSql)
{
sqlCmd.CommandText = sql;
sqlCmd.CommandType = CommandType.Text;
sqlCmd.ExecuteNonQuery();
}
transaction.Commit();
ConnexionDB.deconnect();
return(true);
}
catch (Exception ex)
{
Console.WriteLine();
try
{
transaction.Rollback();
transaction.Dispose();
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
ConnexionDB.deconnect();
return(false);
}
}
private XmlConfigEnvironnementClient GetXmlConfigEnvironnementClient(string sPath)
{
XmlConfigEnvironnementClient xmlConfigEnvironnementClient = null;
if (File.Exists(sPath))
{
xmlConfigEnvironnementClient = FastSerialisation.Instance().GetSaveStructInCurrentDirectory <XmlConfigEnvironnementClient>(sPath);
// Ajout nouvelles caractèristiques à fichier existant :
bool ToSave = false;
//foreach (var env in xmlConfigEnvironnementClient.listEnvironnementExecution) {
// if (env.listConnexionOrpheaWeb == null || (env.listConnexionOrpheaWeb != null && env.listConnexionOrpheaWeb.Count == 0)) {
// env.listConnexionOrpheaWeb = new List<ConnexionOrpheaWeb>();
// ConnexionOrpheaWeb con = new ConnexionOrpheaWeb() { ToConnect = false, UrlApi = "http://*****:*****@GetXmlEnvironnementSession : Config n'existe pas : creation : " + sPath + " : " + statutMes);
return(xmlConfigEnvironnementClient);
}
