/// <summary>
/// InsertMember method
/// - Insert Member table row from member information
/// </summary>
/// <param name="member">Member information</param>
/// <returns></returns>
public bool InsertMember(Member member)
{
try
{
using (connection)
{
if (string.IsNullOrEmpty(OracleParameterHelperFactory.ProviderName))
{
OracleParameterHelperFactory.ProviderName = providerName;
}
connection.Open();
int ret = (int)OracleDataHelperFactory.Execute(connection,
CommandType.Text,
@"INSERT INTO Product.Member " +
@"( MemberID, MemberName, IsAvailable, Email, PhoneNumber, Address, InsertedDate, UpdatedDate ) " +
@"VALUES " +
@"( Product.SEQ_Member.NEXTVAL, :MemberName, :IsAvailable, :Email, :PhoneNumber, :Address, SYSDATE, NULL ) ",
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemberName", member.MemberName, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":IsAvailable", ((member.IsAvailable) ? 1 : 0), ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":Email", member.Email, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":PhoneNumber", member.PhoneNumber, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":Address", member.Address, ParameterDirection.Input)
);
return((ret == 1) ? true : false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// DeleteMember() method
/// - Delete Member table row by memberID
/// </summary>
/// <param name="memberID">Member ID</param>
/// <returns></returns>
public bool RemoveMember(int memberID)
{
try
{
using (connection)
{
if (string.IsNullOrEmpty(OracleParameterHelperFactory.ProviderName))
{
OracleParameterHelperFactory.ProviderName = providerName;
}
connection.Open();
int ret = OracleDataHelperFactory.Execute(connection,
CommandType.Text,
@"DELETE FROM Product.Member " +
@"WHERE MemberID = :MemberID ",
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemberID", memberID, ParameterDirection.Input)
);
return((ret == 1) ? true : false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// InsertMember method
/// - Insert Member table row from member information
/// </summary>
/// <param name="member">Member information</param>
/// <returns></returns>
public Member InsertMember(Member member)
{
try
{
using (connection)
{
if (string.IsNullOrEmpty(OracleParameterHelperFactory.ProviderName))
{
OracleParameterHelperFactory.ProviderName = providerName;
}
connection.Open();
Member ret = (Member)OracleDataHelperFactory.SelectSingleEntity <Member>(connection,
typeof(Member),
CommandType.StoredProcedure,
"Product.sp_Insert_Member",
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemName", member.MemberName, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemIsAvailable", ((member.IsAvailable) ? 1 : 0), ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemEmail", member.Email, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemPhoneNumber", member.PhoneNumber, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName(":MemAddress", member.Address, ParameterDirection.Input),
OracleParameterHelperFactory.CreateParameterWOProviderName <OracleDbType>(":OutputData", null, OracleDbType.RefCursor, ParameterDirection.Output)
);
return(ret);
}
}
catch (Exception ex)
{
throw ex;
}
}
