private void btnUpdate_Click(object sender, EventArgs e)
{
if (Code > -1)
{
NCCPTien nc = cbbSupplier.SelectedItem as NCCPTien;
PhuongTien exited = PhuongTien.Single(Code);
PhuongTien newVehicle = controls_Load();
if (txtName.Text != exited.TenPT)
{
if (PhuongTien.FindByTen_NCC(txtName.Text, nc.ID).Count > 0)
{
MessageBox.Show("This vehicle had been exited!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
btnAdd.Enabled = false;
return;
}
}
int affected = PhuongTien.Update(newVehicle);
if (affected > 0)
{
MessageBox.Show("Updating is sucessful!", "Kim Nguyễn say:", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
this.Close();
}
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 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;
}
}
public IActionResult OnGet(int id)
{
PhuongTien = _PhuongTienService.GetPhuongTien(id);
if (PhuongTien == null)
{
return(NotFound());
}
return(Page());
}
private void itemAdd_ItemClick(object sender, TileItemEventArgs e)
{
Vehiclefrm frm = new Vehiclefrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvVehicles_Load(PhuongTien.All());
}
}
public void UpdatePhuongTien(int id, PhuongTien PhuongTien)
{
var _PhuongTien = _unitOfWork.DanhSachPhuongTien.GetBy(id);
if (_PhuongTien != null)
{
_PhuongTien.CaVet = PhuongTien.CaVet;
_PhuongTien.BKS = PhuongTien.BKS;
}
_unitOfWork.Complete();
}
private void controls_LoadUp()
{
PhuongTien pt = PhuongTien.Single(Code);
txtCode.Text = pt.ID.ToString();
txtName.Text = pt.TenPT;
txtFacitities.Text = pt.TienNghi;
txtMxNbr.Text = pt.SoChoToiDa.ToString();
txtMinNbr.Text = pt.SoChoToiThieu.ToString();
cbbSupplier.SelectedValue = pt.NhaCungCap;
}
private void lvSuppliers_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvSuppliers.SelectedItems.Count > 0)
{
lvVehicles_Load(PhuongTien.FindByMaNCC(MyConvert.ToInt32(lvSuppliers.SelectedItems[0].SubItems[0].Text)));
}
else
{
lvVehicles.Items.Clear();
}
}
private void itemUpdate_ItemClick(object sender, TileItemEventArgs e)
{
if (lvVehicles.SelectedItems.Count > 0)
{
Vehiclefrm frm = new Vehiclefrm();
frm.Code = MyConvert.ToInt32(lvVehicles.SelectedItems[0].SubItems[0].Text);
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvVehicles_Load(PhuongTien.All());
}
}
}
private void updateToolStripMenuItem1_Click_1(object sender, EventArgs e)
{
if (lvTours.SelectedItems.Count > 0 && lvGuide.SelectedItems.Count > 0)
{
Guiderfrm frm = new Guiderfrm();
frm.MaSo = lvGuide.SelectedItems[0].SubItems[0].Text;
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvVehicles_Load(PhuongTien.FindByMTour(MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text)));
}
}
}
private void toolStripMenuItem5_Click(object sender, EventArgs e)
{
vehiclesfrm frm = new vehiclesfrm();
frm.Powers = this.Powers;
frm.ShowDialog();
if (lvTours.SelectedItems.Count > 0)
{
int _MaTour = MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text);
lvVehicles_Load(PhuongTien.FindByMTour(_MaTour));
//lvGuide_Load(HuongDanVien.FindByMTour(_MaTour));
}
}
private void vehiclesfrm_Load(object sender, EventArgs e)
{
if (Powers == PowersLog.Administrator || Powers == PowersLog.Designer)
{
grbManager.Visible = true;
}
else
{
grbManager.Visible = false;
}
lvVehicles_Load(PhuongTien.All());
lblInfo.Text = "";
cbbFields_Load();
}
private void toolStripMenuItem7_Click(object sender, EventArgs e)
{
if (lvTours.SelectedItems.Count > 0 && lvVehicles.SelectedItems.Count > 0)
{
int cod = MyConvert.ToInt32(lvVehicles.SelectedItems[0].SubItems[0].Text);
Vehiclefrm frm = new Vehiclefrm();
frm.Code = cod;
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
lvVehicles_Load(PhuongTien.FindByMTour(MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text)));
}
}
}
private PhuongTien controls_Load()
{
PhuongTien result = new PhuongTien();
result.ID = Code;
result.TenPT = txtName.Text;
result.TienNghi = txtFacitities.Text;
result.SoChoToiDa = MyConvert.ToInt32(txtMxNbr.Text);
result.SoChoToiThieu = MyConvert.ToInt32(txtMinNbr.Text);
NCCPTien nc = (NCCPTien)cbbSupplier.SelectedItem;
result.NhaCungCap = nc.ID;
return(result);
}
private void cbbSupplier_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbSupplier.SelectedIndex > 0)
{
NCCPTien ncc = cbbSupplier.SelectedItem as NCCPTien;
cbbPhuongTien_Load(PhuongTien.FindByMaNCC(ncc.ID));
}
else
{
cbbPhuongTien_Load(PhuongTien.All());
}
cbbVehical.Text = "";
tvVehical.Nodes.Clear();
btnAddDes.Enabled = false;
}
private void tvVehical_Load(PhuongTien pt)
{
tvVehical.Nodes.Clear();
tvVehical.Nodes.Add("Vehical: " + pt.TenPT);
tvVehical.Nodes.Add("Facilities: " + pt.TienNghi);
tvVehical.Nodes.Add("Maximum number of tickets: " + pt.SoChoToiDa);
tvVehical.Nodes.Add("Minimum number of tickets: " + pt.SoChoToiThieu);
tvVehical.Nodes.Add("Supplier: " + pt.TenNCC);
if (tvHotel.Nodes.Count > 0 && tvVehical.Nodes.Count > 0)
{
btnAddDes.Enabled = true;
}
else
{
btnAddDes.Enabled = false;
}
}
public List <PhuongTien> DSPhuongTien()
{
conn.Open();
List <PhuongTien> listPT = new List <PhuongTien>();
String sql = "select * from PhuongTien";
cmd = new SqlCommand(sql, conn);
dr = cmd.ExecuteReader();
while (dr.Read())
{
PhuongTien dm = new PhuongTien();
dm.idphuongtien = int.Parse(dr["idphuongtien"].ToString());
dm.nhansu = dr["nhansu"].ToString();
dm.dungcu = dr["dungcu"].ToString();
dm.vatlieuthietke = dr["vatlieuthietke"].ToString();
listPT.Add(dm);
}
conn.Close();
return(listPT);
}
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 btnSearchTickites_Click(object sender, EventArgs e)
{
if (txtMxNbr.Text == "")
{
txtMxNbr.Focus();
lblInfo.Text = "You must enter a value into Maximum Numbers";
return;
}
if (txtMnNbr.Text == "")
{
txtMnNbr.Focus();
lblInfo.Text = "You must enter a value into Minimum Numbers";
return;
}
if (MyConvert.ToInt32(txtMnNbr.Text) > MyConvert.ToInt32(txtMxNbr.Text))
{
txtMnNbr.Focus();
lblInfo.Text = "The value Minimum is less than the value Maximum!";
return;
}
lvVehicles_Load(PhuongTien.FindBySoChoTD_TT(MyConvert.ToInt32(txtMxNbr.Text), MyConvert.ToInt32(txtMnNbr.Text)));
}
private void textEdit2_EditValueChanged(object sender, EventArgs e)
{
lvVehicles_Load(PhuongTien.FindByTienNghi(textEdit2.Text));
}
public void OnGet(int id)
{
PhuongTien = _PhuongTienService.GetPhuongTien(id);
}
public async Task DeleteAsync(PhuongTien item)
{
await _repository.DeleteAsync(item);
}
private void cbbVehical_SelectedIndexChanged(object sender, EventArgs e)
{
PhuongTien pt = cbbVehical.SelectedItem as PhuongTien;
tvVehical_Load(pt);
}
private void btnAll_Click(object sender, EventArgs e)
{
lvVehicles_Load(PhuongTien.All());
}
private void txtSearchByName_EditValueChanged(object sender, EventArgs e)
{
lvVehicles_Load(PhuongTien.FindByTenPT(txtSearchByName.Text));
}
private void txtSearchKey_EditValueChanged(object sender, EventArgs e)
{
lvVehicles_Load(PhuongTien.FindBy_SearchKey(txtSearchKey.Text));
}
private void cbbFields_Load()
{
object[] s = PhuongTien.ColumnNames();
cbbFields.Items.AddRange(s);
}
private void cbbFields_SelectedIndexChanged(object sender, EventArgs e)
{
lvVehicles_Load(PhuongTien.SearchFields(cbbFields.SelectedItem.ToString(), txtSearchOption.Text));
}
public async Task <int> InsertAsync(PhuongTien item)
{
await _repository.AddAsync(item);
return(item.Id);
}
public async Task UpdateAsync(PhuongTien item)
{
await _repository.UpdateAsync(item);
}
