public string getAnhDaiDien(string MaTour) { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour); if (obj.Media.Count(x => x.Main == true) > 0) { return(obj.Media.First(x => x.Main == true).Url); } else { return(""); } }
public void getKhachSan(string MaTour) { TourDLEntities db = new TourDLEntities(); QLTour.CTTour obj = db.CTTour.FirstOrDefault(x => x.MaTour == MaTour); string MaDDDL = obj.MaDDDL.ToString(); string MaKS = db.KhachSan.First(x => x.MaDDDL == MaDDDL).MaKS; lbKhachSan.Text = db.KhachSan.First(x => x.MaKS == MaKS).TenKS; //QLTour.DiaDiemDL obj1 = db.DiaDiemDL.FirstOrDefault(x => x.MaDDDL == MaDDDL); //string MaKS = obj1.Ma.ToString(); //lbKhachSan.Text = db.KhachSan.First(x => x.MaKS == MaKS).TenKS; }
public string getmatour() { TourDLEntities db = new TourDLEntities(); string maMax = db.Tour.Max(x => x.MaTour); // string ma; int a = int.Parse(maMax.Substring(2)); a++; if (a < 10) { ma = "kh00" + a; } else { ma = "kh0" + a; } return(ma); }
public void getInfoKH() { try { //Load dữ liệu string abc = Session["TaiKhoan"].ToString(); // Query về db để lấy các thông tin còn lại TourDLEntities db = new TourDLEntities(); QLTour.KhachHang obj = db.KhachHang.FirstOrDefault(x => x.TaiKhoan == abc); lbTenKH.Text = obj.TenKH; lbDiaChi.Text = obj.DiaChi; lbSoDT.Text = obj.SDT; string makh = obj.MaKH; } catch (Exception) { Response.Redirect("Login.aspx"); } }
protected void btnRegister_Click(object sender, EventArgs e) { try { TourDLEntities db = new TourDLEntities(); string taikhoan = txtTaiKhoan.Text; int soluong = db.KhachHang.Count(x => x.TaiKhoan == taikhoan); if (soluong == 1) { //Tài khoản đã tồn tại lbError.Text = "tài khoản đã tồn tại!"; } if (txtMatKhau.Text == txtXTMatKhau.Text && txtTaiKhoan.Text != null && txtXTMatKhau.Text != null) { //check điều kiện QLTour.KhachHang obj = db.KhachHang.FirstOrDefault(x => x.TaiKhoan == txtTaiKhoan.Text); obj = new QLTour.KhachHang(); obj.MaKH = getmatour(); obj.TenKH = null; obj.GioiTinh = null; obj.QuocTich = null; obj.CMND = null; obj.DiaChi = null; obj.SDT = null; obj.TaiKhoan = txtTaiKhoan.Text; obj.Matkhau = mahoa(txtMatKhau.Text); db.KhachHang.Add(obj); db.SaveChanges(); Response.Redirect("Login.aspx"); } else { //lỗi lbError.Text = "Thông tin không chính xác"; } } catch (Exception) { lbError.Text = "Không thể tạo tài khoản!"; } }
protected void btnLogin_Click(object sender, EventArgs e) { //Do MD5 Hashing... byte[] hs = new byte[50]; string pass = txtMatKhau.Text; MD5 md5 = MD5.Create(); byte[] inputBytes = System.Text.Encoding.ASCII.GetBytes(pass); byte[] hash = md5.ComputeHash(inputBytes); StringBuilder sb = new StringBuilder(); for (int i = 0; i < hash.Length; i++) { hs[i] = hash[i]; sb.Append(hs[i].ToString("x2")); } var hash_pass = sb.ToString(); string taikhoan = txtTaiKhoan.Text; //string TenKhachHang; // TourDLEntities db = new TourDLEntities(); int soluong = db.KhachHang.Count(x => x.TaiKhoan == taikhoan && x.Matkhau == hash_pass); if (soluong == 1) { // Dang nhap thanh cong, gán seesion Session["TaiKhoan"] = taikhoan; //QLTour.KhachHang obj = db.KhachHang.FirstOrDefault(x => x.TaiKhoan == taikhoan); //Session["MaKH"] = obj.MaKH; // Response.Redirect("Home.aspx"); } else { lbError.Text = "Tài khoản hoặc mật khẩu không đúng!"; } }
protected void btnSubmit_Click(object sender, EventArgs e) { try { TourDLEntities db = new TourDLEntities(); QLTour.Contact obj = new QLTour.Contact(); obj.Name = txtName.Text; obj.Email = txtEmail.Text; obj.Subject = txtSubject.Text; obj.Message = txtMessage.Text; db.Contact.Add(obj); db.SaveChanges(); //Response.Write("<script>alert('Gửi thành công!');</script>"); Response.Redirect("Contacts.aspx"); } catch (Exception) { // Lỗi Response.Write("<script>alert('Gửi thất bại!');</script>"); } }
void getData(/*string src*/) { try { TourDLEntities db = new TourDLEntities(); List <QLTour.Tour> lstTour = db.Tour.ToList(); List <string> lst = new List <string>(); int c = 1; for (int i = 0; i < txtSearch.Text.Length; i++) { if (txtSearch.Text[i] == ' ') { c++; } } string[] tu = txtSearch.Text.Split(' '); for (int i = 0; i < c; i++) { lst.Add(tu[i]); } string src = Request.QueryString["src"].ToString(); List <QLTour.Tour> lstT = db.Tour.Where(x => lst.Any(k => x.TenTour.Contains(src))).ToList(); int t1 = lstT.Count(); for (int i = 0; i < t1; i++) { Tour obj = lstT.ElementAt(i); } //List<QLTour.Tour> lst = db.Tour.OrderBy(x => x.MaTour).Take(5).ToList(); rpSanPhamHot.DataSource = lstT; rpSanPhamHot.DataBind(); } catch (Exception) { lbNotFound.Text = "Không tìm thấy kết quả phù hợp"; } }
//public void getLoaiTour(string MaTour) //{ // TourDLEntities db = new TourDLEntities(); // int soluong = db.Tour.Count(x => x.MaLoaiTour.ToString() == "lt001"); // if (soluong == 1) // { // lbLoaiTour.Text = "Tour trong nước"; // } // else // { // lbLoaiTour.Text = "Tour ngoài nước hay còn gọi là tour nước ngoài"; // } //} //public void getMaxUser(string MaTour) //{ // //Load Max user // TourDLEntities db = new TourDLEntities(); // List<QLTour.Tour> max = db.Tour.Where(x => x.MaTour == MaTour).ToList(); // rpLichTrinh.DataSource = max; // rpLichTrinh.DataBind(); //} public string getLoaiPT(string MaPT) { TourDLEntities db = new TourDLEntities(); return(db.PhuongTien.First(x => x.MaPT == MaPT).TenPT); }
public string getLoaiTour(string MaLoaiTour) { TourDLEntities db = new TourDLEntities(); return(db.LoaiTour.First(x => x.MaLoaiTour == MaLoaiTour).TenLoaiTour); }
public void getTenTour(string MaTour) { TourDLEntities db = new TourDLEntities(); lbTenTour.Text = db.Tour.First(x => x.MaTour == MaTour).TenTour; }
public void getMaTour(string MaLT) { TourDLEntities db = new TourDLEntities(); lbMaTour.Text = db.LichTrinh.First(x => x.MaLT == MaLT).MaTour; }