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