Exemplo n.º 1
0
 public JsonNetResult VacationBunch(BaseSearchParameters parameters)
 {
     var query = new SearchVacations(parameters);
     var results = Query(query);
     return Json(new
     {
         Items = results,
         Skipped = parameters.Skip,
         TotalResults = query.Stats.TotalResults
     });
 }
 public JsonNetResult EmployeeFileBatch(BaseSearchParameters parameters)
 {
     var query = new SearchEmployeeFiles(parameters);
     var results = Query(query);
     return Json(new
     {
         Items = results,
         Skipped = parameters.Skip,
         TotalResults = query.Stats.TotalResults
     });
 }
Exemplo n.º 3
0
 public JsonNetResult AbsenceBunch(int year, BaseSearchParameters parameters)
 {
     //TODO: return abscence data
     var query = new SearchAbsences(parameters) { From = new DateTime(year, 1, 1), To = new DateTime(year, 12, 31) };
     var results = Query(query);
     return Json(new
     {
         Items = results,
         Skipped = parameters.Skip,
         TotalResults = query.Stats.TotalResults
     });
 }
Exemplo n.º 4
0
        public JsonNetResult VacationBunch(BaseSearchParameters parameters)
        {
            var query   = new SearchVacations(parameters);
            var results = Query(query);

            return(Json(new
            {
                Items = results,
                Skipped = parameters.Skip,
                TotalResults = query.Stats.TotalResults
            }));
        }
        public JsonNetResult EmployeeFileBatch(BaseSearchParameters parameters)
        {
            var query   = new SearchEmployeeFiles(parameters);
            var results = Query(query);

            return(Json(new
            {
                Items = results,
                Skipped = parameters.Skip,
                TotalResults = query.Stats.TotalResults
            }));
        }
        /// <summary>
        /// Constructs WHERE clause in given sql statement based on provided <see cref="BaseSearchParameters"/>
        /// </summary>
        /// <param name="sql">The sql statement before appending WHERE clause</param>
        /// <param name="parameters"><see cref="BaseSearchParameters"/> to append to WHERE clause</param>
        /// <returns>Updated sql query with additional WHERE clause</returns>
        public virtual string BuildWhereClause(string sql, BaseSearchParameters parameters)
        {
            StringBuilder sb = new StringBuilder(sql);

            sb.Append(" WHERE ");

            if (!(string.IsNullOrWhiteSpace(parameters.Id)))
            {
                sb.Append("[Id] = @Id");
            }

            return(sb.ToString());
        }
Exemplo n.º 7
0
        /// <summary>
        /// Implements <see cref="IDataRepository{TResource}.Find(BaseSearchParameters)"/>
        /// </summary>
        public async Task <IEnumerable <TResource> > Find(BaseSearchParameters parameters)
        {
            using (var connection = new SqlConnection(_connectionConfiguration.GetConnectionString()))
            {
                try
                {
                    var results = await connection.QueryAsync <TResource>(_tableConfiguration.BuildWhereClause(_tableConfiguration.Find, parameters), parameters);

                    return(results);
                }
                catch
                {
                    throw;
                }
            }
        }
Exemplo n.º 8
0
        public JsonNetResult AbsenceBunch(int year, BaseSearchParameters parameters)
        {
            //TODO: return abscence data
            var query = new SearchAbsences(parameters)
            {
                From = new DateTime(year, 1, 1), To = new DateTime(year, 12, 31)
            };
            var results = Query(query);

            return(Json(new
            {
                Items = results,
                Skipped = parameters.Skip,
                TotalResults = query.Stats.TotalResults
            }));
        }
        /// <summary>
        /// override of <see cref="BaseTableConfiguration.BuildWhereClause(string, BaseSearchParameters)"/>
        /// </summary>
        /// <remarks>calls base method to get WHERE and optionally add <see cref="BaseResource.Id"/> as parameter
        /// also adds optional <see cref="UserResource.Email"/></remarks>
        public override string BuildWhereClause(string sql, BaseSearchParameters parameters)
        {
            if (!(parameters is UserSearchParameters userSearchParameters))
            {
                throw new ArgumentException("Invalid parameter search type");
            }

            StringBuilder sb = new StringBuilder(sql);

            sb.Append(" WHERE ");

            if (!(string.IsNullOrWhiteSpace(userSearchParameters.Email)))
            {
                sb.Append("[Email] = @Email");
            }

            return(sb.ToString());
        }
Exemplo n.º 10
0
 public SearchAbsences(BaseSearchParameters parameters)
 {
     Parameters = parameters;
 }
Exemplo n.º 11
0
 public SearchVacations(BaseSearchParameters parameters)
 {
     Parameters = parameters;
 }
Exemplo n.º 12
0
 public SearchEmployeeFiles(BaseSearchParameters parameters)
 {
     Parameters = parameters;
 }
Exemplo n.º 13
0
 /// <summary>
 /// No search parameters are needed at the moment
 /// </summary>
 public override string BuildWhereClause(string sql, BaseSearchParameters parameters) => sql;