public virtual void Remove(T item)
{
using (var context = new Database())
{
context.Entry(ConvertToEntity(item)).State = EntityState.Deleted;
context.SaveChanges();
}
}
public Role FindByName(string name)
{
Role role = null;
using (var context = new Database())
{
var entityRole = context.Roles.FirstOrDefault(x => x.Name == name);
role = ConvertToModel(entityRole);
}
return(role);
}
public T FindById(int id)
{
T modelItem;
using (var contex = new Database())
{
var item = contex.Set <K>().Find(id);
modelItem = ConvertToModel(item);
}
return(modelItem);
}
public User GetByEmail(string login)
{
User user = null;
using (var context = new Database())
{
var entityUser = context.Users
.FirstOrDefault(x => x.Email == login);
user = ConvertToModel(entityUser);
}
return(user);
}
public User GetByEmailAndPassword(string login, string password)
{
User user = null;
using (var context = new Database())
{
var entityUser = context.Users
.FirstOrDefault(x => x.Email == login && x.Password == password);
user = ConvertToModel(entityUser);
}
return(user);
}
public List <User> GetUserByPositionId(int positionId)
{
var users = new List <User>();
using (var context = new Database())
{
users = context.Users
.Where(x => x.PositionId == positionId)
.ToList()
.Select(x => ConvertToModel(x))
.ToList();
}
return(users);
}
public virtual IEnumerable <T> GetAll()
{
IEnumerable <T> list;
using (var context = new Database())
{
list = context
.Set <K>()
.AsNoTracking()
.ToList()
.Select(x => ConvertToModel(x))
.ToList();
}
return(list ?? new List <T>());
}
