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