示例#1
0
        public DatatableRecords GetPagedRecords(DatatableFilters filters)
        {
            // Let's create the actual data to go into the table
            List <string[]> dtData = new List <string[]>();

            for (int i = 0; i < 15; i++)
            {
                dtData.Add(new string[] {
                    string.Format("first column paged row {0}", i + 1),
                    string.Format("second column paged row {0}", i + 1)
                });
            }

            DatatableRecords dtRecords = new DatatableRecords
            {
                sEcho                = filters.sEcho,
                iTotalRecords        = dtData.Count(),              // Total records in table
                iTotalDisplayRecords = dtData.Count(),              // Total records to be displayed in the table
                aaData               = dtData
                                       .Skip(filters.iDisplayStart) // The data to be displayed
                                       .Take(filters.iDisplayLength)
                                       .ToArray()
            };

            return(dtRecords);
        }
示例#2
0
        //
        // GET: /JQueryUI/Core/GetPostbackData
        public virtual JsonResult GetPostbackData(DatatableFilters filters, PostbackSetupViewModel postbacks)
        {
            IEnumerable <string[]> dtData = new string[][]
            {
                new string[] { "first column row 1", "second column row 1" },
                new string[] { "first column row 2", "second column row 2" },
                new string[] { "first column row 3", "second column row 3" },
                new string[] { "first column row 4", "second column row 4" }
            };

            if (!string.IsNullOrEmpty(postbacks.FirstColumn))
            {
                dtData = dtData.Where(f => f[0].ContainsIgnoreCase(postbacks.FirstColumn));
            }
            if (!string.IsNullOrEmpty(postbacks.SecondColumn))
            {
                dtData = dtData.Where(f => f[1].ContainsIgnoreCase(postbacks.SecondColumn));
            }

            DatatableRecords dtRecords = new DatatableRecords
            {
                sEcho                = filters.sEcho,
                iTotalRecords        = dtData.Count(),
                iTotalDisplayRecords = dtData.Count(),
                aaData               = dtData.ToArray()
            };

            return(Json(dtRecords, JsonRequestBehavior.AllowGet));
        }
示例#3
0
        public void From_Returns_Correct_Records()
        {
            // Arrange
            DatatableTestClass[] records = DatatableTestClass.CreateData();

            // Act
            DatatableRecords result = DatatableRecords.From(records);

            // Assert
            Assert.AreEqual(5, result.aaData.Length);
        }
示例#4
0
        public void Ctor_Test()
        {
            // Act
            m_records = new DatatableRecords();

            // Assert
            Assert.AreEqual("1", m_records.sEcho);
            Assert.AreEqual(0, m_records.iTotalRecords);
            Assert.AreEqual(0, m_records.iTotalDisplayRecords);
            Assert.IsNotNull(m_records.aaData);
            Assert.AreEqual(0, m_records.aaData.Count());
        }
示例#5
0
 public void Initialize()
 {
     m_records        = new DatatableRecords();
     m_records.aaData = new List <string[]>
     {
         new[] { "<a href='/displayplan/4'>4</a>", "mihir", "02-Jan-13", "&euro;15.00" },
         new[] { "<a href='/displayplan/24'>3</a>", "sneha", "2013-Mar-12", "&pound;12.00" },
         new[] { "<a href='/displayplan/11'>1</a>", "mohan", "20 Mar 13", "$151.00" },
         new[] { "<a href='/displayplan/16'>2</a>", "swati", "29May13", "$201.00" }
     }.ToArray();
     m_records.iTotalDisplayRecords = m_records.aaData.Count();
     m_records.iTotalRecords        = m_records.aaData.Count();
 }
示例#6
0
        public DatatableRecords GetSortedRecords(DatatableFilters filters)
        {
            // Let's create the actual data to go into the table
            IList <string[]> dtData = DatatableGenerator.GetDataWithSpecialFormat();

            DatatableRecords dtRecords = new DatatableRecords
            {
                sEcho                = filters.sEcho,
                iTotalRecords        = dtData.Count(),                                  // Total records in table
                iTotalDisplayRecords = dtData.Count(),                                  // Total records to be displayed in the table
                aaData               = dtData
                                       .Sort(filters.iSortCol_0, filters.SortDirection) // The data to be displayed
                                       .ToArray()
            };

            return(dtRecords);
        }
示例#7
0
        public virtual ActionResult Datatables(DatatablesViewModel viewModel)
        {
            // create the basic table again
            IEnumerable <AOColumn> dtAOColumns = new List <AOColumn> {
                new AOColumn {
                    sTitle = "First Column", sWidth = "25%"
                },
                new AOColumn {
                    sTitle = "Second Column"
                }
            };

            DatatableSettings dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), null, "basic records", "150px");

            dtSettings.bJQueryUI = true;

            IEnumerable <string[]> dtData = new string[][]
            {
                new string[] { "first column row 1", "second column row 1" },
                new string[] { "first column row 2", "second column row 2" },
                new string[] { "first column row 3", "second column row 3" },
                new string[] { "first column row 4", "second column row 4" }
            };

            DatatableRecords dtRecords = new DatatableRecords
            {
                iTotalRecords        = dtData.Count(), // Total records in table
                iTotalDisplayRecords = dtData.Count(), // Total records to be displayed in the table
                aaData = dtData.ToArray()              // The data to be displayed
            };

            viewModel.Table = new Datatable("basic-table", dtSettings, dtRecords);

            // create the postbacks enabled table
            IEnumerable <PostbackItem> dtPostbacks = PostbackItem.FromObject(viewModel.PostbackFormFields);

            dtSettings                     = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetPostbackData, "searched/filtered records", "150px");
            dtSettings.bJQueryUI           = true;
            viewModel.PostbackEnabledTable = new Datatable("postbacks-table", dtSettings, null, dtPostbacks);

            // update the display mode
            viewModel.DisplayMode = 6;

            return(View(MVC.JQueryUI.Core.Views.Datatables, viewModel));
        }
示例#8
0
        //
        // GET: /Bootstrap/Core/GetAjaxData
        public virtual JsonResult GetAjaxData(DatatableFilters filters)
        {
            // Let's create the actual data to go into the table
            string[][] dtData = new string[][]
            {
                new string[] { "first column ajax row 1", "second column ajax row 1" },
                new string[] { "first column ajax row 2", "second column ajax row 2" }
            };

            DatatableRecords dtRecords = new DatatableRecords
            {
                sEcho                = filters.sEcho,
                iTotalRecords        = dtData.Length,                                 // Total records in table
                iTotalDisplayRecords = dtData.Length,                                 // Total records to be displayed in the table
                aaData               = dtData                                         // The data to be displayed
            };

            return(Json(dtRecords, JsonRequestBehavior.AllowGet));
        }
示例#9
0
        //
        // GET: /Bootstrap/Core/Datatables
        public virtual ActionResult Datatables(int?mode)
        {
            if (!mode.HasValue)
            {
                return(RedirectToAction(Actions.Datatables(0)));
            }

            DatatablesViewModel model = new DatatablesViewModel();
            string tableId            = string.Empty;
            string tableHeight        = null;

            IEnumerable <AOColumn> dtAOColumns = new List <AOColumn> {
                new AOColumn {
                    sTitle = "First Column", sWidth = "25%"
                },
                new AOColumn {
                    sTitle = "Second Column"
                }
            };

            DatatableSettings dtSettings = null;
            DatatableRecords  dtRecords  = null;
            bool enableStatusColumn      = false;

            switch (mode)
            {
            case 1:
                tableId    = "ajax-table";
                dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetAjaxData, "ajax records", tableHeight);
                break;

            case 2:
                tableId    = "paged-table";
                dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetPagedData, "paged records", tableHeight);
                dtRecords  = GetPagedRecords(new DatatableFilters {
                    iDisplayStart = 0, iDisplayLength = 5
                });
                break;

            case 3:
                tableId     = "paged-and-sorted-table";
                dtAOColumns = new List <AOColumn>
                {
                    new AOColumn {
                        sTitle = "HTML field column", bSortable = true
                    },
                    new AOColumn {
                        sTitle = "String Column", bSortable = true
                    },
                    new AOColumn {
                        sTitle = "DateTime Column", bSortable = true
                    },
                    new AOColumn {
                        sTitle = "Numeric Column", bSortable = true
                    },
                    new AOColumn {
                        sTitle = "Currency Column", bSortable = true
                    }
                };
                dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), MVC.Bootstrap.Core.ActionNames.GetSortedData, "sorted records", tableHeight);
                dtRecords  = GetSortedRecords(new DatatableFilters {
                    iDisplayStart = 0, iDisplayLength = 5
                });
                break;

            case 4:
                tableId    = "status-table";
                dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), null, "status records", tableHeight);
                IEnumerable <string[]> statusData = DatatableGenerator.GetDefaultDataWithStatusColumn();
                enableStatusColumn = true;
                dtRecords          = new DatatableRecords
                {
                    iTotalRecords        = statusData.Count(),
                    iTotalDisplayRecords = statusData.Count(),
                    aaData = statusData.ToArray()
                };
                break;

            case 0:
            case 5:
            default:
                tableId    = "basic-table";
                dtSettings = new DatatableSettings(5, dtAOColumns, new AASort(0, ESort.Ascending), null, "basic records", tableHeight);
                IEnumerable <string[]> dtData = DatatableGenerator.GetDefaultData();

                dtRecords = new DatatableRecords
                {
                    iTotalRecords        = dtData.Count(), // Total records in table
                    iTotalDisplayRecords = dtData.Count(), // Total records to be displayed in the table
                    aaData = dtData.ToArray()              // The data to be displayed
                };
                break;
            }

            // Let's create the datatable object with an HTML ID, our settings, columns and records
            model.DisplayMode = mode.Value;
            model.Table       = new Datatable(tableId, dtSettings, dtRecords, null, enableStatusColumn);
            return(View(model));
        }
示例#10
0
        //
        // GET: /Bootstrap/Core/GetSortedData
        public virtual JsonResult GetSortedData(DatatableFilters filters)
        {
            DatatableRecords dtRecords = GetSortedRecords(filters);

            return(Json(dtRecords, JsonRequestBehavior.AllowGet));
        }