public void AddParrents(Parrents parrents)
{
using (var context = new RabbitsDBEntities())
{
context.Parrents.Add(parrents);
context.SaveChanges();
}
}
public void AddChildBirth(ChildBirth childBirth)
{
using (var context = new RabbitsDBEntities())
{
context.ChildBirth.Add(childBirth);
context.SaveChanges();
}
}
public void AddCage(Cages cage)
{
using (var context = new RabbitsDBEntities())
{
if (IsNameExist(cage.Name, context))
throw new InvalidOperationException(AlreadyExist);
context.Cages.Add(cage);
context.SaveChanges();
}
}
public void AddMale(Males male)
{
using (var context = new RabbitsDBEntities())
{
if (IsNameExist(male.Name, context))
throw new InvalidOperationException(AlreadyExist);
context.Males.Add(male);
context.SaveChanges();
}
}
public void AddMedicalService(MedicalServices medicalService)
{
using (var context = new RabbitsDBEntities())
{
if(IsNameExist(medicalService.MedicalServiceName, context))
throw new InvalidOperationException(AlreadyExist);
context.MedicalServices.Add(medicalService);
context.SaveChanges();
}
}
public void DeleteMale(int maleId)
{
using (var context = new RabbitsDBEntities())
{
var result = context.Males.FirstOrDefault(x => x.Id == maleId);
if (result == null)
throw new InvalidOperationException(NotFound);
context.Males.Remove(result);
context.SaveChanges();
}
}
public void DeleteCage(int cageId)
{
using (var context = new RabbitsDBEntities())
{
var entity = context.Cages.FirstOrDefault(x => x.Id == cageId);
if (entity == null)
throw new InvalidOperationException(DoesNotExist);
context.Cages.Remove(entity);
context.SaveChanges();
}
}
public void DeleteParrents(int parrentsId)
{
using (var context = new RabbitsDBEntities())
{
var entity = context.Parrents.FirstOrDefault(x => x.Id == parrentsId);
if (entity == null)
throw new InvalidOperationException(NotFound);
context.Parrents.Remove(entity);
context.SaveChanges();
}
}
public void UpdateMale(Males male)
{
using (var context = new RabbitsDBEntities())
{
if (IsNameExist(male.Name, context))
throw new InvalidOperationException(AlreadyExist);
var result = context.Males.FirstOrDefault(x => x.Id == male.Id);
if (result == null)
throw new InvalidOperationException(NotFound);
result.Name = male.Name;
context.SaveChanges();
}
}
public void UpdateParrents(Parrents parrents)
{
using (var context = new RabbitsDBEntities())
{
var entity = context.Parrents.FirstOrDefault(x => x.Id == parrents.Id);
if(entity == null)
throw new InvalidOperationException(NotFound);
entity.FatherId1 = parrents.FatherId1;
entity.FatherId2 = parrents.FatherId2;
entity.MotherId = parrents.MotherId;
context.SaveChanges();
}
}
public void UpdateCage(Cages cage)
{
using (var context = new RabbitsDBEntities())
{
if (IsNameExist(cage.Name, context))
throw new InvalidOperationException(AlreadyExist);
var entity = context.Cages.FirstOrDefault(x => x.Id == cage.Id);
if (entity == null)
throw new InvalidOperationException(DoesNotExist);
entity.Name = cage.Name;
context.SaveChanges();
}
}
public void UpdateFemale(Females female)
{
using (var context = new RabbitsDBEntities())
{
var result = context.Females.FirstOrDefault(x => x.Id == female.Id);
if (result == null)
throw new InvalidOperationException(DoesNotExist);
if (result.Name != female.Name && IsNameExist(female.Name, context))
throw new InvalidOperationException(AlreadyExist);
result.Name = female.Name;
result.DateOfBirth = female.DateOfBirth;
result.CageId = female.CageId;
context.SaveChanges();
}
}
public void UpdateChildBirth(ChildBirth childBirth)
{
using (var context = new RabbitsDBEntities())
{
var result = context.ChildBirth.FirstOrDefault(x => x.Id == childBirth.Id);
if (result == null)
throw new InvalidOperationException(NotFound);
result.FemaleId = childBirth.FemaleId;
result.Birthday = childBirth.Birthday;
result.ExpectBirthday = childBirth.ExpectBirthday;
result.Notes = childBirth.Notes;
result.MaleId1 = childBirth.MaleId1;
result.MaleId2 = childBirth.MaleId2;
result.StartDate1 = childBirth.StartDate1;
result.StartDate2 = childBirth.StartDate2;
result.ResultId = childBirth.ResultId;
context.SaveChanges();
}
}
public void DeleteFemaleFromCage(int femaleId)
{
using (var context = new RabbitsDBEntities())
{
var female = context.Females.FirstOrDefault(x => x.Id == femaleId);
if (female == null)
throw new InvalidOperationException(DoesNotExist);
female.CageId = null;
context.SaveChanges();
}
}
