public ListarCafe() { InitializeComponent(); cafeDao = new CafeDAO(); dgCafe.ItemsSource = cafeDao.listar(); }
public void gerarJson() { CafeDAO cdao = new CafeDAO(); DataContractJsonSerializer ser = new DataContractJsonSerializer(typeof(List <Cafe>)); diretorioExiste(); FileStream fs = new FileStream(@"C:\VizuCafe - Relatorio\cafe.json", FileMode.OpenOrCreate); ser.WriteObject(fs, cdao.listar()); fs.Close(); MessageBox.Show("Arquivo criado com sucesso no diretorio - C:\\VizuCafe - Relatorio\\"); }
private void Button_Click(object sender, RoutedEventArgs e) { CafeDAO cdao = new CafeDAO(); Cafe cafe = new Cafe() { Nome = txtNome.Text, Sabor = txtSabor.Text, Valor = Convert.ToDecimal(txtValor.Text), Descricao = txtDesc.Text }; cdao.inserir(cafe); MessageBox.Show("Cafe inserido com sucesso!"); }
public void gerarCSV() { CafeDAO cdao = new CafeDAO(); Stream saida = File.Open(@"C:\VizuCafe - Relatorio\cafe.csv", FileMode.Create); StreamWriter sw = new StreamWriter(saida); foreach (Cafe cafe in cdao.listar()) { sw.WriteLine(cafe.ToCSV()); } sw.Close(); saida.Close(); MessageBox.Show("Arquivo criado com sucesso no diretorio - C:\\VizuCafe - Relatorio\\"); }
private void BtnDialog_Click(object sender, RoutedEventArgs e) { OpenFileDialog openFileDialog = new OpenFileDialog(); openFileDialog.Filter = "JSON files (*.json) | *.json"; if (openFileDialog.ShowDialog() == true) { Relatorio relatorio = new Relatorio(); CafeDAO cDao = new CafeDAO(); foreach (Cafe cafe in relatorio.lerJson(openFileDialog.FileName)) { cDao.inserir(cafe); } } }