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); }