private void cancellaRecordSelezionatiToolStripMenuItem1_Click(object sender, EventArgs e)
{
try
{
int EventKey = 0;
using (TransactionScope scp = new TransactionScope())
{
foreach (DataGridViewRow r in dbDataGridView_righe.SelectedRows)
{
DataSet.dsEvents.EventiRigheRow row = (r.DataBoundItem as DataRowView).Row as DataSet.dsEvents.EventiRigheRow;
EventKey = row.EventKey;
eventiRigheTableAdapter.DeleteQuery(row.EventRowKey);
}
scp.Complete();
}
if (EventKey != 0)
{
RefreshDatagridRighe(EventKey);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
private void button_modifica_righe_Click(object sender, EventArgs e)
{
if (dbDataGridView_righe.SelectedRows.Count > 0)
{
DataRowView drv = dbDataGridView_righe.SelectedRows[0].DataBoundItem as DataRowView;
if (drv != null)
{
try
{
DataSet.dsEvents.EventiRigheRow row = drv.Row as DataSet.dsEvents.EventiRigheRow;
eventiRigheTableAdapter.UpdateQuery(
(int)ctrlPlantSelector.SelectedImpianto(),
(int)ctrlPlantSelector.SelectedMacchina(),
ctrlPlantSelector.SelectedComponente(),
ctrlPlantSelector.SelectedSCM_1(),
ctrlPlantSelector.SelectedSCM_2(),
ctrlPlantSelector.SelectedSCM_3(),
int.Parse(textBox_driver.Text),
row.EventRowKey);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
}
}
private void RefreshDatagridRighe(int EventKey)
{
eventiRigheTableAdapter.Fill(dsEvents.EventiRighe, EventKey, Program.language_);
textBox_remaining.Text = string.Empty;
int count = 0;
for (int i = 0; i < dbDataGridView_righe.Rows.Count; i++)
{
DataRowView drv = dbDataGridView_righe.Rows[i].DataBoundItem as DataRowView;
DataSet.dsEvents.EventiRigheRow row = drv.Row as DataSet.dsEvents.EventiRigheRow;
count += row.DriverPerc;
}
textBox_remaining.Text = (100 - count).ToString();
}
private void dbDataGridView_righe_SelectionChanged(object sender, EventArgs e)
{
if (dbDataGridView_righe.SelectedRows.Count > 0)
{
DataRowView drv = dbDataGridView_righe.SelectedRows[0].DataBoundItem as DataRowView;
if (drv != null)
{
DataSet.dsEvents.EventiRigheRow row = drv.Row as DataSet.dsEvents.EventiRigheRow;
textBox_driver.Text = row.DriverPerc.ToString();
int?null_value = null;
ctrlPlantSelector.PerformSelection(
row.IMPKey,
row.MACKey,
row.IsCOMKeyNull() ? null_value : row.COMKey,
row.IsSCM_1KeyNull() ? null_value : row.SCM_1Key,
row.IsSCM_2KeyNull() ? null_value : row.SCM_2Key,
row.IsSCM_3KeyNull() ? null_value : row.SCM_3Key);
}
}
}
