public List <HomelessAnimal> SearchWithAnimals(int speciesCode, int genderCode)
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.HomelessAnimals
where x.Species == speciesCode && x.AdoptionStatus == 0 && x.PhysicalCondition != 3
select x;
if (genderCode == 1)
{
query = query.Where(x => x.Gender == 1);
}
else if (genderCode == 2)
{
query = query.Where(x => x.Gender == 2);
}
var list = query.ToList();
foreach (var x in list)
{
x.SpeciesName = ((SpeciesType)x.Species).ToString();
x.PhysicalConditionName = ((PhysicalConditionType)x.PhysicalCondition).ToString();
x.GenderName = ((Genders)x.Gender).ToString();
}
return(list);
}
public List <Adoption> GetAnimalsById(string userId)
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.Adoptions
where x.User.Name.Contains(userId)
select new
{
Adopt = x,
AnimalName = x.HomelessAnimal.Name,
userLoginId = x.User.Id,
AdoptionStatus = x.HomelessAnimal.AdoptionStatus
};
var list = query.ToList();
foreach (var x in list)
{
x.Adopt.AnimalName = x.AnimalName;
x.Adopt.userLoginId = x.userLoginId;
x.Adopt.AdoptionStatus = (AdoptionStatusType)x.AdoptionStatus;
}
return(list.ConvertAll(x => x.Adopt));
}
public void Delete(T entity)
{
AnimalShelterManagementEntities context = CreateContext();
context.Entry(entity).State = EntityState.Deleted;
context.SaveChanges();
}
public void Insert(T entity)
{
AnimalShelterManagementEntities context = CreateContext();
//context.Albums.Add(album);
context.Entry(entity).State = EntityState.Added;
context.SaveChanges();
}
protected AnimalShelterManagementEntities CreateContext()
{
AnimalShelterManagementEntities context = new AnimalShelterManagementEntities();
context.Configuration.ProxyCreationEnabled = false;
context.Database.Log = x => Console.WriteLine(x);
return(context);
}
public int GetMaxId()
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.Specieses
orderby x.SpeciesCode descending
select x.SpeciesCode;
return(query.FirstOrDefault());
}
public int GetMaxId()
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.FindingReports
orderby x.FindingReportId descending
select x.FindingReportId;
return(query.FirstOrDefault());
}
public int GetMaxCode()
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.PhysicalConditions
orderby x.PhysicalConditionCode descending
select x.PhysicalConditionCode;
return(query.FirstOrDefault());
}
public int GetFirstId()
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.HomelessAnimals
orderby x.HomelessAnimalId
select x.HomelessAnimalId;
return(query.FirstOrDefault());
}
public List <HomelessAnimal> GetByAnimalName(string animalName)
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.HomelessAnimals
where x.Name == animalName
orderby x.HomelessAnimalId
select x;
return(query.ToList());
}
public List <User> GetbyName(string name)
{
List <User> user = new List <User>();
AnimalShelterManagementEntities context = CreateContext();
foreach (User userr in context.Users)
{
if (String.Equals(userr.Name, name) == true)
{
user.Add(userr);
}
}
return(user);
}
public List <HomelessAnimal> SearchWithHomelessAnimal(int animalShelterId, int speciesCode, int gender, DateTime foundDateFrom, DateTime foundDateTo)
{
AnimalShelterManagementEntities context = CreateContext();
var query = from x in context.HomelessAnimals
where x.AnimalShelterId == animalShelterId &&
x.Species == speciesCode &&
(x.LatestFindingReport >= foundDateFrom && x.LatestFindingReport <= foundDateTo)
select x;
if (gender == 1)
{
query = query.Where(x => x.Gender == 1);
}
else if (gender == 2)
{
query = query.Where(x => x.Gender == 2);
}
//if(species = )
var list = query.ToList();
foreach (var x in list)
{
x.SpeciesName = ((SpeciesType)x.Species).ToString();
x.GenderName = ((Genders)x.Gender).ToString();
x.LatestFindingReportDate = x.LatestFindingReport;
x.PhysicalConditionName = ((PhysicalConditionType)x.PhysicalCondition).ToString();
}
return(list);
}
public LossReport Get(int lossReportId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.LossReports.FirstOrDefault(a => a.LossReportId == lossReportId));
}
public AnimalShelter Get(int animalShelterId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.AnimalShelters.FirstOrDefault(a => a.AnimalShelterId == animalShelterId));
}
public int GetCount()
{
AnimalShelterManagementEntities context = CreateContext();
return(context.Set <T>().Count());
}
public Adoption Get(int userId, int homelessAnimalId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.Adoptions.FirstOrDefault(a => a.UserId == userId && a.HomelessAnimalId == homelessAnimalId));
}
public Species Get(int speciesCode)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.Specieses.FirstOrDefault(a => a.SpeciesCode == speciesCode));
}
public HomelessAnimal Get(int homelessAnimalId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.HomelessAnimals.FirstOrDefault(a => a.HomelessAnimalId == homelessAnimalId));
}
public List <T> GetAll()
{
AnimalShelterManagementEntities context = CreateContext();
return(context.Set <T>().ToList());
}
public FoundAnimalRecord Get(int lossReportId, int homelessAnimalId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.FoundAnimalRecords.FirstOrDefault(a => a.LossReportId == lossReportId && a.HomelessAnimalId == homelessAnimalId));
}
public User GetbyId(string id)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.Users.FirstOrDefault(a => a.Id == id));
}
public FindingReport Get(int findingReportId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.FindingReports.FirstOrDefault(a => a.FindingReportId == findingReportId));
}
public void IsAdopted(int homelessAnimalId)
{
AnimalShelterManagementEntities context = CreateContext();
context.HomelessAnimals.FirstOrDefault(a => a.HomelessAnimalId == homelessAnimalId);
}
public FindingReportRecord Get(int findingReportId, int homelessAnimalId)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.FindingReportRecords.FirstOrDefault(a => a.FindingReportId == findingReportId && a.HomelessAnimalId == homelessAnimalId));
}
public PhysicalCondition Get(int physicalConditionCode)
{
AnimalShelterManagementEntities context = CreateContext();
return(context.PhysicalConditions.FirstOrDefault(a => a.PhysicalConditionCode == physicalConditionCode));
}
