public IQueryable <Show> GetAll()
{
try
{
return(_showsRepository.GetAllAsync());
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
return(null);
}
public async Task <ShowResultModel> AddShow(ShowDomainModel requestedShow)
{
// check if requested show time is in the past
if (requestedShow.ShowTime < DateTime.Now)
{
return(new ShowResultModel
{
isSuccessful = false,
ErrorMessage = Messages.SHOW_IN_THE_PAST
});
}
// check if auditorium exist
var existingAuditorium = await _auditoriumsRepository.GetByIdAsync(requestedShow.AuditoriumId);
if (existingAuditorium == null)
{
return(new ShowResultModel
{
isSuccessful = false,
ErrorMessage = Messages.CANNOT_CREATE_SHOW_AUDITORIUM_DOES_NOT_EXIST,
});
}
// check if piece exist
var existingPiece = await _piecesRepository.GetByIdAsync(requestedShow.PieceId);
if (existingPiece == null)
{
return(new ShowResultModel
{
isSuccessful = false,
ErrorMessage = Messages.CANNOT_CREATE_SHOW_PIECE_DOES_NOT_EXIST
});
}
// check if shows are at the same time
int showTime = 3;
var allShows = await _showsRepository.GetAllAsync();
var allShowsInAuditorium = allShows
.Where(show => show.AuditoriumId == requestedShow.AuditoriumId);
var showsAtTheSameTime = allShowsInAuditorium
.Where(x => x.ShowTime <requestedShow.ShowTime.AddHours(showTime) && x.ShowTime> requestedShow.ShowTime.AddHours(-showTime));
if (showsAtTheSameTime.Count() > 0)
{
return(new ShowResultModel
{
ErrorMessage = Messages.SHOWS_AT_THE_SAME_TIME,
isSuccessful = false
});
}
// check if actors are provided
if (requestedShow.ActorsList.Count() == 0)
{
return(new ShowResultModel
{
ErrorMessage = Messages.ACTORS_NOT_PROVIDED,
isSuccessful = false
});
}
// check if actors exist in database
var allActors = await _actorsRepository.GetAllAsync();
IEnumerable <int> actorIds = allActors.Select(actor => actor.Id);
IEnumerable <int> requestedActorIds = requestedShow.ActorsList.Select(actor => actor.Id);
var actorsInBoth = actorIds.Intersect(requestedActorIds);
if (actorsInBoth.Count() < requestedActorIds.Count())
{
return(new ShowResultModel
{
isSuccessful = false,
ErrorMessage = Messages.CANNOT_CREATE_SHOW_ACTORS_DOES_NOT_EXIST
});
}
//check if any actor has more than 2 shows on the same day
var requestedActorsInDatabase = new List <Actor>();
foreach (var requested in requestedShow.ActorsList)
{
var actor = await _actorsRepository.GetByIdAsync(requested.Id);
requestedActorsInDatabase.Add(actor);
}
foreach (var actor in requestedActorsInDatabase)
{
if (actor.ShowActors.Any(showactor => showactor.Show.ShowTime.Date == requestedShow.ShowTime.Date))
{
if (actor.ShowActors.Count(showActor => showActor.Show.ShowTime.Date == requestedShow.ShowTime.Date) > 2)
{
return(new ShowResultModel
{
ErrorMessage = Messages
.CANNOT_CREATE_SHOW_SOME_ACTORS_HAVE_MORE_THAN_TWO_SHOWS_PER_DAY,
isSuccessful = false,
});
}
}
}
// insert in database
Show showToInsert = new Show
{
ShowTime = requestedShow.ShowTime,
AuditoriumId = requestedShow.AuditoriumId,
PieceId = requestedShow.PieceId,
TicketPrice = requestedShow.TicketPrice
};
var insertedShow = _showsRepository.Insert(showToInsert);
insertedShow.ShowActors = requestedShow.ActorsList.Select(actorDomainModel => new ShowActor
{
ActorId = actorDomainModel.Id,
ShowId = insertedShow.Id
}).ToList();
_showsRepository.Save();
// return created show to user
var createdShow = await _showsRepository.GetByIdAsync(insertedShow.Id);
ShowResultModel resultModel = new ShowResultModel
{
ErrorMessage = null,
isSuccessful = true,
ShowDomainModel = new ShowDomainModel
{
Id = createdShow.Id,
AuditoriumId = createdShow.AuditoriumId,
PieceId = createdShow.PieceId,
TicketPrice = createdShow.TicketPrice,
ShowTime = createdShow.ShowTime,
PieceTitle = createdShow.Piece.Title,
ActorsList = createdShow.ShowActors.Select(showActor => new ActorDomainModel
{
Id = showActor.Actor.Id,
FirstName = showActor.Actor.FirstName,
LastName = showActor.Actor.LastName
}).ToList()
}
};
return(resultModel);
}