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