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 string AffectWorkflowsProcesses(PNPU_STEP input, string workflowID)
{
return(RequestTool.AffectWorkflowsProcesses(input, workflowID));
}