예제 #1
0
        public ViewContact(string title, clsContact contact)
        {
            InitializeComponent();

            //Set caption to the person's name
            Text = title;

            buildForm(contact);
        }
예제 #2
0
        public UpdateContact(string title, string mode, clsContact contact)
        {
            InitializeComponent();

            Text = title;

            mFormMode = mode;

            clsContact mContact = contact;

            if (mode == "Update")
            {
                //Populate the form with existing data
                populate(contact);
            }
        }
예제 #3
0
        private void populate(clsContact contact)
        {
            //Build values into the form here.
            txtContactFirstName.Text = contact.ContactFirstName;
            txtContactMiddleName.Text = contact.ContactMiddleName;
            txtContactLastName.Text = contact.ContactLastName;
            txtContactJobTitle.Text = contact.ContactJobTitle;
            txtContactCompany.Text = contact.ContactCompany;

            //Email addresses
            txtContactEmail1.Text = contact.ContactEmail1;
            txtContactEmail2.Text = contact.ContactEmail2;
            txtContactEmail3.Text = contact.ContactEmail3;

            //Addresses
            txtContactAddressHome.Text = contact.ContactAddressHome;
            txtContactAddressWork.Text = contact.ContactAddressWork;
            txtContactAddressVacation.Text = contact.ContactAddressVacation;
            txtContactAddressOther.Text = contact.ContactAddressOther;

            //Phone Numbers
            txtContactPhoneWork.Text = contact.ContactPhoneBusiness;
            txtContactPhoneHome.Text = contact.ContactPhoneHome;
            txtContactPhoneCell.Text = contact.ContactPhoneCell;
            txtContactPhoneFax.Text = contact.ContactPhoneFax;
            txtContactPhoneOther.Text = contact.ContactPhoneOther;

            //Notes
            txtContactNotes.Text = contact.ContactNotes;

            //Dept, Office, Prof.
            txtContactDepartment.Text = contact.ContactDepartment;
            txtContactOffice.Text = contact.ContactOffice;
            txtContactProfession.Text = contact.ContactProfession;

            //Nickname, Title, Suffix
            txtContactNickname.Text = contact.ContactNickname;
            txtContactTitle.Text = contact.ContactTitle;
            txtContactSuffix.Text = contact.ContactSuffix;

            //Manager, Assistant, Spouse names
            txtContactManagerName.Text = contact.ContactManagersName;
            txtContactAssistantName.Text = contact.ContactAssistantsName;
            txtContactSpouseName.Text = contact.ContactSpousesName;

            //Birthday and Anniversary
            if (contact.ContactBirthday.Year < 1000)
            {
                txtContactBirthday.Text = "";
            }
            else
            {
                txtContactBirthday.Text = contact.ContactBirthday.ToShortDateString();
            }

            if (contact.ContactAnniversary.Year < 1000)
            {
                txtContactAnniversary.Text = "";
            }
            else
            {
                txtContactAnniversary.Text = contact.ContactAnniversary.ToShortDateString();
            }

            //Set Hidden ID Field to Contact ID
            lblHiddenID.Text = contact.ContactID.ToString();
        }
예제 #4
0
        private void buildForm(clsContact contact)
        {
            //Build values into the form here.
            lblContactName.Text = contact.ContactFirstName + " " + contact.ContactMiddleName + " " + contact.ContactLastName;
            lblContactJobTitle.Text = contact.ContactJobTitle;
            lblContactCompany.Text = contact.ContactCompany;

                //Email addresses
            lblContactEmail1.Text = contact.ContactEmail1;
            mContactEmail1 = contact.ContactEmail1;
            lblContactEmail2.Text = contact.ContactEmail2;
            mContactEmail2 = contact.ContactEmail2;
            lblContactEmail3.Text = contact.ContactEmail3;
            mContactEmail3 = contact.ContactEmail3;

                //Addresses
            lblContactAddressHome.Text = contact.ContactAddressHome;
            lblContactAddressWork.Text = contact.ContactAddressWork;
            lblContactAddressVacation.Text = contact.ContactAddressVacation;
            lblContactAddressOther.Text = contact.ContactAddressOther;

                //Phone Numbers
            lblContactPhoneBusiness.Text = contact.ContactPhoneBusiness;
            lblContactPhoneHome.Text = contact.ContactPhoneHome;
            lblContactPhoneCell.Text = contact.ContactPhoneCell;
            lblContactPhoneFax.Text = contact.ContactPhoneFax;
            lblContactPhoneOther.Text = contact.ContactPhoneOther;

                //Notes
            txtContactNotes.Text = contact.ContactNotes;

                //Dept, Office, Prof.
            lblContactDepartment.Text = contact.ContactDepartment;
            lblContactOffice.Text = contact.ContactOffice;
            lblContactProfession.Text = contact.ContactProfession;

                //Nickname, Title, Suffix
            lblContactNickname.Text = contact.ContactNickname;
            lblContactTitle.Text = contact.ContactTitle;
            lblContactSuffix.Text = contact.ContactSuffix;

                //Manager, Assistant, Spouse names
            lblContactManagerName.Text = contact.ContactManagersName;
            lblContactAssistantName.Text = contact.ContactAssistantsName;
            lblContactSpouseName.Text = contact.ContactSpousesName;

                //Birthday, Anniversary
            if (contact.ContactBirthday.Year < 1000)
            {
                lblContactBirthday.Text = "";
            }
            else
            {
                lblContactBirthday.Text = contact.ContactBirthday.ToShortDateString();
            }

            if (contact.ContactAnniversary.Year < 1000)
            {
                lblContactAnniversary.Text = "";
            }
            else
            {
                lblContactAnniversary.Text = contact.ContactAnniversary.ToShortDateString();
            }

                //Added, Modified
            lblDateAdded.Text = contact.ContactDateAdded.ToShortDateString();
            lblDateModified.Text = contact.ContactModified.ToString();
        }
예제 #5
0
        private void readUsers()
        {
            OleDbConnection db = null;
            OleDbDataReader dataReader = null;

            try
            {
                // Open a connection to the DBMS.
                db = new OleDbConnection();
                db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + mFileName;
                db.Open();

                string sql = "SELECT * FROM Contacts ORDER BY ContactLastName ASC";

                OleDbCommand command = new OleDbCommand(sql, db);
                dataReader = command.ExecuteReader();

                // Format each message returned from the query.
                mContacts = new ArrayList();
                while (dataReader.Read() == true)
                {
                    //Build a class object and add it to the array
                    //Make a new clsPost object each time.
                    clsContact contact = new clsContact();
                    contact.createObject(dataReader); //Pass the reader to create the object.

                    mContacts.Add(contact); //Add the object to the ArrayList
                }
            }
            catch (Exception ex)
            {
                showErrorMessage(ex.Message);
                Close(); //Close if you get an error here, because there is a database issue.
            }
            finally
            {
                if (dataReader != null)
                {
                    dataReader.Close();
                }

                if (db != null)
                {
                    db.Close();
                }
            }
        }
예제 #6
0
        private void deleteContact(clsContact contact)
        {
            OleDbConnection db = null;

            try
            {
                db = new OleDbConnection();
                db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + mFileName;
                db.Open();

                string sql = "DELETE FROM Contacts WHERE ContactID=" + contact.ContactID;

                OleDbCommand command = new OleDbCommand(sql, db);
                command.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                showErrorMessage(ex.Message);
            }
            finally
            {
                if (db != null)
                {
                    db.Close();
                }
            }
        }
예제 #7
0
        private void addContact()
        {
            clsContact contact = new clsContact();

            UpdateContact updateContact = new UpdateContact("Add a new User", "Add", contact);

            updateContact.ShowDialog();

            //Rebuild table after adding or updating a user.
            readUsers();
            showUsers();
        }