public static bool RemoveUser(int id)
{
try
{
using (var db = new AdapterDbEntities())
{
var user = db.User.Find(id);
foreach (var role in user.Roles.ToList())
{
user.Roles.Remove(role);
}
var membership = db.BusinessMember.Where(bm => bm.UserId == id);
db.BusinessMember.RemoveRange(membership);
db.Set <User>().Remove(user);
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
log.Error("RemoveUser error", ex);
return(false);
}
}
public static List <TPoco> GetAll <TEntity, TPoco>(Func <IEnumerable <TEntity>, IEnumerable <TPoco> > map) where TEntity : class
{
using (var db = new AdapterDbEntities())
{
var dbList = db.Set <TEntity>().ToList();
var list = map(dbList).ToList();
return(list);
}
}
public static TPoco Find <TEntity, TPoco>(int id, Func <TEntity, TPoco> map) where TEntity : class
{
using (var db = new AdapterDbEntities())
{
var dbObj = db.Set <TEntity>().Find(id);
var obj = map(dbObj);
return(obj);
}
}
public static TPoco Last <TEntity, TKey, TPoco>(Expression <Func <TEntity, TKey> > expr, Func <TEntity, TPoco> map) where TEntity : class
{
using (var db = new AdapterDbEntities())
{
var dbObj = db.Set <TEntity>().OrderByDescending(expr).FirstOrDefault();
if (dbObj == null)
{
return(default(TPoco));
}
var obj = map(dbObj);
return(obj);
}
}