private void button_save_ca_Click(object sender, EventArgs e) { Utility.formatDataGrid(dbDataGridView_CA, true); manAnaCDCBindingSource.EndEdit(); using (TransactionScope scp = new TransactionScope()) { if (dsMaintenance.Man_Ana_CDC.GetChanges() != null) { foreach (DataSet.dsMaintenance.Man_Ana_CDCRow r in dsMaintenance.Man_Ana_CDC.GetChanges().Rows) { try { if (r.RowState == DataRowState.Added) { r.TranslationUID = Guid.NewGuid().ToString(); translations.Insert(1, r.TranslationUID, r.CDCName); if (r.IsStatoRecKeyNull()) { r.StatoRecKey = 1; } if (r.IsSchedaKeyNull()) { DataRowView drv = dbDataGridView_scheda.CurrentCell.OwningRow.DataBoundItem as DataRowView; DataSet.dsMaintenance.Man_Ana_SCHEDARow rimp = drv.Row as DataSet.dsMaintenance.Man_Ana_SCHEDARow; r.SchedaKey = rimp.SCHEDAKey; } } else if (r.RowState == DataRowState.Modified) { translations.UpdateDefaultTranslation(r.CDCName, r.TranslationUID); } man_Ana_CDCTableAdapter.Update(r); } catch (Exception ex) { MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } else { MessageBox.Show("Nessun record da salvare!!!"); } scp.Complete(); } InitCA(); }
private void delete_toolStrip_SCHEDA_MenuItem_Click(object sender, EventArgs e) { if (MessageBox.Show( Properties.MessageLocalization.man_plant_delete_scheda, Properties.MessageLocalization.man_plant_confirm, MessageBoxButtons.YesNo) == DialogResult.Yes) { if (dbDataGridView_scheda.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_scheda.SelectedRows[0].DataBoundItem as DataRowView; DataSet.dsMaintenance.Man_Ana_SCHEDARow row = drv.Row as DataSet.dsMaintenance.Man_Ana_SCHEDARow; man_Ana_SCHEDATableAdapter.Delete_SCHEDA(row.SCHEDAKey); } InitSCHEDA(); } }
private void InitCA() { Utility.formatDataGrid(dbDataGridView_CA, true); dsMaintenance.Man_Ana_MAC.Clear(); 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_scheda.SelectedRows.Count > 0) { DataRowView drv = dbDataGridView_scheda.CurrentCell.OwningRow.DataBoundItem as DataRowView; if (drv != null) { DataSet.dsMaintenance.Man_Ana_SCHEDARow r = drv.Row as DataSet.dsMaintenance.Man_Ana_SCHEDARow; man_Ana_CDCTableAdapter.Fill(dsMaintenance.Man_Ana_CDC, r.SCHEDAKey); } } }