private void CreateTeams() { using (TaskboardEntities db = new TaskboardEntities()) { for (int i = 0; i < dataAmount / 100; i++) { try { if (creatorIndexes.Contains(i % 8)) { string uEmail = this.userEmails[i % 8] + i + emailDomain; int uId = db.USER.FirstOrDefault(x => x.email == uEmail).id; SqlParameter userId = new SqlParameter("@userId", uId); SqlParameter title = new SqlParameter("@teamName", this.teamNames[i % 8]); db.Database.ExecuteSqlCommand("[Team.Create] @userId, @teamName", userId, title); } } catch { continue; } } } }
private void AddBoards() { using (TaskboardEntities db = new TaskboardEntities()) { List <int> creatorsId = db.TEAM_USER.Where(x => x.role == "CREATOR").Select(u => u.id).ToList(); for (int j = 0; j < creatorsId.Count; j++) { for (int i = 0; i < dataAmount / 1000; i++) { try { SqlParameter userId = new SqlParameter("@userId", creatorsId[j]); SqlParameter title = new SqlParameter("@title", boardNames[i % 8]); SqlParameter projectId = new SqlParameter("@projectId", i); SqlParameter teamId = new SqlParameter("@teamId", i); db.Database.ExecuteSqlCommand("[Board.Create] @userId, @title, @projectId, @teamId", new[] { userId, title, projectId, teamId }); } catch { continue; } } } } }
private void AddUsersToTeam() { using (TaskboardEntities db = new TaskboardEntities()) { List <int> creatorsId = db.TEAM_USER.Where(x => x.role == "CREATOR").Select(u => u.id).ToList(); for (int j = 0; j < creatorsId.Count; j++) { for (int i = 0; i < dataAmount / 100; i++) { try { SqlParameter userId = new SqlParameter("@creatorId", creatorsId[j]); SqlParameter teamId = new SqlParameter("@teamId", i); SqlParameter userEmail = new SqlParameter("@userEmail", this.userEmails[i % 8] + i + emailDomain); var result = db.Database.ExecuteSqlCommand("[Team.AddUserToTeam] @creatorId, @teamId, @userEmail", new[] { userId, teamId, userEmail }); } catch { continue; } } } } }
private void LoginUsers() { using (TaskboardEntities db = new TaskboardEntities()) { for (int i = 0; i < dataAmount / 100; i++) { try { SqlParameter email = new SqlParameter("@email", this.userEmails[i % 8] + i + emailDomain); SqlParameter password = new SqlParameter("@password", this.password); db.Database.ExecuteSqlCommand("[User.Login] @email, @password", new[] { email, password }); } catch { continue; } } } }
private void RegisterUsers() { using (TaskboardEntities db = new TaskboardEntities()) { for (int i = 0; i < dataAmount / 100; i++) { try { string mail = $"{this.userEmails[i % 8]}{i}{emailDomain}"; SqlParameter email = new SqlParameter("@email", mail); SqlParameter password = new SqlParameter("@password", this.password); SqlParameter name = new SqlParameter("@name", this.userNames[i % 8]); db.Database.ExecuteSqlCommand("[User.Register] @email, @password, @name", new[] { email, password, name }); } catch { continue; } } } }