public void Generar_Test()
{
CoTest comtest = new CoTest();
BrTest br = new BrTest();
br.Create_DataBase();
br = new BrTest();
comtest = new CoTest();
comtest.id = 2;
comtest.name = "Android";
br.insert_test(comtest);
comtest = new CoTest();
comtest.id = 2;
comtest.name = "Fedora";
br.update_test(comtest);
comtest = new CoTest();
comtest.id = 2;
br.delete_test(comtest);
DataTable dt = br.trae_registro();
}
internal void delete_test(CoTest comtest)
{
DaTest da = new DaTest();
da.delete_test(comtest);
}
internal void update_test(CoTest comtest)
{
DaTest da = new DaTest();
da.update_test(comtest);
}
public void insert_test(CoTest comtest)
{
DaTest da = new DaTest();
da.insert_test(comtest);
}
public void insert_test(CoTest comtest)
{
try
{
sqliteConn = new SQLiteConnection(connectionString);
sqliteConn.Open();
sqliteTransaction = sqliteConn.BeginTransaction();
sqliteCmd = new SQLiteCommand("INSERT INTO usuario(id,name) VALUES(?,?)", sqliteConn);
sqliteCmd.Parameters.Add(new SQLiteParameter("@id")
{
Value = comtest.id
});
sqliteCmd.Parameters.Add(new SQLiteParameter("@name")
{
Value = comtest.name
});
sqliteCmd.Transaction = sqliteTransaction;
sqliteCmd.ExecuteNonQuery();
sqliteTransaction.Commit();
}
catch (SQLiteException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
if (sqliteTransaction != null)
{
try
{
sqliteTransaction.Rollback();
}
catch (SQLiteException ex2)
{
Console.WriteLine("Transaction rollback failed.");
Console.WriteLine("Error: {0}", ex2.ToString());
}
finally
{
sqliteTransaction.Dispose();
}
}
}
finally
{
if (sqliteCmd != null)
{
sqliteCmd.Dispose();
}
if (sqliteTransaction != null)
{
sqliteTransaction.Dispose();
}
if (sqliteConn != null)
{
try
{
sqliteConn.Close();
}
catch (SQLiteException ex)
{
Console.WriteLine("Closing connection failed.");
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
sqliteConn.Dispose();
}
}
}
}
internal void delete_test(CoTest comtest)
{
try
{
sqliteConn = new SQLiteConnection(connectionString);
sqliteConn.Open();
sqliteTransaction = sqliteConn.BeginTransaction();
sqliteCmd = new SQLiteCommand(sqliteConn);
sqliteCmd.CommandText = "delete from usuario where id=@id";
sqliteCmd.Parameters.Add(new SQLiteParameter("@id")
{
Value = comtest.id
});
sqliteCmd.Transaction = sqliteTransaction;
sqliteCmd.ExecuteNonQuery();
sqliteTransaction.Commit();
}
catch (SQLiteException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
if (sqliteTransaction != null)
{
try
{
sqliteTransaction.Rollback();
}
catch (SQLiteException ex2)
{
Console.WriteLine("Transaction rollback failed.");
Console.WriteLine("Error: {0}", ex2.ToString());
}
finally
{
sqliteTransaction.Dispose();
}
}
}
finally
{
if (sqliteCmd != null)
{
sqliteCmd.Dispose();
}
if (sqliteTransaction != null)
{
sqliteTransaction.Dispose();
}
if (sqliteConn != null)
{
try
{
sqliteConn.Close();
}
catch (SQLiteException ex)
{
Console.WriteLine("Closing connection failed.");
Console.WriteLine("Error: {0}", ex.ToString());
}
finally
{
sqliteConn.Dispose();
}
}
}
}
