public void AddContextSame() { var vectorData = new WordsContext(word); vectorData.AddContext(word); Assert.AreEqual(0, vectorData.Words.Count); }
public ActionResult Index([Bind(Include = "language,strategy")] LanguageAndStrategyContener lanStr) { using (wordcontext = new WordsContext()) { UserCl usercl = wordcontext.Users.Where(x => x.name == User.Identity.Name).FirstOrDefault(); if (usercl.languages.Where(x => x.id == lanStr.language.id).FirstOrDefault() == null) { if (usercl.languages.ToList() == null) { usercl.languages = new List <Language>(); } if (usercl.usersWords.ToList() == null) { usercl.usersWords = new List <UserWord>(); } IQueryable <Word> languageWords = wordcontext.Words.Where(x => x.foreignLanguage.id == lanStr.language.id); foreach (Word word in languageWords) { usercl.usersWords.Add(new UserWord() { lastTimeAccesed = DateTime.Now, levelOfKnowledge = 0, user = usercl, word = word }); } usercl.languages.Add(wordcontext.Languages.Where(x => x.id == lanStr.language.id).First()); } usercl.settings.currentLangage = usercl.languages.FirstOrDefault(x => x.id == lanStr.language.id); usercl.settings.numberOfWordsPerLearning = lanStr.strategy.id; wordcontext.SaveChanges(); return(RedirectToAction("Index", "Home")); } }
//public ActionResult CreateNewDuplicate() //{ // try // { // using (var ctx = new WordsContext()) // { // var model = new Models.DuplicatesModel(); // //CREATE NEW DUPLICATE // int order = ctx.Duplicates.OrderByDescending(i => i.Order).Take(1).Select(x => x.Order).FirstOrDefault(); // order++; // var dup = ctx.Duplicates.Add(new Duplicate() { Answer1 = "xxx", Answer2 = "xxx", Answer3 = "xxx", Answer4 = "xxx", Order = order }); // ctx.SaveChanges(); // model.Duplicate = dup; // return View(model); // } // } // catch (Exception ex) // { // throw ex; // } //} public ActionResult CreateCollection() { using (var ctx = new WordsContext()) { var collection = new Collection() { Name = "Empty" + DateTime.Now.Millisecond }; var dup = new List <Duplicate>(); for (int i = 0; i < 10; i++) { dup.Add(new Duplicate() { Order = i, Collection = collection }); } //collection.Duplicates = dup; collection.Type = collectionType.duplicates; ctx.Collections.Add(collection); ctx.SaveChanges(); } Response.StatusCode = (int)System.Net.HttpStatusCode.OK; return(RedirectToAction("Index", "Duplicates")); }
public JsonResult AddNewLanguageWords() { bool isAuthenticated = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated; if (!isAuthenticated) { return(null); } using (wordContext = new WordsContext()) { usercl = wordContext.Users.Where(x => x.name == User.Identity.Name).FirstOrDefault(); IEnumerable <UserWord> userLanguageWords = usercl.usersWords.Where(x => x.word.foreignLanguage.id == usercl.settings.currentLangage.id); IQueryable <Word> newLanguageWords = wordContext.Words.Where(x => x.foreignLanguage.id == usercl.settings.currentLangage.id); int numberOfNewWords = 0; foreach (Word word in newLanguageWords) { if (userLanguageWords.FirstOrDefault(x => x.word.id == word.id) == null) { usercl.usersWords.Add(new UserWord() { lastTimeAccesed = DateTime.Now, levelOfKnowledge = 0, user = usercl, word = word }); numberOfNewWords++; } } wordContext.SaveChanges(); return(Json(numberOfNewWords, JsonRequestBehavior.AllowGet)); } }
public void T1_TestDbConnection() { var db = new WordsContext(); Console.WriteLine("Testausgabe: " + db.Categories.Count()); Assert.AreEqual(true, db.Categories.Count() > 0); }
public List <Word> Get() { using (var Context = new WordsContext()) { return(Context.Words.ToList()); } }
public ActionResult Learn() { using (wordContext = new WordsContext()) { try { usercl = wordContext.Users.Where(x => x.name == User.Identity.Name).FirstOrDefault(); if (usercl.languages.Count < 1) { return(RedirectToAction("Index", "ChooseLanguage")); } IEnumerable <Language> userLanguages = usercl.languages.ToList(); SelectList sl = new SelectList(from e in userLanguages select new { Value = e.id, Text = e.name }, "Value", "Text"); return(View(sl)); } catch (Exception e) { return(View("Error")); } } }
public ActionResult CreateCollection() { using (var ctx = new WordsContext()) { var collection = new Collection() { Name = "Empty" + DateTime.Now.Millisecond }; var words = new List <Word>(); for (int i = 0; i < 10; i++) { words.Add(new Word() { Part1 = "", Part2 = "", Part3 = "", Part4 = "", Collection = collection }); } //collection.Words = words; collection.Type = collectionType.words; ctx.Collections.Add(collection); ctx.SaveChanges(); } Response.StatusCode = (int)HttpStatusCode.OK; return(RedirectToAction("Index", "Words")); }
public ActionResult ManageWords(int?collectionid) { try { using (var ctx = new WordsContext()) { if (collectionid == null) { collectionid = -1; } var model = new Models.MainModel(); model.Words = ctx.Words.Include(x => x.Image).Where(x => x.Collection.CollectionId == collectionid).ToList(); model.CollectionId = collectionid; var c = ctx.Collections.Include(x => x.Image).Where(x => x.CollectionId == collectionid).FirstOrDefault(); if (c != null) { model.CollectionName = c.Name; } if (c.Image != null) { model.CollectionPictureId = c.Image.PictureId; } return(View(model)); } } catch (Exception ex) { throw ex; } }
public ActionResult Index(int?collectionid, bool ordenades = false) { using (var ctx = new WordsContext()) { if (collectionid == null) { collectionid = ctx.Collections.Min(x => x.CollectionId); } var model = new Models.MainModel() { Words = ctx.Words.Include(x => x.Image).Where(x => x.Collection.CollectionId == collectionid).ToList(), CollectionId = collectionid }; var c = ctx.Collections.Include(x => x.Image).Where(x => x.CollectionId == collectionid).FirstOrDefault(); if (c != null) { model.CollectionName = c.Name; } if (c.Image != null) { model.CollectionPictureId = c.Image.PictureId; } model.Ordenades = ordenades; return(View(model)); } }
public ActionResult ManageDuplicatesAjax(string duplicateid, string question, string answer1, string answer2, string answer3, string answer4, bool answer1iscorrect, bool answer2iscorrect, bool answer3iscorrect, bool answer4iscorrect) { if (!(Session["IsAdmin"] != null && Session["IsAdmin"].ToString().ToUpper() == "TRUE")) { return(Content("Not allowed", MediaTypeNames.Text.Plain)); } using (var ctx = new WordsContext()) { var dup = ctx.Duplicates.Where(x => x.DuplicateId.ToString() == duplicateid).SingleOrDefault(); dup.Question = question; dup.Answer1 = answer1; dup.Answer2 = answer2; dup.Answer3 = answer3; dup.Answer4 = answer4; dup.Answer1IsCorrect = answer1iscorrect; dup.Answer2IsCorrect = answer2iscorrect; dup.Answer3IsCorrect = answer3iscorrect; dup.Answer4IsCorrect = answer4iscorrect; ctx.ChangeTracker.DetectChanges(); //alternative is to set context.Configuration.AutoDetectChangesEnabled = true ctx.SaveChanges(); } // Response.StatusCode = (int)HttpStatusCode.OK; return(Content("Message sent!", MediaTypeNames.Text.Plain)); // return View(model); }
public void Create() { var vectorData = new WordsContext(word); Assert.AreEqual(word, vectorData.Word); Assert.AreEqual(0, vectorData.Words.Count); }
public WordsService(WordsContext wordsContext, IFileReader fileReader) { _fileReader = fileReader; _context = wordsContext; var entityType = _context.Model.FindEntityType(typeof(Word)); _wordsTableName = entityType.GetTableName(); }
public static void Add(Word word) { using (wordsContext = new WordsContext()) { wordsContext.Words.Add(word); wordsContext.SaveChanges(); } }
/// <summary> /// Initializes the singleton application object. This is the first line of authored code /// executed, and as such is the logical equivalent of main() or WinMain(). /// </summary> public App() { InitializeComponent(); Suspending += OnSuspending; using (var db = new WordsContext()) { db.Database.Migrate(); } }
public void AddContext() { var addingWord = new WordEx(new SimpleWord("Test")); var vectorData = new WordsContext(word); vectorData.AddContext(addingWord); Assert.AreEqual(1, vectorData.Words.Count); vectorData.AddContext(addingWord); Assert.AreEqual(2, vectorData.Words.Count); }
public JsonResult LevelUp(int option) { using (wordcontext = new WordsContext()) { UserCl usercl = wordcontext.Users.Where(x => x.name == User.Identity.Name).FirstOrDefault(); wordcontext.UserWords.Where(x => x.id == option).First().levelOfKnowledge = 10; wordcontext.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteCollection(int collectionid) { using (var ctx = new WordsContext()) { ctx.Words.RemoveRange(ctx.Words.Where(x => x.Collection.CollectionId == collectionid)); ctx.Collections.RemoveRange(ctx.Collections.Where(x => x.CollectionId == collectionid)); ctx.SaveChanges(); } return(RedirectToAction("Index", "Words")); }
public ActionResult UploadImage(string FileUpload, string DuplicateId, int Num) { if (!(Session["IsAdmin"] != null && Session["IsAdmin"].ToString().ToUpper() == "TRUE")) { return(Content("Not allowed", System.Net.Mime.MediaTypeNames.Text.Plain)); } using (var ctx = new WordsContext()) { using (var image = System.Drawing.Image.FromStream(Request.Files[0].InputStream)) { using (var scaledImage = ImageController.ScaleImage(image, 300, 300)) { MemoryStream ms = new MemoryStream(); scaledImage.Save(ms, ImageFormat.Jpeg); var dup = ctx.Duplicates.Where(x => x.DuplicateId.ToString() == DuplicateId).SingleOrDefault(); switch (Num) { case 0: dup.ImageQuestion = new Picture(); dup.ImageQuestion.Content = ms.ToArray(); break; case 1: dup.Image1 = new Picture(); dup.Image1.Content = ms.ToArray(); break; case 2: dup.Image2 = new Picture(); dup.Image2.Content = ms.ToArray(); break; case 3: dup.Image3 = new Picture(); dup.Image3.Content = ms.ToArray(); break; case 4: dup.Image4 = new Picture(); dup.Image4.Content = ms.ToArray(); break; } ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); } } } return(Json(new { success = "Valid" })); }
public ActionResult ChangeCollectionName(string collectionname, int collectionid) { using (var ctx = new WordsContext()) { var collectionToChange = ctx.Collections.Where(x => x.CollectionId == collectionid).SingleOrDefault(); collectionToChange.Name = collectionname; ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); } return(Json(new { success = "Valid" })); }
public ActionResult Upload(string File, int WordId, int PartId) { if (!(Session["IsAdmin"] != null && Session["IsAdmin"].ToString().ToUpper() == "TRUE")) { return(Content("Not allowed", System.Net.Mime.MediaTypeNames.Text.Plain)); } var file = Request.Files[0]; using (var ctx = new WordsContext()) { var wordToChange = ctx.Words.Where(x => x.WordId == WordId).SingleOrDefault(); var bytes = SoundController.ReadFully(file.InputStream); //var data = ConvertWavToMp3(bytes); switch (PartId) { case 1: wordToChange.Part1Sound = bytes; break; case 2: wordToChange.Part2Sound = bytes; break; case 3: wordToChange.Part3Sound = bytes; break; case 4: wordToChange.Part4Sound = bytes; break; case 5: wordToChange.Part5Sound = bytes; break; case 6: wordToChange.Part6Sound = bytes; break; case 7: wordToChange.Part7Sound = bytes; break; } ctx.ChangeTracker.DetectChanges(); ctx.SaveChanges(); } return(Json(new { success = "Successfully uploaded file for Wordid:" + WordId + " PartId:" + PartId })); }
// GET: Pieces public ActionResult Index() { using (var ctx = new WordsContext()) { var model = new Models.MainModel() { Words = ctx.Words.Where(x => x.Type == Word.TypeEnum.Piece && !string.IsNullOrEmpty(x.Part1.Trim())).ToList(), }; return(View(model)); } }
public ActionResult Index() { using (wordContext = new WordsContext()) { bool isAuthenticated = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated; if (isAuthenticated) { usercl = wordContext.Users.Where(x => x.name == User.Identity.Name).FirstOrDefault(); } return(View()); } }
//[OutputCache(Duration = 3600, VaryByParam = "*")] public ActionResult Index(string WordId, int PartId) { using (var ctx = new WordsContext()) { var word = ctx.Words.Where(x => x.WordId.ToString() == WordId).SingleOrDefault(); if (word == null) { return(null); } byte[] data = null; switch (PartId) { case 1: data = word.Part1Sound; break; case 2: data = word.Part2Sound; break; case 3: data = word.Part3Sound; break; case 4: data = word.Part4Sound; break; case 5: data = word.Part5Sound; break; case 6: data = word.Part6Sound; break; case 7: data = word.Part7Sound; break; } if (data != null) { return(File(data, "audio/mpeg")); } else { return(null); } } }
public async Task <ActionResult> ExternalLoginConfirmation(ExternalLoginConfirmationViewModel model, string returnUrl) { if (User.Identity.IsAuthenticated) { return(RedirectToAction("Index", "Manage")); } if (ModelState.IsValid) { // Get the information about the user from the external login provider var info = await AuthenticationManager.GetExternalLoginInfoAsync(); if (info == null) { return(View("ExternalLoginFailure")); } var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user); if (result.Succeeded) { result = await UserManager.AddLoginAsync(user.Id, info.Login); if (result.Succeeded) { var usercl = new UserCl { name = user.UserName }; var userSettings = new UserSettings { currentLangage = null, numberOfWordsPerLearning = 20 }; WordsContext wc = new WordsContext(); wc.Settings.Add(userSettings); usercl.settings = userSettings; wc.Users.Add(usercl); wc.SaveChanges(); await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); return(RedirectToLocal(returnUrl)); } } AddErrors(result); } ViewBag.ReturnUrl = returnUrl; return(View(model)); }
public static void Delete(string wordId) { using (wordsContext = new WordsContext()) { foreach (var item in wordsContext.Words) { if (item.WordId == wordId) { wordsContext.Words.Remove(item); wordsContext.SaveChanges(); } } } }
public static Word Get(string wordId) { using (wordsContext = new WordsContext()) { foreach (var item in wordsContext.Words) { if (item.WordId == wordId) { return(item); } } return(default(Word)); } }
public ActionResult Index(int?collectionid) { using (var ctx = new WordsContext()) { if (collectionid == null) { CreateNewDuplicateCollection(); } var col = ctx.Collections.Where(x => x.CollectionId == collectionid).SingleOrDefault(); var dup = ctx.Duplicates.Where(x => x.Collection_CollectionId == col.CollectionId).OrderBy(x => x.Order).FirstOrDefault(); return(RedirectToAction("IndexByDupId", new { id = dup.DuplicateId })); } }
public ActionResult Previous(int id) { var model = new Models.DuplicatesModel(); using (var ctx = new WordsContext()) { model.Duplicate = ctx.Duplicates.Where(x => x.DuplicateId == id).FirstOrDefault(); //.OrderBy(x=>x.Order).ToList(), var order = model.Duplicate.Order; var oldDuplicate = model.Duplicate; model.Duplicate = ctx.Duplicates.Where(x => x.Order < order && x.Collection.CollectionId == oldDuplicate.Collection.CollectionId).OrderByDescending(x => x.Order).FirstOrDefault() ?? model.Duplicate; return(RedirectToAction("IndexByDupId", "Duplicates", new { id = model.Duplicate.DuplicateId })); } }
public JsonResult GetCurrentLanguage() { bool isAuthenticated = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated; if (!isAuthenticated) { return(null); } using (wordContext = new WordsContext()) { usercl = wordContext.Users.Where(x => x.name == User.Identity.Name).FirstOrDefault(); return(Json(usercl.settings.currentLangage.name, JsonRequestBehavior.AllowGet)); } }