public void getCountCmt(string MaTour) { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour); lbCountCmt.Text = obj.Comment.Count(x => x.ID_comment > 0).ToString(); }
//public void getData() //{ // TourDLEntities db = new TourDLEntities(); // List<QLTour.Tour> lstSP = db.Tour.Take(1).ToList(); // rpAnhDaiDien.DataSource = lstSP; // rpAnhDaiDien.DataBind(); //} void getMoTa(string MaTour) { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.First(x => x.MaTour == MaTour); if (db.Tour.FirstOrDefault(x => x.MaTour == MaTour) != null) { //Load anh Dai dien List <QLTour.Media> lst = db.Media.Where(x => x.MaTour == MaTour).Take(1).ToList(); rpAnhDaiDien.DataSource = lst; rpAnhDaiDien.DataBind(); //Load Mo Ta List <QLTour.Tour> mt = db.Tour.Where(x => x.MaTour == MaTour).ToList(); rpMoTa.DataSource = mt; rpMoTa.DataBind(); //Load Anh Tour List <QLTour.Media> lst1 = db.Media.Where(x => x.MaTour == MaTour).ToList(); rpAnhTour.DataSource = lst1; rpAnhTour.DataBind(); ////Load Max user //List<QLTour.Tour> max = db.Tour.Where(x => x.MaTour == MaTour).ToList(); //rpLichTrinh.DataSource = max; //rpLichTrinh.DataBind(); } else { Response.Redirect("Offers.aspx"); } }
public void getPoint(string MaTour) { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour); lbPoint.Text = obj.DanhGia.Average(x => x.Diem).ToString(); }
public string getPoint(string MaTour) { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour); return(obj.DanhGia.Average(x => x.Diem).ToString()); }
//void getcmbLoaitour() //{ // TourDLEntities db = new TourDLEntities(); // List<QLTour.LoaiTour> lst = db.LoaiTour.ToList(); // cmbMaLoaiTour.DataSource = lst; // cmbMaLoaiTour.DataTextField = "TenLoaiTour"; // cmbMaLoaiTour.DataValueField = "MaLoaiTour"; // cmbMaLoaiTour.DataBind(); //} protected void btnSave_Click(object sender, EventArgs e) { try { // Sửa dữ liệu TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == txtMaTour.Text); if (obj == null) { Response.Redirect("Tours.aspx"); } else { //obj.MaTour = txtMaTour.Text; obj.TenTour = txtTenTour.Text; obj.MaLoaiTour = cmbMaLoaiTour.SelectedValue; obj.GiaTien = Int32.Parse(txtGiaTour.Text); obj.Maxuser = Int32.Parse(txtMaxUser.Text); obj.Minuser = Int32.Parse(txtMinUser.Text); obj.MoTa = txtMieuTaNgan.Text; db.SaveChanges(); Response.Redirect("Tours.aspx"); } } catch { // Lỗi } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //getcmbLoaitour(); // kiểm tra trường hợp sửa/thêm mới // nếu url có dạng ?masp=123 => sửa, ngược lại là thêm mới if (Request.QueryString["Matour"] == null) { // thêm mới btnSave.Visible = false; btnAdd.Visible = true; txtMaTour.Enabled = true; //txtMaTour.Text = Request.QueryString["MaTour"]; txtMaTour.Enabled = false; txtMaTour.CssClass = txtMaTour.CssClass + " form-control"; } else { // Sửa btnSave.Visible = true; btnAdd.Visible = false; txtMaTour.Text = Request.QueryString["MaTour"]; txtMaTour.Enabled = false; txtMaTour.CssClass = txtMaTour.CssClass + " form-control"; // Query về db để lấy các thông tin còn lại TourDLEntities db = new TourDLEntities(); string manv = Session["username"].ToString(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == txtMaTour.Text); if (obj == null) { Response.Redirect("QLTours.aspx"); } else { QLTour.NhanVien ob = db.NhanVien.FirstOrDefault(p => p.MaNV == manv); string quyen = ob.NghiepVu; if (quyen == "CSKH" || quyen == "SELL") { btnSave.Visible = false; txtTenTour.Text = obj.TenTour; txtGiaTour.Text = obj.GiaTien.ToString(); cmbMaLoaiTour.SelectedValue = obj.MaTour; txtMaxUser.Text = obj.Maxuser.ToString(); txtMinUser.Text = obj.Minuser.ToString(); txtMieuTaNgan.Text = obj.MoTa; } else { txtTenTour.Text = obj.TenTour; txtGiaTour.Text = obj.GiaTien.ToString(); cmbMaLoaiTour.SelectedValue = obj.MaTour; txtMaxUser.Text = obj.Maxuser.ToString(); txtMinUser.Text = obj.Minuser.ToString(); txtMieuTaNgan.Text = obj.MoTa; } } } } }
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(""); } }
protected void btnXoa_Command(object sender, CommandEventArgs e) { try { string MaTour = e.CommandArgument.ToString(); TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == MaTour); if (obj != null) { db.Tour.Remove(obj); db.SaveChanges(); getData(); } } catch { // lỗi lbErrorxoa.Text = "Bạn không thể xóa khi chưa xóa ảnh!"; } }
protected void btnAdd_Click(object sender, EventArgs e) { try { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.FirstOrDefault(x => x.MaTour == txtMaTour.Text); if (obj != null) { // Cảnh báo mã sản phẩm đã tồn tại } else { if (txtTenTour.Text == "" || txtGiaTour.Text == "") { lbloi.Text = "bạn chưa nhập đủ thông tin!"; } else { obj = new QLTour.Tour(); obj.MaTour = getmatour(); obj.TenTour = txtTenTour.Text; obj.MaLoaiTour = cmbMaLoaiTour.SelectedValue; obj.GiaTien = Int32.Parse(txtGiaTour.Text); obj.Maxuser = Int32.Parse(txtMaxUser.Text); obj.Minuser = Int32.Parse(txtMinUser.Text); obj.MoTa = txtMieuTaNgan.Text; db.Tour.Add(obj); db.SaveChanges(); Response.Redirect("Tours.aspx"); } } } catch { // Lỗi } }
public string getAnhDaiDien(string Matour) { TourDLEntities db = new TourDLEntities(); QLTour.Tour obj = db.Tour.First(x => x.MaTour == Matour); //var idanh = obj.Media.Where(p => p.MaTour == Matour && p.Main == true).Max(p => p.IDMedia); if (obj != null) { if (obj.Media.Count(x => x.Main == true) > 0) { return(obj.Media.First(x => x.Main == true).Url); //return idanh; } else { return(""); } } else { return(""); } }