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