// Busca pelo action e controller
public Aplicativos BuscarActionController(string action = "", string controller = "")
{
try
{
Aplicativos apps = new Aplicativos();
string qry = "";
qry += "SELECT * FROM Aplicativos WHERE txaction = '" + action + "' AND txcontroller = '" + controller + "'";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
IDataReader reader = query.ExecuteQuery();
if (reader.Read())
{
apps.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
apps.txaplicativo.value = Convert.ToString(reader["txaplicativo"]);
apps.txaction.value = Convert.ToString(reader["txaction"]);
apps.txcontroller.value = Convert.ToString(reader["txcontroller"]);
apps.idtabela.value = Convert.ToInt32(reader["idtabela"]);
apps.txmainaction.value = Convert.ToString(reader["txmainaction"]);
apps.txpasta.value = Convert.ToString(reader["txpasta"]);
apps.flscript.value = Convert.ToInt32(reader["flscript"]);
}
reader.Close();
session.Close();
return(apps);
}
catch (Exception error)
{
throw error;
}
}
// Alterar tabela
public void Alterar(Aplicativos rs, Aplicativos temp)
{
try
{
string qry = "";
qry += "UPDATE Aplicativos ";
qry += "SET txaplicativo = '" + rs.txaplicativo.value + "', txaction = '" + rs.txaction.value + "', ";
qry += "txcontroller = '" + rs.txcontroller.value + "', idtabela = " + rs.idtabela.value + ", ";
qry += "txmainaction = '" + rs.txmainaction.value + "', txpasta = '" + rs.txpasta.value + "', flscript = " + rs.flscript.value + " ";
qry += "WHERE idaplicativo = " + rs.idaplicativo.value;
Connection session = new Connection();
Query query = session.CreateQuery(qry);
query.ExecuteUpdate();
// Auditoria
Audit.Check("Aplicativos", "U", rs.idaplicativo.value, rs, temp);
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
// Gravar nova tabela
public int Gravar(Aplicativos rs)
{
try
{
int idaplicativo = 0;
string qry = "";
qry += "INSERT INTO Aplicativos (txaplicativo, txaction, txcontroller, idtabela, txmainaction, txpasta, flscript) output INSERTED.idaplicativo ";
qry += "VALUES ('" + rs.txaplicativo.value + "', '" + rs.txaction.value + "', '" + rs.txcontroller.value + "', ";
qry += rs.idtabela.value + ", '" + rs.txmainaction.value + "', '" + rs.txpasta.value + "', " + rs.flscript.value + ")";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
// Retorna o identificador
idaplicativo = query.ExecuteScalar();
// Atualizar registro para registro de auditoria
rs.idtabela.value = idaplicativo;
session.Close();
// Auditoria
Audit.Check("Aplicativos", "I", idaplicativo, rs);
return(idaplicativo);
}
catch (Exception erro)
{
throw erro;
}
}
public async Task <ActionResult <Aplicativos> > PostAplicativos(Aplicativos aplicativos)
{
_context.Aplicativos.Add(aplicativos);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetAplicativos", new { id = aplicativos.id_aplicativo }, aplicativos));
}
// Busca pelo código
public Aplicativos Buscar(int idaplicativo = 0)
{
try
{
Aplicativos apps = new Aplicativos();
string qry = "";
qry += "SELECT a.*, t.txtabela FROM Aplicativos a LEFT JOIN Tabelas t ON t.idtabela = a.idtabela WHERE a.idaplicativo = " + idaplicativo;
Connection session = new Connection();
Query query = session.CreateQuery(qry);
IDataReader reader = query.ExecuteQuery();
if (reader.Read())
{
apps.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
apps.txaplicativo.value = Convert.ToString(reader["txaplicativo"]);
apps.txaction.value = Convert.ToString(reader["txaction"]);
apps.txcontroller.value = Convert.ToString(reader["txcontroller"]);
apps.idtabela.value = Convert.ToInt32(reader["idtabela"]);
apps.txtabela.value = Convert.ToString(reader["txtabela"]);
apps.txmainaction.value = Convert.ToString(reader["txmainaction"]);
apps.txpasta.value = Convert.ToString(reader["txpasta"]);
apps.flscript.value = Convert.ToInt32(reader["flscript"]);
}
reader.Close();
session.Close();
return(apps);
}
catch (Exception error)
{
throw error;
}
}
public async Task <IActionResult> PutAplicativos(int id, Aplicativos aplicativos)
{
if (id != aplicativos.id_aplicativo)
{
return(BadRequest());
}
_context.Entry(aplicativos).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AplicativosExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void Logar()
{
Usuario UsuarioValido = _controlador.usuarioValido(new Usuario {
user = inputLogin.Text, pass = inputSenha.Password
});
if (UsuarioValido != null)
{
JanelaPrincipal.buttonAplicacoes.Visibility = Visibility.Visible;
Aplicativos inicio = new Aplicativos(UsuarioValido, JanelaPrincipal);
JanelaPrincipal.janelaPrincipal.NavigationService.Navigate(inicio);
JanelaPrincipal.nomeUsuario.Content = UsuarioValido.nickname;
JanelaPrincipal.controladorGeral._usuarioLogado = UsuarioValido;
}
}
// Excluir tabela
public void Excluir(Aplicativos rs)
{
try
{
string qry = "";
qry += "DELETE FROM Aplicativos ";
qry += "WHERE idaplicativo = " + rs.idaplicativo.value;
Connection session = new Connection();
Query query = session.CreateQuery(qry);
query.ExecuteUpdate();
// Auditoria
Audit.Check("Aplicativos", "D", rs.idaplicativo.value, rs);
session.Close();
}
catch (Exception erro)
{
throw erro;
}
}
// Lista Aplicativos
public List <Aplicativos> Listar()
{
try
{
List <Aplicativos> apps = new List <Aplicativos>();
string qry = "";
qry += "SELECT * FROM Aplicativos ORDER BY txaplicativo";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
IDataReader reader = query.ExecuteQuery();
while (reader.Read())
{
Aplicativos temp = new Aplicativos();
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.txaplicativo.value = Convert.ToString(reader["txaplicativo"]);
temp.txaction.value = Convert.ToString(reader["txaction"]);
temp.txcontroller.value = Convert.ToString(reader["txcontroller"]);
temp.idtabela.value = Convert.ToInt32(reader["idtabela"]);
temp.txmainaction.value = Convert.ToString(reader["txmainaction"]);
temp.txpasta.value = Convert.ToString(reader["txpasta"]);
temp.flscript.value = Convert.ToInt32(reader["flscript"]);
apps.Add(temp);
}
reader.Close();
session.Close();
return(apps);
}
catch (Exception error)
{
throw error;
}
}
// Listagem Widget
public (List <Aplicativos>, WidgetsListConfig) ListarWidget(FormCollection form = null)
{
try
{
List <Aplicativos> list = new List <Aplicativos>();
WidgetsListConfig control = new WidgetsListConfig();
string filter = "";
// Parametros de pesquisa
int page = 1;
int registers = 10;
string order = "a.txaplicativo";
string direction = "asc";
// Filtro de resultados
if (form != null)
{
// Aplicativo
if (form.AllKeys.Contains("filter_txaplicativo"))
{
string filter_txaplicativo = Utils.ClearText(form["filter_txaplicativo"], 20);
if (filter_txaplicativo.Length > 0)
{
filter += "AND a.txaplicativo LIKE '%" + filter_txaplicativo.Replace(" ", "%") + "%' ";
}
}
// Action
if (form.AllKeys.Contains("filter_txaction"))
{
string filter_txaction = Utils.ClearText(form["filter_txaction"], 20);
if (filter_txaction.Length > 0)
{
filter += "AND a.txaction LIKE '%" + filter_txaction.Replace(" ", "%") + "%' ";
}
}
// Controller
if (form.AllKeys.Contains("filter_txcontroller"))
{
string filter_txcontroller = Utils.ClearText(form["filter_txcontroller"], 20);
if (filter_txcontroller.Length > 0)
{
filter += "AND a.txcontroller LIKE '%" + filter_txcontroller.Replace(" ", "%") + "%' ";
}
}
// Variáveis de controle
if (form.AllKeys.Contains("widget_temp_page"))
{
page = Convert.ToInt32(form["widget_temp_page"]);
}
if (form.AllKeys.Contains("widget_temp_registers"))
{
registers = Convert.ToInt32(form["widget_temp_registers"]);
}
if (form.AllKeys.Contains("widget_temp_order"))
{
order = form["widget_temp_order"];
}
if (form.AllKeys.Contains("widget_temp_direction"))
{
direction = form["widget_temp_direction"];
}
}
// Controle de widget
control.count = 0;
control.registers = registers;
control.page = page;
control.order = order;
control.direction = direction;
control.columns = new int[9] {
0, 28, 12, 12, 0, 12, 12, 12, 12
};
control.show = new int[9] {
0, 1, 1, 1, 0, 1, 1, 1, 1
};
control.headers = new string[9] {
"199", "230", "231", "232", "143", "144", "272", "280", "281"
};
control.orderfields = new string[9] {
"a.idaplicativo", "a.txaplicativo", "a.txaction", "a.txcontroller", "a.idtabela", "t.txtabela", "a.txmainaction", "a.txpasta", "a.flscript"
};
control.fields = new string[9] {
"idaplicativo", "txaplicativo", "txaction", "txcontroller", "idtabela", "txtabela", "txmainaction", "txpasta", "flscript"
};
control.formatFields = new string[9] {
"master", "", "", "", "", "", "", "", "boolean"
};
// Query
string qry = "";
qry += "SELECT COUNT (*) OVER () AS ROW_COUNT, a.idaplicativo, a.txaplicativo, a.txaction, a.txcontroller, a.idtabela, t.txtabela, a.txmainaction, a.txpasta, a.flscript ";
qry += "FROM Aplicativos a ";
qry += "LEFT JOIN Tabelas t ON t.idtabela = a.idtabela ";
qry += "WHERE 1=1 " + filter;
qry += "ORDER BY " + Utils.Null(order, "a.txaplicativo") + " " + direction + " ";
qry += "OFFSET " + ((page - 1) * registers) + " ROWS FETCH NEXT " + registers + " ROWS ONLY";
Connection session = new Connection();
Query query = session.CreateQuery(qry);
IDataReader reader = query.ExecuteQuery();
while (reader.Read())
{
control.count = Convert.ToInt32(reader["ROW_COUNT"]);
Aplicativos temp = new Aplicativos();
temp.idaplicativo.value = Convert.ToInt32(reader["idaplicativo"]);
temp.txaplicativo.value = Convert.ToString(reader["txaplicativo"]);
temp.txaction.value = Convert.ToString(reader["txaction"]);
temp.txcontroller.value = Convert.ToString(reader["txcontroller"]);
temp.idtabela.value = Convert.ToInt32(reader["idtabela"]);
temp.txtabela.value = Convert.ToString(reader["txtabela"]);
temp.txmainaction.value = Convert.ToString(reader["txmainaction"]);
temp.txpasta.value = Convert.ToString(reader["txpasta"]);
temp.flscript.value = Convert.ToInt32(reader["flscript"]);
list.Add(temp);
}
reader.Close();
session.Close();
return(list, control);
}
catch (Exception error)
{
throw error;
}
}
private void NavegarInicio(object sender, RoutedEventArgs e)
{
Aplicativos inicio = new Aplicativos(controladorGeral._usuarioLogado, this);
this.janelaPrincipal.NavigationService.Navigate(inicio);
}
public static void Main(string[] args)
{
string opcao;
Aluno aluno = new Aluno();
Menu menu = new Menu();
ListaConteudos checklist = new ListaConteudos();
Areas areas = new Areas();
Aplicativos app = new Aplicativos();
Literatura literatura = new Literatura();
Redacao redacao = new Redacao();
Dicas dicas = new Dicas();
Artes artes = new Artes();
aluno.ImprimirBoasVindas();
Console.WriteLine("\nEscolha uma opção: \n1 - Sobre mim \n2 - Acessar conteúdo ");
opcao = Console.ReadLine();
if (opcao == "1")
{
aluno.EfetuarCadastro();
}
if (opcao == "2")
{
Console.WriteLine("\nInforme a opção desejada para continuar: ");
menu.ImprimirMenu();
opcao = Console.ReadLine();
switch (opcao)
{
case "1":
checklist.ImprimirLista();
break;
case "2":
Console.WriteLine("Informe a opção desejada para continuar: ");
areas.ImprimirAreas();
opcao = Console.ReadLine();
if (opcao == "1")
{
areas.ImprimirHumanas();
}
if (opcao == "2")
{
areas.ImprimirMatematica();
}
if (opcao == "3")
{
areas.ImprimirLinguagens();
}
if (opcao == "4")
{
areas.ImprimirCiencias();
}
break;
case "3":
app.ImprimirAplicativos();
break;
case "4":
literatura.ListarLivros();
//voltar e adicionar resumo
break;
case "5":
Console.WriteLine();
//adicionar simulado nan classe simulado
break;
case "6":
redacao.ImprimirRedacao();
break;
case "7":
dicas.ImprimirDicasGerais();
break;
case "8":
atualidades.ImprimirAtualidades();
break;
default:
Console.WriteLine("Comando inválido.");
break;
}
}
}
