Пример #1
0
 /// <summary>
 /// Gets the name of the Query by.
 /// </summary>
 /// <param name="queryName">Name of the query.</param>
 /// <returns></returns>
 /// <exception cref="ArgumentNullException">Get Query By Name</exception>
 public IQuery GetQueryByName(string queryName)
 {
     try
     {
         using (
             var dbContext = (HRMSEntities)this.dbContextFactory.GetDbContext(ObjectContextType.HRMS))
         {
             var queryInfo = QueryQueries.getQueryByName(dbContext, queryName);
             return(queryInfo);
         }
     }
     catch (Exception e)
     {
         throw new ArgumentNullException("Get Query By Name", e);
     }
 }
Пример #2
0
        /// <summary>
        /// </summary>
        /// <param name="companyId"></param>
        /// <returns></returns>
        /// <exception cref="ApplicationException">Repository GetAllMyQueries</exception>
        public IList <IQuery> GetAllMyQueries(int companyId)
        {
            try
            {
                using (
                    var dbContext = (HRMSEntities)this.dbContextFactory.GetDbContext(ObjectContextType.HRMS))
                {
                    var list = QueryQueries.getAllMyQueries(dbContext, companyId).ToList();

                    return(list);
                }
            }
            catch (Exception e)
            {
                throw new ApplicationException("Repository GetAllMyQueries", e);
            }
        }
Пример #3
0
        /// <summary>
        /// Gets the Query by identifier.
        /// </summary>
        /// <param name="queryId">The Query identifier.</param>
        /// <returns></returns>
        /// <exception cref="ArgumentNullException">
        /// QueryId
        /// or
        /// Get Query By Id
        /// </exception>
        public IQuery GetQueryById(int queryId)
        {
            if (queryId <= 0)
            {
                throw new ArgumentNullException(nameof(queryId));
            }

            try
            {
                using (
                    var dbContext = (HRMSEntities)this.dbContextFactory.GetDbContext(ObjectContextType.HRMS))
                {
                    var result = QueryQueries.getQueryById(dbContext, queryId);

                    return(result);
                }
            }
            catch (Exception e)
            {
                throw new ArgumentNullException("Get Query By Id", e);
            }
        }