public IEnumerable<IssueViewedState> UnreadIssues(User aUser) { return (from v in theEntities.IssueViewedStates where v.UserId == aUser.Id && v.Viewed == false select v).ToList<IssueViewedState>(); }
public PetitionSignature GetPetitionSignature(User aUser, int aPetitionId) { return (from s in theEntities.PetitionSignatures where s.PetitionId == aPetitionId && s.UserId == aUser.Id select s).FirstOrDefault<PetitionSignature>(); }
public void AddPhotoComplaint(User aFiledBy, string aComplaint, int aPictureId) { PhotoComplaint myPhotoComplaint = PhotoComplaint.CreatePhotoComplaint(0, aFiledBy.Id, aPictureId, aComplaint); theEntities.AddToPhotoComplaints(myPhotoComplaint); theEntities.SaveChanges(); }
public void AddIssueReplyComplaint(User aFiledBy, string aComplaint, int anIssueReplyId) { IssueReplyComplaint myIssueReplyComplaint = IssueReplyComplaint.CreateIssueReplyComplaint(0, aFiledBy.Id, anIssueReplyId, aComplaint); theEntities.AddToIssueReplyComplaints(myIssueReplyComplaint); theEntities.SaveChanges(); }
public void DeleteIssue(User aDeletingUser, Issue anIssue, bool anAdminDelete) { anIssue.Deleted = true; anIssue.DeletedByUserId = aDeletingUser.Id; theEntities.ApplyCurrentValues(anIssue.EntityKey.EntitySetName, anIssue); theEntities.SaveChanges(); }
public void AddProfileComplaint(User aFiledBy, string aComplaint, int aTowardUserId) { ProfileComplaint myProfileComplaint = ProfileComplaint.CreateProfileComplaint(0, aFiledBy.Id, aTowardUserId, aComplaint); theEntities.AddToProfileComplaints(myProfileComplaint); theEntities.SaveChanges(); }
public void CreateTokenForEmail(User aCreatingUser, string anEmail, string aToken, string anAuthorityType, string anAuthorityPosition) { Role myRole = GetRoleByName(anAuthorityType); AuthorityVerification myVerification = AuthorityVerification.CreateAuthorityVerification(anEmail, aCreatingUser.Id, myRole.Id, aToken, false, DateTime.UtcNow, anAuthorityPosition); theEntities.AddToAuthorityVerifications(myVerification); theEntities.SaveChanges(); }
public IEnumerable<FriendConnectionModel> FindUsersBasedOnQuestion(User aUser, IEnumerable<string> aQuestionNames) { Dictionary<string, int> myQuestionToAnswers = new Dictionary<string, int>(); foreach (string myQuestionName in aQuestionNames) { UserProfileQuestionAnswer myAnswer = GetProfileQuesitonAnswerForUser(aUser, myQuestionName); if (myAnswer != null) { myQuestionToAnswers.Add(myQuestionName, myAnswer.Answer); } } if (myQuestionToAnswers.Keys.Count == 0) { return new List<FriendConnectionModel>(); } else { List<FriendConnectionModel> myFriendConnections = new List<FriendConnectionModel>(); foreach(string myQuestionName in aQuestionNames) { if (myQuestionToAnswers.Keys.Contains(myQuestionName)) { int myAnswer = myQuestionToAnswers[myQuestionName]; IEnumerable<FriendConnectionModel> myResults = (from a in theEntities.UserProfileQuestionAnswers where a.UserProfileQuestionName == myQuestionName && a.Answer == myAnswer && a.UserId != aUser.Id select new FriendConnectionModel() { User = a.User, QuestionConnectionMadeFrom = a.UserProfileQuestion }); myFriendConnections.AddRange(myResults); } } return myFriendConnections; } }
public Petition CreatePetition(User aUserCreating, string aTitle, string aBody, string aCity, string aState, string aZip) { Petition myPetition = Petition.CreatePetition(0, aUserCreating.Id, aTitle, aBody, aCity, aState, aZip, DateTime.UtcNow, true); theEntities.AddToPetitions(myPetition); theEntities.SaveChanges(); return myPetition; }
public int NewMessageCount(User aRequestingUser) { int myTotalUnreadReceived = theNavRepo.GetUnreadMessagesReceivedCount(aRequestingUser); int myTotalUnreadSent = theNavRepo.GetUnreadMessagesSentCount(aRequestingUser); return myTotalUnreadReceived + myTotalUnreadSent; }
public IEnumerable<GroupInvitation> GroupInvitations(User aUser) { return (from i in theEntities.GroupInvitations where i.UserId == aUser.Id && i.Viewed == false && i.Accepted == HAVConstants.PENDING select i); }
public void ActivateGroup(User aUser, int aGroupId) { Group myClub = GetGroup(aGroupId); myClub.DeactivatedByUserId = null; myClub.DeactivatedDateTimeStamp = null; myClub.Active = true; theEntities.SaveChanges(); }
public bool ProfileComplaint(User aFiledBy, string aComplaint, int aTowardUserId) { if (!ValidComplaint(aComplaint, aTowardUserId)) { return false; } theRepository.AddProfileComplaint(aFiledBy, aComplaint, aTowardUserId); return true; }
public void SetPetitionAsInactive(User aUser, int aPetitionId) { Petition myPetition = GetPetition(aPetitionId); myPetition.Active = false; myPetition.DeactivatedByUserId = aUser.Id; myPetition.DeactivatedDateTimeStamp = DateTime.UtcNow; theEntities.SaveChanges(); }
public bool IssueReplyComplaint(User aFiledBy, string aComplaint, int aIssueReplyId) { if (!ValidComplaint(aComplaint, aIssueReplyId)) { return false; } theRepository.AddIssueReplyComplaint(aFiledBy, aComplaint, aIssueReplyId); return true; }
public void AddIssueReplyCommentComplaint(User aFiledBy, string aComplaint, int anIssueReplyCommentId) { IHAVIssueRepository myIssueRepo = new EntityHAVIssueRepository(); IssueReplyCommentComplaint issueReplyCommentComplaint = IssueReplyCommentComplaint.CreateIssueReplyCommentComplaint(0, aFiledBy.Id, anIssueReplyCommentId, aComplaint); theEntities.AddToIssueReplyCommentComplaints(issueReplyCommentComplaint); theEntities.SaveChanges(); }
public bool AddFeedback(User aUser, string aFeedback) { if (!ValidFeedback(aFeedback)) { return false; } theRepository.AddFeedback(aUser, aFeedback); return true; }
public UserRegionSpecific GetRegionSpecifcInformationForUser(User aUser, UserPosition aUserPosition) { return (from urs in theEntities.UserRegionSpecifics join rs in theEntities.RegionSpecifics on urs.RegionSpecificId equals rs.Id where urs.UserId == aUser.Id && rs.UserPositionId == aUserPosition.Position select urs).FirstOrDefault<UserRegionSpecific>(); }
public bool PhotoComplaint(User aFiledBy, string aComplaint, int aPhotoId) { if (!ValidComplaint(aComplaint, aPhotoId)) { return false; } theRepository.AddPhotoComplaint(aFiledBy, aComplaint, aPhotoId); return true; }
public Event AddEvent(User aUser, DateTime aStartDate, DateTime anEndDate, string aTitle, string anInformation) { IUserRepository<User, Role, UserRole> myUserRepo = new EntityHAVUserRepository(); Event myEvent = Event.CreateEvent(0, aUser.Id, aStartDate, anEndDate , aTitle, anInformation, false); theEntities.AddToEvents(myEvent); theEntities.SaveChanges(); return myEvent; }
public void AddUserToIgnoreList(User aUser, int aUserIdToIgnore) { FriendSuggestionIgnore myFriendSuggestion = GetFriendSuggestionIgnore(aUser, aUserIdToIgnore); if (myFriendSuggestion == null) { FriendSuggestionIgnore myIgnore = FriendSuggestionIgnore.CreateFriendSuggestionIgnore(0, aUser.Id, aUserIdToIgnore); theEntities.AddToFriendSuggestionIgnores(myIgnore); theEntities.SaveChanges(); } }
public bool AddIssueStance(User aUser, int anIssueId, int aDisposition) { if (theIssueRepository.HasIssueStance(aUser, anIssueId)) { return false; } else { theIssueRepository.CreateIssueStance(aUser, anIssueId, aDisposition); return true; } }
public Issue CreateIssue(Issue anIssueToCreate, User aUserCreating) { anIssueToCreate = Issue.CreateIssue(0, anIssueToCreate.Title, anIssueToCreate.Description, aUserCreating.City, aUserCreating.State, aUserCreating.Zip, DateTime.UtcNow, aUserCreating.Id, false); theEntities.AddToIssues(anIssueToCreate); theEntities.SaveChanges(); return anIssueToCreate; }
public void CreateCommentToIssueReply(User aUserCreating, int anIssueReplyId, string aComment) { IssueReplyComment myIssueReplyComment = IssueReplyComment.CreateIssueReplyComment(0, anIssueReplyId, aComment, DateTime.UtcNow, aUserCreating.Id, false); theEntities.AddToIssueReplyComments(myIssueReplyComment); IssueReplyViewedHelper.UpdateCurrentIssueReplyViewedStateAndAddIfNecessaryWithoutSave(theEntities, aUserCreating.Id, anIssueReplyId); theEntities.SaveChanges(); }
public IEnumerable<Board> UnreadBoardMessages(User aUser) { return (from b in theEntities.Boards join v in theEntities.BoardViewedStates on b.Id equals v.BoardId where v.Viewed == false && b.OwnerUserId == aUser.Id && v.UserId == aUser.Id select b).ToList<Board>(); }
public IEnumerable<GroupMember> UnreadGroupBoardPosts(User aUser) { return (from gm in theEntities.GroupMembers where gm.MemberUserId == aUser.Id && !gm.Deleted && !gm.OldRecord && !gm.BoardViewed select gm); }
public IEnumerable<IssueReplyViewedState> UnreadIssueReplies(User aUser) { return (from v in theEntities.IssueReplyViewedStates join ir in theEntities.IssueReplys on v.IssueReplyId equals ir.Id where v.Viewed == false && v.UserId == aUser.Id && ir.UserId == aUser.Id select v).ToList<IssueReplyViewedState>(); }
public IEnumerable<BoardViewedState> UnreadParticipatingBoardMessages(User aUser) { return (from v in theEntities.BoardViewedStates join b in theEntities.Boards on v.BoardId equals b.Id where v.Viewed == false && v.UserId == aUser.Id && b.OwnerUserId != aUser.Id select v).ToList<BoardViewedState>(); }
public void DeleteEvent(User aUser, int anEventId, bool anAdminDelete) { Event myEvent = GetEvent(anEventId); if (myEvent.User.Id == aUser.Id || anAdminDelete) { myEvent.Deleted = true; myEvent.DeletedUserId = aUser.Id; theEntities.ApplyCurrentValues(myEvent.EntityKey.EntitySetName, myEvent); theEntities.SaveChanges(); } }
public void AddZipCodesForUser(User anAdminUser, string anEmail, IEnumerable<int> aZipCodes) { User myAuthority = GetUser(anEmail); foreach(int myZipCode in aZipCodes) { AuthorityViewableZipCode myAuthorityZipCode = AuthorityViewableZipCode.CreateAuthorityViewableZipCode(0, myAuthority.Id, myZipCode, anAdminUser.Id, DateTime.UtcNow); theEntities.AddToAuthorityViewableZipCodes(myAuthorityZipCode); } theEntities.SaveChanges(); }