public bool AddNewSubject(long userId, long subjectId) { UserSubjects objUserSubject = null; objUserSubject = new UserSubjects(); objUserSubject.UserId = userId; objUserSubject.SubjectId = Convert.ToInt32(subjectId); objUserSubject.InsertedBy = _userStatistics.UserId; if (this.repository.AssignSubjectToUser(objUserSubject)) { return(true); } return(false); }
private void AssignSubject(string subjectIds, long userId, long studentId) { if (subjectIds != null) { var idList = subjectIds.Split(','); UserSubjects objUserSubject = null; foreach (var subjectId in idList) { objUserSubject = new UserSubjects(); objUserSubject.UserId = userId; objUserSubject.StudentId = studentId; objUserSubject.SubjectId = Convert.ToInt32(subjectId); objUserSubject.InsertedBy = _userStatistics.UserId; this.repository.AssignSubjectToUser(objUserSubject); } } }
public async Task <bool> PairSubjectsWithStudents() { var users = await _userService.GetUsers(); var students = users.FindAll(u => u.RoleId == 3); if (students == null || students.Count < 1) { throw new Exception("Insert classrooms into database prior"); } List <Subject> subjects = await _service.GetSubjects(); if (subjects == null || subjects.Count < 1) { throw new Exception("Insert subjects into database prior"); } var pairs = new List <UserSubjects>(); for (int j = 0; j < 500; ++j) { var subject = subjects[j]; for (int i = 0; i < _random.Next(5, 20); i++) { UserSubjects pair = new UserSubjects() { StudentId = students[_random.Next(students.Count)].UserId, SubjectId = subject.SubjectId }; if (!pairs.Contains(pair)) { pairs.Add(pair); } else { Console.WriteLine("click"); } } } bool success = await _service.PairSubjectWithStudents(pairs); return(success); }
public bool AssignSubjectToUser(UserSubjects objUserSubject) { var parameters = new { UserId = objUserSubject.UserId, SubjectId = objUserSubject.SubjectId, InsertedOn = DateTime.Now, InsertedBy = objUserSubject.InsertedBy, StudentId = objUserSubject.StudentId }; using (IDbConnection connection = OpenConnection()) { const string storedProcedure = "usp_AssignSubjectToUser"; int rowsAffected = connection.Execute(storedProcedure, parameters, commandType: CommandType.StoredProcedure); // SetIdentity<int>(connection, id => objUserSubject.GroupId = id); if (rowsAffected > 0) { return(true); } return(false); } }