public override async Task <Entities.StringManufacturer> Execute(GuitarManagerStorageContext context)
{
context.StringManufacturers.Update(this.Parameter);
await context.SaveChangesAsync();
return(this.Parameter);
}
public override async Task <Entities.Instrument> Execute(GuitarManagerStorageContext context)
{
context.Instruments.Update(this.Parameter);
await context.SaveChangesAsync();
return(this.Parameter);
}
public override async Task <Entities.StringInSet> Execute(GuitarManagerStorageContext context)
{
context.Remove(Parameter);
await context.SaveChangesAsync();
return(this.Parameter);
}
public override async Task <Entities.MyInstrument> Execute(GuitarManagerStorageContext context)
{
await context.AddAsync(Parameter);
await context.SaveChangesAsync();
return(Parameter);
}
public override async Task <Entities.GuitarType> Execute(GuitarManagerStorageContext context)
{
await context.AddAsync(this.Parameter);
await context.SaveChangesAsync();
return(this.Parameter);
}
public override Task <List <Entities.MyInstrument> > Execute(GuitarManagerStorageContext context)
{
if (PlayerID <= 0)
{
return(context.MyInstruments.ToListAsync());
}
else
{
return(context.MyInstruments.Where(x => x.PlayerID == this.PlayerID).ToListAsync());
}
}
public override Task <List <Entities.String> > Execute(GuitarManagerStorageContext context)
{
if (StringTypeID <= 0 && StringManufacturerID > 0)
{
return(context.Strings.Where(x => x.StringManufacturerID == this.StringManufacturerID).ToListAsync());
}
else if (StringTypeID > 0 && StringManufacturerID <= 0)
{
return(context.Strings.Where(x => x.StringTypeID == this.StringTypeID).ToListAsync());
}
else if (StringTypeID > 0 && StringManufacturerID > 0)
{
return(context.Strings.Where(x => x.StringManufacturerID == this.StringManufacturerID && x.StringTypeID == this.StringTypeID).ToListAsync());
}
else
{
return(context.Strings.ToListAsync());
}
}
public override Task <List <Entities.Instrument> > Execute(GuitarManagerStorageContext context)
{
if (GuitarTypeID <= 0 && GuitarManufacturerID > 0)
{
return(context.Instruments.Where(x => x.GuitarManufacturerID == this.GuitarManufacturerID).ToListAsync());
}
else if (GuitarTypeID > 0 && GuitarManufacturerID <= 0)
{
return(context.Instruments.Where(x => x.GuitarTypeID == this.GuitarTypeID).ToListAsync());
}
else if (GuitarTypeID > 0 && GuitarManufacturerID > 0)
{
return(context.Instruments.Where(x => x.GuitarTypeID == this.GuitarTypeID && x.GuitarManufacturerID == this.GuitarManufacturerID).ToListAsync());
}
else
{
return(context.Instruments.ToListAsync());
}
}
public QueryExecutor(GuitarManagerStorageContext context)
{
this.context = context;
}
public abstract Task <TResult> Execute(GuitarManagerStorageContext context);
public override async Task <Entities.Sound> Execute(GuitarManagerStorageContext context) => await context.Sounds.FirstOrDefaultAsync(x => x.Id == Id);
public CommandExecutor(GuitarManagerStorageContext context)
{
this.context = context;
}
public override Task <List <Entities.Sound> > Execute(GuitarManagerStorageContext context) => context.Sounds.ToListAsync();
public override async Task <Entities.StringManufacturer> Execute(GuitarManagerStorageContext context) => await context.StringManufacturers.FirstOrDefaultAsync(x => x.Id == this.Id);
public override Task <List <Entities.StringManufacturer> > Execute(GuitarManagerStorageContext context) => context.StringManufacturers.ToListAsync();
public override Task <Entities.StringInSet> Execute(GuitarManagerStorageContext context) => context.StringsInSets.FirstOrDefaultAsync(x => x.StringPosition == StringPosition && x.StringSetID == StringSetID);
public override async Task <Entities.InstalledString> Execute(GuitarManagerStorageContext context) => await context.InstalledStrings.FirstOrDefaultAsync(x => x.StringPosition == this.StringPosition && x.MyInstrumentID == this.MyInstrumentID);
public override Task <List <Entities.InstalledString> > Execute(GuitarManagerStorageContext context) => context.InstalledStrings.ToListAsync();
public override Task <Entities.Player> Execute(GuitarManagerStorageContext context) => context.Players.FirstOrDefaultAsync(x => x.Id == this.Id);
public override Task <Entities.MyInstrument> Execute(GuitarManagerStorageContext context) => context.MyInstruments.FirstOrDefaultAsync(x => x.Id == this.Id);
public override async Task<Entities.InstalledString> Execute(GuitarManagerStorageContext context)
{
await context.AddAsync(this.Parameter);
await context.SaveChangesAsync();
return this.Parameter;
}
public override Task <List <Entities.StringInSet> > Execute(GuitarManagerStorageContext context) => context.StringsInSets.ToListAsync();
public override Task <Entities.GuitarManufacturer> Execute(GuitarManagerStorageContext context) => context.GuitarManufacturers.FirstOrDefaultAsync(x => x.Id == Id);
