private void button_save_ass_tipologie_ore_Click(object sender, EventArgs e)
{
Utility.formatDataGrid(dbDataGridView_tipo_ore_ass, true);
manTipOreAZIBindingSource.EndEdit();
using (TransactionScope scp = new TransactionScope())
{
foreach (DataSet.dsMaintenance.Man_Tip_Ore_AZIRow r in dsMaintenance.Man_Tip_Ore_AZI.GetChanges().Rows)
{
if (r.RowState == DataRowState.Added)
{
if (r.IsStatoRecKeyNull())
{
r.StatoRecKey = 1;
}
DataRowView drv = dbDataGridView_AZI.CurrentCell.OwningRow.DataBoundItem as DataRowView;
DataSet.dsMaintenance.Man_Ana_AZIRow r_azi = drv.Row as DataSet.dsMaintenance.Man_Ana_AZIRow;
r.AZIKey = r_azi.AZIKey;
}
man_Ana_AZI_REPTableAdapter.Update(r);
}
scp.Complete();
}
Init_Tip_Ore_AZI();
}
private void dbDataGridView_AZI_REP_UserAddedRow(object sender, DataGridViewRowEventArgs e)
{
DataRowView drv_azi = dbDataGridView_AZI.CurrentCell.OwningRow.DataBoundItem as DataRowView;
DataSet.dsMaintenance.Man_Ana_AZIRow r_azi = drv_azi.Row as DataSet.dsMaintenance.Man_Ana_AZIRow;
DataRowView drv_azi_rep = dbDataGridView_AZI_REP.CurrentCell.OwningRow.DataBoundItem as DataRowView;
DataSet.dsMaintenance.Man_Ana_AZI_REPRow r = drv_azi_rep.Row as DataSet.dsMaintenance.Man_Ana_AZI_REPRow;
r.AZIKey = r_azi.AZIKey;
}
private void Init_Tip_Ore_AZI()
{
if (dbDataGridView_AZI.SelectedRows.Count > 0)
{
DataRowView drv = dbDataGridView_AZI.CurrentCell.OwningRow.DataBoundItem as DataRowView;
if (drv != null)
{
DataSet.dsMaintenance.Man_Ana_AZIRow r_azi = drv.Row as DataSet.dsMaintenance.Man_Ana_AZIRow;
man_Tip_Ore_AZITableAdapter.Fill(dsMaintenance.Man_Tip_Ore_AZI, r_azi.AZIKey);
}
}
Utility.formatDataGrid(dbDataGridView_tipo_ore_ass, true);
}
private void button_associa_Click(object sender, EventArgs e)
{
try
{
//Utility.formatDataGrid(dbDataGridView_tipo_ore_ass, true);
manTipOreAZIBindingSource.EndEdit();
DataRowView drv_tip = dbDataGridView_tipo_ore.CurrentCell.OwningRow.DataBoundItem as DataRowView;
DataSet.dsMaintenance.Man_Ana_Tip_OraRow r_tip = drv_tip.Row as DataSet.dsMaintenance.Man_Ana_Tip_OraRow;
DataRowView drv = dbDataGridView_AZI.CurrentCell.OwningRow.DataBoundItem as DataRowView;
DataSet.dsMaintenance.Man_Ana_AZIRow r_azi = drv.Row as DataSet.dsMaintenance.Man_Ana_AZIRow;
man_Tip_Ore_AZITableAdapter.InsertRelationship(r_tip.TipOreKey, r_azi.AZIKey);
Init_Tip_Ore_AZI();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
