public static bool ChinhSuaTour(ThaoTacTourViewModel tourViewModel)
{
QlTourDuLichEntities entity = new QlTourDuLichEntities();
try
{
TOUR tour = entity.TOURs.Where(t => t.MaTour == tourViewModel.Tour.MaTour).FirstOrDefault();
tour.MaTour = tourViewModel.Tour.MaTour;
tour.TenTour = tourViewModel.Tour.TenTour;
//tour.AnhDaiDien = tourViewModel.AnhDiaDiem;
tour.GiaNguoiLon = tourViewModel.Tour.GiaNguoiLon;
tour.GiaTreEm = tourViewModel.Tour.GiaTreEm;
tour.MaHanhTrinh = entity.HANHTRINHs.FirstOrDefault(t => (t.NoiDen == tourViewModel.Tour.MaDiaDiemDen) &&
t.NoiDi == tourViewModel.Tour.MaDiaDiemDi).MaHanhTrinh;
tour.MaHDV = tourViewModel.Tour.MaHDV;
tour.MaKS = tourViewModel.KhachSan;
tour.MaLoaiTour = tourViewModel.Tour.LoaiTour;
tour.NgayKetThuc = tourViewModel.Tour.NgayKT;
tour.NgayKhoiHanh = tourViewModel.Tour.NgayKH;
entity.SaveChanges();
return(true);
}
catch (Exception)
{
entity.Dispose();
return(false);
}
}
private void bbiEdit_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (txtMaTour.TextName == "")
{
MessageBox.Show("Bạn phải chọn tour !", "Thông báo");
return;
}
if (txtTen.TextName == "")
{
MessageBox.Show("Bạn phải nhập tên tour", "Thông báo");
txtTen.Focus();
}
if (txtSoNgay.TextName == "")
{
MessageBox.Show("Bạn phải nhập số ngày", "Thông báo");
txtSoNgay.Focus();
}
if (txtSoNgay.TextName == "")
{
MessageBox.Show("Bạn phải nhập số ngày", "Thông báo");
txtSoNgay.Focus();
}
if (txtSoCho.TextName == "")
{
MessageBox.Show("Bạn phải nhập số chỗ", "Thông báo");
txtSoCho.Focus();
}
if (txtGia.TextName == "")
{
MessageBox.Show("Bạn phải nhập giá", "Thông báo");
txtGia.Focus();
}
else
{
TOUR t = tourdal.GetDVByMa(Int32.Parse(txtMaTour.TextName));
if (nameimg.Text != "")
{
string filename = System.IO.Path.GetFileName(openFileDialog1.FileName);
string path = Application.StartupPath.Substring(0, (Application.StartupPath.Length - 10));
System.IO.File.Copy(openFileDialog1.FileName, path + "\\Image\\" + filename);
t.IMAGE = filename;
}
t.TEN_TOUR = txtTen.TextName;
t.GIA = double.Parse(txtGia.TextName);
t.MA_LOAI = Int32.Parse(cb_loait.SelectedValue.ToString());
t.SO_NGAY = Int32.Parse(txtSoNgay.TextName);
t.SO_CHO = Int32.Parse(txtSoCho.TextName);
t.DISCOUNT = double.Parse(txtGiamGia.TextName);
if (tourdal.Update(tour) == 1)
{
MessageBox.Show("Sửa thành công", "Thông báo");
load();
//resetTextbox();
}
else
{
MessageBox.Show("Sửa không thành công", "Thông báo");
}
}
}
public static void sua(TOUR t)
{
var dd = db.TOURs.Find(t.ID);
db.Entry(dd).CurrentValues.SetValues(t);
db.SaveChanges();
}
public ActionResult TourForm(string tourName, string summary, string tourDescription, string url, string bookNowUrl, string duration, string cost, string groupSize, string additionalInfo, Guid organGuid)
{
var tourGuid = System.Guid.NewGuid();
var context = new TravelContentManagerEntities();
var tour = new TOUR()
{
TOUR_GUID = tourGuid,
TOUR_NAME = tourName,
TOUR_SUMMARY = summary,
TOUR_DESC = tourDescription,
URL = url,
BOOK_NOW_URL = bookNowUrl,
DURATION = duration,
COST = cost,
GROUP_SIZE = groupSize,
ADDITIONAL_INFO = additionalInfo,
ENTERED_BY = System.Guid.NewGuid(),
ENTERED_DATE_TIME = DateTime.Now
};
var orgToItem = new TOUR_ORGANIZATION_TO_ITEM
{
ORGANIZATION_TO_ITEM_ID = 1,
ORGANIZATION_TO_ITEM_GUID = System.Guid.NewGuid(),
ORGANIZATION_GUID = organGuid,
ITEM_GUID = tourGuid,
ENTERED_BY = System.Guid.NewGuid(),
ENTERED_DATE_TIME = DateTime.Now
};
context.TOURs.Add(tour);
context.TOUR_ORGANIZATION_TO_ITEM.Add(orgToItem);
context.SaveChanges();
return(RedirectToAction("Tours", "Home", new { id = organGuid }));
}
public ActionResult ChiTietTour(int id)
{
TOUR tour = data.TOURs.Where(t => t.MaSoTour == id).FirstOrDefault();
List <ChiTietPhuongTien> lstPhuongTien = data.ChiTietPhuongTiens.Where(t => t.MaSoTour == id).ToList();
ViewBag.lstPhuongTien = lstPhuongTien;
List <DiaDiemThamQuan> lstThamQuan = data.DiaDiemThamQuans.Where(t => t.MaSoTour == id).ToList();
ViewBag.lstThamQuan = lstThamQuan;
List <ChiTietDichVu> lstDichVu = data.ChiTietDichVus.Where(t => t.MaSoTour == id).ToList();
ViewBag.lstDichVu = lstDichVu;
List <TOUR> lstTourCungLoai = data.TOURs.Where(t => t.MaLoaiTour == tour.MaLoaiTour).ToList();
List <TOUR> lstTourCungLoaiRandom = new List <TOUR>();
Random rd = new Random();
for (int i = 0; i < 3; i++)
{
int num = rd.Next(0, lstTourCungLoai.Count());
lstTourCungLoaiRandom.Add(lstTourCungLoai[num]);
}
ViewBag.lstTourCungLoaiRandom = lstTourCungLoaiRandom;
List <DanhGia> lstTopDanhGia = data.DanhGias.OrderByDescending(t => t.LuotYeuThich).Take(3).ToList();
ViewBag.lstTopDanhGia = lstTopDanhGia;
return(View(tour));
}
public ActionResult Them(TOUR tour)
{
HttpPostedFileBase fileUpload = Request.Files["fileUpload"];
ViewBag.lstLoaiTour = new SelectList(data.LoaiTours.ToList(), "MaLoaiTour", "TenLoai");
ViewBag.lstTinh = new SelectList(data.Tinhs.ToList(), "MaSoTinh", "TenTinh");
if (fileUpload == null)
{
ViewBag.ThongBao = "Vui lòng chọn ảnh bìa";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Content/AnhDoAn"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
tour.HinhAnhTour = fileName;
data.TOURs.InsertOnSubmit(tour);
data.SubmitChanges();
}
return(RedirectToAction("DanhSachTour", "TienIch"));
}
}
public static bool ThemTour(ThaoTacTourViewModel tourDTO)
{
QlTourDuLichEntities entity = new QlTourDuLichEntities();
try
{
TOUR tour = new TOUR()
{
MaTour = new Random().Next(0, 10000).ToString(),
//AnhDaiDien = tourDTO.AnhDiaDiem,
GiaNguoiLon = tourDTO.Tour.GiaNguoiLon,
GiaTreEm = tourDTO.Tour.GiaTreEm,
MaHanhTrinh = entity.HANHTRINHs.FirstOrDefault(t => (t.NoiDi == tourDTO.Tour.MaDiaDiemDi &&
t.NoiDen == tourDTO.Tour.MaDiaDiemDen)).MaHanhTrinh,
MaHDV = tourDTO.Tour.MaHDV,
MaKS = tourDTO.KhachSan,
MaLoaiTour = tourDTO.Tour.LoaiTour,
NgayKetThuc = tourDTO.Tour.NgayKT,
NgayKhoiHanh = tourDTO.Tour.NgayKH,
};
entity.TOURs.Add(tour);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
entity.Dispose();
}
return(false);
}
public ActionResult DeleteConfirmed(string id)
{
TOUR tOUR = db.TOURs.Find(id);
db.TOURs.Remove(tOUR);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Sua(int id)
{
ViewBag.lstLoaiTour = new SelectList(data.LoaiTours.ToList(), "MaLoaiTour", "TenLoai");
ViewBag.lstTinh = new SelectList(data.Tinhs.ToList(), "MaSoTinh", "TenTinh");
TOUR tour = data.TOURs.Where(t => t.MaSoTour == id).FirstOrDefault();
ViewBag.ngayDi = string.Format("{0:yyyy-MM-dd}", tour.NgayBatDau);
ViewBag.ngayVe = string.Format("{0:yyyy-MM-dd}", tour.NgayKetThuc);
return(View(tour));
}
public void set(TOUR t)
{
tour = t;
textBox1.Text = t.TENTOUR;
richTextBox1.Text = t.DACDIEM;
textBox4.Text = t.GIATOUR.ToString();
textBox3.Text = t.LOAIHINH;
gia = QLTOUR_BUS.loadg(t.ID);
idcu = gia.Where(s => s.current == true).FirstOrDefault().ID;
gridControl2.DataSource = gia;
}
public ActionResult Edit([Bind(Include = "MA_TOUR,TEN_TOUR,Anh,SoLuong,SO_NGAY,SO_DEM")] TOUR tOUR)
{
if (ModelState.IsValid)
{
db.Entry(tOUR).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MA_TOUR = new SelectList(db.LOTRINH_TOUR, "MA_TOUR", "MA_NOIDI", tOUR.MA_TOUR);
return(View(tOUR));
}
private void cboTour_EditValueChanged(object sender, EventArgs e)
{
try
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
string maTour = cboTour.EditValue.ToString();
TOUR tour = data.TOURs.Where(t => t.MaSoTour == int.Parse(maTour)).FirstOrDefault();
txtDonGia.Text = tour.Gia.ToString();
}
}
catch { }
}
public CartItem(int MaTour)
{
TOUR tour = data.TOURs.Where(t => t.MaSoTour == MaTour).FirstOrDefault();
if (tour != null)
{
iMaTour = MaTour;
sTenTour = tour.TenTour;
sHinhAnhTour = tour.HinhAnhTour;
dGia = double.Parse(tour.Gia.ToString());
iSoLuong = 1;
}
}
public static int sua(TOUR t)
{
try
{
DAO.QLTOUR.sua(t);
return(1);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
private void gridView1_RowClick(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
tt = new TOUR();
TOUR t = new TOUR();
t.ID = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "ID").ToString());
t.TENTOUR = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "TENTOUR").ToString();
t.DACDIEM = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DACDIEM").ToString();
t.GIATOUR = int.Parse(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "GIATOUR").ToString());
t.LOAIHINH = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "LOAIHINH").ToString();
button2.Enabled = true;
button3.Enabled = true;
tt = t;
}
public ActionResult Xoa(int id)
{
try
{
TOUR tour = data.TOURs.Where(t => t.MaSoTour == id).FirstOrDefault();
data.TOURs.DeleteOnSubmit(tour);
data.SubmitChanges();
return(RedirectToAction("DanhSachTour", "TienIch"));
}
catch
{
return(View());
}
}
// GET: TOURs/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TOUR tOUR = db.TOURs.Find(id);
if (tOUR == null)
{
return(HttpNotFound());
}
return(View(tOUR));
}
// GET: TOURs/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TOUR tOUR = db.TOURs.Find(id);
if (tOUR == null)
{
return(HttpNotFound());
}
ViewBag.MA_TOUR = new SelectList(db.LOTRINH_TOUR, "MA_TOUR", "MA_NOIDI", tOUR.MA_TOUR);
return(View(tOUR));
}
private void btnXoa_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
TOUR tour = data.TOURs.Where(t => t.MaSoTour == int.Parse(maTour)).FirstOrDefault();
DialogResult r;
r = MessageBox.Show("Bạn có muốn tour này", "Thông báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (r == DialogResult.Yes)
{
data.TOURs.DeleteOnSubmit(tour);
data.SubmitChanges();
loadDgvTour();
}
}
}
public ActionResult Sua(TOUR tour, FormCollection col)
{
HttpPostedFileBase fileUpload = Request.Files["fileUpload"];
ViewBag.lstLoaiTour = new SelectList(data.LoaiTours.ToList(), "MaLoaiTour", "TenLoai");
ViewBag.lstTinh = new SelectList(data.Tinhs.ToList(), "MaSoTinh", "TenTinh");
TOUR editTour = data.TOURs.Where(t => t.MaSoTour == tour.MaSoTour).FirstOrDefault();
if (col["chkAnh"] == "1")
{
if (fileUpload == null)
{
ViewBag.ThongBao = "Vui lòng chọn ảnh bìa";
return(View());
}
else
{
if (ModelState.IsValid)
{
var fileName = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Content/AnhDoAn"), fileName);
if (System.IO.File.Exists(path))
{
ViewBag.ThongBao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
editTour.HinhAnhTour = fileName;
}
}
}
editTour.TenTour = tour.TenTour;
editTour.NgayBatDau = tour.NgayBatDau;
editTour.NgayKetThuc = tour.NgayKetThuc;
editTour.MoTaTour = tour.MoTaTour;
editTour.Gia = tour.Gia;
editTour.MaLoaiTour = tour.MaLoaiTour;
editTour.MaSoTinh = tour.MaSoTinh;
UpdateModel(editTour);
data.SubmitChanges();
return(RedirectToAction("DanhSachTour", "TienIch"));
}
public void set(TOUR t)
{
textBox1.Text = t.TENTOUR;
richTextBox1.Text = t.DACDIEM;
textBox4.Text = t.GIATOUR.ToString();
textBox3.Text = t.LOAIHINH;
List <DIADIEM> dd = QLTOUR_BUS.load(t.ID);
List <CTDD> ctdd = new List <CTDD>();
foreach (var x in dd)
{
CTDD ct = new CTDD();
ct = x.CTDD;
ctdd.Add(ct);
}
List <GIATOUR> gia = QLTOUR_BUS.loadg(t.ID);
gridControl1.DataSource = ctdd;
gridControl2.DataSource = gia;
}
public TourDaDatViewModel(string masp)
{
//-----------------------------------------------------
TOUR tour = ql.TOURs.Single(t => t.MaTour == masp);
matour = tour.MaTour;
tentour = tour.TenTour;
hinhanh = tour.AnhDaiDien;
giatreem = tour.GiaTreEm;
KHACHSAN khachsan = ql.KHACHSANs.Single(t => t.MaKS == tour.MaKS);
dongia = tour.GiaNguoiLon + khachsan.GiaTien;
slnguoilon = 1;
sltreem = 0;
soluong = 1;
//----------------------------------------------
QlTourDuLichEntities entity = new QlTourDuLichEntities();
var res = (from t in entity.TOURs
where t.MaTour == masp
join ks in entity.KHACHSANs
on t.MaKS equals ks.MaKS
join ht in entity.HANHTRINHs
on t.MaHanhTrinh equals ht.MaHanhTrinh
join dd1 in entity.DIADIEMs
on ht.NoiDen equals dd1.MaDiaDiem
join dd2 in entity.DIADIEMs
on ht.NoiDi equals dd2.MaDiaDiem
select new
{
NoiBD = dd1.TenDiaDiem,
NoiKT = dd2.TenDiaDiem,
NgayDi = t.NgayKhoiHanh.Value,
NgayDen = t.NgayKetThuc.Value
});
var kq = res.FirstOrDefault();
NoiDi = kq.NoiBD;
NoiDen = kq.NoiKT;
Ngaykh = kq.NgayDi;
Ngaykt = kq.NgayDen;
}
private void btnLuu_Click(object sender, EventArgs e)
{
using (DataClasses1DataContext data = new DataClasses1DataContext())
{
if (trangThai1 == "them")
{
TOUR tour = new TOUR();
tour.TenTour = txtTenTour.Text;
tour.NgayBatDau = DateTime.Parse(txtNgayBatDau.EditValue.ToString());
tour.NgayKetThuc = DateTime.Parse(txtNgayKetThuc.EditValue.ToString());
tour.MoTaTour = txtMoTa.Text;
tour.HinhAnhTour = tenAnh;
tour.Gia = int.Parse(txtGia.Text);
tour.MaLoaiTour = int.Parse(cboLoaiTour.EditValue.ToString());
tour.MaSoTinh = int.Parse(cboTinh.EditValue.ToString());
data.TOURs.InsertOnSubmit(tour);
data.SubmitChanges();
loadDgvTour();
ClearAll();
MessageBox.Show("Thêm thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (trangThai1 == "sua")
{
string maTour = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "MaSoTour").ToString();
TOUR tour = data.TOURs.Where(t => t.MaSoTour == int.Parse(maTour)).FirstOrDefault();
tour.TenTour = txtTenTour.Text;
tour.NgayBatDau = DateTime.Parse(txtNgayBatDau.EditValue.ToString());
tour.NgayKetThuc = DateTime.Parse(txtNgayKetThuc.EditValue.ToString());
tour.MoTaTour = txtMoTa.Text;
//tour.HinhAnhTour = tenAnh;
tour.Gia = int.Parse(txtGia.Text);
tour.MaLoaiTour = int.Parse(cboLoaiTour.EditValue.ToString());
tour.MaSoTinh = int.Parse(cboTinh.EditValue.ToString());
data.SubmitChanges();
loadDgvTour();
ClearAll();
MessageBox.Show("Sửa thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
TrangThaiBanDau();
}
}
private void button2_Click(object sender, EventArgs e)
{
TOUR tt = new TOUR();
tt.TENTOUR = textBox1.Text;
tt.DACDIEM = richTextBox1.Text;
tt.GIATOUR = int.Parse(textBox4.Text);
tt.LOAIHINH = textBox3.Text;
int t = QLTOUR_BUS.them(tt);
if (t == 0)
{
MessageBox.Show("Lỗi thêm tour");
}
else
{
int id = QLTOUR_BUS.id();
foreach (var x in ctdd)
{
DIADIEM d = new DIADIEM();
d.IDTOUR = id;
d.IDDD = x.ID;
t = QLTOUR_BUS.them(d);
if (t == 0)
{
MessageBox.Show("Lỗi thêm địa điểm");
}
}
foreach (var x in gia)
{
x.IDTOUR = id;
t = QLTOUR_BUS.them(x);
if (t == 0)
{
MessageBox.Show("Lỗi thêm giá");
}
}
}
}
public static List <Thongke> thongke(DateTime tu, DateTime den)
{
List <Thongke> tour = new List <Thongke>();
List <int> lt = QLTOUR.load(tu, den);
foreach (var temp in lt)
{
TOUR tt = QLTOUR.find(temp);
int demd = DAO.QLTOUR.demdoan(temp, tu, den);
int doanhthu = DAO.QLTOUR.doanhthu(temp, tt.GIATOUR, tu, den);
int chiphi = DAO.QLTOUR.chiphi(temp, tu, den);
int loi = doanhthu - chiphi;
Thongke tk = new Thongke();
tk.TENTOUR = tt.TENTOUR;
tk.SODOAN = demd;
tk.DOANHTHU = doanhthu;
tk.CHIPHI = chiphi;
tk.LOI = loi;
tour.Add(tk);
}
return(tour);
}
public string delete_tour(TOUR tour)
{
return(new Events().Delete_Tour(tour));
}
public string Add_event_tour(TOUR tour)
{
return(new Events().Add_event_tour(tour));
}
public static void them(TOUR t)
{
db.TOURs.Add(t);
db.SaveChanges();
}
public TOUR select_tour_event(TOUR tour)
{
return(new Events().select_tour_event(tour));
}
public string Update_Tour(TOUR tour)
{
return(new Events().Update_Tour(tour));
}
