private static void CallBusinessSP() { // Create new member Member newMember = new Member("John Doe", true, "*****@*****.**", "080-00-1234-5678", "anywhere"); Member createdMemberInDB = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).CreateMember(newMember); WriteMember(createdMemberInDB); // Select member Member selectedMemberInDB = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).GetMember(createdMemberInDB.MemberID); WriteMember(selectedMemberInDB); // Create new member Member newMember2 = new Member("Jane Doe", true, "*****@*****.**", "080-00-0234-5378", "anywhere"); Member createdMemberInDB2 = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).CreateMember(newMember2); WriteMember(createdMemberInDB2); // Get member Member selectedMemberInDB2 = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).GetMember(createdMemberInDB2.MemberID); WriteMember(selectedMemberInDB2); // Get members List <Member> currentMembers = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).GetMembers(string.Empty); WriteMembers(currentMembers); // Get numboer of members int numOfCurrentMembers = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).GetNumsOfMembers(string.Empty); WriteCurrentNumberOfMemers(numOfCurrentMembers); // Update Member createdMemberInDB.MemberName = "John and Jane Doe"; createdMemberInDB.Address = "John and Jane's home"; createdMemberInDB.Email = "*****@*****.**"; bool updateResult = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).SetMember(createdMemberInDB); if (updateResult) { Member updatedMember = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).GetMember(createdMemberInDB.MemberID); WriteMember(updatedMember); } // Delete Member bool deleteResult = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).RemoveMember(createdMemberInDB.MemberID); List <Member> afterDeletedMembers = new BizMemberShipSP(ORACLE_PROVIDER_NAME, ORACLE_CONN_STR).GetMembers(string.Empty); WriteMembers(afterDeletedMembers); }
public bool SetMember(Member member) { bool ret = false; try { ret = new BizMemberShipSP(MY_SQL_PROVIDER_NAME, MY_SQL_CONN_STR).SetMember(member); } catch (Exception ex) { throw ex; } return(ret); }
public int GetNumsOfMembers([FromBody] string memberName) { int ret = -1; try { ret = new BizMemberShipSP(MY_SQL_PROVIDER_NAME, MY_SQL_CONN_STR).GetNumsOfMembers(memberName); } catch (Exception ex) { throw ex; } return(ret); }
public List <Member> GetMembers([FromBody] string memberName) { List <Member> ret = null; try { ret = new BizMemberShipSP(MY_SQL_PROVIDER_NAME, MY_SQL_CONN_STR).GetMembers(memberName); } catch (Exception ex) { throw ex; } return(ret); }
public Member GetMember(int memberID) { Member ret = null; try { ret = new BizMemberShipSP(MY_SQL_PROVIDER_NAME, MY_SQL_CONN_STR).GetMember(memberID); } catch (Exception ex) { throw ex; } return(ret); }
public Member CreateMember(Member member) { Member ret = null; try { ret = new BizMemberShipSP(MY_SQL_PROVIDER_NAME, MY_SQL_CONN_STR).CreateMember(member); } catch (Exception ex) { throw ex; } return(ret); }
public bool RemoveMember([FromBody] int memberID) { bool ret = false; try { ret = new BizMemberShipSP(MY_SQL_PROVIDER_NAME, MY_SQL_CONN_STR).RemoveMember(memberID); } catch (Exception ex) { throw ex; } return(ret); }