public ActionResult <Winery> PostWinery(Winery winery) { _logger.LogTrace("Create new Winery " + winery.ToString( )); // Convert model to entity. var wineryEntity = _converter.Convert(winery); // Only allow one instance of each Winery. var checkWinery = from v in _context.Wineries where (v.Name == wineryEntity.Name) select v; if (checkWinery.FirstOrDefault( ) == null) { _context.Wineries.Add(wineryEntity); try { _context.SaveChanges( ); } catch { return(BadRequest( )); } } else { return(Conflict( )); } return(CreatedAtAction("GetWinery", wineryEntity.Id)); }
public void PutWinery_Returns404NotFound_WhenUsingInvalidIWineryId() { // Arrange var wineryEntity = new WineryEntity { Name = "Test 4.3 Winery", WebSite = "Test 4.3 Web Site", EMail = "Test 4.3 EMail", Phone = "Test 4.3 Phone" }; _dbContext.Wineries.Add(wineryEntity); _dbContext.SaveChanges( ); var wineryId = wineryEntity.Id + 1; // force an invalid record Id var winery = new Winery { Name = "Test 4.3 Winery", WebSite = "Test 4.3 Web Site UPDATED", EMail = "Test 4.3 EMail", Phone = "Test 4.3 Phone" }; // Act var result = _controller.PutWinery(wineryId, winery); // Assert Assert.IsType <NotFoundResult>(result); }
public void PutWinery_ReturnsItemOfCorrectType_WhenUsingValidWineryId() { // Arrange var wineryEntity = new WineryEntity { Name = "Test 4.2 Winery", WebSite = "Test 4.2 Web Site", EMail = "Test 4.2 EMail", Phone = "Test 4.2 Phone" }; _dbContext.Wineries.Add(wineryEntity); _dbContext.SaveChanges( ); var wineryEntityId = wineryEntity.Id; var winery = new Winery { Name = "Test 4.2 Winery", WebSite = "Test 4.2 Web Site", EMail = "Test 4.2 EMail", Phone = "Test 4.2 Phone UPDATED" }; // Act var result = _controller.PutWinery(wineryEntityId, winery); // Assert Assert.IsType <NoContentResult>(result); }
public void PutWinery_AttributesUnchanged_WhenUsingInvalidWineryId() { // Arrange var wineryEntity = new WineryEntity { Name = "Test 4.4 Winery", WebSite = "Test 4.4 Web Site", EMail = "Test 4.4 EMail", Phone = "Test 4.4 Phone" }; _dbContext.Wineries.Add(wineryEntity); _dbContext.SaveChanges( ); var winery = new Winery { Name = "Test 4.4 Winery UPDATE", WebSite = "Test 4.4 Web Site UPDATE", EMail = "Test 4.4 EMail UPDATE", Phone = "Test 4.4 Phone UPDATE" }; // Act _controller.PutWinery(wineryEntity.Id + 1, winery); var result = _dbContext.Wineries.Find(wineryEntity.Id); // Assert Assert.Equal(wineryEntity.Name, result.Name); }
public HttpResponseMessage Put(DeleteReviewSubmitModel delModel) { var response = new HttpResponseMessage(HttpStatusCode.NotFound); using (var session = ravenStore.OpenSession()) { Winery winery = session.Load <Winery>(delModel.SubjectId); Review myReview = winery.Reviews.FirstOrDefault(x => x.UserId == delModel.UserId); winery.Reviews.Remove(myReview); if (winery.Reviews.Count > 0) { var rating = winery.Reviews.Average(x => x.Rating); winery.Rating = rating; } else { winery.Rating = 0; } session.SaveChanges(); response = new HttpResponseMessage(HttpStatusCode.OK); } return(response); }
public void WriteEnterprises(string filename) { // Creates an instance of the XmlSerializer class. XmlSerializer mySerializer = new XmlSerializer(typeof(Enterprises)); // Writing file requires a TextWriter. TextWriter writer = new StreamWriter(filename); // Creates an instance of the XmlSerializerNamespaces class. XmlSerializerNamespaces ns = new XmlSerializerNamespaces(); // Adds namespaces and prefixes for the XML document instance. ns.Add("winery", "http://www.cohowinery.com"); ns.Add("vacationCompany", "http://www.treyresearch.com"); // Creates an instance of the class that will be serialized. Enterprises myEnterprises = new Enterprises(); // Creates objects and adds to the array. Winery w1 = new Winery(); w1.Name = "cohowinery"; Winery[] myWinery = { w1 }; myEnterprises.Wineries = myWinery; VacationCompany com1 = new VacationCompany(); com1.Name = "adventure-works"; VacationCompany[] myCompany = { com1 }; myEnterprises.Companies = myCompany; // Serializes the class, and closes the TextWriter. mySerializer.Serialize(writer, myEnterprises, ns); writer.Close(); }
public IActionResult Add(WineryViewModel nw) { if (ModelState.IsValid) { Winery newWinery = new Winery { Name = nw.Name, Address = nw.Address, Phone = nw.Phone, Email = nw.Email, Website = nw.Website, Notes = nw.Notes }; if (!newWinery.Website.StartsWith("http://") || !newWinery.Website.StartsWith("https://")) { newWinery.Website = "http://" + newWinery.Website; } context.Wineries.Add(newWinery); context.SaveChanges(); return(Redirect("/Winery")); } return(View(nw)); }
public void WineryPostWinery() { Winery testWinery = new Winery() { HasMenu = true, TastingPrice = 50, Rating = 4, Address = "290 John St E, Niagara-on-the-Lake, ON L0S 1J0", CheckInRadius = 250, HoursOfOperation = new string[] { "9-20", "9-20", "9-20", "9-20", "9-20", "11-19", "11-19" }, PhoneNumber = "519-872-1556", WineryName = "Peller Estates Winery and Restaurant", Latitude = 43.238662, Longitude = -79.067035, Reviews = new List <Review>() }; var response = _wineryController.Post(testWinery); Assert.Equal(HttpStatusCode.Created, response.StatusCode); var winery = _wineryController.Get("wineries/1-A"); Assert.NotNull(winery); }
public Task <int> UpdateWineryAsync(Winery winery) { wineryContext.Wineries.Update(winery); var saved = wineryContext.SaveChanges(); return(Task.FromResult(saved)); }
public void PutWinery_AttributesUpdated_WhenUsingValidWineryId() { // Arrange var wineryEntity = new WineryEntity { Name = "Test 4.1 Winery", WebSite = "Test 4.1 Web Site", EMail = "Test 4.1 EMail", Phone = "Test 4.1 Phone" }; _dbContext.Wineries.Add(wineryEntity); _dbContext.SaveChanges( ); var wineryEntityId = wineryEntity.Id; var winery = new Winery { Name = "Test 4.1 Winery UPDATED", WebSite = "Test 4.1 Web Site UPDATED", EMail = "Test 4.1 EMail UPDATED", Phone = "Test 4.1 Phone UPDATED" }; // Act _controller.PutWinery(wineryEntityId, winery); var result = _dbContext.Wineries.Find(wineryEntityId); // Assert Assert.Equal(winery.Name, result.Name); Assert.Equal(winery.WebSite, result.WebSite); Assert.Equal(winery.EMail, result.EMail); Assert.Equal(winery.Phone, result.Phone); }
public ActionResult PutWinery(int id, Winery winery) { _logger.LogTrace("Update Winery with Id " + id); var wineryEntity = _context.Wineries.Find(id); // Can only update an existing winery. if (wineryEntity == null) { return(NotFound( )); } // Convert parameter model to entity. var paramWineryEntity = _converter.Convert(winery); // Generate an updated winery entity. wineryEntity.Name = paramWineryEntity.Name; wineryEntity.EMail = paramWineryEntity.EMail; wineryEntity.Phone = paramWineryEntity.Phone; wineryEntity.WebSite = paramWineryEntity.WebSite; // Flush change to database. _context.Entry(wineryEntity).State = EntityState.Modified; _context.SaveChanges( ); return(NoContent( )); }
public Task <Guid> AddWineryAsync(Winery winery) { winery.Id = Guid.NewGuid(); wineryContext.Wineries.Add(winery); var result = wineryContext.SaveChanges() > 0 ? winery.Id : Guid.Empty; return(Task.FromResult(result)); }
public ActionResult DeleteConfirmed(int id) { Winery winery = db.Wineries.Find(id); db.Wineries.Remove(winery); db.SaveChanges(); TempData["message"] = string.Format("{0} has been Deleted", winery.Name, true); //infrom user of changes, message displayed in partail view name _AdminLayOut return(RedirectToAction("Index")); }
public static Contract.Winery MapToWineryContract(this Winery winery) { return(new Contract.Winery { Id = winery.Id, Name = winery.Name, Region = winery.Region, Country = winery.Country }); }
public IActionResult Delete(int id) { // Get a winery info ffrom the passesd id Winery winery = _context.Winery.Single(model => model.Id == id); _context.Winery.Remove(winery); _context.SaveChanges(); return(RedirectToAction("Index")); }
public WineryModelTests() { _testWinery = new Winery { Name = "Base Winery", WebSite = "Base WebSite", EMail = "Base EMail", Phone = "Base Phone" }; }
public ActionResult Edit([Bind(Include = "Id,Name,Country")] Winery winery) { if (ModelState.IsValid) { db.Entry(winery).State = EntityState.Modified; db.SaveChanges(); TempData["message"] = string.Format("{0} has been Edited", winery.Name, true); //infrom user of changes, message displayed in partail view return(RedirectToAction("Index")); } return(View(winery)); }
public IActionResult Create(Winery winery) { if (ModelState.IsValid) { _context.Winery.Add(winery); _context.SaveChanges(); // add data to the database return(RedirectToAction("Index")); } return(View(winery)); }
// GET api/winery/id route: api/winery?id=wineries/[id] Returns: SPecified winery public Winery Get(string id) { Winery winery = new Winery(); using (var session = ravenStore.OpenSession()) { winery = session.Load <Winery>(id); } return(winery); }
public IActionResult Edit(Winery winery) { if (ModelState.IsValid) { _context.Winery.Update(winery); _context.SaveChanges(); return(RedirectToAction("Index")); } return(View(winery)); }
public ActionResult Create([Bind(Include = "Id,Name,Country")] Winery winery) { if (ModelState.IsValid) { db.Wineries.Add(winery); db.SaveChanges(); TempData["message"] = string.Format("{0} has been created", winery.Name, true); //can be added after db.save changes return(RedirectToAction("Index")); } return(View(winery)); }
public IActionResult WinesFromThisWinery(int id) { Winery winery = context.Wineries.SingleOrDefault(wn => wn.ID == id); if (winery != null) { List <Wine> wineList = context.Wines.Where(w => w.WineryID == id).ToList(); WineListViewModel wines = new WineListViewModel(wineList, winery); return(View(wines)); } return(Redirect("/Winery")); }
public IActionResult Remove(int id) { Winery winery = context.Wineries.Single(wn => wn.ID == id); if (winery != null) { context.Wineries.Remove(winery); context.SaveChanges(); return(Redirect("/Winery")); } return(Redirect("/Winery/ViewWinery/" + id)); }
public HttpResponseMessage Post(Winery newWinery) { Winery winery = newWinery; using (var session = ravenStore.OpenSession()) { session.Store(winery); session.SaveChanges(); } var response = new HttpResponseMessage(HttpStatusCode.Created); return(response); }
// GET: Wineries/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Winery winery = db.Wineries.Find(id); if (winery == null) { return(HttpNotFound()); } return(View(winery)); }
public IActionResult Create(Winery winery) // Winery as an Input // this method is accessible by Post Back Event Using An Action Filter { //Check If The Models Check Are Valid if (ModelState.IsValid) { // Add To Context Object _context.Winery.Add(winery); _context.SaveChanges(); // Save Data To The DB return(RedirectToAction("Index")); } return(View(winery)); // Return The View With Errors }
public HttpResponseMessage Post(CellarSubmitModel cellarItem) { HttpResponseMessage response = new HttpResponseMessage(HttpStatusCode.NotFound); using (var session = ravenStore.OpenSession()) { UserProfile user = session.Load <UserProfile>(cellarItem.UserId); Wine wine = session.Load <Wine>(cellarItem.WineId); if (user != null && wine != null) { if (user.CellarBottles == null) { user.CellarBottles = new List <CellarBottle>(); } if (user.CellarBottles.Any(x => x.WineId == cellarItem.WineId)) { var item = user.CellarBottles.FirstOrDefault(x => x.WineId == cellarItem.WineId); item.IncreaseBottleCount(cellarItem.Quantity); if (!string.IsNullOrEmpty(cellarItem.Notes)) { item.PersonalComment = cellarItem.Notes; } if (item.Finished) { item.Finished = false; } session.SaveChanges(); response = new HttpResponseMessage(HttpStatusCode.Created); return(response); } Winery winery = session.Load <Winery>(wine.WineryId); CellarBottle newItem = new CellarBottle(wine, winery.WineryName, cellarItem.Quantity); newItem.PersonalComment = cellarItem.Notes; user.CellarBottles.Add(newItem); session.SaveChanges(); response = new HttpResponseMessage(HttpStatusCode.Created); return(response); } } return(response); }
public async Task <Response <int> > UpdateWineryAsync(Winery winery) { try { var response = new Response <int> { Result = await DataStore.UpdateWineryAsync(winery.MapToWineryPersistence()) }; return(response); } catch (Exception ex) { throw ex; } }
public IActionResult Edit(int id) { Winery winery = context.Wineries.SingleOrDefault(wn => wn.ID == id); WineryViewModel editWinery = new WineryViewModel { Name = winery.Name, Address = winery.Address, Email = winery.Email, Phone = winery.Phone, Notes = winery.Notes, Website = winery.Website, WineryID = winery.ID }; return(View(editWinery)); }
public void PostWinery_ReturnsItemOfCorrectType_WhenUsingValidID() { // Arrange var winery = new Winery { Name = "Test 3.2 Winery", WebSite = "Test 3.2 Web Site", EMail = "Test 3.2 EMail", Phone = "Test 3.2 Phone" }; // Act var result = _controller.PostWinery(winery); // Assert Assert.IsType <CreatedAtActionResult>(result.Result); }