public async Task <AppSubCategory> Insert(AppSubCategory appSubCategory)
{
await _unitOfWork.AppSubCategoryRepository.Add(appSubCategory);
await _unitOfWork.SaveChangesAsync();
return(appSubCategory);
}
public async Task <AppSubCategory> Update(AppSubCategory appSubCategory)
{
var appSubCategoryFind = await GetById(appSubCategory.Id);
if (appSubCategoryFind == null)
{
throw new Exception("Documento No existe");
}
_unitOfWork.AppSubCategoryRepository.Update(appSubCategory);
await _unitOfWork.SaveChangesAsync();
return(await GetById(appSubCategory.Id));
}
public async Task <ApiResponse <AppProductsGetDto> > GetProduct(int id)
{
AppProductsGetDto resultDto = new AppProductsGetDto();
Metadata metadata = new Metadata
{
IsValid = true,
Message = ""
};
ApiResponse <AppProductsGetDto> response = new ApiResponse <AppProductsGetDto>(resultDto);
try
{
AppProducts appProductsFind = await GetById(id);
if (appProductsFind == null)
{
metadata.IsValid = false;
metadata.Message = "Codigo de producto no existe, verifique por favor";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
resultDto = _mapper.Map <AppProductsGetDto>(appProductsFind);
AppUnits AppUnitsFind = await _appUnitsService.GetById((int)appProductsFind.AppUnitsId);
if (AppUnitsFind != null)
{
AppUnitsGetDto appUnitsGetDto = _mapper.Map <AppUnitsGetDto>(AppUnitsFind);
resultDto.AppUnitsGetDto = appUnitsGetDto;
}
AppUnitsFind = await _appUnitsService.GetById((int)appProductsFind.ProductionUnitId);
if (AppUnitsFind != null)
{
AppUnitsGetDto appUnitsGetDto = _mapper.Map <AppUnitsGetDto>(AppUnitsFind);
resultDto.ProductionUnitGetDto = appUnitsGetDto;
}
MtrTipoMoneda MtrTipoMonedaFind = await _mtrTipoMonedaService.GetById((long)appProductsFind.PrymaryMtrMonedaId);
if (MtrTipoMonedaFind != null)
{
MtrTipoMonedaDto mtrTipoMonedaDto = _mapper.Map <MtrTipoMonedaDto>(MtrTipoMonedaFind);
resultDto.PrymaryMtrMonedaGetDto = mtrTipoMonedaDto;
}
MtrTipoMonedaFind = await _mtrTipoMonedaService.GetById((long)appProductsFind.SecundaryMtrMonedaId);
if (MtrTipoMonedaFind != null)
{
MtrTipoMonedaDto mtrTipoMonedaDto = _mapper.Map <MtrTipoMonedaDto>(MtrTipoMonedaFind);
resultDto.SecundaryMtrMonedaGetDto = mtrTipoMonedaDto;
}
AppSubCategory AppSubCategoryFind = await _appSubCategoryService.GetById((int)appProductsFind.AppSubCategoryId);
if (AppSubCategoryFind != null)
{
AppSubCategoryGetDto appSubCategoryGetDto = _mapper.Map <AppSubCategoryGetDto>(AppSubCategoryFind);
resultDto.AppSubCategoryGetDto = appSubCategoryGetDto;
}
if (resultDto.UrlImage == "" || resultDto.UrlImage == null)
{
resultDto.Link = _paginationOptions.UrlGetFiles + "NoImage.png";
}
else
{
resultDto.Link = _paginationOptions.UrlGetFiles + resultDto.UrlImage;
}
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
catch (Exception ex)
{
metadata.IsValid = false;
metadata.Message = ex.InnerException.Message;
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
}
public async Task <ApiResponse <List <AppProductsGetDto> > > GetAll(AppProdutsQueryFilter filters)
{
filters.PageNumber = filters.PageNumber == 0 ? _paginationOptions.DefaultPageNumber : filters.PageNumber;
filters.PageSize = filters.PageSize == 0 ? _paginationOptions.DefaultPageSize : filters.PageSize;
List <AppProductsGetDto> resultDto = new List <AppProductsGetDto>();
Metadata metadata = new Metadata
{
IsValid = true,
Message = ""
};
ApiResponse <List <AppProductsGetDto> > response = new ApiResponse <List <AppProductsGetDto> >(resultDto);
try
{
var appProducts = await _unitOfWork.AppProductsRepository.GetAllFilter(filters);
if (appProducts != null)
{
List <AppProductsGetDto> appProductsDto = _mapper.Map <List <AppProductsGetDto> >(appProducts);
foreach (var item in appProductsDto)
{
if (item.UrlImage == "" || item.UrlImage == null)
{
item.Link = _paginationOptions.UrlGetFiles + "NoImage.png";
}
else
{
item.Link = _paginationOptions.UrlGetFiles + item.UrlImage;
}
AppUnits AppUnitsFind = await _appUnitsService.GetById((int)item.AppUnitsId);
if (AppUnitsFind != null)
{
AppUnitsGetDto appUnitsGetDto = _mapper.Map <AppUnitsGetDto>(AppUnitsFind);
item.AppUnitsGetDto = appUnitsGetDto;
}
AppUnitsFind = await _appUnitsService.GetById((int)item.ProductionUnitId);
if (AppUnitsFind != null)
{
AppUnitsGetDto appUnitsGetDto = _mapper.Map <AppUnitsGetDto>(AppUnitsFind);
item.ProductionUnitGetDto = appUnitsGetDto;
}
MtrTipoMoneda MtrTipoMonedaFind = await _mtrTipoMonedaService.GetById((long)item.PrymaryMtrMonedaId);
if (MtrTipoMonedaFind != null)
{
MtrTipoMonedaDto mtrTipoMonedaDto = _mapper.Map <MtrTipoMonedaDto>(MtrTipoMonedaFind);
item.PrymaryMtrMonedaGetDto = mtrTipoMonedaDto;
}
MtrTipoMonedaFind = await _mtrTipoMonedaService.GetById((long)item.SecundaryMtrMonedaId);
if (MtrTipoMonedaFind != null)
{
MtrTipoMonedaDto mtrTipoMonedaDto = _mapper.Map <MtrTipoMonedaDto>(MtrTipoMonedaFind);
item.SecundaryMtrMonedaGetDto = mtrTipoMonedaDto;
}
AppSubCategory AppSubCategoryFind = await _appSubCategoryService.GetById((int)item.AppSubCategoryId);
if (AppSubCategoryFind != null)
{
AppSubCategoryGetDto appSubCategoryGetDto = _mapper.Map <AppSubCategoryGetDto>(AppSubCategoryFind);
item.AppSubCategoryGetDto = appSubCategoryGetDto;
}
}
response.Data = appProductsDto;
response.Meta = metadata;
return(response);
}
else
{
metadata.IsValid = true;
metadata.Message = "No Data....";
response.Data = null;
response.Meta = metadata;
return(response);
}
}
catch (Exception ex)
{
metadata.IsValid = false;
metadata.Message = ex.InnerException.Message;
response.Data = null;
response.Meta = metadata;
return(response);
}
}
public async Task <ApiResponse <AppProductsGetDto> > UpdateProducts(AppProductsUpdateDto appProductsUpdateDto)
{
AppProductsGetDto resultDto = new AppProductsGetDto();
Metadata metadata = new Metadata
{
IsValid = true,
Message = ""
};
ApiResponse <AppProductsGetDto> response = new ApiResponse <AppProductsGetDto>(resultDto);
try
{
AppProducts appProductsFind = await GetById(appProductsUpdateDto.Id);
if (appProductsFind == null)
{
metadata.IsValid = false;
metadata.Message = "Codigo de producto no existe, verifique por favor";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
if (appProductsUpdateDto.ExternalCode == "")
{
metadata.IsValid = false;
metadata.Message = "Codigo Externo no es valido";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
AppUnits appUnitsFind = await _appUnitsService.GetById((int)appProductsUpdateDto.AppUnitsId);
if (appUnitsFind == null)
{
metadata.IsValid = false;
metadata.Message = "Unidad venta del Producto No existe";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
appUnitsFind = await _appUnitsService.GetById((int)appProductsUpdateDto.ProductionUnitId);
if (appUnitsFind == null)
{
metadata.IsValid = false;
metadata.Message = "Unidad Produccion del Producto No existe";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
MtrTipoMoneda mtrTipoMonedaFind = await _unitOfWork.MtrTipoMonedaRepository.GetById((long)appProductsUpdateDto.PrymaryMtrMonedaId);
if (mtrTipoMonedaFind == null)
{
metadata.IsValid = false;
metadata.Message = "Moneda Primaria No Existe!!! ";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
mtrTipoMonedaFind = await _unitOfWork.MtrTipoMonedaRepository.GetById((long)appProductsUpdateDto.SecundaryMtrMonedaId);
if (mtrTipoMonedaFind == null)
{
metadata.IsValid = false;
metadata.Message = "Moneda Secundaria No Existe!!! ";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
AppSubCategory appSubCategory = await _unitOfWork.AppSubCategoryRepository.GetById((int)appProductsUpdateDto.AppSubCategoryId);
if (appSubCategory == null)
{
metadata.IsValid = false;
metadata.Message = "Subcategoria No Existe!!! ";
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
appProductsFind.ProductionUnitId = appProductsUpdateDto.ProductionUnitId;
appProductsFind.AppUnitsId = appProductsUpdateDto.AppUnitsId;
appProductsFind.AppSubCategoryId = appProductsUpdateDto.AppSubCategoryId;
appProductsFind.PrymaryMtrMonedaId = appProductsUpdateDto.PrymaryMtrMonedaId;
appProductsFind.SecundaryMtrMonedaId = appProductsUpdateDto.SecundaryMtrMonedaId;
appProductsFind.UnitPrice = appProductsUpdateDto.UnitPrice;
appProductsFind.Description1 = appProductsUpdateDto.Description1;
appProductsFind.Description2 = appProductsUpdateDto.Description2;
appProductsFind.ExternalCode = appProductsUpdateDto.ExternalCode;
appProductsFind.UserUpdate = appProductsUpdateDto.UsuarioConectado;
appProductsFind.UpdatedAt = DateTime.Now;
AppProducts appProductsUpdated = await Update(appProductsFind);
if (appProductsUpdated != null)
{
resultDto = _mapper.Map <AppProductsGetDto>(appProductsUpdated);
AppUnits AppUnitsFind = await _appUnitsService.GetById((int)appProductsUpdated.AppUnitsId);
if (AppUnitsFind != null)
{
AppUnitsGetDto appUnitsGetDto = _mapper.Map <AppUnitsGetDto>(AppUnitsFind);
resultDto.AppUnitsGetDto = appUnitsGetDto;
}
if (resultDto.UrlImage == "" || resultDto.UrlImage == null)
{
resultDto.Link = _paginationOptions.UrlGetFiles + "NoImage.png";
}
else
{
resultDto.Link = _paginationOptions.UrlGetFiles + resultDto.UrlImage;
}
metadata.IsValid = true;
metadata.Message = $"Producto: {resultDto.Code} Actualizado Satisfactoriamente!!";
}
else
{
metadata.IsValid = false;
metadata.Message = "Registro No actualizado";
}
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
catch (Exception ex)
{
metadata.IsValid = false;
metadata.Message = ex.InnerException.Message;
response.Meta = metadata;
response.Data = resultDto;
return(response);
}
}
public async Task Delete(int id)
{
AppSubCategory entity = await GetById(id);
_context.AppSubCategory.Remove(entity);
}
public void Update(AppSubCategory entity)
{
_context.AppSubCategory.Update(entity);
}
public async Task Add(AppSubCategory entity)
{
await _context.AppSubCategory.AddAsync(entity);
}
