//đặt tour tự chọn
public void DatTourTuChon(TourTuChonValidation validation)
{
var ks = _db.KhachSans.FirstOrDefault(n => n.ID == validation.ID);
var kh = _db.Khachhangs.FirstOrDefault(k => k.Cmnd == validation.Cmnd);
if (kh == null)
{
KhachhangViewModel khs = new KhachhangViewModel
{
Hoten = validation.Hoten,
Cmnd = validation.Cmnd,
Diachi = validation.Diachi,
Sdt = validation.Sdt,
Email = validation.Email
};
var newKH = new Khachhang(khs);
_db.Khachhangs.Add(newKH);
_db.SaveChanges();
HoadonViewModel hd = new HoadonViewModel
{
Ngaylaphd = DateTime.Now,
Ptthanhtoan = "Thanh toán online",
Tongtien = validation.Tongtien,
Tinhtrang = 0,
KhachhangID = newKH.ID
};
var newHD = new Hoadon(hd);
_db.Hoadons.Add(newHD);
_db.SaveChanges();
CTHoadonTuChonViewModel cthd = new CTHoadonTuChonViewModel()
{
Ngaynhan = validation.Ngaynhan,
Ngaytra = validation.Ngaytra,
Sophong = validation.Sophong,
Sogiuongthem = validation.Sogiuongthem,
Sotreem = validation.Sotreem,
Hoten = validation.Hoten,
Sdt = validation.Sdt,
Email = validation.Email,
Ghichu = validation.Ghichu,
Hoadoncode = RandomString(),
KhachsanID = ks.ID,
HoadonID = newHD.ID
};
var newCTHD = new CTHoadonTuChon(cthd);
_db.CTHoadonTuChons.Add(newCTHD);
_db.SaveChanges();
//send mail
var webRoot = _hostingEnvironment.WebRootPath;
var body = string.Empty;
var pathToFile = _hostingEnvironment.WebRootPath
+ Path.DirectorySeparatorChar.ToString()
+ "templates"
+ Path.DirectorySeparatorChar.ToString()
+ "email"
+ Path.DirectorySeparatorChar.ToString()
+ "bookingtourtuchon.html";
using (StreamReader reader = new StreamReader(pathToFile))
{
body = reader.ReadToEnd();
}
body = body.Replace("{{hoadoncode}}", cthd.Hoadoncode);
body = body.Replace("{{ngaylaphd}}", hd.Ngaylaphd.ToShortDateString());
body = body.Replace("{{hoten}}", validation.Hoten);
body = body.Replace("{{email}}", validation.Email);
body = body.Replace("{{sogiuongthem}}", validation.Sogiuongthem.ToString());
body = body.Replace("{{sdt}}", validation.Sdt);
body = body.Replace("{{tinhtrang}}", "chưa thanh toán");
body = body.Replace("{{ghichu}}", validation.Ghichu);
body = body.Replace("{{tenks}}", ks.Tenks);
body = body.Replace("{{diachi}}", ks.Diachi);
body = body.Replace("{{ngaynhanphong}}", validation.Ngaynhan.ToShortDateString());
body = body.Replace("{{ngaytraphong}}", validation.Ngaytra.ToShortDateString());
body = body.Replace("{{loaiphong}}", ks.Loaiphong);
body = body.Replace("{{sophong}}", validation.Sophong.ToString());
body = body.Replace("{{gia}}", ks.Gia.ToString());
body = body.Replace("{{giaphuthu}}", ks.Giaphuthu.ToString());
body = body.Replace("{{sotreem}}", validation.Sotreem.ToString());
body = body.Replace("{{giatreem}}", ks.Giatreem.ToString());
body = body.Replace("{{tongtien}}", validation.Tongtien.ToString());
var mailHelper = new MailHelpers();
mailHelper.SendMail(validation.Email, "Thông tin booking tour tự chọn", body);
}
else
{
HoadonViewModel hd = new HoadonViewModel
{
Ngaylaphd = DateTime.Now,
Ptthanhtoan = "Thanh toán online",
Tongtien = validation.Tongtien,
Tinhtrang = 0,
KhachhangID = kh.ID
};
var newHD = new Hoadon(hd);
_db.Hoadons.Add(newHD);
_db.SaveChanges();
CTHoadonTuChonViewModel cthd = new CTHoadonTuChonViewModel()
{
Ngaynhan = validation.Ngaynhan,
Ngaytra = validation.Ngaytra,
Sophong = validation.Sophong,
Sogiuongthem = validation.Sogiuongthem,
Sotreem = validation.Sotreem,
Hoten = validation.Hoten,
Sdt = validation.Sdt,
Email = validation.Email,
Ghichu = validation.Ghichu,
Hoadoncode = RandomString(),
KhachsanID = ks.ID,
HoadonID = newHD.ID
};
var newCTHD = new CTHoadonTuChon(cthd);
_db.CTHoadonTuChons.Add(newCTHD);
_db.SaveChanges();
//send mail
var webRoot = _hostingEnvironment.WebRootPath;
var body = string.Empty;
var pathToFile = _hostingEnvironment.WebRootPath
+ Path.DirectorySeparatorChar.ToString()
+ "templates"
+ Path.DirectorySeparatorChar.ToString()
+ "email"
+ Path.DirectorySeparatorChar.ToString()
+ "bookingtourtuchon.html";
using (StreamReader reader = new StreamReader(pathToFile))
{
body = reader.ReadToEnd();
}
body = body.Replace("{{hoadoncode}}", cthd.Hoadoncode);
body = body.Replace("{{ngaylaphd}}", hd.Ngaylaphd.ToShortDateString());
body = body.Replace("{{hoten}}", validation.Hoten);
body = body.Replace("{{email}}", validation.Email);
body = body.Replace("{{sogiuongthem}}", validation.Sogiuongthem.ToString());
body = body.Replace("{{sdt}}", validation.Sdt);
body = body.Replace("{{tinhtrang}}", "chưa thanh toán");
body = body.Replace("{{ghichu}}", validation.Ghichu);
body = body.Replace("{{tenks}}", ks.Tenks);
body = body.Replace("{{diachi}}", ks.Diachi);
body = body.Replace("{{ngaynhanphong}}", validation.Ngaynhan.ToShortDateString());
body = body.Replace("{{ngaytraphong}}", validation.Ngaytra.ToShortDateString());
body = body.Replace("{{loaiphong}}", ks.Loaiphong);
body = body.Replace("{{sophong}}", validation.Sophong.ToString());
body = body.Replace("{{gia}}", ks.Gia.ToString());
body = body.Replace("{{giaphuthu}}", ks.Giaphuthu.ToString());
body = body.Replace("{{sotreem}}", validation.Sotreem.ToString());
body = body.Replace("{{giatreem}}", ks.Giatreem.ToString());
body = body.Replace("{{tongtien}}", validation.Tongtien.ToString());
var mailHelper = new MailHelpers();
mailHelper.SendMail(validation.Email, "Thông tin booking tour tự chọn", body);
}
}
public void DatTourMienTrung(DatTourValidation validation)
{
var tour = _db.Tours.FirstOrDefault(n => n.ID == validation.TourID);
var kh = _db.Khachhangs.FirstOrDefault(n => n.Cmnd == validation.Cmnd);
if (kh == null)
{
var newKH = new Khachhang(validation);
_db.Khachhangs.Add(newKH);
_db.SaveChanges();
//thêm thông tin tour miền Trung
//thêm hóa đơn
HoadonViewModel hd = new HoadonViewModel
{
KhachhangID = newKH.ID,
Ngaylaphd = DateTime.Now,
Ptthanhtoan = validation.Ptthanhtoan,
Tongtien = validation.Tongtien,
Ghichu = validation.Ghichu
};
var newHD = new Hoadon(hd);
_db.Hoadons.Add(newHD);
_db.SaveChanges();
if (tour.Songuoi > 1)
{
tour.Songuoi = tour.Songuoi - validation.Songuoidi;
_db.SaveChanges();
}
else
{
tour.Songuoi = tour.Songuoi - validation.Songuoidi;
tour.Trangthai = "hết chỗ";
_db.SaveChanges();
}
//thêm chi tiết hóa đơn
CTHoadonTrungViewModel cthd = new CTHoadonTrungViewModel
{
Hotenkhachhang = newKH.Hoten,
Sdt = newKH.Sdt,
Email = newKH.Email,
Hoadoncode = RandomString(),
Songuoidi = validation.Songuoidi,
HoadonID = newHD.ID,
TourID = tour.ID
};
var newCTHD = new CTHoadonTrung(cthd);
_db.CTHoadonTrungs.Add(newCTHD);
_db.SaveChanges();
//send mail
var webRoot = _hostingEnvironment.WebRootPath;
var body = string.Empty;
var pathToFile = _hostingEnvironment.WebRootPath
+ Path.DirectorySeparatorChar.ToString()
+ "templates"
+ Path.DirectorySeparatorChar.ToString()
+ "email"
+ Path.DirectorySeparatorChar.ToString()
+ "bookingdetail.html";
using (StreamReader reader = new StreamReader(pathToFile))
{
body = reader.ReadToEnd();
}
body = body.Replace("{{TourName}}", tour.Tentour);
body = body.Replace("{{Code}}", tour.Code);
body = body.Replace("{{Noixuatphat}}", tour.Diadiemkhoihanh);
body = body.Replace("{{Diemden}}", tour.Diemden);
body = body.Replace("{{Ngaydi}}", tour.Ngaydi.ToString());
//body = body.Replace("{{Ngayve}}", tour.Ngayve.ToString());
body = body.Replace("{{Sobooking}}", cthd.Hoadoncode);
body = body.Replace("{{Tongtien}}", hd.Tongtien.ToString());
body = body.Replace("{{Ngaydangky}}", hd.Ngaylaphd.ToString());
body = body.Replace("{{Hinhthucthanhtoan}}", hd.Ptthanhtoan);
body = body.Replace("{{Thoihanthanhtoan}}", "Vui lòng thanh toán trước khi tour khởi hành 3 ngày");
body = body.Replace("{{Hoten}}", validation.Hoten);
body = body.Replace("{{Diachi}}", validation.Diachi);
body = body.Replace("{{Sdt}}", validation.Sdt);
body = body.Replace("{{Email}}", validation.Email);
body = body.Replace("{{Songuoidi}}", validation.Songuoidi.ToString());
var mailHelper = new MailHelpers();
mailHelper.SendMail(validation.Email, "Thông tin booking tour", body);
}
else
{
//thêm thông tin tour miền Trung
//thêm hóa đơn
HoadonViewModel hd = new HoadonViewModel
{
KhachhangID = kh.ID,
Ngaylaphd = DateTime.Now,
Ptthanhtoan = validation.Ptthanhtoan,
Tongtien = validation.Tongtien,
Ghichu = validation.Ghichu
};
var newHD = new Hoadon(hd);
_db.Hoadons.Add(newHD);
_db.SaveChanges();
if (tour.Songuoi > 1)
{
tour.Songuoi = tour.Songuoi - validation.Songuoidi;
_db.SaveChanges();
}
else
{
tour.Songuoi = tour.Songuoi - validation.Songuoidi;
tour.Trangthai = "hết chỗ";
_db.SaveChanges();
}
//thêm chi tiết hóa đơn
CTHoadonTrungViewModel cthd = new CTHoadonTrungViewModel();
cthd.Hotenkhachhang = kh.Hoten;
cthd.Sdt = kh.Sdt;
cthd.Email = kh.Email;
cthd.Hoadoncode = RandomString();
cthd.Songuoidi = validation.Songuoidi;
cthd.HoadonID = newHD.ID;
cthd.TourID = tour.ID;
var newCTHD = new CTHoadonTrung(cthd);
_db.CTHoadonTrungs.Add(newCTHD);
_db.SaveChanges();
//send mail
var webRoot = _hostingEnvironment.WebRootPath;
var body = string.Empty;
var pathToFile = _hostingEnvironment.WebRootPath
+ Path.DirectorySeparatorChar.ToString()
+ "templates"
+ Path.DirectorySeparatorChar.ToString()
+ "email"
+ Path.DirectorySeparatorChar.ToString()
+ "bookingdetail.html";
using (StreamReader reader = new StreamReader(pathToFile))
{
body = reader.ReadToEnd();
}
body = body.Replace("{{TourName}}", tour.Tentour);
body = body.Replace("{{Code}}", tour.Code);
body = body.Replace("{{Noixuatphat}}", tour.Diadiemkhoihanh);
body = body.Replace("{{Diemden}}", tour.Diemden);
body = body.Replace("{{Ngaydi}}", tour.Ngaydi.ToString());
//body = body.Replace("{{Ngayve}}", tour.Ngayve.ToString());
body = body.Replace("{{Sobooking}}", cthd.Hoadoncode);
body = body.Replace("{{Tongtien}}", hd.Tongtien.ToString());
body = body.Replace("{{Ngaydangky}}", hd.Ngaylaphd.ToString());
body = body.Replace("{{Hinhthucthanhtoan}}", hd.Ptthanhtoan);
//int day = hd.Ngaylaphd.Date + 7;
body = body.Replace("{{Thoihanthanhtoan}}", "N/A");
body = body.Replace("{{Hoten}}", validation.Hoten);
body = body.Replace("{{Diachi}}", validation.Diachi);
body = body.Replace("{{Sdt}}", validation.Sdt);
body = body.Replace("{{Email}}", validation.Email);
body = body.Replace("{{Songuoidi}}", validation.Songuoidi.ToString());
var mailHelper = new MailHelpers();
mailHelper.SendMail(validation.Email, "Thông tin booking tour", body);
}
}