public static void insertDomain(Domain domain)
{
SqlTransaction transaction = con.BeginTransaction();
try
{
using (SqlCommand command = con.CreateCommand())
{
command.Connection = con;
command.Transaction = transaction;
command.CommandText = "IF NOT EXISTS (SELECT URL FROM Domain WHERE URL = '" + domain.getURL() + "') " +
"INSERT INTO Domain(Object, URL, Priority, Country) VALUES('"
+ escapeApostrophe(SerializeToXml.SerializeObjectToXml <Domain>(domain)) + "', '"
+ domain.getURL() + "', "
+ domain.getPriority() + ", '"
+ domain.getCountry() + "');";
command.ExecuteNonQuery();
transaction.Commit();
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
if (con != null)
{
transaction.Rollback();
}
}
finally
{
transaction.Dispose();
}
}
public static void alterDomain(Domain domain)
{
SqlTransaction transaction = con.BeginTransaction();
try
{
using (SqlCommand command = con.CreateCommand())
{
command.Connection = con;
command.Transaction = transaction;
command.CommandText = "IF EXISTS (SELECT * FROM Domain WHERE URL = '" + domain.getDomainURL() + "')" +
"UPDATE Domain SET Object = '" + escapeApostrophe(SerializeToXml.SerializeObjectToXml <Domain>(domain)) + "' WHERE URL = '" + domain.getDomainURL() + "';";
command.ExecuteNonQuery();
transaction.Commit();
}
}
catch (SqlException ex)
{
if (con != null)
{
transaction.Rollback();
}
throw ex;
}
finally
{
transaction.Dispose();
}
}