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