public ActionResult SuaKhachsan(KhachSan ksan, HttpPostedFileBase fileUpload, FormCollection collection, int id)
{
ViewBag.MaDiaDiem = new SelectList(db.DiaDiems.ToList().OrderBy(n => n.TenDiaDiem), "MaDiaDiem", "TenDiaDiem", ksan.MaDiaDiem);
KhachSan ks = db.KhachSans.Where(m => m.MaKhachSan == ksan.MaKhachSan).FirstOrDefault();
string tenkhachsan = collection["TenKhachSan"];
var diachi = collection["DiaChi"];
var thongtin = collection["ThongTin"];
string video = collection["Video"];
if (String.IsNullOrEmpty(tenkhachsan))
{
ViewData["Loi"] = "Tên ko để trống";
}
else
{
ks.TenKhachSan = tenkhachsan;
ks.DiaChi = diachi;
ks.ThongTin = thongtin;
ks.Video = video;
//Luu vao CSDL
UpdateModel(ksan);
db.SubmitChanges();
//kiểm tra đường dẫn file
return(RedirectToAction("Khachsan"));
}
return(this.SuaKhachsan(id));
}
private void btnUpdate_Click(object sender, EventArgs e)
{
DialogResult dlg = MessageBox.Show("Do you want to update this hotel?", "Kim Nguyen say:", MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dlg == System.Windows.Forms.DialogResult.Yes)
{
if (KhachSan.Update(controls_Load()))
{
if (listf.Count > 0)
{
foreach (var item in listf)
{
KSanDLich ks = new KSanDLich();
ks.MKS = Code;
ks.MDiemDL = item;
if (!KSanDLich.Add(ks))
{
MessageBox.Show(String.Format("Updating had been failse with the scenic witch had been code {0}?", item), "Kim Nguyen say:", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
}
MessageBox.Show("Updating is successful?", "Kim Nguyen say:", MessageBoxButtons.OK, MessageBoxIcon.Question);
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("Updating had been failse?", "Kim Nguyen say:", MessageBoxButtons.OK, MessageBoxIcon.Question);
}
}
}
private void lvTrips_SelectedIndexChanged(object sender, EventArgs e)
{
if (lvTrips.SelectedItems.Count > 0)
{
int _Machuyen = MyConvert.ToInt32(lvTrips.SelectedItems[0].SubItems[0].Text);
int _MaTour = 0;
foreach (Chuyen item in listTrip)
{
if (item.MChuyen == _Machuyen)
{
_MaTour = item.MTour;
break;
}
}
lvScenics_Load(DiemDL.FindByMTour(_MaTour));
lvGuide_Load(HuongDanVien.FindByMChuyen(_Machuyen));
lvHotels_Load(KhachSan.FindByMTour(_MaTour));
lvVehicles_Load(PhuongTien.FindByMTour(_MaTour));
lvCustomers_Load(KhachHang.FindByMChuyen(_Machuyen));
btnUpdate.Enabled = true;
btnDelete.Enabled = true;
}
else
{
lvGuide.Items.Clear();
lvHotels.Items.Clear();
lvScenics.Items.Clear();
lvCustomers.Items.Clear();
btnUpdate.Enabled = false;
btnDelete.Enabled = false;
}
}
public ActionResult Add(KhachSan model)
{
if (ModelState.IsValid)
{
try
{
var obj = Db.KhachSans.FirstOrDefault(x => x.TenKhachSan == model.TenKhachSan);
if (obj == null)
{
Db.KhachSans.Add(model);
Db.SaveChanges();
TempData["notice"] = "Thêm thành công!";
return(RedirectToAction("Index"));
}
else
{
TempData["notice"] = "Tên khách sạn đã tồn tại! Vui lòng chọn tên khác!";
}
}
catch
{
TempData["notice"] = "Thêm không thành công!";
}
}
return(View(model));
}
private void btnAddDes_Click(object sender, EventArgs e)
{
DiemDL ddl = cbbScenic.SelectedItem as DiemDL;
listScenic.Add(ddl);
cbbScenic.Items.Remove(ddl);
ListViewItem i = lvDestination.Items.Add(ddl.TenDD);
i.SubItems.Add(ddl.TenDiem);
KhachSan ks = cbbHotel.SelectedItem as KhachSan;
i.SubItems.Add(ks.TenKS);
PhuongTien pt = cbbVehical.SelectedItem as PhuongTien;
i.SubItems.Add(pt.TenPT);
i.SubItems.Add(pt.TenNCC);
DiemDen dd = new DiemDen();
dd.MTour = 0;
dd.MDiemDL = ddl.ID;
dd.MaKS = ks.ID;
dd.MaPT = pt.ID;
listDes.Add(dd);
btnAddDes.Enabled = false;
}
public ActionResult Edit(KhachSan model)
{
if (ModelState.IsValid)
{
try
{
var objCheck = Db.KhachSans.FirstOrDefault(x => x.TenKhachSan == model.TenKhachSan && x.MaKhachSan != model.MaKhachSan);
if (objCheck == null)
{
var obj = Db.KhachSans.FirstOrDefault(x => x.MaKhachSan == model.MaKhachSan);
obj.TenKhachSan = model.TenKhachSan;
obj.HinhAnh = model.HinhAnh;
obj.DiaChi = model.DiaChi;
obj.Email = model.Email;
obj.SDT = model.SDT;
Db.KhachSans.Attach(obj);
Db.Entry(obj).State = EntityState.Modified;
Db.SaveChanges();
TempData["notice"] = "Sửa thành công!";
return(RedirectToAction("Index"));
}
else
{
TempData["notice"] = "Tên khách sạn đã tồn tại! Vui lòng chọn tên khác!";
}
}
catch
{
TempData["notice"] = "Sửa không thành công!";
}
}
return(View(model));
}
public ActionResult ThemKhachSan(KhachSan objKhachSan, HttpPostedFileBase fUpload)
{
try
{
if (ModelState.IsValid)
{
//Xử lý upload file
if (fUpload != null &&
fUpload.ContentLength > 0)
{
//Upload
fUpload.SaveAs(Server.MapPath("~/Content/Image/KhachSan/" + fUpload.FileName));
//Lưu vào db
objKhachSan.PictureId = fUpload.FileName;
}
//thêm vào database
DataProvider.Entities.KhachSans.Add(objKhachSan);
//Lưu thay đổi
DataProvider.Entities.SaveChanges();
logger.Info("Add a Hotel: " + objKhachSan.TenKhachSan);
}
return(RedirectToAction("DanhSachKhachSan"));
}
catch (Exception ex)
{
logger.Error(ex.ToString());
return(Redirect("~/ErrorPage/Return"));
}
}
public ActionResult dat_phong(string id1, string id2, string startString, string endString, string didbook)
{
if (didbook != "true")
{
KhachSan khachSan = ivivuDB.timKhachSan(id1);
LoaiPhong loaiPhong = ivivuDB.timLoaiPhong(id2);
ViewBag.idKS = id1;
ViewBag.idLP = id2;
return(View(khachSan));
}
else
{
KhachSan khachSan = ivivuDB.timKhachSan(id1);
LoaiPhong loaiPhong = ivivuDB.timLoaiPhong(id2);
ViewBag.idKS = id1;
ViewBag.idLP = id2;
DateTime startDay = DateTime.Parse(startString);
DateTime endDay = DateTime.Parse(endString);
if (startDay.CompareTo(endDay) >= 0)
{
return(RedirectToAction("dat_phong", "KhachHang", new { id1, id2 }));
}
List <Phong> listPhong = ivivuDB.timPhongTrongTheoNgay(startString, endString, id2);
ViewBag.listPhong = listPhong;
return(View(khachSan));
}
}
private void cbMaks_TextChanged(object sender, EventArgs e)
{
if (cbMaks.Text != "" && cbGt2.Text == "" && cbCv.Text == "")
{
KhachSan ks = dl.KhachSans.Single(a => a.TenKhachSan == cbMaks.Text);
string maks = ks.MaKhachSan;
dataGridView1.DataSource = db.search_nv(maks);
}
if (cbMaks.Text != "" && cbGt2.Text != "" && cbCv.Text == "")
{
KhachSan ks = dl.KhachSans.Single(a => a.TenKhachSan == cbMaks.Text);
string maks = ks.MaKhachSan;
dataGridView1.DataSource = db.search_nv(cbGt2.Text, maks);
}
if (cbMaks.Text != "" && cbGt2.Text == "" && cbCv.Text != "")
{
KhachSan ks = dl.KhachSans.Single(a => a.TenKhachSan == cbMaks.Text);
string maks = ks.MaKhachSan;
dataGridView1.DataSource = db.search_nv(maks, cbCv.Text);
}
if (cbMaks.Text != "" && cbGt2.Text != "" && cbMaks.Text != "")
{
KhachSan ks = dl.KhachSans.Single(a => a.TenKhachSan == cbMaks.Text);
string maks = ks.MaKhachSan;
dataGridView1.DataSource = db.search_nv(cbGt2.Text, cbCv.Text, maks);
}
}
public ActionResult Edit(KhachSan ks)
{
if (ModelState.IsValid)
{
if (ks.imageFileks != null)
{
string fileName = Path.GetFileNameWithoutExtension(ks.imageFileks.FileName);
string extension = Path.GetExtension(ks.imageFileks.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssfff") + extension;
ks.Anh = "~/Image/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Image/"), fileName);
ks.imageFileks.SaveAs(fileName);
}
var dao = new KhachSanDao();
var result = dao.ChinhSua(ks);
if (result)
{
SetAlert("Cập nhật thành công", "success");
return RedirectToAction("DanhSachKhachSan", "KhachSan");
}
else
{
SetAlert("Cập nhật thất bại", "error");
return RedirectToAction("Edit", "KhachSan");
}
}
return View("Index");
}
public async Task <int> ThemKhachSan(CauHinhKhachSanRequiter khachsan)
{
KhachSan khachsanadd = new KhachSan();
//khachsanadd.ID_KhachSan = khachsan.ID_KhachSan;
khachsanadd.TenKhachSan = khachsan.TenKhachSan;
khachsanadd.CreateBy = khachsan.CreateBy;
khachsanadd.LogoKhachSan = khachsan.LogoKhachSan;
khachsanadd.CreateDate = DateTime.Now;
khachsanadd.Delete = khachsan.Delete;
khachsanadd.DiaChiKhachSan = khachsan.DiaChiKhachSan;
khachsanadd.Email = khachsan.Email;
khachsanadd.Facebook = khachsan.Facebook;
khachsanadd.Hotline = khachsan.Hotline;
khachsanadd.LastModifiedDate = DateTime.Now;
khachsanadd.MaKhachSan = khachsan.MaKhachSan;
khachsanadd.ModifyBy = khachsan.ModifyBy;
khachsanadd.SoDiDong = khachsan.SoDiDong;
khachsanadd.SoFax = khachsan.SoFax;
khachsanadd.SoMayBan = khachsan.SoMayBan;
khachsanadd.TrangThai = khachsan.TrangThai;
khachsanadd.Twitter = khachsan.Twitter;
khachsanadd.Website = khachsan.Website;
khachsanadd.Youtube = khachsan.Youtube;
khachsanadd.Instagram = khachsan.Instagram;
khachsanadd.GioiThieu = khachsan.GioiThieu;
khachsanadd.ViTri = khachsan.ViTri;
_context.KhachSans.Add(khachsanadd);
await _context.SaveChangesAsync();
return(khachsanadd.ID_KhachSan);
}
public ActionResult CreateHotel(KhachSan p, HttpPostedFileBase fileUpload, FormCollection collection)
{
var filename = Path.GetFileName(fileUpload.FileName);
var path = Path.Combine(Server.MapPath("~/Images"), filename);
if (System.IO.File.Exists(path))
{
ViewBag.Thongbao = "Hình ảnh đã tồn tại";
}
else
{
fileUpload.SaveAs(path);
}
var tenks = collection["TenKS"];
var gioithieu = collection["GioiThieu"];
var diachi = collection["DiaChi"];
var sdt = collection["SDT"];
p.TenKS = tenks;
p.hinh_1 = filename;
p.hinh_2 = filename;
p.GioiThieu = gioithieu;
p.DiaChi = diachi;
p.SDT = sdt;
p.MaKV = 1;
p.star = 4;
p.point = 7;
p.QC = true;
p.LuotDanhGia = 500;
data.KhachSans.InsertOnSubmit(p);
data.SubmitChanges();
return(RedirectToAction("HotelControl"));
}
private void cbbHotel_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbbHotel.SelectedIndex >= 0)
{
KhachSan ks = cbbHotel.SelectedItem as KhachSan;
tvHotel_Load(ks);
}
}
public ActionResult DeleteConfirmed(int id)
{
KhachSan khachSan = db.KhachSans.Find(id);
db.KhachSans.Remove(khachSan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult KSLienQUan(int id)
{
KhachSan ks = db.KhachSans.FirstOrDefault(x => x.MaKS == id);
List <KhachSan> ks1 = db.KhachSans.Where(x => x.MaKV == ks.MaKV || (x.MaKV == ks.MaKV && x.star == ks.star)).ToList();
return(PartialView(ks1));
}
public IEnumerable <PhongKhachSan> ListRoomsByHotelId(KhachSan ks)
{
if (ks == null)
{
return(null);
}
return(db.PhongKhachSans.Where(x => x.KhachSan_ID == ks.ID));
}
public ActionResult RemoveHotel(int id)
{
List <DonDatPhong> ls_ddp = data.DonDatPhongs.Where(t => t.MaKS == id).ToList();
foreach (DonDatPhong ddp in ls_ddp)
{
data.DonDatPhongs.DeleteOnSubmit(ddp);
}
List <DiemDanhGia> ls_ddg = data.DiemDanhGias.Where(t => t.MaKS == id).ToList();
foreach (DiemDanhGia ddg in ls_ddg)
{
data.DiemDanhGias.DeleteOnSubmit(ddg);
}
List <ChiTietDatPhong> ls_ctdp = data.ChiTietDatPhongs.Where(t => t.maks == id).ToList();
foreach (ChiTietDatPhong ctdp in ls_ctdp)
{
data.ChiTietDatPhongs.DeleteOnSubmit(ctdp);
}
TienNghi tn = data.TienNghis.FirstOrDefault(t => t.MaKS == id);
data.TienNghis.DeleteOnSubmit(tn);
List <Phong> ls_p = data.Phongs.Where(t => t.MaKS == id).ToList();
foreach (Phong p in ls_p)
{
data.Phongs.DeleteOnSubmit(p);
}
KhachSan ks = data.KhachSans.SingleOrDefault(i => i.MaKS == id);
List <HinhAnh> ls_ha = data.HinhAnhs.Where(t => t.MaKS == ks.MaKS).ToList();
foreach (HinhAnh ha in ls_ha)
{
data.HinhAnhs.DeleteOnSubmit(ha);
}
if (ks == null)
{
Response.StatusCode = 404;
return(null);
}
//var filePath = Server.MapPath("~/images/products" + p.ImageProduct);
var filePath = Path.Combine(Server.MapPath("~/images"), ks.hinh_1);
if (System.IO.File.Exists(filePath))
{
System.IO.File.Delete(filePath);
}
data.KhachSans.DeleteOnSubmit(ks);
data.SubmitChanges();
return(RedirectToAction("HotelControl"));
}
private void control_Load()
{
KhachSan rs = KhachSan.Single(Code);
txtAddress.Text = rs.DiaChi;
txtCode.Text = rs.ID.ToString();
txtName.Text = rs.TenKS;
txtPhone.Text = rs.SoDienThoai;
txtStartNumber.Text = rs.SoSao.ToString();
}
public ActionResult chinh_sua_khach_san(string IdKS, KhachSan KhachSanData)
{
bool temp = ivivuDB.chinhSuaKhachSan(IdKS, KhachSanData);
if (temp)
{
return(RedirectToAction("thong_tin_khach_san", "QuanTri", IdKS));
}
return(RedirectToAction("chinh_sua_khach_san", "QuanTri"));
}
private void Hotelsfrm_Load(object sender, EventArgs e)
{
//grbManager.Visible = false;
//if (Powers == PowersLog.Administrator || Powers == PowersLog.Designer)
//{
// grbManager.Visible = true;
//}
lvHotels_Load(KhachSan.All());
cbbColumn_Load();
}
private void btnNewHotel_Click(object sender, EventArgs e)
{
Hotelfrm frm = new Hotelfrm();
frm.ShowDialog();
if (frm.DialogResult == System.Windows.Forms.DialogResult.OK)
{
cbbHotel_Load(KhachSan.All());
}
}
public ActionResult them_khach_san(KhachSan KhachSanData)
{
bool temp = ivivuDB.thenKhachSan(KhachSanData);
if (!temp)
{
return(RedirectToAction("them_khach_san", "QuanTri"));
}
return(RedirectToAction("Index", "QuanTri"));
}
public ActionResult Edit([Bind(Include = "ID,TenKhachSan,UnsignedName,DiaChi,XepHang,SoDienThoai,ThongTinLienHe,GiaTien,UuTien,ThongTinMoTa,TienIch,ChinhSach,QuanHuyen_ID,GoogleMap")] KhachSan khachSan)
{
if (ModelState.IsValid)
{
db.Entry(khachSan).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.QuanHuyen_ID = new SelectList(db.QuanHuyens, "ID", "TenQuanHuyen", khachSan.QuanHuyen_ID);
return(View(khachSan));
}
public ActionResult thong_tin_khach_san(string id1)
{
KhachSan khachSan = ivivuDB.timKhachSan(id1);
if (khachSan == null)
{
return(RedirectToAction("tim_khach_san", "KhachHang"));
}
ViewBag.roomClassColl = ivivuDB.timLoaiPhongTheoKhachSan(id1);
return(View(khachSan));
}
private KhachSan controls_Load()
{
KhachSan ks = new KhachSan();
ks.ID = Code;
ks.TenKS = txtName.Text;
ks.SoSao = MyConvert.ToInt32(txtStartNumber.Text);
ks.SoDienThoai = txtPhone.Text;
ks.DiaChi = txtAddress.Text;
return(ks);
}
private KhachSan control_LoadUp()
{
KhachSan result = new KhachSan();
result.ID = Code;
result.TenKS = txtName.Text;
result.SoSao = MyConvert.ToDouble(txtStartNumber.Text);
result.SoDienThoai = txtPhone.Text;
result.DiaChi = txtAddress.Text;
return(result);
}
private void toolStripMenuItem1_Click(object sender, EventArgs e)
{
Hotelsfrm frm = new Hotelsfrm();
frm.Powers = this.Powers;
frm.ShowDialog();
if (lvTours.SelectedItems.Count > 0)
{
int _MaTour = MyConvert.ToInt32(lvTours.SelectedItems[0].SubItems[0].Text);
lvHotels_Load(KhachSan.FindByMTour(_MaTour));
}
}
private void controls_LoadUp()
{
KhachSan ks = KhachSan.Single(Code);
txtCode.Text = ks.ID.ToString();
txtName.Text = ks.TenKS;
txtStartNumber.Text = ks.SoSao.ToString();
txtPhone.Text = ks.SoDienThoai;
txtAddress.Text = ks.DiaChi;
clbclbright_Load(DiemDL.FindByMaKS(Code));
clbleft_Load(DiemDL.FindByNotMaKS(Code));
}
public ActionResult XoaKhachsan(int id)
{
KhachSan ksan = db.KhachSans.SingleOrDefault(model => model.MaKhachSan == id);
ViewBag.MaKhachSan = ksan.MaKhachSan;
if (ksan == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(ksan));
}
public bool CapNhat(KhachSan entity)
{
var khachsan = db.KhachSans.Find(entity.ID);
khachsan.TenKhachSan = entity.TenKhachSan;
khachsan.DiaChi = entity.DiaChi;
khachsan.DonGia = entity.DonGia;
khachsan.Images = entity.Images;
khachsan.TinhTrang = entity.TinhTrang;
khachsan.LoaiKhachSan = entity.LoaiKhachSan;
db.SaveChanges();
return(true);
}
