public async Task <WrapperStockListVM> GetListPaged(GetDataListVM dataListVM)
{
IEnumerable <Stock> ListTask =
await _repositoryWrapper.Stock
.FindByCondition(x => x.FactoryId == dataListVM.FactoryId)
.Include(x => x.Item)
.Include(x => x.ItemStatus)
.ToListAsync();
long noOfRecordTask = await _repositoryWrapper.Stock.NumOfRecord();
List <Stock> List = ListTask.ToList().OrderByDescending(x => x.UpdatedDateTime).ToList();//.Skip((dataListVM.PageNumber - 1) * dataListVM.PageSize).Take(dataListVM.PageSize).OrderByDescending(x => x.CreatedDateTime).ToList();
List <StockVM> outputList = new List <StockVM>();
outputList = _utilService.GetMapper().Map <List <Stock>, List <StockVM> >(List);
if (!string.IsNullOrEmpty(dataListVM.GlobalFilter) && !string.IsNullOrWhiteSpace(dataListVM.GlobalFilter))
{
outputList = outputList.Where(output =>
output.ItemName != null ? output.ItemName.Contains(dataListVM.GlobalFilter, StringComparison.OrdinalIgnoreCase) : false ||
output.ItemStatus != null ? output.ItemStatus.Contains(dataListVM.GlobalFilter, StringComparison.OrdinalIgnoreCase) : false ||
output.Quantity.ToString() != null ? output.Quantity.ToString().Contains(dataListVM.GlobalFilter, StringComparison.OrdinalIgnoreCase) : false)
.ToList();
}
outputList = outputList.Skip((dataListVM.PageNumber - 1) * dataListVM.PageSize).Take(dataListVM.PageSize).ToList();
var data = new WrapperStockListVM();
data.ListOfData = outputList;
data.TotalRecords = noOfRecordTask;
this._utilService.Log("Successful In Getting Data");
return(data);
}
public async Task <WrapperStockListVM> Update(string id, StockVM ViewModel)
{
if (id != ViewModel.Id)
{
new WrapperStockListVM();
}
Task <IEnumerable <Stock> > itemsDB = _repositoryWrapper.Stock.FindByConditionAsync(x => x.Id == id && x.FactoryId == ViewModel.FactoryId);
await Task.WhenAll(itemsDB);
var itemUpdated = _utilService.GetMapper().Map <StockVM, Stock>(ViewModel, itemsDB.Result.ToList().FirstOrDefault());
_repositoryWrapper.Stock.Update(itemUpdated);
Task <int> t1 = _repositoryWrapper.Stock.SaveChangesAsync();
await Task.WhenAll(t1);
this._utilService.Log("Successful In Updating Data");
var dataParam = new GetDataListVM()
{
FactoryId = ViewModel.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
WrapperStockListVM data = await GetListPaged(dataParam);
return(data);
}
public async Task <WrapperStockListVM> Delete(StockVM Temp)
{
var Task = await _repositoryWrapper.Stock.FindByConditionAsync(x => x.Id == Temp.Id && x.FactoryId == Temp.FactoryId);
var datarow = Task.ToList().FirstOrDefault();
if (datarow == null)
{
return(new WrapperStockListVM());
}
_repositoryWrapper.Stock.Delete(datarow);
await _repositoryWrapper.Stock.SaveChangesAsync();
this._utilService.Log("Successful In Deleting Data");
var dataParam = new GetDataListVM()
{
FactoryId = Temp.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
WrapperStockListVM data = await GetListPaged(dataParam);
return(data);
}
public async Task <ActionResult <WrapperStockListVM> > DeleteStock([FromBody] StockVM Temp)
{
WrapperStockListVM vb = new WrapperStockListVM();
vb = await _serviceWrapper.StockService.Delete(Temp);
_utilService.Log("Stock Successfully Deleted");
return(vb);
}
public async Task <ActionResult <WrapperStockListVM> > UpdateStock(string id, [FromBody] StockVM temp)
{
WrapperStockListVM result = new WrapperStockListVM();
result = await _serviceWrapper.StockService.Update(id, temp);
_utilService.Log("Stock Successfully Updated");
return(Ok(result));
}
public async Task <ActionResult <WrapperStockListVM> > AddStock([FromBody] StockVM VM)
{
WrapperStockListVM result = new WrapperStockListVM();
VM.ExpiryDate = VM.ExpiryDate.ToLocalTime();
result = await _serviceWrapper.StockService.Add(VM);
_utilService.Log("Stock Successfully Added");
return(Ok(result));
}
public async Task <WrapperStockListVM> Add(StockVM ViewModel)
{
var itemToAdd = _utilService.GetMapper().Map <StockVM, Stock>(ViewModel);
itemToAdd = _repositoryWrapper.Stock.Create(itemToAdd);
Task <int> t1 = _repositoryWrapper.Stock.SaveChangesAsync();
await Task.WhenAll(t1);
this._utilService.Log("Successful In Adding Data");
var dataParam = new GetDataListVM()
{
FactoryId = itemToAdd.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
WrapperStockListVM data = await GetListPaged(dataParam);
return(data);
}
public async Task <WrapperStockListVM> ChangeItemStatus(StockVM ViewModel)
{
var dataParam6 = new GetDataListVM()
{
FactoryId = ViewModel.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
Task <IEnumerable <Stock> > itemsDB = _repositoryWrapper.Stock.FindByConditionAsync(x => x.Id == ViewModel.Id && x.FactoryId == ViewModel.FactoryId);
Task <WrapperStockListVM> data1 = GetListPaged(dataParam6);
Task <IEnumerable <Stock> > stockDB = _repositoryWrapper.Stock.FindByConditionAsync(x => x.FactoryId == ViewModel.FactoryId && x.ItemStatusId == ViewModel.ItemStatusId);
await Task.WhenAll(itemsDB, data1, stockDB);
Stock stock = itemsDB.Result.ToList().FirstOrDefault();
if (stock.Quantity < ViewModel.Quantity || ViewModel.ItemStatusId == stock.ItemStatusId)
{
return(data1.Result);
}
stock.Quantity -= ViewModel.Quantity;
_repositoryWrapper.Stock.Update(stock);
// Task<int> t3 = _repositoryWrapper.Stock.SaveChangesAsync();
// await Task.WhenAll(t3);
await stockDB;
Stock tempStock = stockDB.Result.ToList().FirstOrDefault();
if (tempStock == null)
{
return(await Add(ViewModel));
}
else
{
tempStock.Quantity += ViewModel.Quantity;
_repositoryWrapper.Stock.Update(tempStock);
}
await _repositoryWrapper.Stock.SaveChangesAsync();
WrapperStockListVM data2 = await GetListPaged(dataParam6);
return(data2);
//var itemToAdd = _utilService.GetMapper().Map<StockVM, Stock>(ViewModel);
//itemToAdd = _repositoryWrapper.Stock.Create(itemToAdd);
//Task<int> t1 = _repositoryWrapper.Stock.SaveChangesAsync();
//await Task.WhenAll(t1);
//this._utilService.Log("Successful In Adding Data");
//var dataParam = new GetDataListVM()
//{
// FactoryId = itemToAdd.FactoryId,
// PageNumber = 1,
// PageSize = 10,
// TotalRows = 0
//};
//WrapperStockListVM data = await GetListPaged(dataParam);
//return data;
}
