public bool SaveMember()
{
DataLayer.Members members = new DataLayer.Members();
DataLayer.Member member = new DataLayer.Member()
{
MemberID = view.SelectedMember,
CardNumber = view.CardNumber,
LName = view.LastName,
FName = view.FirstName,
Sex = view.Female_IsSelected ? "female" : "male",
DateOfBirth = view.DateOfBirth,
Street = view.Street,
Suburb = view.Suburb,
City = view.City,
PostalCode = view.PostalCode,
HomePhone = view.HomePhone,
CellPhone = view.CellPhone,
Email = view.Email,
Occupation = view.Occupation,
Notes = view.Notes,
PersonalTrainer = view.PersonalTrainer
};
if (view.MemberImageLocation != null)
{
FileStream fstream = new FileStream(view.MemberImageLocation, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fstream);
member.Image = br.ReadBytes((int)fstream.Length);
}
else
{
byte[] empty_array = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 };
member.Image = empty_array;
}
if (DataLayer.Members.UpdateMember(member) > 0)
{
MessageBox.Show("Member Updated successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed to Update Member!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
RefreshAllMembersDataGrid();
return(true);
}
// loads data for the specified member
public void LoadMember(int id)
{
DataLayer.Members members = new DataLayer.Members();
DataLayer.Member member = new DataLayer.Member();
try
{
// retrieves member data from db
member = members.GetMember(id);
// populate controls with the data
txtCardNumber.Text = member.CardNumber.ToString();
txtCardNumber2.Text = member.CardNumber.ToString();
txtLastName.Text = member.LName;
txtFirstName.Text = member.FName;
if (member.Sex == "male")
{
rbMale.Checked = true;
}
else if (member.Sex == "female")
{
rbFemale.Checked = true;
}
txtDateOfBirth.Value = member.DateOfBirth;
txtStreet.Text = member.Street;
txtSuburb.Text = member.Suburb;
txtCity.Text = member.City;
txtPostalCode.Text = member.PostalCode.ToString();
txtHomePhone.Text = member.HomePhone;
txtCellPhone.Text = member.CellPhone;
txtEmail.Text = member.Email;
txtOccupation.Text = member.Occupation;
txtNotes.Text = member.Notes;
//cbPersonalTrainer.Text = member.PersonalTrainer;
cbPersonalTrainer.SelectedValue = member.PersonalTrainer;
lblName.Text = member.FName + " " + member.LName;
txtMemberId.Text = id.ToString();
//display the member's picture
pictureBoxMemberManager.Image = null; // clears the picturebox
byte[] img = member.Image;
if (member.Image != null)
{
try
{
MemoryStream mstream = new MemoryStream(img);
pictureBoxMemberManager.Image = Image.FromStream(mstream);
}
catch { }
}
//load membership data
LoadMembership(id);
//resetTextBoxes();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void btnMembersSave_Click(object sender, EventArgs e)
{
// create a new member and save its details to the db
DataLayer.Members members = new DataLayer.Members();
DataLayer.Member member = new DataLayer.Member();
if (!String.IsNullOrEmpty(txtLastName.Text))
{
// fill the properties of member object based on textboxes text
member.MemberID = this.member_id;
member.CardNumber = Int32.Parse(txtCardNumber.Text);
member.LName = txtLastName.Text;
member.FName = txtFirstName.Text;
if (rbMale.Checked)
{
member.Sex = "male";
}
else if (rbFemale.Checked)
{
member.Sex = "female";
}
member.DateOfBirth = txtDateOfBirth.Value;
member.Street = txtStreet.Text;
member.Suburb = txtSuburb.Text;
member.City = txtCity.Text;
if (txtPostalCode.Text.Length > 0)
{
member.PostalCode = Int32.Parse(txtPostalCode.Text);
}
else
{
member.PostalCode = 0;
}
member.HomePhone = txtHomePhone.Text;
member.CellPhone = txtCellPhone.Text;
member.Email = txtEmail.Text;
member.Occupation = txtOccupation.Text;
member.Notes = txtNotes.Text;
member.PersonalTrainer = int.Parse( cbPersonalTrainer.SelectedValue.ToString());
// holds the member's picture
//byte[] imageBt = null;
if (pictureBoxMemberManager.ImageLocation != null)
{
FileStream fstream = new FileStream(pictureBoxMemberManager.ImageLocation, FileMode.Open, FileAccess.Read);
BinaryReader br = new BinaryReader(fstream);
member.Image = br.ReadBytes((int)fstream.Length);
}
else
{
byte[] empty_array = new byte[] { 0x20, 0x20, 0x20, 0x20, 0x20, 0x20, 0x20 };
member.Image = empty_array;
}
if (DataLayer.Members.UpdateMember(member) > 0)
{
MessageBox.Show("Member Updated successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Failed to Update Member!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// set textboxes to readonly
DoNotAllowMemberEdit();
}
else
{
MessageBox.Show("Last Name cannot be empty!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public void LoadMember()
{
SelectedMember = view.SelectedMember;
DataLayer.Members members = new DataLayer.Members();
//DataLayer.Member member = new DataLayer.Member();
try
{
var member = members.GetMember(SelectedMember); // retrieves member data from db
// populate controls with the data
view.CardNumber = member.CardNumber;
//txtCardNumber2.Text = member.CardNumber.ToString();
view.LastName = member.LName;
view.FirstName = member.FName;
if (member.Sex == "male")
{
view.Male_IsSelected = true;
}
else if (member.Sex == "female")
{
view.Female_IsSelected = true;
}
view.DateOfBirth = member.DateOfBirth;
view.Street = member.Street;
view.Suburb = member.Suburb;
view.City = member.City;
view.PostalCode = member.PostalCode;
view.HomePhone = member.HomePhone;
view.CellPhone = member.CellPhone;
view.Email = member.Email;
view.Occupation = member.Occupation;
view.Notes = member.Notes;
view.PersonalTrainer = member.PersonalTrainer;
view.MemberId = SelectedMember;
//display the member's picture
view.MemberImage = null; // clears the picturebox
byte[] img = member.Image;
if (member.Image != null)
{
try
{
MemoryStream mstream = new MemoryStream(img);
view.MemberImage = Image.FromStream(mstream);
}
catch { }
}
//load membership data
LoadMemberships(SelectedMember);
SetUpNotifications();
//load measurements data
view.MeasurementsGrid.DataSource = DataLayer.Measurement.GetAllMeasurements(SelectedMember);
view.MeasurementsGrid.AutoResizeColumns();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
