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));
}
