/// <summary> /// Метод изменения параметров бюджета /// </summary> /// <param name="id">Уникальный Id</param> /// <param name="Name">Название текущее или старое</param> /// <param name="NewName">Если указано, то бюджет переименовывается</param> /// <param name="Limit">Лимит по данному бюджету</param> /// <param name="TimePeriod">Период, на который расчитан бюджет</param> /// <param name="CategoryId">ID категории списания</param> /// <returns>Возвращает строку в формате -код ошибки;доп. информация-</returns> public string ChangeBudget(int id, string Name, double Limit, string TimePeriod, int CategoryId) { string result = "1;1"; var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbname); using (var db = new SQLiteConnection(dbPath)) { // Работа с БД var _bud = new BudgetTable() { _ID = id, _CategoryID = CategoryId, _Limit = Limit, _Name = Name, _TimePeriod = TimePeriod }; db.Update(_bud); var _change = new ChangesTable() { _DBString = "UPDATE BudgetTable SET _CategoryID='" + CategoryId + "', _Limit='" + Limit + "', _Name='" + (Name) + "', _TimePeriod='" + (TimePeriod) + "' WHERE _ID='" + id + "';", _ChangesDatetime = DateTime.Now }; db.Insert(_change); } return result; }
public void AddBudgetTest() { int CategoryId = 12345; double Limit = 10000.00; string Name = "TestBudget"; string TP = "Month"; var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, "testDB.db"); using (var db = new SQLiteConnection(dbPath)) { // Работа с БД var _bud = new BudgetTable() { _CategoryID = CategoryId, _Limit = Limit, _Name = Name, _TimePeriod = TP }; db.Insert(_bud); Assert.IsNotNull(_bud, "New Budget is NULL"); } }
public string AddBudget(string Name, double Limit, int CategoryId, string TP) { string result = "1;1"; var dbPath = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbname); using (var db = new SQLiteConnection(dbPath)) { // Работа с БД var _bud = new BudgetTable() { _CategoryID = CategoryId, _Limit = Limit, _Name = Name, _TimePeriod = TP}; db.Insert(_bud); var _change = new ChangesTable() { _DBString = "INSERT INTO BudgetTable(_ID, _Limit, _Name, _TimePeriod) VALUES('" + CategoryId + "', '" + Limit + "', '" + Name + "', '" + TP + "');", _ChangesDatetime = DateTime.Now }; db.Insert(_change); } return result; }