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