private SaleProductDTO Map(tblProduct tbl)
{
var dto = new SaleProductDTO
{
MasterId = tbl.id,
DateCreated = tbl.IM_DateCreated,
DateLastUpdated = tbl.IM_DateLastUpdated,
StatusId = tbl.IM_Status,
Description = tbl.Description,
ProductBrandMasterId = tbl.BrandId ?? Guid.Empty,
ProductPackagingMasterId = tbl.PackagingId ?? Guid.Empty,
ProductPackagingTypeMasterId = tbl.PackagingTypeId ?? Guid.Empty,
ProductCode = tbl.ProductCode,
ReturnableTypeMasterId = tbl.ReturnableType,
VatClassMasterId = tbl.VatClassId,
ExFactoryPrice = tbl.ExFactoryPrice,
ProductFlavourMasterId = tbl.FlavourId ?? Guid.Empty,
ProductTypeMasterId = tbl.ProductTypeId.HasValue ?tbl.ProductTypeId.Value: Guid.Empty,
ReturnableProductMasterId = tbl.Returnable ?? Guid.Empty,
};
if (tbl.Returnable.HasValue)
{
string sql =
string.Format(
"select c.Id,c.Capacity from tblProduct r join tblProduct c on c.id=r.Returnable where r.id='{0}'",
tbl.Returnable.Value);
var container = _context.ExecuteStoreQuery<ReturnableContainer>(sql).FirstOrDefault();
if (container != null)
{
dto.ContainerCapacity = container.Capacity;
dto.ReturnableContainerMasterId = container.Id;
}
}
return dto;
}
public SaleProduct Map(SaleProductDTO dto)
{
if (dto == null) return null;
var saleProduct = Mapper.Map<SaleProductDTO, SaleProduct>(dto);
saleProduct.ReturnableProduct = (ReturnableProduct) _productRepository.GetById(dto.ReturnableProductMasterId);
saleProduct.ProductType = _productTypeRepository.GetById(dto.ProductTypeMasterId);
saleProduct.Flavour = _productFlavourRepository.GetById(dto.ProductFlavourMasterId);
saleProduct.Brand = _productBrandRepository.GetById(dto.ProductBrandMasterId);
saleProduct.PackagingType = _productPackagingTypeRepository.GetById(dto.ProductPackagingTypeMasterId);
saleProduct.VATClass = _vatClassRepository.GetById(dto.VatClassMasterId.Value);
saleProduct.Packaging = _productPackagingRepository.GetById(dto.ProductPackagingMasterId);
return saleProduct;
}
