void SetBooking(WCFStandards AEAGDataBase, String BookableUnitsID,
DateTime BookedFor, String SetTo, DateTime BookingDateTime)
{
DataSet Bookings = AEAGDataBase.GetCommonDataSet (String.Format
("Select * from Booking where BookableUnitsID = '{0}' and BookedFor = {1}",
BookableUnitsID, TransportData.GetSQLFormattedDateTime(BookedFor)));
if (String.IsNullOrEmpty (SetTo))
{
if (Bookings.Tables ["Booking"].Rows.Count == 0)
return;
Bookings.Tables ["Booking"].Rows [0].Delete ();
}
else
{
DataRow RowToProcess;
if (Bookings.Tables ["Booking"].Rows.Count == 0)
{
RowToProcess = Bookings.Tables ["Booking"].NewRow ();
RowToProcess ["ID"] = System.Guid.NewGuid ();
RowToProcess ["BookableUnitsID"] = BookableUnitsID;
RowToProcess ["BookedFor"] = BookedFor;
Bookings.Tables ["Booking"].Rows.Add (RowToProcess);
}
else
{
RowToProcess = Bookings.Tables ["Booking"].Rows [0];
}
RowToProcess ["BookingStatus"] = SetTo;
RowToProcess ["BookingDateTime"] = BookingDateTime;
}
AEAGDataBase.SetCommonDataSet (Bookings);
}