public JsonResult BookingAvailablity(System.DateTime DateOfBooking, int ShowId /*, int NoOfSeats*/) { using (var context = new AdityaEntities4()) { var objData = from f in context.Bookings where f.DateOfBooking == DateOfBooking && f.ShowId == ShowId group f by new { f.DateOfBooking, f.ShowId } into t select new { TotalNoOfSeats = t.Sum(s => s.NoOfSeats) }; int numberOfSeats = 0; foreach (var a in objData) { numberOfSeats = a.TotalNoOfSeats; } // no of seat 157 //var show = db.Shows.SingleOrDefault(temp => temp.ShowId == ShowId); var show = getShowList().SingleOrDefault(temp => temp.ShowId == ShowId); var var1 = show.ScreenId; // var screenindb = db.Screens.SingleOrDefault(temp => temp.ScreenId == var1); var screenindb = getScreenList().SingleOrDefault(temp => temp.ScreenId == var1); int leftseats = screenindb.ScreenCapacity - numberOfSeats; var value = screenindb.ScreenCapacity; if (numberOfSeats >= value) { leftseats = 0; } globleleftseat = leftseats; /* if (NoOfSeats > leftseats) * { * * * return Json(leftseats,JsonRequestBehavior.AllowGet); // return leftseats; * * }*/ return(Json(leftseats, JsonRequestBehavior.AllowGet)); //return leftseats; } }
protected override ValidationResult IsValid(object value, ValidationContext validationContext) { var bvm = (Booking)validationContext.ObjectInstance; using (var context = new AdityaEntities4()) { var objData = from f in context.Bookings where f.DateOfBooking == bvm.DateOfBooking && f.ShowId == bvm.ShowId group f by new { f.DateOfBooking, f.ShowId } into t select new { /* dateofBooking = t.Key.DateOfBooking, * showId = t.Key.ShowId, */ TotalNoOfSeats = t.Sum(s => s.NoOfSeats) }; int numberOfSeats = 0; foreach (var a in objData) { numberOfSeats = a.TotalNoOfSeats; } var show = db.Shows.SingleOrDefault(temp => temp.ShowId == bvm.ShowId); var var1 = show.ScreenId; var screenindb = db.Screens.SingleOrDefault(temp => temp.ScreenId == var1); int leftseats = screenindb.ScreenCapacity - numberOfSeats; // int leftseats = bvm.screen.ScreenCapacity - numberOfSeats; if (bvm.NoOfSeats > leftseats) { return(new ValidationResult(leftseats + " seats are left")); // ViewBag.leftseatsStatus1 = leftseats; } else { return(ValidationResult.Success); } } }
public LanguageWepApiController() { db = new AdityaEntities4(); }
public ScreenWebApiController() { db = new AdityaEntities4(); }
public ShowWebApiController() { db = new AdityaEntities4(); }
public AspNetUsersWebApiController() { db = new AdityaEntities4(); }
public MovieWebApiController() { db = new AdityaEntities4(); }
public GenreWebApiController() { db = new AdityaEntities4(); }
public BookingWebApiController() { db = new AdityaEntities4(); }
public PaymentWebApiController() { db = new AdityaEntities4(); }
public CustomerWebApiController() { db = new AdityaEntities4(); }