/// <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;
}
}
