/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
public static DocsPaSecurityItem NewItem(System.Data.IDataReader reader)
{
DocsPaSecurityItem item = new DocsPaSecurityItem();
item.IdPeople = reader.GetValue(reader.GetOrdinal("id_people")).ToString();
item.IdGroup = reader.GetValue(reader.GetOrdinal("id_group")).ToString();
item.CodiceRubrica = reader.GetValue(reader.GetOrdinal("codice_rubrica")).ToString();
item.AccessRights = reader.GetValue(reader.GetOrdinal("accessrights")).ToString();
item.TipoDiritto = reader.GetValue(reader.GetOrdinal("tipodiritto")).ToString();
return(item);
}
/// <summary>
/// Reperimento di un array di oggetti "DocsPaSecurityItem",
/// ciascuno contenente i metadati di security relativi ad un oggetto DocsPa
/// </summary>
/// <param name="thing"></param>
/// <returns></returns>
public static DocsPaSecurityItem[] getSecurityItems(string thing)
{
List <DocsPaSecurityItem> securityItems = new List <DocsPaSecurityItem>();
using (DocsPaDB.DBProvider dbProvider = new DocsPaDB.DBProvider())
{
string commandText = string.Format("SELECT cg.id_people AS id_people, cg.id_gruppo AS id_group, nvl(cg.var_original_code, cg.var_cod_rubrica) AS codice_rubrica, s.accessrights AS accessrights, s.cha_tipo_diritto AS tipodiritto FROM security s, dpa_corr_globali cg WHERE (s.personorgroup = cg.id_gruppo or s.personorgroup = cg.id_people) AND s.thing = {0} AND cg.dta_fine IS NULL", thing);
using (System.Data.IDataReader reader = dbProvider.ExecuteReader(commandText))
{
while (reader.Read())
{
securityItems.Add(DocsPaSecurityItem.NewItem(reader));
}
}
}
return(securityItems.ToArray());
}
