private void btnXoa_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
string maDiaDiem = gridView2.GetRowCellValue(gridView2.FocusedRowHandle, "MaSoDiaDiem").ToString();
DiaDiemThamQuan ddtq = data.DiaDiemThamQuans.Where(t => t.MaSoTour == int.Parse(maTour) && t.MaSoDiaDiem == int.Parse(maDiaDiem)).FirstOrDefault();
DialogResult r;
r = MessageBox.Show("Bạn có muốn xóa địa điểm này", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (r == DialogResult.Yes)
{
data.DiaDiemThamQuans.DeleteOnSubmit(ddtq);
data.SubmitChanges();
loadDgvDiaDiemTheoMa(int.Parse(maTour));
}
TrangThaiBanDau();
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
if (trangThai == "them")
{
DiaDiemThamQuan ddtq = new DiaDiemThamQuan();
ddtq.MaSoTour = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString());
ddtq.MaSoDiaDiem = int.Parse(txtMaDiaDiem.Text);
ddtq.TenDiaDiem = txtTenDiaDiem.Text;
ddtq.MoTaDiaDiem = txtMoTaDiaDiem.Text;
try
{
ddtq.HinhAnhDiaDiem = tenAnh;
}
catch { }
data.DiaDiemThamQuans.InsertOnSubmit(ddtq);
data.SubmitChanges();
loadDgvDiaDiemTheoMa(int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString()));
ClearAll();
MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (trangThai == "sua")
{
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
string maDiaDiem = gridView2.GetRowCellValue(gridView2.FocusedRowHandle, "MaSoDiaDiem").ToString();
DiaDiemThamQuan ddtq = data.DiaDiemThamQuans.Where(t => t.MaSoTour == int.Parse(maTour) && t.MaSoDiaDiem == int.Parse(maDiaDiem)).FirstOrDefault();
ddtq.MaSoTour = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString());
ddtq.MaSoDiaDiem = int.Parse(txtMaDiaDiem.Text);
ddtq.TenDiaDiem = txtTenDiaDiem.Text;
ddtq.MoTaDiaDiem = txtMoTaDiaDiem.Text;
try
{
ddtq.HinhAnhDiaDiem = tenAnh;
}
catch { }
data.SubmitChanges();
loadDgvTour();
ClearAll();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
TrangThaiBanDau();
}
}
