public PersonalityType GetPersonalityType(int id)
{
using (var db = new RevolutionEntities1())
{
return db.PersonalityTypes.FirstOrDefault(pt => pt.ID == id);
}
}
public List<PersonalityType> GetAllPersonalityTypes()
{
using (var db = new RevolutionEntities1())
{
return db.PersonalityTypes.ToList();
}
}
public Character GetCharacter(int id)
{
using (var db = new RevolutionEntities1())
{
var ch = db.Characters.Where(c => c.ID == id && !c.Deleted).FirstOrDefault();
return ch;
}
}
public Phrase GetPhrase(int id)
{
using (var db = new RevolutionEntities1())
{
var phrase = db.Phrases.Where(p => p.ID == id).FirstOrDefault();
return new Phrase { ID = phrase.ID, Immediacy = phrase.Immediacy, IsQuestion = phrase.IsQuestion, IsSpontaneous = phrase.IsSpontaneous, PersonalityPhrases = phrase.PersonalityPhrases, Text = phrase.Text, Topic = phrase.Topic, TopicID = phrase.TopicID };
}
}
public List<Character> GetAllCharacters()
{
using (var db = new RevolutionEntities1())
{
var chars = db.Characters.Select(ch => ch as Character).ToList();
return chars;
}
}
public Phrase SavePhrase(Phrase phrase)
{
using (var db = new RevolutionEntities1())
{
db.Phrases.Add(phrase);
db.SaveChanges();
return phrase;
}
}
public void RemoveCharacter(int id)
{
using (var db = new RevolutionEntities1())
{
var character = db.Characters.FirstOrDefault(c => c.ID == id);
if (character == null) return;
character.Deleted = true;
db.SaveChanges();
}
}
public void RemovePhrase(int id)
{
using (var db = new RevolutionEntities1())
{
var phrase = db.Phrases.FirstOrDefault(c => c.ID == id);
if (phrase == null) return;
db.Phrases.Remove(phrase);
db.SaveChanges();
}
}
public List<Character> GetCharacters(XElement query)
{
var serializer = new ExpressionSerializer();
var expression = serializer.Deserialize<Func<Character, bool>>(query);
if (expression == null)
return null;
using (var db = new RevolutionEntities1())
{
return db.Characters.Where(expression).ToList();
}
}
public List<Phrase> GetPhrasesByTopic(int topicId)
{
using (var db = new RevolutionEntities1())
{
return db.Phrases.Where(p => p.TopicID == topicId).Select(p => new Phrase
{ ID = p.ID,
Immediacy = p.Immediacy,
IsQuestion = p.IsQuestion,
IsSpontaneous = p.IsSpontaneous,
PersonalityPhrases = p.PersonalityPhrases,
Text = p.Text, Topic = p.Topic,
TopicID = p.TopicID
}).ToList();
}
}
public Character SaveCharacter(Character character)
{
using (var db = new RevolutionEntities1())
{
Character ch = db.Characters.Where(c => c.ID == character.ID).FirstOrDefault();
if (ch != default(Character))
{
db.Entry(ch).CurrentValues.SetValues(character);
}
else
{
db.Characters.Add(character);
}
db.SaveChanges();
return character;
}
}