// D e l e t e
public bool DeleteVetVisit(int id)
{
VetVisit vetVisitToDelete =
context.VetVisits.FirstOrDefault(v => v.Id == id);
if (vetVisitToDelete == null)
{
return(false);
}
context.VetVisits.Remove(vetVisitToDelete);
context.SaveChanges();
return(true);
}
// M e t h o d s - C R U D
// C r e a t e
public VetVisit Create(VetVisit vetVisit)
{
try
{
context.VetVisits.Add(vetVisit);
context.SaveChanges();
return(vetVisit);
}
catch (Exception e)
{//something bad happened!
return(null);
}
}
// U p d a t e
public VetVisit UpdateVetVisit(VetVisit vetVisit)
{
//1. Go find (read) this product from the database
VetVisit vetVisitToUpdate = context.VetVisits //This will return an IQueryable
.FirstOrDefault(v => v.Id == vetVisit.Id); //gets one product out of the database
//2. Modify the database copy of the product
if (vetVisitToUpdate != null)
{
vetVisitToUpdate.Date = vetVisit.Date;
vetVisitToUpdate.Vaccine = vetVisit.Vaccine;
vetVisitToUpdate.Weight = vetVisit.Weight;
vetVisitToUpdate.Comments = vetVisit.Comments;
vetVisitToUpdate.Id = vetVisit.Id;
//3. Dear Database: Please update you copy of this product
context.SaveChanges();
}
return(vetVisitToUpdate);
}