public GetBooking GetBookingById(int id)
{
GetBooking getBooking = new GetBooking();
if (db.Bookings.Any(b => b.BookingID == id))
{
getBooking.booking = db.Bookings.Where(b => b.BookingID == id).First();
getBooking.transactions = db.Transactions.Where(t => t.BookingID == id).ToList();
getBooking.passengers = db.PassengerDetails.Where(p => p.BookingID == id).ToList();
if (getBooking.booking.UserRegistered == 1)
{
getBooking.user = db.Users.Where(u => u.Id == getBooking.booking.UserId).First();
}
else
{
getBooking.guestUser = db.GuestUsers.Where(u => u.Id == getBooking.booking.GuestId).First();
}
getBooking.FromStop = db.TripStops.Where(ts => ts.Stop == getBooking.booking.Boarding && ts.TripId == getBooking.booking.TripId).FirstOrDefault();
getBooking.ToStop = db.TripStops.Where(ts => ts.Stop == getBooking.booking.Arrival && ts.TripId == getBooking.booking.TripId).FirstOrDefault();
getBooking.bus = getBooking.booking.Trip.Bus;
return(getBooking);
}
return(null);
}
public async Task <ActionResult> GetBooking(
long start,
string name = "n/a")
{
var sub = GetUserId();
var query = new GetBooking(sub, start);
var result = await _db.Submit(_creds, query);
var r = result.SingleOrDefault();
if (r == null)
{
return(NotFound());
}
var token = _twilio.GetTwilioToken(name, r.Host.ToString(), r.Start);
if (token == null)
{
_log.LogError("could not generate token with {twilioAccount}", _twilio.AccountSid);
return(StatusCode(500));
}
return(Ok(new AppointmentJson
{
Counterpart = r.Host.ToString(),
Token = token,
Start = r.Start,
Dur = (int)(r.End - r.Start)
}));
}
private void Add()
{
GetBooking c = new GetBooking();
c = _apiRequester.Create(c, "booking");
Items = LoadItems();
//Items.Add(new BookingViewModel(c));
}
private void btnGetBooking_Click(object sender, RoutedEventArgs e)
{
GetBooking dialog = new GetBooking();
dialog.ShowDialog();
FillBookingsListViews();
}
public List <GetBooking> GetBookingsById(List <int> ids)
{
List <GetBooking> getBookings = new List <GetBooking>();
if (ids.Count == 1 && ids[0] == -1)
{
ids = db.Bookings.Select(b => b.BookingID).ToList();
}
foreach (int id in ids)
{
GetBooking getBooking = new GetBooking();
if (db.Bookings.Any(b => b.BookingID == id))
{
getBooking.booking = db.Bookings.Where(b => b.BookingID == id).First();
getBooking.transactions = db.Transactions.Where(t => t.BookingID == id).ToList();
getBooking.passengers = db.PassengerDetails.Where(p => p.BookingID == id).ToList();
if (getBooking.booking.UserRegistered == 1)
{
getBooking.user = db.Users.Where(u => u.Id == getBooking.booking.UserId).First();
}
else
{
getBooking.guestUser = db.GuestUsers.Where(u => u.Id == getBooking.booking.GuestId).First();
}
getBooking.FromStop = db.TripStops.Where(ts => ts.Stop == getBooking.booking.Boarding && ts.TripId == getBooking.booking.TripId).FirstOrDefault();
getBooking.ToStop = db.TripStops.Where(ts => ts.Stop == getBooking.booking.Arrival && ts.TripId == getBooking.booking.TripId).FirstOrDefault();
getBooking.bus = getBooking.booking.Trip.Bus;
if (db.Feedbacks.Any(f => f.BookingID == getBooking.booking.BookingID))
{
getBooking.feedback = db.Feedbacks.Where(f => f.BookingID == getBooking.booking.BookingID).First();
}
else
{
getBooking.feedback = new Feedback()
{
BusFeedback = 5
};
}
getBookings.Add(getBooking);
}
}
return(getBookings.OrderByDescending(b => b.booking.BookingID).ToList());
}
protected void Pay_Click(object sender, EventArgs e)
{
InsertBooking is1 = new InsertBooking();
GetBooking gb = new GetBooking();
int size = gb.getsize();
Label5.Text = size.ToString();
size++;
string content = "<book><book_id>" + size + "</book_id><cin_id>" +
DropDownList3.SelectedValue + "</cin_id><date>" +
DateTime.Now.ToString("yyyy-MM-ddTHH:mm:sszzz") + "</date><mov_id>" + DropDownList1.SelectedValue + "</mov_id><no_of_seats>" + DropDownList2.SelectedValue + "</no_of_seats><total>" + Label4.Text + "</total></book>";
// content = "sjzdkhdkjhkjjdh" + DropDownList3.SelectedValue+"lakdkjhdskjhkj";
Label5.Text = content;
is1.addBooking(content);
//Label5.Text = content;
Response.Redirect("pay.aspx?book_id=" + size);
}
public async Task <ActionResult <IEnumerable <Booking> > > GetOldBooking(int UserId)
{
ObservableCollection <GetBooking> tempBooking = new ObservableCollection <GetBooking>();
foreach (Booking b in _context.Booking.Where(x => x.UserID == UserId))
{
if (b.EndDate < DateTime.Now)
{
GetBooking TempBooking = new GetBooking
{
BookingID = b.BookingID,
Adress = b.Adress,
BookedRoom = _context.Room.FirstOrDefaultAsync(r => r.ID == b.BookedRoomID).Result,
EndDate = b.EndDate,
StartDate = b.StartDate,
PhoneNumber = b.PhoneNumber,
UserID = b.UserID
};
tempBooking.Add(TempBooking);
}
}
return(Ok(tempBooking));
}
