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