private void UpdateEntity(IHandlerRegistration entity)
{
using (var ctx = new HappyDogShowContext())
{
HandlerRegistration foundEntity = ctx.HandlerRegistrations.Where(d => d.ID == entity.Id).First();
if (foundEntity != null)
{
Sex entitySex = ctx.Sexes.Where(g => g.ID == entity.SexId).First();
foundEntity.Sex = entitySex;
foundEntity.DateOfBirth = entity.DateOfBirth;
foundEntity.Surname = entity.Surname;
foundEntity.Title = entity.Title;
foundEntity.FirstName = entity.FirstName;
foundEntity.Address = entity.Address;
foundEntity.PostalCode = entity.PostalCode;
foundEntity.Tel = entity.Tel;
foundEntity.Cell = entity.Cell;
foundEntity.Fax = entity.Fax;
foundEntity.Email = entity.Email;
ctx.SaveChanges();
}
}
}
private void UpdateEntity(IHandlerEntryEntity entity)
{
using (var ctx = new HappyDogShowContext())
{
HandlerEntry foundEntity = ctx.HandlerEntries.Where(d => d.ID == entity.Id).First();
if (foundEntity != null)
{
if (entity.Dog != null)
{
DogRegistration selectedDog = ctx.DogRegistrations.Where(i => i.ID == entity.Dog.Id).First();
foundEntity.Dog = selectedDog;
}
if (entity.DogShow != null)
{
DogShow selectedShow = ctx.DogShows.Where(i => i.ID == entity.DogShow.Id).First();
foundEntity.Show = selectedShow;
}
if (entity.Class != null)
{
HandlerClass selectedClass = ctx.HandlerClasses.Where(i => i.ID == entity.Class.Id).First();
foundEntity.EnteredClass = selectedClass;
}
foundEntity.Number = entity.Number;
ctx.SaveChanges();
}
}
}
private int CreateEntity(IHandlerEntryEntity entity)
{
int newid = -1;
using (var ctx = new HappyDogShowContext())
{
DogRegistration selectedDog = ctx.DogRegistrations.Where(i => i.ID == entity.Dog.Id).First();
DogShow selectedShow = ctx.DogShows.Where(i => i.ID == entity.DogShow.Id).First();
HandlerClass selectedClass = ctx.HandlerClasses.Where(i => i.ID == entity.Class.Id).First();
HandlerRegistration selectedHander = ctx.HandlerRegistrations.Where(i => i.ID == entity.Handler.Id).First();
HandlerEntry newEntity = new HandlerEntry()
{
Dog = selectedDog,
Show = selectedShow,
EnteredClass = selectedClass,
Handler = selectedHander
};
ctx.HandlerEntries.Add(newEntity);
ctx.SaveChanges();
newid = newEntity.ID;
}
return(newid);
}
private int CreateEntity(IHandlerRegistration entity)
{
int newid = -1;
using (var ctx = new HappyDogShowContext())
{
Sex entitySex = ctx.Sexes.Where(g => g.ID == entity.SexId).First();
HandlerRegistration newEntity = new HandlerRegistration()
{
Sex = entitySex,
DateOfBirth = entity.DateOfBirth,
Surname = entity.Surname,
Title = entity.Title,
FirstName = entity.FirstName,
Address = entity.Address,
PostalCode = entity.PostalCode,
Tel = entity.Tel,
Cell = entity.Cell,
Fax = entity.Fax,
Email = entity.Email
};
ctx.HandlerRegistrations.Add(newEntity);
ctx.SaveChanges();
newid = newEntity.ID;
}
return(newid);
}
private void UpdateEntity(IBreedEntryEntity entity)
{
using (var ctx = new HappyDogShowContext())
{
DogShow selectedShow = ctx.DogShows.Where(i => i.ID == entity.ShowId).First();
BreedEntry foundEntity = ctx.BreedEntries.Where(d => d.ID == entity.Id).Include(b => b.EnteredClasses).First();
if (foundEntity != null)
{
if (entity.Classes != null)
{
foreach (var i in entity.Classes)
{
// existing class entry
if (i.ID > 0)
{
if (i.IsSelected)
{
// nothing to do, keep it
}
else
{
var foundEntries = ctx.BreedClassEntries.Where(ec => ec.ID == i.ID);
if (foundEntries.Count() == 1)
{
ctx.BreedClassEntries.Remove(foundEntries.First());
}
}
}
// potential new class entry
else
{
if (i.IsSelected)
{
BreedClass breedClass = ctx.BreedClasses.Where(k => k.ID == i.BreedClassID).First();
foundEntity.EnteredClasses.Add(new BreedClassEntry()
{
Class = breedClass
});
}
else
{
// ignore
}
}
}
}
foundEntity.Show = selectedShow;
foundEntity.Number = entity.Number;
ctx.SaveChanges();
}
}
}
private int CreateEntity(IBreedEntryEntity entity)
{
int newid = -1;
using (var ctx = new HappyDogShowContext())
{
DogRegistration selectedDog = ctx.DogRegistrations.Where(i => i.ID == entity.Dog.Id).First();
DogShow selectedShow = ctx.DogShows.Where(i => i.ID == entity.ShowId).First();
List <BreedClassEntry> enteredClasses = new List <BreedClassEntry>();
foreach (var i in entity.Classes.Where(j => j.IsSelected))
{
BreedClass breedClass = ctx.BreedClasses.Where(k => k.ID == i.BreedClassID).First();
enteredClasses.Add(new BreedClassEntry()
{
Class = breedClass
});;
}
if (string.IsNullOrEmpty(entity.Number))
{
var usednumbers = ctx.BreedEntries.Where(be => be.Show.ID == entity.ShowId).Select(be => be.Number).ToList().Distinct().ToList();
if (usednumbers.Count > 0)
{
int temp;
int max = usednumbers.Select(n => int.TryParse(n, out temp) ? temp : 0).Max();
if (max > 0)
{
entity.Number = (max + 1).ToString();
}
}
else
{
entity.Number = "";
}
}
BreedEntry newEntity = new BreedEntry()
{
Dog = selectedDog,
EnteredClasses = enteredClasses,
Show = selectedShow,
Number = entity.Number
};
ctx.BreedEntries.Add(newEntity);
ctx.SaveChanges();
newid = newEntity.ID;
}
return(newid);
}
private void DeleteEntity(IEntityWithID entity)
{
using (var ctx = new HappyDogShowContext())
{
HandlerEntry foundEntity = ctx.HandlerEntries.Where(d => d.ID == entity.Id).First();
if (foundEntity != null)
{
ctx.HandlerEntries.Remove(foundEntity);
ctx.SaveChanges();
}
}
}
private void UpdateEntity(IMultipleBreedEntryClassEntry entity)
{
using (var ctx = new HappyDogShowContext())
{
foreach (IBreedEntryClassEntry classEntry in entity.BreedClassEntries)
{
BreedClassEntry foundEntry = ctx.BreedClassEntries.Where(i => i.ID == classEntry.Id).First();
foundEntry.Result = classEntry.Result;
}
ctx.SaveChanges();
}
}
private void UpdateEntity(IDogShowEntity entity)
{
using (var ctx = new HappyDogShowContext())
{
DogShow foundEntity = ctx.DogShows.Where(d => d.ID == entity.Id).First();
if (foundEntity != null)
{
foundEntity.Name = entity.DogShowName;
foundEntity.ShowDate = entity.ShowDate;
ctx.SaveChanges();
}
}
}
private void DeleteEntity(IEntityWithID entity)
{
using (var ctx = new HappyDogShowContext())
{
BreedEntry foundEntity = ctx.BreedEntries.Where(d => d.ID == entity.Id).Include(b => b.EnteredClasses).First();
if (foundEntity != null)
{
if (foundEntity.EnteredClasses != null)
{
foundEntity.EnteredClasses.Clear();
}
ctx.BreedEntries.Remove(foundEntity);
ctx.SaveChanges();
}
}
}
private void UpdateEntity(IChallengeResultCollection <IChallengeResult> entity)
{
using (var ctx = new HappyDogShowContext())
{
foreach (IChallengeResult result in entity.Results)
{
var foundResults = ctx.HandlerChallengeResults.Where(i => i.ID == result.Id);
if (foundResults.Count() == 1)
{
HandlerChallengeResult foundResult = foundResults.First();
foundResult.EntryNumber = result.EntryNumber;
}
}
ctx.SaveChanges();
}
}
private int CreateEntity(IDogRegistration entity)
{
int newid = -1;
using (var ctx = new HappyDogShowContext())
{
Gender entityGender = ctx.Genders.Where(g => g.ID == entity.GenderId).First();
Breed entityBreed = ctx.Breeds.Where(g => g.ID == entity.BreedId).First();
DogRegistration newEntity = new DogRegistration()
{
RegisrationNumber = entity.RegisrationNumber,
Gender = entityGender,
DateOfBirth = entity.DateOfBirth,
Breed = entityBreed,
RegisteredName = entity.RegisteredName,
Qualifications = entity.Qualifications,
ChipOrTattooNumber = entity.ChipOrTattooNumber,
Sire = entity.Sire,
Dam = entity.Dam,
BredBy = entity.BredBy,
Colour = entity.Colour,
RegisteredOwnerSurname = entity.RegisteredOwnerSurname,
RegisteredOwnerTitle = entity.RegisteredOwnerTitle,
RegisteredOwnerInitials = entity.RegisteredOwnerInitials,
RegisteredOwnerAddress = entity.RegisteredOwnerAddress,
RegisteredOwnerPostalCode = entity.RegisteredOwnerPostalCode,
RegisteredOwnerKUSANo = entity.RegisteredOwnerKUSANo,
RegisteredOwnerTel = entity.RegisteredOwnerTel,
RegisteredOwnerCell = entity.RegisteredOwnerCell,
RegisteredOwnerFax = entity.RegisteredOwnerFax,
RegisteredOwnerEmail = entity.RegisteredOwnerEmail
};
ctx.DogRegistrations.Add(newEntity);
ctx.SaveChanges();
newid = newEntity.ID;
}
return(newid);
}
private int CreateEntity(IDogShowEntity entity)
{
int newid = -1;
using (var ctx = new HappyDogShowContext())
{
DogShow newEntity = new DogShow()
{
ID = entity.Id,
Name = entity.DogShowName,
ShowDate = entity.ShowDate
};
ctx.DogShows.Add(newEntity);
ctx.SaveChanges();
newid = newEntity.ID;
}
return(newid);
}
private void UpdateEntity(IDogRegistration entity)
{
using (var ctx = new HappyDogShowContext())
{
DogRegistration foundEntity = ctx.DogRegistrations.Where(d => d.ID == entity.Id).First();
if (foundEntity != null)
{
Gender entityGender = ctx.Genders.Where(g => g.ID == entity.GenderId).First();
Breed entityBreed = ctx.Breeds.Where(g => g.ID == entity.BreedId).First();
foundEntity.RegisrationNumber = entity.RegisrationNumber;
foundEntity.Gender = entityGender;
foundEntity.DateOfBirth = entity.DateOfBirth;
foundEntity.Breed = entityBreed;
foundEntity.RegisteredName = entity.RegisteredName;
foundEntity.Qualifications = entity.Qualifications;
foundEntity.ChipOrTattooNumber = entity.ChipOrTattooNumber;
foundEntity.Sire = entity.Sire;
foundEntity.Dam = entity.Dam;
foundEntity.BredBy = entity.BredBy;
foundEntity.Colour = entity.Colour;
foundEntity.RegisteredOwnerSurname = entity.RegisteredOwnerSurname;
foundEntity.RegisteredOwnerTitle = entity.RegisteredOwnerTitle;
foundEntity.RegisteredOwnerInitials = entity.RegisteredOwnerInitials;
foundEntity.RegisteredOwnerAddress = entity.RegisteredOwnerAddress;
foundEntity.RegisteredOwnerPostalCode = entity.RegisteredOwnerPostalCode;
foundEntity.RegisteredOwnerKUSANo = entity.RegisteredOwnerKUSANo;
foundEntity.RegisteredOwnerTel = entity.RegisteredOwnerTel;
foundEntity.RegisteredOwnerCell = entity.RegisteredOwnerCell;
foundEntity.RegisteredOwnerFax = entity.RegisteredOwnerFax;
foundEntity.RegisteredOwnerEmail = entity.RegisteredOwnerEmail;
ctx.SaveChanges();
}
}
}
private void PopulateBreedChallengeResultsTableForDogShow(int dogShowId)
{
using (var ctx = new HappyDogShowContext())
{
var breedsthathaveentries = from e in ctx.BreedEntries
where e.Show.ID == dogShowId
select e.Dog.Breed;
breedsthathaveentries = breedsthathaveentries.Distinct();
var whatwemusthaveeventually = from bc in ctx.BreedChallenges
from b in breedsthathaveentries
from s in ctx.DogShows.Where(i => i.ID == dogShowId)
select new
{
BreedChallenge = bc,
Breed = b,
Show = s
};
var whatwehavenow = from res in ctx.BreedChallengeResults
where res.DogShow.ID == dogShowId
select res;
var whatwehavewithwhatwemusthave = from i in whatwemusthaveeventually
join res in whatwehavenow on
new
{
breedid = i.Breed.ID,
breedchallengeid = i.BreedChallenge.ID,
dogshowid = i.Show.ID
} equals
new
{
breedid = res.Breed.ID,
breedchallengeid = res.BreedChallenge.ID,
dogshowid = res.DogShow.ID
}
into gj
from joinedresult in gj.DefaultIfEmpty()
select new
{
breedid = i.Breed.ID,
breed = i.Breed,
breedchallengeid = i.BreedChallenge.ID,
breedchallenge = i.BreedChallenge,
dogshowid = i.Show.ID,
dogshow = i.Show,
existingdata = joinedresult
};
var yes = whatwehavewithwhatwemusthave.ToList();
var whatwemustcreate = yes.Where(i => i.existingdata == null);
foreach (var tocreate in whatwemustcreate)
{
BreedChallengeResult realEntry = new BreedChallengeResult()
{
DogShow = tocreate.dogshow,
Breed = tocreate.breed,
BreedChallenge = tocreate.breedchallenge,
EntryNumber = ""
};
ctx.BreedChallengeResults.Add(realEntry);
}
ctx.SaveChanges();
}
}
private static void PopulateBreedGroupChallengeResultsTableForDogShow(int dogShowId)
{
using (var ctx = new HappyDogShowContext())
{
List <string> placings = new List <string>();
placings.Add("1st");
placings.Add("2nd");
placings.Add("3rd");
placings.Add("4th");
var whatwemusthaveeventually = from bc in ctx.BreedGroupChallenges
from bg in ctx.BreedGroups
from s in ctx.DogShows.Where(i => i.ID == dogShowId)
from p in placings
select new
{
BreedGroupChallenge = bc,
BreedGroup = bg,
Show = s,
Placing = p
};
var whatwehavenow = from res in ctx.BreedGroupChallengeResults
where res.DogShow.ID == dogShowId
select res;
BreedGroupChallengeResult defaultValue = new BreedGroupChallengeResult();
var whatwehavewithwhatwemusthave = from i in whatwemusthaveeventually
join res in whatwehavenow on
new
{
breedgroupid = i.BreedGroup.ID,
breedgroupchallengeid = i.BreedGroupChallenge.ID,
dogshowid = i.Show.ID,
placing = i.Placing
} equals
new
{
breedgroupid = res.BreedGroup.ID,
breedgroupchallengeid = res.BreedGroupChallenge.ID,
dogshowid = res.DogShow.ID,
placing = res.Placing
}
into gj
from joinedresult in gj.DefaultIfEmpty()
select new
{
breedgroupid = i.BreedGroup.ID,
breedgroup = i.BreedGroup,
breedgroupchallengeid = i.BreedGroupChallenge.ID,
breedgroupchallenge = i.BreedGroupChallenge,
dogshowid = i.Show.ID,
dogshow = i.Show,
placing = i.Placing,
existingdata = joinedresult
};
var yes = whatwehavewithwhatwemusthave.ToList();
var whatwemustcreate = yes.Where(i => i.existingdata == null);
foreach (var tocreate in whatwemustcreate)
{
BreedGroupChallengeResult realEntry = new BreedGroupChallengeResult()
{
DogShow = tocreate.dogshow,
BreedGroup = tocreate.breedgroup,
BreedGroupChallenge = tocreate.breedgroupchallenge,
Placing = tocreate.placing,
EntryNumber = ""
};
ctx.BreedGroupChallengeResults.Add(realEntry);
}
ctx.SaveChanges();
}
}
private List <IChallengeResult> GetList <T>(int dogShowId, int classId) where T : IChallengeResult, new()
{
List <IChallengeResult> items = new List <IChallengeResult>();
using (var ctx = new HappyDogShowContext())
{
if (classId > 0)
{
var existingData = from r in ctx.HandlerChallengeResults
where r.DogShow.ID == dogShowId && r.HandlerClass.ID == classId
select r;
if (existingData.Count() == 0)
{
List <string> placings = new List <string>();
placings.Add("1st");
placings.Add("2nd");
placings.Add("3rd");
placings.Add("4th");
var newEntries = from ds in ctx.DogShows.Where(d => d.ID == dogShowId)
from scc in ctx.HandlerClasses
from p in placings
select new
{
DogShow = ds,
HandlerClass = scc,
Placing = p
};
foreach (var newEntry in newEntries)
{
HandlerChallengeResult realEntry = new HandlerChallengeResult()
{
DogShow = newEntry.DogShow,
HandlerClass = newEntry.HandlerClass,
Placing = newEntry.Placing,
EntryNumber = ""
};
ctx.HandlerChallengeResults.Add(realEntry);
}
ctx.SaveChanges();
}
}
var rawdata = from r in ctx.HandlerChallengeResults
where r.DogShow.ID == dogShowId
select r;
if (classId > 0)
{
rawdata = rawdata.Where(r => r.HandlerClass.ID == classId);
}
var actualEntries = from r in rawdata
orderby r.Placing
select new T
{
Id = r.ID,
ShowId = r.DogShow.ID,
ShowName = r.DogShow.Name,
Challenge = r.HandlerClass.Name,
EntryNumber = r.EntryNumber,
Placing = r.Placing,
Print = false
};
foreach (var entry in actualEntries)
{
items.Add(entry);
}
}
return(items);
}
private List <IInShowChallengeResult> GetList <T>(int dogShowId, int challengeId) where T : IInShowChallengeResult, new()
{
List <IInShowChallengeResult> items = new List <IInShowChallengeResult>();
using (var ctx = new HappyDogShowContext())
{
if (challengeId > 0)
{
var existingData = from r in ctx.InShowChallengeResults
where r.DogShow.ID == dogShowId && r.ShowChallenge.ID == challengeId
select r;
if (existingData.Count() == 0)
{
List <string> placings = new List <string>();
placings.Add("1st");
placings.Add("2nd");
placings.Add("3rd");
placings.Add("4th");
var newEntries = from ds in ctx.DogShows.Where(d => d.ID == dogShowId)
from scc in ctx.ShowChallenges.Where(d => d.ID == challengeId)
from p in placings
select new
{
DogShow = ds,
ShowChallenge = scc,
Placing = p
};
foreach (var newEntry in newEntries)
{
InShowChallengeResult realEntry = new InShowChallengeResult()
{
DogShow = newEntry.DogShow,
ShowChallenge = newEntry.ShowChallenge,
Placing = newEntry.Placing,
EntryNumber = ""
};
ctx.InShowChallengeResults.Add(realEntry);
}
ctx.SaveChanges();
}
}
var rawdata = from r in ctx.InShowChallengeResults
where r.DogShow.ID == dogShowId
select r;
if (challengeId > 0)
{
rawdata = rawdata.Where(r => r.ShowChallenge.ID == challengeId);
}
var judges = from j in ctx.ShowInShowChallengeJudges
where j.DogShow.ID == dogShowId
select j;
var actualEntries = from r in rawdata
join j in judges on
r.ShowChallenge.ID equals j.ShowChallenge.ID
orderby r.Placing
select new T
{
Id = r.ID,
ShowId = r.DogShow.ID,
ShowName = r.DogShow.Name,
Challenge = r.ShowChallenge.Name,
EntryNumber = r.EntryNumber,
Placing = r.Placing,
Print = false,
JudgeName = j.Judge.Name,
BreedName = ""
};
foreach (var entry in actualEntries.ToList())
{
if (entry.EntryNumber != "")
{
entry.BreedName = ctx.BreedEntries.Include("Dog").Include("Dog.Breed").Where(e => e.Show.ID == dogShowId && e.Number == entry.EntryNumber).First().Dog.Breed.Name;
}
items.Add(entry);
}
}
return(items);
}
