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