public async Task <SalesFilteredResponse <object> > GetAllSales(BaseSearchRequestModel request) { try { var csvSales = _context.CSVSales .OrderBy(x => x.OrderDate) .AsNoTracking(); return(await GetSearchDDLModel.ReturnSales(_context, csvSales, request)); } catch (Exception ex) { throw ex; } }
public async Task <CreateSaleFilteringResponse <object> > CreateSale(SearchSaleRequestModel request) { try { var newSale = request.SaleViewModel; var addSale = new CSVSale { Region = newSale.Region, Country = newSale.Country, ItemType = newSale.ItemType, SalesChannel = newSale.SalesChannel, OrderPriority = newSale.OrderPriority, OrderDate = newSale.OrderDate, OrderID = newSale.OrderID, ShipDate = newSale.ShipDate, UnitsSold = newSale.UnitsSold, UnitPrice = newSale.UnitPrice, UnitCost = newSale.UnitCost, TotalRevenue = newSale.TotalRevenue, TotalCost = newSale.TotalCost, TotalProfit = newSale.TotalProfit }; _context.CSVSales.Add(addSale); await _context.SaveChangesAsync(); var csvSales = _context.CSVSales .OrderBy(x => x.OrderDate) .AsNoTracking(); var result = await GetSearchDDLModel.ReturnSales(_context, csvSales, request); return(new CreateSaleFilteringResponse <object> { Total = result.Total, Length = result.Length, Data = result.Data, DropDownLists = result.DropDownLists, NewSaleId = addSale.ID }); } catch (Exception ex) { throw ex; } }
public async Task <SalesFilteredResponse <object> > UpdateSale(UpdateSaleRequestModel request) { try { var updateSale = request.SaleViewModel; var changedSale = _context .CSVSales .FirstOrDefault(u => u.ID == updateSale.ID); if (changedSale == null) { throw new EntityNotFoundException(); } changedSale.Region = updateSale.Region; changedSale.Country = updateSale.Country; changedSale.ItemType = updateSale.ItemType; changedSale.SalesChannel = updateSale.SalesChannel; changedSale.OrderPriority = updateSale.OrderPriority; changedSale.OrderDate = updateSale.OrderDate; changedSale.OrderID = updateSale.OrderID; changedSale.ShipDate = updateSale.ShipDate; changedSale.UnitsSold = updateSale.UnitsSold; changedSale.UnitPrice = updateSale.UnitPrice; changedSale.UnitCost = updateSale.UnitCost; changedSale.TotalRevenue = updateSale.TotalRevenue; changedSale.TotalCost = updateSale.TotalCost; changedSale.TotalProfit = updateSale.TotalProfit; _context.SaveChanges(); var csvSales = _context.CSVSales .OrderBy(x => x.OrderDate) .AsNoTracking(); return(await GetSearchDDLModel.ReturnSales(_context, csvSales, request)); } catch (Exception ex) { throw ex; } }