public void GetArchiveIdeas(RestAPIGetArchiveIdeaResponse response, int UserId) { List <RESTAPIIdeaInterchange> ideaInterchangeList = null; List <Idea> ideaList = null; DatabaseWrapper.databaseOperation(response, (context, query) => { ideaInterchangeList = new List <RESTAPIIdeaInterchange>(); ideaList = new List <Idea>(); ideaList = query.GetArchiveIdeas(context, UserId); if (ideaList.Count > 0) { foreach (var idea in ideaList) { RESTAPIIdeaInterchange ideaInterchange = new RESTAPIIdeaInterchange(idea); ideaInterchangeList.Add(ideaInterchange); } } response.Status = Success; } , readOnly: true ); if (ideaInterchangeList != null && ideaInterchangeList.Count > 0) { response.ArchiveIdeaList.AddRange(ideaInterchangeList); } }
public void SearchIdea(RestAPISearchIdeaResponse response, string title, int UserID) { List <RESTAPIIdeaInterchange> ideaInterchangeList = null; List <Idea> ideaList = null; DatabaseWrapper.databaseOperation(response, (context, query) => { ideaInterchangeList = new List <RESTAPIIdeaInterchange>(); ideaList = new List <Idea>(); if (!String.IsNullOrEmpty(title)) { ideaList = query.SearchIdea(context, UserID, title); if (ideaList.Count > 0) { foreach (var idea in ideaList) { if (idea.IsSensitive == false && idea.UserId != UserID) { RESTAPIIdeaInterchange ideaInterchange = new RESTAPIIdeaInterchange(idea); ideaInterchangeList.Add(ideaInterchange); } else if (idea.UserId == UserID) { RESTAPIIdeaInterchange ideaInterchange = new RESTAPIIdeaInterchange(idea); ideaInterchangeList.Add(ideaInterchange); } } } response.Status = Success; } else { response.ErrorList.Add(Faults.InvalidSearch); return; } } , readOnly: true ); if (ideaInterchangeList != null && ideaInterchangeList.Count > 0) { response.IdeaSearchList.AddRange(ideaInterchangeList); } }
public void GetPublicIdeas(RestAPIGetUserIdeaResponse response, int UserId, int CategoryId = 0, bool Sort = false) { List <RESTAPIIdeaInterchange> ideaInterchangeList = null; List <Idea> ideaList = null; DatabaseWrapper.databaseOperation(response, (context, query) => { ideaInterchangeList = new List <RESTAPIIdeaInterchange>(); ideaList = new List <Idea>(); if (!Sort) { ideaList = query.GetPublicIdeas(context, UserId, CategoryId); } else { ideaList = query.GetSortedPublicIdeas(context, UserId, CategoryId); } if (ideaList.Count > 0) { foreach (var idea in ideaList) { RESTAPIIdeaInterchange ideaInterchange = new RESTAPIIdeaInterchange(idea); ideaInterchangeList.Add(ideaInterchange); } } response.Status = Success; } , readOnly: true ); if (ideaInterchangeList != null && ideaInterchangeList.Count > 0) { response.IdeaList.AddRange(ideaInterchangeList); } }