protected void btnAdd_Click(object sender, EventArgs e) { TourDLEntities db = new TourDLEntities(); QLTour.Booking obj = new Booking(); if (txtGiaTien.Text == "") { lbErrordangky.Text = "Bạn chưa nhập đủ thông tin!!!"; } else { obj = new QLTour.Booking(); //obj.MaVe = getmave(); //obj.MaVe = int.Parse(txtMaVe.Text); obj.MaLT = cmbMaLT.SelectedValue; obj.MaTour = cmbMaTour.SelectedValue; obj.GiaTien = Int32.Parse(txtGiaTien.Text); obj.MaNV = txtMaNV.Text; obj.MaKH = cmbMaKH.SelectedValue; obj.MaDDDL = cmbMaDDDL.SelectedValue; obj.SLNguoiLon = Int32.Parse(cmbSLNL.SelectedValue); obj.SLTreEm = Int32.Parse(cmbSLTE.SelectedValue); obj.TrangThai = Int32.Parse(cmbTrangThai.SelectedValue); string ngaybk = cmbThangbk.SelectedValue + "/" + cmbNgaybk.SelectedValue + "/" + cmbNambk.SelectedValue; obj.NgayBook = Convert.ToDateTime(ngaybk); db.Booking.Add(obj); db.SaveChanges(); Response.Redirect("BooKings.aspx"); } }
protected void btnRating_Command(object sender, CommandEventArgs e) { string MaVe = e.CommandArgument.ToString(); int mave = Int32.Parse(MaVe); QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mave); string matour = obj.MaTour; string makh = obj.MaKH; Response.Redirect("Reviews.aspx?MaTour=" + matour + "&MaVe=" + MaVe + "&MaKH=" + makh); }
protected void btnSave_Click(object sender, EventArgs e) { try { // Sửa dữ liệu int mv = Int32.Parse(txtMaVe.Text); TourDLEntities db = new TourDLEntities(); string q = Session["username"].ToString(); QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mv); if (obj == null) { Response.Redirect("Bookings.aspx"); } else { if (txtGiaTien.Text == "") { lbErrordangky.Text = "Bạn chưa nhập đủ thông tin!!!"; } else { if (txtMaNV.Text == "" || q == txtMaNV.Text) { //obj.MaVe = txtMaVe.Text; obj.MaVe = int.Parse(txtMaVe.Text); obj.MaLT = cmbMaLT.SelectedValue; obj.MaTour = cmbMaTour.SelectedValue; obj.GiaTien = Int32.Parse(txtGiaTien.Text); obj.MaNV = q; obj.MaKH = cmbMaKH.SelectedValue; obj.MaDDDL = cmbMaDDDL.SelectedValue; obj.SLNguoiLon = Int32.Parse(cmbSLNL.SelectedValue); obj.SLTreEm = Int32.Parse(cmbSLTE.SelectedValue); obj.TrangThai = Int32.Parse(cmbTrangThai.SelectedValue); string ngaybk = cmbThangbk.SelectedValue + "/" + cmbNgaybk.SelectedValue + "/" + cmbNambk.SelectedValue; obj.NgayBook = Convert.ToDateTime(ngaybk); db.SaveChanges(); Response.Redirect("Bookings.aspx"); } else { lbErrordangky.Text = "Nhân viên bán tour mới có quyền sửa, Mã nhân viên: " + txtMaNV.Text; } } } } catch { // Lỗi } }
//------------------------------------------- //public string getIDBooking() //{ // TourDLEntities db = new TourDLEntities(); // string maMax = db.Booking.Max(x => x.MaVe); // // // string ma; // int a = int.Parse(maMax.Substring(2)); // a++; // if (a < 10) // { // ma = "v00" + a; // } // else // { // ma = "v0" + a; // } // return ma; // //TourDLEntities db = new TourDLEntities(); // //string maMax = db.Booking.Max(x => x.MaVe); // //// // //string ma; // //int a = int.Parse(maMax.Substring(2)); // //a++; // //if (a < 10) // //{ // // ma = "v00" + a; // //} // //else // //{ // // ma = "v0" + a; // //} // //return ma; //} //public string AutoGetma() //{ // string matour = getIDBooking(); // int MTour = int.Parse(matour.Substring(3)); // MTour++; // if (MTour < 10) // { // matour = "v00" + MTour; // } // else // { // matour = "v0" + MTour; // } // return matour; //} protected void lbtnDatTour_Click(object sender, EventArgs e) { try { TourDLEntities db = new TourDLEntities(); string matour = lbMaTour.Text.ToString(); //không cần check điều kiện //get makh string abc = Session["TaiKhoan"].ToString(); QLTour.KhachHang obj1 = db.KhachHang.FirstOrDefault(x => x.TaiKhoan == abc); string makh = obj1.MaKH; //get madddl QLTour.CTTour obj2 = db.CTTour.FirstOrDefault(x => x.MaTour == matour); string madddl = obj2.MaDDDL.ToString(); //get gia tour QLTour.CTTour obj3 = db.CTTour.FirstOrDefault(x => x.MaTour == matour); //dgvCTTour.DataSource = lst; //dgvCTTour.DataBind(); int GiaNL = Int32.Parse(obj3.GiaveNL.ToString()); int GiaTE = Int32.Parse(obj3.GiaVeTE.ToString()); int SoNL = Int32.Parse(txtSoNL.Text); int SoTE = Int32.Parse(txtSoTE.Text); int GiaTour = Int32.Parse(txtGiaTour.Text); int abcd = 0; abcd = abcd + (GiaNL * SoNL) + (GiaTE * SoTE) + GiaTour; QLTour.Booking obj = db.Booking.FirstOrDefault();//? obj = new QLTour.Booking(); //obj.MaVe = AutoGetma(); obj.MaTour = lbMaTour.Text.ToString(); obj.SLNguoiLon = Int32.Parse(txtSoNL.Text); obj.SLTreEm = Int32.Parse(txtSoTE.Text); obj.MaLT = Request.QueryString["MaLT"].ToString(); obj.MaKH = makh; obj.MaDDDL = madddl; obj.MaNV = null; obj.TrangThai = Int32.Parse("0"); obj.GiaTien = abcd; // db.Booking.Add(obj); db.SaveChanges(); //Response.Write("<script>alert('đặt tour thành công. chúng tôi sẽ liên hệ với bạn sớm!');</script>"); Response.Redirect("Home.aspx"); } catch (Exception) { Response.Write("<script>alert('Không thể đặt tour lúc này. vui lòng thử lại!');</script>"); } }
public bool getVisibleDG1(string mave) { int abc = int.Parse(mave); QLTour.Booking obj = db.Booking.First(x => x.MaVe == abc); if (obj.DanhGia.Count(x => x.Diem != null) > 0) { return(true); } else { return(false); } }
protected void btnXoa_Command(object sender, CommandEventArgs e) { try { int MaVe = Int32.Parse(e.CommandArgument.ToString()); TourDLEntities db = new TourDLEntities(); QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == MaVe); if (obj != null) { db.Booking.Remove(obj); db.SaveChanges(); getData(); } } catch { // } }
protected void btnXoa_Command(object sender, CommandEventArgs e) { string mave = e.CommandArgument.ToString(); int abc = Int32.Parse(mave); QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == abc); if (obj.TrangThai == 1) { Response.Redirect("Home.aspx"); //Response.Write("<script>alert('Bạn không thể xóa khi admin đã xác nhận tour thành công!');</script>"); } else if (obj != null) { db.Booking.Remove(obj); db.SaveChanges(); Response.Redirect("EditInfo.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Session["username"] == null || Session["username"].ToString() == "") { // Chưa đăng nhập Response.Redirect("login.aspx"); } else { getnambk(); getngaybk(); getthangbk(); getSLTE(); getSLNL(); getcmbmatour(); getcmbmalt(); //getcmbmanv(); //gettrangthai(); getcmbmadddl(); getcmbmakh(); // 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["MaVe"] == null) { // thêm mới txtMaVe.Text = Request.QueryString["MaVe"]; txtMaVe.Enabled = false; btnSave.Visible = false; btnAdd.Visible = true; //txtMaVe.Enabled = true; } else { // Sửa TourDLEntities db = new TourDLEntities(); btnSave.Visible = true; btnAdd.Visible = false; string q = Session["username"].ToString(); QLTour.NhanVien ob = db.NhanVien.FirstOrDefault(p => p.MaNV == q); string quyen = ob.NghiepVu; if (quyen == "SELL") { txtMaVe.Text = Request.QueryString["MaVe"]; txtMaVe.Enabled = false; txtMaVe.CssClass = txtMaVe.CssClass + " form-control"; cmbMaTour.SelectedValue = Request.QueryString["MaTour"]; cmbMaTour.Enabled = false; cmbMaTour.CssClass = cmbMaTour.CssClass + " form-control"; cmbMaLT.SelectedValue = Request.QueryString["MaLT"]; cmbMaLT.Enabled = false; cmbMaLT.CssClass = cmbMaLT.CssClass + " form-control"; cmbMaKH.SelectedValue = Request.QueryString["MaKH"]; cmbMaKH.Enabled = false; cmbMaKH.CssClass = cmbMaKH.CssClass + " form-control"; //-- cmbMaDDDL.SelectedValue = Request.QueryString["MaDDDL"]; cmbMaDDDL.Enabled = false; cmbMaDDDL.CssClass = cmbMaDDDL.CssClass + " form-control"; //-- txtMaNV.Text = Request.QueryString["MaNV"]; txtMaNV.Enabled = false; txtMaNV.CssClass = txtMaNV.CssClass + " form-control"; txtGiaTien.Text = Request.QueryString["GiaTien"]; txtGiaTien.Enabled = false; txtGiaTien.CssClass = txtGiaTien.CssClass + " form-control"; cmbSLNL.SelectedValue = Request.QueryString["SLNguoiLon"]; cmbSLNL.Enabled = false; cmbSLNL.CssClass = cmbSLNL.CssClass + " form-control"; cmbSLTE.SelectedValue = Request.QueryString["SLTreEm"]; cmbSLTE.Enabled = false; cmbSLTE.CssClass = cmbSLNL.CssClass + " form-control"; // Query về db để lấy các thông tin còn lại int mv = Int32.Parse(txtMaVe.Text); QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mv); if (obj == null) { Response.Redirect("QLBooking.aspx"); } else { cmbMaLT.Text = obj.MaLT; cmbMaTour.Text = obj.MaTour; txtGiaTien.Text = obj.GiaTien.ToString(); txtMaNV.Text = obj.MaNV; cmbMaKH.SelectedValue = obj.MaKH.ToString(); cmbMaDDDL.Text = obj.MaDDDL; cmbSLNL.SelectedValue = obj.SLNguoiLon.ToString(); cmbSLTE.SelectedValue = obj.SLTreEm.ToString(); cmbTrangThai.Text = obj.TrangThai.ToString(); cmbNambk.SelectedValue = obj.NgayBook.Value.Year.ToString(); cmbThangbk.SelectedValue = obj.NgayBook.Value.Month.ToString(); cmbNgaybk.SelectedValue = obj.NgayBook.Value.Day.ToString(); } } else { txtMaVe.Text = Request.QueryString["MaVe"]; txtMaVe.Enabled = false; txtMaVe.CssClass = txtMaVe.CssClass + " form-control"; cmbMaTour.SelectedValue = Request.QueryString["MaTour"]; cmbMaTour.Enabled = false; cmbMaTour.CssClass = cmbMaTour.CssClass + " form-control"; cmbMaLT.SelectedValue = Request.QueryString["MaLT"]; cmbMaLT.Enabled = false; cmbMaLT.CssClass = cmbMaLT.CssClass + " form-control"; cmbMaKH.SelectedValue = Request.QueryString["MaKH"]; cmbMaKH.Enabled = false; cmbMaKH.CssClass = cmbMaKH.CssClass + " form-control"; //-- cmbMaDDDL.SelectedValue = Request.QueryString["MaDDDL"]; cmbMaDDDL.Enabled = false; cmbMaDDDL.CssClass = cmbMaDDDL.CssClass + " form-control"; //-- txtMaNV.Text = Request.QueryString["MaNV"]; txtMaNV.Enabled = false; txtMaNV.CssClass = txtMaNV.CssClass + " form-control"; txtGiaTien.Text = Request.QueryString["GiaTien"]; txtGiaTien.Enabled = false; txtGiaTien.CssClass = txtGiaTien.CssClass + " form-control"; cmbSLNL.SelectedValue = Request.QueryString["SLNguoiLon"]; cmbSLNL.Enabled = false; cmbSLNL.CssClass = cmbSLNL.CssClass + " form-control"; cmbSLTE.SelectedValue = Request.QueryString["SLTreEm"]; cmbSLTE.Enabled = false; cmbSLTE.CssClass = cmbSLNL.CssClass + " form-control"; txtMaNV.Text = Request.QueryString["MaNV"]; txtMaNV.Enabled = false; txtMaNV.CssClass = txtMaNV.CssClass + " form-control"; cmbTrangThai.SelectedValue = Request.QueryString["TrangThai"]; cmbTrangThai.Enabled = false; cmbTrangThai.CssClass = cmbTrangThai.CssClass + " form-control"; cmbNambk.SelectedValue = Request.QueryString["NgayBook"]; cmbNambk.Enabled = false; cmbNambk.CssClass = cmbNambk.CssClass + " form-control"; cmbNgaybk.SelectedValue = Request.QueryString["NgayBook"]; cmbNgaybk.Enabled = false; cmbNgaybk.CssClass = cmbNgaybk.CssClass + " form-control"; cmbThangbk.SelectedValue = Request.QueryString["NgayBook"]; cmbThangbk.Enabled = false; cmbThangbk.CssClass = cmbThangbk.CssClass + " form-control"; // Query về db để lấy các thông tin còn lại int mv = Int32.Parse(txtMaVe.Text); QLTour.Booking obj = db.Booking.FirstOrDefault(x => x.MaVe == mv); if (obj == null) { Response.Redirect("QLBooking.aspx"); } else { txtMaVe.Text = obj.MaVe.ToString(); cmbMaLT.Text = obj.MaLT; cmbMaTour.Text = obj.MaTour; txtGiaTien.Text = obj.GiaTien.ToString(); txtMaNV.Text = obj.MaNV; cmbMaKH.SelectedValue = obj.MaKH; cmbMaDDDL.Text = obj.MaDDDL; cmbSLNL.SelectedValue = obj.SLNguoiLon.ToString(); cmbSLTE.SelectedValue = obj.SLTreEm.ToString(); cmbTrangThai.Text = obj.TrangThai.ToString(); cmbNambk.SelectedValue = obj.NgayBook.Value.Year.ToString(); cmbThangbk.SelectedValue = obj.NgayBook.Value.Month.ToString(); cmbNgaybk.SelectedValue = obj.NgayBook.Value.Day.ToString(); } } } } } }