public void alterarConta(Conta c) { //MessageBox.Show("AlterarConta"); Console.WriteLine("AlterarConta"); DataContext dc = getDataContext(); Table<Conta> tc = dc.GetTable<Conta>(); tc.Attach(c, true); try { dc.SubmitChanges(ConflictMode.ContinueOnConflict); //MessageBox.Show("Conta alterada"); Console.WriteLine("Conta alterada"); } catch (ChangeConflictException e) { //MessageBox.Show("Erro ao alterar a conta"); Console.WriteLine("Erro ao alterar a conta: ChangeConflictException"); Console.WriteLine("inserirConta"); this.inserirConta(c); Console.WriteLine("Conta inserida"); //Console.WriteLine("ChangeConflictException.Message: {0}", e.Message); //throw; } catch (Exception e) { Console.WriteLine("Erro ao alterar a conta: Exception"); Console.WriteLine("Exception.Message: {0}", e.Message); Console.WriteLine("Exception.StackTrace: {0}", e.StackTrace); //throw; } }
public void inserirConta(Conta c) { DataContext dc = getDataContext(); Table<Conta> tc = dc.GetTable<Conta>(); tc.InsertOnSubmit(c); dc.SubmitChanges(); }
public void inserirConta(Conta c) { DataContext dc = new DataContext(@"Data Source=wv-toshiba\instancia1;Initial Catalog=ASI;User ID=sa;Password=123"); Table<Conta> tc = dc.GetTable<Conta>(); tc.InsertOnSubmit(c); dc.SubmitChanges(); }
public void alterarConta(Conta c) { MessageBox.Show("AlterarConta"); Console.WriteLine("AlterarConta"); DataContext dc = new DataContext(@"Data Source=wv-toshiba\instancia1;Initial Catalog=ASI;User ID=sa;Password=123"); Table<Conta> tc = dc.GetTable<Conta>(); tc.Attach(c, true); try { dc.SubmitChanges(ConflictMode.ContinueOnConflict); MessageBox.Show("Conta alterada"); } catch (ChangeConflictException e) { MessageBox.Show("Erro ao alterar a conta"); throw; } }