private static void CreditDataAction(LoggedUser u)
{
var p = u.Preferences;
if (p.CreditLogStartDate.NotEmpty() && p.CreditCardPaymentDay > 0)
{
var date = p.CreditLogStartDate;
while (date <= DateTime.Now)
{
var current = DBController.DbMoney.Get(new CreditSearchParameters {
Month = date
}).FirstOrDefault();
if (current == null)
{
var i = new CreditCardMonthlyData
{
Active = true,
Date = new DateTime(date.Year, date.Month, p.CreditCardPaymentDay),
TotalSpent = 0,
};
DBController.DbMoney.Add(i);
}
date = date.AddMonths(1);
}
}
}
public void Add(CreditCardMonthlyData i)
{
SqlItemList sqlItems = Get(i);
SetInsertIntoSql(SynnDataProvider.TableNames.CreditData, sqlItems);
ExecuteSql();
}
protected void btnCloseMonth_Command(object sender, CommandEventArgs e)
{
CreditCardMonthlyData i = GetItem(e.CommandArgument);
i.Active = false;
DBController.DbMoney.Update(i);
RefreshView();
}
public void Update(CreditCardMonthlyData i)
{
SqlItemList sqlItems = Get(i);
SetUpdateSql(SynnDataProvider.TableNames.CreditData, sqlItems, new SqlItemList {
new SqlItem {
FieldName = "Id", FieldValue = i.Id
}
});
ExecuteSql();
}
protected void btnAction_Command(object sender, CommandEventArgs e)
{
CreditCardMonthlyData i = GetItem(e.CommandArgument);
var row = (sender as ImageButton).NamingContainer as GridViewRow;
var txCurrentTotal = (TextBox)row.FindControl("txCurrentTotal");
var nVal = Convert.ToInt32(Convert.ToDecimal(txCurrentTotal.Text));
if (i.Active)
{
i.TotalSpent = nVal;
DBController.DbMoney.Update(i);
RefreshGrid(gv);
}
}
