public void Add(CashMoneyItem p)
{
var sqlItems = new SqlItemList();
sqlItems.Add(new SqlItem("Date", p.Date));
sqlItems.Add(new SqlItem("TotalSpent", p.TotalSpent));
sqlItems.Add(new SqlItem("Description", p.Description));
SetInsertIntoSql(SynnDataProvider.TableNames.CashItems, sqlItems);
ExecuteSql();
}
protected void btnAddCashItem_Command(object sender, CommandEventArgs e)
{
var row = (sender as ImageButton).NamingContainer as GridViewRow;
var spent = ((TextBox)row.FindControl("txspent")).Text;
var Idesc = ((TextBox)row.FindControl("txIdesc")).Text;
if (spent.NotEmpty() && Idesc.NotEmpty())
{
var i = new CashMoneyItem
{
Date = DateTime.Now,
Description = Idesc,
TotalSpent = spent.ToInteger(),
};
DBController.DbMoney.Add(i);
var current = DBController.DbMoney.Get(new CashSearchParameters {
Month = DateTime.Now
}).FirstOrDefault();
current.TotalSpent += i.TotalSpent;
DBController.DbMoney.Update(current);
RefreshView();
}
}
