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 Reply(long id, long packid)
{
MstBookingReplyModel obj = new MstBookingReplyModel();
obj.MstTourBook = dbBook.GetBookingByID(id);
dalMstTourPackage dbPack = new dalMstTourPackage();
MstTourPackageDetailsModel pack = new MstTourPackageDetailsModel();
pack = dbPack.GetTourPackageDetailsByID(packid);
ViewBag.PackageName = pack.PackageName;
return(View(obj));
}
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 Reply(MstBookingReplyModel paramdata)
{
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;
if (ModelState.IsValid)
{
MailMessage mail = new MailMessage();
mail.From = new MailAddress(settings.Smtp.Network.UserName, "Brothers Tours & Travel");
mail.To.Add(paramdata.MstTourBook.ClientEmailID);
mail.Priority = MailPriority.High;
mail.Subject = paramdata.MstMail.Subject;
mail.Body = paramdata.MstMail.MessageBody;
mail.ReplyToList.Add("*****@*****.**");
try
{
client.Send(mail);
paramdata.MstTourBook.Status = "Replied";
dbBook.Save(paramdata.MstTourBook);
TempData["ErrMsg"] = 1;
return(RedirectToAction("list"));
}
catch (Exception ex)
{
TempData["ErrMsg"] = 0;
return(RedirectToAction("list"));
}
}
paramdata.MstTourBook = dbBook.GetBookingByID(paramdata.MstTourBook.BookingID);
MstTourPackageDetailsModel pack = new MstTourPackageDetailsModel();
dalMstTourPackage dbPack = new dalMstTourPackage();
pack = dbPack.GetTourPackageDetailsByID(paramdata.MstTourBook.PackageID);
ViewBag.PackageName = pack.PackageName;
return(View(paramdata));
}
