public HttpResponseMessage Get(int?top, int?id, int?authorid, int?subjectid) { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_articles = ee.GetArticles(id, null, null, null, authorid, subjectid, top).ToList(); var articles = new List <object>(); foreach (var article in ee_articles) { articles.Add(new { ID = article.ID, CreationTime = article.CreationTime, Description = article.Description, FilePath = article.FilePath, MainText = article.MainText, ModificationTime = article.ModificationTime, Title = article.Title, Authors = ee.GetArticlesAuthors(article.ID, null).ToList().Select(aa => aa.AuthorID).ToList(), Subjects = ee.GetArticlesSubjects(article.ID, null).ToList().Select(aa => aa.SubjectID).ToList(), IsImageOnly = article.IsImageOnly, IsTextOnly = article.IsTextOnly }); } return(Globals.FinishResponse(articles)); } }
public HttpResponseMessage Get(int top) { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_news = ee.GetNews(null, null, null, top).ToList(); return(Globals.FinishResponse(ee_news)); } }
public HttpResponseMessage Get(string username = null, string password = null) { using (ElectronicsEntities ee = new ElectronicsEntities()) { if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password)) { var a = ee.GetAuthors(null, null, null, username, password).FirstOrDefault(); a.Username = ""; a.Password = ""; HttpContext.Current.Session["LoggedAuthor"] = a; } return(Globals.FinishResponse((Author)HttpContext.Current.Session["LoggedAuthor"])); } }
public HttpResponseMessage Post() { HttpContext.Current.Request.InputStream.Seek(0, SeekOrigin.Begin); string requestJSON = new StreamReader(HttpContext.Current.Request.InputStream).ReadToEnd().ToString(); AuthorsRequest req = JsonConvert.DeserializeObject <AuthorsRequest>(requestJSON); using (ElectronicsEntities ee = new ElectronicsEntities()) { req.ID = ee.SetAuthor(req.ID, req.Name, req.FilePath, req.Description, req.Username, req.Password).FirstOrDefault(); return(Globals.FinishResponse(req)); } }
public HttpResponseMessage Delete() { HttpContext.Current.Request.InputStream.Seek(0, SeekOrigin.Begin); string requestJSON = new StreamReader(HttpContext.Current.Request.InputStream).ReadToEnd().ToString(); Article art = JsonConvert.DeserializeObject <Article>(requestJSON); using (ElectronicsEntities ee = new ElectronicsEntities()) { var res = ee.DeleteArticles(art.ID).FirstOrDefault(); return(Globals.FinishResponse(res)); } }
public HttpResponseMessage Post() { HttpContext.Current.Request.InputStream.Seek(0, SeekOrigin.Begin); string requestJSON = new StreamReader(HttpContext.Current.Request.InputStream).ReadToEnd().ToString(); Subject sbj = JsonConvert.DeserializeObject <Subject>(requestJSON); using (ElectronicsEntities ee = new ElectronicsEntities()) { var res = ee.SetSubject(sbj.ID, sbj.ParentID, sbj.Name).FirstOrDefault(); return(Globals.FinishResponse(res)); } }
public HttpResponseMessage Get() { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_authors = ee.GetAuthors(null, null, null, null, null).ToList(); foreach (var a in ee_authors) { a.Username = ""; a.Password = ""; } return(Globals.FinishResponse(ee_authors)); } }
public HttpResponseMessage Get(string q) { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_subjects = ee.GetSubjects(null, null, q).ToList(); var ee_articlesT = ee.GetArticles(null, q, null, null, null, null, null); var ee_articlesD = ee.GetArticles(null, null, q, null, null, null, null); var ee_articlesM = ee.GetArticles(null, null, null, q, null, null, null); var joined = ee_subjects.Select(s => new { Title = s.Name, ID = s.ID, Type = "S" }).ToList(); joined.AddRange(ee_articlesT.Select(a => new { Title = a.Title, ID = a.ID, Type = "A" }).ToList()); joined.AddRange(ee_articlesD.Select(a => new { Title = a.Title, ID = a.ID, Type = "A" }).ToList()); joined.AddRange(ee_articlesM.Select(a => new { Title = a.Title, ID = a.ID, Type = "A" }).ToList()); return(Globals.FinishResponse(joined)); } }
public HttpResponseMessage Post() { try { HttpContext.Current.Request.InputStream.Seek(0, SeekOrigin.Begin); string requestJSON = new StreamReader(HttpContext.Current.Request.InputStream).ReadToEnd().ToString(); ArticlesRequest req = JsonConvert.DeserializeObject <ArticlesRequest>(requestJSON); using (ElectronicsEntities ee = new ElectronicsEntities()) { var id = ee.SetArticle(req.ID, req.IsTextOnly && !string.IsNullOrEmpty(req.MainText) && req.MainText.IndexOf(" ") > 0 ? req.MainText.Substring(0, req.MainText.IndexOf(" ")) : req.Title, req.MainText ?? "", req.FilePath ?? "", req.Description ?? "", string.Join(",", req.Authors), string.Join(",", req.Subjects), req.IsImageOnly, req.IsTextOnly).FirstOrDefault(); return(Globals.FinishResponse(id)); } } catch (Exception ex) { return(Globals.FinishResponse(new { Error = true })); } }
public HttpResponseMessage Get() { using (ElectronicsEntities ee = new ElectronicsEntities()) { var ee_subjects = ee.GetSubjects(null, null, null); List <SubjectResponse> subjects = new List <SubjectResponse>(); foreach (var s in ee_subjects) { var ee_articles = ee.GetArticles(null, null, null, null, null, s.ID, null).ToList(); subjects.Add(new SubjectResponse { ID = s.ID, ParentID = s.ParentID, Name = s.Name, Articles = ee_articles.Select(a => new { ID = a.ID, Title = a.Title, URL = a.FilePath }) }); } return(Globals.FinishResponse(subjects)); } }