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