示例#1
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            using (MembershipDataContext dbContext = new MembershipDataContext())
            {
                if (isModify)
                {
                    Membership memb = dbContext.Memberships.Single(m => m.MemberID == Convert.ToInt32(memberIDTextBox.Text));
                    memb.MemberName  = (memberNameTextBox.Text).ToString();
                    memb.DateStarted = Convert.ToDateTime(dateStartedDateTimePicker.Value);
                    memb.DateEnded   = tmpDate;
                }
                else
                {
                    Membership newMember = new Membership
                    {
                        MemberName  = (memberNameTextBox.Text).ToString(),
                        DateStarted = Convert.ToDateTime(dateStartedDateTimePicker.Value),
                        DateEnded   = tmpDate
                    };
                    dbContext.Memberships.InsertOnSubmit(newMember);
                }
                dbContext.SubmitChanges();

                DialogResult = DialogResult.OK;
            }
        }
示例#2
0
        private void btnModify_Click(object sender, EventArgs e)
        {
            frmAddModify secondFrm = new frmAddModify();

            secondFrm.isModify = true;
            int rowNum  = Convert.ToInt32(membershipDataGridView.CurrentCell.RowIndex);
            int membNum = Convert.ToInt32(membershipDataGridView["dataGridViewTextBoxColumn1", rowNum].Value);

            using (MembershipDataContext dbContext = new MembershipDataContext())
            {
                secondFrm.currentMember = (from m in dbContext.Memberships
                                           where m.MemberID == membNum
                                           select m).Single();
            }

            DialogResult result = secondFrm.ShowDialog();

            using (MembershipDataContext dbContext = new MembershipDataContext())
            {
                if (result == DialogResult.OK)
                {
                    membershipDataGridView.DataSource = dbContext.Memberships;
                }
            }
        }
示例#3
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            int rowNum  = Convert.ToInt32(membershipDataGridView.CurrentCell.RowIndex);
            int membNum = Convert.ToInt32(membershipDataGridView["dataGridViewTextBoxColumn1", rowNum].Value);

            DialogResult answer = MessageBox.Show("Are you sure?", "Confirm", MessageBoxButtons.OKCancel);

            if (answer == DialogResult.OK)
            {
                using (MembershipDataContext dbContext = new MembershipDataContext())
                {
                    try
                    {
                        Membership currentMember = (from m in dbContext.Memberships
                                                    where m.MemberID == membNum
                                                    select m).Single();

                        dbContext.Memberships.DeleteOnSubmit(currentMember);
                        dbContext.SubmitChanges();
                        membershipDataGridView.DataSource = dbContext.Memberships;
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.ToString());
                    }
                }
            }
        }
示例#4
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            frmAddModify secondFrm = new frmAddModify();

            DialogResult result = secondFrm.ShowDialog();

            using (MembershipDataContext dbContext = new MembershipDataContext())
            {
                if (result == DialogResult.OK)
                {
                    membershipDataGridView.DataSource = dbContext.Memberships;
                }
            }
        }
示例#5
0
        private void Form1_Load(object sender, EventArgs e)
        {
            MembershipDataContext dbContext = new MembershipDataContext();

            membershipDataGridView.DataSource = dbContext.Memberships;
        }