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