private void LoadData() { LoaiTourBUS loaiTourBus = new LoaiTourBUS(); cbo_LoaiTour.DisplayMember = "TenLoaiTour"; cbo_LoaiTour.ValueMember = "MaLoaiTour"; cbo_LoaiTour.DataSource = loaiTourBus.LoadLoaiTourToCombobox(); DiaDiemBUS diaDiemBus = new DiaDiemBUS(); DataTable table = diaDiemBus.LoadDiaDiem(); cbo_NoiDen.DisplayMember = "TenDiaDiem"; cbo_NoiDen.ValueMember = "MaDiaDiem"; cbo_NoiDen.DataSource = table; cbo_NoiDi.DisplayMember = "TenDiaDiem"; cbo_NoiDi.ValueMember = "MaDiaDiem"; cbo_NoiDi.DataSource = diaDiemBus.LoadDiaDiem(); HuongDanVienBUS huongDanVienBus = new HuongDanVienBUS(); cbo_HuongDanVien.ValueMember = "MaHDV"; cbo_HuongDanVien.DisplayMember = "TenHDV"; cbo_HuongDanVien.DataSource = huongDanVienBus.LoadHuongDanVienToCombobox(); KhachSanBUS khachSanBus = new KhachSanBUS(); cbo_KhachSan.DisplayMember = "TenKS"; cbo_KhachSan.ValueMember = "MaKS"; cbo_KhachSan.DataSource = khachSanBus.LoadKhachSan(); TourBUS tourBus = new TourBUS(); gridControl_Tour.DataSource = tourBus.LoadTourToDataGridView(); }
public static List <DiaDiemBUS> getDiaDiemByTour(TourBUS tour) { List <DiaDiemBUS> dsDiaDiem = new List <DiaDiemBUS>(); String query = "select * from DiaDiem d,ChiTietTour c where d.maDiaDiem=c.maDiaDiem and c.maTour=@tour"; Connection connection = new Connection(); using (SqlCommand command = new SqlCommand(query, connection.getConnection())) { connection.open(); command.Parameters.AddWithValue("@tour", tour.MaTour); var reader = command.ExecuteReader(); while (reader.Read()) { DiaDiemBUS diadiem = new DiaDiemBUS(); diadiem.MaDiaDiem = reader["maDiaDiem"].ToString(); diadiem.TenDiaDiem = reader["tenDiaDiem"].ToString(); diadiem.Diaphuong = reader["diaphuong"].ToString(); dsDiaDiem.Add(diadiem); } reader.Close(); connection.close(); } return(dsDiaDiem); }
public static List <DiaDiemBUS> getAll() { List <DiaDiemBUS> dsDiaDiem = new List <DiaDiemBUS>(); String query = "select * from DiaDiem"; Connection connection = new Connection(); using (SqlCommand command = new SqlCommand(query, connection.getConnection())) { connection.open(); var reader = command.ExecuteReader(); while (reader.Read()) { DiaDiemBUS diadiem = new DiaDiemBUS(); diadiem.MaDiaDiem = reader["maDiaDiem"].ToString(); diadiem.TenDiaDiem = reader["tenDiaDiem"].ToString(); diadiem.Diaphuong = reader["diaphuong"].ToString(); dsDiaDiem.Add(diadiem); } reader.Close(); connection.close(); } return(dsDiaDiem); }
public static void XoaTrongTour(DiaDiemBUS diadiem, TourBUS tour) { String query = "delete ChiTietTour where maDiaDiem=@madiadiem and maTour=@matour"; Connection connection = new Connection(); using (SqlCommand command = new SqlCommand(query, connection.getConnection())) { connection.open(); command.Parameters.AddWithValue("@matour", tour.MaTour); command.Parameters.AddWithValue("@madiadiem", diadiem.MaDiaDiem); command.ExecuteNonQuery(); connection.close(); } }
public static void ThemVaoTour(DiaDiemBUS diadiem, TourBUS tour) { String query = "insert into ChiTietTour (maTour,maDiaDiem) values (@matour,@madiadiem)"; Connection connection = new Connection(); using (SqlCommand command = new SqlCommand(query, connection.getConnection())) { connection.open(); command.Parameters.AddWithValue("@matour", tour.MaTour); command.Parameters.AddWithValue("@madiadiem", diadiem.MaDiaDiem); command.ExecuteNonQuery(); connection.close(); } }
private void Save_Click(object sender, EventArgs e) { if (TestInput() == true) { TourBUS tour = new TourBUS(); TourDTO t = new TourDTO(); foreach (ListViewItem item in listView_dstour.Items) { if (item.Selected) { t.MaTour = int.Parse(item.SubItems[0].Text); t.TenTour = textBox_tentour.Text; t.ThongTinTour = textBox_thongtintour.Text; string str = textBox_giatour.Text; if (str.Contains("₫")) { while (str.IndexOf("₫") != -1) { str = str.Remove(str.IndexOf("₫"), 1); } } if (str.Contains(" ")) { while (str.IndexOf(" ") != -1) { str = str.Remove(str.IndexOf(" "), 1); } } if (str.Contains(".")) { while (str.IndexOf(".") != -1) { str = str.Remove(str.IndexOf("."), 1); } } Regex regex = new Regex(@"^\d+$"); if (!regex.IsMatch(str)) { MessageBox.Show("Thêm thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { t.GiaTour = int.Parse(str); if (tour.suaTour(t) == 1) { MessageBox.Show("Lưu thành công!", "Thông báo"); ChiTietTourBUS ctt = new ChiTietTourBUS(); ctt.xoaChiTiet(int.Parse(item.SubItems[0].Text)); foreach (ListViewItem item1 in listView_dd.Items) { DiaDiemBUS dd = new DiaDiemBUS(); int ma = dd.search_madd(item1.SubItems[0].Text); ChiTietTourDTO ct = new ChiTietTourDTO(); ct.MaTour = int.Parse(item.SubItems[0].Text); ct.MaDiaDiem = ma; ChiTietTourBUS chitiet = new ChiTietTourBUS(); chitiet.themChiTiet(ct); } item.SubItems[1].Text = textBox_tentour.Text; item.SubItems[2].Text = textBox_thongtintour.Text; item.SubItems[3].Text = textBox_giatour.Text; } else { MessageBox.Show("Thêm thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); Dispose(); } } } } } }
private void Add1_Click(object sender, EventArgs e) { if (TestInput() == true) { TourDTO t = new TourDTO(); t.TenTour = textBox_tentour.Text; t.ThongTinTour = textBox_thongtintour.Text; string str = textBox_giatour.Text; if (str.Contains("₫")) { while (str.IndexOf("₫") != -1) { str = str.Remove(str.IndexOf("₫"), 1); } } if (str.Contains(" ")) { while (str.IndexOf(" ") != -1) { str = str.Remove(str.IndexOf(" "), 1); } } if (str.Contains(".")) { while (str.IndexOf(".") != -1) { str = str.Remove(str.IndexOf("."), 1); } } Regex regex = new Regex(@"^\d+$"); if (!regex.IsMatch(str)) { MessageBox.Show("Thêm thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { t.GiaTour = int.Parse(str); TourBUS tour = new TourBUS(); int kq = tour.themTour(t); if (kq != 0) { MessageBox.Show("Thêm thành công!", "Thông báo"); ListViewItem item = new ListViewItem(new String[] { textBox_matour.Text = kq.ToString(), textBox_tentour.Text, textBox_thongtintour.Text, textBox_giatour.Text }); this.listView_dstour.Items.AddRange(new ListViewItem[] { item }); foreach (ListViewItem item1 in listView_dd.Items) { DiaDiemBUS dd = new DiaDiemBUS(); int ma = dd.search_madd(item1.SubItems[0].Text); ChiTietTourDTO ct = new ChiTietTourDTO(); ct.MaTour = kq; ct.MaDiaDiem = ma; ChiTietTourBUS chitiet = new ChiTietTourBUS(); chitiet.themChiTiet(ct); } textBox_tentour.Text = ""; textBox_thongtintour.Text = ""; textBox_giatour.Text = ""; listView_dd.Items.Clear(); } else { MessageBox.Show("Thêm thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); Dispose(); } } } }