// 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); }