public bool Save(Contact phoneContact) { var sqlConnection = SQLLiteHelperF.CreateInstance().SQLiteConnection; var sqlCommandString = "insert into Contacts (Name, PhoneNumber) values (?,?)"; using (var stt = sqlConnection.Prepare(sqlCommandString)) { stt.Bind(1, phoneContact.Name); stt.Bind(2, phoneContact.PhoneNumber); var result = stt.Step(); // Debug.WriteLine("create " + result); return(result == SQLiteResult.DONE); } }
public bool Delete(int id) { var sqlConnection = SQLLiteHelperF.CreateInstance().SQLiteConnection; var sqlCommandString = "DELETE FROM Contacts WHERE Id = '" + id + "'"; using (var stt = sqlConnection.Prepare(sqlCommandString)) { if (SQLiteResult.DONE == stt.Step()) { return(true); } return(false); } }
public Contact GetDetail(string name) { var sqlConnection = SQLLiteHelperF.CreateInstance().SQLiteConnection; var sqlCommandString = "SELECT * FROM Contacts WHERE Name LIKE '%" + name + "%' LIMIT 1"; using (var stt = sqlConnection.Prepare(sqlCommandString)) { if (SQLiteResult.ROW == stt.Step()) { var id = stt[0].ToString(); var _name = (string)stt["Name"]; var _phoneNumber = (string)stt["PhoneNumber"]; var contact = new Contact() { Id = Int32.Parse(id), Name = _name, PhoneNumber = _phoneNumber }; return(contact); } return(null); } }
public Contact Update(Contact phoneContact) { var sqlConnection = SQLLiteHelperF.CreateInstance().SQLiteConnection; var sqlCommandString = "UPDATE Contacts SET Name = '" + phoneContact.Name + "', PhoneNumber = '" + phoneContact.PhoneNumber + "' WHERE Id = '" + phoneContact.Id + "'"; using (var stt = sqlConnection.Prepare(sqlCommandString)) { if (SQLiteResult.ROW == stt.Step()) { var id = stt[0].ToString(); var _name = (string)stt["Name"]; var _phoneNumber = (string)stt["PhoneNumber"]; var contact = new Contact() { Id = Int32.Parse(id), Name = _name, PhoneNumber = _phoneNumber }; return(contact); } return(null); } }
public ObservableCollection <Contact> GetList() { ObservableCollection <Contact> list = new ObservableCollection <Contact>(); var sqlConnection = SQLLiteHelperF.CreateInstance().SQLiteConnection; var sqlCommandString = "select * from Contacts"; using (var stt = sqlConnection.Prepare(sqlCommandString)) { while (SQLiteResult.ROW == stt.Step()) { var id = stt[0].ToString(); var _name = (string)stt["Name"]; var _phoneNumber = (string)stt["PhoneNumber"]; var contact = new Contact() { Id = Int32.Parse(id), Name = _name, PhoneNumber = _phoneNumber }; list.Add(contact); } } return(list); }