/// <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; } }
/// <summary> /// SelectMember method /// - Select Member table row by memberID /// </summary> /// <param name="memberID">Member ID</param> /// <returns></returns> public Member SelectMember(int memberID) { try { using (connection) { connection.Open(); Member ret = (Member)OracleDataHelperFactory.SelectSingleEntity <Member>(connection, typeof(Member), CommandType.Text, @"SELECT MemberID, MemberName, IsAvailable, Email, PhoneNumber, Address, InsertedDate, UpdatedDate " + @"FROM Product.Member " + @"WHERE MemberID = :MemberID ", OracleParameterHelperFactory.CreateParameter(providerName, ":MemberID", memberID, ParameterDirection.Input) ); return(ret); } } catch (Exception ex) { throw ex; } }
/// <summary> /// InsertMemberHistory method /// - Insert MemberHistory table row from member history information /// </summary> /// <param name="member">Member history information</param> /// <returns></returns> public MemberHistory InsertMemberHistory(MemberHistory memberHistory) { try { using (connection) { connection.Open(); MemberHistory ret = (MemberHistory)OracleDataHelperFactory.SelectSingleEntity <MemberHistory>(connection, typeof(MemberHistory), CommandType.StoredProcedure, "Product.sp_Insert_MemberHistory", OracleParameterHelperFactory.CreateParameter(providerName, ":MemID", memberHistory.MemberID, ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter(providerName, ":MemName", memberHistory.MemberName, ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter(providerName, ":MemIsSuccess", ((memberHistory.IsSuccess) ? 1 : 0), ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter(providerName, ":MemMessage", memberHistory.Message, ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter <OracleDbType>(providerName, ":OutputData", null, OracleDbType.RefCursor, ParameterDirection.Output) ); return(ret); } } catch (Exception ex) { throw ex; } }
public MemberHistory SelectMemberHistory(int seq) { try { using (connection) { connection.Open(); MemberHistory ret = (MemberHistory)OracleDataHelperFactory.SelectSingleEntity <MemberHistory>(connection, typeof(MemberHistory), CommandType.Text, @"SELECT Seq, MemberID, MemberName, IsSuccess, Message, InsertedDate " + @"FROM Product.MemberHistory " + @"WHERE Seq = :Seq ", OracleParameterHelperFactory.CreateParameter(providerName, ":Seq", seq, ParameterDirection.Input) ); return(ret); } } catch (Exception ex) { throw ex; } }
/// <summary> /// SelectMember method /// - Select Member table row by memberID /// </summary> /// <param name="memberID">Member ID</param> /// <returns></returns> public Member SelectMember(int memberID) { try { using (connection) { connection.Open(); Member ret = (Member)OracleDataHelperFactory.SelectSingleEntity <Member>(connection, typeof(Member), CommandType.StoredProcedure, "Product.sp_Select_Member_By_MemID", OracleParameterHelperFactory.CreateParameter(providerName, ":MemID", memberID, ParameterDirection.Input), OracleParameterHelperFactory.CreateParameter <OracleDbType>(providerName, ":OutputData", null, OracleDbType.RefCursor, ParameterDirection.Output) ); return(ret); } } catch (Exception ex) { throw ex; } }