/// <summary>
/// Creates the new seat.
/// </summary>
/// <param name="id">The identifier.</param>
/// <returns>
/// a new seat
/// </returns>
public SeatViewModel CreateNewObject(int id)
{
SeatView view = new SeatView();
SeatViewModel viewModel = new SeatViewModel(new VRPosition(initialPosition, initialPosition, initialRotation), id);
this.LinkMVVM(view, viewModel);
return viewModel;
}
/// <summary>
/// Creates the new object.
/// </summary>
/// <param name="pos">The position.</param>
/// <param name="id">The identifier.</param>
/// <returns>A new object</returns>
public SeatViewModel CreateNewObject(VRPosition pos, int id)
{
SeatView view = new SeatView();
SeatViewModel viewModel = new SeatViewModel(pos, id);
this.LinkMVVM(view, viewModel);
return viewModel;
}
public List <SeatViewModel> AllSeatsForFlight(int FlightId)
{
using (var context = new ABS())
{
var seatForFlight = context.Seats.Include(co => co.Section)
.Where(s => s.FlightId == FlightId)
.ToList();
List <SeatViewModel> seatsDisplay = new List <SeatViewModel>();
if (seatForFlight == null)
{
return(null);
}
foreach (var seat in seatForFlight)
{
var seatDisplay = new SeatViewModel()
{
SeatId = seat.SeatId,
Col = seat.Col,
Row = seat.Row,
Status = seat.Status,
Section = seat.Section.SeatClassName,
FlightId = seat.FlightId
};
seatsDisplay.Add(seatDisplay);
}
return(seatsDisplay);
}
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
base.OnNavigatedTo(e);
LoggedStaff = (StaffViewModel)e.Parameter;
SeatViewModel = new SeatViewModel(LoggedStaff.FlightId);
}
private void ComboSeats_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
SeatViewModel o = this.DataContext as SeatViewModel;
o.Station.SelectedSeat = o.Seats.Find((item) => item.Number == Int16.Parse(o.SelectedSeatNumber));
this.DataContext = o;
}
public ActionResult GetLocationPartial(SeatViewModel seatVM)
{
var R_Id = Request.Cookies["idCookie"].Values["r_id"];
var SeatList = seatService.GetSeatByRAccount(R_Id).Select(Mapper.Map <Seat, SeatViewModel>);
return(PartialView("_SeatLocation", SeatList));
}
public ActionResult ChangeStatus(SeatViewModel seat)
{
if (ModelState.IsValid)
{
db.BookSeat(seat.SeatId);
return(RedirectToAction("Index", "Seat", new { FlightId = seat.FlightId.ToString() }));
}
return(View());
}
public IActionResult BusSelected(string date, int id)
{
SeatViewModel seats = new SeatViewModel();
var dateToTravel = Convert.ToDateTime(date);
var seatForDate = this._seatRepo.GetSeatsUsingDateAndBus(dateToTravel, id);
seats.seats = seatForDate;
seats.dateToTravel = dateToTravel;
seats.bus = this._busRepo.GetBus(id);
return(View(seats));
}
public ActionResult Create([FromJson] OrderViewModel orderViewModel)
{
ModelState.Clear();
string currentUserId = User.Identity.GetUserId();
var currentSeance = _seanceService.ReadById(orderViewModel.SeanceId);
var permittedUserSeats = (from seat in currentSeance.ReservedSeats
where seat.ApplicationUserId == currentUserId &&
seat.IsSold == false &&
DateTime.Compare(DateTime.Now, seat.ReservationTime.AddMinutes(10)) < 0
select seat).ToList();
List <SeatViewModel> targetSeats = new List <SeatViewModel>();
foreach (var seat in permittedUserSeats)
{
SeatViewModel seatModel = (from seatToBuy in orderViewModel.Seats
where seatToBuy.ColumnNumber == seat.ColumnNumber &&
seatToBuy.RowNumber == seat.RowNumber
select seatToBuy).SingleOrDefault();
if (seatModel != null)
{
targetSeats.Add(seatModel);
}
}
bool areAllSeatsAccepted = orderViewModel.Seats.Count() == targetSeats.Count();
if (!areAllSeatsAccepted)
{
return(Json(Url.Action("TimeIsOut", "Home")));
}
foreach (var seat in targetSeats)
{
ReservedSeatDomainModel payedSeat = (from reservedSeat in currentSeance.ReservedSeats
where reservedSeat.RowNumber == seat.RowNumber &&
reservedSeat.ColumnNumber == seat.ColumnNumber
select reservedSeat).SingleOrDefault();
TicketDomainModel ticket = new TicketDomainModel();
ticket.SeatId = seat.Id;
ticket.ApplicationUserId = currentUserId;
ticket.PaymentDate = DateTime.Now;
ticket.PaymentMethodId = orderViewModel.PaymentMethodId;
ticket.SeanceId = orderViewModel.SeanceId;
payedSeat.IsSold = true;
//_seanceService.Update(currentSeance);
_ticketService.Add(ticket);
payedSeat.Seance = null;
_reservedSeatService.Update(payedSeat);
}
return(Json(Url.Action("Index", "Ticket")));
}
/// <summary>
/// Constructor with ViewModel
/// </summary>
/// <param name="seatingGrid"></param>
/// <param name="viewModel"></param>
public SeatControl(SeatingGrid seatingGrid, SeatViewModel viewModel)
{
try
{
SeatingGrid = seatingGrid;
InitializeComponent();
DataContext = viewModel;
}
catch (Exception ex)
{
ex.Log();
}
}
public int CreateOrder(SeatViewModel seatViewModel)
{
try
{
con = new SqlConnection(connectionString);
var p = new DynamicParameters();
p.Add("@VendorId", seatViewModel.VendorId);
p.Add("@TempOrderId", seatViewModel.TempOrderId);
p.Add("@WebOrderId", seatViewModel.WebOrderId);
p.Add("@MobileNumber", seatViewModel.MobileNumber);
p.Add("@ScreenId", seatViewModel.ScreenId);
p.Add("@ShowDate", seatViewModel.ShowDate);
p.Add("@ShowTime", seatViewModel.ShowTime);
p.Add("@ScreenClassId", seatViewModel.ScreenClassId);
p.Add("@SeatIds", seatViewModel.SeatIds);
p.Add("@TotalAmount", seatViewModel.TotalAmount);
p.Add("@TicketPrice", seatViewModel.TicketPrice);
p.Add("@TransactionId", seatViewModel.TransactionId);
p.Add("@MovieTimingId", seatViewModel.MovieTimingId);
p.Add("@TicketCount", seatViewModel.TicketCount);
p.Add("@PaymentType", seatViewModel.PaymentType);
p.Add("@PaymentConfirmationNumber", seatViewModel.PaymentConfirmationNumber);
p.Add("@IPAddress", seatViewModel.IPAddress);
p.Add("@Output", dbType: DbType.Int32, direction: ParameterDirection.Output);
p.Add("@OrderId", dbType: DbType.Int32, direction: ParameterDirection.Output);
const string storedprocedure = "dbo.mt_ins_TempOrders";
con.Query <int>(storedprocedure, p, commandType: CommandType.StoredProcedure).SingleOrDefault();
var result = p.Get <int>("@Output");
var OrderId = p.Get <int>("@OrderId");
//Error occured or validation when result value is negative.
if (result < 0)
{
return(Convert.ToInt32(result));
}
else
{
return(Convert.ToInt32(OrderId));
}
}
catch (Exception ex)
{
return(-101);
throw ex;
}
}
private void GetSeats_Click(object sender, RoutedEventArgs e)
{
SeatViewModel o = this.DataContext as SeatViewModel;
try
{
this.ComboSeats.ItemsSource = o.loadSeats(o.Station.SelectedVan);
}
catch
{
this.ComboSeats.ItemsSource = new List <SeatModel> {
};
}
Deb.Print(o.Station.SelectedSeat, "selected Seat from vans");
}
/// <summary>
/// Aircraft constructor
/// </summary>
/// <param name="flight"></param>
/// <param name="seats"></param>
/// <param name="cols"></param>
/// <param name="aisles"></param>
public Aircraft(Flight flight, int seats, int cols, int aisles)
{
Passengers = new List <Passenger>();
_flightInfo = flight;
Flight_ID = _flightInfo.Flight_ID;
Flight_Number = _flightInfo.Flight_Number;
Aircraft_Type = _flightInfo.Aircraft_Type;
TotalSeats = seats;
Columns = cols;
Aisles = aisles;
LoadPassengers();
List <int> filledSeats = GetFilledSeats().ToList();
for (int seat = 0; seat < seats; seat++)
{
SeatViewModel viewModel = new SeatViewModel
{
SeatID = seat + 1
};
bool seatIsFilled = false;
foreach (int filledSeatID in filledSeats)
{
if (filledSeatID == viewModel.SeatID)
{
seatIsFilled = true;
break;
}
}
if (seatIsFilled)
{
viewModel.SeatStatus = SeatStatus.Taken;
}
else
{
viewModel.SeatStatus = SeatStatus.Empty;
}
Seats.Add(viewModel);
}
}
public IActionResult Index(SeatViewModel model)
{
Guid SeatId = Guid.NewGuid();
Guid AirplainId = new Guid("320F2833-58C2-49E8-8DA1-1EF29C47CF5B");//
Guid TypeId = new Guid("ed44f3c7-0271-448e-9445-2806f544061c");
Seat seat = new Seat();
seat.Id = SeatId;
seat.AirplaneId = AirplainId;
seat.TypeId = TypeId;
seat.ColumnNumber = model.ColumnNumber;
seat.RowNumber = model.RowNumber;
_service.Seat.Add(seat);
return(View("Index", "Test"));
}
public SeatViewModel GetSeat(Seat seat)
{
var seats = new SeatViewModel {
VenueId = seat.Row.Section.Venue.VenueId,
VenueName = seat.Row.Section.Venue.VenueName,
SectionId = seat.Row.Section.SectionId,
SectionName = seat.Row.Section.SectionName,
RowId = seat.Row.RowId,
RowName = seat.Row.RowName,
Seats = _context.Seat.Where(s => s.SeatId == seat.SeatId)
.Select(s => new SeatDetailViewModel {
SeatId = s.SeatId,
SeatName = s.SeatName,
Price = s.Price
}).ToList()
};
return(seats);
}
protected void Submit_Click(object sender, EventArgs e)
{
SeatViewModel seatViewModel = new SeatViewModel();
seatViewModel.SeatNumber = Convert.ToInt32(SeatNumber.Text);
seatViewModel.SeatSide = SeatSide.Text;
if (HiddenField1.Value != "")
{
seatViewModel.ID = Convert.ToInt32(HiddenField1.Value);
}
seatViewModel = iSeatService.AddAndUpdate(seatViewModel);
if (seatViewModel.ID > 0)
{
Response.Write("<script>alert('Record saved successfully')</script>");
Response.Redirect("Ticket.aspx");
}
bindGrid();
}
public SeatViewModel AddAndUpdate(SeatViewModel viewModel)
{
if (viewModel.ID > 0)
{
var record = _db.Seats.Where(x => x.ID == viewModel.ID).FirstOrDefault();
record.SeatNumber = viewModel.SeatNumber;
record.SeatSide = viewModel.SeatSide;
_db.SaveChanges();
}
else
{
Seat _seat = new Seat();
_seat.SeatNumber = viewModel.SeatNumber;
_seat.SeatSide = viewModel.SeatSide;
_db.Seats.Add(_seat);
_db.SaveChanges();
viewModel.ID = _seat.ID;
}
return(viewModel);
}
public async Task <IActionResult> Selector([FromRoute] long playListId)
{
var PlayListList = await playListRepository.FindAllAsync();
var PlayList = PlayListList.FirstOrDefault(p => p.Id == playListId);
var ReservedSeats = await seatRepository.FindAllByTimeSlotIdAsync(PlayList.TimeSlotId);
SeatViewModel SeatViewModel = new SeatViewModel();
SeatViewModel.Movie = PlayList.Movie;
SeatViewModel.TimeSlot = PlayList.TimeSlot;
SeatViewModel.PlayListId = playListId;
var Seats = ReservedSeats.ToList();
var Seating = JSONSeatingHelper.JSONSeating(PlayList.TimeSlot.Room, Seats);
SeatViewModel.SeatingArrangement = JSONSeatingHelper.JSONSeating(PlayList.TimeSlot.Room, Seats);
return(View(SeatViewModel));
}
public ActionResult SeatGalleryUser(string id)
{
SeatDal dal = new SeatDal();
MovieDal dal2 = new MovieDal();
userSeatViewModel mvm2 = new userSeatViewModel();
SeatViewModel mvm = new SeatViewModel();
List <Seat> Seatss = new List <Seat>();
var item = dal2.MOVIES.Where(a => a.ID == id).FirstOrDefault();
for (int i = 0; i < dal.Seats.ToList().Count(); i++)
{
if (dal.Seats.ToList()[i].Hall == item.SALLE && dal.Seats.ToList()[i].date == item.showtime)
{
Seatss.Add(dal.Seats.ToList()[i]);
}
}
mvm2.Seat = new Seat();
mvm2.Seats = Seatss;
return(View(mvm2));
}
// GET: Booking
public ActionResult Index(int showtimeId)
{
Session["CurrentUrl"] = Request.Url;
if (Session["Customer"] == null)
{
return(RedirectToAction("Index", "Login"));
}
else
{
var roomId = showtimeService.GetShowtime(showtimeId).RoomId;
var seatVM = new SeatViewModel()
{
SeatModel = seatService.GetAll().Where(n => n.RoomId == roomId).ToList()
};
ViewBag.MaxColumn = seatService.GetAll().Max(c => Convert.ToInt32(c.ColumnSeat)).ToString();
ViewBag.Showtime = showtimeService.GetAll().Where(n => n.ShowtimeId == showtimeId).ToList();
ViewBag.ShowtimeId = showtimeId;
return(View(seatVM));
}
}
public SeatViewModel Retreive(int seatId)
{
using (var context = new ABS())
{
var seat = context.Seats.Where(s => s.SeatId == seatId).FirstOrDefault();
if (seat == null)
{
return(null);
}
SeatViewModel seatDisplay = new SeatViewModel()
{
SeatId = seat.SeatId,
Col = seat.Col,
Row = seat.Row,
Status = seat.Status,
Section = seat.Section.SeatClassName,
FlightId = seat.FlightId
};
return(seatDisplay);
}
}
public ActionResult ToogleReservationStatus([FromJson] SeatViewModel seatViewModel, long seanceId)
{
SeanceDomainModel currentSeance = _seanceService.ReadById(seanceId);
string currentUserId = User.Identity.GetUserId();
if (currentSeance == null || seatViewModel == null)
{
HttpNotFound();
}
else
{
var reservedSeat = (from seat in currentSeance.ReservedSeats
where seat.RowNumber == seatViewModel.RowNumber &&
seat.ColumnNumber == seatViewModel.ColumnNumber
select seat).SingleOrDefault();
if (reservedSeat == null)
{
ReservedSeatDomainModel currentReservedSeat = new ReservedSeatDomainModel
{
RowNumber = seatViewModel.RowNumber,
ColumnNumber = seatViewModel.ColumnNumber,
ReservationTime = DateTime.Now,
SeanceId = seanceId,
ApplicationUserId = currentUserId
};
_reservedSeatService.Add(currentReservedSeat);
}
else
{
if (reservedSeat.ApplicationUserId != currentUserId)
{
return(new HttpStatusCodeResult(HttpStatusCode.Forbidden));
}
_reservedSeatService.Delete(reservedSeat);
}
}
return(new HttpStatusCodeResult(HttpStatusCode.OK));;
}
public ActionResult RedirectProjectionData(FormCollection data)
{
try
{
var kidsRetirees = int.Parse(data["kidsRetirees"]);
var students = int.Parse(data["students"]);
var adults = int.Parse(data["adults"]);
var projectionID = int.Parse(data["projectionID"]);
var totalPrice = decimal.Parse(data["totalPrice"]);
var projectionTime = data["projectionTime"].Split(' ');
Session["ticketDate"] = projectionTime[0];
Session["ticketHour"] = projectionTime[1] + projectionTime[2];
var seatDtos = new List <SeatDTO>();
using (var context = new CinemaTicketsDbContext())
{
var projection = context.Projections.FirstOrDefault(p => p.ProjectionID == projectionID);
var hallNumber = context.Halls.FirstOrDefault(h => h.HallID == projection.HallID).HallNumber;
Session["hallNumber"] = hallNumber;
var tickets = projection.Tickets.ToList();
foreach (var ticket in tickets)
{
var seatDto = new SeatDTO
{
Column = ticket.Seat.Column,
Row = ticket.Seat.Row,
HallID = ticket.Seat.HallID,
SeatID = ticket.Seat.SeatID
};
if (ticket.IsSold)
{
seatDto.IsTaken = true;
}
else
{
seatDto.IsTaken = false;
}
seatDtos.Add(seatDto);
}
}
var model = new SeatViewModel()
{
Adults = adults,
KidsRetirees = kidsRetirees,
SeatDtos = seatDtos,
Students = students,
TotalPrice = totalPrice,
ProjectionID = projectionID
};
CacheViewModel.CacheModel(model);
}
catch (Exception e)
{
return(new HttpStatusCodeResult(400, "Something went wrong! :("));
}
return(new HttpStatusCodeResult(200, "OK"));
}
public SearchPassengerToMoveCommand(SeatViewModel svm, int p)
{
SeatViewModel = svm;
Passenger = p;
}
public void Execute(object parameter)
{
SeatViewModel.SearchPassengerToMove(Passenger);
}
public Seats()
{
this.InitializeComponent();
SeatViewModel = new SeatViewModel();
this.DataContext = SeatViewModel;
}
public SwitchPlacesCommand(SeatViewModel svm)
{
SeatViewModel = svm;
}
public static void CacheModel(SeatViewModel model)
{
svm = model;
}
