Esempio n. 1
0
        public dynamic GetList(string _search, long nd, int rows, int?page, string sidx, string sord, string filters = "")
        {
            // Construct where statement
            string strWhere = GeneralFunction.ConstructWhere(filters);
            string filter   = null;

            GeneralFunction.ConstructWhereInLinq(strWhere, out filter);
            if (filter == "")
            {
                filter = "true";
            }

            // Get Data
            var q = _salesInvoiceService.GetQueryable().Include("DeliveryOrder");

            var query = (from model in q
                         select new
            {
                model.Id,
                model.Code,
                model.DeliveryOrderId,
                deliveryorder = model.DeliveryOrder.Code,
                model.Description,
                model.Discount,
                model.IsTaxable,
                model.InvoiceDate,
                model.DueDate,
                model.AmountReceivable,
                model.IsConfirmed,
                model.ConfirmationDate,
                model.CreatedAt,
                model.UpdatedAt,
            }).Where(filter).OrderBy(sidx + " " + sord);              //.ToList();

            var list = query.AsEnumerable();

            var pageIndex    = Convert.ToInt32(page) - 1;
            var pageSize     = rows;
            var totalRecords = query.Count();
            var totalPages   = (int)Math.Ceiling((float)totalRecords / (float)pageSize);

            // default last page
            if (totalPages > 0)
            {
                if (!page.HasValue)
                {
                    pageIndex = totalPages - 1;
                    page      = totalPages;
                }
            }

            list = list.Skip(pageIndex * pageSize).Take(pageSize);

            return(Json(new
            {
                total = totalPages,
                page = page,
                records = totalRecords,
                rows = (
                    from model in list
                    select new
                {
                    id = model.Id,
                    cell = new object[] {
                        model.Id,
                        model.Code,
                        model.DeliveryOrderId,
                        model.deliveryorder,
                        model.Description,
                        model.Discount,
                        model.IsTaxable,
                        model.InvoiceDate,
                        model.DueDate,
                        model.AmountReceivable,
                        model.IsConfirmed,
                        model.ConfirmationDate,
                        model.CreatedAt,
                        model.UpdatedAt,
                    }
                }).ToArray()
            }, JsonRequestBehavior.AllowGet));
        }