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 MstTourPackageView MstTourPackageView(long id)
{
MstTourPackageView obj = new MstTourPackageView();
var parPackID = new SqlParameter("@PackID", id);
obj = _db.Database.SqlQuery <MstTourPackageView>("udspMstTourPackageView @PackID", parPackID).FirstOrDefault();
return(obj);
}
