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