public void Create(DalMark entity)
{
var mark = new UserMovieMarks()
{
IdMovie = entity.MovieId,
IdUser = entity.UserId,
Mark = entity.Mark
};
context.Set<UserMovieMarks>().Add(mark);
context.SaveChanges();
}
//Mark
public static MarkEntity ToBllMark(this DalMark dalMark)
{
return(new MarkEntity()
{
Id = dalMark.Id,
MovieId = dalMark.MovieId,
UserId = dalMark.UserId,
Mark = dalMark.Mark,
Marks = dalMark.Marks,
Target = dalMark.Target
});
}
public void Update(DalMark entity)
{
var mark = context.Set<UserMovieMarks>().Where(x => x.Id == entity.Id).FirstOrDefault();
mark.Mark = entity.Mark;
mark.IdMovie = entity.MovieId;
mark.IdUser = entity.UserId;
context.Set<UserMovieMarks>().Attach(mark);
var entry = context.Entry(mark);
//entry.Property(x => x.Movies).IsModified = false;
//entry.Property(x => x.Users).IsModified = false;
entry.Property(x => x.Mark).IsModified = true;
context.SaveChanges();
}
public DalMark GetMovieMarks(int id)
{
var userList = context.Set<UserMovieMarks>().Where(x => x.IdMovie == id);
DalMark result = new DalMark()
{
Marks = new Dictionary<int, int>(),
Target = id
};
foreach (var item in userList)
{
result.Marks[item.IdUser] = item.Mark;
}
return result;
}
public void Delete(DalMark entity)
{
var result = context.Set<UserMovieMarks>().Where(x => x.Id == entity.Id).Single();
context.Set<UserMovieMarks>().Remove(result);
context.SaveChanges();
}
