public async void Should_be_able_to_modify_the_price_of_a_pet()
{
//given
TestServer server = new TestServer(new WebHostBuilder().UseStartup <Startup>());
HttpClient client = server.CreateClient();
await client.DeleteAsync("petStore/removePets");
Pet pet = new Pet("huanhuan", "dog", "white", 5000);
string request = JsonConvert.SerializeObject(pet);
StringContent requestBody = new StringContent(request, Encoding.UTF8, "application/json");
//when
await client.PostAsync("petStore/addNewPet", requestBody);
UpdatePet newpet = new UpdatePet("huanhuan", 100);
string request2 = JsonConvert.SerializeObject(newpet);
StringContent requestBody2 = new StringContent(request2, Encoding.UTF8, "application/json");
//when
var response = await client.PatchAsync("petStore/ModifyPrice/huanhuan", requestBody2);
//then
response.EnsureSuccessStatusCode();
var responseString = await response.Content.ReadAsStringAsync();
List <Pet> actualPets = JsonConvert.DeserializeObject <List <Pet> >(responseString);
Assert.Equal(100, actualPets[0].Price);
}
//ActionResult is a way of routing information to the view
//URL: /Pet/Update/2 -> update pet with id 2
public ActionResult Update(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//how to get pet data? run query
//first or default converts the first sql result into a pet object
Pet selectedpet = db.Pets.SqlQuery("select * from pets where petid = @PetID", new SqlParameter("PetID", id)).FirstOrDefault();
if (selectedpet == null)
{
return(HttpNotFound());
}
//grabbing all pets
string query = "select * from species";
List <Species> selectedspecies = db.Species.SqlQuery(query).ToList();
//create instance of our viewmodel
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = selectedpet;
viewmodel.species = selectedspecies;
return(View(viewmodel));
}
public List <Pet> ModifyPrice(string name, UpdatePet newPet)
{
return(pets.Where(pet => pet.Name == name).Select(pet =>
{
pet.Price = newPet.Price;
return pet;
}).ToList());
}
//TODO:
//Update
public ActionResult Update(int id)
{
Pet selectedpet = db.Pets.SqlQuery("Select * from pets where petid=@id", new SqlParameter("@id", id)).FirstOrDefault();
List <Species> species = db.Species.SqlQuery("Select * from species").ToList();
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = selectedpet;
viewmodel.species = species;
return(View(viewmodel));
}
public UpdatePet updatePet(string endpoint, string payload)
{
var apiHelpObject = new APIHelper <UpdatePet>();
var restClient = apiHelpObject.setUrl(endpoint);
var request = apiHelpObject.putMethod(payload);
var response = apiHelpObject.getResponse(restClient, request);
UpdatePet userDTO = apiHelpObject.getContent <UpdatePet>(response);
return(userDTO);
}
public ActionResult Update(UpdatePet updatePet)
{
this.ViewData["CancelUrl"] = $"/Providers/Pet/Profile/{updatePet.Id}";
if (this.ModelState.IsValid)
{
int result = updatePet.ExecuteNonQuery();
return(Redirect($"/Providers/Pet/Profile/{updatePet.Id}"));
}
return(View("FormPage", updatePet));
}
//Update
public ActionResult Update(int id)
{
//need information about a particular pet
Pet selectedpet = db.Pets.SqlQuery("select * from pets where petid = @id", new SqlParameter("@id", id)).FirstOrDefault();
string query = "select * from species";
List <Species> selectedspecies = db.Species.SqlQuery(query).ToList();
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = selectedpet;
viewmodel.species = selectedspecies;
return(View(viewmodel));
}
public ActionResult Update(int id)
{
//need information about a particular pet
Pet selectedpet = db.Pets.SqlQuery("select * from pets where petid = @id", new SqlParameter("@id", id)).FirstOrDefault();
Pet selected_pet = db.Pets.SqlQuery("select * from pets where petid = @id", new SqlParameter("@id", id)).FirstOrDefault();
List <Species> species = db.Species.SqlQuery("select * from Species").ToList();
UpdatePet petUpdate = new UpdatePet();
petUpdate.pet = selected_pet;
petUpdate.Species = species;
return(View(petUpdate));
}
public ActionResult Update(int id) //must same with file name Update.cshtml
{
Pet selectedpet = db.Pets.SqlQuery("SELECT * FROM pets WHERE PetID = @id", new SqlParameter("@id", id)).FirstOrDefault();
List <Species> selectedspecies = db.Species.SqlQuery("select * from Species").ToList();
UpdatePet updatepet = new UpdatePet();
updatepet.pet = selectedpet;
updatepet.species = selectedspecies;
return(View(updatepet));
}
public ActionResult Update(UpdatePet updatePet)
{
if (this.ModelState.IsValid)
{
int result = updatePet.ExecuteNonQuery();
return(new JsonResult()
{
Data = new { Result = "Success" }
});
}
this.AddAjaxPost($"/Providers/Pet/Update/{updatePet.Id}", "Update Pet", x => x.OnSuccess = "paw.onAjaxFormSuccess");
return(View("FormModal", updatePet));
}
public ActionResult Update(int id)
{
//gets information about a pet
Pet selectedpet = db.Pets.SqlQuery("SELECT * FROM pets WHERE petid =@id", new SqlParameter
("@id", id)).FirstOrDefault();
List <Species> species = db.Species.SqlQuery("SELECT FROM species").ToList();
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = selectedpet;
viewmodel.species = species;
return(View(selectedpet)
);
}
public ActionResult Update(int id)
{
Pet selectedpet = db.Pets.SqlQuery("select * from pets where petid =@PetID", new SqlParameter("@PetID", id)).FirstOrDefault();
if (selectedpet == null)
{
return(HttpNotFound());
}
string query = "select * from species";
List <Species> selectedspecies = db.Species.SqlQuery(query).ToList();
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = selectedpet;
viewmodel.species = selectedspecies;
return(View(viewmodel));
}
//TODO:
//GET : Update
public ActionResult Update(int id)
{
//grtting the data of pets
Pet pet = db.Pets.SqlQuery("select * from pets where PetID=@PetID", new SqlParameter("@PetID", id)).FirstOrDefault();
//information of species
List <Species> species = db.Species.SqlQuery("select * from species").ToList();
//to show the options of the species
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = pet;
viewmodel.species = species;
return(View(viewmodel));
}
public IActionResult ConfirmSelling(int Id, string userId)
{
var pet = new Pet().ChangeOwnership(_petRepository.GetPet(Id), userId);
UpdatePet update = new UpdatePet(_updatePetRepository);
if (TempData["jobId"] != null)
{
update.CancleJob(TempData["jobId"].ToString());
}
TempData.Clear();
_petRepository.UpdateWithHistory(pet);
return(RedirectToAction(nameof(Index)));
}
public ActionResult Update(int id)
{
//need information about a particular pet
Pet selectedpet = db.Pets.SqlQuery("select * from pets where petid = @id", new SqlParameter("@id", id)).FirstOrDefault();
//Creating a drop down for species when updating the pet....works with Models/ViewModels/UpdatePet.cs
//need information about all species
string query = "select * from species";
List <Species> selectedspecies = db.Species.SqlQuery(query).ToList();
//create an instance of our ViewModel
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = selectedpet;
viewmodel.species = selectedspecies;
return(View(viewmodel));
}
public IActionResult BuyPet(int Id)
{
ViewBag.Id = Id;
var userId = _userManager.GetUserId(HttpContext.User);
var pet = new Pet().LockPetForBuying(_petRepository.GetPet(Id), userId);
_petRepository.Update(pet);
//Schedule to cancel buy after 3 hours if buying does not succeed
UpdatePet update = new UpdatePet(_updatePetRepository);
string jobId = update.Update(pet);
TempData["jobId"] = jobId;
return(View());
}
//Update
public ActionResult Update(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Pet Pet = db.Pets.SqlQuery("select * from pets where petid=@petid", new SqlParameter("@PetID", id)).FirstOrDefault();
List <Species> species = db.Species.SqlQuery("select * from species").ToList();
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = Pet;
viewmodel.species = species;
if (Pet == null)
{
return(HttpNotFound());
}
return(View(viewmodel));
}
public ActionResult Update(int id)
{
Debug.WriteLine("User click on the Update link id=" + id);
//need information about a particular pet
Pet selectedPet = db.Pets.SqlQuery("select * from pets where petid = @id", new SqlParameter("@id", id)).FirstOrDefault();
//need information about all species
string query = "select * from species";
List <Species> selectedSpecies = db.Species.SqlQuery(query).ToList();
Debug.WriteLine(query);
//create an instance of our ViewModel
UpdatePet viewModel = new UpdatePet();
viewModel.pet = selectedPet;
viewModel.species = selectedSpecies;
return(View(viewModel));
}
public ActionResult Update(int?id)
{
// if the id is null then returning the error of bad request
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Pet pet = db.Pets.SqlQuery("select * from pets where petid=@PetID", new SqlParameter("@PetID", id)).FirstOrDefault();
List <Species> species = db.Species.SqlQuery("select * from species").ToList();
//since the pet needs the species detail to using viewmodel to combine both pet and species
UpdatePet viewmodel = new UpdatePet();
viewmodel.pet = pet;
viewmodel.species = species;
//if no pet then showing error
Debug.WriteLine("Running from the update method, pet details:", pet);
if (pet == null)
{
return(HttpNotFound());
}
return(View(viewmodel));
}
// GET: Pet/Edit/5
public ActionResult Edit(int id)
{
UpdatePet ViewModel = new UpdatePet();
string url = "petdata/findpet/" + id;
HttpResponseMessage response = client.GetAsync(url).Result;
//Can catch the status code (200 OK, 301 REDIRECT), etc.
//Debug.WriteLine(response.StatusCode);
if (response.IsSuccessStatusCode)
{
//Put data into pet data transfer object
PetDto SelectedPet = response.Content.ReadAsAsync <PetDto>().Result;
ViewModel.Pet = SelectedPet;
return(View(ViewModel));
}
else
{
return(RedirectToAction("Error"));
}
}
public ActionResult Update(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
//need information about a particular pet
Pet selectedpet = db.Pets.SqlQuery("select * from pets where petid = @id", new SqlParameter("@id", id)).FirstOrDefault();
//string query = "select * from species";
if (selectedpet == null)
{
return(HttpNotFound());
}
///In-class example by Christine Bittle January 30, 2020
List <Species> selectedspecies = db.Species.SqlQuery("select * from species").ToList();
UpdatePet viewModel = new UpdatePet();
viewModel.Pet = selectedpet;
viewModel.Species = selectedspecies;
return(View(viewModel));
}
