public DataTable getStruttureSottofascicoli(string idamm, int idfascicolo, int idtitolario, int idtemplate)
{
ArrayList sp_params = new ArrayList();
DataSet data = new DataSet();
DocsPaUtils.Data.ParameterSP output = new DocsPaUtils.Data.ParameterSP("ID_OBJECT", 0, DocsPaUtils.Data.DirectionParameter.ParamOutput);
sp_params.Add(new DocsPaUtils.Data.ParameterSP("ID_FASCICOLO", (idfascicolo == int.MinValue ? "" : idfascicolo.ToString())));
sp_params.Add(new DocsPaUtils.Data.ParameterSP("ID_TITOLARIO", (idtitolario == int.MinValue ? "" : idtitolario.ToString())));
sp_params.Add(new DocsPaUtils.Data.ParameterSP("ID_TEMPLATE", (idtemplate == int.MinValue ? "" : idtemplate.ToString())));
sp_params.Add(new DocsPaUtils.Data.ParameterSP("ID_AMM", idamm.ToString()));
sp_params.Add(output);
ExecuteStoredProcedure("SP_GET_PROJECT_STRUCTURE", sp_params, data);
if (data.Tables.Count > 0)
{
return(data.Tables[0]);
}
else
{
return(null);
}
}
private void insertNodiStruttura(IEnumerable <DataRow> rows, int id)
{
DocsPaUtils.Data.ParameterSP output = new DocsPaUtils.Data.ParameterSP("ID", 0, DocsPaUtils.Data.DirectionParameter.ParamOutput);
for (int i = 0; i < rows.Count(); i++)
{
int nodeid = int.MinValue,
prevnodeid = Convert.ToInt32(rows.ElementAt(i)["SYSTEM_ID"]);
ExecuteStoreProcedure("SP_INSERT_STRUCTURE_NODE", new ArrayList()
{
new DocsPaUtils.Data.ParameterSP("NAME", rows.ElementAt(i)["NAME"]),
new DocsPaUtils.Data.ParameterSP("PARENT_ID", rows.ElementAt(i)["ID_PARENT"]),
new DocsPaUtils.Data.ParameterSP("TEMPLATE_ID", id.ToString()),
output
});
if (output.Valore == null)
{
throw new Exception("Errore nella SP_INSERT_STRUCTURE_NODE");
}
nodeid = Convert.ToInt32(output.Valore);
(from r in rows where !r.IsNull("ID_PARENT") && Convert.ToInt32(r["ID_PARENT"]) == prevnodeid select r)
.ToList().ForEach(x => x["ID_PARENT"] = nodeid);
}
}
private int insertStrutturaNode(DataRow row, int idtemplate)
{
DocsPaUtils.Data.ParameterSP output = new DocsPaUtils.Data.ParameterSP("ID", 0, DocsPaUtils.Data.DirectionParameter.ParamOutput);
ExecuteStoreProcedure("SP_INSERT_STRUCTURE_NODE", new ArrayList()
{
new DocsPaUtils.Data.ParameterSP("NAME", row["NAME"]),
new DocsPaUtils.Data.ParameterSP("PARENT_ID", row["ID_PARENT"]),
new DocsPaUtils.Data.ParameterSP("TEMPLATE_ID", idtemplate.ToString()),
output
});
return(output.Valore == null ? -1 : Convert.ToInt32(output.Valore));
}
private void insertTemplateStruttura(ref int id, string name, string idAmm)
{
DocsPaUtils.Data.ParameterSP outParam = new DocsPaUtils.Data.ParameterSP("ID", 0, DocsPaUtils.Data.DirectionParameter.ParamOutput);
int result = ExecuteStoreProcedure("SP_INSERT_PROJECT_TEMPLATE", new ArrayList()
{
new DocsPaUtils.Data.ParameterSP("NAME", name),
new DocsPaUtils.Data.ParameterSP("ID_AMM", idAmm),
outParam
});
if (outParam.Valore != null)
{
id = Convert.ToInt32(outParam.Valore);
}
}
public bool FollowDomainObjectManager(string operation, string idObject, string idPeople, string idGroup, string idAmm, string application)
{
bool res = false;
try
{
this.BeginTransaction();
logger.Debug("INIZIO SPFollowDomainObject");
// Creazione parametri per la Store Procedure
ArrayList parameters = new ArrayList();
DocsPaUtils.Data.ParameterSP outParam;
outParam = new DocsPaUtils.Data.ParameterSP("resultValue", new Int32(), 10, DocsPaUtils.Data.DirectionParameter.ParamOutput, System.Data.DbType.Int32);
if (operation.Equals(ADD_FOLDER) || operation.Equals(REMOVE_FOLDER))
{
parameters.Add(new DocsPaUtils.Data.ParameterSP("idFasc", idObject));
parameters.Add(new DocsPaUtils.Data.ParameterSP("idDoc", "0"));
}
else
{
parameters.Add(new DocsPaUtils.Data.ParameterSP("idDoc", idObject));
parameters.Add(new DocsPaUtils.Data.ParameterSP("idFasc", "0"));
}
parameters.Add(new DocsPaUtils.Data.ParameterSP("operation", operation));
parameters.Add(new DocsPaUtils.Data.ParameterSP("idPeople", idPeople));
parameters.Add(new DocsPaUtils.Data.ParameterSP("idGroup", idGroup));
parameters.Add(new DocsPaUtils.Data.ParameterSP("idAmm", idAmm));
parameters.Add(new DocsPaUtils.Data.ParameterSP("application", application));
this.ExecuteStoredProcedure("SPFollowDomainObject", parameters, null);
if (outParam.Valore != null && (int)outParam.Valore == 0)
{
res = true;
logger.Debug("STORE PROCEDURE SPFollowDomainObject: esito positivo");
}
else
{
res = false;
logger.Debug("STORE PROCEDURE SPFollowDomainObject: esito negativo");
}
}
catch (Exception exc)
{ }
return(res);
}
