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)); }
public DemoParser(Stream input) { reader = new BinaryReader(input); DemoPacketsParser = new DemoPacketParser(); DataTablesParser = new DataTableParser(); StringTablesParser = new StringTableParser(); EventsManager = new EventsManager(); }
/// <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 static void WriteDataTableDump(StreamWriter sw, SourceDemo demo, DataTableDumpMode mode) { PrettyStreamWriter pw = new PrettyStreamWriter(sw.BaseStream); int datatablesCount = 0; // spliced demos have more than one datatables packet foreach (DataTables dataTables in demo.FilterForPacket <DataTables>()) { if (datatablesCount++ > 0) { pw.Append("\n\n\n"); } if (mode != DataTableDumpMode.TreeOnly) { switch (mode) { case DataTableDumpMode.PacketAndTree: dataTables.PrettyWrite(pw); break; case DataTableDumpMode.Flattened: var tableParser = new DataTableParser(demo, dataTables); tableParser.FlattenClasses(false); foreach ((ServerClass sClass, List <FlattenedProp> fProps) in tableParser.FlattenedProps !) { pw.AppendLine($"{sClass.ClassName} ({sClass.DataTableName}) ({fProps.Count} props):"); for (var i = 0; i < fProps.Count; i++) { FlattenedProp fProp = fProps[i]; pw.Append($"\t({i}): "); pw.Append(fProp.TypeString().PadRight(12)); pw.AppendLine(fProp.ArrayElementPropInfo == null ? fProp.PropInfo.ToStringNoType() : fProp.ArrayElementPropInfo.ToStringNoType()); } } break; default: throw new ArgProcessProgrammerException($"invalid data table dump mode: \"{mode}\""); } } if (mode != DataTableDumpMode.TreeOnly) { pw.Append("\n\n\n"); } pw.Append("Datatable hierarchy:\n\n\n"); new DataTableTree(dataTables, true).PrettyWrite(pw); } // see note at PrettyStreamWriter pw.Flush(); }
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)); }
public System.Collections.Generic.IEnumerable<Dictionary<string, object>> GetVirtualDataTable(params String[] tableNames) { IDataTableParser parser = new DataTableParser(); List<List<String>> columns = new List<List<String>>(); List<String> headers = new List<String>(); bool isMultipleDataTable = false; int colCount = 0; int rowCount = 0; int currentTableColCount = 0; for (int index = 0; index < tableNames.Length; index++) { Table table = parser.getDataTable(tableNames[index]); if (table.rows.Count > rowCount) { rowCount += table.rows.Count; } colCount = currentTableColCount; currentTableColCount += table.getColumnCount(); foreach (Column column in table.header[0].columns) { headers.Add(table.tableName + "_" + column.name); List<string> col = new List<string>(); columns.Add(col); if (index > 0) { isMultipleDataTable = true; } } foreach (Row row in table.rows) { for (int i = 0; i < row.value.Count; i++) { if (!isMultipleDataTable) { columns[i].Add(row.value[i]); } else { columns[(i + colCount)].Add(row.value[i]); } } } } for (int i = 0; i < rowCount; i++) { Dictionary<string, object> objd = new Dictionary<string, object>(); object[] obj = new object[columns.Count]; for (int j = 0; j < columns.Count; j++) { try { objd.Add(headers[j], columns[j][i]); obj[j] = columns[j][i]; } catch (Exception) { obj[j] = null; } } yield return objd; } }