public async Task <WrapperSalesListVM> GetAllSalesAsync(GetDataListVM getDataListVM)
{
WrapperSalesListVM vm = new WrapperSalesListVM();
List <SalesVM> vmList = new List <SalesVM>();
Task <List <Invoice> > invoicesT = _repositoryWrapper
.Invoice
.FindAll()
.Include(x => x.Customer)
.Include(x => x.InvoiceType)
.Where(x => x.FactoryId == getDataListVM.FactoryId &&
x.InvoiceType.Name == TypeInvoice.Sales.ToString())
.Skip((getDataListVM.PageNumber - 1) * (getDataListVM.PageSize))
.Take(getDataListVM.PageSize)
.ToListAsync();
Task <List <Sales> > salesT = _repositoryWrapper
.Sales
.FindAll()
.Where(x => x.FactoryId == getDataListVM.FactoryId)
.Include(x => x.Item)
.ThenInclude(s => s.ItemCategory)
.ToListAsync();
await Task.WhenAll(invoicesT, salesT);
List <Sales> dbListSales = salesT.Result.ToList();
vmList = _utilService.Mapper.Map <List <Invoice>, List <SalesVM> >(invoicesT.Result.ToList());
List <Sales> temp = new List <Sales>();
for (int i = 0; i < vmList.Count; i++)
{
temp = dbListSales.Where(x => x.InvoiceId == vmList.ElementAt(i).InvoiceId).ToList();
vmList.ElementAt(i).ItemList = _utilService.Mapper.Map <List <Sales>, List <SalesItemVM> >(temp);
}
vm.ListOfData = vmList;
vm.TotalRecords = invoicesT.Result.ToList().Count;
return(vm);
}
// Invoice
// Income
// Recievable
// Sales
// Stock
// StockOut
// Transaction
public async Task <WrapperSalesListVM> AddSalesAsync(SalesVM salesVM)
{
// Invoice
Invoice invoiceToAdd = new Invoice();
invoiceToAdd = _utilService.Mapper.Map <SalesVM, Invoice>(salesVM);
_repositoryWrapper.Invoice.Create(invoiceToAdd);
// Setting Up Invoice Id
salesVM.InvoiceId = invoiceToAdd.Id;
foreach (var item in salesVM.ItemList)
{
item.InvoiceId = invoiceToAdd.Id;
}
// Income
Income incomeToAdd = new Income();
incomeToAdd = this._utilService.Mapper.Map <SalesVM, Income>(salesVM);
_repositoryWrapper.Income.Create(incomeToAdd);
// Recievable
Recievable recievableToAdd = new Recievable();
recievableToAdd = _utilService.Mapper.Map <SalesVM, Recievable>(salesVM);
_repositoryWrapper.Recievable.Create(recievableToAdd);
// Sales
List <Sales> listOfSalesToAdd = new List <Sales>();
listOfSalesToAdd = _utilService.Mapper.Map <List <SalesItemVM>, List <Sales> >(salesVM.ItemList);
_repositoryWrapper.Sales.CreateAll(listOfSalesToAdd);
// Stock
Stock stockToAdd = new Stock();
IEnumerable <Stock> stockList = await _repositoryWrapper.Stock.FindByConditionAsync(x => x.FactoryId == salesVM.FactoryId);
for (int i = 0; i < salesVM.ItemList.Count; i++)
{
Stock existingStock = stockList.ToList().Where(x => x.ItemId == salesVM.ItemList[i].Item.Id && x.ItemStatusId == salesVM.ItemList[i].ItemStatus.Id).FirstOrDefault();
if (existingStock == null)
{
var getDatalistVM2 = new GetDataListVM()
{
FactoryId = salesVM.FactoryId,
PageNumber = 1,
PageSize = 10
};
WrapperSalesListVM dataToReturn = await GetAllSalesAsync(getDatalistVM2);
dataToReturn.HasMessage = true;
dataToReturn.Message = "Stock Is Empty";
return(dataToReturn);
// _utilService.Log("Stock Is Empty. Not Enough Stock available");
// throw new StockEmptyException();
}
else
{
if (existingStock.Quantity >= salesVM.ItemList[i].Quantity)
{
existingStock.Quantity -= salesVM.ItemList[i].Quantity;
_repositoryWrapper.Stock.Update(existingStock);
}
else
{
_utilService.Log("Stock Is Empty");
return(new WrapperSalesListVM());
}
}
}
// StockOut
List <StockOut> stockOutsToAdd = new List <StockOut>();
stockOutsToAdd = _utilService.Mapper.Map <List <SalesItemVM>, List <StockOut> >(salesVM.ItemList);
_repositoryWrapper.StockOut.CreateAll(stockOutsToAdd);
// Transaction
TblTransaction transactionRecieved = new TblTransaction();
transactionRecieved = _utilService.Mapper.Map <SalesVM, TblTransaction>(salesVM);
transactionRecieved.Amount = salesVM.PaidAmount;
transactionRecieved.PaymentStatus = PAYMENT_STATUS.CASH_RECIEVED.ToString();
transactionRecieved.TransactionType = TRANSACTION_TYPE.CREDIT.ToString();
_repositoryWrapper.Transaction.Create(transactionRecieved);
//TblTransaction transactionRecievable = new TblTransaction();
//transactionRecievable = _utilService.Mapper.Map<SalesVM, TblTransaction>(salesVM);
//transactionRecievable.Amount = salesVM.DueAmount;
//transactionRecievable.PaymentStatus = PAYMENT_STATUS.CASH_RECIEVABLE.ToString();
//transactionRecievable.TransactionType = TRANSACTION_TYPE.NOT_YET_EXECUTED.ToString();
//transactionRecievable.TransactionId = transactionRecieved.TransactionId;
//_repositoryWrapper.Transaction.Create(transactionRecievable);
Task <int> Invoice = _repositoryWrapper.Invoice.SaveChangesAsync();
Task <int> Income = _repositoryWrapper.Income.SaveChangesAsync();
Task <int> Recievable = _repositoryWrapper.Recievable.SaveChangesAsync();
Task <int> Sales = _repositoryWrapper.Sales.SaveChangesAsync();
Task <int> Stock = _repositoryWrapper.Stock.SaveChangesAsync();
Task <int> StockOut = _repositoryWrapper.StockOut.SaveChangesAsync();
Task <int> Transaction = _repositoryWrapper.Transaction.SaveChangesAsync();
await Task.WhenAll(Invoice, Income, Recievable, Sales, Stock, StockOut, Transaction);
var getDatalistVM = new GetDataListVM()
{
FactoryId = salesVM.FactoryId,
PageNumber = 1,
PageSize = 10
};
return(await GetAllSalesAsync(getDatalistVM));
}