public void GetPageSize()
{
this.driver.Navigate().GoToUrl(@"http://demos.telerik.com/kendo-ui/grid/index");
var kendoGrid = new KendoGrid(this.driver, this.driver.FindElement(By.Id("grid")));
var pageNumber = kendoGrid.GetPageSize();
Assert.AreEqual(20, pageNumber);
}
public void DeleteRow(KendoGrid grid, string value, int searchColumn)
{
var rows = grid.DataItems;
HtmlAnchor deleteButton = null;
foreach (var row in rows)
{
if (row[searchColumn].InnerText == value)
{
// It works only on Internet Explorer on my machine
deleteButton = row.Find.ByExpression<HtmlAnchor>("class=~k-grid-delete");
deleteButton.ScrollToVisible();
this.Browser.RefreshDomTree();
var deleteRectangle = deleteButton.GetRectangle();
var currentManager = Manager.Current;
AlertDialog alertDialog = new AlertDialog(this.Browser, DialogButton.OK);
currentManager.DialogMonitor.AddDialog(alertDialog);
currentManager.Desktop.Mouse.Click(MouseClickType.LeftClick, deleteRectangle);
this.Browser.Desktop.KeyBoard.KeyPress(Keys.Return);
}
}
}
public JsonResult Export(KendoGridRequest request)
{
var employees = GetEmployees();
var grid = new KendoGrid<Employee>(request, employees);
return Json(grid);
}
public JsonResult Grid(KendoGridRequest request)
{
Mapper.CreateMap<Employee, EmployeeDto>();
var employees = _employeeRepository.All;
var dto = Mapper.Map<IEnumerable<Employee>, IEnumerable<EmployeeDto>>(employees);
var grid = new KendoGrid<EmployeeDto>(request, dto);
return Json(grid);
}
public void GetAllItems()
{
this.driver.Navigate().GoToUrl(@"http://demos.telerik.com/kendo-ui/grid/index");
var kendoGrid = new KendoGrid(this.driver, this.driver.FindElement(By.Id("grid")));
var items = kendoGrid.GetItems<GridItem>();
Assert.AreEqual(91, items.Count);
}
public void FilterContactName()
{
this.driver.Navigate().GoToUrl(@"http://demos.telerik.com/kendo-ui/grid/index");
var kendoGrid = new KendoGrid(this.driver, this.driver.FindElement(By.Id("grid")));
kendoGrid.Filter("ContactName", Enums.FilterOperator.Contains, "Thomas");
var items = kendoGrid.GetItems<GridItem>();
Assert.AreEqual(1, items.Count);
}
public JsonResult AjaxBinding(KendoGridRequest request, string keyWord, string downloadClassId)
{
SetConditions(keyWord, downloadClassId);
var data = GetGridData();
var result = new KendoGrid<DownloadRecord>(request, data.Skip((request.Page - 1) * request.PageSize).Take(request.PageSize), data.Count());
return Json(result);
}
public void SortContactTitleDesc()
{
this.driver.Navigate().GoToUrl(@"http://demos.telerik.com/kendo-ui/grid/index");
var kendoGrid = new KendoGrid(this.driver, this.driver.FindElement(By.Id("grid")));
kendoGrid.Sort("ContactTitle", SortType.Desc);
var items = kendoGrid.GetItems<GridItem>();
Assert.AreEqual("Sales Representative", items[0]);
Assert.AreEqual("Sales Representative", items[1]);
}
public JsonResult AdditionalLinks(KendoGridRequest request)
{
var employees = new List<AdditionalLinks>
{
new AdditionalLinks { Id = 1, Name = "Bill", Url= "Jones"},
new AdditionalLinks { Id = 2, Name = "Rob", Url = "Johnson"},
new AdditionalLinks { Id = 3, Name = "Jane", Url = "Smith"},
};
var grid = new KendoGrid<AdditionalLinks>(request, employees);
return Json(grid);
}
public JsonResult AjaxBinding(KendoGridRequest request, string keyWord, string downloadClassId, string memberLoginId)
{
SetConditions(keyWord, downloadClassId, memberLoginId);
int total = GetGridTotal();
int pageIndex = (request.Page - 1);
m_Conditions.Add("PageIndex", pageIndex.ToString());
m_Conditions.Add("PageSize", request.PageSize.ToString());
AppendSortingCondition(request);
var data = GetGridData();
var result = new KendoGrid<DownloadRecord>(request, data, total);
return Json(result);
}
public JsonResult Grid(KendoGridRequest request)
{
var fromdb = ((Log)_table).All();
var dto = fromdb.Select(x => new LogDto
{
UpdatedAt = x.UpdatedAt,
IpAddress = x.IpAddress, Level = x.Level, Server = x.Server,
Session=x.Session, UserName= x.UserName,
Summary = x.Summary, Id = x.Id,
Email = x.Email
}).OrderByDescending(x => x.UpdatedAt);
var grid = new KendoGrid<LogDto>(request, dto);
return Json(grid);
}
public JsonResult Grid2(KendoGridRequest request)
{
var employees = new List<Employee>
{
new Employee { EmployeeId = 1, HireDate = new DateTime(2012, 1, 13), FirstName = "Bill", LastName = "Jones", Email = "*****@*****.**" },
new Employee { EmployeeId = 2, HireDate = new DateTime(2012, 2, 16), FirstName = "Rob", LastName = "aaaaaa", Email = "*****@*****.**" },
new Employee { EmployeeId = 3, HireDate = new DateTime(2012, 3, 14), FirstName = "Jane", LastName = "ssss", Email = "*****@*****.**" },
new Employee { EmployeeId = 4, HireDate = new DateTime(2012, 4, 12), FirstName = "bbb", LastName = "ggg", Email = "*****@*****.**" },
new Employee { EmployeeId = 5, HireDate = new DateTime(2012, 5, 1), FirstName = "cccc", LastName = "ff", Email = "*****@*****.**" },
new Employee { EmployeeId = 6, HireDate = new DateTime(2012, 7, 12), FirstName = "dddd", LastName = "eeee", Email = "*****@*****.**" },
};
var grid = new KendoGrid<Employee>(request, employees);
return Json(grid);
}
public JsonResult Grid(KendoGridRequest request)
{
var fromdb = ((Projects)_table).All();
var dto = fromdb.Select(x => new ProjectsDto
{
Id = x.Id,
UpdatedAt = x.UpdatedAt,
Name = x.Name
/*FirstName = x.FirstName,
LastName = x.LastName,
Email = x.Email, Level = x.Level, Server = x.Server, UserName= x.UserName,
Summary = x.Summary,
Email = x.Email*/
}).OrderByDescending(x => x.UpdatedAt);
var grid = new KendoGrid< ProjectsDto>(request, dto);
return Json(grid);
}
public JsonResult Grid(KendoGridRequest request)
{
var fromdb = ((Customer)_table).All();
var dto = fromdb.Select(x => new CustomerDto
{
Id = x.Id,
UpdatedAt = x.UpdatedAt,
IpAddress = x.IpAddress,
Session = x.Session,
City = "xxxxxxxxx",
State = "xxxxxxxxx",
Zip = "xxxxxxxxx",
FirstName = x.FirstName,
LastName = x.LastName,
Email = x.Email
}).OrderByDescending(x => x.UpdatedAt);
var grid = new KendoGrid< CustomerDto>(request, dto);
return Json(grid);
}
public JsonResult Grid(KendoGridRequest request)
{
var fromdb = ((Product)_table).All();
var dto = fromdb.Select(x => new ProductDto
{
Id = x.Id,
UpdatedAt = x.UpdatedAt,
Title = x.Title,
Price = x.Price,
MemberPrice = x.MemberPrice,
ImageUrl = "/Public/images/picture2.jpg"
/*IpAddress = x.IpAddress,
Session = x.Session,
FirstName = x.FirstName,
LastName = x.LastName,
Email = x.Email, Level = x.Level, Server = x.Server, UserName= x.UserName,
Summary = x.Summary,
Email = x.Email*/
}).OrderByDescending(x => x.UpdatedAt);
var grid = new KendoGrid< ProductDto>(request, dto);
return Json(grid);
}
public void DeleteRow(KendoGrid grid, string value, int searchColumn)
{
var rows = grid.DataItems;
HtmlAnchor deleteButton = null;
foreach (var row in rows)
{
if (row[searchColumn].InnerText == value)
{
deleteButton = row.Find.ByExpression<HtmlAnchor>("class=~k-grid-delete");
deleteButton.ScrollToVisible();
this.Browser.RefreshDomTree();
var currentManager = Manager.Current;
var deleteRectangle = deleteButton.GetRectangle();
AlertDialog alertDialog = new AlertDialog(this.Browser, DialogButton.OK);
currentManager.DialogMonitor.AddDialog(alertDialog);
currentManager.Desktop.Mouse.Click(MouseClickType.LeftClick, deleteRectangle);
alertDialog.WaitUntilHandled(5000);
}
}
}
//asdf
public GridEntity <StickyEnds> GetSummary(GridOptions options, string from, string to)
{
return(KendoGrid <StickyEnds> .GetGridData_5(options, "SP_SELECT_STICKY_END_GRID", "GET_SUMMARY", "SDate", from, to));
}
public JsonResult AjaxBinding(KendoGridRequest request, string templateType)
{
var data = GetGridData(templateType);
var result = new KendoGrid<TemplateVO>(request, data.Skip((request.Page - 1) * request.PageSize).Take(request.PageSize), data.Count());
return Json(result);
}
public GridEntity <StickyEndsDetails> GetDetail(GridOptions options, string sID)
{
return(KendoGrid <StickyEndsDetails> .GetGridData_5(options, "SP_SELECT_STICKY_END_GRID", "GET_DETAIL", "SID", sID));
}
public static void AssertRoleIsPresentInGrid(this RolesPage rolePage, KendoGrid grid, string roleName)
{
var isContained = grid.ContainsValueInColumn(roleName, 2);
Assert.IsTrue(isContained);
}
public JsonResult Grid(KendoGridRequest request)
{
db.Configuration.ProxyCreationEnabled = false;
var projects = db.Projects.Include("Predictions").OrderByDescending(d => d.StartOn).ToList();
foreach (var x in projects)
{
if (x.ProjectNo == null) x.ProjectNo = "";
if (x.CustomerCode == null) x.CustomerCode = "";
if (x.CustomerName == null) x.CustomerName = "";
}
var grid = new KendoGrid<Project>(request, projects);
return Json(grid);
}
public JsonResult AjaxBinding(KendoGridRequest request, string enterTimeFrom, string enterTimeTo)
{
SetConditions(enterTimeFrom, enterTimeTo);
int total = GetGridTotal();
int pageIndex = (request.Page - 1);
m_Conditions.Add("PageIndex", pageIndex.ToString());
m_Conditions.Add("PageSize", request.PageSize.ToString());
AppendSortingCondition(request);
var data = GetGridData();
var result = new KendoGrid<MasterLog>(request, data, total);
return Json(result);
}
public GridEntity <R_UnitDept> GetDepartmentPermissionSummary(GridOptions options, string UnitId)
{
return(KendoGrid <R_UnitDept> .GetGridData(options, "sp_Select_Unit_Grid", "get_Department_permission", "DepartmentName", 0, UnitId));
}
public KendoGrid <StrategyForDisplay> GetAll(int page)
{
KendoGrid <StrategyForDisplay> strategies = _strategiesOrchestrator.GetStrategies(page);
return(strategies);
}
public GridEntity <LoomDownTimeMaster> GetSummaryData(GridOptions options, string from, string to)
{
return(KendoGrid <LoomDownTimeMaster> .GetGridData_5(options, "SP_SELECT_LOOM_DOWN_TIME_GRID", "GET_SUMMARY_DATA", "LoomDate", from, to));
}
public JsonResult CategoryGrid(KendoGridRequest request)
{
db.Configuration.ProxyCreationEnabled = false;
var categories = (from c in db.Categories
orderby c.OrderBy, c.Name
select new CategoryForIndex
{
WorkCategoryId = c.WorkCategoryId,
Name = c.Name,
OrderBy = c.OrderBy
}).ToList();
var grid = new KendoGrid<CategoryForIndex>(request, categories);
return Json(grid);
}
public static void AssertUniversityIsPresentInGrid(this UniversitiesPage uniPage, KendoGrid grid, string universityName)
{
var isContained = grid.ContainsValueInColumn(universityName, 1);
Assert.IsTrue(isContained);
}
public JsonResult GetEmployeeNameList(KendoGridRequest request)
{
db.Configuration.ProxyCreationEnabled = false;
if (User.IsInRole("工程師"))
{
return Json("{}");
}
else
{
var employee = db.Employees.ToList();
var grid = new KendoGrid<Employee>(request, employee);
return Json(grid);
}
}
//asdf
public GridEntity <TblStock11> GetSummary(GridOptions options, string from, string to)
{
return(KendoGrid <TblStock11> .GetGridData_5(options, "SP_SELECT_INSPECTION_PRODUCTION_GRID", "GET_SUMMARY", "ID", from, to));
}
public JsonResult Grid(KendoGridRequest request)
{
// Sample here: https://github.com/rwhitmire/KendoGridBinder
db.Configuration.ProxyCreationEnabled = false;
var emp = db.Employees.Include("Rank").Where(e => e.Account == User.Identity.Name).FirstOrDefault();
List<DailyInfoForIndex> dailies = new List<DailyInfoForIndex>();
if (emp.Rank.Name == "工程師")
{
dailies = (from d in db.Dailies.Include("WorkCategory").Include("Project")
where d.EmployeeId == emp.EmployeeId
select new DailyInfoForIndex
{
DailyInfoId = d.DailyInfoId,
CreateDate = d.CreateDate,
EmployeeId = d.DailyInfoId,
Customer = d.Project.CustomerName,
ProjectNo = d.Project.ProjectNo,
WorkContent = d.WorkContent,
WorkingHours = d.WorkingHours,
WorkCategory = d.WorkCategory.Name,
EmployeeName = d.Employee.Name
}).OrderByDescending(d => d.CreateDate).ToList();
}
else
{
dailies = (from d in db.Dailies.Include("WorkCategory").Include("Project")
select new DailyInfoForIndex
{
DailyInfoId = d.DailyInfoId,
CreateDate = d.CreateDate,
EmployeeId = d.DailyInfoId,
Customer = d.Project.CustomerName,
ProjectNo = d.Project.ProjectNo,
WorkContent = d.WorkContent,
WorkingHours = d.WorkingHours,
WorkCategory = d.WorkCategory.Name,
EmployeeName = d.Employee.Name
}).OrderByDescending(d => d.CreateDate).ToList();
foreach (var daily in dailies)
{
if (daily.ProjectNo == null) daily.ProjectNo = "";
}
}
var grid = new KendoGrid<DailyInfoForIndex>(request, dailies);
return Json(grid);
}
public static void AssertWorkEducationStatusIsPresentInGrid(this WorkEducationStatusesPage workEducationStatusPage, KendoGrid grid, string statusName)
{
var isContained = grid.ContainsValueInColumn(statusName, 1);
Assert.IsTrue(isContained);
}
public GridEntity <ShiftEntity> GetShiftEntity(GridOptions options)
{
var shift = KendoGrid <ShiftEntity> .GetGridData_5(options, "sp_select_shift_grid", "get_shift_summary", "ShiftNo");
return(shift);
}
public void SortByName(KendoGrid grid)
{
this.NameHeader.Click();
}
public void SortById(KendoGrid grid)
{
this.IdHeader.Click();
}
public JsonResult AjaxBinding(KendoGridRequest request, string keyWord)
{
SetConditions(keyWord);
int total = GetGridTotal();
int pageIndex = (request.Page - 1);
m_Conditions.Add("PageIndex", pageIndex.ToString());
m_Conditions.Add("PageSize", request.PageSize.ToString());
AppendSortingCondition(request);
var data = GetGridData();
var result = new KendoGrid<Activity>(request, data, total);
return Json(result);
}
public void EditRow(KendoGrid grid, string value, string idOfEditField, string newValue, int searchColumn)
{
var rows = grid.DataItems;
HtmlAnchor editButton = null;
foreach (var row in rows)
{
if (row[searchColumn].InnerText == value)
{
editButton = row.Find.ByExpression<HtmlAnchor>("class=~k-grid-edit");
editButton.ScrollToVisible();
editButton.Click();
Thread.Sleep(1000);
var nameBox = this.NameTextbox.GetRectangle();
var currentManager = Manager.Current;
currentManager.Desktop.Mouse.Click(MouseClickType.LeftClick, nameBox);
currentManager.Desktop.KeyBoard.KeyDown(Keys.ControlKey);
currentManager.Desktop.KeyBoard.KeyPress(Keys.A);
currentManager.Desktop.KeyBoard.KeyUp(Keys.ControlKey);
currentManager.Desktop.KeyBoard.KeyPress(Keys.Delete);
currentManager.Desktop.KeyBoard.TypeText(newValue);
this.UpdateButton.Click();
Thread.Sleep(1000);
break;
}
}
}
public JsonResult Grid(KendoGridRequest request)
{
var employees = _employeeRepository.GetAll();
var data = new KendoGrid<Employee>(request, employees);
return Json(data);
}
public GridEntity <R_DeptSection> GetSectionPermissionSummary(GridOptions options, string UDepID)
{
return(KendoGrid <R_DeptSection> .GetGridData(options, "sp_Select_Unit_Department_Grid", "get_Section_permission", "Sectionname", 0, UDepID));
}
