/// <summary>
/// InsertMember method
/// - InsertMember Member table row from member information
/// </summary>
/// <param name="member">Member information</param>
/// <returns></returns>
public Member InsertMember(Member member)
{
try
{
using (connection)
{
connection.Open();
Member ret = (Member)MsSqlDataHelperFactory.SelectSingleEntity <Member>(connection,
typeof(Member),
CommandType.StoredProcedure,
"Product.dbo.sp_Memberships_Insert_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)
);
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();
return((MemberHistory)MsSqlDataHelperFactory.SelectSingleEntity <MemberHistory>(connection,
typeof(MemberHistory),
CommandType.Text,
@"INSERT INTO Product.dbo.MemberHistory " +
@"( MemberID, MemberName, Successful, Message, InsertedDate ) " +
@"VALUES " +
@"( @MemberID, @MemberName, @Successful, @Message, GETDATE() ) " +
@" " +
@"SELECT Sequence, MemberID, MemberName, Successful, Message, InsertedDate " +
@"FROM Product.dbo.MemberHistory " +
@"WHERE MemberID = @MemberID AND MemberName = @MemberName " +
@" AND Successful = @Successful AND Message = @Message " +
@"ORDER BY InsertedDate DESC ",
MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberHistory.MemberID, SqlDbType.Int, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberName", memberHistory.MemberName, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Successful", memberHistory.IsSuccess, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Message", memberHistory.Message, ParameterDirection.Input)
));
}
}
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)MsSqlDataHelperFactory.SelectSingleEntity <Member>(connection,
typeof(Member),
CommandType.Text,
@"SELECT MemberID, MemberName, IsAvailable, Email, PhoneNumber, Address, InsertedDate, UpdatedDate " +
@"FROM Product.dbo.Member " +
@"WHERE MemberID = @MemberID ",
MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberID, SqlDbType.Int, 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)MsSqlDataHelperFactory.SelectSingleEntity <Member>(connection,
typeof(Member),
CommandType.StoredProcedure,
"Product.dbo.sp_Memberships_Select_Member_By_MemberID",
MsSqlParameterHelperFactory.CreateParameter <SqlDbType>(providerName, "@MemberID", memberID, SqlDbType.Int, 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();
return((MemberHistory)MsSqlDataHelperFactory.SelectSingleEntity <MemberHistory>(connection,
typeof(MemberHistory),
CommandType.StoredProcedure,
"Product.dbo.sp_Memberships_Insert_MemberHistory",
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberID", memberHistory.MemberID, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@MemberName", memberHistory.MemberName, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Successful", memberHistory.IsSuccess, ParameterDirection.Input),
MsSqlParameterHelperFactory.CreateParameter(providerName, "@Message", memberHistory.Message, ParameterDirection.Input)
));
}
}
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)
{
connection.Open();
Member ret = (Member)MsSqlDataHelperFactory.SelectSingleEntity <Member>(connection,
typeof(Member),
CommandType.Text,
@"INSERT INTO Product.dbo.Member " +
@"( MemberName, IsAvailable, Email, PhoneNumber, Address, InsertedDate, UpdatedDate ) " +
@"VALUES " +
@"( @MemberName, @IsAvailable, @Email, @PhoneNumber, @Address, GETDATE(), NULL ) " +
@" " +
@"SELECT MemberID, MemberName, IsAvailable, Email, PhoneNumber, Address, InsertedDate, UpdatedDate " +
@"FROM Product.dbo.Member " +
@"WHERE MemberName = @MemberName AND IsAvailable = @IsAvailable AND Email = @Email " +
@" AND PhoneNumber = @PhoneNumber AND Address = @Address " +
@"ORDER BY InsertedDate DESC ",
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)
);
return(ret);
}
}
catch (Exception ex)
{
throw ex;
}
}