How to get monthly reports store app i am developing a account manager app in that i want to display monthly and yearly income and expense

See more:

C#

ASP.NET

C#3.5

, +

Please Help me to build my final year project.i am making my windows store app(C#) that name is "Account manager" their major two component 1.Income 2.Expense
My income table having this field

Field Name	Data Type (Size)
IncomeID	int
UserID	int
AccountID	int
IncomeTitle	nvarchar(30)
IncomeAmount	double(10,2)
IncomeDate	datetime
IncomeDetail	nvarchar(150)
PaymentMode	nvarchar(10)

and My Expense Table contain this field

Field Name	Data Type (Size)
ExpenseID	int
UserID	int
AccountID	int
ExpenseCategoryID	int
ExpenseTitle	nvarchar(30)
ExpenseAmount	double(10,2)
ExpenseDate	datetime
ExpenseDetail	nvarchar(150)
PaymentMode	nvarchar(10)

Pleas Help me out to generate Monthly Income & Expense and Yearly Income And expense.

What I have tried:

i have tried this code In my Monthly expense Page.

private async void navigationHelper_LoadState(object sender, LoadStateEventArgs e)
        {
            var expense = await client.getExpenseAsync();
            var user = await client.selectUserByIdAsync(App.userId);
            var expensecategory = await client.getExpensecategoryAsync();
            for (int i = 0; i < expense.Count; i++)
            {
                if (expense[i].expensedate.Value.Month == System.DateTime.Now.Month)
                {
                    gridexpense.Items.Add(expense);
                }
            }


        }