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;
}
}
