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();
}
}
}
}
