Пример #1
0
        public async Task <JsonResult> GetAllAddressTypes()
        {
            try
            {
                var draw = HttpContext.Request.Query["draw"].FirstOrDefault();
                // Skiping number of Rows count
                var start = Request.Query["start"].FirstOrDefault();
                // Paging Length 10,20
                var length = Request.Query["length"].FirstOrDefault();
                // Sort Column Name
                var sortColumn = Request
                                 .Query["columns[" + Request.Query["order[0][column]"].FirstOrDefault() + "][name]"]
                                 .FirstOrDefault();
                // Sort Column Direction ( asc ,desc)
                var sortColumnDirection = Request.Query["order[0][dir]"].FirstOrDefault();
                // Search Value from (Search box)
                var searchValue = Request.Query["search[value]"].FirstOrDefault();

                //Paging Size (10,20,50,100)
                var pageSize = length != null?Convert.ToInt32(length) : 0;

                var skip = start != null?Convert.ToInt32(start) : 0;

                var recordsTotal = 0;


                var listOfAddressTypes = await _lookUpService.GetAddressTypeDetails();

                // Getting all Customer data  z
                var allAddressTypes = listOfAddressTypes;

                //Search
                if (!string.IsNullOrEmpty(searchValue))
                {
                    allAddressTypes = allAddressTypes.Where(m =>
                                                            m.AddressTypeCode == searchValue ||
                                                            m.AddressTypeName == searchValue)
                                      as List <AddressTypeDetailsDTO>;
                }

                //total number of rows count
                recordsTotal = allAddressTypes.Count();
                //Paging
                var data = allAddressTypes.Skip(skip).Take(pageSize).ToList();
                //Returning Json Data
                return(Json(new
                            { draw = draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, data = allAddressTypes }));
            }
            catch (Exception)
            {
                throw;
            }
        }