private BotMessageResults AddResultsGraphDatatable(DataTable dtResumoVendas)
{
BotMessageResults results = new BotMessageResults();
results.AddDataTableToResultSet(dtResumoVendas);
results.ViewConfig.Add(new Entities.Results.GraphView()
{
Columns = new Collection <Column>()
{
new Column()
{
Name = "Mês", Visible = true, Axis = "x"
},
new Column()
{
Name = "Vendas", Visible = true
}
},
Order = 0,
GraphType = GraphType.Bar,
ResultSet = 0,
ShowTitle = true,
Title = "Vendas"
});
return(results);
}
private BotMessageResults AddResultsTable(DataTable dtClientes)
{
BotMessageResults results = new BotMessageResults();
results.AddDataTableToResultSet(dtClientes);
results.ViewConfig.Add(new Entities.Results.TableView()
{
Order = 0,
Columns = new System.Collections.ObjectModel.Collection <Entities.Results.Column>()
{
new Entities.Results.Column()
{
Name = "Cliente",
Visible = true
},
new Entities.Results.Column()
{
Name = "Nome",
Visible = true
},
},
ResultSet = 0,
ShowTitle = true,
Title = "Clientes"
});
return(results);
}
private BotMessageResults AddDebitMessageResults(DataTable dtCustomersWithDebit)
{
BotMessageResults results = new BotMessageResults();
results.AddDataTableToResultSet(dtCustomersWithDebit);
results.ViewConfig.Add(new Entities.Results.TableView()
{
Order = 0,
Columns = new System.Collections.ObjectModel.Collection <Entities.Results.Column>()
{
new Entities.Results.Column()
{
Name = "Cliente",
Visible = true
},
new Entities.Results.Column()
{
Name = "Crédito total",
Visible = true
},
},
ResultSet = 0,
ShowTitle = true,
Title = "Clientes com créditos pendentes."
});
foreach (List <Cell> linha in results.ResultSets.First())
{
// Add action for the first column (entity, ex: "Sofrio")
linha[0].Action = new BotMessageAction()
{
ActionIndex = 0,
ActionType = BotMessageActionType.Drilldown,
ActionParameters = string.Concat("GCP|1|GCP_MOSTRAMANUTENCAO|Manutencao=mnuTabClientes|Entidade=", linha[0].Value),
Text = linha[0].Value
};
linha[1].Action = new BotMessageAction()
{
ActionIndex = 1,
ActionType = BotMessageActionType.Drilldown,
ActionParameters = "GCP|1|GCP_MOSTRAEXPLORACAO|Exploracao=mnuExpCCPendentesGrelha|TipoEntidade=C|Entidade=" + linha[0].Value,
Text = linha[1].Value
};
}
return(results);
}
/// <summary>
/// Adds the results.
/// </summary>
/// <param name="companyMessage">The company message.</param>
/// <param name="resultsDiff">The results difference.</param>
private void AddResults(BotMessage companyMessage, DataTable resultsDiff)
{
var results = new BotMessageResults();
results.AddDataTableToResultSet(resultsDiff);
// for each result we'll add the correspondent action
foreach (List <Cell> line in results.ResultSets[0])
{
// Add action for the first column
line[1].Action = new BotMessageAction()
{
ActionIndex = 0,
ActionType = BotMessageActionType.Drilldown,
ActionParameters = "Parameters.",
Text = line[1].Value
};
}
// Now we need to define how the table is displayed (view config)
this.AddViewConfig(results);
companyMessage.Results = results;
}
/// <summary>
/// Adds the view configuration.
/// </summary>
/// <param name="results">The results.</param>
private void AddViewConfig(BotMessageResults results)
{
results.ViewConfig.Add(
new Entities.Results.TableView()
{
Order = 0,
Columns = new System.Collections.ObjectModel.Collection <Entities.Results.Column>()
{
new Entities.Results.Column()
{
Name = string.Empty,
Visible = false
},
new Entities.Results.Column()
{
Name = Entities.Helpers.Functions.GetAllAvailableCulturesForResource(Properties.Resources.ResourceManager, "ResourceName", null),
Visible = true
},
},
ResultSet = 0,
ShowTitle = true,
Title = Entities.Helpers.Functions.GetAllAvailableCulturesForResource(Properties.Resources.ResourceManager, "ResourceName", null)
});
}
private BotMessageResults AddResultsGraph()
{
BotMessageResults results = new BotMessageResults();
Collection <Line> linesList = new Collection <Line>()
{
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Janeiro"
},
new Cell()
{
Action = null, Value = "32"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Fevereiro"
},
new Cell()
{
Action = null, Value = "45"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Março"
},
new Cell()
{
Action = null, Value = "54"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Abril"
},
new Cell()
{
Action = null, Value = "110"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Maio"
},
new Cell()
{
Action = null, Value = "150"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Junho"
},
new Cell()
{
Action = null, Value = "120"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Julho"
},
new Cell()
{
Action = null, Value = "80"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Agosto"
},
new Cell()
{
Action = null, Value = "10"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Setembro"
},
new Cell()
{
Action = null, Value = "5"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Outubro"
},
new Cell()
{
Action = null, Value = "15"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Novembro"
},
new Cell()
{
Action = null, Value = "25"
},
}
},
new Line()
{
Cells = new Collection <Cell>()
{
new Cell()
{
Action = null, Value = "Dezembro"
},
new Cell()
{
Action = null, Value = "70"
},
}
}
};
results.AddLinesListToResultSet(linesList);
results.ViewConfig.Add(new Entities.Results.GraphView()
{
Columns = new Collection <Column>()
{
new Column()
{
Name = "Mês", Visible = true, Axis = "x"
},
new Column()
{
Name = "Vendas", Visible = true
}
},
Order = 0,
GraphType = GraphType.Bar,
ResultSet = 0,
ShowTitle = true,
Title = "Vendas"
});
return(results);
}
