public Employee GetEmployee(User user)
{
using (var db = new ZooMasterDBEntities())
{
return user.Employees.First();
}
}
public List<Employee> GetListOfAllEmployees()
{
using (var db = new ZooMasterDBEntities())
{
return db.Employees
.Include("User")
.ToList();
}
}
public bool EditArea(Area area)
{
using (var db = new ZooMasterDBEntities())
{
var originalArea = db.Areas.First(a => a.AreaID == area.AreaID);
originalArea.Name = area.Name;
return db.SaveChanges() == 1;
}
}
public List<Cleaning> GetListfOfCleanings()
{
using (var db = new ZooMasterDBEntities())
{
return db.Cleanings
.Include("Employee")
.Include("Cage.Area")
.ToList();
}
}
public List<Employee> GetListOfAllGuards()
{
using (var db = new ZooMasterDBEntities())
{
return db.Employees
.Include("User")
.Where(employee => employee.User.Role == (int)Role.RegularEmployee)
.ToList();
}
}
public List<Cage> GetListOfAllCages()
{
using (var db = new ZooMasterDBEntities())
{
var cages = db.Cages
.Include("Area")
.Include("Animals")
.ToList();
return cages;
}
}
public User Login(string email, String password)
{
using (var db = new ZooMasterDBEntities())
{
var loggedUser = db.Users
.Include("Employees").FirstOrDefault(user => user.Email == email);
if (loggedUser == null) return null;
return Crypto.VerifyMd5Hash(password, loggedUser.Password) ? loggedUser : null;
}
}
public List<Disease> GetListOfAllDiseases()
{
using (var db = new ZooMasterDBEntities())
{
return db.Diseases
.Include("Animal")
.Include("Animal.Species")
.Include("Animal.Employee")
.Include("Animal.Employee1")
.ToList();
}
}
public List<Animal> GetListOfAllAnimals()
{
using (var db = new ZooMasterDBEntities())
{
return db.Animals
.Include("Species")
.Include("Employee")
.Include("Cage.Area")
.Include("Employee1")
.ToList();
}
}
public bool EditCleaning(Cleaning cleaning)
{
using (var db = new ZooMasterDBEntities())
{
var originalCleaning = db.Cleanings.First(c => c.CleainingID == cleaning.CleainingID);
originalCleaning.CageID = cleaning.CageID;
originalCleaning.Time = cleaning.Time;
originalCleaning.EmployeeID = cleaning.EmployeeID;
return db.SaveChanges() == 1;
}
}
public bool AddArea(string areaName)
{
Area newArea = new Area()
{
Name = areaName
};
using (var db = new ZooMasterDBEntities())
{
db.Areas.Add(newArea);
return db.SaveChanges() == 1;
}
}
public bool EditCage(Cage cage)
{
using (var db = new ZooMasterDBEntities())
{
var originalCage = db.Cages.First(c => c.CageID == cage.CageID);
originalCage.AreaID = cage.AreaID;
originalCage.Size = cage.Size;
originalCage.Description = cage.Description;
return db.SaveChanges() == 1;
}
}
public bool AddCleaning(Cage cage, DateTime time, int regularEmployeeID)
{
var newCleaning = new Cleaning()
{
CageID = cage.CageID,
Time = time,
EmployeeID = regularEmployeeID
};
using (var db = new ZooMasterDBEntities())
{
db.Cleanings.Add(newCleaning);
return db.SaveChanges() == 1;
}
}
public bool RemoveCleaning(int cleaningID)
{
using (var db = new ZooMasterDBEntities())
{
try
{
db.Cleanings.Remove(db.Cleanings.First(c => c.CleainingID == cleaningID));
return db.SaveChanges() == 1;
}
catch (DbUpdateException)
{
return false;
}
}
}
public bool RemoveArea(int areaID)
{
using (var db = new ZooMasterDBEntities())
{
try
{
db.Areas.Remove(db.Areas.First(a => a.AreaID == areaID));
return db.SaveChanges() == 1;
}
catch (DbUpdateException)
{
return false;
}
}
}
public bool RemoveFeeding(int feedingID)
{
using (var db = new ZooMasterDBEntities())
{
try
{
db.Feedings.Remove(db.Feedings.First(f => f.FeedingID == feedingID));
return db.SaveChanges() == 1;
}
catch (DbUpdateException)
{
return false;
}
}
}
public bool RemoveDisease(int diseaseID)
{
using (var db = new ZooMasterDBEntities())
{
try
{
db.Diseases.Remove(db.Diseases.First(d => d.DiseaseID == diseaseID));
return db.SaveChanges() == 1;
}
catch (DbUpdateException)
{
return false;
}
}
}
public bool AddCage(decimal cageSize, string cageDescription, Area cageArea)
{
var newCage = new Cage()
{
AreaID = cageArea.AreaID,
Size = cageSize,
Description = cageDescription
};
using (var db = new ZooMasterDBEntities())
{
db.Cages.Add(newCage);
return db.SaveChanges() == 1;
}
}
public string ResetEmployeePassword(Employee employee)
{
var password = Guid.NewGuid().ToString("N").Substring(0, 10);
using (var db = new ZooMasterDBEntities())
{
var user = db.Users
.First(u => u.Email == employee.Email);
user.Password = Crypto.GetMd5Hash(password);
db.SaveChanges();
}
return password;
}
public bool EditDisease(Disease disease)
{
using (var db = new ZooMasterDBEntities())
{
var originalDisease = db.Diseases.First(d => d.DiseaseID == disease.DiseaseID);
originalDisease.Name = disease.Name;
originalDisease.Description = disease.Description;
originalDisease.Treatment = disease.Treatment;
originalDisease.StartDate = disease.StartDate;
originalDisease.EndDate = disease.EndDate;
return db.SaveChanges() == 1;
}
}
public bool EditAnimal(Animal animal)
{
using (var db = new ZooMasterDBEntities())
{
var originalAnimal = db.Animals.First(a => a.AnimalID == animal.AnimalID);
originalAnimal.Name = animal.Name;
originalAnimal.BirthDate = animal.BirthDate;
originalAnimal.DeathDate = animal.DeathDate;
originalAnimal.SpeciesID = animal.SpeciesID;
originalAnimal.CageID = animal.CageID;
originalAnimal.Weight = animal.Weight;
originalAnimal.Gender = animal.Gender;
originalAnimal.ArrivalDate = animal.ArrivalDate;
originalAnimal.GuardID = animal.GuardID;
originalAnimal.VetID = animal.VetID;
return db.SaveChanges() == 1;
}
}
public bool AddAnimal(string name, DateTime birthDate, Species species, Cage cage, decimal weight, Gender gender,
Employee guard, Employee vet, DateTime arivalDate)
{
var newAnimal = new Animal()
{
Name = name,
BirthDate = birthDate,
SpeciesID = species.SpeciesID,
CageID = cage.CageID,
Weight = (decimal)weight,
Gender = (int)gender,
GuardID = guard.EmployeeID,
VetID = vet.EmployeeID,
ArrivalDate = arivalDate
};
using (var db = new ZooMasterDBEntities())
{
db.Animals.Add(newAnimal);
return db.SaveChanges() == 1;
}
}
public List<MedicalProcedure> GetListOfAllMedicalProcedures()
{
using (var db = new ZooMasterDBEntities())
{
var medicalProcedures = db.MedicalProcedures
.Include("Animal")
.Include("Medicine")
.Include("Animal.Employee1")
.Include("Animal.Species")
.ToList();
return medicalProcedures;
}
}
public bool AddMedicine(string name, string description)
{
using (var db = new ZooMasterDBEntities())
{
db.Medicines.Add(new Medicine
{
Name = name,
Description = description
});
return db.SaveChanges() == 1;
}
}
public bool AddMedicalProcedure(Medicine medicine, Animal animal, string name, DateTime nextDate)
{
var newMedicalProcedure = new MedicalProcedure
{
AnimalID = animal.AnimalID,
MedicineID = medicine.MedicineID,
Name = name,
AddDate = DateTime.Now,
NextDate = nextDate,
};
using (var db = new ZooMasterDBEntities())
{
db.MedicalProcedures.Add(newMedicalProcedure);
return db.SaveChanges() == 1;
}
}
public bool EditEmployee(Employee employee)
{
using (var db = new ZooMasterDBEntities())
{
var originalEmployee = db.Employees.First(e => e.EmployeeID == employee.EmployeeID);
var originalUser = db.Users.First(u => u.Email == employee.User.Email);
originalEmployee.FirstName = employee.FirstName;
originalEmployee.LastName = employee.LastName;
originalEmployee.BirthDate = employee.BirthDate;
originalEmployee.Address = employee.Address;
originalEmployee.Gender = employee.Gender;
originalEmployee.EmploymentDate = employee.EmploymentDate;
originalEmployee.ReleaseDate = employee.ReleaseDate;
originalEmployee.ManagerID = employee.ManagerID;
originalUser.Role = employee.User.Role;
return db.SaveChanges() == 2;
}
}
public bool AddDisease(Animal animal, string description, string name, DateTime startDate, DateTime? endDate, string treatment)
{
var newDisease = new Disease
{
AnimalID = animal.AnimalID,
Description = description,
Treatment = treatment,
Name = name,
StartDate = startDate,
EndDate = endDate == DateTime.MinValue ? null : endDate
};
using (var db = new ZooMasterDBEntities())
{
db.Diseases.Add(newDisease);
return db.SaveChanges() == 1;
}
}
public bool EditFeeding(Feeding feeding)
{
using (var db = new ZooMasterDBEntities())
{
var originalFeeding = db.Feedings.First(f => f.FeedingID == feeding.FeedingID);
originalFeeding.CageID = feeding.CageID;
originalFeeding.Time = feeding.Time;
originalFeeding.EmployeeID = feeding.EmployeeID;
return db.SaveChanges() == 1;
}
}
public string AddEmployee(Role role, string firstName, string lastName, string address, DateTime birthDate,
DateTime employmentDate, string email, Gender gender, int managerID)
{
var password = Guid.NewGuid().ToString("N").Substring(0, 10);
var newUser = new User
{
Email = email,
Role = (int)role,
Password = Crypto.GetMd5Hash(password)
};
var newEmployee = new Employee
{
Address = address,
BirthDate = birthDate,
Email = email,
Gender = (int)gender,
FirstName = firstName,
LastName = lastName,
ManagerID = managerID,
EmploymentDate = employmentDate
};
using (var db = new ZooMasterDBEntities())
{
db.Users.Add(newUser);
db.Employees.Add(newEmployee);
db.SaveChanges();
}
return password;
}
public bool EditMedicalProcedure(MedicalProcedure procedure)
{
using (var db = new ZooMasterDBEntities())
{
var originalProcedure = db.MedicalProcedures.First(i => i.MedicalProcedureID == procedure.MedicalProcedureID);
originalProcedure.MedicineID = procedure.MedicineID;
originalProcedure.Name = procedure.Name;
originalProcedure.AddDate = procedure.AddDate;
originalProcedure.NextDate = procedure.NextDate;
return db.SaveChanges() == 1;
}
}
