Example #1
0
        public static int insert(membership_card membership_card)
        {
            int result = 0;

            using (var db = new ExtremeAppContext())
            {
                db.membership_card.Add(membership_card);
                result = db.SaveChanges();
            }
            return(result);
        }
Example #2
0
        private void btnAddMember_Click(object sender, EventArgs e)
        {
            if (validateInput())
            {
                String sex;
                if (radioButtonSexMale.Checked)
                {
                    sex = "M";
                }
                else
                {
                    sex = "Ž";
                }

                var member = new member()
                {
                    first_name         = textBoxFirstName.Text,
                    last_name          = textBoxLastName.Text,
                    sex                = sex,
                    birth_date         = dateTimePickerBirthDate.Value.Date,
                    address            = textBoxAddress.Text,
                    phone_number       = textBoxPhoneNumber.Text,
                    email              = textBoxEmail.Text,
                    registration_date  = dateTimePickerRegistrationDate.Value.Date,
                    last_modified      = DateTime.Now,
                    profile_picture    = picturePath,
                    active             = checkBoxActiveMember.Checked,
                    membership_type_id = comboBoxMembershipType.SelectedIndex + 1
                };


                int result          = MemberDAO.insert(member);
                var membership_card = new membership_card()
                {
                    active                 = true,
                    barcode_number         = generateBarcodeNumber(),
                    issuer_user_account_id = mainForm.loggedInUser.user_account_id,
                    member_id              = MemberDAO.getLast(),
                    create_date            = DateTime.Now
                };
                if (result == 1)
                {
                    DialogResult dialogResult
                        = MessageBox.Show("Korisnik je uspješno dodan! Da li želite da ištampate člansku kartu ?",
                                          "Štampanje članske karte", MessageBoxButtons.YesNo);
                    if (dialogResult == DialogResult.Yes)
                    {
                        Bitmap barcodeImage = (Bitmap)generateBarcodeImage(generateBarcodeNumber());
                        barcodeImage.Save(path);
                        new ReportForm(member.first_name, member.last_name, member.member_id.ToString()
                                       , path).Show();
                    }

                    else
                    {
                        MessageBox.Show("Došlo je do greške prilikom dodavanja!");
                    }
                }
                else
                {
                    member.member_id = memberId;
                    result           = MemberDAO.update(member);
                    if (result == 1)
                    {
                        DialogResult dialogResult
                            = MessageBox.Show("Korisnik je uspješno izmjenjen! " +
                                              "Da li želite da ištampate člansku kartu ?",
                                              "Štampanje članske karte", MessageBoxButtons.YesNo);
                        if (dialogResult == DialogResult.Yes)
                        {
                            Bitmap barcodeImage = (Bitmap)generateBarcodeImage(MemberDAO.getBarcodeNumber(memberId));
                            barcodeImage.Save(path);
                            new ReportForm(member.first_name, member.last_name, member.member_id.ToString()
                                           , path).Show();
                        }
                    }
                    else
                    {
                        MessageBox.Show("Došlo je do greške prilikom izmjene!");
                    }
                }
                mainForm.populateTable(false);
                mainForm.displayMemberInfo(member);
                this.Close();
            }
        }