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()); } var response = new RockstarsResponse { Aged = request.Age, Total = Db.Scalar <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>() }; if (request.View != null || request.Template != null) { return new HttpResult(response) { View = request.View, Template = request.Template, } } ; return(response); }
public override object OnGet(Rockstars request) { using (var db = DbFactory.OpenDbConnection()) { if (request.Delete == "reset") { db.DeleteAll <Rockstar>(); db.Insert(Rockstar.SeedData); } else if (request.Delete.IsInt()) { db.DeleteById <Rockstar>(request.Delete.ToInt()); } var response = 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>() }; if (request.View != null || request.Template != null) { return new HttpResult(response) { View = request.View, Template = request.Template, } } ; return(response); } }
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()); } var response = new RockstarsResponse { Aged = request.Age, Total = Db.Scalar<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>() }; if (request.View != null || request.Template != null) return new HttpResult(response) { View = request.View, Template = request.Template, }; return response; }