public IQueryable <Student> GetList(StudentDBContent db)
{
IQueryable <Student>
list = db.Students.AsQueryable();
return(list);
}
public Student GetById(int id)
{
using (StudentDBContent db = new StudentDBContent())
{
return(db.Students.SingleOrDefault(a => a.Id == id));
}
}
public int Create(Student entity)
{
using (StudentDBContent db = new StudentDBContent())
{
db.Set <Student>().Add(entity);
return(db.SaveChanges());
}
}
public int Edit(Student entity)
{
using (StudentDBContent db = new StudentDBContent())
{
db.Set <Student>().Attach(entity);
db.Entry <Student>(entity).State = EntityState.Modified;
return(db.SaveChanges());
}
}
public int Delete(int id)
{
using (StudentDBContent db = new StudentDBContent())
{
Student entity = db.Students.SingleOrDefault(a => a.Id == id);
db.Set <Student>().Remove(entity);
int row = db.SaveChanges();
return(row > 0 ? 1 : 0);
}
}
public bool IsExist(int id)
{
using (StudentDBContent db = new StudentDBContent())
{
Student entity = GetById(id);
if (entity != null)
{
return(true);
}
return(false);
}
}
