public bool Save() { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { OptionCategoryDAO propertyOptionCategoryDAO = new OptionCategoryDAO(); if (this.OptionCategoryId.HasValue) { result = propertyOptionCategoryDAO.Update(this, db, transaction); } else { result = propertyOptionCategoryDAO.Insert(this, db, transaction); } transaction.Commit(); } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return result; }
public bool Save() { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { OptionCategoryDAO propertyOptionCategoryDAO = new OptionCategoryDAO(); if (this.OptionCategoryId.HasValue) { result = propertyOptionCategoryDAO.Update(this, db, transaction); } else { result = propertyOptionCategoryDAO.Insert(this, db, transaction); } transaction.Commit(); } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return(result); }