/// <summary> /// Metodo para retornar todos os orçamentos /// </summary> /// <param name="param"></param> /// <returns></returns> public List <Estimate> GetAllEstimates(string param, UserControlSalesOrder window) { try { // Abertura da conexão com o banco conn.Open(); // Definição do comando de consulta string command = $"SELECT o.no_documento, o.descricao, p.nome_pessoa, o.data_orcamento, o.valor_total " + $"FROM {Refs.TABLE_ESTIMATES} o, {Refs.TABLE_CLIENTS} c, {Refs.TABLE_PEOPLE} p " + $"WHERE o.id_cliente = c.id_cliente " + $"AND c.id_pessoa = p.id_pessoa " + $"AND (p.nome_pessoa LIKE @paramSearch " + $"OR o.descricao LIKE @paramSearch " + $"OR o.data_orcamento LIKE @paramSearch);"; // Definição do comando instanciado List <Estimate> results = new List <Estimate>(); MySqlDataReader reader; MySqlCommand cmd = new MySqlCommand(command, conn) { CommandType = CommandType.Text }; // Adicionando parametros a busca cmd.Parameters.Add(new MySqlParameter("@paramSearch", $"%{param}%")); // Preparando comando com os parametros cmd.Prepare(); // Realizando busca no banco reader = cmd.ExecuteReader(); // Verificando resultados while (reader.Read()) { Estimate estimate = new Estimate(); estimate.DocNo = (int)reader["no_documento"]; estimate.NameCustomer = reader["nome_pessoa"].ToString(); estimate.Description = reader["descricao"].ToString(); estimate.Date = reader["data_orcamento"].ToString(); if (window != null) { estimate.TotalValue2 = (double)reader["valor_total"]; } results.Add(estimate); } // Fechamento da conexão conn.Close(); return(results); } catch (MySqlException) { // Fechando conexão com banco de disparando exceção conn.Close(); throw new DatabaseAccessException(); } }
public SearchSaleOrder(UserControlSalesOrder window) { InitializeComponent(); dao = new SaleOrders(); dao2 = new Estimates(); dao3 = new Services(); this.window = window; RefreshGrid(); }
/// <summary> /// Evento ao selecionar alguma opcão do menu priincipal /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ListView_SelectionChanged(object sender, SelectionChangedEventArgs e) { //Limpando a view atual UserControl usc = null; GridMain.Children.Clear(); //Verificando qual tela será carregada switch (((ListViewItem)((ListView)sender).SelectedItem).Name) { case "Main": usc = new UserControlMain(); GridMain.Children.Add(usc); break; case "Client": usc = new UserControlClient(); GridMain.Children.Add(usc); break; case "Employes": usc = new UserControlEmployes(); GridMain.Children.Add(usc); break; case "Services": usc = new UserControlServices(); GridMain.Children.Add(usc); break; case "Supplier": usc = new UserControlSupplier(); GridMain.Children.Add(usc); break; case "BillsToPay": usc = new UserControlBillsToPay(); GridMain.Children.Add(usc); break; case "BillsToReceive": usc = new UserControlBillsToReceive(); GridMain.Children.Add(usc); break; case "Estimate": usc = new UserControlEstimate(); GridMain.Children.Add(usc); break; case "Order": usc = new UserControlSalesOrder(); GridMain.Children.Add(usc); break; case "Sair": System.Environment.Exit(0); break; default: break; } }