private void RefreshBookingFinancialTransactions()
{
BookingSearchService bookingFinancialTransactions = new BookingSearchService();
BindingSource bindingSource = new BindingSource();
try {
bindingSource.DataSource =
bookingFinancialTransactions.BookingFinancialTransactions(
_bookingContract.Booking.BookingId
);
dataGridViewBookingFinancialTransactions.AutoGenerateColumns = true;
dataGridViewBookingFinancialTransactions.DataSource = bindingSource;
dataGridViewBookingFinancialTransactions.AutoResizeColumns();
// select last (totals) row
dataGridViewBookingFinancialTransactions.Rows[0].Selected = false;
dataGridViewBookingFinancialTransactions.Rows[dataGridViewBookingFinancialTransactions.Rows.Count - 1].Selected = true;
dataGridViewBookingFinancialTransactions.Refresh();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
bookingFinancialTransactions.Close();
}
}
private void RefreshBookingFinancialPayments()
{
BookingSearchService bookingFinancialPayments = new BookingSearchService();
BindingSource bindingSource = new BindingSource();
try {
bindingSource.DataSource = bookingFinancialPayments.BookingFinancialPayments(_bookingContract.Booking.BookingId);
dataGridViewBookingFinancialPayments.AutoGenerateColumns = true;
dataGridViewBookingFinancialPayments.DataSource = bindingSource;
dataGridViewBookingFinancialPayments.AutoResizeColumns();
dataGridViewBookingFinancialPayments.Refresh();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
bookingFinancialPayments.Close();
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
BookingSearchService bookingsOpen = new BookingSearchService();
BindingSource bindingSource = new BindingSource();
try {
bindingSource.DataSource = bookingsOpen.BookingsOpen();
gridBookingsOpen.AutoGenerateColumns = true;
gridBookingsOpen.DataSource = bindingSource;
gridBookingsOpen.AutoResizeColumns();
gridBookingsOpen.Refresh();
} catch (Exception ex) {
Singleton.Instance.Error(ex);
MessageBox.Show(ex.Message);
} finally {
bookingsOpen.Close();
}
}
public void ShowAsEdit(System.Guid bookingPassengerId)
{
var service = new BookingSearchService();
_isNew = false;
try {
_contract = service.BookingPassengerWithExtra(bookingPassengerId);
passengerTypeRefCombo.Text = _contract.PassengerTypeRcd != null ? _contract.PassengerTypeRcd : String.Empty;
textBoxPassengerName.Text = _contract.PassengerName;
defaultStateRefCombo.Text = _contract.DefaultStateRcd;
userPicker.SelectedValue = _contract.UserId;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
Show();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
service.Close();
}
}
public ActionResult BookingStatisticsIndex()
{
Logging.ActionLog(Request, "BookingStatisticsIndex ( ASP MVC WCF )");
DateTime fromDateTime = DateTime.UtcNow.AddDays(-20);
DateTime untilDateTime = DateTime.UtcNow.AddDays(+20);
List <BookingStatisticsContract> statistics =
new BookingSearchService().BookingStatistics(
Guid.Empty,
Guid.Empty,
fromDateTime,
untilDateTime
);
// create a collection of data
var statisticsCounts = new List <BookingStatistics>();
foreach (BookingStatisticsContract contract in statistics)
{
statisticsCounts.Add(
new BookingStatistics()
{
Day = contract.Date.ToString("yyyyMMdd"),
Passengers = contract.PassengersBookedCount,
Adults = contract.AdultBookedCount,
Childs = contract.ChildBookedCount,
Infants = contract.InfantBookedCount
}
);
}
// modify data type to make it of array type
var xDataMonths = statisticsCounts.Select(i => i.Day).ToArray();
var yDataPassengers = statisticsCounts.Select(i => new object[] { i.Passengers }).ToArray();
var yDataAdults = statisticsCounts.Select(i => new object[] { i.Adults }).ToArray();
var yDataChildren = statisticsCounts.Select(i => new object[] { i.Childs }).ToArray();
var yDataInfants = statisticsCounts.Select(i => new object[] { i.Infants }).ToArray();
// instantiate an object of the High charts type
var chart = new Highcharts("chart")
// define the type of chart
.InitChart(new Chart {
DefaultSeriesType = ChartTypes.Line
})
// overall Title of the chart
.SetTitle(new Title {
Text = "nor-port"
})
// small label below the main Title
.SetSubtitle(new Subtitle {
Text = "Bookings from " + fromDateTime.ToShortDateString() + " until " + untilDateTime.ToShortDateString()
})
// load the X values
.SetXAxis(new XAxis {
Categories = xDataMonths
})
// set the Y title
.SetYAxis(new YAxis {
Title = new YAxisTitle {
Text = "Bookings"
}
})
.SetYAxis(new YAxis {
Title = new YAxisTitle {
Text = "Adults"
}
})
.SetYAxis(new YAxis {
Title = new YAxisTitle {
Text = "Children"
}
})
.SetYAxis(new YAxis {
Title = new YAxisTitle {
Text = "Infants"
}
})
.SetTooltip(
new Tooltip {
Enabled = true,
Formatter = @"function() { return '<b>'+ this.series.name +'</b><br/>'+ this.x +': '+ this.y; }"
})
.SetPlotOptions(new PlotOptions {
Line = new PlotOptionsLine {
DataLabels = new PlotOptionsLineDataLabels {
Enabled = true
},
EnableMouseTracking = false
}
})
// load the Y values
.SetSeries(new[]
{ new Series {
Name = "Bookings", Data = new Data(yDataPassengers)
},
new Series {
Name = "Adults", Data = new Data(yDataAdults)
},
new Series {
Name = "Children", Data = new Data(yDataChildren)
},
new Series {
Name = "Infants", Data = new Data(yDataInfants)
} });
return(View(chart));
}
