public virtual void CreateIPProxy(IPProxy iPProxy) { try { Database database = DatabaseFactory.CreateDatabase("DatabaseProxy"); DbCommand dbCommand = database.GetStoredProcCommand("PR_IPProxy_Insert"); database.AddInParameter(dbCommand, "@IPAddress", DbType.AnsiString, iPProxy.IPAddress); database.AddInParameter(dbCommand, "@IPPort", DbType.Int32, iPProxy.IPPort); database.AddInParameter(dbCommand, "@StatusIP", DbType.Boolean, iPProxy.StatusIP); database.AddInParameter(dbCommand, "@CreateDate", DbType.Int32, iPProxy.CreateDate); database.AddOutParameter(dbCommand, "@Id", DbType.Int32, iPProxy.Id); database.ExecuteNonQuery(dbCommand); iPProxy.Id = (int)database.GetParameterValue(dbCommand, "@Id"); } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(); } }