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 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);
}
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);
}
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));
}
}
