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