private void listBox1_Click(object sender, EventArgs e) { try { CONTACT contact = new CONTACT(); int groupid = (Int32)listBox1.SelectedValue; SqlCommand command = new SqlCommand("SELECT fname as FirstName, lname as LastName, [mygroups].name as Group, phone, email, address, pic FROM [mycontact] INNER JOIN [mygroups] on [mycontact].group_id = mygroups.id WHERE [mycontact].userid = @userid AND [mycontact].group_id = @groupid"); command.Parameters.AddWithValue("@groupid", groupid); command.Parameters.AddWithValue("@userid", Globals.GlobalUserId); dataGridView1.DataSource = contact.SelectContactList(command); for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (IsOdd(i)) { dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.WhiteSmoke; } } } catch (Exception) { } dataGridView1.ClearSelection(); }
private void button_Add_Contact_Click(object sender, EventArgs e) { string fname = textBoxFName.Text; string lname = textBoxLName.Text; string phone = textBoxPhone.Text; string address = textBoxAddress.Text; string email = textBoxEmail.Text; int userid = Globals.GlobalUserId; try { // get the group id int groupid = (int)comboBoxGroup.SelectedValue; // get the image MemoryStream pic = new MemoryStream(); pictureBoxContactImage.Image.Save(pic, pictureBoxContactImage.Image.RawFormat); CONTACT contact = new CONTACT(); if (contact.insertContact(fname, lname, phone, address, email, userid, groupid, pic)) { MessageBox.Show("New Contact Added", "Add Contact", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Error", "Add Contact", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception) { MessageBox.Show("One Or More Fields Are Empty", "Add Contact", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// button edit contact private void button_Edit_Contact_Click(object sender, EventArgs e) { CONTACT contact = new CONTACT(); string fname = textBoxFName.Text; string lname = textBoxLName.Text; string phone = textBoxPhone.Text; string address = textBoxAddress.Text; string email = textBoxEmail.Text; try { Int32 id = Convert.ToInt32(textBoxContactId.Text); int groupid = (int)comboBoxGroup.SelectedValue; MemoryStream pic = new MemoryStream(); pictureBoxContactImage.Image.Save(pic, pictureBoxContactImage.Image.RawFormat); if (contact.updateContact(id, fname, lname, phone, address, email, groupid, pic)) { MessageBox.Show("Contact Inormation UpDated", "Edit Contact", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Error", "Add Contact", MessageBoxButtons.OK, MessageBoxIcon.Error); } }catch (Exception ex) { MessageBox.Show(ex.Message, "Add Contact", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
// button select the contact you want to edit from the list private void buttonSelectContact_Click(object sender, EventArgs e) { // open the form to select a contact from it Select_Contact_Form SelectContactF = new Select_Contact_Form(); SelectContactF.ShowDialog(); try { // get the contact id int contactId = Convert.ToInt32(SelectContactF.dataGridView1.CurrentRow.Cells[0].Value.ToString()); CONTACT contact = new CONTACT(); DataTable table = contact.GetContactById(contactId); textBoxContactId.Text = table.Rows[0]["id"].ToString(); textBoxFName.Text = table.Rows[0]["fname"].ToString(); textBoxLName.Text = table.Rows[0]["lname"].ToString(); comboBoxGroup.SelectedValue = table.Rows[0]["group_id"]; textBoxPhone.Text = table.Rows[0]["phone"].ToString(); textBoxEmail.Text = table.Rows[0]["email"].ToString(); textBoxAddress.Text = table.Rows[0]["address"].ToString(); byte[] pic = (byte[])table.Rows[0]["pic"]; MemoryStream picture = new MemoryStream(pic); pictureBoxContactImage.Image = Image.FromStream(picture); } catch (Exception) { // if no contact is selected } }
private void Select_Contact_Form_Load(object sender, EventArgs e) { // display image on the panel ( close and minimize ) panel4.BackgroundImage = Image.FromFile("../../images/img4.png"); CONTACT contact = new CONTACT(); SqlCommand command = new SqlCommand("SELECT id, fname as firstname, lname as lastname, group_id as group id FROM [mycontact] WHERE userid = @uid"); command.Parameters.AddWithValue("@uid", Globals.GlobalUserId); dataGridView1.DataSource = contact.SelectContactList(command); }
// button remove selected contact by id private void buttonRemoveContact_Click(object sender, EventArgs e) { CONTACT contact = new CONTACT(); if (!TextBoxContactId.Text.Equals("")) // check if TextBoxContactId is empty { int contactid = Convert.ToInt32(TextBoxContactId.Text); if (contact.deleteContact(contactid)) { MessageBox.Show("Contact Deleted", "Remove Contact", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Remove Contact", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("No Contact Selected", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void Contacts_Full_List_Form_Load(object sender, EventArgs e) { // display image on the panel ( close and minimize ) panel4.BackgroundImage = Image.FromFile("../../images/img4.png"); DataGridViewImageColumn picCol = new DataGridViewImageColumn(); dataGridView1.RowTemplate.Height = 80; CONTACT contact = new CONTACT(); //SqlCommand command = new SqlCommand("SELECT [mycontact].fname as FirstName, [mycontact].lname as LastName, [mygroups].name as Group, phone, email, address, pic FROM [mycontact] INNER JOIN [mygroups] on [mycontact].group_id = [mygroups].id WHERE [mycontact].userid = @userid"); SqlCommand command = new SqlCommand("SELECT [mygroups].name as GroupName,fname as FirstName, lname as LastName, phone, email, address, pic FROM [mycontact] INNER JOIN [mygroups] on [mycontact].group_id = [mygroups].id WHERE [mycontact].userid = @userid"); command.Parameters.AddWithValue("@userid", Globals.GlobalUserId); dataGridView1.DataSource = contact.SelectContactList(command); picCol = (DataGridViewImageColumn)dataGridView1.Columns[6]; picCol.ImageLayout = DataGridViewImageCellLayout.Stretch; for (int i = 0; i < dataGridView1.Rows.Count; i++) { if (IsOdd(i)) { dataGridView1.Rows[i].DefaultCellStyle.BackColor = Color.WhiteSmoke; } } GROUP group = new GROUP(); listBox1.DataSource = group.getGroups(Globals.GlobalUserId); listBox1.DisplayMember = "name"; listBox1.ValueMember = "id"; listBox1.SelectedItem = null; dataGridView1.ClearSelection(); }