private void RenumberIssues() { var tableIssues = Issues.GetDataByStateCode(StateCode) .OrderBy(r => r.IssueOrder); var count = 10; foreach (var rowIssue in tableIssues) { Issues.UpdateIssueOrder(count, rowIssue.IssueKey); count += 10; } }
private void BackgroundWorker_DoWork(object sender, DoWorkEventArgs e) { try { int found = 0; int notFound = 0; bool update = (bool)e.Argument; var stateCode = StateCodeTextBox.Text.Trim().ToUpperInvariant(); if (!StateCache.IsValidStateCode(stateCode)) { throw new VoteException("Invalid state code"); } var table = Issues.GetDataByStateCode(stateCode); foreach (var row in table) { if (!row.IsIssueOmit) { if (!row.IssueKey.StartsWith("C" + stateCode)) { throw new VoteException("Bad IssueKey: " + row.IssueKey); } string tableKey = row.IssueKey.Substring(3); string issueGroupSuffix; if (IssueGroupDictionary.TryGetValue(tableKey, out issueGroupSuffix)) { found++; } else { notFound++; AppendStatusText("Key not found: " + row.IssueKey); } } } AppendStatusText("{0} found, {1} not found", found, notFound); if (notFound > 0 || !update) { AppendStatusText("Not updated"); } else { foreach (var row in table) { if (!row.IsIssueOmit) { string tableKey = row.IssueKey.Substring(3); string issueGroupSuffix = IssueGroupDictionary[tableKey]; IssueGroupsIssues.Insert( issueGroupKey: stateCode + issueGroupSuffix, issueKey: row.IssueKey, issueOrder: 0); } } AppendStatusText("Table updated"); } } catch (Exception ex) { AppendStatusText("Exception: " + ex.Message); } AppendStatusText("Process is complete."); }