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");
}
}
