public void SaveAdoption()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
Adoptions adoption = new Adoptions
{
AnimalID = AnimalID,
PersonID = PersonID,
Returned = false,
ReturnDate = ReturnDate,
ReturnReason = ReturnReason,
Date = Date
};
db.Adoptions.InsertOnSubmit(adoption);
db.SubmitChanges();
ID = adoption.ID;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static int?DatedDeaths(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from stay in db.Stays
where (stay.FinishDate >= since) && (stay.FinishDate <= to) && stay.IsDeleted.Equals(null) && stay.Died.Equals(true)
select stay)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static int?AnimalsInShelterSum()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from animal in db.Animals
where (animal.InShelter == true) && animal.IsDeleted.Equals(null)
select animal)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static int?DatedDonations(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from donation in db.Donations
where (donation.Date >= since) && (donation.Date <= to) && donation.IsDeleted.Equals(null)
select donation.Amount)
.Sum();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static int?DatedIncidents(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from incident in db.Incidents
where (incident.IncidentDate >= since) && (incident.IncidentDate <= to) && incident.IsDeleted.Equals(null)
select incident)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static int?TotalAnimalMedicalRecords(int animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from record in db.MedicalRecords
where record.AnimalID.Equals(animalID) && record.IsDeleted.Equals(null)
select record)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static int?DatedCosts(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from cost in db.Costs
where (cost.Date >= since) && (cost.Date <= to) && cost.IsDeleted.Equals(null)
select cost.Price)
.Sum();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public void UpdatePerson()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
People person = db.People.FirstOrDefault(i => i.Id == ID);
person.Title = Title;
person.FirstName = FirstName;
person.LastName = LastName;
person.Phone = Phone;
person.Mail = Mail;
person.Note = Note;
person.AdressCity = AdressCity;
person.AdressStreet = AdressStreet;
person.AdressZip = AdressZip;
person.IsOwner = IsOwner;
person.IsSponsor = IsSponsor;
person.IsVet = IsVet;
person.IsWalker = IsWalker;
person.IsVolunteer = IsVolunteer;
db.SubmitChanges();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static BindableCollection <PersonInfo> ReturnOwners()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var results = (from person in db.People
where ((person.IsOwner.Equals(true)) && person.IsDeleted.Equals(null))
select new PersonInfo
{
ID = person.Id,
Title = person.Title,
FirstName = person.FirstName,
LastName = person.LastName,
Phone = person.Phone,
Mail = person.Mail,
Note = person.Note,
AdressCity = person.AdressCity,
AdressStreet = person.AdressStreet,
AdressZip = person.AdressZip,
IsOwner = person.IsOwner,
IsVet = person.IsVet,
IsWalker = person.IsWalker,
IsSponsor = person.IsSponsor,
IsVolunteer = person.IsVolunteer
});
return(new BindableCollection <PersonInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <PersonInfo>());
}
}
public void SaveFurColor()
{
try
{
if (FurColorName != null)
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
FurColors furColor = new FurColors
{
FurColorName = FurColorName,
IsDeleted = null
};
db.FurColors.InsertOnSubmit(furColor);
db.SubmitChanges();
ID = furColor.Id;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void GetPerson(int personID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var person = db.People.FirstOrDefault(i => i.Id == personID && i.IsDeleted.Equals(null));
if (person != null)
{
ID = person.Id;
Title = person.Title;
FirstName = person.FirstName;
LastName = person.LastName;
Phone = person.Phone;
Mail = person.Mail;
Note = person.Note;
AdressCity = person.AdressCity;
AdressStreet = person.AdressStreet;
AdressZip = person.AdressZip;
IsOwner = person.IsOwner;
IsVet = person.IsVet;
IsWalker = person.IsWalker;
IsSponsor = person.IsSponsor;
IsVolunteer = person.IsVolunteer;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static BindableCollection <MedicalRecordInfo> GetDatedMedicalRecords(int animalID, DateTime?since, DateTime?to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var results = (from record in db.MedicalRecords
where (record.AnimalID.Equals(animalID) && (record.Date >= since && record.Date <= to) && (record.IsDeleted.Equals(null)))
select new MedicalRecordInfo
{
ID = record.Id,
Date = record.Date,
RecordName = record.RecordName,
AnimalID = record.AnimalID,
AnimalName = record.Animals.Name,
Description = record.Description,
VetID = record.VetID,
VetName = record.People.FirstName + " " + record.People.LastName,
CostID = record.CostID,
});
return(new BindableCollection <MedicalRecordInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <MedicalRecordInfo>());
}
}
public void SaveMedicalRecord()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
MedicalRecords medicalRecord = new MedicalRecords
{
AnimalID = AnimalID,
RecordName = RecordName,
Description = Description,
CostID = CostID,
Date = Date,
VetID = VetID
};
db.MedicalRecords.InsertOnSubmit(medicalRecord);
db.SubmitChanges();
ID = medicalRecord.Id;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static BindableCollection <AdoptionInfo> ReturnSpecificAdoptions(string searchValue)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var results = (from adoption in db.Adoptions
where ((adoption.IsDeleted.Equals(null)) &&
((adoption.Date.ToString().Contains(searchValue)) ||
(adoption.ID.ToString().Equals(searchValue)) ||
(adoption.Animals.Name.Contains(searchValue)) ||
(adoption.People.LastName.Contains(searchValue))))
select new AdoptionInfo
{
ID = adoption.ID,
Date = adoption.Date,
OwnerName = adoption.People.FirstName + " " + adoption.People.LastName,
AnimalName = adoption.Animals.Name,
Returned = adoption.Returned,
ReturnDate = adoption.ReturnDate,
ReturnReason = adoption.ReturnReason
});
return(new BindableCollection <AdoptionInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <AdoptionInfo>());
}
}
public static int?TotalAnimalDays(int animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from stay in db.Stays
where stay.AnimalID.Equals(animalID) && stay.IsDeleted.Equals(null) && !stay.FinishDate.Equals(null)
select(int?)((DateTime)stay.FinishDate - (DateTime)stay.StartDate).TotalDays)
.Sum();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public void SavePerson()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
People person = new People
{
Title = Title,
FirstName = FirstName,
LastName = LastName,
Phone = Phone,
Mail = Mail,
Note = Note,
AdressCity = AdressCity,
AdressStreet = AdressStreet,
AdressZip = AdressZip,
IsOwner = IsOwner,
IsVet = IsVet,
IsWalker = IsWalker,
IsSponsor = IsSponsor,
IsVolunteer = IsVolunteer
};
db.People.InsertOnSubmit(person);
db.SubmitChanges();
ID = person.Id;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static bool?AnimalAdopted(int animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
bool?result =
(from adoption in db.Adoptions
where adoption.AnimalID.Equals(animalID) && adoption.IsDeleted.Equals(null)
select adoption.Returned)
.Contains(false);
if (result != null)
{
return(result);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(null);
}
}
public static BindableCollection <IncidentInfo> GetDatedAnimalIncidents(int animalID, DateTime?since, DateTime?to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var results = (from incident in db.Incidents
where (incident.AnimalID.Equals(animalID) && (incident.IncidentDate >= since && incident.IncidentDate <= to)) &&
(incident.IsDeleted.Equals(null))
select new IncidentInfo
{
ID = incident.ID,
Date = incident.IncidentDate,
AnimalID = incident.AnimalID,
AnimalName = incident.Animals.Name,
Description = incident.Description,
Severity = incident.Severity,
});
return(new BindableCollection <IncidentInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <IncidentInfo>());
}
}
public static int?TotalAnimalWalks(int animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from walk in db.Walks
where walk.AnimalID.Equals(animalID) && walk.IsDeleted.Equals(null)
select walk)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public void SaveDonation()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
Donations donation = new Donations
{
DonatorID = DonatorID,
DonationName = DonationName,
Description = Description,
Amount = Amount,
Date = Date
};
db.Donations.InsertOnSubmit(donation);
db.SubmitChanges();
ID = donation.ID;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static int?SuccessfullyAdoptedAnimals()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from adoption in db.Adoptions
where (adoption.Returned == false) && adoption.IsDeleted.Equals(null)
select adoption)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static BindableCollection <DonationInfo> GetDonations()
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var results = (from donation in db.Donations
where ((donation.IsDeleted.Equals(null)))
select new DonationInfo
{
ID = donation.ID,
Date = donation.Date,
DonatorID = donation.DonatorID,
DonatorName = donation.People.FirstName + " " + donation.People.LastName,
Amount = donation.Amount,
DonationName = donation.DonationName,
Description = donation.Description
});
return(new BindableCollection <DonationInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <DonationInfo>());
}
}
public static int?DatedEscapes(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from escape in db.Escapes
where (escape.Date >= since) && (escape.Date <= to) && escape.IsDeleted.Equals(null)
select escape)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static BindableCollection <DonationInfo> GetDatedDonations(DateTime?since, DateTime?to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
//return db.Donations.Where(x => x.Date >= since && x.Date <= to).ToList();
var results = (from donation in db.Donations
where (donation.Date >= since && donation.Date <= to) && (donation.IsDeleted.Equals(null))
select new DonationInfo
{
ID = donation.ID,
Date = donation.Date,
DonatorName = donation.People.FirstName + " " + donation.People.LastName,
Amount = donation.Amount,
DonationName = donation.DonationName,
Description = donation.Description
});
return(new BindableCollection <DonationInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <DonationInfo>());
}
}
public static int?DatedMedicalRecords(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from record in db.MedicalRecords
where (record.Date >= since) && (record.Date <= to) && record.IsDeleted.Equals(null)
select record)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static BindableCollection <EscapeInfo> GetDatedEscapes(DateTime?since, DateTime?to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
var results = (from escape in db.Escapes
where (escape.Date >= since && escape.Date <= to) && (escape.IsDeleted.Equals(null))
select new EscapeInfo
{
ID = escape.Id,
Date = escape.Date,
AnimalID = escape.AnimalID,
AnimalName = escape.Animals.Name,
Description = escape.Description,
});
return(new BindableCollection <EscapeInfo>(results));
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new BindableCollection <EscapeInfo>());
}
}
public static int?DatedReturned(DateTime since, DateTime to)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from adoption in db.Adoptions
where (adoption.ReturnDate >= since) && (adoption.ReturnDate <= to) && adoption.IsDeleted.Equals(null)
select adoption)
.Count();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static AnimalInfo GetAnimalInfo(int?animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
db.DeferredLoadingEnabled = false;
var result =
(from animal in db.Animals
where (animal.ID.Equals(animalID))
select new AnimalInfo
{
ID = animal.ID,
Name = animal.Name,
ChipNumber = animal.ChipNumber,
BirthDate = animal.Birth,
Sex = animal.Sexes.SexName,
Species = animal.Species.SpeciesName,
Breed = animal.Breeds.BreedName,
CrossBreed = animal.Breeds1.BreedName,
CoatType = animal.CoatTypes.CoatTypeName,
FurColor = animal.FurColors.FurColorName,
Castration = animal.Castration,
});
return(result.FirstOrDefault());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new AnimalInfo());
}
}
public static int?TotalAnimalCosts(int animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
int?total =
(from cost in db.Costs
where cost.AnimalID.Equals(animalID) && cost.IsDeleted.Equals(null)
select cost.Price)
.Sum();
if (total != null)
{
return(total);
}
else
{
return(0);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(0);
}
}
public static AdoptionInfo GetAdoptionInfo(int?animalID)
{
try
{
using (ShelterDatabaseLINQDataContext db = new ShelterDatabaseLINQDataContext())
{
db.DeferredLoadingEnabled = false;
var result =
(from adoption in db.Adoptions
where adoption.ID.Equals(animalID)
select new AdoptionInfo
{
ID = adoption.ID,
Date = adoption.Date,
OwnerName = adoption.People.FirstName + " " + adoption.People.LastName,
AnimalName = adoption.Animals.Name,
Returned = adoption.Returned,
ReturnDate = adoption.ReturnDate,
ReturnReason = adoption.ReturnReason
});
return(result.FirstOrDefault());
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(new AdoptionInfo());
}
}
