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