public object Get(Rockstars request) { if (request.Delete == "reset") { Db.DeleteAll <Rockstar>(); Db.Insert(Rockstar.SeedData); } else if (request.Delete.IsInt()) { Db.DeleteById <Rockstar>(request.Delete.ToInt()); } return(new RockstarsResponse { Aged = request.Age, Total = Db.GetScalar <int>("select count(*) from Rockstar"), Results = request.Id != default(int) ? Db.Select <Rockstar>(q => q.Id == request.Id) : request.Age.HasValue ? Db.Select <Rockstar>(q => q.Age == request.Age.Value) : Db.Select <Rockstar>() }); }
public object Post(Rockstars request) { Db.Insert(request.TranslateTo <Rockstar>()); return(Get(new Rockstars())); }
public object Post(Rockstars request) { Db.Insert(request.TranslateTo<Rockstar>()); return Get(new Rockstars()); }
public object Get(Rockstars request) { if (request.Delete == "reset") { Db.DeleteAll<Rockstar>(); Db.Insert(Rockstar.SeedData); } else if (request.Delete.IsInt()) { Db.DeleteById<Rockstar>(request.Delete.ToInt()); } return new RockstarsResponse { Aged = request.Age, Total = Db.GetScalar<int>("select count(*) from Rockstar"), Results = request.Id != default(int) ? Db.Select<Rockstar>(q => q.Id == request.Id) : request.Age.HasValue ? Db.Select<Rockstar>(q => q.Age == request.Age.Value) : Db.Select<Rockstar>() }; }