public bool Save(House house) { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HouseDAO houseDAO = new HouseDAO(); // House house = new House(); if (houseDAO.IsHouseExist(house)) { result = new HouseOptionDAO().Delete(new HouseOption() { HouseId = house.HouseId.Value }, db, transaction); if (house.HouseOptionList != null) { foreach (HouseOption item in house.HouseOptionList) { new HouseOptionDAO().Insert(item, db, transaction); } } } if (result) { transaction.Commit(); } else { transaction.Rollback(); } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return(result); }
public bool Save(House house) { bool result = false; Database db = DatabaseFactory.CreateDatabase(Constants.CONNECTIONSTRING); DbConnection connection = db.CreateConnection(); connection.Open(); DbTransaction transaction = connection.BeginTransaction(); try { HouseDAO houseDAO = new HouseDAO(); // House house = new House(); if (houseDAO.IsHouseExist(house)) { result = new HouseOptionDAO().Delete(new HouseOption() { HouseId = house.HouseId.Value }, db, transaction); if (house.HouseOptionList != null) { foreach (HouseOption item in house.HouseOptionList) { new HouseOptionDAO().Insert(item, db, transaction); } } } if (result) { transaction.Commit(); } else { transaction.Rollback(); } } catch (System.Exception ex) { transaction.Rollback(); result = false; throw ex; } finally { connection.Close(); } return result; }