public async Task <WrapperItemCategoryListVM> Delete(ItemCategoryVM itemTemp)
{
IEnumerable <ItemCategory> itemTask = await _repositoryWrapper.ItemCategory.FindByConditionAsync(x => x.Id == itemTemp.Id && x.FactoryId == itemTemp.FactoryId);
var item = itemTask.ToList().FirstOrDefault();
if (item == null)
{
return(new WrapperItemCategoryListVM());
}
_repositoryWrapper.ItemCategory.Delete(item);
await _repositoryWrapper.ItemCategory.SaveChangesAsync();
this._utilService.LogInfo("Successful In Deleting Item Cateory");
var dataParam = new GetDataListVM()
{
FactoryId = itemTemp.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
WrapperItemCategoryListVM data = await GetListPaged(dataParam);
return(data);
}
public async Task <WrapperItemCategoryListVM> GetListPaged(GetDataListVM dataListVM)
{
System.Linq.Expressions.Expression <Func <ItemCategory, bool> > globalFilterExpression = (x) => true;
if (string.IsNullOrEmpty(dataListVM.GlobalFilter) || string.IsNullOrWhiteSpace(dataListVM.GlobalFilter))
{
globalFilterExpression = (x) => true;
}
else
{
globalFilterExpression = (x) =>
x.Name.Contains(dataListVM.GlobalFilter);
}
var itemCatagoryList = await _repositoryWrapper.ItemCategory
.FindAll()
.Where(x => x.FactoryId == dataListVM.FactoryId)
.Where(globalFilterExpression)
.OrderByDescending(x => x.UpdatedDateTime)
.Skip((dataListVM.PageNumber - 1) * (dataListVM.PageSize))
.Take(dataListVM.PageSize)
.ToListAsync();
var dataRowCount = await _repositoryWrapper.ItemCategory.NumOfRecord();
List <ItemCategoryVM> itemCategoryVMLists = new List <ItemCategoryVM>();
itemCategoryVMLists = _utilService.GetMapper().Map <List <ItemCategory>, List <ItemCategoryVM> >(itemCatagoryList);
var wrapper = new WrapperItemCategoryListVM()
{
ListOfData = itemCategoryVMLists,
TotalRecords = dataRowCount
};
this._utilService.LogInfo("Successful In Getting Item Category");
return(wrapper);
}
public async Task <WrapperItemCategoryListVM> Update(string id, ItemCategoryVM vm)
{
IEnumerable <ItemCategory> ItemDB = await _repositoryWrapper.ItemCategory.FindByConditionAsync(x => x.Id == id && x.FactoryId == vm.FactoryId);
var ItemUpdated = _utilService.GetMapper().Map <ItemCategoryVM, ItemCategory>(vm, ItemDB.ToList().FirstOrDefault());
_repositoryWrapper.ItemCategory.Update(ItemUpdated);
await _repositoryWrapper.ItemCategory.SaveChangesAsync();
this._utilService.LogInfo("Successful In Updating Item Cateory");
var dataParam = new GetDataListVM()
{
FactoryId = vm.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
WrapperItemCategoryListVM data = await GetListPaged(dataParam);
return(data);
}
public async Task <WrapperItemCategoryListVM> Add(ItemCategoryVM vm)
{
var entityToAdd = _utilService.GetMapper().Map <ItemCategoryVM, ItemCategory>(vm);
//string uniqueIdTask =await _repositoryWrapper.ItemCategory.GetUniqueId();
//// Todo need to aandle unique id from db
//entityToAdd.UniqueId = uniqueIdTask;
entityToAdd = _repositoryWrapper.ItemCategory.Create(entityToAdd);
await _repositoryWrapper.ItemCategory.SaveChangesAsync();
this._utilService.LogInfo("Successful In saving Item Category");
var dataParam = new GetDataListVM()
{
FactoryId = vm.FactoryId,
PageNumber = 1,
PageSize = 10,
TotalRows = 0
};
WrapperItemCategoryListVM data = await GetListPaged(dataParam);
return(data);
}