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