public string CreateContact(CreateContactCommand contact) { ContactDTO contact1 = new ContactDTO(); contact1.Id = Guid.NewGuid().ToString(); contact1.Name = contact.Name; contact1.Address = contact.Address; contact1.Phone = contact.Phone; return(dal.CreateContact(contact1)); }
public string CreateContact(ContactDTO contact) { string text = string.Format("INSERT INTO contacts(id, name, phone, address) VALUES('{0}', '{1}', '{2}', '{3}')", contact.Id, contact.Name, contact.Phone, contact.Address); ExecuteNonQuery(text); return(contact.Id); }
private void updateContact(object sender, EventArgs e) { int row = Convert.ToInt32(bindingNavigatorPositionItem.Text) - 1; var text = dataGridView1.Rows[row]; ContactDTO contact = new ContactDTO(); contact.Id = text.Cells[0].Value.ToString(); contact.Name = text.Cells[1].Value.ToString(); contact.Phone = text.Cells[2].Value.ToString(); contact.Address = text.Cells[3].Value.ToString(); bll.UpdateContact(contact); }
public bool UpdateContact(ContactDTO contact) { string text = string.Format("UPDATE contacts SET id = \"{0}\", name = \"{1}\", phone = \"{2}\", address = \"{3}\" WHERE id = \"{0}\"", contact.Id, contact.Name, contact.Phone, contact.Address); MessageBox.Show(text); ExecuteNonQuery(text); return(true); }
public List <ContactDTO> GetContacts(string selectSQL) { List <ContactDTO> res = new List <ContactDTO>(); using (SQLiteCommand command = new SQLiteCommand(selectSQL, con)) { var reader = command.ExecuteReader(); while (reader.Read()) { var item = new ContactDTO { Id = reader.GetString(0), Name = reader.GetString(1), Phone = reader.GetString(2), Address = reader.GetString(3) }; res.Add(item); } } return(res); }
public bool UpdateContact(ContactDTO contact) { return(dal.UpdateContact(contact)); }