public List <TagEntity> Read()
{
using (var database = new DBLab2Context())
{
return(database.Set <TagEntity>().ToList());
}
}
public ICollection <StudentEntity> Read()
{
using (var database = new DBLab2Context())
{
return(database.Set <StudentEntity>().ToList());
}
}
public TagEntity Read(int id)
{
using (var database = new DBLab2Context())
{
return(database.Tags.Find(id));
}
}
public StudentEntity Read(int id)
{
using (var database = new DBLab2Context())
{
return(database.Students.Find(id));
}
}
public void Create(PostEntity entity)
{
using (var database = new DBLab2Context())
{
database.Posts.Add(entity);
database.SaveChanges();
}
}
public void Delete(TagEntity entity)
{
using (var database = new DBLab2Context())
{
database.Tags.Attach(entity);
database.Tags.Remove(entity);
database.SaveChanges();
}
}
public void Update(TagEntity entity)
{
using (var database = new DBLab2Context())
{
database.Tags.Attach(entity);
var entry = database.Entry(entity);
entry.Property(e => e.Name).IsModified = true;
database.SaveChanges();
}
}
public void Delete(int id)
{
using (var database = new DBLab2Context())
{
var oldEntity = new TagEntity {
TagId = id
};
database.Tags.Attach(oldEntity);
database.Tags.Remove(oldEntity);
database.SaveChanges();
}
}
public void Delete(int id)
{
using (var database = new DBLab2Context())
{
var oldEntity = new CommentEntity {
CommentId = id
};
database.Comments.Attach(oldEntity);
database.Comments.Remove(oldEntity);
database.SaveChanges();
}
}
public void Create(int postId, TagEntity entity)
{
using (var database = new DBLab2Context())
{
var post = database.Posts.Find(postId);
entity.Posts = new List <PostEntity>();
entity.Posts.Add(post);
database.Tags.Add(entity);
database.SaveChanges();
}
}
public StudentEntity Read(StudentEntity entity)
{
using (var database = new DBLab2Context())
{
StudentEntity output = null;
foreach (var item in database.Students)
{
if ((item.FirstName == entity.FirstName) && (item.LastName == entity.LastName))
{
output = item;
break;
}
}
return(output);
}
}
