Exemplo n.º 1
0
        public void TableRequest_Defaults()
        {
            var r = new TableRequest();

            Assert.IsNotNull(r.Sources);
            Assert.IsNotNull(r.Destinations);
        }
Exemplo n.º 2
0
        private void Write(IDictionary <string, object> entity, string uri, string method)
        {
            if (entity == null)
            {
                throw new ArgumentNullException("entity");
            }
            if (!entity.ContainsKey("PartitionKey"))
            {
                throw new ArgumentException("Entity has no PartitionKey");
            }
            if (!entity.ContainsKey("RowKey"))
            {
                throw new ArgumentException("Entity has no RowKey");
            }

            var webRequest = BuildRequest(uri, method);

            webRequest.ContentType = @"application/atom+xml";

            if (!entity.ContainsKey("Timestamp"))
            {
                entity.Add("Timestamp", "0001-01-01T00:00:00");
            }

            TableRequest.SignRequestForSharedKeyLite(webRequest, credentials);
            WriteToRequestStream(entity, uri, webRequest);

            using (var response = webRequest.GetResponse())
            { }
        }
Exemplo n.º 3
0
        public void TableRequest_Url()
        {
            var r = new TableRequest
            {
                Coordinates = locations
            };

            Assert.IsTrue(r.CoordinatesUrlPart.Contains("13.420526,52.503033"));
            Assert.IsTrue(r.CoordinatesUrlPart.Contains("13.429290,52.516582"));

            r.Sources = new uint[1] {
                0
            };
            var srcParams = ParamValues(r.UrlParams, "sources");

            Assert.AreEqual <int>(1, srcParams.Length);
            Assert.IsTrue(srcParams.Contains("0"));

            r.Destinations = new uint[1] {
                1
            };
            var dstParams = ParamValues(r.UrlParams, "destinations");

            Assert.AreEqual <int>(1, dstParams.Length);
            Assert.IsTrue(dstParams.Contains("1"));
        }
Exemplo n.º 4
0
        public override async Task <BaseReply> DeleteTable(TableRequest request, ServerCallContext context)
        {
            try
            {
                await _databaseService.DeleteTable(request.DbName, request.TableName);

                Console.WriteLine();
                Console.WriteLine();
                Console.WriteLine("***************************************************************************************************************");
                Console.WriteLine("Table deleted: " + request.TableName);
                Console.WriteLine("***************************************************************************************************************");

                return(new BaseReply()
                {
                    Code = 200
                });
            }
            catch (Exception ex)
            {
                return(new BaseReply()
                {
                    Code = 400, Message = ex.Message, StackTrace = ex.StackTrace
                });
            }
        }
        /// <summary>
        /// Generates a task sequence for getting the properties of the table service.
        /// </summary>
        /// <param name="setResult">A delegate to receive the service properties.</param>
        /// <returns>A task sequence that gets the properties of the table service.</returns>
        private TaskSequence GetServicePropertiesImpl(Action <ServiceProperties> setResult)
        {
            HttpWebRequest request = TableRequest.GetServiceProperties(this.BaseUri, this.Timeout.RoundUpToSeconds());

            CommonUtils.ApplyRequestOptimizations(request, -1);
            this.Credentials.SignRequestLite(request);

            // Get the web response.
            Task <WebResponse> responseTask = request.GetResponseAsyncWithTimeout(this, this.Timeout);

            yield return(responseTask);

            using (HttpWebResponse response = responseTask.Result as HttpWebResponse)
                using (Stream responseStream = response.GetResponseStream())
                    using (MemoryStream memoryStream = new MemoryStream())
                    {
                        // Download the service properties.
                        Task <NullTaskReturn> downloadTask = new InvokeTaskSequenceTask(() => { return(responseStream.WriteTo(memoryStream)); });
                        yield return(downloadTask);

                        // Materialize any exceptions.
                        NullTaskReturn scratch = downloadTask.Result;

                        // Get the result from the memory stream.
                        memoryStream.Seek(0, SeekOrigin.Begin);
                        setResult(TableResponse.ReadServiceProperties(memoryStream));
                    }
        }
Exemplo n.º 6
0
        public async System.Threading.Tasks.Task CheckRequestTestAsync()
        {
            var options = new DbContextOptionsBuilder <CoffeeDbContext>()
                          .UseInMemoryDatabase(Guid.NewGuid().ToString())
                          .Options;

            using (var context = new CoffeeDbContext(options))
            {
                var service = new TableRepository(context);

                TableRequest table = new TableRequest
                {
                    Id          = 1,
                    FirstName   = "FirstName",
                    LastName    = "LastName",
                    Date        = DateTime.Now.ToString(),
                    Status      = "Waiting",
                    Note        = "Test",
                    PhoneNumber = "123456",
                    Time        = DateTime.Now.AddDays(2).ToString()
                };

                await service.AddRequestAsync(table);
            }

            using (var context = new CoffeeDbContext(options))
            {
                Assert.AreEqual(1, context.TableRequests.Count());

                var service = new TableRepository(context);
                await service.CheckRequest(1, "Done");

                Assert.AreEqual("Done", context.TableRequests.Single().Status);
            }
        }
Exemplo n.º 7
0
        public TableItems <UserListViewModel[]> Search(TableRequest request, UserListViewModel searchModel)
        {
            var query = _repository.TableAsNoTracking;

            IQueryable <TEntity> GetOrderedQuery <TEntity, TKey>(IQueryable <TEntity> loccalQuery, System.Linq.Expressions.Expression <Func <TEntity, TKey> > expression, string sortOrder)
            {
                return(sortOrder == "desc" ? loccalQuery.OrderByDescending(expression) : loccalQuery.OrderBy(expression));
            }

            switch (request.sidx)
            {
            case nameof(User.Login):
                query = GetOrderedQuery(query, q => q.Login, request.sord);
                break;

            case nameof(User.PasswordHash):
                query = GetOrderedQuery(query, q => q.PasswordHash, request.sord);
                break;

            case nameof(User.Salt):
                query = GetOrderedQuery(query, q => q.Salt, request.sord);
                break;

            case nameof(User.Id):
                query = GetOrderedQuery(query, q => q.Id, request.sord);
                break;

            default:
                query = GetOrderedQuery(query, q => q.Login, request.sord);
                break;
            }
            if (!string.IsNullOrEmpty(searchModel.Login))
            {
                query = query.Where(w => w.Login.Contains(searchModel.Login));
            }
            if (searchModel.Id.HasValue)
            {
                query = query.Where(w => w.Id == searchModel.Id.Value);
            }
            var rows = query.Select(s => new UserListViewModel
            {
                Login = s.Login,
                Id    = s.Id,
            });
            var total  = rows.Count();
            var toTake = request.rows;

            if (request.includePrevousPages)
            {
                toTake = request.page * request.rows;
            }
            else
            {
                rows = rows.Skip((request.page - 1) * request.rows);
            }
            var data = rows.Take(toTake).ToArray();

            return(new TableItems <UserListViewModel[]>(data, total, request.page, (int)Math.Ceiling((decimal)total / request.rows)));
        }
Exemplo n.º 8
0
 public TableExtractorFrame(AxMODI.AxMiDocView documentViewer, TableRequest request)
 {
     InitializeComponent();
     _documentViewer = documentViewer;
     _request        = request;
     // Synchronize transparent color
     this.TransparencyKey = TransparentListView.TransparentColor;
 }
Exemplo n.º 9
0
        public void Table_Response_DurationAndDistanceAnnotation()
        {
            var locations = new Location[] {
                new Location(52.554070m, 13.160621m),
                new Location(52.431272m, 13.720654m),
                new Location(52.554070m, 13.720654m),
                new Location(52.554070m, 13.160621m),
            };

            var tableRequest = new TableRequest()
            {
                Coordinates = locations,
                Annotations = TableRequestAnnotation.DistancesAndDurations
            };

            var result = osrm.Table(tableRequest).GetAwaiter().GetResult();

            // check distances
            Assert.AreEqual <string>("Ok", result.Code);
            Assert.AreEqual <int>(4, result.Distances.Length);
            Assert.AreEqual <int>(4, result.Distances[0].Length);
            Assert.AreEqual <int>(4, result.Distances[1].Length);
            Assert.AreEqual <int>(4, result.Distances[2].Length);
            Assert.AreEqual <int>(4, result.Distances[3].Length);

            // check durations
            Assert.AreEqual <int>(4, result.Durations.Length);
            Assert.AreEqual <int>(4, result.Durations[0].Length);
            Assert.AreEqual <int>(4, result.Durations[1].Length);
            Assert.AreEqual <int>(4, result.Durations[2].Length);
            Assert.AreEqual <int>(4, result.Durations[3].Length);


            var srcAndDests = new Location[] {
                new Location(52.554070m, 13.160621m),
                new Location(52.431272m, 13.720654m),
                new Location(52.554070m, 13.720654m),
                new Location(52.554070m, 13.160621m),
            };

            var result2 = osrm.Table(new TableRequest()
            {
                Coordinates  = srcAndDests,
                Annotations  = TableRequestAnnotation.DistancesAndDurations,
                Sources      = new uint[] { 0 },
                Destinations = new uint[] { 1, 2, 3 }
            }).GetAwaiter().GetResult();

            // check durations
            Assert.AreEqual <string>("Ok", result.Code);
            Assert.AreEqual <int>(1, result2.Durations.Length);
            Assert.AreEqual <int>(3, result2.Durations[0].Length);

            // check distances
            Assert.AreEqual <string>("Ok", result.Code);
            Assert.AreEqual <int>(1, result2.Distances.Length);
            Assert.AreEqual <int>(3, result2.Distances[0].Length);
        }
Exemplo n.º 10
0
 public TableRequest TableRequestByName(string tableName, out int urlId)
 {
     try
     {
         TableRequest obj = db.TableRequests.Where(v => v.TableName == tableName).First();
         urlId = db.Urls.Where(v => v.TableId == obj.Id).First().Id;
         return(obj);
     }
     catch (Exception) { urlId = -1; return(null); }
 }
Exemplo n.º 11
0
        public override IActionResult ApplyFilters([FromBody] TableRequest request)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest($"Model is not Valid: {string.Join(" ;", ModelState.Values.SelectMany(x => x.Errors.Select(y => y.ErrorMessage)))}"));
            }
            SaveToSession(SessionKeys.TableRequest, request);

            return(RedirectToAction(nameof(Table), new { page = 1 }));
        }
Exemplo n.º 12
0
        public Table MapEntity(TableRequest request)
        {
            Table table = new Table(request.Id, request.Number);

            UpdateOrder(table);

            UpdateOrderItem(table);

            return(table);
        }
Exemplo n.º 13
0
        public async Task <IEnumerable <TablesResponse> > TablesAsync(TableRequest request,
                                                                      CancellationToken token = default)
        {
            Guard.Against.Null(request, nameof(request));

            var response = await this
                           .PostAsync <IEnumerable <TablesResponse>, TableRequest>(request, token);

            return(response ?? Enumerable.Empty <TablesResponse>());
        }
Exemplo n.º 14
0
        public TableResultJson <ReplyCommentViewModel> GetReplyCommentPaged(TableRequest request)
        {
            var dataSource          = replyCommentRepository.GetAll().OrderByDescending(x => x.CreatedDate).ToList();
            var dataSourceViewModel = (mapper.Map <List <ReplyCommentViewModel> >(dataSource)).AsEnumerable();

            if (request.columns[1].search != null)
            {
                var _value1 = request.columns[1].search.value;
                if (!string.IsNullOrEmpty(_value1))
                {
                    dataSourceViewModel = dataSourceViewModel.Where(x => x.OId.Contains(_value1));
                }
            }

            if (request.columns[2].search != null)
            {
                var _value2 = request.columns[2].search.value;
                if (!string.IsNullOrEmpty(_value2))
                {
                    dataSourceViewModel = dataSourceViewModel.Where(x => x.AuthorName.Contains(_value2));
                }
            }

            if (request.columns[3].search != null)
            {
                if (!string.IsNullOrEmpty(request.columns[3].search.value))
                {
                    var dt = DateTime.TryParseExact(request.columns[3].search.value, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out var datetime);
                    if (dt)
                    {
                        dataSourceViewModel = dataSourceViewModel.Where(x => x.CreatedDate.Value.Date == datetime);
                    }
                }
            }

            if (request.columns[8].search != null)
            {
                var _value4 = request.columns[8].search.value;
                if (!string.IsNullOrEmpty(_value4))
                {
                    dataSourceViewModel = dataSourceViewModel.Where(x => x.Content.Contains(_value4));
                }
            }

            var response = new TableResultJson <ReplyCommentViewModel>();

            response.draw            = request.draw;
            response.recordsFiltered = dataSourceViewModel.Count();
            dataSourceViewModel      = dataSourceViewModel.Skip(request.start).Take(request.length);
            response.data            = dataSourceViewModel.ToList();

            response.data.ForEach(x => { x.Index = response.data.IndexOf(x) + request.start + 1; });
            return(response);
        }
        public IActionResult TableAdd(TableRequest user)
        {
            var userAdd = new Tablenya()
            {
                Id = user.Id, Name = user.Name, Description = user.Description
            };

            Tables.Add(userAdd);

            return(Ok(userAdd));
        }
Exemplo n.º 16
0
        public async Task <IActionResult> RequestTable(TableRequest request)
        {
            if (ModelState.IsValid)
            {
                await _unitOfWork.TableRepository.AddRequestAsync(request);

                await _unitOfWork.SaveAsync();

                return(View("RequestComplete"));
            }
            return(RedirectToAction("Index", "Home"));
        }
Exemplo n.º 17
0
        public IActionResult Menu()
        {
            var drinks         = _unitOfWork.DrinkRepository.GetDrinks();
            var request        = new TableRequest();
            var indexViewModel = new IndexViewModel
            {
                Drinks  = drinks,
                Request = request
            };

            return(View(indexViewModel));
        }
Exemplo n.º 18
0
        public JsonResult SelectCooperContents(TableRequest request)
        {
            var           data          = _db.CooperationContents.Include(x => x.CooperationTitle).WhereIf(request.KeyWord != null, x => x.Name.Contains(request.KeyWord));
            TableResponse tableResponse = new TableResponse();

            tableResponse.Total = data.Count();
            tableResponse.Data  = data.Skip((request.Page - 1) * request.Limit).Take(request.Limit).Select(x => new
            {
                x.ID,
                CooperationTitleName = x.CooperationTitle.Name,
                x.Name
            });
            return(Json(tableResponse));
        }
Exemplo n.º 19
0
        public JsonResult SelectClients(TableRequest request)
        {
            var datas = _db.Clients.WhereIf(request.KeyWord != null, x => x.Name.Contains(request.KeyWord)).Select(c => new
            {
                c.ID,
                c.Name
            });

            TableResponse tableResponse = new TableResponse();

            tableResponse.Total = datas.Count();
            tableResponse.Data  = datas.Skip((request.Page - 1) * request.Limit).Take(request.Limit).OrderBy(x => x.ID).ToList();
            return(Json(tableResponse));
        }
Exemplo n.º 20
0
        public async System.Threading.Tasks.Task GetRequestsTestAsync()
        {
            var options = new DbContextOptionsBuilder <CoffeeDbContext>()
                          .UseInMemoryDatabase(Guid.NewGuid().ToString())
                          .Options;

            using (var context = new CoffeeDbContext(options))
            {
                var service = new TableRepository(context);

                TableRequest table1 = new TableRequest
                {
                    Id          = 1,
                    FirstName   = "FirstName",
                    LastName    = "LastName",
                    Date        = DateTime.Now.ToString(),
                    Status      = "Waiting",
                    Note        = "Test",
                    PhoneNumber = "123456",
                    Time        = DateTime.Now.AddDays(2).ToString()
                };

                TableRequest table2 = new TableRequest
                {
                    Id          = 2,
                    FirstName   = "FirstName1",
                    LastName    = "LastName1",
                    Date        = DateTime.Now.ToString(),
                    Status      = "Waiting1",
                    Note        = "Test1",
                    PhoneNumber = "123456",
                    Time        = DateTime.Now.AddDays(2).ToString()
                };

                await service.AddRequestAsync(table1);

                await service.AddRequestAsync(table2);
            }

            using (var context = new CoffeeDbContext(options))
            {
                Assert.AreEqual(2, context.TableRequests.Count());

                var service = new TableRepository(context);
                var result  = service.GetRequests();

                Assert.AreEqual(2, result.Count());
            }
        }
Exemplo n.º 21
0
        public TableResultJson <FieldViewModel> GetAllField(TableRequest request)
        {
            var dataSource          = fieldRepository.GetAll().OrderByDescending(x => x.CreatedDate);
            var dataSourceViewModel = mapper.Map <List <FieldViewModel> >(dataSource).AsEnumerable();
            var response            = new TableResultJson <FieldViewModel>
            {
                draw            = request.draw,
                recordsFiltered = dataSourceViewModel.Count()
            };

            dataSourceViewModel = dataSourceViewModel.Skip(request.start).Take(request.length);
            response.data       = dataSourceViewModel.ToList();
            response.data.ForEach(x => { x.Index = response.data.IndexOf(x) + request.start + 1; });
            return(response);
        }
Exemplo n.º 22
0
        public TableResultJson <LevelViewModel> GetAllLevel(TableRequest request)
        {
            var dataSource          = levelRepository.GetAll();
            var dataSourceViewModel = mapper.Map <List <LevelViewModel> >(dataSource).AsEnumerable();
            var response            = new TableResultJson <LevelViewModel>
            {
                draw            = request.draw,
                recordsFiltered = dataSourceViewModel.Count()
            };

            dataSourceViewModel = dataSourceViewModel.Skip(request.start).Take(request.length);
            response.data       = dataSourceViewModel.ToList();
            response.data.ForEach(x => { x.Index = response.data.IndexOf(x) + request.start + 1; });
            return(response);
        }
Exemplo n.º 23
0
        public IEnumerable <dynamic> Query(string queryString)
        {
            var webRequest = BuildRequest(string.Format(@"http://{0}.table.core.windows.net/{1}()?$filter={2}", credentials.AccountName, tableName, queryString.Replace(' ', '+')));

            TableRequest.SignRequestForSharedKeyLite(webRequest, credentials);
            using (var response = webRequest.GetResponse())
            {
                foreach (var item in ParseResponse(response))
                {
                    yield return(item);
                }
            }

            yield break;
        }
Exemplo n.º 24
0
        private TableRequest GetPropertyValues(TableRequest request, ValueProviderResult filtersValueResult)
        {
            var filters = (string)filtersValueResult.ConvertTo(typeof(string));
            var appliedFilters = JObject.Parse(filters);
            var tokens = appliedFilters.Children();

            var Name = "";
            var Surname = "";
            var Role = Roles.All;
            int? Id = null;
            var index = 0;

            foreach (var token in tokens)
            {
                if (index != 0)
                {
                    for (var j = 0; j < token.First.Count(); j++)
                    {
                        var currentToken = token.First[j];
                        if (currentToken.Value<string>("field").Equals("Name"))
                        {
                            Name = currentToken["data"].ToString().Trim();
                        }
                        if (currentToken.Value<string>("field").Equals("Surname"))
                        {
                            Surname = currentToken["data"].ToString().Trim();
                        }
                        if (currentToken.Value<string>("field").Equals("Position"))
                        {
                            Role = (Roles)(Enum.Parse(typeof(Roles), currentToken["data"].ToString().Trim()));
                        }
                        if (currentToken.Value<string>("field").Equals("Id"))
                        {
                            Id = Convert.ToInt32(currentToken["data"].ToString().Trim());
                        }
                    }
                }
                index++;
            }

            request.Name = Name.Trim();
            request.Surname = Surname.Trim();
            request.Role = Role;
            request.Id = Id;

            return request;
        }
Exemplo n.º 25
0
        private TableRequest GetPropertyValues(TableRequest request, ValueProviderResult filtersValueResult)
        {
            var filters        = (string)filtersValueResult.ConvertTo(typeof(string));
            var appliedFilters = JObject.Parse(filters);
            var tokens         = appliedFilters.Children();

            var Name    = "";
            var Surname = "";
            var Role    = Roles.All;
            int?Id      = null;
            var index   = 0;

            foreach (var token in tokens)
            {
                if (index != 0)
                {
                    for (var j = 0; j < token.First.Count(); j++)
                    {
                        var currentToken = token.First[j];
                        if (currentToken.Value <string>("field").Equals("Name"))
                        {
                            Name = currentToken["data"].ToString().Trim();
                        }
                        if (currentToken.Value <string>("field").Equals("Surname"))
                        {
                            Surname = currentToken["data"].ToString().Trim();
                        }
                        if (currentToken.Value <string>("field").Equals("Position"))
                        {
                            Role = (Roles)(Enum.Parse(typeof(Roles), currentToken["data"].ToString().Trim()));
                        }
                        if (currentToken.Value <string>("field").Equals("Id"))
                        {
                            Id = Convert.ToInt32(currentToken["data"].ToString().Trim());
                        }
                    }
                }
                index++;
            }

            request.Name    = Name.Trim();
            request.Surname = Surname.Trim();
            request.Role    = Role;
            request.Id      = Id;

            return(request);
        }
Exemplo n.º 26
0
 public string TableNameByUrl(int urlId, string dbName)
 {
     try
     {
         int          tableId = db.Urls.Where(v => v.Id == urlId).First().TableId.Value;
         TableRequest obj     = db.TableRequests.Where(v => v.Id == tableId).First();
         if (dbName != obj.DBName)
         {
             return(null);
         }
         else
         {
             return(obj.TableName);
         }
     }
     catch (Exception) { return(null); }
 }
        /// <summary>
        /// Generates a task sequence for setting the properties of the table service.
        /// </summary>
        /// <param name="properties">The table service properties to set.</param>
        /// <returns>A task sequence that sets the properties of the table service.</returns>
        private TaskSequence SetServicePropertiesImpl(ServiceProperties properties)
        {
            CommonUtils.AssertNotNull("properties", properties);

            HttpWebRequest request = TableRequest.SetServiceProperties(this.BaseUri, this.Timeout.RoundUpToSeconds());

            using (MemoryStream memoryStream = new MemoryStream())
            {
                try
                {
                    TableRequest.WriteServiceProperties(properties, memoryStream);
                }
                catch (InvalidOperationException invalidOpException)
                {
                    throw new ArgumentException(invalidOpException.Message, "properties");
                }

                memoryStream.Seek(0, SeekOrigin.Begin);
                CommonUtils.ApplyRequestOptimizations(request, memoryStream.Length);
                this.Credentials.SignRequestLite(request);

                // Get the request stream
                Task <Stream> getStreamTask = request.GetRequestStreamAsync();
                yield return(getStreamTask);

                using (Stream requestStream = getStreamTask.Result)
                {
                    // Upload the service properties.
                    Task <NullTaskReturn> uploadTask = new InvokeTaskSequenceTask(() => { return((memoryStream as Stream).WriteTo(requestStream)); });
                    yield return(uploadTask);

                    // Materialize any exceptions.
                    NullTaskReturn scratch = uploadTask.Result;
                }
            }

            // Get the web response.
            Task <WebResponse> responseTask = request.GetResponseAsyncWithTimeout(this, this.Timeout);

            yield return(responseTask);

            // Materialize any exceptions.
            using (HttpWebResponse response = responseTask.Result as HttpWebResponse)
            {
            }
        }
Exemplo n.º 28
0
        /***************************************************/
        /**** Request Methods                           ****/
        /***************************************************/

        public static string ToSqlCommand(this TableRequest request)
        {
            string select = "*";

            if (request.Columns != null && request.Columns.Count > 0)
            {
                select = request.Columns.Aggregate((a, b) => a + ", " + b);
            }

            string where = "";
            if (!string.IsNullOrWhiteSpace(request.Filter))
            {
                where = "WHERE " + request.Filter;
            }

            return($"SELECT {select} FROM {request.Table} {where}");
        }
Exemplo n.º 29
0
        public int TableAdd(string tableName, bool isDaily)
        {
            //check duplicated
            TableRequest obj;

            try
            {
                obj = (from t in db.TableRequests
                       where t.TableName == tableName
                       select t).First();
            }
            catch (Exception) { obj = new TableRequest(); }
            obj.TableName = tableName;
            obj.IsDaily   = isDaily;
            db.TableRequests.InsertOnSubmit(obj);
            db.SubmitChanges();
            return(obj.Id);
        }
Exemplo n.º 30
0
        public TableResultJson <ViolenceWordViewModel> GetViolenceWordPaged(TableRequest request)
        {
            var dataSource          = violenceWordRepository.GetAll();
            var dataSourceViewModel = mapper.Map <IEnumerable <ViolenceWordViewModel> >(dataSource);

            var response = new TableResultJson <ViolenceWordViewModel>();

            response.draw            = request.draw;
            response.recordsFiltered = dataSourceViewModel.Count();
            dataSourceViewModel      = dataSourceViewModel.Skip(request.start).Take(request.length);
            response.data            = dataSourceViewModel.ToList();

            foreach (var item in response.data)
            {
                item.Index = response.data.IndexOf(item) + request.start + 1;
            }
            return(response);
        }
Exemplo n.º 31
0
        public JsonResult SelectCoopers(TableRequest request)
        {
            var           data     = _db.Coopers.WhereIf(request.KeyWord != null, x => x.Company.Contains(request.KeyWord) || x.Contact.Contains(request.KeyWord) || x.Detail.Contains(request.KeyWord) || x.Email.Contains(request.KeyWord) || x.LinkMan.Contains(request.KeyWord));
            TableResponse response = new TableResponse();

            response.Total = data.Count();
            response.Data  = data.OrderByDescending(x => x.CommitDateTime).Skip((request.Page - 1) * request.Limit).Take(request.Limit).Select(x => new
            {
                x.ID,
                ReadStatus = x.AlreadyRead.GetDescription(),
                x.Company,
                x.CommitDateTime,
                x.Contact,
                x.Detail,
                x.Email,
                x.LinkMan
            }).ToList();
            return(Json(response));
        }
Exemplo n.º 32
0
        public EmployeePagedCollection Create(TableRequest request)
        {
            IEnumerable<SimplifiedEmployeeViewModel> toTransfer;

            var totalCount = 0;
            var queryResult = employeeDataAccessObject.GetNextPage(request, gridPageSize);

            totalCount = queryResult.ResultQuantity;
            toTransfer = employeeService.SimplifyCollection(queryResult.Employees);

            return new EmployeePagedCollection()
            {
                Employees = toTransfer,
                Page = request.Page,
                TotalPages = employeeService.CalculatePages(gridPageSize, totalCount),
                SortColumn = request.SortingProperty,
                SortOrder = request.SortOrder,
                TotalRecords = totalCount
            };
        }
Exemplo n.º 33
0
        public PagingQueryResult GetNextPage(TableRequest request, int pageSize)
        {
            var projectId = request.ProjectId;
            var id = request.Id;
            var role = request.Role;
            var name = request.Name;
            var surname = request.Surname;
            var property = request.SortingProperty;
            var sortingOrder = request.SortOrder;
            var pageNumber = request.Page;

            var result = DirectSearch(name, surname, id, role, projectId)
                .OrderBy(property + (sortingOrder.Equals(SortEnum.asc) ? " descending" : ""));

            return new PagingQueryResult()
            {
                Employees = result
                    .Skip((pageNumber - 1)*pageSize)
                    .Take(pageSize),
                ResultQuantity = result.Count()
            };
        }
Exemplo n.º 34
0
        private TableRequest Bind(ModelBindingContext bindingContext)
        {
            var searchValueResult = bindingContext.ValueProvider.GetValue(keySearch);
            var pageValueResult = bindingContext.ValueProvider.GetValue(keyPage);
            var rowsValueResult = bindingContext.ValueProvider.GetValue(keyRows);
            var sortProperyValueResult = bindingContext.ValueProvider.GetValue(keySortProperty);
            var sortValueResult = bindingContext.ValueProvider.GetValue(keySortingOrder);
            var filtersValueResult = bindingContext.ValueProvider.GetValue(filters);
            var projectIdValueResult = bindingContext.ValueProvider.GetValue(projectId);

            var request = new TableRequest()
            {
                IsSearch = (bool)searchValueResult.ConvertTo(typeof(bool)),
                Page = (int)pageValueResult.ConvertTo(typeof(int)),
                Rows = (int)rowsValueResult.ConvertTo(typeof(int)),
                SortingProperty = (string)sortProperyValueResult.ConvertTo(typeof(string)),
                SortOrder = (SortEnum)Enum.Parse(typeof(SortEnum),(string)sortValueResult.ConvertTo(typeof(string))),
                ProjectId = ToNullableInt32((string)projectIdValueResult.ConvertTo(typeof(string)))
            };

            return filtersValueResult == null ? request : GetPropertyValues(request, filtersValueResult);
        }