public void SaveCurrentMonthBudgetSettleReport(TinyMoneyDataContext db, System.DateTime date) { var month = date.Month; var year = date.Year; if (month == 1) { month = 12; year--; } else { month--; } var lastTimeReportSaved = IsolatedAppSetingsHelper.LastTimeBudgetReportSaved; if (lastTimeReportSaved.Month < DateTime.Now.Month && lastTimeReportSaved.Year <= DateTime.Now.Year) { IsolatedAppSetingsHelper.LastTimeBudgetReportSaved = DateTime.Now; if (db.BudgetMonthlyReports.Count<BudgetMonthlyReport>(p => ((p.Year == year) && (p.Month == month))) == 0) { Table<BudgetProject> budgetProjects = db.BudgetProjects; if (budgetProjects.Count<BudgetProject>() > 0) { foreach (BudgetProject project in budgetProjects) { BudgetMonthlyReport entity = new BudgetMonthlyReport { Month = month, Year = year, Amount = project.GetMoney().GetValueOrDefault(), BudgetProjectId = project.Id, ItemType = project.ItemType }; db.BudgetMonthlyReports.InsertOnSubmit(entity); } db.SubmitChanges(); } } } }
public void SaveCurrentMonthBudgetSettleReport(TinyMoneyDataContext db, System.DateTime date) { BugFixingFor1_8_9(); if (db.BudgetMonthlyReports.Count<BudgetMonthlyReport>(p => ((p.Year == date.Year) && (p.Month == (date.Month - 1)))) == 0) { Table<BudgetProject> budgetProjects = db.BudgetProjects; if (budgetProjects.Count<BudgetProject>() > 0) { foreach (BudgetProject project in budgetProjects) { BudgetMonthlyReport entity = new BudgetMonthlyReport { Month = date.Month - 1, Year = date.Year, Amount = project.GetMoney().GetValueOrDefault(), BudgetProjectId = project.Id, ItemType = project.ItemType }; db.BudgetMonthlyReports.InsertOnSubmit(entity); } db.SubmitChanges(); } } }