public JsonResult GetDictPackageList()
{
DictionaryDBEntities1 DictEntities = new DictionaryDBEntities1();
var PackageList = from p in DictEntities.DictPackages
where p.UserName == User.Identity.Name
select new { p.Id, p.DictionaryName};
return Json(new { result = PackageList }, JsonRequestBehavior.AllowGet);
}
public ActionResult Create(DictModel model)
{
if (model == null) return Json("Error");
try
{
DictionaryDBEntities1 DictEntities = new DictionaryDBEntities1();
DictPackage dict = new DictPackage();
dict.UserName = User.Identity.Name;
dict.DictionaryName = model.DictionaryName;
dict.LanguageFrom = model.LanguageFrom;
dict.LanguageTo = model.LanguageTo;
DictEntities.DictPackages.Add(dict);
DictEntities.SaveChanges();
int id = (from p in DictEntities.DictPackages
where p.UserName == dict.UserName && p.DictionaryName == dict.DictionaryName && p.LanguageFrom == dict.LanguageFrom && p.LanguageTo == dict.LanguageFrom
orderby p.Id descending
select p.Id).First();
foreach (word word in model.word)
{
Word w = new Word();
w.PackageId = id;
w.LangToWord = word.LangToWord;
w.LangFromWord = word.LangFromWord;
DictEntities.Words.Add(w);
}
DictEntities.SaveChanges();
}
catch (DbEntityValidationException dbEx)
{
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
}
return Json("Success");
}
public JsonResult GetRunList(int? id)
{
List<RunModel> model = new List<RunModel>();
DictionaryDBEntities1 DictEntities = new DictionaryDBEntities1();
var words = from w in DictEntities.Words
where w.PackageId == id
select new { w.LangToWord, w.LangFromWord };
List<string> wrong = (from w in DictEntities.Words
select w.LangFromWord).ToList();
foreach (var w in words)
{
RunModel wordpair = new RunModel();
wordpair.LangFromWord = new List<string>();
wordpair.LangToWord = w.LangToWord;
wordpair.answer = Rnd.Next(5);
for (int i = 0; i < wordpair.answer; i++)
{
wordpair.LangFromWord.Add(wrong[Rnd.Next(wrong.Count)]);
}
wordpair.LangFromWord.Add(w.LangFromWord);
for (int i = wordpair.answer; i < 5; i++)
{
wordpair.LangFromWord.Add(wrong[Rnd.Next(wrong.Count)]);
}
model.Add(wordpair);
}
return Json(new { result = model }, JsonRequestBehavior.AllowGet);
}
