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);
}
