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