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); }