public void AddRating(DalRating rating)
{
var photo = context.Context.Set <Photos>().FirstOrDefault(p => p.PhotoId == rating.PhotoId);
context.Context.Set <Photos>().Attach(photo);
photo.Ratings.Add(rating.ToRating());
}
public void DeleteRating(DalRating rating)
{
context.Context.Set <Photos>().First(p => p.PhotoId == rating.PhotoId).Ratings.Remove(rating.ToRating());
var ratingDB = context.Context.Set <Ratings>().First(r => r.UserName == rating.UserName && r.PhotoId == rating.PhotoId);
context.Context.Set <Ratings>().Remove(ratingDB);
}
public static RatingEntity ToBLLRating(this DalRating ratingDal)
{
return(new RatingEntity()
{
Id = ratingDal.Id,
UserName = ratingDal.UserName,
PhotoId = ratingDal.PhotoId
});
}
public static Ratings ToRating(this DalRating ratingDal)
{
return(new Ratings
{
PhotoId = ratingDal.PhotoId,
RatingId = ratingDal.Id,
UserName = ratingDal.UserName
});
}
public void Update(DalRating entity)
{
Rating rating = context.Set <Rating>().FirstOrDefault(r => r.UserId == entity.UserId && r.PhotoId == entity.PhotoId);
if (rating != null)
{
rating.UserRate = entity.UserRate;
}
}
public void Delete(DalRating entity)
{
Rating rating = context.Set <Rating>().FirstOrDefault(r => r.UserId == entity.UserId && r.PhotoId == entity.PhotoId);
if (rating != null)
{
context.Set <Rating>().Remove(rating);
}
}
public static Rating ToOrmRating(this DalRating rating)
{
return(new Rating
{
Id = rating.Id,
UserId = rating.UserId,
Value = rating.Value,
SkillId = rating.SkillId
});
}
public static RatingEntity ToBllRating(this DalRating rating)
{
return(new RatingEntity
{
Id = rating.Id,
SkillId = rating.SkillId,
UserId = rating.UserId,
Value = rating.Value
});
}
public void Update(DalRating entity)
{
var oldRating = context.Set <Rating>()
.FirstOrDefault(r => r.Id == entity.Id);
if (oldRating != null)
{
oldRating.Value = entity.Value;
context.Entry(oldRating).State = EntityState.Modified;
}
}
public static Rating ToOrm(DalRating rating)
{
if (rating == null)
{
throw new ArgumentNullException(nameof(rating));
}
return(new Rating()
{
Id = rating.Id,
TextDescId = rating.TextDescId,
UserId = rating.UserId,
value = rating.Value
});
}
public static RatingEntity ToBllRating(this DalRating dalRating)
{
if (dalRating == null)
{
return(null);
}
return(new RatingEntity()
{
Id = dalRating.Id,
UserId = dalRating.UserId,
PhotoId = dalRating.PhotoId,
UserRate = dalRating.UserRate
});
}
public static Rating ToOrmRating(this DalRating dalRating)
{
if (dalRating == null)
{
return(null);
}
return(new Rating()
{
RatingId = dalRating.Id,
UserId = dalRating.UserId,
PhotoId = dalRating.PhotoId,
UserRate = dalRating.UserRate
});
}
public void Delete(DalRating entity)
{
var ratingToDelete = context.Set <Rating>().Single(r => r.Id == entity.Id);
context.Set <Rating>().Remove(ratingToDelete);
}
public void Create(DalRating entity)
{
context.Set <Rating>()
.Add(entity.ToOrmRating());
}
