private string MakeMailBody(long id) { StringBuilder mailbody = new StringBuilder(); dalMstTourPackage dbTour = new dalMstTourPackage(); MstTourPackageView pack = new MstTourPackageView(); pack = dbTour.MstTourPackageView(id); dalMstTourPackageActivity dbActivity = new dalMstTourPackageActivity(); IEnumerable <MstTourPackageActivityView> act = new List <MstTourPackageActivityView>(); act = dbActivity.MstTourPackageActivityList(id); mailbody.Append("<h4>Package Details</h4>"); mailbody.Append("Package Name: " + pack.PackageName + "<br/>Duration: " + pack.TotalDays + " Days / " + (pack.TotalDays - 1) + " Nights<br/>"); mailbody.Append("Package Routing: " + pack.PackageRouting + "<br/>Package Description: " + pack.PackageRemarks); mailbody.Append("<h4>Tour Package Activities</h4>"); mailbody.Append("<table style='width:700px;' border= '1'>"); mailbody.Append("<tr>"); mailbody.Append("<th style='border: 1px solid black'>Day List</th>"); mailbody.Append("<th style='border: 1px solid black'>Activity</th>"); mailbody.Append("<th style='border: 1px solid black'>Overnight Destination</th>"); mailbody.Append("</tr>"); foreach (var item in act) { mailbody.Append("<tr>"); mailbody.Append("<td style='text-align:center;'>Day " + item.DayNo + "</td>"); mailbody.Append("<td style='text-align:center;'>" + item.ActivityTitle + "</td>"); mailbody.Append("<td style='text-align:center;'>" + item.DestinationName + "</td>"); mailbody.Append("</tr>"); } mailbody.Append("</table>"); return(mailbody.ToString()); }
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 TourPackageDetails(long id) { dbTour.RaiseHitCount(id); dalMstTourPackageActivity dbAct = new dalMstTourPackageActivity(); dalTourPackageMap dbMap = new dalTourPackageMap(); MstPackageGeneralViewModel obj = new MstPackageGeneralViewModel(); obj.MstTourPhotoList = dbPhoto.MstTourPackagePhotoList(id); obj.MstTourActivityList = dbAct.MstTourPackageActivityList(id); obj.MstTourPackage = dbTour.MstTourPackageView(id); obj.MstTourMap = dbMap.GetTourMapByID(id); return(View("TourPackageDetails", 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)); }