public PersonalisationState(BookingSummary booking)
{
// Add Error checking to ensure booking.UserType, UserRole or others are not null
this.UserType = booking.UserType;
this.UserRole = booking.UserRole;
this.BookingPeriod = booking.BookingPeriod;
}
public PersonalisationState(BookingSummary booking)
{
// Add Error checking to ensure booking.UserType, UserRole or others are not null
this.UserType = new UserType() { userType = booking.UserType };
this.UserRole = new UserRole() { roleName = booking.UserRole };
this.BookingPeriod = new BookingPeriod() {periodName = booking.BookingPeriod};
}
public async Task <JsonResult> Get([FromQuery] int id)
{
IExecutionContext executionContext = await ExecutionContextFactory.CreateAsync();
PermissionValidationService.EnforceCustomEntityPermission <CustomEntityReadPermission>(BookingCustomEntityDefinition.DefinitionCode, executionContext.UserContext);
BookingSummary booking = await BookingProvider.GetBookingSummaryById(id);
return(ApiResponseHelper.SimpleQueryResponse(booking));
}
public PersonalisationState(BookingSummary booking)
{
if (booking == null)
{
return;
}
UserRole = UserRole.Parse(booking.UserRole);
UserType = new UserType(booking.UserType);
BookingPeriod = new BookingPeriod {
BookingPeriodType = booking.BookingPeriod
};
}
public async Task <BookingMail> CreateBookingMail(int bookingId, string templateName)
{
BookingSummary booking = await BookingProvider.GetBookingSummaryById(bookingId);
if (booking == null)
{
return(null);
}
TemplateDataModel template = await TemplateProvider.GetTemplateByName(templateName);
string message = TemplateProvider.MergeText(template.Text, booking);
return(new BookingMail
{
Description = template.Description,
To = new MailAddress(booking.ContactEMail, booking.ContactName),
Subject = template.Subject,
Message = message
});
}
protected void Page_Load(object sender, EventArgs e)
{
// if Session Customer variable is not null then assign it
// to a Customer object and set up a Razor variable for customer name.
if (Session["Customer"] != null)
{
cust = (Customer)Session["Customer"];
custName = $"{cust.CustFirstName} {cust.CustLastName}";
}
else
{
Response.Redirect("~/login.aspx");
}
if (!IsPostBack) // on first time page load
{
// populate Package, Booking and BookingDetail Lists from database
packages = PackageDB.GetAllPackages();
bookings = BookingDB.GetAllBookings();
bookingDetails = BookingDetailDB.GetAllBookingDetails();
// Two table LINQ join to extract relevant Fields for display in the
// Customer Orders table. This selection is customizable depending on
// what the clients would like to have displayed in the Customer Orders
// table. Fields are stored in BookingSummary objects.
List <BookingSummary> bookSummary =
(from b in bookings
join bd in bookingDetails on b.BookingId equals bd.BookingId
where b.CustomerId == cust.CustomerId
select new BookingSummary // assign the Linq results to a List of BookingSummary objects.
{
BookingNo = b.BookingNo,
BookingDate = ((DateTime)(b.BookingDate)).ToString("d"),
Description = bd.Description,
TripStartDate = ((DateTime)bd.TripStart).ToString("d"),
TripEndDate = ((DateTime)bd.TripEnd).ToString("d"),
BBasePrice = ((decimal)(bd.BasePrice)).ToString("c"),
BAgencyCommission = ((decimal)(bd.AgencyCommission)).ToString("c"),
Total = ((decimal)(bd.BasePrice + bd.AgencyCommission)).ToString("c")
}).ToList();
bool isEmpty = !bookSummary.Any();
if (!isEmpty) // if there are Travel Products, execute the following block
{
bookS = true;
// iterate through the BookingSummary List to calculate column
// totals for Price, Commission and Total
decimal totBase1 = 0.0m;
decimal totComm1 = 0.0m;
decimal totTotl1 = 0.0m;
foreach (BookingSummary book in bookSummary) // iterate throught the list to calculate totals
{
string temp = "";
temp = (book.BBasePrice).Remove(0, 1); // remove dollar sign prior to parsing text to decimal
totBase1 += decimal.Parse(temp); // calculate running total for Base Price
temp = (book.BAgencyCommission).Remove(0, 1);
totComm1 += decimal.Parse(temp);
temp = (book.Total).Remove(0, 1);
totTotl1 += decimal.Parse(temp);
}
// sort the BookingSummary List by descending date
List <BookingSummary> newList = bookSummary.OrderByDescending(b => b.BookingDate).ToList();
// Build a dummy BookingSummary Record for the last Totals line in the GridView
BookingSummary book1 = new BookingSummary();
book1.BookingNo = "";
book1.BookingDate = "";
book1.Description = "";
book1.TripStartDate = "";
book1.TripEndDate = "Totals";
book1.BBasePrice = totBase1.ToString("c");
book1.BAgencyCommission = totComm1.ToString("c");
book1.Total = totTotl1.ToString("c");
newList.Add(book1); // add the Totals line to the List
gvwTravelData.DataSource = newList; // assign list as data source
gvwTravelData.DataBind(); // bind the GridView data
int rowCount = gvwTravelData.Rows.Count;
// format the Total row
gvwTravelData.Rows[rowCount - 1].Cells[4].Font.Bold = true;
gvwTravelData.Rows[rowCount - 1].Cells[5].Font.Bold = true;
gvwTravelData.Rows[rowCount - 1].Cells[6].Font.Bold = true;
gvwTravelData.Rows[rowCount - 1].Cells[7].Font.Bold = true;
gvwTravelData.HeaderRow.HorizontalAlign = HorizontalAlign.Center;
}
// Use a LINQ query to join the Bookings and Packages tables and poulate
// a list of BookingSummary objects for Travel Packages.
List <BookingSummary> packSummary =
(from b in bookings
join p in packages on b.PackageId equals p.PackageId
where b.CustomerId == cust.CustomerId
select new BookingSummary
{
BookingNo = b.BookingNo.ToString(),
BookingDate = ((DateTime)(b.BookingDate)).ToString("d"),
Description = p.PkgDesc,
TripStartDate = ((DateTime)p.PkgStartDate).ToString("d"),
TripEndDate = ((DateTime)p.PkgEndDate).ToString("d"),
BBasePrice = ((decimal)(p.PkgBasePrice)).ToString("c"),
BAgencyCommission = ((decimal)(p.PkgAgencyCommission)).ToString("c"),
Total = ((decimal)(p.PkgBasePrice + p.PkgAgencyCommission)).ToString("c")
}).ToList();
isEmpty = !packSummary.Any();
if (isEmpty)
{
return;
}
packS = true;
// iterate through the BookingSummary List to calculate column
// totals for Price, Commission and Total
decimal totBase = 0.0m;
decimal totComm = 0.0m;
decimal totTotl = 0.0m;
foreach (BookingSummary pack in packSummary)
{
string temp = "";
temp = (pack.BBasePrice).Remove(0, 1);
totBase += decimal.Parse(temp);
temp = (pack.BAgencyCommission).Remove(0, 1);
totComm += decimal.Parse(temp);
temp = (pack.Total).Remove(0, 1);
totTotl += decimal.Parse(temp);
}
//Build a dummy BookingSummary Record for the last Totals line in the table
BookingSummary pack1 = new BookingSummary();
pack1.BookingNo = "";
pack1.BookingDate = "";
pack1.Description = "";
pack1.TripEndDate = "";
pack1.TripEndDate = "Totals";
pack1.BBasePrice = totBase.ToString("c");
pack1.BAgencyCommission = totComm.ToString("c");
pack1.Total = totTotl.ToString("c");
packSummary.Add(pack1);
if (packSummary != null)
{
packS = true;
}
gvwTravelData1.DataSource = packSummary; // assign Package list to GridView datasource
gvwTravelData1.DataBind(); // bind the GridView data
int rowCount1 = gvwTravelData1.Rows.Count;
// format the Totals Row
gvwTravelData1.Rows[rowCount1 - 1].Cells[4].Font.Bold = true;
gvwTravelData1.Rows[rowCount1 - 1].Cells[5].Font.Bold = true;
gvwTravelData1.Rows[rowCount1 - 1].Cells[6].Font.Bold = true;
gvwTravelData1.Rows[rowCount1 - 1].Cells[7].Font.Bold = true;
}
}
