//OK
public ArrayList getCorrispondentiByCodRF(string codiceRF)
{
ArrayList corr = new ArrayList();
DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider();
try
{
//semaforo.WaitOne();
DocsPaUtils.Query queryMng = DocsPaUtils.InitQuery.getInstance().getQuery("GET_CORRISPONDENTE_BY_RF");
queryMng.setParam("param1", codiceRF.ToUpper().Replace("'", "''"));
string commandText = queryMng.getSQL();
System.Diagnostics.Debug.WriteLine("SQL - getCorrispondentiByCodRF - RF.cs - QUERY : " + commandText);
logger.Debug("SQL - getCorrispondentiByCodRF - RF.cs - QUERY : " + commandText);
DataSet ds = new DataSet();
dbProvider.ExecuteQuery(ds, commandText);
DocsPaDB.Query_DocsPAWS.Utenti u = new DocsPaDB.Query_DocsPAWS.Utenti();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DocsPaVO.utente.Corrispondente c = u.GetCorrispondenteBySystemID(ds.Tables[0].Rows[i][0].ToString());
string ii = c.codiceRubrica;
// corr.Add(c);
if (c.tipoIE == "I")
{
corr.Add(u.GetCorrispondenteByCodRubrica(ds.Tables[0].Rows[i][1].ToString(), c.codiceRubrica, DocsPaVO.addressbook.TipoUtente.INTERNO));
}
if (c.tipoIE == "E")
{
corr.Add(u.GetCorrispondenteByCodRubrica(ds.Tables[0].Rows[i][1].ToString(), c.codiceRubrica, DocsPaVO.addressbook.TipoUtente.ESTERNO));
}
}
}
catch
{
return(null);
}
finally
{
dbProvider.Dispose();
//semaforo.ReleaseMutex();
}
return(corr);
}
