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