private void btnRemove_Click(object sender, EventArgs e) { if (cmbExpedition.SelectedIndex == -1) { MessageBox.Show("Ekspedisi harus dipilih"); } else { tblJoin deleteJoin = (from x in de.tblJoins join y in de.tblExpeditions on x.ExpeditionId equals y.ExpeditionId where y.ExpeditionName == cmbExpedition.Text select x).FirstOrDefault(); DialogResult result = MessageBox.Show("Apa Anda yakin ingin delete data?", "Confirmation", MessageBoxButtons.YesNo); if (result == DialogResult.Yes) { de.tblJoins.Remove(deleteJoin); cmbExpedition.SelectedIndex = -1; } else { cmbExpedition.SelectedIndex = -1; return; } de.SaveChanges(); update_data(); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (expedition_Grid.RowCount > 0) { foreach (DataGridViewRow rows in expedition_Grid.Rows) { if (rows.Cells[0].Value.ToString().Equals(cmbExpedition.Text, StringComparison.OrdinalIgnoreCase)) { isNotSame = false; break; } else { isNotSame = true; } } } else if (expedition_Grid.RowCount == 0) { isNotSame = true; } if (cmbExpedition.SelectedIndex == -1) { MessageBox.Show("Anda harus memlih expedisinya"); } else if (!isNotSame) { MessageBox.Show("Ekspedisi yang anda ingin masukan sudah ada dalam database"); } else { //belum validasi bila sudah ada (ekspedisi yg sma) int expeditionId = int.Parse(cmbExpedition.SelectedValue.ToString()); var query = (from x in de.tblShops where x.ShopName == txtShopName.Text select x.ShopId).FirstOrDefault(); tblJoin newJoin = new tblJoin { ShopId = query, ExpeditionId = expeditionId }; de.tblJoins.Add(newJoin); de.SaveChanges(); cmbExpedition.SelectedIndex = -1; mode(false); update_data(); MessageBox.Show("Selesai menambahkan ekspedisi"); } }