public int Create(Text text)
{
using (var db = new DbSocialReader())
{
var query = from a in db.Text
where a.Id == text.Id
select a;
if (query.Any())
{
return(-1);
}
db.Insert(text);
// Apply Id on account object.
var lastId = (from a in db.Text orderby a.Id select a.Id).Max();
text.Id = lastId;
// To-Do: Apply Bulk insert
if (text.GetAuthors().Count > 0)
{
foreach (var author in text.GetAuthors())
{
var textToAuthor = new TextToAuthor {
TextId = text.Id, AuthorId = author.Id
};
db.Insert(textToAuthor);
}
}
// To-Do: Apply Bulk insert
if (text.GetGenres().Count > 0)
{
foreach (var genre in text.GetGenres())
{
var textToGenre = new TextToGenre {
TextId = text.Id, GenreId = genre.Id
};
db.Insert(textToGenre);
}
}
return(lastId);
}
}
public void Create(User user)
{
using (var db = new DbSocialReader())
{
var query = from u in db.User
where u.Id == user.Id || u.Name == user.Name
select u;
if (query.Any())
{
return;
}
db.Insert(user);
// Apply Id on account object.
var lastId = (from u in db.User orderby u.Id select u.Id).Max();
user.Id = lastId;
}
}
public void Create(Score score)
{
using (var db = new DbSocialReader())
{
var query = from s in db.Score
where s.Id == score.Id
select s;
if (query.Any())
{
return;
}
db.Insert(score);
// Apply Id on note object.
var lastId = (from s in db.Score orderby s.Id select s.Id).Max();
score.Id = lastId;
}
}
public void Create(Note note)
{
using (var db = new DbSocialReader())
{
var query = from a in db.Note
where a.Id == note.Id
select a;
if (query.Any())
{
return;
}
db.Insert(note);
// Apply Id on note object.
var lastId = (from a in db.Note orderby a.Id select a.Id).Max();
note.Id = lastId;
}
}
/*
* Returns id of inserted account.
* Returns -1 if failed.
*/
public int Create(Account account)
{
using (var db = new DbSocialReader())
{
var query = from a in db.Account
where a.Id == account.Id
select a;
if (query.Any())
{
return(-1);
}
db.Insert(account);
// Apply Id on account object.
var lastId = (from a in db.Account orderby a.Id select a.Id).Max();
account.Id = lastId;
return(lastId);
}
}
