public IHttpActionResult TopSeller() //topSellerBranchManager { BranchManagerRepository branchManagerRepository = new BranchManagerRepository(); TopBranchManagerModel branchManager = branchManagerRepository.BranchManagerInfo(); return(Ok(branchManager)); }
public TopBranchManagerModel BranchManagerInfo() { SumGroupByModel branchManagerInfo = context.Database.SqlQuery <SumGroupByModel>("select top 1 sum(TotalAmount) as Column1, BranchManagerId as Id from Invoices group by BranchManagerId order by sum(TotalAmount) desc").First(); //BranchManager manager = context.BranchManagers.Find(branchManagerInfo.Id); TopBranchManagerModel manager = context.Database.SqlQuery <TopBranchManagerModel>("select * from BranchManagers where BranchManagerId = " + branchManagerInfo.Id).First(); manager.SumAmount = branchManagerInfo.Column1; return(manager); }