public JsonResult ReadAllServidoresSde(int ClienteId)
{
ClienteDAO clienteDAO = new ClienteDAO();
IQueryable <Cliente> clientes = clienteDAO.GetServidoresSde(ClienteId);
DataTableParser <Sde> dtParser = new DataTableParser <Sde>(Request, clientes.SingleOrDefault().ServidoresSde.AsQueryable().Select(
/*Definindo os campos que serao apresentandos, alem de eliminar os atributos circular*/
s => new Sde()
{
ArcgisVersion = s.ArcgisVersion,
ConnDirect = s.ConnDirect,
DataReg = s.DataReg,
EstReg = s.EstReg,
Instance = s.Instance,
Login = s.Login,
Name = s.Name,
Password = s.Password,
SdeId = s.SdeId,
Server = s.Server,
Service = s.Service,
Version = s.Version
}));
return(Json(dtParser.Parse(), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Monta a query primeiro pra depois consulta tudo (o processamento fica inteiro no servidor)
/// </summary>
/// <returns></returns>
public JsonResult ReadAll()
{
ClienteDAO clienteDAO = new ClienteDAO();
IQueryable <Cliente> clientes = clienteDAO.ReadAll();
DataTableParser <Cliente> dtParser = new DataTableParser <Cliente>(Request, clientes);
return(Json(dtParser.Parse(), JsonRequestBehavior.AllowGet));
}
public JsonResult ReadAll()
{
ClientSideJavascriptExceptionDAO dao = new ClientSideJavascriptExceptionDAO();
IQueryable <ClientSideJavaScriptException> errors = dao.ReadAll();
DataTableParser <ClientSideJavaScriptException> dtParser = new DataTableParser <ClientSideJavaScriptException>(Request, errors);
return(Json(dtParser.Parse(), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Processa primeiro depois passa todos os dados para o parser que processa no lado do cliente o outro filtro
/// </summary>
/// <returns></returns>
public JsonResult ListEnumerable()
{
Thread.Sleep(2000);
UsuarioDAO userDAO = new UsuarioDAO();
List <User> allUsers = userDAO.GetAllIEnumerable();
DataTableParser <User> dtParser = new DataTableParser <User>(Request, allUsers.AsQueryable());
return(Json(dtParser.Parse(), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Retorna todos os itens do menu ativos
/// </summary>
/// <returns></returns>
public JsonResult ReadAll()
{
MenuDAO dao = new MenuDAO();
IEnumerable <MenuItem> menuItens = dao.ReadAll().ToList <MenuItem>().Select(x => new MenuItem {
Name = x.Name, Root = x.Root, MenuItemId = x.MenuItemId, ParentId = x.ParentId, Children = null, Icon = x.Icon, Url = x.Url, Leaf = x.Leaf
});
DataTableParser <MenuItem> dtParser = new DataTableParser <MenuItem>(Request, menuItens.AsQueryable());
return(Json(dtParser.Parse(), JsonRequestBehavior.AllowGet));
}
public JsonResult ReadAllArcgisServer(int ClienteId)
{
ClienteDAO clienteDAO = new ClienteDAO();
IQueryable <Cliente> clientes = clienteDAO.GetArcgisServers(ClienteId);
DataTableParser <ArcgisServer> dtParser = new DataTableParser <ArcgisServer>(Request, clientes.SingleOrDefault().ArcgisServers.AsQueryable().Select(
/*Definindo os campos que serao apresentandos, alem de eliminar os atributos circular*/
s => new ArcgisServer()
{
ArcgisVersion = s.ArcgisVersion,
Name = s.Name,
Url = s.Url,
Login = s.Login,
Password = s.Password,
DataReg = s.DataReg,
EstReg = s.EstReg
}));
return(Json(dtParser.Parse(), JsonRequestBehavior.AllowGet));
}