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