private void LoadPaymentStatus ()
{
if (paymentStatus == null)
{
paymentStatus = SwarmDb.GetDatabaseForReading().GetMembershipPaymentStatus(this.Identity);
}
}
public Dictionary<int, BasicMembershipPaymentStatus> GetMembershipPaymentStatuses (int[] membershipIds)
{
Dictionary<int, BasicMembershipPaymentStatus> retVal = new Dictionary<int, BasicMembershipPaymentStatus>();
if (membershipIds.Length == 0)
return retVal;
using (DbConnection connection = GetMySqlDbConnection())
{
connection.Open();
DbCommand command =
GetDbCommand("SELECT " + membershipPaymentStatusFieldSequence + " WHERE MembershipPayments.MembershipId IN (" + JoinIds(membershipIds) + ") ORDER BY StatusDateTime ASC ", connection);
using (DbDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
BasicMembershipPaymentStatus bms = ReadMembershipPaymentStatusFromDataReader(reader);
retVal[bms.MembershipId] = ReadMembershipPaymentStatusFromDataReader(reader);
}
foreach (int i in membershipIds)
{
if (!retVal.ContainsKey(i))
retVal[i] = new BasicMembershipPaymentStatus(i, MembershipPaymentStatus.Unknown, new DateTime(1900, 1, 1));
}
return retVal;
}
}
}
