private async Task <int> GetMaximumSaleNumber(GetQueryStr query) { var prodlist = await _context.Sales.Where(e => e.BranchId.Equals(query.branchid) && e.ShopId.Equals(query.shopid) && e.Dates.Equals(query.Sdate)).GroupBy(f => f.Billnum).ToListAsync(); return(prodlist.Count); }
public async Task <IActionResult> GetMaxSaleCount([FromQuery] GetQueryStr query) { if (query == null) { return(BadRequest()); } //var prodlist = await _context.Sales.Where(e => e.BranchId.Equals(query.branchid) //&& e.ShopId.Equals(query.shopid) && e.UserId.Equals(query.userId) && e.Dates.Equals(query.Sdate)).GroupBy(f => f.Billnum).ToListAsync(); var numb = await GetMaximumSaleNumber(query); return(Ok(numb)); }
public async Task <IActionResult> Get([FromQuery] GetQueryStr query) { if (query == null) { return(BadRequest()); } var list = await _context.ShopDetails.Where(e => e.BranchId.Equals(query.branchid) && e.ShopId.Equals(query.shopid)).FirstOrDefaultAsync(); if (list != null) { var tolist = Mapper.Map <ShopDetailsDTO>(list); return(Ok(tolist)); } return(NotFound()); }
public async Task <IActionResult> Get([FromQuery] GetQueryStr query) { if (query == null) { return(BadRequest()); } var salelist = await _context.Salebook.Where(e => e.BranchId.Equals(query.branchid) && e.ShopId.Equals(query.shopid)).ToListAsync(); if (salelist.Count > 0) { var saledtolist = Mapper.Map <List <SalebookDTO> >(salelist); return(Ok(saledtolist)); } return(NotFound()); }
public async Task <IActionResult> GetMySalesForDay(GetQueryStr query) { if (query.userId == 0 && query.branchid == 0) { return(BadRequest()); } var saleslist = await _context.Sales.Where(e => e.BranchId.Equals(query.branchid) && e.ShopId.Equals(query.shopid) && e.UserId.Equals(query.userId) && e.Dates.Date.Equals(query.Sdate.Date)) .GroupBy(e => new { e.Billnum, e.Totalamount }) .Select(y => new SaleDtoArray() { BillNum = y.Key.Billnum, Totalamount = y.Key.Totalamount, SaleInfos = Mapper.Map <List <SalesDTO> >(y.ToList()), CanReturn = CanReturnProducts(y, y.Key.Billnum) }).ToListAsync(); return(Ok(saleslist)); }