//lấy thông tin hóa đơn đặt tour miền Bắc public CTHoadonBac GetCTHoaDonTourMienBac() { var cthd = new CTHoadonBac(); using (var conn = new SqlConnection(this._db.Database.GetDbConnection().ConnectionString)) { conn.Open(); cthd = conn.Query <CTHoadonBac>(@"select top 1 * from CTHoadonBac order by ID desc").FirstOrDefault(); conn.Close(); } return(cthd); }
//hủy tour miền Bắc public CTHoadonBac HuyBookingTourMienBac(int id) { var result = new CTHoadonBac(); using (var conn = new SqlConnection(this._db.Database.GetDbConnection().ConnectionString)) { conn.Open(); result = conn.Query <CTHoadonBac>(@"select * from CTHoadonBac join Tour on CTHoadonBac.TourID = Tour.ID join Hoadon on CTHoadonBac.HoadonID = Hoadon.ID join KhachHang on Hoadon.KhachhangID = Khachhang.ID where CTHoadonBac.ID= " + id).FirstOrDefault(); conn.Close(); } return(result); }
public void DatTourMienBac(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 Bắc //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 CTHoadonBacViewModel cthd = new CTHoadonBacViewModel { Hotenkhachhang = newKH.Hoten, Sdt = newKH.Sdt, Email = newKH.Email, Hoadoncode = RandomString(), Songuoidi = validation.Songuoidi, HoadonID = newHD.ID, TourID = tour.ID }; var newCTHD = new CTHoadonBac(cthd); _db.CTHoadonBacs.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}}", "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 Bắc //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 CTHoadonBacViewModel cthd = new CTHoadonBacViewModel { Hotenkhachhang = kh.Hoten, Sdt = kh.Sdt, Email = kh.Email, Hoadoncode = RandomString(), Songuoidi = validation.Songuoidi, HoadonID = newHD.ID, TourID = tour.ID }; var newCTHD = new CTHoadonBac(cthd); _db.CTHoadonBacs.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}}", "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); } }