public Occupation GetOccupationByID(int id)
{
Occupation occupation = null;
#region Business validation
if (id <= 0)
{
// Log -> Constants.OCCUPATION_ID_NULL_ERROR;
throw new BusinessException(Constants.OCCUPATION_ID_NULL_ERROR);
}
#endregion
occupation = GetAllOccupations().FirstOrDefault(o => o.ID == id);
// If Occupation or RatingDetails is null then
if (occupation == null)
{
// Log -> Constants.OCCUPATION_NOT_FOUND;
throw new BusinessException(Constants.OCCUPATION_NOT_FOUND);
}
else if (occupation.RatingDetail == null)
{
// Log -> Constants.RATING_NOT_FOUND;
throw new BusinessException(Constants.RATING_NOT_FOUND);
}
else
{
// ToDo:: This won't be required, as EF will automap RatingDetail
RatingDetail ratingDetail = _ratingDetailService.GetRatingDetailByID(occupation.RatingDetail.ID);
occupation.RatingDetail = ratingDetail;
//
}
return(occupation);
}
public RatingDetail GetRatingDetail(int id)
{
using (var ctx = new ApplicationDbContext())
{
var entity = ctx.SafetyRatings.Single(e => e.Id == id);
var detailedRating = new RatingDetail
{
Id = entity.Id,
HousingId = entity.HousingId,
ApplicantId = entity.ApplicantId,
Rating = entity.Rating,
Posted = entity.Posted
};
return(detailedRating);
}
}
public RatingDetail GetRatingsByRatingID(int ratingId)
{
using (var ctx = new ApplicationDbContext())
{
var entity = ctx.Ratings.FirstOrDefault(r => r.RatingID == ratingId);
var model = new RatingDetail()
{
RatingID = entity.RatingID,
UserName = entity.Rater.UserName,
BaseName = entity.Base.BaseName,
OverallRating = entity.OverallRating,
HousingRating = entity.HousingRating,
FoodRating = entity.FoodRating,
ActivitiesRating = entity.ActivitiesRating,
TrainingSitesRating = entity.TrainingSitesRating,
Comments = entity.Comments
};
return(model);
}
}
public async Task <IHttpActionResult> GetByID(int id)
{
Rating rating = await _context.Ratings.FindAsync(id);
if (rating != null)
{
//var model = (Rating)_context.Entry(rating).CurrentValues.ToObject();
var model = new RatingDetail
{
Id = rating.Id,
RestaurantId = rating.RestaurantId,
FoodScore = rating.FoodScore,
EnvironmentScore = rating.EnvironmentScore,
CleanlinessScore = rating.CleanlinessScore,
AverageRating = rating.AverageRating
};
return(Ok(model));
}
return(NotFound());
}
