private void LoadMember(int ID)
{
try
{
MembershipTableAdapters.MembersTableAdapter daMember = new MembershipTableAdapters.MembersTableAdapter();
Membership.MembersDataTable dtMember = new Membership.MembersDataTable();
daMember.Fill(dtMember);
Membership.MembersRow row = dtMember.FindByID(ID);
_ID = row.ID;
_LastName = (row.Last_Name == null ? string.Empty : row.Last_Name);
_FirstName = (row.First_Name == null ? string.Empty : row.First_Name);
_Address = (row.Address == null ? string.Empty : row.Address);
_CityProv = (row.City__Prov == null ? string.Empty : row.City__Prov);
_Postal = (row.Postal == null ? string.Empty : row.Postal);
_Phone = (row.Phone == null ? string.Empty : row.Phone);
_Email = (row.Email_Address == null ? string.Empty : row.Email_Address);
_MemberTypeID = row.MemberTypeID;
_JoinedDate = row.Date_Joined;
_BirthDate = row.Birth_Date;
_Walk = (row.Walk == null ? string.Empty : row.Walk);
_Pal = row.Pal;
_PalExpDate = row.Pal_Exp_Date;
_UserName = (row.Website_Usernames == null ? string.Empty : row.Website_Usernames);
_NoBackTrack = row.NoBackTrack;
_NoEmail = row.NoEmailing;
_MasterRecord = row.MasterRecord;
if (_MasterRecord > 0)
{
MasterRecordName = getMasterRecordName(row.MasterRecord);
}
_SectionFlag = row.SectionFlag;
_Card = row.Card;
_paidHistory = getPaidHistory();
_ExtraCards = getExtraCards();
_Active = row.Active;
_Notes = (row.Notes == null ? string.Empty : row.Notes);
_SwipeCard = row.Swipe;
_Cell = (row.Cell == null ? string.Empty : row.Cell);
_Participation = row.Participation;
_pOther = (row.pOther == null ? string.Empty : row.pOther);
BadgeImage = row.Image;
_CardMade = row.CardMade;
_Sponsor = row.Sponsor;
}
catch (Exception ex)
{
ErrorLogger.Log("Error loading member information", ex, true);
}
}
private void PromoteMember()
{
try
{
MembershipTableAdapters.MembersTableAdapter daMember = new MembershipTableAdapters.MembersTableAdapter();
Membership.MembersDataTable dtMember = new Membership.MembersDataTable();
daMember.Fill(dtMember);
Membership.MembersRow row = dtMember.FindByID(this.MasterRecord);
SectionFlag = row.SectionFlag;
MemberTypeID = 5;
MasterRecord = -1;
setDefaultPaid();
}
catch (Exception ex)
{
ErrorLogger.Log("Error trying to promot extra card", ex, true);
}
}
public void Save()
{
try
{
MembershipTableAdapters.MembersTableAdapter daMember = new MembershipTableAdapters.MembersTableAdapter();
Membership.MembersDataTable dtMember = new Membership.MembersDataTable();
Membership.MembersRow row;
daMember.Fill(dtMember);
if (ID > 0)
{
row = dtMember.FindByID(ID);
}
else
{
row = dtMember.NewMembersRow();
}
row.Last_Name = _LastName;
row.First_Name = _FirstName;
row.Address = Address;
row.City__Prov = _CityProv;
row.Postal = _Postal;
row.Phone = _Phone;
row.Email_Address = _Email;
row.MemberTypeID = _MemberTypeID;
row.Date_Joined = _JoinedDate;
row.Birth_Date = _BirthDate;
row.Walk = _Walk;
row.Pal = _Pal;
row.Pal_Exp_Date = _PalExpDate;
row.Website_Usernames = _UserName;
row.NoBackTrack = _NoBackTrack;
row.NoEmailing = _NoEmail;
row.Active = _Active;
row.MasterRecord = _MasterRecord;
row.SectionFlag = byte.Parse(_SectionFlag.ToString());
row.Card = _Card;
row.Notes = _Notes;
row.Swipe = _SwipeCard;
row.Executive = _Executive;
row.Sponsor = _Sponsor;
row.Cell = _Cell;
row.Participation = byte.Parse(_Participation.ToString());
row.pOther = _pOther;
row.Image = BadgeImage;
row.CardMade = _CardMade;
// Old columns
row.ATT_Expiry = new DateTime(1900, 01, 01);
row.Membership_Type = string.Empty;
row.Section = string.Empty;
if (ID > 0)
{
daMember.Update(row);
}
else
{
// Include an event to fill in the Autonumber value.
dtMember.AddMembersRow(row);
daMember.Update(dtMember);
dtMember.AcceptChanges();
ID = row.ID;
}
if (ID > 0 && MasterRecord <= 0)
{
savePaidHistory();
saveExtraCard();
}
}
catch (Exception ex)
{
ErrorLogger.Log("Error saving Member", ex, true);
}
}
