private void LoadDataSet()
{
Cursor.Current = Cursors.WaitCursor;
try
{
adaScenarioDataSet1.EnforceConstraints = false;
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(adaScenarioDataSet1.Symbol);
ScenarioTableAdapter scenarioAdapter = new ScenarioTableAdapter();
scenarioAdapter.Fill(adaScenarioDataSet1.Scenario);
TextTableAdapter textAdapter = new TextTableAdapter();
textAdapter.Fill(adaScenarioDataSet1.Text);
adaScenarioDataSet1.EnforceConstraints = true;
}
catch (Exception ex)
{
ReportError(ex);
}
RefreshViews();
Cursor.Current = Cursors.Default;
}
private void LoadDataSet()
{
Cursor.Current = Cursors.WaitCursor;
try
{
communicatorDataSet.EnforceConstraints = false;
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(communicatorDataSet.Symbol);
ScenarioTableAdapter scenarioAdapter = new ScenarioTableAdapter();
scenarioAdapter.Fill(communicatorDataSet.Scenario);
TextTableAdapter textAdapter = new TextTableAdapter();
textAdapter.Fill(communicatorDataSet.Text);
communicatorDataSet.EnforceConstraints = true;
communicatorDataSet.AcceptChanges();
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
}
RefreshScenarioListView();
this.EnableButtons();
Cursor.Current = Cursors.Default;
}
private void LoadDataSet()
{
Cursor.Current = Cursors.WaitCursor;
try
{
adaScheduleDataSet1.EnforceConstraints = false;
UserTableAdapter userAdapter = new UserTableAdapter();
userAdapter.Fill(adaScheduleDataSet1.User);
ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter();
scheduleAdapter.Fill(adaScheduleDataSet1.Schedule);
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(adaScheduleDataSet1.Symbol);
ActivityTableAdapter activityAdapter = new ActivityTableAdapter();
activityAdapter.Fill(adaScheduleDataSet1.Activity);
adaScheduleDataSet1.EnforceConstraints = true;
}
catch (Exception ex)
{
ReportError(ex);
}
RefreshViews();
Cursor.Current = Cursors.Default;
}
private void SymbolDetailForm_Load(object sender, EventArgs e)
{
try
{
LocalizedSymbolNameTableAdapter localizedSymbolNameAdapter = new LocalizedSymbolNameTableAdapter();
localizedSymbolNameAdapter.Fill(this.symbolDetailDataSet.LocalizedSymbolName, symbolId, cultureName);
if (symbolId > 0)
{
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(this.symbolDetailDataSet.Symbol, symbolId);
}
byte[] image = this.symbolDetailDataSet.Symbol.Rows[0]["Image"] as byte[];
if (image != null)
{
this.pictureBoxImage.Image = ImageEngine.Resize(ImageEngine.FromArray(image), this.pictureBoxImage.Size);
}
EnableButtons();
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
this.DialogResult = DialogResult.Abort;
this.Close();
}
}
private void LoadDataSet(ADAScheduleDataSet dataSet, DateTime date, bool loadSymbol)
{
try
{
dataSet.EnforceConstraints = false;
UserTableAdapter userAdapter = new UserTableAdapter();
userAdapter.Fill(dataSet.User);
ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter();
scheduleAdapter.Fill(dataSet.Schedule, date);
if (loadSymbol)
{
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(dataSet.Symbol, date);
}
ActivityTableAdapter activityAdapter = new ActivityTableAdapter();
activityAdapter.Fill(dataSet.Activity, date);
ReminderTableAdapter reminderAdapter = new ReminderTableAdapter();
reminderAdapter.Fill(dataSet.Reminder);
Activity_ReminderTableAdapter arAdapter = new Activity_ReminderTableAdapter();
arAdapter.Fill(dataSet.Activity_Reminder, date);
if (loadSymbol)
{
dataSet.EnforceConstraints = true;
foreach (ADAScheduleDataSet.ActivityRow activityRow in dataSet.Activity.Rows)
{
if (!activityRow.IsSymbolIdNull() && !activityRow.SymbolRow.IsImageNull())
{
activityRow.Image = activityRow.SymbolRow.Image;
}
}
}
dataSet.AcceptChanges();
}
catch (Exception ex)
{
ReportError(ex);
}
}
private void LoadDataSet(ADAWorkSystemDataSet dataSet, bool loadSymbol)
{
try
{
dataSet.EnforceConstraints = false;
ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter();
scheduleAdapter.Fill(dataSet.Schedule);
if (loadSymbol)
{
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(dataSet.Symbol);
}
ActivityTableAdapter activityAdapter = new ActivityTableAdapter();
activityAdapter.Fill(dataSet.Activity);
if (loadSymbol)
{
dataSet.EnforceConstraints = true;
foreach (ADAWorkSystemDataSet.ActivityRow activityRow in dataSet.Activity.Rows)
{
if (!activityRow.IsSymbolIdNull() && !activityRow.SymbolRow.IsImageNull())
{
activityRow.Image = activityRow.SymbolRow.Image;
}
}
}
dataSet.AcceptChanges();
}
catch (Exception ex)
{
ReportError(ex);
}
}
private void LoadDataSet()
{
Cursor.Current = Cursors.WaitCursor;
DateTime date = DateTime.Now.Date;
string userName = (string)ReadRegistry(Registry.CurrentUser, "Name", "ControlPanel", "Owner");
try
{
adaScheduleDataSet1.EnforceConstraints = false;
UserTableAdapter userAdapter = new UserTableAdapter();
userAdapter.Fill(adaScheduleDataSet1.User, userName);
ScheduleTableAdapter scheduleAdapter = new ScheduleTableAdapter();
scheduleAdapter.Fill(adaScheduleDataSet1.Schedule, date, userName);
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Fill(adaScheduleDataSet1.Symbol, date, userName);
ActivityTableAdapter activityAdapter = new ActivityTableAdapter();
activityAdapter.Fill(adaScheduleDataSet1.Activity, date, userName);
adaScheduleDataSet1.EnforceConstraints = true;
}
catch (Exception ex)
{
ReportError(ex);
}
_activityRows = adaScheduleDataSet1.Activity.Select("", "Sequence ASC");
RefreshViews();
Cursor.Current = Cursors.Default;
}
private void buttonOk_Click(object sender, EventArgs e)
{
try
{
this.BindingContext[this.symbolDetailDataSet, SYMBOL].EndCurrentEdit();
this.BindingContext[this.symbolDetailDataSet, LOCALIZED_SYMBOL_NAME].EndCurrentEdit();
DataRowView view = this.BindingContext[symbolDetailDataSet, SYMBOL].Current as DataRowView;
SymbolDetailDataSet.SymbolRow row = view.Row as SymbolDetailDataSet.SymbolRow;
if (row.IsImageNull())
{
this.DialogResult = DialogResult.None;
// Initializes the variables to pass to the MessageBox.Show method.
string message = Resources.ImageNotSetMessage;
string caption = Resources.ErrorCaption;
// Displays the MessageBox.
MessageBox.Show(this, message, caption, MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
foreach (SymbolDetailDataSet.LocalizedSymbolNameRow localizedNameRow in this.symbolDetailDataSet.LocalizedSymbolName.Rows)
{
if (localizedNameRow.CultureName == this.cultureName)
{
if (localizedNameRow.IsNameNull() || localizedNameRow.Name.Trim().Length == 0)
{
this.DialogResult = DialogResult.None;
// Initializes the variables to pass to the MessageBox.Show method.
string message = string.Format(Resources.CannotBeEmptyMessage, localizedNameRow.Language);
string caption = Resources.ErrorCaption;
// Displays the MessageBox.
MessageBox.Show(this, message, caption, MessageBoxButtons.OK,
MessageBoxIcon.Error);
return;
}
break;
}
}
SymbolDetailDataSet changes = (SymbolDetailDataSet)symbolDetailDataSet.GetChanges();
if (changes != null)
{
SymbolTableAdapter symbolAdapter = new SymbolTableAdapter();
symbolAdapter.Connection.Open();
symbolAdapter.Update(changes);
SqlCommand sqlUpdateCommand = new SqlCommand();
sqlUpdateCommand.Connection = symbolAdapter.Connection;
sqlUpdateCommand.CommandText = @"UPDATE Resource SET [Text] = @Text "
+ "WHERE (ResourceId = @ResourceId AND CultureId = @CultureId) ";
sqlUpdateCommand.Parameters.Add(new SqlParameter("@Text", System.Data.SqlDbType.NText, 0, "Text"));
sqlUpdateCommand.Parameters.Add(new SqlParameter("@ResourceId", System.Data.SqlDbType.UniqueIdentifier, 0, "ResourceId"));
sqlUpdateCommand.Parameters.Add(new SqlParameter("@CultureId", System.Data.SqlDbType.Int, 0, "CultureId"));
SqlCommand sqlInsertCommand = new SqlCommand();
sqlInsertCommand.Connection = symbolAdapter.Connection;
sqlInsertCommand.CommandText = @"INSERT INTO Resource([Text], ResourceId, CultureId) VALUES(@Text, @ResourceId, @CultureId) ";
sqlInsertCommand.Parameters.Add(new SqlParameter("@Text", System.Data.SqlDbType.NText, 0, "Text"));
sqlInsertCommand.Parameters.Add(new SqlParameter("@ResourceId", System.Data.SqlDbType.UniqueIdentifier, 0, "ResourceId"));
sqlInsertCommand.Parameters.Add(new SqlParameter("@CultureId", System.Data.SqlDbType.Int, 0, "CultureId"));
Guid resourceId = row.Name;
DataRow[] rows = this.symbolDetailDataSet.LocalizedSymbolName.Select("", "", DataViewRowState.ModifiedCurrent);
foreach (DataRow modifiedRow in rows)
{
if (modifiedRow.IsNull("ResourceId"))
{
sqlInsertCommand.Parameters["@Text"].Value = modifiedRow["Name"];
sqlInsertCommand.Parameters["@ResourceId"].Value = resourceId;
sqlInsertCommand.Parameters["@CultureId"].Value = modifiedRow["CultureId"];
sqlInsertCommand.ExecuteNonQuery();
}
else
{
sqlUpdateCommand.Parameters["@Text"].Value = modifiedRow["Name"];
sqlUpdateCommand.Parameters["@ResourceId"].Value = resourceId;
sqlUpdateCommand.Parameters["@CultureId"].Value = modifiedRow["CultureId"];
sqlUpdateCommand.ExecuteNonQuery();
}
}
symbolAdapter.Connection.Close();
}
}
catch (Exception ex)
{
ReportError(ex.Message.ToString());
this.DialogResult = DialogResult.Cancel;
}
}
