private void btnUpdate_Click(object sender, EventArgs e)
{
DiaDiemDL dd = cbbLocal.SelectedItem as DiaDiemDL;
DiemDL exited = DiemDL.Single(Code);
DiemDL newUp = controls_Load();
if (exited.TenDD != newUp.TenDD || exited.MaDD != newUp.MaDD)
{
if (DiemDL.FindByTenD_MaDD(txtName.Text, dd.ID).Count > 0)
{
lblInfo.Text = "This Scenic had been exited!";
txtName.Focus();
return;
}
}
DialogResult dlg = MessageBox.Show("Do you want to Update?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlg == System.Windows.Forms.DialogResult.Yes)
{
if (DiemDL.Update(newUp))
{
MessageBox.Show("Updating is sucessfull!", "Kim Nguyen's Say", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Updating had been failse!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void btnAddDes_Click(object sender, EventArgs e)
{
DiemDL ddl = cbbScenic.SelectedItem as DiemDL;
listScenic.Add(ddl);
cbbScenic.Items.Remove(ddl);
ListViewItem i = lvDestination.Items.Add(ddl.TenDD);
i.SubItems.Add(ddl.TenDiem);
KhachSan ks = cbbHotel.SelectedItem as KhachSan;
i.SubItems.Add(ks.TenKS);
PhuongTien pt = cbbVehical.SelectedItem as PhuongTien;
i.SubItems.Add(pt.TenPT);
i.SubItems.Add(pt.TenNCC);
DiemDen dd = new DiemDen();
dd.MTour = 0;
dd.MDiemDL = ddl.ID;
dd.MaKS = ks.ID;
dd.MaPT = pt.ID;
listDes.Add(dd);
btnAddDes.Enabled = false;
}
private void btnAdd_Click(object sender, EventArgs e)
{
DiaDiemDL dd = cbbLocal.SelectedItem as DiaDiemDL;
if (DiemDL.FindByTenD_MaDD(txtName.Text, dd.ID).Count > 0)
{
lblInfo.Text = "This Scenic had been exited!";
txtName.Focus();
return;
}
DialogResult dlg = MessageBox.Show("Do you want to add this scenic?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlg == System.Windows.Forms.DialogResult.Yes)
{
if (DiemDL.Add(controls_Load()))
{
MessageBox.Show("Adding is successful!", "Kim Nguyen's Say", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Adding had been failse!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
private void lvTrips_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvTrips.SelectedItems.Count > 0)
{
int _Machuyen = MyConvert.ToInt32(lvTrips.SelectedItems[0].SubItems[0].Text);
int _MaTour = 0;
foreach (Chuyen item in listTrip)
{
if (item.MChuyen == _Machuyen)
{
_MaTour = item.MTour;
break;
}
}
lvScenics_Load(DiemDL.FindByMTour(_MaTour));
lvGuide_Load(HuongDanVien.FindByMChuyen(_Machuyen));
lvHotels_Load(KhachSan.FindByMTour(_MaTour));
lvVehicles_Load(PhuongTien.FindByMTour(_MaTour));
lvCustomers_Load(KhachHang.FindByMChuyen(_Machuyen));
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
}
else
{
lvGuide.Items.Clear();
lvHotels.Items.Clear();
lvScenics.Items.Clear();
lvCustomers.Items.Clear();
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
}
}
private void itemAdd_ItemClick(object sender, DevExpress.XtraEditors.TileItemEventArgs e)
{
Scenicfrm frm = new Scenicfrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvScenics_Load(DiemDL.All());
}
}
private void tvScenic_Load(DiemDL _Diem)
{
tvScenic.Nodes.Clear();
TreeNode node = tvScenic.Nodes.Add("Scenic: " + _Diem.TenDiem);
node.Nodes.Add("Code: " + _Diem.ID);
node.Nodes.Add("Local: " + _Diem.TenDD);
node.Nodes.Add("Address: " + _Diem.DiaChi);
node.Expand();
}
private void controls_LoadUp()
{
KhachSan ks = KhachSan.Single(Code);
txtCode.Text = ks.ID.ToString();
txtName.Text = ks.TenKS;
txtStartNumber.Text = ks.SoSao.ToString();
txtPhone.Text = ks.SoDienThoai;
txtAddress.Text = ks.DiaChi;
clbclbright_Load(DiemDL.FindByMaKS(Code));
clbleft_Load(DiemDL.FindByNotMaKS(Code));
}
private void Scenicsfrm_Load(object sender, EventArgs e)
{
grbManager.Visible = false;
if (Powers == PowersLog.Administrator || Powers == PowersLog.Designer)
{
grbManager.Visible = true;
}
lvScenics_Load(DiemDL.All());
//cbbColumn_Load();
}
private void lvLocals_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvLocals.SelectedItems.Count > 0)
{
int mdd = MyConvert.ToInt32(lvLocals.SelectedItems[0].SubItems[0].Text);
lvScenics_Load(DiemDL.FindByMaDD(mdd));
}
else
{
lvScenics.Items.Clear();
}
}
private void aToolStripMenuItem_Click(object sender, EventArgs e)
{
Scenicsfrm frm = new Scenicsfrm();
frm.Powers = this.Powers;
frm.ShowDialog();
if (lvTours.SelectedItems.Count > 0)
{
int _MaTour = MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text);
lvScenics_Load(DiemDL.FindByMTour(_MaTour));
}
}
private DiemDL controls_Load()
{
DiemDL result = new DiemDL();
result.ID = Code;
result.TenDiem = txtName.Text;
result.DiaChi = txtAddress.Text;
DiaDiemDL dd = cbbLocal.SelectedItem as DiaDiemDL;
result.MaDD = dd.ID;
return(result);
}
private void lvHotels_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvHotels.SelectedItems.Count > 0)
{
lvScenics_Load(DiemDL.FindByMaKS(MyConvert.ToInt32(lvHotels.SelectedItems[0].SubItems[0].Text)));
lvTours_Load(Tour.FindByMKSan(MyConvert.ToInt32(lvHotels.SelectedItems[0].SubItems[0].Text)));
}
else
{
lvTours.Items.Clear();
lvScenics.Items.Clear();
}
}
private void itemUpdate_ItemClick(object sender, DevExpress.XtraEditors.TileItemEventArgs e)
{
if (lvScenics.SelectedItems.Count > 0)
{
Scenicfrm frm = new Scenicfrm();
frm.Code = MyConvert.ToInt32(lvScenics.SelectedItems[0].SubItems[0].Text);
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvScenics_Load(DiemDL.All());
}
}
}
private void updateToolStripMenuItem_Click(object sender, EventArgs e)
{
if (lvTours.SelectedItems.Count > 0 && lvScenics.SelectedItems.Count > 0)
{
int cod = MyConvert.ToInt32(lvScenics.SelectedItems[0].SubItems[0].Text);
Scenicfrm frm = new Scenicfrm();
frm.Code = cod;
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvScenics_Load(DiemDL.FindByMTour(MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text)));
}
}
}
private void Hotelfrm_Load(object sender, EventArgs e)
{
if (Code == 0)
{
btnUpdate.Visible = false;
clbleft_Load(DiemDL.All());
}
else
{
btnAdd.Visible = false;
btnRightGoTo.Visible = false;
controls_LoadUp();
}
}
private void cbbLocal_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbLocal.SelectedIndex > 0)
{
DiaDiemDL dd = cbbLocal.SelectedItem as DiaDiemDL;
cbbScenic_Load(DiemDL.FindByMaDD(dd.ID));
}
else
{
cbbScenic_Load(DiemDL.All());
}
tvScenic.Nodes.Clear();
btnAddDes.Enabled = false;
cbbScenic.Text = "";
}
private void cbbScenic_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbScenic.SelectedIndex >= 0)
{
DiemDL dl = cbbScenic.SelectedItem as DiemDL;
cbbHotel_Load(KhachSan.FindMDiemDL(dl.ID));
tvScenic_Load(dl);
}
else
{
cbbHotel.Items.Clear();
}
cbbHotel.Text = "";
tvHotel.Nodes.Clear();
btnAddDes.Enabled = false;
}
private void Controls_LoadUp()
{
Tour t = Tour.Single(_ID);
txtCode.Text = t.ID.ToString();
txtName.Text = t.TenTour;
txtStartPlace.Text = t.XuatPhat;
int i = 0;
foreach (var item in cbbStatus.Items)
{
if (item.ToString() == t.TrangThai)
{
cbbStatus.SelectedIndex = i;
break;
}
i++;
}
btnAddTour.Enabled = false;
btnUpdateTour.Enabled = true;
//btnDeleteTour.Enabled = true;
//
listScenic = new List <DiemDL>();
listDes = DiemDen.FindByMTour(ID);
lvDestination.Items.Clear();
foreach (DiemDen j in listDes)
{
ListViewItem item = lvDestination.Items.Add(j.TenDD);
item.SubItems.Add(j.TenDiem);
item.SubItems.Add(j.TenKS);
item.SubItems.Add(j.TenPT);
item.SubItems.Add(j.TenNCC);
listScenic.Add(DiemDL.Single(j.MDiemDL));
}
cbbLocal_Load(DiaDiemDL.All());
cbbLocal.SelectedIndex = 0;
cbbHotel.Items.Clear();
cbbHotel.Text = "";
tvHotel.Nodes.Clear();
}
private void controls_LoadUp()
{
DiemDL result = DiemDL.Single(Code);
txtCode.Text = result.ID.ToString();
txtName.Text = result.TenDiem;
txtAddress.Text = result.DiaChi;
int i = 0;
foreach (var item in cbbLocal.Items)
{
DiaDiemDL d = cbbLocal.Items[i] as DiaDiemDL;
if (d.ID == result.MaDD)
{
break;
}
i++;
}
cbbLocal.SelectedIndex = i;
}
private void lvTours_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvTours.SelectedItems.Count > 0)
{
int _MaTour = MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text);
lvScenics_Load(DiemDL.FindByMTour(_MaTour));
lvHotels_Load(KhachSan.FindByMTour(_MaTour));
lvVehicles_Load(PhuongTien.FindByMTour(_MaTour));
lvGuide_Load(HuongDanVien.FindByMTour(_MaTour));
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
}
else
{
lvGuide.Items.Clear();
lvHotels.Items.Clear();
lvScenics.Items.Clear();
lvVehicles.Items.Clear();
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
}
}
private void cbbColumn_SelectedIndexChanged(object sender, EventArgs e)
{
lvScenics_Load(DiemDL.SearchFields(cbbColumn.SelectedItem.ToString(), txtValueField.Text));
}
private void cbbColumn_Load()
{
object[] s = DiemDL.ColumnNames();
cbbColumn.Items.AddRange(s);
}
private void btnAll_Click(object sender, EventArgs e)
{
lvScenics_Load(DiemDL.All());
}
private void txtSearchKey_EditValueChanged(object sender, EventArgs e)
{
lvScenics_Load(DiemDL.SearchKey(txtSearchKey.Text));
}
