private void button_save_mac_Click(object sender, EventArgs e) { Utility.formatDataGrid(dbDataGridView_mac, true); manAnaMACBindingSource.EndEdit(); using (TransactionScope scp = new TransactionScope()) { if (dsMaintenance.Man_Ana_MAC.GetChanges() != null) { foreach (DataSet.dsMaintenance.Man_Ana_MACRow r in dsMaintenance.Man_Ana_MAC.GetChanges().Rows) { try { if (r.RowState == DataRowState.Added) { r.TranslationUID = Guid.NewGuid().ToString(); translations.Insert(1, r.TranslationUID, r.MACName); if (r.IsStatoRecKeyNull()) { r.StatoRecKey = 1; } if (r.IsCDCKeyNull()) { DataRowView drv = dbDataGridView_CA.CurrentCell.OwningRow.DataBoundItem as DataRowView; DataSet.dsMaintenance.Man_Ana_CDCRow rimp = drv.Row as DataSet.dsMaintenance.Man_Ana_CDCRow; r.CDCKey = rimp.CDCKey; } } else if (r.RowState == DataRowState.Modified) { translations.UpdateDefaultTranslation(r.MACName, r.TranslationUID); } man_Ana_MACTableAdapter.Update(r); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("Nessun record da salvare!!!"); } scp.Complete(); } InitMAC(); }
private void delete_CA_Click(object sender, EventArgs e) { if (MessageBox.Show( Properties.MessageLocalization.man_plant_delete_CA, Properties.MessageLocalization.man_plant_confirm, MessageBoxButtons.YesNo) == DialogResult.Yes) { if (dbDataGridView_CA.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_CA.SelectedRows[0].DataBoundItem as DataRowView; DataSet.dsMaintenance.Man_Ana_CDCRow row = drv.Row as DataSet.dsMaintenance.Man_Ana_CDCRow; man_Ana_CDCTableAdapter.Delete_CDC(row.CDCKey); } InitCA(); } }
private void InitMAC() { Utility.formatDataGrid(dbDataGridView_mac, true); dsMaintenance.Man_Ana_COM.Clear(); dsMaintenance.Man_Ana_SCM_1.Clear(); dsMaintenance.Man_Ana_SCM_2.Clear(); dsMaintenance.Man_Ana_SCM_3.Clear(); if (dbDataGridView_CA.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_CA.CurrentCell.OwningRow.DataBoundItem as DataRowView; if (drv != null) { DataSet.dsMaintenance.Man_Ana_CDCRow r = drv.Row as DataSet.dsMaintenance.Man_Ana_CDCRow; man_Ana_MACTableAdapter.Fill(dsMaintenance.Man_Ana_MAC, r.CDCKey); } } }