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 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);
}
class Program { //main
static void Main(string[] args)
{
Dog myDog = getInfoFromDB();
DogShow show = new DogShow();
DogController ctrl = new DogController(myDog, show);
ctrl.updateView();
ctrl.setName("snow");
ctrl.setAge(4);
strl.updateView();
Console.ReadLine();
}
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 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);
}
public DogController(Dog model, DogShow view)
{
this.model = model;
this.view = view;
}
