public void insertBooked(BookedObject bookedObject) { String sql = "insert into booked values(N'" + bookedObject.MaTour + "', N'" + bookedObject.TenKhachHang + "', " + "'" + bookedObject.NgaySinh + "', N'" + bookedObject.GioiTinh + "', '" + bookedObject.SoDienThoai + "', " + "N'" + bookedObject.Gmail + "', N'" + bookedObject.DiaChi + "', '" + bookedObject.NgayDatTour + "', " + "'" + bookedObject.NgayKhoiHanh + "', " + bookedObject.SoVe + ", " + bookedObject.TongTien + ")"; data.ExecuteSQL(sql); }
protected void Page_Load(object sender, EventArgs e) { string maTour = Request.Form.Get("matour"); string gioitinh = Request.Form.Get("gioitinh"); string tenKhachHang = Request.Form.Get("hoten"); string ngaysinh = Request.Form.Get("ngaysinh"); string diaChi = Request.Form.Get("diachi"); string soDienThoai = Request.Form.Get("sdt"); string gmail = Request.Form.Get("email"); DataTable dt = bus_Tour.getTourByMaTour(maTour.Trim()); string ngayKhoiHanh = dt.Rows[0].Field <DateTime>("ngaykhoihanh").ToString(); int giatour = int.Parse(Request.Form.Get("giatour")); string ngayDatTour = DateTime.Now.ToString(); int soVe = 0; int tongTien = 0; try { soVe = int.Parse(Request.Form.Get("sove")); tongTien = soVe * giatour; } catch (Exception) { } BookedObject bookedObject = new BookedObject(); bookedObject.MaTour = maTour; bookedObject.GioiTinh = gioitinh; bookedObject.TenKhachHang = tenKhachHang; bookedObject.NgaySinh = ngaysinh; bookedObject.DiaChi = diaChi; bookedObject.SoDienThoai = soDienThoai; bookedObject.Gmail = gmail; bookedObject.NgayDatTour = ngayDatTour; bookedObject.SoVe = soVe; bookedObject.NgayKhoiHanh = ngayKhoiHanh; bookedObject.TongTien = tongTien; bus_Booked.insertBooked(bookedObject); LabelMaTour.Text = maTour; LabelHoTen.Text = tenKhachHang; LabelNgaySinh.Text = ngaysinh; LabelGioiTinh.Text = gioitinh; LabelDiaChi.Text = diaChi; LabelSdt.Text = soDienThoai; LabelEmail.Text = gmail; LabelSoVe.Text = soVe.ToString(); LabelTongTien.Text = tongTien.ToString(); LabelThoiGianDat.Text = ngayDatTour; LabelNgayKhoiHanh.Text = ngayKhoiHanh; }
public void Delete(BookedObject b) { string sql = "Delete from booked where maBooked = '" + b.MaBooked + "'"; data.ExecuteSQL(sql); }
public void update(BookedObject b) { string sql = "update booked set MaTour = '" + b.MaTour.Trim() + "',TenKhachHang = N'" + b.TenKhachHang + "',NgaySinh = '" + b.NgaySinh + "',GioiTinh = N'" + b.GioiTinh + "',SoDienThoai = '" + b.SoDienThoai + "',Gmail = '" + b.Gmail + "',DiaChi = N'" + b.DiaChi + "',SoVe = " + b.SoVe + ",TongTien = " + b.TongTien + " where maBooked = '" + b.MaBooked + "'"; data.ExecuteSQL(sql); }