/// <summary> /// InsertMemberHistory method /// - Insert MemberHistory table row from member history information /// </summary> /// <param name="member">Member history information</param> /// <returns></returns> public bool InsertMemberHistory(MemberHistory memberHistory) { try { using (connection) { connection.Open(); int ret = (int)OracleDataHelperFactory.Execute(connection, CommandType.Text, @"INSERT INTO Product.MemberHistory " + @"( Seq, MemberID, MemberName, IsSuccess, Message, InsertedDate ) " + @"VALUES " + @"( Product.SEQ_MemberHistory.NEXTVAL, :MemberID, :MemberName, :IsSuccess, :Message, SYSDATE ) ", OracleParameterHelperFactory.CreateParameter(providerName, ":MemberID", memberHistory.MemberID, ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter(providerName, ":MemberName", memberHistory.MemberName, ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter(providerName, ":IsSuccess", ((memberHistory.IsSuccess) ? 1 : 0), ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter(providerName, ":Message", memberHistory.Message, ParameterDirection.Input) ); return((ret == 1) ? true : false); } } catch (Exception ex) { throw ex; } }