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