public Task <T> FindByNameAsync(string normalizedUserName, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
return((Task <T>)Convert.ChangeType(db.User.FirstOrDefaultAsync(u => u.NormalizedUserName.Equals(normalizedUserName)), typeof(Task <T>)));
}
}
public Task <bool> IsInRoleAsync(T user, string roleName, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
return(Task.FromResult(db.UserInRole.Count(m => m.UserId.Equals(user.Id) && m.Role.NormalizedName.Equals(roleName)) > 0));
}
}
public Task <T> FindByIdAsync(string userId, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
return((Task <T>)Convert.ChangeType(db.User.FirstOrDefaultAsync(u => u.Id == userId), typeof(Task <T>)));
}
}
public Task <IdentityResult> DeleteAsync(T user, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
db.User.Where(u => u.Id == user.Id).Delete();
return(Success());
}
}
public Task <IList <string> > GetRolesAsync(T user, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
IList <string> l = db.UserInRole.Where(m => m.UserId.Equals(user.Id)).Select(m => m.Role.Name).ToList();
return(Task.FromResult(l));
}
}
public Task <IdentityResult> CreateAsync(T user, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
if (db.Insert(user) > 0)
{
return(Success());
}
return(Fail());
}
}
public Task <IdentityResult> UpdateAsync(T role, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
if (db.Update(role) > 0)
{
return(Success());
}
return(Fail());
}
}
public Task <IList <T> > GetUsersInRoleAsync(string roleName, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
IList <T> l = new List <T>();
foreach (var u in db.UserInRole.Where(m => m.Role.NormalizedName.Equals(roleName)).Select(m => m.User))
{
l.Add((T)u);
}
return(Task.FromResult(l));
}
}
public Task RemoveFromRoleAsync(T user, string roleName, CancellationToken cancellationToken)
{
cancellationToken.ThrowIfCancellationRequested();
using (var db = new WeatherDb())
{
var roleId = db.UserRole.First(r => r.NormalizedName.Equals(roleName)).Id;
db.Delete(new UserInRole()
{
UserId = user.Id, RoleId = roleId
});
}
return(Task.FromResult <object>(null));
}
public static void DeleteDashboardItems(WeatherDb db, string userId)
{
if (db.DataProvider.Name.Equals("SQLite"))
{
var ids = from item in db.DashboardItem
where item.UserId.Equals(userId)
select item.Id;
db.DashbordFilter
.Where(f => ids.Contains(f.DashboardItemId))
.Delete();
db.DashboardItem
.Where(item => ids.Contains(item.Id))
.Delete();
}
else
{
db.DashboardItem
.Where(item => item.UserId.Equals(userId))
.Delete();
}
}