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 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 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();
}
public static List<Word> GetAllWordsForDictionary(int dictionaryId)
{
WordBinEntities db = new WordBinEntities();
var dictionary = db.Dictionaries.Where(dict => dict.Id.Equals(dictionaryId)).FirstOrDefault();
return db.Words.Where(x => x.DictionaryId == dictionary.Id).ToList();
}
public static Word FindWordById(int wordId)
{
WordBinEntities db = new WordBinEntities();
var word = db.Words.Where(x => x.Id.Equals(wordId)).FirstOrDefault();
return word;
}
public ActionResult ViewWords(int dictionaryId)
{
WordBinEntities db = new WordBinEntities();
List<Word> wordsForDictionary = WordDAL.GetAllWordsForDictionary(dictionaryId);
string dictionaryName = DictionaryDAL.GetDictionaryName(dictionaryId);
Tuple<List<WordViewModel>, int, string> viewModel = new Tuple<List<WordViewModel>, int, string>(new List<WordViewModel>(), dictionaryId, dictionaryName);
foreach (Word word in wordsForDictionary)
{
viewModel.Item1.Add(new WordViewModel(word));
}
return View(viewModel);
}
public ActionResult ViewDictionaries()
{
List<DictionaryViewModel> viewModel = new List<DictionaryViewModel>();
if (User.Identity.IsAuthenticated)
{
WordBinEntities db = new WordBinEntities();
List<Dictionary> dictionariesForUser = DictionaryDAL.GetAllDictionariesForUser(User.Identity.Name);
foreach (Dictionary dict in dictionariesForUser)
{
viewModel.Add(new DictionaryViewModel(dict));
}
}
return PartialView(viewModel);
}
public static string GetDictionaryName(int dictionaryId)
{
WordBinEntities db = new WordBinEntities();
var dict = db.Dictionaries.Where(x => x.Id.Equals(dictionaryId)).FirstOrDefault();
return dict.Name;
}
public static List<Dictionary> GetAllDictionariesForUser(string username)
{
WordBinEntities db = new WordBinEntities();
var user = db.Users.Where(x => x.UserName.Equals(username)).FirstOrDefault();
return db.Dictionaries.Where(dict => dict.UserId == user.UserId).ToList();
}
