private void LoadDataSet(bool forceLoad)
{
Cursor.Current = Cursors.WaitCursor;
try
{
if (forceLoad || bufferedDataSet == null)
{
LocalizedCategoryTableAdapter categoryAdapter = new LocalizedCategoryTableAdapter();
categoryAdapter.Fill(this.symbolDataSet.LocalizedCategory, cultureName);
LocalizedSymbolTableAdapter symbolAdapter = new LocalizedSymbolTableAdapter();
symbolAdapter.Fill(this.symbolDataSet.LocalizedSymbol, cultureName);
bufferedDataSet = symbolDataSet.Copy() as SymbolDataSet;
}
else
{
symbolDataSet.Merge(bufferedDataSet);
}
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
}
pickedSymbol = symbolDataSet.LocalizedSymbol.FindBySymbolId(this.currentSymbolId);
RefreshCategoryListView();
this.EnableButtons();
Cursor.Current = Cursors.Default;
}
private void buttonDeleteCategory_Click(object sender, EventArgs e)
{
ListView.SelectedListViewItemCollection selectedItems = this.listViewCategory.SelectedItems;
SymbolDataSet.LocalizedCategoryRow currentCategoryRow = selectedItems[0].Tag as SymbolDataSet.LocalizedCategoryRow;
// Initializes the variables to pass to the MessageBox.Show method.
string message = string.Format(Resources.ConfirmDeletionMessage, currentCategoryRow.Name);
string caption = Resources.ConfirmDeletionCaption;
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(this, message, caption, buttons,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
try
{
LocalizedCategoryTableAdapter categoryAdapter = new LocalizedCategoryTableAdapter();
categoryAdapter.Connection.Open();
SqlCommand sqlUpdateCommand = new SqlCommand();
sqlUpdateCommand.Connection = categoryAdapter.Connection;
sqlUpdateCommand.CommandText = @"UPDATE Symbol SET IsActive = 'false' WHERE (CategoryId = @CategoryId) ";
sqlUpdateCommand.Parameters.Add(new SqlParameter("@CategoryId", System.Data.SqlDbType.Int, 0, "CategoryId"));
sqlUpdateCommand.Parameters["@CategoryId"].Value = currentCategoryRow.CategoryId;
sqlUpdateCommand.ExecuteNonQuery();
sqlUpdateCommand.CommandText = @"UPDATE Category SET IsActive = 'false' WHERE (CategoryId = @CategoryId) ";
sqlUpdateCommand.ExecuteNonQuery();
categoryAdapter.Connection.Close();
this.LoadDataSet();
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
}
}
}
private void LoadDataSet()
{
Cursor.Current = Cursors.WaitCursor;
int selectedCategory = 0;
if (this.listViewCategory.SelectedIndices.Count > 0)
{
selectedCategory = this.listViewCategory.SelectedIndices[0];
}
int selectedSymbol = 0;
if (this.listViewSymbol.SelectedIndices.Count > 0)
{
selectedSymbol = this.listViewSymbol.SelectedIndices[0];
}
try
{
LocalizedCategoryTableAdapter cultureAdapter = new LocalizedCategoryTableAdapter();
cultureAdapter.Fill(this.symbolDataSet.LocalizedCategory, cultureName);
LocalizedSymbolTableAdapter symbolAdapter = new LocalizedSymbolTableAdapter();
symbolAdapter.Fill(this.symbolDataSet.LocalizedSymbol, cultureName);
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
}
RefreshCategoryListView();
this.listViewSymbol.Clear();
this.imageListSymbol.Images.Clear();
if (this.listViewCategory.Items.Count > 0)
{
if (selectedCategory >= this.listViewCategory.Items.Count)
{
selectedCategory = this.listViewCategory.Items.Count - 1;
}
this.listViewCategory.SelectedIndices.Clear();
this.listViewCategory.SelectedIndices.Add(selectedCategory);
}
if (this.listViewSymbol.Items.Count > 0)
{
if (selectedSymbol >= this.listViewSymbol.Items.Count)
{
selectedSymbol = this.listViewSymbol.Items.Count - 1;
}
this.listViewSymbol.SelectedIndices.Clear();
this.listViewSymbol.SelectedIndices.Add(selectedSymbol);
}
this.EnableButtons();
Cursor.Current = Cursors.Default;
}
