private void tnSubmit_Click(object sender, EventArgs e) { for (int i = 0; i < dgvItem.Rows.Count; i++) { ChangedPart cp = new ChangedPart(); cp.EmergencyMaintenanceID = emergencyMaintenance.ID; cp.PartID = (cbPart.SelectedItem as Part).ID; cp.Amount = Convert.ToDouble(dgvItem.Rows[i].Cells["Amount"].Value); db.ChangedParts.Add(cp); } emergencyMaintenance = db.EmergencyMaintenances.Where(x => x.ID == emergencyMaintenance.ID).SingleOrDefault(); emergencyMaintenance.EMTechinicianNote = txtNote.Text; try { if (dpkEndDate.Text != " - -") { DateTime endDate = Convert.ToDateTime(dpkEndDate.Text); } } catch (Exception ex) { MessageBox.Show("End date is invalid"); return; } emergencyMaintenance.EMStartDate = dpkStartDate.Value; if (dpkEndDate.Text != " - -") { emergencyMaintenance.EMEndDate = Convert.ToDateTime(dpkEndDate.Text); } db.SaveChanges(); MessageBox.Show("Submit successfully"); }
private void dgvItem_CellContentClick(object sender, DataGridViewCellEventArgs e) { int col = dgvItem.CurrentCell.ColumnIndex; if (col == 2) //Click remove { if (dgvItem.CurrentRow.Cells["Flag"].Value.ToString() == "1") { dgvItem.Rows.Remove(dgvItem.CurrentRow); } else { int cpid = Convert.ToInt32(dgvItem.CurrentRow.Cells["ID"].Value); ChangedPart cp = db.ChangedParts.Where(x => x.ID == cpid).SingleOrDefault(); if (cp != null) { db.ChangedParts.Remove(cp); } dgvItem.Rows.Remove(dgvItem.CurrentRow); } } }