public string ChangeCategory(int id, string name) { string result = "1:1"; var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbname); using (var db = new SQLiteConnection(dbPath)) { // Работа с БД var _bud = new CategoryTable() { _Name = name, ID = id }; db.Update(_bud); var _change = new ChangesTable() { _DBString = "UPDATE CategoryTable SET _Name='" + name +"' WHERE ID='" + id + "';", _ChangesDatetime = DateTime.Now }; db.Insert(_change); } return result; }
/// <summary> /// Добавление новой категории /// </summary> /// <param name="Name"></param> /// <returns></returns> public string AddCategory(string Name) { string result = "1:1"; var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbname); using (var db = new SQLiteConnection(dbPath)) { // Работа с БД var _bud = new CategoryTable() { _Name = Name }; db.Insert(_bud); var _change = new ChangesTable() { _DBString = "INSERT INTO CategoryTable(_Name) VALUES('" + Name + "');", _ChangesDatetime = DateTime.Now }; db.Insert(_change); } return result; }