private Attachment CreateAdaptiveCardAttachment(string cardName, BookingDetails booking) { AdaptiveCard card = new AdaptiveCard(new AdaptiveSchemaVersion(1, 0)); string[] Passengers = booking.PassengerName.Split(","); var messageText = $"I have {booking.PassengerName} "; var messageBody = $"booked to {booking.Destination} from {booking.Origin} on {booking.TravelDate}."; card.Speak = String.Concat(messageText, messageBody); card.Body.Add(new AdaptiveTextBlock() { Text = "Hello, I have", Type = "TextBlock", Weight = AdaptiveTextWeight.Bolder, IsSubtle = false, Size = AdaptiveTextSize.Default }); for (int i = 0; i < Passengers.Length; i++) { string res = Passengers[i]; card.Body.Add(new AdaptiveTextBlock() { Text = res, Size = AdaptiveTextSize.Default }); } card.Body.Add(new AdaptiveTextBlock() { Text = messageBody, Size = AdaptiveTextSize.Default }); card.Body.Add(new AdaptiveImage() { Url = new Uri("https://adaptivecards.io/content/airplane.png") }); // serialize the card to JSON string json = card.ToJson(); return(new Attachment() { ContentType = "application/vnd.microsoft.card.adaptive", Content = JsonConvert.DeserializeObject(json), }); }
private async Task <DialogTurnResult> ActStepAsync(WaterfallStepContext stepContext, CancellationToken cancellationToken) { if (!_luisRecognizer.IsConfigured) { // LUIS is not configured, we just run the BookingDialog path with an empty BookingDetailsInstance. return(await stepContext.BeginDialogAsync(nameof(BookingDialog), new BookingDetails(), cancellationToken)); } // Call LUIS and gather any potential booking details. (Note the TurnContext has the response to the prompt.) var luisResult = await _luisRecognizer.RecognizeAsync <FlightBooking>(stepContext.Context, cancellationToken); switch (luisResult.TopIntent().intent) { case FlightBooking.Intent.BookFlight: await ShowWarningForUnsupportedCities(stepContext.Context, luisResult, cancellationToken); // Initialize BookingDetails with any entities we may have found in the response. var bookingDetails = new BookingDetails() { // Get destination and origin from the composite entities arrays. Destination = luisResult.ToEntities.Airport, Origin = luisResult.FromEntities.Airport, TravelDate = luisResult.TravelDate, }; // Run the BookingDialog giving it whatever details we have from the LUIS call, it will fill out the remainder. return(await stepContext.BeginDialogAsync(nameof(BookingDialog), bookingDetails, cancellationToken)); case FlightBooking.Intent.GetWeather: // We haven't implemented the GetWeatherDialog so we just display a TODO message. var getWeatherMessageText = "TODO: get weather flow here"; var getWeatherMessage = MessageFactory.Text(getWeatherMessageText, getWeatherMessageText, InputHints.IgnoringInput); await stepContext.Context.SendActivityAsync(getWeatherMessage, cancellationToken); break; default: // Catch all for unhandled intents var didntUnderstandMessageText = $"Sorry, I didn't get that. Please try asking in a different way (intent was {luisResult.TopIntent().intent})"; var didntUnderstandMessage = MessageFactory.Text(didntUnderstandMessageText, didntUnderstandMessageText, InputHints.IgnoringInput); await stepContext.Context.SendActivityAsync(didntUnderstandMessage, cancellationToken); break; } return(await stepContext.NextAsync(null, cancellationToken)); }
public IActionResult BookingVenue(BookingVenue BookingVenue) { if (ModelState.IsValid) { BookingDetails BD = new BookingDetails { BookingDate = BookingVenue.BookingDate, Createdby = Convert.ToInt32(HttpContext.Session.GetString("UserID")), CreatedDate = DateTime.Now, BookingApproval = "P" }; var result = _IBookingVenue.BookEvent(BD); BookingVenue BV = new BookingVenue { VenueID = BookingVenue.VenueID, EventTypeID = BookingVenue.EventTypeID, GuestCount = BookingVenue.GuestCount, Createdby = Convert.ToInt32(HttpContext.Session.GetString("UserID")), CreatedDate = DateTime.Now, BookingID = result }; var VenueID = _IBookingVenue.BookVenue(BV); HttpContext.Session.SetInt32("BookingID", result); if (result > 0) { SetSlider(); ModelState.Clear(); ViewData["BookingMessage"] = "Venue Booked Successfully"; return(View("Success")); } else { SetSlider(); return(View("BookingVenue", BookingVenue)); } } else { SetSlider(); return(View("BookingVenue", BookingVenue)); } }
public async Task <BookingDetails> AddBooking(BookingDetails request) { BookingDetails added; using (var db = _provider.GetDatabase()) { var bookings = db.GetCollection <BookingDetails>("bookings"); bookings.EnsureIndex(x => x.Id, true); bookings.Insert(request); var id = request.Id; added = bookings.FindById(id); } return(await Task.FromResult(added)); }
// Method responsible for getting BookingDetails accrording to the passed booking Id public static BookingDetails GetBookingDetailByID(int BookingId) { BookingDetails bookingDetails = null; SqlConnection connection = UnversalDBControls.GetConnection(); string selectStatement = "SELECT BookingDetailId, ItineraryNo, TripStart, TripEnd, Description, " + "Destination, BasePrice, AgencyCommission, BookingId, RegionId, " + "ClassId, FeeId, ProductSupplierId, DeparturePlnId, ReturnPlnId " + "FROM BookingDetails " + "WHERE BookingId = @BookingId "; SqlCommand selectCommand = new SqlCommand(selectStatement, connection); selectCommand.Parameters.AddWithValue("@BookingId", BookingId); try { connection.Open(); SqlDataReader dr = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (dr.Read()) { bookingDetails = new BookingDetails(); bookingDetails.BookingDetailId = (int)dr["BookingDetailId"]; bookingDetails.ItineraryNo = (double)dr["ItineraryNo"]; bookingDetails.TripStart = (DateTime)dr["TripStart"]; bookingDetails.TripEnd = (DateTime)dr["TripEnd"]; bookingDetails.Description = dr["Description"].ToString(); bookingDetails.Destination = dr["Destination"].ToString(); bookingDetails.BasePrice = (decimal)dr["BasePrice"]; bookingDetails.AgencyCommission = (decimal)dr["AgencyCommission"]; bookingDetails.BookingId = (int)dr["BookingId"]; bookingDetails.RegionId = dr["RegionId"].ToString(); bookingDetails.ClassId = dr["ClassId"].ToString(); bookingDetails.FeeId = dr["FeeId"].ToString(); bookingDetails.ProductSupplierId = (int)dr["ProductSupplierId"]; bookingDetails.DeparturePlnId = (int)dr["DeparturePlnId"]; bookingDetails.ReturnPlnId = (int)dr["ReturnPlnId"]; } } catch (SqlException ex) { throw ex; } finally { connection.Close(); } return(bookingDetails); }
/// <summary> /// This gives search results /// </summary> /// <returns></returns> public JsonResult GetRooms(BookingDetails bookingDetails) { // BookingDetails bookingDetails = new BookingDetails { CityId = 1, GuestId = "1", CheckinDate = "6/5/2013", CheckoutDate = "6/12/2013", NumberOfAdults = 2 }; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); SqlCommand cmd = new SqlCommand("sp_get_availability", conn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BranchID", bookingDetails.CityId); cmd.Parameters.AddWithValue("@FromDate", bookingDetails.CheckinDate); cmd.Parameters.AddWithValue("@ToDate", bookingDetails.CheckoutDate); cmd.Parameters.AddWithValue("@IncludePartner", 0); SqlParameter param = new SqlParameter("@RtnValue", SqlDbType.Int); param.Direction = ParameterDirection.ReturnValue; cmd.Parameters.Add(param); SqlDataAdapter adpter = new SqlDataAdapter(cmd); DataSet dataSet = new DataSet(); adpter.Fill(dataSet); if ((int)cmd.Parameters["@RtnValue"].Value != 0) { return(null); } if (dataSet == null || dataSet.Tables == null || dataSet.Tables.Count == 0 || dataSet.Tables[0].Rows == null || dataSet.Tables[0].Rows.Count == 0) { return(null); } var availableRooms = new List <AvailableRoom>(); foreach (DataRow dataRow in dataSet.Tables[0].Rows) { AvailableRoom availableRoom = new AvailableRoom(); availableRoom.Id = dataRow["RoomTypeID"].ToString(); availableRoom.Name = dataRow["TypeName"].ToString(); availableRoom.Description = dataRow["facilities"].ToString(); availableRooms.Add(availableRoom); } return(Json(availableRooms, JsonRequestBehavior.AllowGet)); }
private async Task <DialogTurnResult> ActStepAsync(WaterfallStepContext stepContext, CancellationToken cancellationToken) { if (!_luisRecognizer.IsConfigured) { // LUIS is not configured, we just run the BookingDialog path with an empty BookingDetailsInstance. return(await stepContext.BeginDialogAsync(nameof(BookingDialog), new BookingDetails(), cancellationToken)); } // Call LUIS and gather any potential booking details. (Note the TurnContext has the response to the prompt.) var luisResult = await _luisRecognizer.RecognizeAsync <ChatBotModels>(stepContext.Context, cancellationToken); switch (luisResult.TopIntent().intent) { case ChatBotModels.Intent.GetEmployee: var getEmployeeMessage = MessageFactory.Text("", "", InputHints.IgnoringInput); await stepContext.Context.SendActivityAsync(getEmployeeMessage, cancellationToken); var bookingDetails = new BookingDetails() { IDA = luisResult.Entities.ida }; return(await stepContext.BeginDialogAsync(nameof(BookingDialog), bookingDetails, cancellationToken)); case ChatBotModels.Intent.Help: List <string> helpMessageText = new List <string>(); helpMessageText.Add("Example Messages follow this format - \r\n" + "Get Employee : Will follow up and ask for an Employee ID. \r\n" + "Get Employee XX : Will use provided Employee ID"); foreach (string msg in helpMessageText) { var helpMessage = MessageFactory.Text(msg, msg, InputHints.IgnoringInput); stepContext.Context.SendActivityAsync(helpMessage, cancellationToken); } break; default: // Catch all for unhandled intents var didntUnderstandMessageText = $"Sorry, I didn't get that. Please try asking in a different way (intent was {luisResult.TopIntent().intent})"; var didntUnderstandMessage = MessageFactory.Text(didntUnderstandMessageText, didntUnderstandMessageText, InputHints.IgnoringInput); await stepContext.Context.SendActivityAsync(didntUnderstandMessage, cancellationToken); break; } return(await stepContext.NextAsync(null, cancellationToken)); }
protected void SalesByEndDate() { BookingDetails bd = new BookingDetails(); List <string> listDays = new List <string>() { "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday", "Sunday" }; List <int> salesByEndDay = bd.GetSalesByEnd(listDays); Series series = Chart1.Series["SeriesStats"]; for (int i = 0; i < listDays.Count; i++) { series.Points.AddXY(listDays[i], salesByEndDay[i]); } }
protected void OverallPlanSales() { BookingDetails bd = new BookingDetails(); List <string> listYears = new List <string>() { "2020", "2021", "2022" }; List <int> totalSales = bd.GetTotalSales(listYears); Series series = Chart1.Series["SeriesStats"]; for (int i = 0; i < listYears.Count; i++) { series.Points.AddXY(listYears[i], totalSales[i]); } }
public async Task BookAsync(Guid facilityId, Guid accommodationId, BookingDetails details) { var data = mapper.MapFrom(details); data.AccommodationId = accommodationId; var result = await partitionClientFactory.CreatePartitionClient(new ServicePartitionKey(facilityId.ToPartitionKey())).InvokeWithRetryAsync(async client => { var api = await client.CreateApiClient(); return(await api.CreateBookingWithHttpMessagesAsync(accommodationId, data)); }); if (result.Response.StatusCode == HttpStatusCode.NotFound) { throw new AccommodationNotFoundException(accommodationId); } }
public IActionResult CheckOut(Customers customer) { var amount = TempData["total"]; var cid = (TempData["cid"]).ToString(); HttpContext.Session.SetString("cID", cid.ToString()); DateTime cin = DateTime.Parse(HttpContext.Session.GetString("CheckIn")); DateTime cout = DateTime.Parse(HttpContext.Session.GetString("CheckOut")); Bookings bookings = new Bookings() { BookingPrice = Convert.ToSingle(amount), BookingDate = DateTime.Now, CheckIn = cin, CheckOut = cout, CustomerId = int.Parse(cid) }; ViewBag.Book = bookings; context.Bookings.Add(bookings); context.SaveChanges(); var booking = SessionHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "Book"); List <BookingDetails> bookingDetails = new List <BookingDetails>(); for (int i = 0; i < booking.Count; i++) { BookingDetails bookingdetail = new BookingDetails() { BookingId = bookings.BookingId, RoomId = booking[i].HotelRooms.RoomId, Qunatity = booking[i].Quantity }; bookingDetails.Add(bookingdetail); } bookingDetails.ForEach(n => context.BookingDetails.Add(n)); context.SaveChanges(); TempData["cust"] = cid; ViewBag.booking = null; return(RedirectToAction("Invoice")); }
public IActionResult BookRoom (IFormCollection formData) { BookingDetails details = new BookingDetails(); if (ModelState.IsValid) { details.Name = Convert.ToString(formData["Name"]); details.EmailAddress = Convert.ToString(formData["EmailAddress"]); details.StartDate = Convert.ToDateTime(formData["StartDate"]); details.EndDate = Convert.ToDateTime(formData["EndDate"]); details.Type = (RoomType)Enum.Parse(typeof(RoomType), formData["Type"].ToString()); var confirmationDetails = _b.BookRoom(details.Type, details.Name, details.EmailAddress, details.StartDate, details.EndDate); TempData.Clear(); return(View(nameof(Confirmation), confirmationDetails)); } return(View()); }
// GET: Bookings/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Booking booking = db.Bookings.Find(id); Courier courier = db.Couriers.Find(id); BookingDetails bd = new BookingDetails(); bd.booking = booking; bd.courier = courier; if (booking == null) { return(HttpNotFound()); } return(View(bd)); }
// POST: odata/BookingDetails public IHttpActionResult Post(BookingDetails bookingDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } try { db.BookingDetails.Add(bookingDetails); db.SaveChanges(); } catch (Exception ex) { string s = ex.InnerException.ToString(); return(BadRequest(s)); } return(Created(bookingDetails)); }
public int UpdateBookingStatus(int BookingID) { try { BookingDetails bookingdetail = (from bookingdetails in _context.BookingDetails where bookingdetails.BookingID == BookingID select bookingdetails).Single(); bookingdetail.BookingCompletedFlag = "C"; _context.BookingDetails.Attach(bookingdetail); _context.Entry(bookingdetail).Property(x => x.BookingCompletedFlag).IsModified = true; return(_context.SaveChanges()); } catch (Exception) { throw; } }
private Booking ConvertToBooking(BookingDetails bookingDetails) { Booking booking = new Booking(); booking.Amount = bookingDetails.Amount; booking.Arrival = bookingDetails.Arrival; booking.Boarding = bookingDetails.Boarding; booking.Status = bookingDetails.Status; booking.UserRegistered = bookingDetails.UserRegistered; if (booking.UserRegistered == 1) { booking.UserId = bookingDetails.UserId; } booking.TripId = bookingDetails.TripId; booking.BookingDate = DateTime.Now; return(booking); }
//Tạo các form passenger render về trang hiện tại public ActionResult RenderPassenger(int Adult, int Kid, int Baby, double PriceAdult, double PriceBaby, double PriceKid) { if (Session[UtilContants.USER_LOGIN] == null) { return(RedirectToAction("Index", "Home")); } else { BookingDetails BookingDetails = new BookingDetails(); BookingDetails.PriceAdult = PriceAdult; BookingDetails.PriceBaby = PriceBaby; BookingDetails.PriceKid = PriceKid; BookingDetails.Adult = Adult; BookingDetails.Kid = Kid; BookingDetails.Baby = Baby; var listPassenger = MultiPartialView.RenderRazorViewToString(this.ControllerContext, "listPassenger", BookingDetails); return(Json(new { status = true, listPassenger })); } }
/// <summary> /// Miguel Santana /// Created: 2015/04/06 /// added read-only capability to the ui /// </summary> /// <param name="selectedItem"></param> /// <param name="readOnly"></param> private void OpenBookingDetail(BookingDetails selectedItem = null, bool readOnly = false) { try { if (selectedItem == null) { if (new AddBooking(CurrentInvoice).ShowDialog() == false) { return; } RefreshBookingList(); } else { if (readOnly) { new EditBooking(CurrentInvoice, selectedItem, true).ShowDialog(); return; } //check if selected item can be edited switch (_bookingManager.CheckToEditBooking(selectedItem)) { case (ResultsEdit.CannotEditTooOld): throw new WanderingTurtleException(this, "Bookings in the past cannot be edited."); case (ResultsEdit.Cancelled): throw new WanderingTurtleException(this, "This booking has been cancelled and cannot be edited."); case (ResultsEdit.OkToEdit): if (new EditBooking(CurrentInvoice, selectedItem).ShowDialog() == false) { return; } RefreshBookingList(); break; } } } catch (Exception ex) { throw new WanderingTurtleException(this, ex); } }
public void InvoiceManagerCalculateDue() { //Updated: Create a list of booking details List <BookingDetails> guestBookings = new List <BookingDetails>(); //Creates two fake Total Charges to be added to the guestBookings list BookingDetails test = new BookingDetails(); test.TotalCharge = 40m; BookingDetails test2 = new BookingDetails(); test2.TotalCharge = 50m; //Fake BookingDetails added guestBookings.Add(test); guestBookings.Add(test2); //Calculates by calling manager method to test decimal amount = access.CalculateTotalDue(guestBookings); //Asserts that 90 will be returned. Assert.AreEqual((decimal)90, amount); }
public static string insertbookingdetails(BookingDetails b) { List <SqlParameter> v = new List <SqlParameter>(); SqlParameter p = null; //int bookingid = DBOperations.getbookid(); p = new SqlParameter("@bookingid", b.booking_id); v.Add(p); p = new SqlParameter("@customerid", b.customer_id); v.Add(p); p = new SqlParameter("@name", b.name); v.Add(p); p = new SqlParameter("@flightno", b.flight_no); v.Add(p); p = new SqlParameter("@airlinesname ", b.AirLinesName); v.Add(p); p = new SqlParameter("@locationfrom", b.locationfrom); v.Add(p); p = new SqlParameter("@locationto", b.LocationTo); v.Add(p); p = new SqlParameter("@dateofjourney", b.date_of_journey); v.Add(p); p = new SqlParameter("@departuretime", b.DepartureTime); v.Add(p); p = new SqlParameter("@bookingdate", b.booking_date); v.Add(p); p = new SqlParameter("@noofpassengers", b.no_of_passenger); v.Add(p); p = new SqlParameter("@totalprice", b.total_price); v.Add(p); p = new SqlParameter("@st", SqlDbType.NVarChar, 100); p.Direction = ParameterDirection.Output; v.Add(p); string msg = DBOperations.insertbookingdetails(v); return(msg); //string msg = "B"+bookingid.ToString(); //return msg; }
public string Write(BookingDetails bookingDetails, bool includeHeader) { StringBuilder sb = new StringBuilder(); Type type = typeof(BookingDetails); PropertyInfo[] properties = type.GetProperties(); if (includeHeader) { sb.AppendLine(this.CreateCsvHeaderLine(properties)); } foreach (var item in bookingDetails.Result) { sb.AppendLine(this.CreateCsvLine(item.Reservation_id, properties)); } return(sb.ToString()); }
public IActionResult Register(UserDetails c1) { var showTiming = Request.Form["showTiming"].ToString(); var bookmovie = SessionHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "bookmovie"); var total = bookmovie.Sum(item => item.Movies.MoviePrice * item.Quantity); context.UserDetails.Add(c1); context.SaveChanges(); checkAudi(showTiming); Bookings booking = new Bookings() { BookingAmount = total, BookingDate = DateTime.Now, ShowTiming = showTiming, AudiName = audiName, UserDetailId = c1.UserDetailId }; context.Bookings.Add(booking); context.SaveChanges(); List <BookingDetails> BookingDetail = new List <BookingDetails>(); for (int i = 0; i < bookmovie.Count; i++) { BookingDetails bookingDetail = new BookingDetails() { BookingId = booking.BookingId, MovieId = bookmovie[i].Movies.MovieId, QtySeats = bookmovie[i].Quantity }; context.BookingDetails.Add(bookingDetail); } BookingDetail.ForEach(n => context.BookingDetails.Add(n)); context.SaveChanges(); TempData["uid"] = c1.UserDetailId; return(RedirectToAction("Checkout", "Ticket")); }
public IActionResult Checkout(UserDetails userDetails) { //context.UserDetails.Add(userDetails); //context.SaveChanges(); var amount = (TempData["total"]); var uid = (TempData["uid"]).ToString(); Bookings bookings = new Bookings() { BookingAmount = Convert.ToSingle(amount), BookingDate = DateTime.Now, UserDetailId = int.Parse(uid) //UserDetailId = userDetails.UserDetailId }; ViewBag.book = bookings; context.Bookings.Add(bookings); context.SaveChanges(); var bookmovie = SessionHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "bookmovie"); List <BookingDetails> BookingDetail = new List <BookingDetails>(); for (int i = 0; i < bookmovie.Count; i++) { BookingDetails booking = new BookingDetails() { BookingId = bookings.BookingId, MovieId = bookmovie[i].Movies.MovieId, QtySeats = bookmovie[i].Quantity }; context.BookingDetails.Add(booking); } BookingDetail.ForEach(n => context.BookingDetails.Add(n)); context.SaveChanges(); TempData["cust"] = /*userDetails.UserDetailId*/ uid; ViewBag.bookings = null; return(RedirectToAction("Invoice", "Ticket")); }
public int UpdateBookingStatus(string BookingNo, string BookingStatus) { try { BookingDetails BD = (from BDs in _context.BookingDetails where BDs.BookingNo == BookingNo select BDs).Single(); BD.BookingApproval = BookingStatus; BD.BookingApprovalDate = DateTime.Now; _context.BookingDetails.Attach(BD); _context.Entry(BD).Property(x => x.BookingApproval).IsModified = true; _context.Entry(BD).Property(x => x.BookingApprovalDate).IsModified = true; return(_context.SaveChanges()); } catch (Exception) { throw; } }
public int InsertItem(BookingDetails bookingItem) { int count = 0; using (SqlConnection con = new SqlConnection(conString)) { using (SqlCommand cmd = new SqlCommand("Stp_InsertBookDetails", con)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@RoomID", bookingItem.RoomID); cmd.Parameters.AddWithValue("@BookingStatus", bookingItem.BookingStatus); cmd.Parameters.AddWithValue("@BookedDateFrom", bookingItem.BookedDateFrom); cmd.Parameters.AddWithValue("@BookedDateTO", bookingItem.BookedDateTO); cmd.Parameters.AddWithValue("@AdvancePayed", bookingItem.AdvancePayed); con.Open(); count = cmd.ExecuteNonQuery(); } } return(count); }
public IActionResult Checkout(UserDetails userDetails) { var bookmovie = SessionHelper.GetObjectFromJson <List <Item> >(HttpContext.Session, "bookmovie"); var showTiming = Request.Form["showTiming"].ToString(); var amount = (TempData["total"]); var uid = (TempData["uid"]).ToString(); checkAudi(showTiming); Bookings booking = new Bookings() { BookingAmount = Convert.ToInt32(amount), BookingDate = DateTime.Now, ShowTiming = showTiming, AudiName = audiName, UserDetailId = Convert.ToInt32(uid) }; context.Bookings.Add(booking); context.SaveChanges(); List <BookingDetails> BookingDetail = new List <BookingDetails>(); for (int i = 0; i < bookmovie.Count; i++) { BookingDetails bookingDetail = new BookingDetails() { BookingId = booking.BookingId, MovieId = bookmovie[i].Movies.MovieId, QtySeats = bookmovie[i].Quantity }; context.BookingDetails.Add(bookingDetail); } BookingDetail.ForEach(n => context.BookingDetails.Add(n)); context.SaveChanges(); TempData.Keep("uid"); TempData["bookingId"] = booking.BookingId; return(RedirectToAction("Index", "Payment")); }
//FunName : GetBookingDetails //Mode : Offline || Offline = Request : MoboleNo || Table : CCRMMembership || Reponse : PackageName , StartDate , InvoiceId //Mode : Online || Online = Request : MobileNo || Table : OnlinePackagePurchase || Reponse : PackageName , StartDate , InvoiceId public Object GetBookingDetails([FromBody] BookingDetailsInput bdi) { BookingDetailsOpt bdo = new BookingDetailsOpt(); DataSet SelectedSlots = new DataSet(); string sJSONResponse = ""; DataTable dt_BookingDetails = new DataTable(); List <BookingDetails> bdetails = new List <BookingDetails>(); try { if (bdi.Mode == "OffLine") { dt_BookingDetails = getdata(string.Format("select InvoiceID,CCRMM.PackageCode,CMSP.PackageName,StartDate,CCRMM.BranchCode,B.BranchName from CCRMMembership CCRMM,Users U,CMSPACKAGES CMSP,Branch B where CMSP.PackageCode=CCRMM.PackageCode and B.BranchCode=CCRMM.BranchCode and CCRMM.MembershipCode=U.UCode and U.MobileNo='{0}' ", bdi.MobileNo)); } else if (bdi.Mode == "OnLine") { dt_BookingDetails = getdata(string.Format("select Invoice as InvoiceID,OPP.PackageID as PackageCode,OP.PackageName,OPP.BranchCode,BranchName='Online', StartDate from OnlinePackagePurchase OPP,OnlinePackages OP where OPP.PackageID=OP.PackageID and OPP.MobileNo='{0}'", bdi.MobileNo)); } else { } for (int i = 0; i < dt_BookingDetails.Rows.Count; i++) { BookingDetails fd = new BookingDetails { InvoiceId = dt_BookingDetails.Rows[i]["InvoiceID"].ToString(), PackageCode = dt_BookingDetails.Rows[i]["PackageCode"].ToString(), PackageName = dt_BookingDetails.Rows[i]["PackageName"].ToString(), BranchName = dt_BookingDetails.Rows[i]["BranchName"].ToString(), StartDate = Convert.ToDateTime(dt_BookingDetails.Rows[i]["StartDate"].ToString()), BranchCode = dt_BookingDetails.Rows[i]["BranchCode"].ToString(), }; bdetails.Add(fd); } bdo.status = "success"; bdo.value = bdetails; sJSONResponse = JsonConvert.SerializeObject(bdo); } catch (Exception ec) { bdo.status = "fail"; sJSONResponse = JsonConvert.SerializeObject(bdo); } return(sJSONResponse); }
public bool Updatebooking(BookingViewModel model) { try { BookingDetails booking = _context.BookingDetails.Where(x => x.BillId == model.BillID).FirstOrDefault(); booking.ArrivalDate = model.ArrivalDate; booking.DepartureDate = model.DepartureDate; booking.RoomId = model.RoomID; booking.Price = model.Price; _context.BookingDetails.Update(booking); _context.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public bool AddBooking(BookingViewModel model) { try { BookingDetails booking = new BookingDetails { ArrivalDate = model.ArrivalDate, DepartureDate = model.DepartureDate, RoomId = model.RoomID, Price = model.Price }; _context.BookingDetails.Add(booking); _context.SaveChanges(); return(true); } catch (Exception) { return(false); } }
public int CancelBooking(int?BookingID) { try { if (BookingID != 0) { BookingDetails objBD = _context.BookingDetails.Find(BookingID); objBD.BookingApproval = "C"; _context.Entry(objBD).Property(x => x.BookingApprovalDate).IsModified = true; return(_context.SaveChanges()); } else { return(0); } } catch (Exception) { throw; } }