/// <summary>
/// Gets instance of Members Attempt object for specific member and type.
/// </summary>
/// <param name="MemberID">Member unique identifier number.</param>
/// <param name="AttemptType">Type of attempt.</param>
/// <returns>List of MemberAttempt objects.</returns>
public static List <MemberAttempt> Get(long MemberID, MemberAttemptTypes AttemptType)
{
SpRoleAdmin sp = new SpRoleAdmin(String.Format(@"SELECT * FROM {0}
WHERE MemberID = @MemberID AND
AttemptType = @AttemptType", Table));
sp.AddParameter("MemberID", MemberID);
sp.AddParameter("AttemptType", AttemptType);
return(GetApplicationCollection(sp));
}
/// <summary>
/// Gets valid instance of Members Attempt object for specific date, member and type.
/// </summary>
/// <param name="MemberID">Member unique identifier number.</param>
/// <param name="Date">Date</param>
/// <param name="AttemptType">Type of attempt.</param>
/// <returns>Insatnce of MemberAttempt objects.</returns>
public static MemberAttempt GetValid(long MemberID, DateTime Date, MemberAttemptTypes AttemptType)
{
SpRoleAdmin sp = new SpRoleAdmin(String.Format(@"SELECT * FROM {0}
WHERE MemberID = @MemberID AND
AttemptType = @AttemptType AND
IsAttemptValid = 1 AND
Year(Created) = Year(@Created) AND Month(Created) = Month(@Created) AND Day(Created) = Day(@Created)", Table));
sp.AddParameter("MemberID", MemberID);
sp.AddParameter("Created", Date);
sp.AddParameter("AttemptType", AttemptType);
return(GetApplicationObject(sp));
}
