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); } }
private void wizard1_FinishButtonClick(object sender, CancelEventArgs e) { //////////////// CREATE A NEW MEMBER ////////////// // create a new member DataLayer.Member member = new DataLayer.Member(); // fill member properties from textboxes member.CardNumber = Int32.Parse(txtWizardCardNumber.Text); member.LName = txtWizardLastName.Text; member.FName = txtWizardFirstName.Text; if (rbWizardMale.Checked) { member.Sex = "male"; } else if (rbWizardFemale.Checked) { member.Sex = "female"; } member.DateOfBirth = dtpWizardDOB.Value; member.Street = txtWizardStreet.Text; member.Suburb = txtWizardSuburb.Text; member.City = txtWizardCity.Text; if (txtPostalCode.Text.Length > 0) { member.PostalCode = Int32.Parse(txtWizardPostalCode.Text); } member.HomePhone = txtWizardHomePhone.Text; member.CellPhone = txtWizardCellPhone.Text; member.Email = txtWizardEmail.Text; member.Occupation = txtWizardOccupation.Text; member.Notes = txtWizardNotes.Text; // holds the member's picture //byte[] imageBt = null; if (picWizard.ImageLocation != null) { FileStream fstream = new FileStream(picWizard.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; } //add member to db if (DataLayer.Members.AddNewMember(member) > 0) { //a new member has been added without any membership //MessageBox.Show("A New Member has been added. You can add a membership at any time from Member Manager", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Failed to add new member. Please try again", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error); } ////////////// CREATE A NEW MEMBERSHIP FOR THE SAME MEMBER ////////////// if (cbWizardPlans.Text != "None") { // create a new membership and fill with data DataLayer.Membership membership = new DataLayer.Membership(); //to find member's id we get the last inserted id and increment by 1 because we haven't inserted the new member yet membership.MemberId = DataLayer.Members.GetLastInsertedMember(); // member's id //membership.MemberId++; membership.Plan = (int)cbWizardPlans.SelectedValue; // id of the selected plan membership.start = dtpWizardStartPlan.Value; // when the membership starts membership.end = dtpWizardEndPlan.Value; // when the membership expires if (DataLayer.Memberships.NewMembership(membership) > 0) { MessageBox.Show("A New Member has been added successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Failed to add new membership. Please add manually from Member Manager", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error); } } RefreshAllMembersDataGrid(); // refresh AllMembers datagridview panelNewMemberWizard.Visible = false; panelAllMembers.Visible = true; // show all members datagrid view }
public bool AddNewMember() { // Create a new Member var member = new DataLayer.Member() { CardNumber = view.CardNumber, LName = view.LastName, FName = view.FirstName, Sex = view.IsMaleChecked ? "Male" : "Female", 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 }; // Check if Card Number is valid if (DataLayer.Members.CardNumberExists(member.CardNumber)) { MessageBox.Show("This Card Number already exists!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } //Check if Last Name is empty if (String.IsNullOrWhiteSpace(member.LName)) { MessageBox.Show("The Last Name cannot be empty!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } // holds the member's picture //byte[] imageBt = null; if (view.ImageLocation != null) { FileStream fstream = new FileStream(view.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; } // Save Member to db if (DataLayer.Members.AddNewMember(member) == 0) { MessageBox.Show("Failed to add new member. Please try again", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error); ClearTextBoxes(); return(false); } // Create Membership for the same member if (view.SelectedPlanName != "None") { // create a new membership and fill with data var membership = new DataLayer.Membership() { //to find member's id we get the last inserted id and increment by 1 because we haven't inserted the new member yet MemberId = DataLayer.Members.GetLastInsertedMember(), // member's id //membership.MemberId++; Plan = view.PlanId, // id of the selected plan start = view.MembershipStart, // when the membership starts end = view.MembershipEnd // when the membership expires }; // Save Membership to db if (DataLayer.Memberships.NewMembership(membership) > 0) { MessageBox.Show("A New Member has been added successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Failed to add new membership. Please add manually from Member Manager", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("A New Member has been added successfully!", "Gym Manager Pro", MessageBoxButtons.OK, MessageBoxIcon.Information); } view.NewMemberWizard.NavigateCancel(); ClearTextBoxes(); return(true); }