private void DisplayEntries()
        {
            Diagnostics.StartTimer("ViewJournal.Refresh");
            List<short> typeIDs = new List<short>();
            DateTime startDate, endDate;
            typeIDs.Add((short)cmbType.SelectedValue);
            string nameProfile = "";
            if (!txtName.Text.Equals(""))
            {
                nameProfile = "%" + txtName.Text + "%";
            }

            Cursor = Cursors.WaitCursor;

            try
            {
                if (_allowRefresh)
                {
                    long ownerID = 0;
                    if (cmbOwner.SelectedValue != null && !chkIngoreOwner.Checked)
                    {
                        CharCorp data = (CharCorp)cmbOwner.SelectedValue;
                        ownerID = data.corp ? data.characterObj.CorpID : data.characterObj.CharID;
                    }
                    int walletID = 0;
                    if (cmbWallet.SelectedValue != null && !chkIgnoreWallet.Checked)
                    {
                        walletID = (int)cmbWallet.SelectedValue;
                    }

                    _accessParams = new List<FinanceAccessParams>();
                    if (ownerID == 0)
                    {
                        foreach (long id in _possibleOwners)
                        {
                            _accessParams.Add(new FinanceAccessParams(id));
                        }
                    }
                    else
                    {
                        List<short> wallets = new List<short>();
                        if (walletID != 0)
                        {
                            wallets.Add((short)walletID);
                        }
                        _accessParams.Add(new FinanceAccessParams(ownerID, wallets));
                    }

                    startDate = dtpStartDate.Value.ToUniversalTime();
                    endDate = dtpEndDate.Value.ToUniversalTime();

                    //ListSortDirection sortDirection = ListSortDirection.Descending;
                    //DataGridViewColumn sortColumn = journalDataGridView.SortedColumn;
                    //if (journalDataGridView.SortOrder == SortOrder.Ascending) sortDirection = ListSortDirection.Ascending;
                    List<SortInfo> sortinfo = journalDataGridView.GridSortInfo;

                    Diagnostics.StartTimer("ViewJournal.Refresh.Load");
                    _entries = Journal.LoadEntries(_accessParams, typeIDs, startDate, endDate, nameProfile);
                    Diagnostics.StopTimer("ViewJournal.Refresh.Load");
                    _journalBindingSource.DataSource = _entries;

                    //journalDataGridView.AutoResizeColumns();
                    //journalDataGridView.AutoResizeRows();

                    //if (sortColumn != null)
                    //{
                    //   journalDataGridView.Sort(sortColumn, sortDirection);
                    //}
                    //else
                    //{
                    //    journalDataGridView.Sort(DateColumn, ListSortDirection.Descending);
                    //}
                    if (sortinfo.Count == 0)
                    {
                        DataGridViewColumn column = journalDataGridView.Columns["DateColumn"];
                        sortinfo.Add(new SortInfo(column.Index, column.DataPropertyName));
                    }
                    journalDataGridView.GridSortInfo = sortinfo;

                    Text = "Viewing " + _journalBindingSource.Count + " entries";
                    Diagnostics.StopTimer("ViewJournal.Refresh");
                    Diagnostics.StopTimer("ViewJournal.Load");
                    Diagnostics.StopTimer("ViewJournal.Load.Part4");
                    Diagnostics.DisplayDiag(
                        "Time to refresh: " + Diagnostics.GetRunningTime("ViewJournal.Refresh").ToString() +
                        "\r\nData load time: " + Diagnostics.GetRunningTime("ViewJournal.Refresh.Load").ToString() +
                        "\r\n\tDatabase access time: " + Diagnostics.GetRunningTime("Journal.LoadEntries.Database").ToString() +
                        "\r\n\tJournal list build time: " + Diagnostics.GetRunningTime("Journal.LoadEntries.BuildList").ToString());
                    Diagnostics.StartTimer("ViewJournal.Load");
                    Diagnostics.StartTimer("ViewJournal.Load.Part4");
                }
            }
            finally
            {
                Cursor = Cursors.Default;
            }
        }
        private void ViewJournal_Load(object sender, EventArgs e)
        {
            try
            {
                Diagnostics.ResetAllTimers();
                Diagnostics.StartTimer("ViewJournal.Load");
                Diagnostics.StartTimer("ViewJournal.Load.Part1");
                _entries = new JournalList();
                _journalBindingSource = new BindingSource();
                _journalBindingSource.DataSource = _entries;

                DataGridViewCellStyle style = new DataGridViewCellStyle(AmountColumn.DefaultCellStyle);
                style.Format = IskAmount.FormatString();
                AmountColumn.DefaultCellStyle = style;
                DataGridViewCellStyle style2 = new DataGridViewCellStyle(BalanceColumn.DefaultCellStyle);
                style2.Format = IskAmount.FormatString();
                BalanceColumn.DefaultCellStyle = style2;

                journalDataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.None;
                journalDataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;

                journalDataGridView.DataSource = _journalBindingSource;
                IDColumn.DataPropertyName = "Id";
                DateColumn.DataPropertyName = "Date";
                TypeColumn.DataPropertyName = "Type";
                OwnerIsSenderColumn.DataPropertyName = "OwnerIsSender";
                Owner1Column.DataPropertyName = "Sender";
                OwnerID1Column.DataPropertyName = "SenderID";
                Owner2Column.DataPropertyName = "Reciever";
                OwnerID2Column.DataPropertyName = "RecieverID";
                ArgIDColumn.DataPropertyName = "ArgID";
                ArgNameColumn.DataPropertyName = "ArgName";
                AmountColumn.DataPropertyName = "Amount";
                BalanceColumn.DataPropertyName = "Balance";
                ReasonColumn.DataPropertyName = "Reason";
                Owner1CorpColumn.DataPropertyName = "SenderCorp";
                Owner2CorpColumn.DataPropertyName = "RecieverCorp";
                Owner1WalletColumn.DataPropertyName = "SenderWallet";
                Owner2WalletColumn.DataPropertyName = "RecieverWallet";

                UserAccount.Settings.GetColumnWidths(this.Name, journalDataGridView);

                dtpEndDate.Value = DateTime.Now;
                dtpStartDate.Value = DateTime.Now.AddDays(-2);
                dtpEndDate.KeyDown += new KeyEventHandler(dtpEndDate_KeyDown);
                dtpEndDate.Leave += new EventHandler(dtpEndDate_Leave);
                dtpStartDate.KeyDown += new KeyEventHandler(dtpStartDate_KeyDown);
                dtpStartDate.Leave += new EventHandler(dtpStartDate_Leave);

                Diagnostics.StopTimer("ViewJournal.Load.Part1");

                Diagnostics.StartTimer("ViewJournal.Load.Part2");
                List<CharCorpOption> charcorps = UserAccount.CurrentGroup.GetCharCorpOptions(APIDataType.Journal);
                _possibleOwners = new List<long>();
                foreach (CharCorpOption chop in charcorps)
                {
                    _possibleOwners.Add(chop.Corp ? chop.CharacterObj.CorpID : chop.CharacterObj.CharID);
                }
                _accessParams = new List<FinanceAccessParams>();
                foreach (long id in _possibleOwners)
                {
                    _accessParams.Add(new FinanceAccessParams(id));
                }
                cmbOwner.DisplayMember = "Name";
                cmbOwner.ValueMember = "Data";
                charcorps.Sort();
                cmbOwner.DataSource = charcorps;
                cmbOwner.SelectedValue = 0;
                cmbOwner.Enabled = false;
                Diagnostics.StopTimer("ViewJournal.Load.Part2");

                Diagnostics.StartTimer("ViewJournal.Load.Part3");
                EMMADataSet.JournalRefTypesDataTable types = JournalRefTypes.GetTypesByJournal(_accessParams);
                EMMADataSet.JournalRefTypesRow newType = types.NewJournalRefTypesRow();
                newType.ID = 0;
                newType.RefName = "All Types";
                types.AddJournalRefTypesRow(newType);
                BindingSource typesSource = new BindingSource();
                typesSource.DataSource = types;
                typesSource.Sort = "RefName";
                cmbType.DisplayMember = "RefName";
                cmbType.ValueMember = "ID";
                cmbType.DataSource = typesSource;
                cmbType.SelectedValue = 0;
                Diagnostics.StopTimer("ViewJournal.Load.Part3");

                cmbType.SelectedIndexChanged += new EventHandler(cmbType_SelectedIndexChanged);

                cmbOwner.SelectedIndexChanged += new EventHandler(cmbOwner_SelectedIndexChanged);
                chkIngoreOwner.Checked = true;
                chkIngoreOwner.CheckedChanged += new EventHandler(chkIngoreOwner_CheckedChanged);

                cmbWallet.SelectedIndexChanged += new EventHandler(cmbWallet_SelectedIndexChanged);

                DisplayWallets();
                chkIgnoreWallet.CheckedChanged += new EventHandler(chkIgnoreWallet_CheckedChanged);
                txtName.KeyDown += new KeyEventHandler(txtName_KeyDown);
                txtName.Leave += new EventHandler(txtName_Leave);

                Diagnostics.StartTimer("ViewJournal.Load.Part4");
                this.FormClosing += new FormClosingEventHandler(ViewJournal_FormClosing);
                DisplayEntries();
                Diagnostics.StopTimer("ViewJournal.Load.Part4");
                Diagnostics.StopTimer("ViewJournal.Load");

                Diagnostics.DisplayDiag(
                    "Total form load time: " + Diagnostics.GetRunningTime("ViewJournal.Load").ToString() +
                    "\r\nSplit time 1: " + Diagnostics.GetRunningTime("ViewJournal.Load.Part1").ToString() +
                    "\r\nSplit time 2: " + Diagnostics.GetRunningTime("ViewJournal.Load.Part2").ToString() +
                    "\r\nSplit time 3: " + Diagnostics.GetRunningTime("ViewJournal.Load.Part3").ToString() +
                    "\r\nSplit time 4: " + Diagnostics.GetRunningTime("ViewJournal.Load.Part4").ToString());
            }
            catch (Exception ex)
            {
                // Creating new EMMAexception will cause error to be logged.
                EMMAException emmaex = ex as EMMAException;
                if (emmaex == null)
                {
                    emmaex = new EMMAException(ExceptionSeverity.Critical, "Error setting up journal form", ex);
                }
                MessageBox.Show("Problem setting up journal view.\r\nCheck " + Globals.AppDataDir + "Logging\\ExceptionLog.txt" +
                    " for details.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
Esempio n. 3
0
        public static JournalList LoadEntries(List<FinanceAccessParams> accessParams, List<short> typeIDs,
            DateTime startDate, DateTime endDate, string nameProfile)
        {
            JournalList retVal = new JournalList();

            EMMADataSet.JournalDataTable table = LoadEntriesData(accessParams, typeIDs, startDate, endDate, nameProfile);

            Diagnostics.StartTimer("Journal.LoadEntries.BuildList");
            foreach (EMMADataSet.JournalRow row in table)
            {
                // We need to build the journal rows differently depending on who the owner is...
                long sOwner = 0, rOwner = 0;
                foreach (FinanceAccessParams access in accessParams)
                {
                    if ((access.OwnerID == row.SenderID && sOwner == 0) || access.OwnerID == row.SCorpID)
                    {
                        sOwner = access.OwnerID;
                    }
                    if ((access.OwnerID == row.RecieverID && rOwner == 0) || access.OwnerID == row.RCorpID)
                    {
                        rOwner = access.OwnerID;
                    }
                }

                if (rOwner != 0) { retVal.Add(new JournalEntry(row, rOwner)); }
                if (sOwner != 0) { retVal.Add(new JournalEntry(row, sOwner)); }
            }
            Diagnostics.StopTimer("Journal.LoadEntries.BuildList");
            return retVal;
        }