[Route("{key}")] //<--key == petId
public ActionResult PutEdit(int key, [FromBody] Pets pet)
{
pethouseContext db = new pethouseContext();
try
{
Pets petDb = db.Pets.Find(key);
if (pet != null)
{
petDb.Petname = pet.Petname;
petDb.Birthdate = pet.Birthdate;
petDb.Photo = pet.Photo;
petDb.User = pet.User;
petDb.RaceId = pet.RaceId;
petDb.BreedId = pet.BreedId;
db.SaveChanges();
return(Ok(petDb.PetId));
}
else
{
return(NotFound("No such ID in pets"));
}
}
catch (Exception)
{
return(BadRequest("Error"));
}
finally
{
db.Dispose();
}
}
[Route("{Key}")] //<--key == petId
public ActionResult PutEdit(int key, [FromBody] Vaccines vac)
{
pethouseContext db = new pethouseContext();
try
{
Vaccines vacDb = db.Vaccines.Find(key);
if (vac != null)
{
vacDb.Vacname = vac.Vacname;
vacDb.VacDate = vac.VacDate;
vacDb.VacExpDate = vac.VacExpDate;
db.SaveChanges();
return(Ok(vacDb.VacId));
}
else
{
return(NotFound("Not found"));
}
}
catch (Exception)
{
return(BadRequest("Error"));
}
finally
{
db.Dispose();
}
}
[Route("{Key}")] //<--key == petId
public ActionResult PutEdit(int key, [FromBody] Grooming gro)
{
pethouseContext db = new pethouseContext();
try
{
Grooming groDb = db.Grooming.Find(key);
if (gro != null)
{
groDb.Groomname = gro.Groomname;
groDb.GroomDate = gro.GroomDate;
groDb.GroomExpDate = gro.GroomExpDate;
groDb.Comments = gro.Comments;
db.SaveChanges();
return(Ok(groDb.GroomId));
}
else
{
return(NotFound("Not found"));
}
}
catch (Exception)
{
return(BadRequest("Error"));
}
finally
{
db.Dispose();
}
}
public ActionResult PostCreateNew([FromBody] Users user)
{
pethouseContext db = new pethouseContext(); //Tietokanta yhteytden muodostus
try
{
var exists = (from p in db.Users
where p.Username == user.Username
select p).Count();
if (exists > 0)
{
return(BadRequest(false));
}
else
{
db.Users.Add(user);
db.SaveChanges();
}
}
catch (Exception ex)
{
return(BadRequest("Jokin meni pieleen asiakasta lisättäessä.\nOta yhteyttä Guruun!\n" + ex.ToString()));
}
db.Dispose(); //Tietokannan vapautus
return(Ok(user.UserId)); //Palauttaa vastaluodun uuden lemmikin avainarvon
}
[Route("{Key}")] //<--key == petId
public ActionResult PutEdit(int key, [FromBody] Medications med)
{
pethouseContext db = new pethouseContext();
try
{
Medications medDb = db.Medications.Find(key);
if (med != null)
{
medDb.Medname = med.Medname;
medDb.MedDate = med.MedDate;
medDb.MedExpDate = med.MedExpDate;
db.SaveChanges();
return(Ok(medDb.MedId));
}
else
{
return(NotFound("Not found"));
}
}
catch (Exception)
{
return(BadRequest("Error"));
}
finally
{
db.Dispose();
}
}
[Route("user/")] // <-- Routen placeholder
public ActionResult PostCreateNew([FromBody] Pets pet)
{
pethouseContext db = new pethouseContext(); //Tietokanta yhteytden muodostus
try
{
db.Pets.Add(pet);
db.SaveChanges();
}
catch (Exception)
{
return(BadRequest("Jokin meni pieleen asiakasta lisättäessä.\nOta yhteyttä Guruun!"));
}
db.Dispose(); //Tietokannan vapautus
return(Ok(pet.PetId)); //Palauttaa vastaluodun uuden lemmikin avainarvon
}
[HttpPost] //<-- filtteri, joka sallii vain POST-metodit
//[Route("")]// <-- Routen placeholder
public ActionResult PostCreateNew([FromBody] Vaccines vac)
{
pethouseContext db = new pethouseContext(); //Tietokanta yhteytden muodostus
try
{
db.Vaccines.Add(vac);
db.SaveChanges();
}
catch (Exception ex)
{
string virhe = ex.GetType().Name.ToString() + ": " + ex.Message.ToString();
return(BadRequest("Jokin meni pieleen asiakasta lisättäessä.\nOta yhteyttä Guruun!\n" + virhe));
}
db.Dispose(); //Tietokannan vapautus
return(Ok(vac.PetId)); //Palauttaa vastaluodun uuden objektin avainarvon
}
[HttpPost] //<-- filtteri, joka sallii vain POST-metodit
//[Route("")]// <-- Routen placeholder
public ActionResult PostCreateNew([FromBody] Grooming grooming)
{
pethouseContext db = new pethouseContext(); //Tietokanta yhteytden muodostus
try
{
db.Grooming.Add(grooming);
db.SaveChanges();
}
catch (Exception ex)
{
string virhe = ex.GetType().Name.ToString() + ": " + ex.Message.ToString();
return(BadRequest("Request failed with error:\n" + virhe));
}
db.Dispose(); //Tietokannan vapautus
return(Ok(grooming.PetId)); //Palauttaa vastaluodun uuden objektin avainarvon
}
public ActionResult DeleteVaccine(int?key)
{
if (key is null)
{
throw new ArgumentNullException(nameof(key));
}
pethouseContext db = new pethouseContext();
try
{ Vaccines vaccine = db.Vaccines.Find(key);
db.Remove(vaccine);
db.SaveChanges(); }
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
return(Ok());
}
public ActionResult DeleteAllVaccines(int?key)
{
if (key is null)
{
throw new ArgumentNullException(nameof(key));
}
pethouseContext db = new pethouseContext();
try
{
Vaccines vaccineRow = db.Vaccines.Where(s => s.PetId == key).FirstOrDefault();
db.Remove(vaccineRow);
db.SaveChanges();
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
return(Ok());
}
public ActionResult DeleteGrooming(int?key)
{
if (key is null)
{
throw new ArgumentNullException(nameof(key));
}
pethouseContext db = new pethouseContext();
try
{
Grooming grooming = db.Grooming.Find(key);
db.Remove(grooming);
db.SaveChanges();
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
return(Ok());
}
public ActionResult DeleteOnePet(int?key)
{
if (key is null)
{
throw new ArgumentNullException(nameof(key));
}
pethouseContext db = new pethouseContext();
Pets pet = db.Pets.Find(key);
try
{
if (pet != null)
{
db.Pets.Remove(pet);
db.SaveChanges();
return(Ok("Pet " + key + " removed"));
}
else
{
return(NotFound("Pet " + key + " not found."));
}
}catch (Exception ex) { return(BadRequest(ex.ToString())); }
}