public static void EditContact(Contact contact, Contact newContact, User user) { if (user.contacts.Contains(contact)) { user.contacts.Remove(contact); user.contacts.Add(contact); } user.contacts.Sort(); }
public static void SelectFromPhoneNumbers(SqlConnection connection, User user, Contact contact) { string sql1 = "SELECT * FROM PHONENUMBER WHERE Id_contact =" + contact.id; SqlCommand command2 = new SqlCommand(sql1, connection); SqlDataReader dr = command2.ExecuteReader(); while (dr.Read()) { List<PhoneNumber> pn = new List<PhoneNumber>(); pn.Add(new PhoneNumber(dr["Number"].ToString(), dr["Label"].ToString())); user.contacts[Int32.Parse(contact.id) - 1].numbers = pn; } dr.Close(); }
public static void InsertIntoContacts(SqlConnection connection, Contact contact, User user, int index) { string saveContact = "INSERT into CONTACTS (Name,Surname,Patronymic,Id_user) " + " VALUES ('" + contact.name + "', '" + contact.surname + "', '" + contact.patronymic + "', '" + index + "');"; SqlCommand querySaveStaff = new SqlCommand(saveContact, connection); querySaveStaff.ExecuteNonQuery(); foreach (PhoneNumber p in contact.numbers) { string saveNumber = "INSERT into PHONENUMBER (Number,Label,Id_contact) " + " VALUES ('" + p.number + "', '" + p.label + "', '" + (contact.id + user.contacts.Count) + "');"; SqlCommand querySaveNumber = new SqlCommand(saveNumber, connection); querySaveNumber.ExecuteNonQuery(); } }
private void btOK_Click(object sender, EventArgs e) { if (tbName.Text == "" || tbPatronymic.Text == "" || tbSurname.Text == "" || tbPhoneNumber.Text == "") { return; } else { numbers.Add(new PhoneNumber(tbPhoneNumber.Text, lbLabels.SelectedItem.ToString())); Contact contact = new Contact(tbName.Text, tbSurname.Text, tbPatronymic.Text, numbers); UserContactsProcessing.AddContact(contact, list); connection1.Open(); BaseDataAccess.InsertIntoContacts(connection1, contact, list, index); this.DialogResult = DialogResult.OK; connection1.Close(); this.Close(); } }
public static List<Contact> SelectFromContacts(SqlConnection connection, int index) { List<Contact> contacts = new List<Contact>(); string sql = "SELECT * FROM CONTACTS WHERE Id_user ="******"Id"].ToString(), dataReader1["Name"].ToString(), dataReader1["Surname"].ToString(), dataReader1["Patronymic"].ToString()); contacts.Add(contact); } dataReader1.Close(); return contacts; }
public FormForEdit(User list, Contact contact) { list = new User(); this.contact = new Contact(); foreach (Contact us in list.contacts) { UserContactsProcessing.AddContact(us, this.list); } this.contact = contact; this.index = Int32.Parse(contact.id); InitializeComponent(); tbName.Text = contact.name; tbSurname.Text = contact.surname; tbPatronymic.Text = contact.patronymic; foreach (PhoneNumber number in contact.numbers) { lbNumbers.Items.Add(number.ToString()); } }
public static void UpdateContacts(SqlConnection connection, Contact contact, int index) { string sql = string.Format("Update CONTACTS Set Name = '{0}', Surname = '{1}', Patronymic = '{2}' Where Id = '{3}'", contact.name, contact.surname, contact.patronymic, index); using (SqlCommand cmd = new SqlCommand(sql, connection)) { cmd.ExecuteNonQuery(); } }
public static void AddContact(Contact contact, User user) { user.contacts.Add(contact); }
private void btEdit_Click(object sender, EventArgs e) { if (dgUsers.SelectedRows.Count == 0) { return; } StringBuilder sb = new StringBuilder(); sb.Append(dgUsers[0, dgUsers.CurrentRow.Index].Value.ToString() + ' '); sb.Append(dgUsers[1, dgUsers.CurrentRow.Index].Value.ToString()); string[] result = sb.ToString().Split(' '); List<PhoneNumber> pn = new List<PhoneNumber>(); for (int i = 3; i < result.Length-1; i+=2) { pn.Add(new PhoneNumber(result[i], result[i+1])); } Contact contact = new Contact(result[0], result[1], result[2], pn); contact.id = (dgUsers.CurrentRow.Index + 1).ToString(); FormForEdit form = new FormForEdit(user, contact); form.ShowDialog(); if (form.DialogResult == DialogResult.OK) { user = form.list; } for (int i = 0; i < form.list.contacts.Count; i++) { dgUsers.Rows.Add(); dgUsers.Rows[i].Cells[0].Value = form.list.contacts[i].surname + " " + form.list.contacts[i].name + " " + form.list.contacts[i].patronymic; StringBuilder s = new StringBuilder(); foreach (PhoneNumber number in users[index].contacts[i].numbers) { s.Append(number.ToString() + " "); } dgUsers.Rows[i].Cells[1].Value = s; } }
private void btOK_Click(object sender, EventArgs e) { if (tbName.Text == "" || tbPatronymic.Text == "" || tbSurname.Text == "") { return; } else { connection1.Open(); List<PhoneNumber> numbers = new List<PhoneNumber>(); StringBuilder sbr = new StringBuilder(); foreach (String str in lbNumbers.Items) { String[] result = str.Split(' '); numbers.Add(new PhoneNumber(result[0], result[1])); } list.contacts.RemoveAt(Int32.Parse(contact.id) - 1); Contact ct = new Contact(tbName.Text, tbSurname.Text, tbPatronymic.Text, numbers); ct.id = index.ToString(); UserContactsProcessing.AddContact(ct, list); BaseDataAccess.UpdateContacts(connection1, ct, index); this.DialogResult = DialogResult.OK; this.Close(); } }