public ActionResult Export(long id, long packid) { dalMstTourPackageActivity dbAct = new dalMstTourPackageActivity(); dalMstTourPackage dbTour = new dalMstTourPackage(); dalTourPackageBooking dbBook = new dalTourPackageBooking(); MstBookingExportModel obj = new MstBookingExportModel(); obj.MstTourActivityList = dbAct.MstTourPackageActivityList(packid); obj.MstTourPackages = dbTour.MstTourPackageView(packid); obj.MstTourBooking = dbBook.GetBookingByID(id); ViewBag.WordDocumentFilename = obj.MstTourPackages.PackageName; return(View("Export", obj)); }
public ActionResult BookingRequest(MstPackageGeneralViewModel model) { System.Configuration.Configuration config = WebConfigurationManager.OpenWebConfiguration(System.Web.HttpContext.Current.Request.ApplicationPath); MailSettingsSectionGroup settings = (MailSettingsSectionGroup)config.GetSectionGroup("system.net/mailSettings"); System.Net.NetworkCredential credential = new System.Net.NetworkCredential(settings.Smtp.Network.UserName, settings.Smtp.Network.Password); //Create the SMTP Client SmtpClient client = new SmtpClient(); client.Host = settings.Smtp.Network.Host; client.Credentials = credential; client.Timeout = 300000; client.EnableSsl = false; dalTourPackageBooking dbBook = new dalTourPackageBooking(); model.MstPackageBooking.PackageID = model.MstTourPackage.PackageID; DateTime Arrdate = model.MstPackageBooking.ArrivalDate; DateTime Departuredate = model.MstPackageBooking.DepartureDate; string tempdt = Arrdate.ToString("dd MMM yyyy"); string Deptdt = Departuredate.ToString("dd MMM yyyy"); model.MstPackageBooking.ArrivalDate = DateTime.ParseExact(tempdt, "dd MMM yyyy", CultureInfo.InvariantCulture); model.MstPackageBooking.DepartureDate = DateTime.ParseExact(Deptdt, "dd MMM yyyy", CultureInfo.InvariantCulture); DateTime Currdate = DateTime.Today; string tempdate = Currdate.ToString("dd MMM yyyy"); string Depdate = Currdate.ToString("dd MMM yyyy"); DateTime NewCurrDate = DateTime.ParseExact(tempdate, "dd MMM yyyy", CultureInfo.InvariantCulture); DateTime DepartureDate = DateTime.ParseExact(Depdate, "dd MMM yyyy", CultureInfo.InvariantCulture); if (ModelState.IsValid) { MailMessage mail = new MailMessage(); StringBuilder mailbody = new StringBuilder(); mail.From = new MailAddress("*****@*****.**", "Pandim Tours & Travel"); //mail.To.Add("*****@*****.**"); mail.To.Add(model.MstPackageBooking.ClientEmailID); mail.Priority = MailPriority.High; mail.ReplyToList.Add("*****@*****.**"); mail.CC.Add("*****@*****.**"); mail.Subject = "Booking Request for Tour Package: " + model.MstTourPackage.PackageName; mailbody.AppendLine("Thank You for your Booking Request for the Tour Package: <b>" + model.MstTourPackage.PackageName + "</b>.<br/> We will get Back to you with further details as soon as possible."); string packdetails = MakeMailBody(model.MstTourPackage.PackageID); mailbody.Append(packdetails); mailbody.Append("<h4>Personal Details</h4>"); mailbody.Append("Name: " + model.MstPackageBooking.ClientName + "<br/>Total number of people: " + model.MstPackageBooking.AdultPax + " Adults / " + model.MstPackageBooking.ChildPax + " Child / " + model.MstPackageBooking.InfantPax + " Infants.<br/>"); mailbody.Append("Arrival Date: " + model.MstPackageBooking.ArrivalDate.ToString("dd MMM yyyy") + "<br/>Contact No: " + model.MstPackageBooking.ClientContactNo); mailbody.Append("Arrival Date: " + model.MstPackageBooking.DepartureDate.ToString("dd MMM yyyy")); mailbody.AppendLine("<br/>Requirement: " + model.MstPackageBooking.ClientRequirement); mailbody.Append("<br/>Please check your mail for regular updates from us."); mail.Body = mailbody.ToString(); mail.IsBodyHtml = true; try { client.Send(mail); model.MstPackageBooking.BookingDate = NewCurrDate; model.MstPackageBooking.Status = "Not Replied"; dbBook.Save(model.MstPackageBooking); return(RedirectToAction("RequestSuccess", new { id = model.MstTourPackage.PackageID })); } catch (Exception) { TempData["ErrMsg"] = 0; return(RedirectToAction("TourPackageDetails", new { id = model.MstTourPackage.PackageID })); } } dalMstTourPackageActivity dbAct = new dalMstTourPackageActivity(); dalTourPackageMap dbMap = new dalTourPackageMap(); model.MstTourPhotoList = dbPhoto.MstTourPackagePhotoList(model.MstTourPackage.PackageID); model.MstTourPackage = dbTour.MstTourPackageView(model.MstTourPackage.PackageID); model.MstTourActivityList = dbAct.MstTourPackageActivityList(model.MstTourPackage.PackageID); model.MstTourMap = dbMap.GetTourMapByID(model.MstTourPackage.PackageID); return(View("TourPackageDetails", model)); }