public void Delete(Score score)
{
using (var db = new DbSocialReader())
{
db.Delete(score);
}
}
public void Update(Genre genre)
{
using (var db = new DbSocialReader())
{
db.Update(genre);
}
}
public void Delete(Text text)
{
using (var db = new DbSocialReader())
{
db.Delete(text);
}
}
public void Update(User user)
{
using (var db = new DbSocialReader())
{
db.Update(user);
}
}
// Nullable
public Text GetById(int id)
{
using (var db = new DbSocialReader())
{
var query = from text in db.Text
join textToAuthor in db.TextToAuthor on text.Id equals textToAuthor.TextId
join author in db.Author on textToAuthor.AuthorId equals author.Id
where text.Id == id
select new { text, author };
if (query.Count() == 0)
{
return(null);
}
var result = query.First().text;
foreach (var arr in query.ToArray())
{
Console.WriteLine(arr);
result.AddAuthor(arr.author);
}
return(result);
}
}
public void Update(Text text)
{
using (var db = new DbSocialReader())
{
db.Update(text);
}
}
public void Delete(User user)
{
using (var db = new DbSocialReader())
{
db.Delete(user);
}
}
public void Delete(Author author)
{
using (var db = new DbSocialReader())
{
db.Delete(author);
}
}
public void Update(Author author)
{
using (var db = new DbSocialReader())
{
db.Update(author);
}
}
public void Delete(Genre genre)
{
using (var db = new DbSocialReader())
{
db.Delete(genre);
}
}
// Nullable
public Account GetByUsername(string username)
{
using (var db = new DbSocialReader())
{
/*var query = from a in db.Account
* where a.Username == username
* select a;
*
* return query.FirstOrDefault();*/
//db.Account.LoadWith(a=>a.Users).Where(a.Users.Where(User ))
var query = from a in db.Account
join user in db.User
on a.Id equals user.AccountId
where a.Username == username
select new { a, user };
/*Console.WriteLine(query.First().a);
* Console.WriteLine(query.First().user);
* Console.WriteLine(query.ToArray());*/
if (query.Count() == 0)
{
return(null);
}
var account = query.First().a;
foreach (var arr in query.ToArray())
{
//Console.WriteLine("arr.user: " + arr.user);
account.Users.Add(arr.user);
}
//account.Users.AddRange(query.First().users);
return(account);
}
}
public void Update(Score score)
{
using (var db = new DbSocialReader())
{
db.Update(score);
}
}
public void Update(Account account)
{
using (var db = new DbSocialReader())
{
db.Update(account);
}
}
public void Delete(Note note)
{
using (var db = new DbSocialReader())
{
db.Delete(note);
}
}
public void Delete(Account account)
{
using (var db = new DbSocialReader())
{
db.Delete(account);
}
}
public void Update(Note note)
{
using (var db = new DbSocialReader())
{
db.Update(note);
}
}
public List <Note> GetNotes()
{
using (var db = new DbSocialReader())
{
var query = from a in db.Note select a;
return(query.ToList());
}
}
// Nullable
public Note Read(int id)
{
using (var db = new DbSocialReader())
{
var q = from t in db.Note.LoadWith(prop => prop.User) where t.Id == id select t;
return(q.FirstOrDefault());
}
}
public List <Genre> GetGenres()
{
using (var db = new DbSocialReader())
{
var query = from g in db.Genre select g;
return(query.ToList());
}
}
public static List <User> All()
{
using (var db = new DbSocialReader())
{
var query = from u in db.User select u;
return(query.ToList());
}
}
public List <Account> All()
{
using (var db = new DbSocialReader())
{
var query = from a in db.Account select a;
return(query.ToList());
}
}
/**
*
* Get all authors from database
*
*/
public List <Author> GetAuthors()
{
using (var db = new DbSocialReader())
{
var query = from a in db.Author
select a;
return(query.ToList());
}
}
public List <Score> GetScores()
{
using (var db = new DbSocialReader())
{
var query = from s in db.Score
select s;
return(query.ToList());
}
}
public Author GetById(int id)
{
using (var db = new DbSocialReader())
{
var query = from a in db.Author
where a.Id == id
select a;
return(query.FirstOrDefault());
}
}
// Nullable
public Genre GetById(int id)
{
using (var db = new DbSocialReader())
{
var query = from g in db.Genre
where g.Id == id
select g;
return(query.FirstOrDefault());
}
}
// Nullable
public User GetByName(string name)
{
using (var db = new DbSocialReader())
{
var query = from u in db.User
where u.Name == name
select u;
return(query.FirstOrDefault());
}
}
// Nullable
public User GetById(int id)
{
using (var db = new DbSocialReader())
{
var query = from u in db.User
where u.Id == id
select u;
return(query.FirstOrDefault());
}
}
public Genre GetByName(string name)
{
using (var db = new DbSocialReader())
{
var query = from g in db.Genre
where g.Name == name
select g;
return(query.FirstOrDefault());
}
}
public Author GetByName(string name)
{
using (var db = new DbSocialReader())
{
var query = from a in db.Author
where a.Name == name
select a;
return(query.FirstOrDefault());
}
}
// Nullable
public Score Read(int id)
{
using (var db = new DbSocialReader())
{
var query = from s in db.Score
where s.Id == id
select s;
return(query.FirstOrDefault());
}
}
