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