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); } }