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