/// <summary>
/// UpdateMember method
/// - Update Member table row by member information
/// </summary>
/// <param name="member">Member information</param>
/// <returns></returns>
public bool UpdateMember(Member member)
{
try
{
using (connection)
{
connection.Open();
int ret = MsSqlDataHelperFactory.Execute(connection,
CommandType.StoredProcedure,
"Product.dbo.sp_Memberships_Update_Member",
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberName", member.MemberName, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@IsAvailable", member.IsAvailable, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Email", member.Email, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@PhoneNumber", member.PhoneNumber, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Address", member.Address, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberID", member.MemberID, ParameterDirection.Input)
);
return((ret == 1) ? true : false);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// UpdateMember method
/// - Update Member table row by member information
/// </summary>
/// <param name="member">Member information</param>
/// <returns></returns>
public bool UpdateMember(Member member)
{
try
{
using (connection)
{
connection.Open();
int ret = MsSqlDataHelperFactory.Execute(connection,
CommandType.Text,
@"UPDATE Product.dbo.Member " +
@"SET MemberName = @MemberName, IsAvailable = @IsAvailable, Email = @Email, " +
@" PhoneNumber = @PhoneNumber, Address = @Address " +
@"WHERE MemberID = @MemberID ",
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberName", member.MemberName, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@IsAvailable", member.IsAvailable, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Email", member.Email, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@PhoneNumber", member.PhoneNumber, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Address", member.Address, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberID", member.MemberID, 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 DeleteMember(int memberID)
{
try
{
using (connection)
{
connection.Open();
int ret = MsSqlDataHelperFactory.Execute(connection,
CommandType.StoredProcedure,
"Product.dbo.sp_Memberships_Delete_Member_By_MemberID",
MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberID, SqlDbType.Int, 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 DeleteMember(int memberID)
{
try
{
using (connection)
{
connection.Open();
int ret = MsSqlDataHelperFactory.Execute(connection,
CommandType.Text,
@"DELETE FROM Product.dbo.Member " +
@"WHERE MemberID = @MemberID ",
MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberID, SqlDbType.Int, ParameterDirection.Input)
);
return((ret == 1) ? true : false);
}
}
catch (Exception ex)
{
throw ex;
}
}
