public ActionResult GetAllTour()
{
var dao = new TourDAO();
var model = dao.GetAllTour().ToList();
return(View(model));
}
// GET: AssignTourLead
public ActionResult FormAssignTourLead()
{
List <TourDTO> TourList = TourDAO.getTourList();
ViewBag.list = TourList;
return(View());
}
public ActionResult LichKhoiHanh()
{
var tourDAO = new TourDAO();
var model = tourDAO.GetTourGanDay(10);
return(View(model));
}
public ActionResult Delete(int id)
{
var dao = new TourDAO();
dao.Delete(id);
return(RedirectToAction("Index"));
}
public ActionResult XacNhanThanhToan(int id)
{
var dao = new DatTourDAO();
var daoTour = new TourDAO();
//Cập nhật trạng thái thanh toán
var dattour = dao.TourChuaThanhToan(id);
var tour = daoTour.ViewDetail(dattour.matour);
//Trừ số chỗ
int sochodattour = dattour.sotreem.Value + dattour.songuoilon.Value;
int socho = tour.socho.Value;
if (sochodattour > socho)
{
Session["Error"] = "Hiện tour đã hết chỗ";
return(RedirectToAction("ChiTietDatTour", "DatTour", new { id = id }));
}
else
{
bool result = dao.XacNhanThanhToan(id);
daoTour.CapNhatSoCho(dattour.matour, sochodattour);
}
ViewBag.TourDaThanhToan = dao.TourDaThanhToan(id);
return(View());
}
public ActionResult Edit(int id)
{
var tour = new TourDAO().ViewDetail(id);
SetViewBag(tour.madd);
return(View(tour));
}
//
// GET: /Tour/
//
// GET: /Tour/Details/5
public ActionResult Danhsach(string searchString, int page = 1, int pageSize = 10)
{
var dao = new TourDAO();
var model = dao.TimTour(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(View(model));
}
// GET: Tour
public TourController()
{
repository = new TourDAO();
tour = new Tour();
nhanvienDAO = new NhanvienDAO();
thanhvienDAO = new ThanhvienDAO();
hotenDAO = new HotenDAO();
}
//
// GET: /Admin/Tour/
public ActionResult Index(int page = 1, int pageSize = 10)
{
var dao = new TourDAO();
var model = dao.ListAllPaging(page, pageSize);
//ViewBag.madd = new DiemDenDAO().GetDiemDen();
return(View(model));
}
public ActionResult TimTour(string searchString, int page = 1, int pageSize = 10)
{
var dao = new TourDAO();
var model = dao.TimTour(searchString, page, pageSize);
ViewBag.SearchString = searchString;
return(RedirectToAction("Them", model));
}
public ActionResult AssignTourLeader(string TourId, string TourLeaderId)
{
if (TourId == null || TourLeaderId == null)
{
return(RedirectToAction("ViewTour"));
}
TourDAO.AssignTourLeader(TourId, TourLeaderId);
return(RedirectToAction("ViewTour"));
}
public ActionResult TourKhuyenMai(int page = 1, int pageSize = 8)
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
var tourDAO = new TourDAO();
var model = tourDAO.GetTourKhuyenMai(page, pageSize);
return(View(model));
}
public ActionResult LichKhoiHanh()
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
var tourDAO = new TourDAO();
ViewBag.LichKhoiHanh = tourDAO.GetTourGanDay(20);
return(View());
}
public ActionResult Search(int diemden, int giatour, string khoihanh)
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
var dao = new TourDAO();
ViewBag.Tour = dao.SearchTour(diemden, giatour, khoihanh);
return(View());
}
public ActionResult TourTrongNuoc(int page = 1, int pageSize = 8)
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
var tourDAO = new TourDAO();
var model = tourDAO.GetListTourOfCategory("Trong nước", page, pageSize);
return(View(model));
}
public ActionResult UpdateTour()
{
string tourid = Request["tour"];
string leaderid = Request["leader"];
TourDAO.UpdateTour(tourid, leaderid);
ViewBag.tour = tourid;
ViewBag.leader = leaderid;
return(View());
}
public ActionResult GetTour()
{
string Id = Request["TourList"];
TourDTO t = TourDAO.getTour(Id);
ViewBag.Tour = t;
List <TourLeadDTO> LeadList = TourLeadDAO.getTourLeadList(t);
ViewBag.Leads = LeadList;
return(View());
}
public ActionResult TourNuocNgoai(int page = 1, int pageSize = 8)
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
var tourDAO = new TourDAO();
var model = tourDAO.GetListTourOfCategory("Quốc tế", page, pageSize);
//ViewBag.TourOfCategory = tourDAO.GetListTourOfCategory("Quốc tế");
return(View(model));
}
public ActionResult SuaTour(tblDATTOUR model)
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
var dao = new DatTourDAO();
ViewBag.TTDatTour = dao.TourChuaThanhToan(model.madattour);
if (ModelState.IsValid)
{
int?socho = new TourDAO().ViewDetail(model.matour).socho;
if (model.sotreem == null)
{
model.sotreem = 0;
}
int soChoDat = model.songuoilon.Value + model.sotreem.Value;
if (socho < soChoDat)
{
ViewBag.Error = "Số chỗ còn trống không đủ . Hiện số chỗ còn " + socho + " chỗ";
ViewBag.DetailTour = new TourDAO().ViewDetail(model.matour);
var session = (TravelOnline.Common.UserLogin)Session[TravelOnline.Common.CommonConstants.CUSTOMER_SESSION];
if (session == null)
{
return(RedirectToAction("Login", "KhachHang"));
}
ViewBag.ThongTinKhachHang = new KhachHangDAO().ViewDetail(session.UserID);
return(View());
}
else
{
double giatour;
var tourDAO = new TourDAO();
var tour = tourDAO.ViewDetail(model.matour);
if (tour.giakhuyenmai != null)
{
giatour = tour.giakhuyenmai.Value;
}
else
{
giatour = tour.giatour.Value;
}
//Gia tour tre em
double giaTourTreEm = giatour - giatour * 5 / 100;
model.tongtien = giatour * model.songuoilon.Value + giaTourTreEm * model.sotreem.Value;
bool result = dao.Update(model);
if (result)
{
return(RedirectToAction("TourCuaToi", "KhachHang"));
}
}
}
return(View());
}
public ActionResult Danhsach(int?MaTour, string searchString, int page = 1, int pageSize = 10)
{
var model = new DoanDAO().DanhSachDoan_MaTour(MaTour, searchString, page, pageSize);
TempData["TenTour"] = new TourDAO().TenTour(MaTour);
TempData["MaTour"] = MaTour;
var kh = new KhachHangDAO().DanhSachKhach();
TempData["KH"] = kh;
ViewBag.SearchString = searchString;
return(View(model));
}
public JsonResult ChonKH_Doan(string madoan)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
var MaDoan = serializer.Deserialize <string>(madoan);
int MaTour = new TourDAO().MaTour_MaDoan(Int16.Parse(MaDoan));
var model = new KhachHangDAO().DanhSachKhach();
ViewBag.KH = model;
return(Json(new
{
status = true
}));
}
//
// GET: /Home/
public ActionResult Index()
{
var tourDAO = new TourDAO();
var tintucDAO = new TinTucDAO();
ViewBag.NewTour = tourDAO.ListNewTour(4);
ViewBag.News = tintucDAO.ListNews(3);
ViewBag.TourGanDay = tourDAO.GetTourGanDay(5);
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
return(View());
}
public ActionResult Edit(tblTOUR tour)
{
if (ModelState.IsValid)
{
var dao = new TourDAO();
var result = dao.Update(tour);
if (result)
{
return(RedirectToAction("Index", "Tour"));
}
else
{
ModelState.AddModelError("", "Sửa tour không thành công");
}
}
return(View("Edit"));
}
public ActionResult Create(tblTOUR tour)
{
if (ModelState.IsValid)
{
var dao = new TourDAO();
long id = dao.Insert(tour);
if (id > 0)
{
return(RedirectToAction("Index", "Tour"));
}
else
{
ModelState.AddModelError("", "Thêm tour không thành công");
}
}
SetViewBag();
return(View("Create"));
}
public int themTour(TourDTO tour)
{
TourDAO t = new TourDAO();
return(t.ThemTour(tour));
}
public int suaTour(TourDTO tour)
{
TourDAO t = new TourDAO();
return(t.SuaTour(tour));
}
// GET: Assignment
public ActionResult ViewTour()
{
ViewData["Tours"] = TourDAO.getTours();
return(View());
}
public void SetViewBag(int?selectedId = null)
{
var dao = new TourDAO();
ViewBag.matour = new SelectList(dao.TourChuaKhuyenMai(), "matour", "tentour", selectedId);
}
public ActionResult DatTour(tblDATTOUR dattour)
{
var quangcaoDAO = new QuangCaoDAO();
ViewBag.QuangCao = quangcaoDAO.DanhSachQuangCao();
if (ModelState.IsValid)
{
int?socho = new TourDAO().ViewDetail(dattour.matour).socho;
if (dattour.sotreem == null)
{
dattour.sotreem = 0;
}
int soChoDat = dattour.songuoilon.Value + dattour.sotreem.Value;
if (socho < soChoDat)
{
ViewBag.Error = "Số chỗ còn trống không đủ";
ViewBag.DetailTour = new TourDAO().ViewDetail(dattour.matour);
var session = (TravelOnline.Common.UserLogin)Session[TravelOnline.Common.CommonConstants.CUSTOMER_SESSION];
if (session == null)
{
return(RedirectToAction("Login", "KhachHang"));
}
ViewBag.ThongTinKhachHang = new KhachHangDAO().ViewDetail(session.UserID);
return(View());
}
else
{
//Insert vào table Dattour
var dao = new DatTourDAO();
double giatour;
var tourDAO = new TourDAO();
var tour = tourDAO.ViewDetail(dattour.matour);
if (tour.giakhuyenmai != null)
{
giatour = tour.giakhuyenmai.Value;
}
else
{
giatour = tour.giatour.Value;
}
//Gia tour tre em
double giaTourTreEm = giatour - giatour * 5 / 100;
dattour.tongtien = giatour * dattour.songuoilon.Value + giaTourTreEm * dattour.sotreem.Value;
long id = dao.Insert(dattour);
var tourSession = new ThongTinDatTour();
tourSession.hoten = dattour.hoten;
tourSession.matour = dattour.matour;
tourSession.cmt = dattour.cmt;
tourSession.diachi = dattour.diachi;
tourSession.dienthoai = dattour.dienthoai;
tourSession.email = dattour.email;
tourSession.songuoilon = dattour.songuoilon;
tourSession.sotreem = dattour.sotreem;
tourSession.tongtien = dattour.tongtien;
Session.Add(CommonConstants.DATTOUR_SESSION, tourSession);
//Trừ số chỗ Tour
//bool result = tourDAO.CapNhatSoCho(tour.matour, soChoDat);
//View hoàn thành
return(Redirect("/dat-tour/thanh-cong"));
}
}
else
{
ViewBag.DetailTour = new TourDAO().ViewDetail(dattour.matour);
var session = (TravelOnline.Common.UserLogin)Session[TravelOnline.Common.CommonConstants.CUSTOMER_SESSION];
if (session == null)
{
return(RedirectToAction("Login", "KhachHang"));
}
ViewBag.ThongTinKhachHang = new KhachHangDAO().ViewDetail(session.UserID);
return(View());
}
}
public TourBUS()
{
tourDAO = new TourDAO();
}
