public async Task <IEnumerable <EntreeInfoResource> > GetEntreeInfoWithVegeId(int VegeId)
{
var entreeInfo = new List <EntreeInfoResource>();
await _context.LoadStoredProc("dbo.GetEntreeInfoById")
.WithSqlParam("Id", VegeId)
.WithSqlParam("Type", "Vegetable")
.ExecuteStoredProcAsync((handler) => {
entreeInfo = handler.ReadToList <EntreeInfoResource>().ToList();
// do something with your results.
});
return(entreeInfo);
}
public async Task <int> GetNumberOfEntreesWithVege(int vegeId)
{
// Use Store Procedure
int numberOfEntreeWithVege = -1;
await _context.LoadStoredProc("dbo.GetNumberOfEntreeById")
.WithSqlParam("Id", vegeId)
.WithSqlParam("Type", "Vegetable")
.ExecuteStoredProcAsync((handler) => {
numberOfEntreeWithVege = handler.ReadToValue <int> () ?? default(int);;
// do something with your results.
});
/*
* // Use Raw SQL
* await _context.LoadSQLText ("SELECT COUNT(*) AS TotalEntrees FROM EntreeVegetable WHERE VegeId = " + vegeId.ToString ())
* .ExecuteSQLTextAsync ((handler) => {
* numberOfEntreeWithVege = handler.ReadToValue<int>() ?? default(int);;
* // do something with your results.
* });
*/
/*
* // Use Entity Framework Query Data
* // Note: include not working in Count()
* var vegetable = this._context.Vegetables.Single(v => v.Id == vegeId);
*
* numberOfEntreeWithVege = await this._context.Entry(vegetable)
* .Collection(v => v.EntreesWithCurrentVegetable)
* .Query()
* .CountAsync();
*/
return(numberOfEntreeWithVege);
}
public async Task <int> GetNumberOfEntreesWithMeat(int meatId)
{
// Use Store Procedure
int numberOfEntreeWithVege = -1;
await _context.LoadStoredProc("dbo.GetNumberOfEntreeById")
.WithSqlParam("Id", meatId)
.WithSqlParam("Type", "Meat")
.ExecuteStoredProcAsync((handler) => {
numberOfEntreeWithVege = handler.ReadToValue <int> () ?? default(int);;
// do something with your results.
});
return(numberOfEntreeWithVege);
}
