public static string AffectWorkflowsProcesses(PNPU_STEP input, string workflowID)
{
string[] requests = { "INSERT INTO PNPU_STEP ( ORDER_ID, ID_PROCESS, WORKFLOW_ID) VALUES( @ORDER_ID, @ID_PROCESS, @WORKFLOW_ID)" };
string[] parameters = new string[] { "@ORDER_ID", input.ID_ORDER.ToString(), "@ID_PROCESS", input.ID_PROCESS.ToString(), "@WORKFLOW_ID", input.ID_WORKFLOW };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_STEP", parameters, false));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("INSERT INTO PNPU_STEP ( ORDER_ID, ID_PROCESS, WORKFLOW_ID) VALUES( @ORDER_ID, @ID_PROCESS, @WORKFLOW_ID)", conn))
* {
* cmd.Parameters.Add("@ORDER_ID", SqlDbType.Int).Value = input.ID_ORDER;
* cmd.Parameters.Add("@ID_PROCESS", SqlDbType.VarChar, 254).Value = input.ID_PROCESS;
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.VarChar, 254).Value = input.ID_WORKFLOW;
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création d’un document.";
* }*/
}
public static string DeleteWorkflow(string workflowID)
{
string[] requests = { "DELETE FROM PNPU_WORKFLOW WHERE WORKFLOW_ID = @WORKFLOW_ID " };
string[] parameters = new string[] { "@WORKFLOW_ID", workflowID };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_WORKFLOW", parameters, false));
/* using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM PNPU_WORKFLOW WHERE WORKFLOW_ID = @WORKFLOW_ID ", conn))
* {
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int).Value = workflowID;
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* using (var cmd = new System.Data.SqlClient.SqlCommand("DELETE FROM PNPU_STEP WHERE WORKFLOW_ID = @WORKFLOW_ID", conn))
* {
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int).Value = workflowID;
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création d’un document.";
* }*/
}
public static string ModifyProcessus(PNPU_PROCESS input, string processID)
{
string[] requests = { "UPDATE PNPU_PROCESS SET PROCESS_LABEL = @PROCESS_LABEL, IS_LOOPABLE = @IS_LOOPABLE WHERE ID_PROCESS = @ID_PROCESS" };
string[] parameters = new string[] { "@ID_PROCESS", processID, "@PROCESS_LABEL", input.PROCESS_LABEL, "@IS_LOOPABLE", input.IS_LOOPABLE };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_PROCESS", parameters, false));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("UPDATE PNPU_PROCESS SET PROCESS_LABEL = @PROCESS_LABEL, IS_LOOPABLE = @IS_LOOPABLE WHERE ID_PROCESS = @ID_PROCESS", conn))
* {
* cmd.Parameters.Add("@ID_PROCESS", SqlDbType.Int).Value = processID;
* cmd.Parameters.Add("@PROCESS_LABEL", SqlDbType.VarChar, 254).Value = input.PROCESS_LABEL;
* cmd.Parameters.Add("@IS_LOOPABLE", SqlDbType.VarChar, 254).Value = input.IS_LOOPABLE;
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création d’un document.";
* }*/
}
public static string ModifyWorkflow(PNPU_WORKFLOW input, string workflowID)
{
string[] requests = { "UPDATE PNPU_WORKFLOW SET WORKFLOW_LABEL = @WORKFLOW_LABEL WHERE WORKFLOW_ID = @WORKFLOW_ID " };
string[] parameters = new string[] { "@WORKFLOW_ID", workflowID, "@WORKFLOW_LABEL", input.WORKFLOW_LABEL };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_WORKFLOW", parameters, false));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("UPDATE PNPU_WORKFLOW SET WORKFLOW_LABEL = @WORKFLOW_LABEL WHERE WORKFLOW_ID = @WORKFLOW_ID ", conn))
* {
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int).Value = workflowID;
* cmd.Parameters.Add("@WORKFLOW_LABEL", SqlDbType.VarChar, 254).Value = input.WORKFLOW_LABEL;
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création d’un document.";
* }*/
}
public static string CreateWorkflow(PNPU_WORKFLOW input)
{
string[] requests = { "INSERT INTO PNPU_WORKFLOW ( WORKFLOW_LABEL) VALUES( @WORKFLOW_LABEL)" };
string[] parameters = new string[] { "@WORKFLOW_LABEL", input.WORKFLOW_LABEL };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_WORKFLOW", parameters, true));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* string LastInsertedPK = "";
* try
* {
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("INSERT INTO PNPU_WORKFLOW ( WORKFLOW_LABEL) VALUES( @WORKFLOW_LABEL)", conn))
* {
* cmd.Parameters.Add("@WORKFLOW_LABEL", SqlDbType.VarChar, 254).Value = input.WORKFLOW_LABEL;
* int rowsAffected = cmd.ExecuteNonQuery();
* if (rowsAffected > 0)
* {
* LastInsertedPK = DataManagerSQLServer.GetLastInsertedPK("PNPU_WORKFLOW", ParamAppli.ConnectionStringBaseAppli);
* }
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return LastInsertedPK;
* }*/
}
public string SaveReportInBDD(string json, IProcess process)
{
string[] requests = { "INSERT INTO PNPU_H_REPORT (ITERATION, WORKFLOW_ID, ID_PROCESS, CLIENT_ID, JSON_TEMPLATE) VALUES(@ITERATION, @WORKFLOW_ID, @ID_PROCESS, @CLIENT_ID, @JSON_TEMPLATE)" };
string[] parameters = new string[] { "@ITERATION", "1", "@WORKFLOW_ID", process.WORKFLOW_ID.ToString(), "@ID_PROCESS", process.PROCESS_ID.ToString(), "@CLIENT_ID", process.CLIENT_ID, "@JSON_TEMPLATE", json.Replace("\r\n", "") };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_H_REPORT", parameters, false));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("INSERT INTO PNPU_H_REPORT (ITERATION, WORKFLOW_ID, ID_PROCESS, CLIENT_ID, JSON_TEMPLATE) VALUES(@ITERATION, @WORKFLOW_ID, @ID_PROCESS, @CLIENT_ID, @JSON_TEMPLATE)", conn))
* {
* cmd.Parameters.Add("@ITERATION", SqlDbType.Int, 10).Value = 1;
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int, 15).Value = process.WORKFLOW_ID;
* cmd.Parameters.Add("@ID_PROCESS", SqlDbType.Int, 15).Value = process.PROCESS_ID;
* cmd.Parameters.Add("@CLIENT_ID", SqlDbType.VarChar, 64).Value = process.CLIENT_ID;
* cmd.Parameters.Add("@JSON_TEMPLATE", SqlDbType.Text).Value = json.Replace("\r\n", "");
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* string msgError = "L'insertion du report du client " + process.CLIENT_ID + ", process " + process.PROCESS_ID + " ,workflow " + process.WORKFLOW_ID + " a échoué !";
* Console.WriteLine(msgError);
* return false;
* }
* return true;
* }*/
}
public static string CreateProcess(PNPU_PROCESS input)
{
string[] requests = { "INSERT INTO PNPU_PROCESS ( PROCESS_LABEL, IS_LOOPABLE) VALUES( @PROCESS_LABEL, @IS_LOOPABLE)" };
string[] parameters = new string[] { "@PROCESS_LABEL", input.PROCESS_LABEL, "@IS_LOOPABLE", input.IS_LOOPABLE };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_PROCESS", parameters, true));
/*string sRequest = "INSERT INTO PNPU_PROCESS ( PROCESS_LABEL, IS_LOOPABLE) VALUES( @PROCESS_LABEL, @IS_LOOPABLE)";
* string sTable = "PNPU_PROCESS";
* string result = DataManagerSQLServer.SendTransactionWithGetLastPKid(sRequest, input, sTable);
*
* return result;*/
}
public static string CreateUpdateWorkflowHistoric(PNPU_H_WORKFLOW input)
{
int workFlowId = Decimal.ToInt32(input.WORKFLOW_ID);
if (historicWorkflowExist(workFlowId))
{
//Update for the moment do nothing
return("Requête traitée avec succès et création/mis à jour d'un historique de workflow");
}
else
{
string[] requests = { "INSERT INTO PNPU_H_WORKFLOW ( CLIENT_ID, WORKFLOW_ID, LAUNCHING_DATE, ENDING_DATE, STATUT_GLOBAL) VALUES (@CLIENT_ID, @WORKFLOW_ID, @LAUNCHING_DATE, @ENDING_DATE, @STATUT)" };
string[] parameters = new string[] { "@CLIENT_ID", input.CLIENT_ID, "@WORKFLOW_ID", input.WORKFLOW_ID.ToString(), "@LAUNCHING_DATE", input.LAUNCHING_DATE.ToString("MM/dd/yyyy HH:mm:ss"), "@ENDING_DATE", input.ENDING_DATE.ToString("MM/dd/yyyy HH:mm:ss"), "@STATUT", input.STATUT_GLOBAL };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_H_WORKFLOW", parameters, true));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
*
* conn.Open();
*
* using (var cmd = new System.Data.SqlClient.SqlCommand("insert into PNPU_H_WORKFLOW ( CLIENT_ID, WORKFLOW_ID, LAUNCHING_DATE, ENDING_DATE, STATUT_GLOBAL) values (@CLIENT_ID, @WORKFLOW_ID, @LAUNCHING_DATE, @ENDING_DATE, @STATUT)", conn))
* {
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int).Value = input.WORKFLOW_ID;
* cmd.Parameters.Add("@CLIENT_ID", SqlDbType.VarChar, 254).Value = input.CLIENT_ID;
* cmd.Parameters.Add("@LAUNCHING_DATE", SqlDbType.DateTime).Value = input.LAUNCHING_DATE;
* cmd.Parameters.Add("@STATUT", SqlDbType.VarChar, 254).Value = input.STATUT_GLOBAL;
* cmd.Parameters.Add("@ENDING_DATE", SqlDbType.DateTime).Value = input.ENDING_DATE;
*
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création/mis à jour d'un historique de workflow";
* }*/
}
}
public static string CreateUpdateStepHistoric(PNPU_H_STEP input)
{
if (historicStepExist(input))
{
string[] requests = { "UPDATE PNPU_H_STEP SET ENDING_DATE = @ENDING_DATE, CLIENT_NAME = @CLIENT_NAME, ID_STATUT = @ID_STATUT WHERE ITERATION = @ITERATION AND WORKFLOW_ID = @WORKFLOW_ID AND ID_PROCESS = @ID_PROCESS AND CLIENT_ID = @CLIENT_ID" };
string[] parameters = new string[] { "@ITERATION", input.ITERATION.ToString(), "@WORKFLOW_ID", input.WORKFLOW_ID.ToString(), "@ID_PROCESS", input.ID_PROCESS.ToString(), "@CLIENT_ID", input.CLIENT_ID, "@CLIENT_NAME", input.CLIENT_NAME, "@ID_STATUT", input.ID_STATUT, "@ENDING_DATE", input.ENDING_DATE.ToString("MM/dd/yyyy HH:mm:ss") };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_H_STEP", parameters, true));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
*
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("update PNPU_H_STEP set ENDING_DATE = @ENDING_DATE, ID_STATUT = @ID_STATUT where ITERATION = @ITERATION AND WORKFLOW_ID = @WORKFLOW_ID AND ID_PROCESS = @ID_PROCESS AND CLIENT_ID = @CLIENT_ID", conn))
* {
* cmd.Parameters.Add("@ITERATION", SqlDbType.Int).Value = input.ITERATION;
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int).Value = input.WORKFLOW_ID;
* cmd.Parameters.Add("@ID_PROCESS", SqlDbType.Int).Value = input.ID_PROCESS;
* cmd.Parameters.Add("@CLIENT_ID", SqlDbType.VarChar, 254).Value = input.CLIENT_ID;
* cmd.Parameters.Add("@ID_STATUT", SqlDbType.VarChar, 254).Value = input.ID_STATUT;
* cmd.Parameters.Add("@ENDING_DATE", SqlDbType.DateTime, 254).Value = input.ENDING_DATE;
*
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création d’un document.";
* }*/
}
else
{
string[] requests = { "INSERT INTO PNPU_H_STEP (ITERATION, WORKFLOW_ID, ID_PROCESS, CLIENT_ID, CLIENT_NAME, USER_ID, LAUNCHING_DATE, ENDING_DATE, ID_STATUT, TYPOLOGY) VALUES (@ITERATION, @WORKFLOW_ID, @ID_PROCESS, @CLIENT_ID, @CLIENT_NAME, @USER_ID, @LAUNCHING_DATE, @ENDING_DATE, @ID_STATUT, @TYPOLOGY)" };
string[] parameters = new string[] { "@ITERATION", input.ITERATION.ToString(), "@WORKFLOW_ID", input.WORKFLOW_ID.ToString(), "@ID_PROCESS", input.ID_PROCESS.ToString(), "@CLIENT_ID", input.CLIENT_ID, "@CLIENT_NAME", input.CLIENT_NAME, "@USER_ID", input.USER_ID, "@LAUNCHING_DATE", input.LAUNCHING_DATE.ToString("MM/dd/yyyy HH:mm:ss"), "@ENDING_DATE", input.ENDING_DATE.ToString("MM/dd/yyyy HH:mm:ss"), "@TYPOLOGY", input.TYPOLOGY, "@ID_STATUT", input.ID_STATUT };
return(DataManagerSQLServer.ExecuteSqlTransaction(requests, "PNPU_H_STEP", parameters, true));
/*using (var conn = new System.Data.SqlClient.SqlConnection(ParamAppli.ConnectionStringBaseAppli))
* {
* try
* {
*
* conn.Open();
* using (var cmd = new System.Data.SqlClient.SqlCommand("insert into PNPU_H_STEP(ITERATION, WORKFLOW_ID, ID_PROCESS, CLIENT_ID, USER_ID, LAUNCHING_DATE, ENDING_DATE, ID_STATUT, TYPOLOGY) values(@ITERATION, @WORKFLOW_ID, @ID_PROCESS, @CLIENT_ID, @USER_ID, @LAUNCHING_DATE, @ENDING_DATE, @ID_STATUT, @TYPOLOGY)", conn))
* {
* cmd.Parameters.Add("@ITERATION", SqlDbType.Int).Value = input.ITERATION;
* cmd.Parameters.Add("@WORKFLOW_ID", SqlDbType.Int).Value = input.WORKFLOW_ID;
* cmd.Parameters.Add("@ID_PROCESS", SqlDbType.Int).Value = input.ID_PROCESS;
* cmd.Parameters.Add("@CLIENT_ID", SqlDbType.VarChar, 254).Value = input.CLIENT_ID;
* cmd.Parameters.Add("@USER_ID", SqlDbType.VarChar, 254).Value = input.USER_ID;
* cmd.Parameters.Add("@LAUNCHING_DATE", SqlDbType.DateTime).Value = input.LAUNCHING_DATE;
* cmd.Parameters.Add("@ENDING_DATE", SqlDbType.DateTime).Value = input.ENDING_DATE;
* cmd.Parameters.Add("@TYPOLOGY", SqlDbType.VarChar, 254).Value = input.TYPOLOGY;
* cmd.Parameters.Add("@ID_STATUT", SqlDbType.VarChar, 254).Value = input.ID_STATUT;
*
* int rowsAffected = cmd.ExecuteNonQuery();
* }
* }
* catch (SqlException ex)
* {
* return ex.ToString();
* }
* return "Requête traitée avec succès et création d’un document.";
* }*/
}
}