private void dgvGriglia_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { if (e.Row.Cells[(int)colonne.IDGALVAPIANO].Value != DBNull.Value) { using (GalvanicaBusiness bGalvanica = new GalvanicaBusiness()) { decimal idgalvapiano = (decimal)e.Row.Cells[(int)colonne.IDGALVAPIANO].Value; GalvanicaDS.AP_GALVANICA_PIANORow daEliminare = _ds.AP_GALVANICA_PIANO.Where(x => x.IDGALVAPIANO == idgalvapiano).FirstOrDefault(); if (daEliminare != null) { daEliminare.Delete(); } bGalvanica.UpdateTable(_ds.AP_GALVANICA_PIANO.TableName, _ds); _ds.AP_GALVANICA_PIANO.AcceptChanges(); } } }
private void SalvaRigaAp_galva_piano(DataGridViewRow riga) { if (riga.Cells[(int)colonne.PIANIFICATO].Value == DBNull.Value) { return; } using (GalvanicaBusiness bGalvanica = new GalvanicaBusiness()) { decimal IDGALVAPIANO; if (riga.Cells[(int)colonne.IDGALVAPIANO].Value == DBNull.Value) { IDGALVAPIANO = bGalvanica.GetID(); riga.Cells[(int)colonne.IDGALVAPIANO].Value = IDGALVAPIANO; } else { IDGALVAPIANO = (decimal)riga.Cells[(int)colonne.IDGALVAPIANO].Value; } GalvanicaDS.AP_GALVANICA_PIANORow rigaPiano = _ds.AP_GALVANICA_PIANO.Where(x => x.IDGALVAPIANO == IDGALVAPIANO).FirstOrDefault(); if (rigaPiano == null) { rigaPiano = _ds.AP_GALVANICA_PIANO.NewAP_GALVANICA_PIANORow(); rigaPiano.IDGALVAPIANO = IDGALVAPIANO; rigaPiano.IDMAGAZZ = (string)riga.Cells[(int)colonne.IDMAGAZZ_LANCIO].Value; rigaPiano.IDMAGAZZ_WIP = (string)riga.Cells[(int)colonne.IDMAGAZZ_WIP].Value; rigaPiano.MODELLO = (string)riga.Cells[(int)colonne.MODELLO_LANCIO].Value; rigaPiano.COMPONENTE = (string)riga.Cells[(int)colonne.MODELLO_WIP].Value; if (riga.Cells[(int)colonne.BRAND].Value != DBNull.Value) { rigaPiano.BRAND = (string)riga.Cells[(int)colonne.BRAND].Value; } if (riga.Cells[(int)colonne.FINITURA].Value != DBNull.Value) { rigaPiano.FINITURA = (string)riga.Cells[(int)colonne.FINITURA].Value; } if (riga.Cells[(int)colonne.MATERIALE].Value != DBNull.Value) { rigaPiano.MATERIALE = (string)riga.Cells[(int)colonne.MATERIALE].Value; } if (riga.Cells[(int)colonne.PEZZIBARRA].Value != DBNull.Value) { rigaPiano.PEZZIBARRA = (decimal)riga.Cells[(int)colonne.PEZZIBARRA].Value; } if (riga.Cells[(int)colonne.SUPERFICIE].Value != DBNull.Value) { rigaPiano.SUPERFICIE = (string)riga.Cells[(int)colonne.SUPERFICIE].Value; } if (riga.Cells[(int)colonne.ORDINE].Value != DBNull.Value) { rigaPiano.ORDINE = (decimal)riga.Cells[(int)colonne.ORDINE].Value; } if (riga.Cells[(int)colonne.GALVANICA].Value != DBNull.Value) { rigaPiano.GALVANICA = (string)riga.Cells[(int)colonne.GALVANICA].Value; } if (riga.Cells[(int)colonne.PIANIFICATO].Value != DBNull.Value) { rigaPiano.PIANIFICATO = (decimal)riga.Cells[(int)colonne.PIANIFICATO].Value; } if (riga.Cells[(int)colonne.BARRE].Value != DBNull.Value) { rigaPiano.BARRE = (decimal)riga.Cells[(int)colonne.BARRE].Value; } if (riga.Cells[(int)colonne.REPARTO].Value != DBNull.Value) { rigaPiano.REPARTO = (string)riga.Cells[(int)colonne.REPARTO].Value; } rigaPiano.DATAGALVANICA = DateTime.Today; _ds.AP_GALVANICA_PIANO.AddAP_GALVANICA_PIANORow(rigaPiano); } else { if (riga.Cells[(int)colonne.BRAND].Value != DBNull.Value) { rigaPiano.BRAND = (string)riga.Cells[(int)colonne.BRAND].Value; } if (riga.Cells[(int)colonne.FINITURA].Value != DBNull.Value) { rigaPiano.FINITURA = (string)riga.Cells[(int)colonne.FINITURA].Value; } if (riga.Cells[(int)colonne.MATERIALE].Value != DBNull.Value) { rigaPiano.MATERIALE = (string)riga.Cells[(int)colonne.MATERIALE].Value; } if (riga.Cells[(int)colonne.PEZZIBARRA].Value != DBNull.Value) { rigaPiano.PEZZIBARRA = (decimal)riga.Cells[(int)colonne.PEZZIBARRA].Value; } if (riga.Cells[(int)colonne.SUPERFICIE].Value != DBNull.Value) { rigaPiano.SUPERFICIE = (string)riga.Cells[(int)colonne.SUPERFICIE].Value; } if (riga.Cells[(int)colonne.ORDINE].Value != DBNull.Value) { rigaPiano.ORDINE = (decimal)riga.Cells[(int)colonne.ORDINE].Value; } if (riga.Cells[(int)colonne.GALVANICA].Value != DBNull.Value) { rigaPiano.GALVANICA = (string)riga.Cells[(int)colonne.GALVANICA].Value; } if (riga.Cells[(int)colonne.PIANIFICATO].Value != DBNull.Value) { rigaPiano.PIANIFICATO = (decimal)riga.Cells[(int)colonne.PIANIFICATO].Value; } if (riga.Cells[(int)colonne.BARRE].Value != DBNull.Value) { rigaPiano.BARRE = (decimal)riga.Cells[(int)colonne.BARRE].Value; } } bGalvanica.UpdateTable(_ds.AP_GALVANICA_PIANO.TableName, _ds); } _ds.AP_GALVANICA_PIANO.AcceptChanges(); }