public int checkbook(DTO_Booked obj)
{
String sql = "Select * From booked where MaKhachHang = N'" + obj.MaKhachHang + "'";
DataTable t = base.GetTable(sql);
return(t.Rows.Count);
}
public GUI_ADMIN_HoTro_SuaBook(DTO_Booked b, DTO_Tour t, DTO_KhachHang k, DTO_TaiKhoan taikhoan) : this()
{
InitializeComponent();
bk = b;
tr = t;
kh = k;
nhantaikhoan = taikhoan;
lbNgayHomNay.Text = DateTime.Now.ToString("dd/MMM/yy").Trim();
laydata();
}
public GUI_ADMIN_HoTro_SuaKhachHang(DTO_KhachHang k, DTO_Booked b, DTO_TaiKhoan taiKhoan) : this()
{
InitializeComponent();
kh = k;
bk = b;
txtTenKhachHang.Text = kh.TenKhachHang;
dtpNgaySinh.Text = kh.NgaySinh;
if (kh.GioiTinh.ToString().Equals("Nam"))
{
rdbNam.Checked = true;
}
else
{
rdbNu.Checked = true;
}
txtSoDienThoai.Text = kh.SoDienThoai;
txtGmail.Text = kh.Gmail;
txtDiaChi.Text = kh.DiaChi;
tk = taiKhoan;
}
public bool DeleteKhachHang(DTO_Booked obj)
{
bool check;
if (base.conn.State == ConnectionState.Closed)
{
base.conn.Open();
}
String sql = "delete from khachhang where maKhachHang = @maKhachHang";
SqlCommand cmd = new SqlCommand(sql, base.conn);
cmd.Parameters.AddWithValue("@makhachhang", obj.MaKhachHang);
check = base.ThucThi(cmd);
if (base.conn.State == ConnectionState.Open)
{
base.conn.Close();
}
return(check);
}
public bool DeleteBooked(DTO_Booked obj)
{
bool check;
if (base.conn.State == ConnectionState.Closed)
{
base.conn.Open();
}
String sql = "delete from booked where MaBooked = @MaBooked";
SqlCommand cmd = new SqlCommand(sql, base.conn);
cmd.Parameters.AddWithValue("@MaBooked", obj.MaBooked);
check = base.ThucThi(cmd);
if (base.conn.State == ConnectionState.Open)
{
base.conn.Close();
}
return(check);
}
public DataTable Lookupbookedtheoma(DTO_Booked obj, DTO_KhachHang objkh)
{
string sql = "Select mabooked,booked.matour, tentour,makhachhang,ngaydattour,tour.ngaykhoihanh, songuoilon,sotreem,giatour From booked inner join tour on booked.matour = tour.matour where makhachhang = '" + obj.MaKhachHang + "' or makhachhang = '" + objkh.MaKhachHang + "'";
return(base.GetTable(sql));
}
public void updateBooked(DTO_Booked obj)
{
String sql = "update booked set SoNguoiLon = " + int.Parse(obj.SoNguoiLon.ToString()) + ",SoTreEm = " + int.Parse(obj.SoTreEm.ToString()) + ",TongTien = " + int.Parse(obj.TongTien.ToString()) + " where maBooked ='" + obj.MaBooked + "'";
base.ExecuteSQL(sql);
}
public DataTable Lookupbookedtheoma(DTO_Booked obj, DTO_KhachHang objkh)
{
return(dal.Lookupbookedtheoma(obj, objkh));
}
public void InsertBooked(DTO_Booked obj)
{
dal.InsertBooked(obj);
}
public int checkbook(DTO_Booked obj)
{
return(dal.checkbook(obj));
}
public bool DeleteBooked(DTO_Booked obj)
{
return(dal.DeleteBooked(obj));
}
public void updateBooked(DTO_Booked obj)
{
dal.updateBooked(obj);
}
public bool DeleteKhachHang(DTO_Booked obj)
{
return(dal.DeleteKhachHang(obj));
}
public DataTable Lookupkhachhangtheoma(DTO_Booked objbk, DTO_KhachHang obj)
{
return(dal.Lookupkhachhangtheoma(objbk, obj));
}
private void btnDangKy_Click(object sender, EventArgs e)
{
if (checktrong() && checklenghth())
{
tongtien = dattour.tongtien(int.Parse(lbGiaTour.Text), numNguoiLon.Value, numTreEm.Value);
if (MessageBox.Show("Bạn có chắc chắn muốn đăng tour này với tổng chi phí là: " + tongtien + " không?", "Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
string makhachhang = dtpNgaySinh.Text.Trim() + "_" + txtSoDienThoai.Text.Trim();
DTO_KhachHang khachhang = new DTO_KhachHang();
khachhang.MaKhachHang = makhachhang.Trim() + "_0";
khachhang.TenKhachHang = txtTenKhachHang.Text.Trim();
khachhang.NgaySinh = dtpNgaySinh.Text.Trim();
if (rdbNam.Checked)
{
khachhang.GioiTinh = "Nam";
}
else
{
khachhang.GioiTinh = "Nữ";
}
khachhang.SoDienThoai = txtSoDienThoai.Text.Trim();
khachhang.Gmail = txtGmail.Text.Trim();
khachhang.DiaChi = txtDiaChi.Text.Trim();
string mabooked = tour.MaTour.Trim() + "_" + khachhang.MaKhachHang.Trim();
DTO_Booked booked = new DTO_Booked();
booked.MaBooked = mabooked.Trim() + "_0";
booked.MaTour = tour.MaTour.Trim();
booked.NgayDatTour = DateTime.Now.ToString("dd/MMM/yy").Trim();
booked.NgayKhoiHanh = tour.NgayKhoiHanh.Trim();
booked.SoNguoiLon = int.Parse(numNguoiLon.Value.ToString());
booked.SoTreEm = int.Parse(numTreEm.Value.ToString());
booked.TongTien = tongtien;
DataTable table2 = dattour.checkmaKhachHang(makhachhang.Trim());
int rows = table2.Rows.Count;
if (rows <= 0)
{
booked.MaKhachHang = khachhang.MaKhachHang;
dattour.InsertKhachHang(khachhang);
dattour.InsertBooked(booked);
}
else
{
DataTable table1 = dattour.checkKhachHang(khachhang);
if (table1.Rows.Count <= 0)
{
int length1 = makhachhang.Trim().Length;
//int length2 = table2.Rows[rows][0].ToString().Trim().Length;
int num = int.Parse(table2.Rows[rows - 1][0].ToString().Trim().Substring(length1 + 1));
num++;
if (num < 99999)
{
khachhang.MaKhachHang = makhachhang + "_" + num;
booked.MaKhachHang = khachhang.MaKhachHang;
booked.MaBooked = tour.MaTour.Trim() + "_" + booked.MaKhachHang.Trim() + "_0";
dattour.InsertKhachHang(khachhang);
dattour.InsertBooked(booked);
}
else
{
MessageBox.Show("Phát hiện spam!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
booked.MaKhachHang = table1.Rows[0][0].ToString().Trim();
string mabookeddaco = tour.MaTour.Trim() + "_" + booked.MaKhachHang.Trim();
DataTable table3 = dattour.checkmabooked(mabookeddaco.Trim());
int rows2 = table3.Rows.Count;
if (rows2 <= 0)
{
booked.MaBooked = tour.MaTour.Trim() + "_" + booked.MaKhachHang.Trim() + "_0";
dattour.InsertBooked(booked);
}
else
{
int length2 = mabooked.Trim().Length;
int num2 = int.Parse(table3.Rows[rows2 - 1][0].ToString().Trim().Substring(length2 + 1));
num2++;
if (num2 < 99999)
{
booked.MaBooked = tour.MaTour.Trim() + "_" + booked.MaKhachHang.Trim() + "_" + num2;
dattour.InsertBooked(booked);
}
else
{
MessageBox.Show("Phát hiện spam!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
MessageBox.Show("Đặt thành công!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
public DataTable Lookupkhachhangtheoma(DTO_Booked objbk, DTO_KhachHang obj)
{
string sql = "Select * From khachhang where makhachhang = '" + obj.MaKhachHang + "' or makhachhang = '" + objbk.MaKhachHang + "'";
return(base.GetTable(sql));
}
public void InsertBooked(DTO_Booked obj)
{
string sql = "insert into booked values('" + obj.MaBooked + "','" + obj.MaTour + "','" + obj.MaKhachHang + "','" + obj.NgayDatTour + "','" + obj.NgayKhoiHanh + "'," + int.Parse(obj.SoNguoiLon.ToString()) + "," + int.Parse(obj.SoTreEm.ToString()) + "," + int.Parse(obj.TongTien.ToString()) + ")";
base.ExecuteSQL(sql);
}
public DataTable Lookupkhachhangtheoma(DTO_Booked obj)
{
string sql = "Select tour.matour,mabooked,booked.makhachhang, songuoilon, sotreem From tour inner join booked on tour.matour = booked.matour inner join khachhang on khachhang.makhachhang = booked.makhachhang where tour.matour = '" + obj.MaTour + "'";
return(base.GetTable(sql));
}
