public void SaveContact(ContactRecord rec) { if (rec.id == 0) { Model.insertContact(rec); } else { Model.updateContact(rec); } ShowContactsLog(); }
public static void updateContact(ContactRecord rec) { if (!opened) { return; } string sql = String.Format("UPDATE contacts SET name='{0}', contact='{1}' WHERE rowid={2}", s(rec.name), s(rec.contact), rec.id ); Save(sql); contacts[rec.id] = rec; }
public static void insertContact(ContactRecord rec) { if (!opened) { return; } string sql = String.Format("INSERT INTO contacts (name, contact) VALUES ('{0}','{1}')", s(rec.name), s(rec.contact) ); rec.id = Insert(sql); contacts[rec.id] = rec; }
public static void loadContacts() { contacts.Clear(); if (!opened) { return; } string sql = "SELECT rowid, name,contact FROM contacts ORDER BY name"; var cmd = new SQLiteCommand(sql, db); SQLiteDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { var item = new ContactRecord(); item.id = Convert.ToInt32(reader["rowid"]); item.name = reader["name"].ToString(); item.contact = reader["contact"].ToString(); contacts[item.id] = item; } }
public ContactUpdate(int id) { InitializeComponent(); data = id == 0 ? new ContactRecord() : Model.contacts[id]; }