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));
}
