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); }