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 btnUpdate_Click(object sender, EventArgs e)
{
if (txtName.Text == "")
{
lblInfo.Text = "You musht enter Local Name!";
lblInfo.Focus();
return;
}
DiaDiemDL exited = DiaDiemDL.Single(Code);
DiaDiemDL newLocal = controls_Load();
if (exited.QuocGia != newLocal.QuocGia || exited.TenDD != newLocal.TenDD)
{
if (DiaDiemDL.FindByTenDD_QuocGia(txtName.Text, cbbCountry.SelectedItem.ToString()).Count > 0)
{
MessageBox.Show("This local had been exited!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
}
if (DiaDiemDL.Update(newLocal))
{
MessageBox.Show("Updating successful!", "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 cbbLocal_Load()
{
cbbLocal.DataSource = DiaDiemDL.All();
cbbLocal.DisplayMember = "TenDD";
cbbLocal.ValueMember = "ID";
cbbLocal.SelectedIndex = 0;
}
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 controls_LoadUp()
{
DiaDiemDL result = DiaDiemDL.Single(Code);
txtCode.Text = result.ID.ToString();
txtName.Text = result.TenDD;
cbbCountry.Text = result.QuocGia;
}
private DiaDiemDL controls_Load()
{
DiaDiemDL result = new DiaDiemDL();
result.ID = Code;
result.TenDD = txtName.Text;
result.QuocGia = cbbCountry.SelectedItem.ToString();
return(result);
}
private void btnNewLocal_Click(object sender, EventArgs e)
{
Localfrm frm = new Localfrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
cbbLocal_Load(DiaDiemDL.All());
}
}
private void Localsfrm_Load(object sender, EventArgs e)
{
grbManager.Visible = false;
if (Powers == PowersLog.Administrator || Powers == PowersLog.Designer)
{
grbManager.Visible = true;
}
cbbColumn_Load();
lvLocals_Load(DiaDiemDL.All());
}
private void itemAdd_ItemClick(object sender, DevExpress.XtraEditors.TileItemEventArgs e)
{
Localfrm frm = new Localfrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvLocals_Load(DiaDiemDL.All());
cbbCounty.DataSource = DiaDiemDL.AllCountries();
}
}
private void bntNewScenic_Click(object sender, EventArgs e)
{
Scenicfrm frm = new Scenicfrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
int i = cbbLocal.SelectedIndex;
cbbLocal_Load(DiaDiemDL.All());
cbbLocal.SelectedIndex = i;
}
}
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 itemUpdate_ItemClick(object sender, DevExpress.XtraEditors.TileItemEventArgs e)
{
if (lvLocals.SelectedItems.Count > 0)
{
Localfrm frm = new Localfrm();
frm.Code = MyConvert.ToInt32(lvLocals.SelectedItems[0].SubItems[0].Text);
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvLocals_Load(DiaDiemDL.All());
cbbCounty.DataSource = DiaDiemDL.AllCountries();
}
}
}
private void Tourfrm_Load(object sender, EventArgs e)
{
tvtours_Load(Tour.All());
listDes = new List <DiemDen>();
listScenic = new List <DiemDL>();
cbbLocal_Load(DiaDiemDL.All());
cbbSupplier_Load(NCCPTien.All());
cbbStatus.SelectedIndex = 0;
if (_ID != 0)
{
btnUpdateTour.Enabled = true;
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 btnAdd_Click(object sender, EventArgs e)
{
if (DiaDiemDL.FindByTenDD_QuocGia(txtName.Text, cbbCountry.SelectedItem.ToString()).Count > 0)
{
MessageBox.Show("This local had been exited!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (DiaDiemDL.Add(controls_Load()))
{
MessageBox.Show("Adding successful!", "Kim Nguyen's Say", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Thêm không thành công!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
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 btnAll_Click(object sender, EventArgs e)
{
lvLocals_Load(DiaDiemDL.All());
}
private void txtSearchKey_EditValueChanged(object sender, EventArgs e)
{
lvLocals_Load(DiaDiemDL.SearchKey(txtSearchKey.Text));
}
private void cbbCounty_SelectedIndexChanged(object sender, EventArgs e)
{
DiaDiemDL dd = cbbCounty.SelectedItem as DiaDiemDL;
lvLocals_Load(DiaDiemDL.FindByContry(dd.QuocGia));
}
private void cbbColumn_Load()
{
object[] s = DiaDiemDL.ColumnNames();
cbbColumn.Items.AddRange(s);
cbbCountry_Load();
}
private void cbbCountry_Load()
{
cbbCounty.DataSource = DiaDiemDL.AllCountries();
cbbCounty.DisplayMember = "QuocGia";
cbbCounty.ValueMember = "QuocGia";
}
private void cbbColumn_SelectedIndexChanged(object sender, EventArgs e)
{
lvLocals_Load(DiaDiemDL.SearchFields(cbbColumn.SelectedItem.ToString(), txtValueField.Text));
}
