public void TestEditBatchNotes() { UserProfile jon = TestUtils.createUser(111, "Jon", "Smith"); Batch batch = TestUtils.createBatch("Test", BatchType.Beer, jon); BatchNote note = TestUtils.createBatchNote(batch, "Test Note", "I am a note!", jon); BrewersBuddyContext db = new BrewersBuddyContext(); var id = note.NoteId; var note1 = db.BatchNotes.Find(id); Assert.IsTrue(batch.Notes.Contains(note)); Assert.AreEqual("Test Note", note1.Title); Assert.AreEqual("I am a note!", note1.Text); note.Title = "Test Title"; // save changes db = new BrewersBuddyContext(); db.Entry(note).State = System.Data.EntityState.Modified; db.SaveChanges(); //clear context and reload db = new BrewersBuddyContext(); note1 = db.BatchNotes.Find(id); // verify local context is not being used note.Text = "test text"; Assert.AreEqual("Test Title", note1.Title); Assert.AreEqual("I am a note!", note1.Text); }
public static BatchComment createBatchComment(Batch batch, UserProfile user, string comment) { BrewersBuddyContext db = new BrewersBuddyContext(); BatchComment batchComment = new BatchComment(); batchComment.Batch = batch; batchComment.User = user; batchComment.Comment = comment; db.BatchComments.Add(batchComment); db.SaveChanges(); return batchComment; }
public static BatchRating createBatchRating(Batch batch, UserProfile user, int rating, string comment) { BrewersBuddyContext db = new BrewersBuddyContext(); BatchRating batchRating = new BatchRating(); batchRating.Batch = batch; batchRating.User = user; batchRating.Rating = rating; batchRating.Comment = comment; db.BatchRatings.Add(batchRating); db.SaveChanges(); return batchRating; }
public static BatchNote createBatchNote(Batch batch, String title, String text, UserProfile user) { BrewersBuddyContext db = new BrewersBuddyContext(); BatchNote note = new BatchNote(); note.Batch = batch; note.Text = text; note.Title = title; note.AuthorId = user.UserId; note.AuthorDate = DateTime.Now; db.BatchNotes.Add(note); db.SaveChanges(); return note; }
public static Batch createBatch(String name, BatchType type, UserProfile owner) { BrewersBuddyContext db = new BrewersBuddyContext(); Batch batch = new Batch(); batch.Name = name; batch.Type = type; batch.OwnerId = owner.UserId; batch.StartDate = DateTime.Now; db.Batches.Add(batch); db.SaveChanges(); return batch; }
public ActionResult ExternalLoginConfirmation(RegisterExternalLoginModel model, string returnUrl) { string provider = null; string providerUserId = null; if (User.Identity.IsAuthenticated || !OAuthWebSecurity.TryDeserializeProviderUserId(model.ExternalLoginData, out provider, out providerUserId)) { return RedirectToAction("Manage"); } if (ModelState.IsValid) { // Insert a new user into the database using (BrewersBuddyContext db = new BrewersBuddyContext()) { UserProfile user = db.UserProfiles.FirstOrDefault(u => u.UserName.ToLower() == model.UserName.ToLower()); // Check if user already exists if (user == null) { // Insert name into the profile table db.UserProfiles.Add(new UserProfile { UserName = model.UserName }); db.SaveChanges(); OAuthWebSecurity.CreateOrUpdateAccount(provider, providerUserId, model.UserName); OAuthWebSecurity.Login(provider, providerUserId, createPersistentCookie: false); return RedirectToLocal(returnUrl); } else { ModelState.AddModelError("UserName", "User name already exists. Please enter a different user name."); } } } ViewBag.ProviderDisplayName = OAuthWebSecurity.GetOAuthClientData(provider).DisplayName; ViewBag.ReturnUrl = returnUrl; return View(model); }
public static Measurement createMeasurement(Batch batch, String name, String description, String measured, Double value) { BrewersBuddyContext db = new BrewersBuddyContext(); Measurement measurment = new Measurement(); measurment.Batch = batch; measurment.Name = name; measurment.Description = description; measurment.Measured = measured; measurment.MeasurementDate = DateTime.Now; measurment.Value = value; db.Measurements.Add(measurment); db.SaveChanges(); return measurment; }
public static UserProfile createUser(int userId, String firstName, String lastName) { BrewersBuddyContext db = new BrewersBuddyContext(); UserProfile user = new UserProfile(); user.UserId = userId; user.FirstName = firstName; user.LastName = lastName; //TODO should we register them somehow?? db.UserProfiles.Add(user); db.SaveChanges(); return user; }
public ActionResult EditNote(BatchNote note) { if (ModelState.IsValid) { BrewersBuddyContext db2 = new BrewersBuddyContext(); db2.Entry(note).State = EntityState.Modified; db2.SaveChanges(); //Associate the batch with the note int batchId = (int)Session["CurrentBatchId"]; return RedirectToAction("Details/" + batchId); } return View(note); }