public MainPage() { InitializeComponent(); using (var _context = new DbContextFiap(App.ConnectionString)) { if (!_context.DatabaseExists()) _context.CreateDatabase(); } this.DataContext = App.ViewContato; this.Loaded += MainPage_Loaded; }
public void Carregar() { IList<Contato> _list = null; using (var _context = new DbContextFiap(App.ConnectionString)) { IQueryable<Contato> _query = _context.Contatos; _list = _query.ToList(); this.Itens.Clear(); foreach (var item in _list) { this.Itens.Add(item); } } }
private void btnRemover_Click(object sender, EventArgs e) { if (MessageBox.Show("Tem certeza que deseja remover o contato?", "Atenção", MessageBoxButton.OKCancel) == MessageBoxResult.OK) { using (var _context = new DbContextFiap(App.ConnectionString)) { Contato _contato = (mainListContato.SelectedItem as Contato); _context.Contatos.Attach(_contato); _context.Contatos.DeleteOnSubmit(_contato); _context.SubmitChanges(); } App.ViewContato.Carregar(); } }
private void btnSalvar_Click(object sender, EventArgs e) { using (var _context = new DbContextFiap(App.ConnectionString)) { Contato _contato = new Contato() { Nome = txtNome.Text, Telefone = txtTelefone.Text, Email = txtEmail.Text }; try { _context.Contatos.InsertOnSubmit(_contato); _context.SubmitChanges(); if (NavigationService.CanGoBack) NavigationService.GoBack(); } catch (Exception error) { MessageBox.Show("Ocorreu um erro inesperado: " + error.Message); } } }