public void WebGridLinqTest2() { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); Collection <NorthwindEmployee> employees = employeedata.GetAllEmployeesCollection("", 0, 100); var list = from test in employees where test.Region != "WA" select new { test.EmployeeID, test.FirstName }; Grid grid = new Grid(); grid.DataSource = list; grid.ID = "test"; int rows = grid.Rows.Count; // Return 5 rows. StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter gridwriter = new HtmlTextWriter(sw); grid.RenderControl(gridwriter); Assert.Greater(grid.MasterTable.Rows.Count, 1); Assert.AreEqual(rows, 4); foreach (WebGrid.Data.Row row in grid.Rows) { Assert.IsNotNull(row["EmployeeID"].Value); Assert.IsNotNull(row["FirstName"].Value); Assert.AreEqual(row["FirstName"].Value.GetType(), typeof(string)); // WebGrid is using int64 Assert.AreEqual(row["EmployeeID"].Value.GetType(), typeof(Int64)); } }
public void LoadGridWithNeedDataGridView() { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List <NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); Grid grid = new Grid(); grid.DataBind(); grid.ID = "test"; BeforeGetDataExecuted = 0; grid.BeforeGetData += grid_BeforeGetData; grid.Columns["EmployeeID"].ColumnType = WebGrid.Enums.ColumnType.Number; grid.Columns["EmployeeID"].Primarykey = true; grid.Columns["FirstName"].ColumnType = WebGrid.Enums.ColumnType.Text; grid.Columns["LastName"].ColumnType = WebGrid.Enums.ColumnType.Text; grid.Columns["Address"].ColumnType = WebGrid.Enums.ColumnType.Text; grid.Columns["BirthDay"].ColumnType = WebGrid.Enums.ColumnType.DateTime; grid.Columns["CustomerType"].ColumnType = WebGrid.Enums.ColumnType.Foreignkey; grid.Columns["CustomerType"].AllowEditInGrid = true; grid.Columns["CustomerType2"].ColumnType = WebGrid.Enums.ColumnType.Foreignkey; grid.Columns["CustomerType2"].AllowEditInGrid = true; ((WebGrid.Foreignkey)grid.Columns["CustomerType"]).ValueColumn = "title"; StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter gridwriter = new HtmlTextWriter(sw); grid.RenderControl(gridwriter); Assert.AreEqual(BeforeGetDataExecuted, 1); Assert.AreEqual(grid.MasterTable.Rows.Count, employees.Count); Assert.AreEqual(((WebGrid.Foreignkey)grid.Columns["CustomerType"]).Table.Rows.Count, 3); Assert.AreEqual(((WebGrid.Foreignkey)grid.Columns["CustomerType2"]).Table.Rows.Count, 9); Assert.AreEqual(grid.SystemMessage.Count, 0); }
public void LoadGridWithEmployeesGenericList() { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List<NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); Grid grid = new Grid(); grid.DataSource = employees; grid.ID = "test"; StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter gridwriter = new HtmlTextWriter(sw); grid.RenderControl(gridwriter); Assert.AreEqual(grid.MasterTable.Rows.Count, employees.Count); }
public void LoadGridWithEmployeesGenericCollection() { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); Collection <NorthwindEmployee> employees = employeedata.GetAllEmployeesCollection("", 0, 100); Grid grid = new Grid(); grid.DataSource = employees; grid.ID = "test"; StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter gridwriter = new HtmlTextWriter(sw); grid.RenderControl(gridwriter); Assert.AreEqual(grid.MasterTable.Rows.Count, employees.Count); }
void grid_BeforeGetData(object sender, WebGrid.Events.BeforeGetDataEventArgs e) { if (e.Table == ((Grid)sender).MasterTable) { BeforeGetDataExecuted++; NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List <NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); e.Table.DataSource = employees; } else if (e.Table == ((WebGrid.Foreignkey)((Grid)sender).Columns["CustomerType"]).Table) { e.Table.Columns["CustomerType"].ColumnType = WebGrid.Enums.ColumnType.Number; e.Table.Columns["Title"].ColumnType = WebGrid.Enums.ColumnType.Text; WebGrid.Data.Row row = new WebGrid.Data.Row(e.Table); row["CustomerType"].Value = 1; row["Title"].Value = "Title"; e.Table.Rows.Add(row); row = new WebGrid.Data.Row(e.Table); row["CustomerType"].Value = 2; row["Title"].Value = "Title"; e.Table.Rows.Add(row); row = new WebGrid.Data.Row(e.Table); row["CustomerType"].Value = 3; row["Title"].Value = "Title"; e.Table.Rows.Add(row); } else if (e.Table == ((WebGrid.Foreignkey)((Grid)sender).Columns["CustomerType2"]).Table) { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List <NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); e.Table.DataSource = employees; } }
void grid_BeforeGetData(object sender, WebGrid.Events.BeforeGetDataEventArgs e) { if (e.Table == ((Grid)sender).MasterTable) { BeforeGetDataExecuted++; NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List<NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); e.Table.DataSource = employees; } else if (e.Table == ((WebGrid.Foreignkey)((Grid)sender).Columns["CustomerType"]).Table) { e.Table.Columns["CustomerType"].ColumnType = WebGrid.Enums.ColumnType.Number; e.Table.Columns["Title"].ColumnType = WebGrid.Enums.ColumnType.Text; WebGrid.Data.Row row = new WebGrid.Data.Row(e.Table); row["CustomerType"].Value = 1; row["Title"].Value = "Title"; e.Table.Rows.Add(row); row = new WebGrid.Data.Row(e.Table); row["CustomerType"].Value = 2; row["Title"].Value = "Title"; e.Table.Rows.Add(row); row = new WebGrid.Data.Row(e.Table); row["CustomerType"].Value = 3; row["Title"].Value = "Title"; e.Table.Rows.Add(row); } else if (e.Table == ((WebGrid.Foreignkey)((Grid)sender).Columns["CustomerType2"]).Table) { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List<NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); e.Table.DataSource = employees; } }
public void WebGridLinqTest2() { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); Collection<NorthwindEmployee> employees = employeedata.GetAllEmployeesCollection("", 0, 100); var list = from test in employees where test.Region != "WA" select new { test.EmployeeID, test.FirstName }; Grid grid = new Grid(); grid.DataSource = list; grid.ID = "test"; int rows = grid.Rows.Count; // Return 5 rows. StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter gridwriter = new HtmlTextWriter(sw); grid.RenderControl(gridwriter); Assert.Greater(grid.MasterTable.Rows.Count, 1); Assert.AreEqual(rows, 4); foreach (WebGrid.Data.Row row in grid.Rows) { Assert.IsNotNull(row["EmployeeID"].Value); Assert.IsNotNull(row["FirstName"].Value); Assert.AreEqual(row["FirstName"].Value.GetType(), typeof(string)); // WebGrid is using int64 Assert.AreEqual(row["EmployeeID"].Value.GetType(), typeof(Int64)); } }
public void LoadGridWithNeedDataGridView() { NorthwindEmployeeData employeedata = new NorthwindEmployeeData(); List<NorthwindEmployee> employees = employeedata.GetAllEmployeesList("", 0, 100); Grid grid = new Grid(); grid.DataBind(); grid.ID = "test"; BeforeGetDataExecuted = 0; grid.BeforeGetData += grid_BeforeGetData; grid.Columns["EmployeeID"].ColumnType = WebGrid.Enums.ColumnType.Number; grid.Columns["EmployeeID"].Primarykey = true; grid.Columns["FirstName"].ColumnType = WebGrid.Enums.ColumnType.Text; grid.Columns["LastName"].ColumnType = WebGrid.Enums.ColumnType.Text; grid.Columns["Address"].ColumnType = WebGrid.Enums.ColumnType.Text; grid.Columns["BirthDay"].ColumnType = WebGrid.Enums.ColumnType.DateTime; grid.Columns["CustomerType"].ColumnType = WebGrid.Enums.ColumnType.Foreignkey; grid.Columns["CustomerType"].AllowEditInGrid = true; grid.Columns["CustomerType2"].ColumnType = WebGrid.Enums.ColumnType.Foreignkey; grid.Columns["CustomerType2"].AllowEditInGrid = true; ((WebGrid.Foreignkey)grid.Columns["CustomerType"]).ValueColumn = "title"; StringBuilder sb = new StringBuilder(); StringWriter sw = new StringWriter(sb); HtmlTextWriter gridwriter = new HtmlTextWriter(sw); grid.RenderControl(gridwriter); Assert.AreEqual(BeforeGetDataExecuted, 1); Assert.AreEqual(grid.MasterTable.Rows.Count, employees.Count); Assert.AreEqual( ((WebGrid.Foreignkey)grid.Columns["CustomerType"]).Table.Rows.Count, 3); Assert.AreEqual(((WebGrid.Foreignkey)grid.Columns["CustomerType2"]).Table.Rows.Count, 9); Assert.AreEqual(grid.SystemMessage.Count, 0); }