public SymbolDetailForm(SymbolDataSet.LocalizedSymbolRow currentLocalizedSymbolRow)
{
InitializeComponent();
// Set up the SoundPlayer object.
player = new SoundPlayer();
if (currentLocalizedSymbolRow.RowState == DataRowState.Added)
{
symbolId = 0;
this.BindingContext[this.symbolDetailDataSet, SYMBOL].AddNew();
DataRowView rowView = this.BindingContext[this.symbolDetailDataSet, SYMBOL].Current as DataRowView;
SymbolDetailDataSet.SymbolRow currentSymbolRow = rowView.Row as SymbolDetailDataSet.SymbolRow;
rowView.BeginEdit();
currentSymbolRow.Name = Guid.NewGuid();
currentSymbolRow.CategoryId = currentLocalizedSymbolRow.CategoryId;
rowView.EndEdit();
}
else
{
symbolId = currentLocalizedSymbolRow.SymbolId;
}
this.symbolDetailDataSet.Merge(currentLocalizedSymbolRow.Table.DataSet.Tables[LOCALIZED_CATEGORY]);
this.cultureName = Properties.Settings.Default.CultureName;
}
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 buttonChangeSymbol_Click(object sender, EventArgs e)
{
DataRowView view = this.BindingContext[adaCommunicatorDataSet1, TEXT_TABLE].Current as DataRowView;
ADACommunicatorDataSet.TextRow textRow = view.Row as ADACommunicatorDataSet.TextRow;
SymbolPicker picker = new SymbolPicker();
SymbolDataSet.LocalizedSymbolRow symbolRow = picker.PickSymbol(this,
textRow.IsSymbolIdNull() ? -1 : textRow.SymbolId);
if (symbolRow != null)
{
if (adaCommunicatorDataSet1.Symbol.FindBySymbolId(symbolRow.SymbolId) == null)
{
ADACommunicatorDataSet.SymbolRow newRow = adaCommunicatorDataSet1.Symbol.NewSymbolRow();
newRow.SymbolId = symbolRow.SymbolId;
if (!symbolRow.IsSoundNull())
{
newRow.Sound = symbolRow.Sound;
}
if (!symbolRow.IsImageNull())
{
newRow.Image = symbolRow.Image;
}
adaCommunicatorDataSet1.Symbol.AddSymbolRow(newRow);
adaCommunicatorDataSet1.Symbol.AcceptChanges();
}
byte[] image = symbolRow.Image;
if (image != null)
{
this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size);
}
buttonPlaySound.Enabled = !symbolRow.IsSoundNull();
this.BindingContext[adaCommunicatorDataSet1, TEXT_TABLE].EndCurrentEdit();
view.BeginEdit();
if (textRow.IsNameNull() || textRow.Name.Length == 0)
{
textRow.Name = symbolRow.Name;
}
if (textRow.IsDescriptonNull() || textRow.Descripton.Length == 0)
{
textRow.Descripton = textRow.Name;
}
textRow.SymbolId = symbolRow.SymbolId;
view.EndEdit();
}
}
private void buttonEditSymbol_Click(object sender, EventArgs e)
{
ListView.SelectedListViewItemCollection selectedSymbols = this.listViewSymbol.SelectedItems;
SymbolDataSet.LocalizedSymbolRow currentSymbolRow = selectedSymbols[0].Tag as SymbolDataSet.LocalizedSymbolRow;
SymbolDetailForm detailForm = new SymbolDetailForm(currentSymbolRow);
if (DialogResult.OK == detailForm.ShowDialog(this))
{
this.LoadDataSet();
}
}
private void buttonChangeSymbol_Click(object sender, EventArgs e)
{
DataRowView view = this.BindingContext[adaScheduleDataSet1, ACTIVITY_TABLE].Current as DataRowView;
ADAScheduleDataSet.ActivityRow activityRow = view.Row as ADAScheduleDataSet.ActivityRow;
SymbolPicker picker = new SymbolPicker();
SymbolDataSet.LocalizedSymbolRow symbolRow = picker.PickSymbol(this,
activityRow.IsSymbolIdNull() ? -1 : activityRow.SymbolId);
if (symbolRow != null)
{
if (adaScheduleDataSet1.Symbol.FindBySymbolId(symbolRow.SymbolId) == null)
{
ADAScheduleDataSet.SymbolRow newRow = adaScheduleDataSet1.Symbol.NewSymbolRow();
newRow.SymbolId = symbolRow.SymbolId;
if (!symbolRow.IsSoundNull())
{
newRow.Sound = symbolRow.Sound;
}
if (!symbolRow.IsImageNull())
{
newRow.Image = symbolRow.Image;
}
adaScheduleDataSet1.Symbol.AddSymbolRow(newRow);
}
byte[] image = symbolRow.Image;
if (image != null)
{
this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size);
}
buttonPlaySound.Enabled = !symbolRow.IsSoundNull();
this.BindingContext[adaScheduleDataSet1, ACTIVITY_TABLE].EndCurrentEdit();
view.BeginEdit();
activityRow.Name = symbolRow.Name;
activityRow.SymbolId = symbolRow.SymbolId;
activityRow.Image = image;
view.EndEdit();
}
}
private void buttonDeleteSymbol_Click(object sender, EventArgs e)
{
ListView.SelectedListViewItemCollection selectedSymbols = this.listViewSymbol.SelectedItems;
SymbolDataSet.LocalizedSymbolRow currentSymbolRow = selectedSymbols[0].Tag as SymbolDataSet.LocalizedSymbolRow;
// Initializes the variables to pass to the MessageBox.Show method.
string message = string.Format(Resources.ConfirmDeletionMessage, currentSymbolRow.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
{
LocalizedSymbolTableAdapter symbolAdapter = new LocalizedSymbolTableAdapter();
symbolAdapter.Connection.Open();
SqlCommand sqlUpdateCommand = new SqlCommand();
sqlUpdateCommand.Connection = symbolAdapter.Connection;
sqlUpdateCommand.CommandText = @"UPDATE Symbol SET IsActive = 'false' WHERE (SymbolId = @SymbolId) ";
sqlUpdateCommand.Parameters.Add(new SqlParameter("@SymbolId", System.Data.SqlDbType.Int, 0, "SymbolId"));
sqlUpdateCommand.Parameters["@SymbolId"].Value = currentSymbolRow.SymbolId;
sqlUpdateCommand.ExecuteNonQuery();
symbolAdapter.Connection.Close();
this.LoadDataSet();
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
}
}
}
private void buttonAddSymbol_Click(object sender, EventArgs e)
{
ListView.SelectedListViewItemCollection selectedItems = this.listViewCategory.SelectedItems;
SymbolDataSet.LocalizedCategoryRow currentCategoryRow = selectedItems[0].Tag as SymbolDataSet.LocalizedCategoryRow;
SymbolDataSet.LocalizedSymbolRow currentSymbolRow = this.symbolDataSet.LocalizedSymbol.NewLocalizedSymbolRow();
currentSymbolRow.CategoryId = currentCategoryRow.CategoryId;
this.symbolDataSet.LocalizedSymbol.AddLocalizedSymbolRow(currentSymbolRow);
SymbolDetailForm detailForm = new SymbolDetailForm(currentSymbolRow);
if (DialogResult.OK == detailForm.ShowDialog(this))
{
this.LoadDataSet();
}
else
{
this.symbolDataSet.LocalizedSymbol.RejectChanges();
}
}
private void buttonOK_Click(object sender, EventArgs e)
{
ListView.SelectedListViewItemCollection selectedSymbols = this.listViewSymbol.SelectedItems;
pickedSymbol = selectedSymbols[0].Tag as SymbolDataSet.LocalizedSymbolRow;
DialogResult = DialogResult.OK;
}
