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