示例#1
0
        private void button4_Click_1(object sender, EventArgs e)
        {
            Member objMember = new Member();

            objMember.number        = numtb.Text.Trim();
            objMember.joindate      = jdtb.Text.Trim();
            objMember.firstname     = firsttb.Text.Trim();
            objMember.lastname      = lasttb.Text.Trim();
            objMember.Address       = addtb.Text.Trim();
            objMember.City          = citytb.Text.Trim();
            objMember.State         = statetb.Text.Trim();
            objMember.Zipcode       = ziptb.Text.Trim();
            objMember.phone         = phonetb.Text.Trim();
            objMember.member_status = membtb.Text.Trim();
            objMember.password      = passtb.Text.Trim();

            try
            {
                bool status = MemberDB.DeleteMember(objMember);
                if (status) //You can use this syntax as well..if (status ==true)
                {
                    MessageBox.Show("Member deleted from database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
                else
                {
                    MessageBox.Show("Member was not found in database to delete.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
示例#2
0
        private void button2_Click(object sender, EventArgs e)
        {
            if (numtb.Text.Trim() == String.Empty)
            {
                MessageBox.Show("Please enter a Member Number to find.");
                numtb.Focus();
                return;
            }

            Member objMember = MemberDB.GetMember(Convert.ToInt32(numtb.Text.Trim()));

            //Step 2: Validate to make sure the Customer object is not null.
            if (objMember != null)
            {
                //Populate the UI with the object values
                jdtb.Text    = objMember.joindate;
                firsttb.Text = objMember.firstname;
                lasttb.Text  = objMember.lastname;
                addtb.Text   = objMember.Address;
                citytb.Text  = objMember.City;
                statetb.Text = objMember.State;
                ziptb.Text   = objMember.Zipcode;
                phonetb.Text = objMember.phone;
                membtb.Text  = objMember.member_status;
                passtb.Text  = objMember.password;
                //make Customer ID field read-only to be used for updating and deleting records demo
                numtb.ReadOnly = true;
            }
            else
            {
                MessageBox.Show("Member Number " + numtb.Text.Trim() + " not found in database.", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
示例#3
0
 private void button6_Click_1(object sender, EventArgs e)
 {
     try
     {
         List <Member> memberList = new List <Member>();
         memberList = MemberDB.GetMembers();
         MessageBox.Show("You have " + memberList.Count.ToString() + " members");
         dataGridView1.DataSource = memberList;
     }
     catch (Exception ex)
     {
         MessageBox.Show(ex.Message);
     }
 }