public void AddAnimal(Animal animal) { using (var data = new AnimalEntities()) { data.Animal.Add(animal); data.SaveChanges(); } }
public void AddAnimalType(AnimalTypes type) { using (var data = new AnimalEntities()) { data.AnimalTypes.Add(type); data.SaveChanges(); } }
public void DeleteAnimal(int id) { using (var data = new AnimalEntities()) { Animal type = (Animal)data.Animal.Where(x => x.Id == id).First(); data.Animal.Remove(type); data.SaveChanges(); } }
public void UpdateAnimalType(AnimalTypes type) { using (var data = new AnimalEntities()) { data.AnimalTypes.Attach(type); var entry = data.Entry(type); entry.State = System.Data.Entity.EntityState.Modified; data.SaveChanges(); } }
public bool CheckIfIDExists(int id) { using (var data = new AnimalEntities()) { try { var animalType = data.AnimalTypes.Where(x => x.Id == id).First(); return(true); } catch { return(false); } } }
public bool checkIfImageAlrExists(Image image) { byte[] convertedImage = imageToByteArray(image); using (var data = new AnimalEntities()) { try { Animal type = (Animal)data.Animal.Where(x => x.Image == convertedImage).First(); return(true); } catch { return(false); } } }
public AnimalTypes SelectAnimalType(string type) { using (var data = new AnimalEntities()) { try { var animalType = data.AnimalTypes.Where(x => x.Animal_type == type).First(); return(animalType); } catch { AddAnimalType(new AnimalTypes() { Id = 0, Animal_type = type }); var animalType = data.AnimalTypes.Where(x => x.Animal_type == type).First(); return(animalType); } } }