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 ModifyWorkflow(PNPU_WORKFLOW input, string workflowID)
{
return(RequestTool.ModifyWorkflow(input, workflowID));
}
public string CreateWorkflow(PNPU_WORKFLOW input)
{
return(RequestTool.CreateWorkflow(input));
}
