C#

public void GetTransactionData()
      {
          DateTime today = DateTime.Now.Date;
          List<Transaction> newTransactionList = DataManager.GetTransaction();
          List<Transaction> TransactionDataGridData = new List<Transaction>();

          var CurrentMonthTransaction = (from item in newTransactionList
                                         where ((int)item.Date.Month == today.Month)
                                         where ((int)item.Date.Year == today.Year)
                                         select item);

          try
          {
              foreach (Transaction item in CurrentMonthTransaction)
              {
                  TransactionDataGridData.Add(item);
              }

              if (TransactionDataGridData.Count >= 1)
              {
                  dgvTransactionList.ItemsSource = TransactionDataGridData.ToList();

                  decimal transactionTotal = (from item in TransactionDataGridData
                                              select Convert.ToInt32(item.Amount)).Sum();
                  txtTotalTransaction.Content = "Total: " + string.Format("{0:C}", transactionTotal);
              }
          }
          catch (Exception error)
          {

              MessageBox.Show(error.ToString());
          }

      }

dbCmd.AddInParameter("p_in_division", DbType.String, DDExcDivision.SelectedValue);
dbCmd.AddInParameter("p_in_subject", DbType.String, txtsubject.Value);
dbCmd.AddInParameter("p_in_body", DbType.String, exc_body.Value);

dbCmd.Command.Connection = dbConn;
db.ExecuteNonQuery(dbCmd);