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