public void Can_RecreateDatabase()
{
using (var context = new MvcSolutionDbContext())
{
if (context.Database.Exists())
{
context.Database.Delete();
}
context.Database.Create();
}
}
public void Can_Init_Database()
{
using (var db = new MvcSolutionDbContext())
{
var roleNames = new[] { Role.Names.SuperAdmin, Role.Names.SaleAgent, Role.Names.Dealer, Role.Names.Customer };
foreach (var name in roleNames)
{
if (!db.Roles.Any(x => x.Name == name))
{
db.Roles.Add(new Role()
{
Id = Guid.NewGuid(),
Name = name
});
}
}
db.SaveChanges();
}
}
public static PageResult<UserRoleDto> Build(this PageResult<UserRoleDto> result, MvcSolutionDbContext db)
{
if (result.Value.Count == 0)
{
return result;
}
var ids = result.Value.Select(x => x.UserId).ToArray();
var query = from a in db.UserRoleRLs
where ids.Contains(a.UserId)
select new
{
a.UserId,
a.Role.Name
};
var items = query.Distinct().ToList();
foreach (var dto in result.Value)
{
dto.Roles = items.Where(x => x.UserId == dto.UserId).Select(x => x.Name).OrderBy(x => x).ToArray();
}
return result;
}
public static PageResult<UserDto> Build(this PageResult<UserDto> result, MvcSolutionDbContext db)
{
if (result.Value.Count == 0)
{
return result;
}
var ids = result.Value.Select(x => x.Id).ToArray();
var tagQuery = from a in db.UserTagRLs
where ids.Contains(a.UserId)
select new
{
a.UserId,
a.Tag.Name
};
var tags = tagQuery.ToList();
foreach (var dto in result.Value)
{
dto.Tags = tags.Where(x => x.UserId == dto.Id).Select(x => x.Name).ToArray();
}
return result;
}
public void Can_RecreateDatabase()
{
var context = new MvcSolutionDbContext();
var sql =
@"
USE MASTER
DECLARE @i INT
SELECT @i=1
DECLARE @sSPID VARCHAR(100)
DECLARE KILL_CUR SCROLL CURSOR FOR
SELECT SPID FROM sysprocesses WHERE DBID=DB_ID('" + DbName + @"')
OPEN KILL_CUR
IF @@CURSOR_ROWS=0 GOTO END_KILL_CUR
FETCH FIRST FROM KILL_CUR INTO @sSPID
EXEC('KILL '+@sSPID)
WHILE @i<@@CURSOR_ROWS
BEGIN
FETCH NEXT FROM KILL_CUR INTO @sSPID
EXEC('KILL '+@sSPID)
SELECT @i=@i+1
END
END_KILL_CUR:
CLOSE KILL_CUR
DEALLOCATE KILL_CUR";
if (context.Database.Exists())
{
try
{
context.Database.ExecuteSqlCommand(sql);
}
catch (Exception)
{
}
}
context.Database.Delete();
context.Database.Create();
}
public static PageResult <UserDto> Build(this PageResult <UserDto> result, MvcSolutionDbContext db)
{
if (result.Value.Count == 0)
{
return(result);
}
var ids = result.Value.Select(x => x.Id).ToArray();
var tagQuery = from a in db.UserTagRLs
where ids.Contains(a.UserId)
select new
{
a.UserId,
a.Tag.Name
};
var tags = tagQuery.ToList();
foreach (var dto in result.Value)
{
dto.Tags = tags.Where(x => x.UserId == dto.Id).Select(x => x.Name).ToArray();
}
return(result);
}
public static PageResult <UserRoleDto> Build(this PageResult <UserRoleDto> result, MvcSolutionDbContext db)
{
if (result.Value.Count == 0)
{
return(result);
}
var ids = result.Value.Select(x => x.UserId).ToArray();
var query = from a in db.UserRoleRLs
where ids.Contains(a.UserId)
select new
{
a.UserId,
a.Role.Name
};
var items = query.Distinct().ToList();
foreach (var dto in result.Value)
{
dto.Roles = items.Where(x => x.UserId == dto.UserId).Select(x => x.Name).OrderBy(x => x).ToArray();
}
return(result);
}
