public void Add(CashMonthlyData i)
{
SqlItemList sqlItems = Get(i);
SetInsertIntoSql(SynnDataProvider.TableNames.CashData, sqlItems);
ExecuteSql();
}
public void Update(CashMonthlyData i)
{
SqlItemList sqlItems = Get(i);
SetUpdateSql(SynnDataProvider.TableNames.CashData, sqlItems, new SqlItemList {
new SqlItem {
FieldName = "Id", FieldValue = i.Id
}
});
ExecuteSql();
}
private static void CashDataAction(LoggedUser u)
{
var date = DateTime.Now;
var current = DBController.DbMoney.Get(new CashSearchParameters {
Month = date
}).FirstOrDefault();
if (current == null)
{
var i = new CashMonthlyData
{
Active = true,
Date = new DateTime(date.Year, date.Month, 1),
TotalSpent = 0,
};
DBController.DbMoney.Add(i);
}
}
