public static void DeleteWord(int wordId)
{
WordBinEntities db = new WordBinEntities();
var word = db.Words.Where(x => x.Id.Equals(wordId)).FirstOrDefault();
db.Words.DeleteObject(word);
db.SaveChanges();
}
public static void RenameDictionary(int dictionaryId, string newName)
{
WordBinEntities db = new WordBinEntities();
var dict = db.Dictionaries.Where(x => x.Id.Equals(dictionaryId)).FirstOrDefault();
dict.Name = newName;
db.SaveChanges();
}
public static void AddDictionary(string name, string username)
{
WordBinEntities db = new WordBinEntities();
var user = db.Users.Where(x => x.UserName.Equals(username)).FirstOrDefault();
db.Dictionaries.AddObject(new Dictionary()
{
Name = name,
UserId = user.UserId
});
db.SaveChanges();
}
public static void AddWord(string word, string definition, string example, int dictionaryId)
{
WordBinEntities db = new WordBinEntities();
db.Words.AddObject(new Word()
{
Word1 = word,
Definition = definition,
Example = example,
DictionaryId = dictionaryId
});
db.SaveChanges();
}
public static void DeleteDictionary(int dictionaryId)
{
WordBinEntities db = new WordBinEntities();
var wordsForDictionary = db.Words.Where(w => w.DictionaryId.Equals(dictionaryId));
foreach (var word in wordsForDictionary)
{
db.DeleteObject(word);
}
var dict = db.Dictionaries.Where(x => x.Id.Equals(dictionaryId)).FirstOrDefault();
db.DeleteObject(dict);
db.SaveChanges();
}
public static void ModifyWord(int wordId, string newWord, string newDefinition, string newExample)
{
WordBinEntities db = new WordBinEntities();
var word = db.Words.Where(x => x.Id.Equals(wordId)).FirstOrDefault();
word.Word1 = newWord;
word.Definition = newDefinition;
if (newExample == null)
{
word.Example = string.Empty;
}
else
{
word.Example = newExample;
}
db.SaveChanges();
}