Example #1
0
        /// <summary>
        /// Ritorna la lista degli id dei documenti
        /// </summary>
        /// <param name="idObject"></param>
        /// <param name="filter"></param>
        /// <returns></returns>
        public List <string> GetDocumentByNotificationsFilters(string[] idObject, DocsPaVO.Notification.NotificationsFilters filter)
        {
            List <string> listIdObject = new List <string>();

            try
            {
                DataSet           ds        = new DataSet();
                string            query     = string.Empty;
                string            condition = string.Empty;
                DocsPaUtils.Query q         = DocsPaUtils.InitQuery.getInstance().getQuery("S_PROFILE_SYSTEM_ID_BY_FILTER_NOTIFICATION");
                condition = BuildConditionNotificationsFilters(idObject, filter);
                q.setParam("condition", condition);
                query = q.getSQL();
                if (this.ExecuteQuery(out ds, "idObject", query))
                {
                    if (ds.Tables["idObject"] != null && ds.Tables["idObject"].Rows.Count > 0)
                    {
                        foreach (DataRow row in ds.Tables["idObject"].Rows)
                        {
                            listIdObject.Add(row["SYSTEM_ID"].ToString());
                        }
                    }
                }
            }
            catch (Exception e)
            {
                throw e;
            }
            return(listIdObject);
        }
Example #2
0
        public static List <string> GetDocumentByNotificationsFilters(string[] idObject, DocsPaVO.Notification.NotificationsFilters filter)
        {
            List <string> listIdObject = new List <string>();

            try
            {
                DocsPaDB.Query_DocsPAWS.NotificationDB notificationDB = new DocsPaDB.Query_DocsPAWS.NotificationDB();
                listIdObject = notificationDB.GetDocumentByNotificationsFilters(idObject, filter);
            }
            catch (Exception e)
            {
                logger.Debug("Errore in BusinessLogic.ServiceNotifications.Notification  - metodo: GetDocumentByNotificationsFilters ", e);
            }
            return(listIdObject);
        }