public TEntity GetById(int Id)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
return(GetByIdInternal(context, Id));
}
}
public User GetByEmail(string email)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
return(context.Set <User>().FirstOrDefault(u => u.Email.Equals(email)));
}
}
public TEntity[] GetAll()
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
return(GetEntityQuery(context).ToArray());
}
}
public void ModifyUserData(User user)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
context.Entry(user).State = EntityState.Modified;
context.SaveChanges();
}
}
public User GetByEmailAndPassword(string email, string password)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
return(context.Set <User>().FirstOrDefault(u => u.Email.Equals(email) &&
u.Password.Equals(password)));
}
}
public void Add(TEntity entity)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
context.Set <TEntity>().Add(entity);
context.SaveChanges();
}
}
public void Update(TEntity entity)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
context.Set <TEntity>().Attach(entity);
context.Entry(entity).State = EntityState.Modified;
context.SaveChanges();
}
}
public void Delete(int Id)
{
using (BuildingServiceContext context = new BuildingServiceContext())
{
TEntity entity = GetByIdInternal(context, Id);
if (entity == null)
{
return;
}
context.Set <TEntity>().Remove(entity);
context.SaveChanges();
}
}
protected virtual TEntity GetByIdInternal(BuildingServiceContext context, int id)
{
return(GetEntityQuery(context).FirstOrDefault(e => e.Id == id));
}
protected virtual IQueryable <TEntity> GetEntityQuery(BuildingServiceContext context)
{
return(context.Set <TEntity>());
}
