public JsonResult GetAllPayments(string name, DateTime?date, int?pageNumber)
        {
            List <SearchPayments> search = null;
            int pageSize = 6;

            if (string.IsNullOrEmpty(name) && date != null)
            {
                //DateTime parsedDate = DateTime.Parse(date);
                search = userDatabaseRepository.getAllUsersAndPaymentsByDate(date);
            }
            else if (!string.IsNullOrEmpty(name) && date == null)
            {
                search = userDatabaseRepository.getAllUsersAndPaymentsByName(name);
            }
            else if (string.IsNullOrEmpty(name) && date == null)
            {
                search = userDatabaseRepository.getAllUsersAndPayments();
            }
            else
            {
                // DateTime parsedDate = DateTime.Parse(date);
                search = userDatabaseRepository.getAllUsersAndPaymentsByDateAndName(date, name);
            }

            var result = PaginatedList <SearchPayments> .Create(search, pageNumber ?? 1, pageSize);

            return(Json(new { data = result, hasPreviousPage = result.HasPreviousPage, hasNextPage = result.HasNextPage }));
        }