public IEnumerable <ProductDetailResult> GetAllASMasterSubCategoryEmployee(long MasterEmployeeId) { try { var _data = (from MC in _Context.ASMasterCategories join MSC in _Context.ASMasterSubCategories on MC.MasterCategoryId equals MSC.MasterCategoryId join MP in _Context.ASMasterProducts on MSC.MasterSubCategoryId equals MP.MasterSubCategoryId into MPGroup from MP in MPGroup.DefaultIfEmpty() join MPC in _Context.ASMasterProductChilds on MP.MasterProductId equals MPC.MasterProductId into MPCGroup from MPC in MPCGroup.DefaultIfEmpty() where MPC.MasterEmployeeId == MasterEmployeeId select new { MC.MasterCategoryId, MC.CategoryTitle, MSC.MasterSubCategoryId, MSC.SubCategoryTitle, MPC.ProductChildTitle, MPC.ProductChildSKU, MPC.ManufacturerPartNumber, MPC.PurchasePrice, MPC.DepreciatePrice, MPC.IsActive, MPC.IsDeadAssets, MPC.IsSaleProduct, MPC.MasterBranchId, MPC.MasterEmployeeId }); List <ProductDetailResult> objProductDetailResultList = new List <ProductDetailResult>(); foreach (var _Item in _data.ToList()) { var _ProductDetailResult = new ProductDetailResult(); _ProductDetailResult.MasterSubCategoryId = _Item.MasterSubCategoryId; _ProductDetailResult.SubCategoryTitle = _Item.SubCategoryTitle; _ProductDetailResult.MasterCategoryId = _Item.MasterCategoryId; _ProductDetailResult.CategoryTitle = _Item.CategoryTitle; _ProductDetailResult.ProductChildTitle = _Item.ProductChildTitle; _ProductDetailResult.ProductChildSKU = _Item.ProductChildSKU; _ProductDetailResult.ManufacturerPartNumber = _Item.ManufacturerPartNumber; _ProductDetailResult.TotalAssetsInStock = (_data.Where(a => a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _ProductDetailResult.AssetsAssign = (_data.Where(a => a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false && (a.MasterEmployeeId != 0)).Count()); _ProductDetailResult.AssetsInRepair = (_data.Where(a => a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _ProductDetailResult.TotalAssetsCost = _Item.PurchasePrice ?? 0; _ProductDetailResult.TotalAssetsDepreciatedValue = _Item.DepreciatePrice ?? 0; objProductDetailResultList.Add(_ProductDetailResult); } return(objProductDetailResultList.Where(a => a.TotalAssetsInStock > 0 || a.AssetsAssign > 0 || a.AssetsInRepair > 0 || a.ServiceInExpire > 0).ToList()); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IEnumerable <MasterCategoryResult> GetAllASMasterCategory() { try { var _data = (from MC in _Context.ASMasterCategories select new { MC.MasterCategoryId, MC.CategoryCode, MC.CategoryTitle, MC.MasterCategoryType, MC.MasterCategoryDescription, MC.CategoryImage, MC.Sequence, MC.IsActive, MC.EnterById, MC.EnterDate, MC.ModifiedById, MC.ModifiedDate, }); var _Productdata = (from MC in _Context.ASMasterCategories join MSC in _Context.ASMasterSubCategories on MC.MasterCategoryId equals MSC.MasterCategoryId join MP in _Context.ASMasterProducts on MSC.MasterSubCategoryId equals MP.MasterSubCategoryId into MPGroup from MP in MPGroup.DefaultIfEmpty() join MPC in _Context.ASMasterProductChilds on MP.MasterProductId equals MPC.MasterProductId into MPCGroup from MPC in MPCGroup.DefaultIfEmpty() select new { MC.MasterCategoryId, MC.CategoryTitle, MSC.MasterSubCategoryId, MSC.SubCategoryTitle, MPC.ProductChildTitle, MPC.ProductChildSKU, MPC.ManufacturerPartNumber, MPC.PurchasePrice, MPC.DepreciatePrice, MPC.IsActive, MPC.IsDeadAssets, MPC.IsSaleProduct, MPC.MasterBranchId, MPC.MasterEmployeeId, MPC.WarrantyExpiryDate }); List <MasterCategoryResult> objMasterCategoryResulttList = new List <MasterCategoryResult>(); foreach (var _Item in _data.ToList()) { var _MasterCategoryResult = new MasterCategoryResult(); _MasterCategoryResult.MasterCategoryId = _Item.MasterCategoryId; _MasterCategoryResult.CategoryCode = _Item.CategoryCode; _MasterCategoryResult.CategoryTitle = _Item.CategoryTitle; _MasterCategoryResult.MasterCategoryType = _Item.MasterCategoryType; _MasterCategoryResult.MasterCategoryDescription = _Item.MasterCategoryDescription; _MasterCategoryResult.CategoryImage = _Item.CategoryImage; _MasterCategoryResult.Sequence = _Item.Sequence; _MasterCategoryResult.IsActive = _Item.IsActive; _MasterCategoryResult.EnterById = _Item.EnterById; _MasterCategoryResult.EnterDate = _Item.EnterDate; _MasterCategoryResult.ModifiedById = _Item.ModifiedById; _MasterCategoryResult.ModifiedDate = _Item.ModifiedDate; _MasterCategoryResult.TotalAssetsInStock = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterCategoryResult.AssetsAssign = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false && (a.MasterEmployeeId != 0)).Count()); _MasterCategoryResult.AssetsInRepair = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterCategoryResult.ServiceInExpire = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.WarrantyExpiryDate <= DateTime.Now && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterCategoryResult.AssetsInSold = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == true).Count()); _MasterCategoryResult.AssetsInDead = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.WarrantyExpiryDate <= DateTime.Now && a.IsActive == true && a.IsDeadAssets == true && a.IsSaleProduct == false).Count()); _MasterCategoryResult.TotalAssetsCost = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.IsDeadAssets == false && a.IsSaleProduct == false).Sum(a => a.PurchasePrice) ?? 0); _MasterCategoryResult.TotalAssetsDepreciatedValue = (_Productdata.Where(a => a.MasterCategoryId == _Item.MasterCategoryId && a.IsDeadAssets == false && a.IsSaleProduct == false).Sum(a => a.DepreciatePrice) ?? 0); objMasterCategoryResulttList.Add(_MasterCategoryResult); } return(objMasterCategoryResulttList); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IEnumerable <MasterProductResult> GetASMasterProductByID(long MasterCategoryId, long MasterSubCategoryId, long MasterBrandId) { try { //Get Parent Product data as per MasterCategoryId Or MasterSubCategoryId Or MasterBranchId var _data = (from MP in _Context.ASMasterProducts join MB in _Context.ASMasterBrands on MP.MasterBrandId equals MB.MasterBrandId into MBGroup from MB in MBGroup.DefaultIfEmpty() join SC in _Context.ASMasterSubCategories on MP.MasterSubCategoryId equals SC.MasterSubCategoryId into SCGroup from SC in SCGroup.DefaultIfEmpty() join CA in _Context.ASMasterCategories on SC.MasterCategoryId equals CA.MasterCategoryId into CAGroup from CA in CAGroup.DefaultIfEmpty() where (MasterCategoryId > 0 && MasterSubCategoryId == 0 && MasterBrandId == 0 && SC.MasterCategoryId == MasterCategoryId) || (MasterCategoryId == 0 && MasterSubCategoryId > 0 && MasterBrandId == 0 && MP.MasterSubCategoryId == MasterSubCategoryId) || (MasterCategoryId == 0 && MasterSubCategoryId == 0 && MasterBrandId > 0 && MP.MasterBrandId == MasterBrandId) select new { MP.MasterProductId, MP.ProductTitle, MP.ProductSKU, MP.ProductHSNCode, MP.ProductBarCode, MP.ProductMainImage, MP.Description, MP.Specification, MP.LegalDisclamer, MP.SafetyWarning, MP.ProductModel, MP.Manufacturer, MP.DepreciatePercentage, MP.ReorderLevel, MP.CountryOfOrigin, //CO.CountryTitle, MP.ProductTaxCode, //MT.TaxTitle, //MT.IsTaxPercentageAmount, //MT.TaxValue, MP.ProductCurrency, //MC.CurrencyTitle, MP.Sequence, MP.IsActive, MP.EnterById, MP.EnterDate, MP.ModifiedById, MP.ModifiedDate, MP.MasterBrandId, MB.BrandTitle, MP.MasterSubCategoryId, SC.SubCategoryTitle, CA.CategoryTitle, CA.MasterCategoryId }); var _AdminCountries = _AdminContext.ADMasterCountries.ToList(); var _AdminTaxes = _AdminContext.ADMasterTaxes.ToList(); var _AdminCurrencies = _AdminContext.ADMasterCurrencies.ToList(); var _AdminBranches = _AdminContext.ADMasterBranches.ToList(); var _AdminEmployees = _AdminContext.ADMasterEmployees.ToList(); var _AdminVendors = _AdminContext.ADMasterVendors.ToList(); //Get Child Product data as per MasterCategoryId Or MasterSubCategoryId Or MasterBranchId var _Productdata = (from MC in _Context.ASMasterCategories join MSC in _Context.ASMasterSubCategories on MC.MasterCategoryId equals MSC.MasterCategoryId join MP in _Context.ASMasterProducts on MSC.MasterSubCategoryId equals MP.MasterSubCategoryId into MPGroup from MP in MPGroup.DefaultIfEmpty() join MPC in _Context.ASMasterProductChilds on MP.MasterProductId equals MPC.MasterProductId into MPCGroup from MPC in MPCGroup.DefaultIfEmpty() where (MasterCategoryId > 0 && MasterSubCategoryId == 0 && MasterBrandId == 0 && MSC.MasterCategoryId == MasterCategoryId) || (MasterCategoryId == 0 && MasterSubCategoryId > 0 && MasterBrandId == 0 && MP.MasterSubCategoryId == MasterSubCategoryId) || (MasterCategoryId == 0 && MasterSubCategoryId == 0 && MasterBrandId > 0 && MP.MasterBrandId == MasterBrandId) select new { MC.MasterCategoryId, MC.CategoryTitle, MSC.MasterSubCategoryId, MSC.SubCategoryTitle, MPC.MasterProductId, MPC.ProductChildTitle, MPC.ProductChildSKU, MPC.ManufacturerPartNumber, MPC.PurchasePrice, MPC.DepreciatePrice, MPC.IsActive, MPC.IsDeadAssets, MPC.IsSaleProduct, MPC.MasterBranchId, MPC.MasterEmployeeId, MPC.WarrantyExpiryDate }); //insert search data in model List<MasterProductResult> object with parent and child List <MasterProductResult> objMasterProductResultList = new List <MasterProductResult>(); foreach (var _Item in _data.ToList()) { MasterProductResult _MasterProductResult = new MasterProductResult(); _MasterProductResult.MasterProductId = _Item.MasterProductId; _MasterProductResult.ProductTitle = _Item.ProductTitle; _MasterProductResult.MasterBrandId = _Item.MasterBrandId; _MasterProductResult.BrandTitle = _Item.BrandTitle; _MasterProductResult.MasterSubCategoryId = _Item.MasterSubCategoryId; _MasterProductResult.SubCategoryTitle = _Item.SubCategoryTitle; _MasterProductResult.MasterCategoryId = _Item.MasterCategoryId; _MasterProductResult.CategoryTitle = _Item.CategoryTitle; _MasterProductResult.ProductSKU = _Item.ProductSKU; _MasterProductResult.ProductHSNCode = _Item.ProductHSNCode; _MasterProductResult.ProductBarCode = _Item.ProductBarCode; _MasterProductResult.ProductMainImage = _Item.ProductMainImage; _MasterProductResult.Description = _Item.Description; _MasterProductResult.Specification = _Item.Specification; _MasterProductResult.LegalDisclamer = _Item.LegalDisclamer; _MasterProductResult.SafetyWarning = _Item.SafetyWarning; _MasterProductResult.ProductModel = _Item.ProductModel; _MasterProductResult.Manufacturer = _Item.Manufacturer; _MasterProductResult.DepreciatePercentage = _Item.DepreciatePercentage; _MasterProductResult.ReorderLevel = _Item.ReorderLevel; _MasterProductResult.CountryOfOrigin = _Item.CountryOfOrigin; _MasterProductResult.CountryOfOriginTitle = _AdminCountries.Where(a => a.MasterCountryId == _Item.CountryOfOrigin).Select(a => a.CountryTitle).FirstOrDefault(); _MasterProductResult.ProductTaxCode = _Item.ProductTaxCode; _MasterProductResult.ProductTaxCodeTitle = _AdminTaxes.Where(a => a.MasterTaxId == _Item.ProductTaxCode).Select(a => a.TaxTitle).FirstOrDefault(); _MasterProductResult.ProductCurrency = _Item.ProductCurrency; _MasterProductResult.ProductCurrencyTitle = _AdminCurrencies.Where(a => a.MasterCurrencyId == _Item.ProductCurrency).Select(a => a.CurrencyTitle).FirstOrDefault();; _MasterProductResult.TotalAssetsInStock = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterProductResult.AssetsAssign = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false && (a.MasterEmployeeId != 0)).Count()); _MasterProductResult.AssetsInRepair = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterProductResult.ServiceInExpire = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.WarrantyExpiryDate <= DateTime.Now && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterProductResult.AssetsInSold = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == true).Count()); _MasterProductResult.AssetsInDead = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == false && a.IsDeadAssets == true && a.IsSaleProduct == false).Count()); _MasterProductResult.TotalAssetsCost = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsDeadAssets == false && a.IsSaleProduct == false).Sum(a => a.PurchasePrice) ?? 0); _MasterProductResult.TotalAssetsDepreciatedValue = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsDeadAssets == false && a.IsSaleProduct == false).Sum(a => a.DepreciatePrice) ?? 0); _MasterProductResult.Sequence = _Item.Sequence; _MasterProductResult.IsActive = _Item.IsActive; _MasterProductResult.EnterById = _Item.EnterById; _MasterProductResult.EnterDate = _Item.EnterDate; _MasterProductResult.ModifiedById = _Item.ModifiedById; _MasterProductResult.ModifiedDate = _Item.ModifiedDate; _MasterProductResult.MaxProductSKU = _Context.ASMasterProductChilds.Where(a => a.MasterProductId == _Item.MasterProductId).Max(a => a.ProductChildSKU); objMasterProductResultList.Add(_MasterProductResult); var _dataChild = (from MPC in _Context.ASMasterProductChilds join MAA in _Context.ASMasterAssetsAssignments on MPC.MasterProductChildId equals MAA.MasterProductChildId into MAAGroup from MAA in MAAGroup.DefaultIfEmpty() where MPC.MasterProductId == _Item.MasterProductId select new { MPC.MasterProductChildId, MPC.MasterProductId, MPC.ProductChildSKU, MPC.ManufacturerPartNumber, MPC.PurchaseDate, MPC.PurchasePrice, MPC.DepreciatePrice, MPC.WarrantyExpiryDate, MPC.WarrantyStartDate, MPC.IterationOfWarranty, MPC.MasterBranchId, MPC.MasterEmployeeId, MPC.MasterVendorId, MPC.IsDeadAssets, MPC.IsSaleProduct, MPC.IsActive, MasterAssetsAssignmentId = (MAA.MasterAssetsAssignmentId != null ? MAA.MasterAssetsAssignmentId : 0), MAA.AssetsAssignmentDate, MAA.IsAssetsDeAssign }); ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// List <MasterProductAssignChildResult> objMasterProductAssignChildResultList = new List <MasterProductAssignChildResult>(); foreach (var _ItemChild in _dataChild.ToList()) { MasterProductAssignChildResult _MasterProductAssignChildResult = new MasterProductAssignChildResult(); _MasterProductAssignChildResult.MasterProductChildId = _ItemChild.MasterProductChildId; _MasterProductAssignChildResult.MasterProductId = _ItemChild.MasterProductId; _MasterProductAssignChildResult.ProductChildSKU = _ItemChild.ProductChildSKU; _MasterProductAssignChildResult.ManufacturerPartNumber = _ItemChild.ManufacturerPartNumber; _MasterProductAssignChildResult.PurchaseDate = _ItemChild.PurchaseDate; _MasterProductAssignChildResult.PurchasePrice = _ItemChild.PurchasePrice; _MasterProductAssignChildResult.DepreciatePrice = _ItemChild.DepreciatePrice; _MasterProductAssignChildResult.WarrantyExpiryDate = _ItemChild.WarrantyExpiryDate; _MasterProductAssignChildResult.WarrantyStartDate = _ItemChild.WarrantyStartDate; _MasterProductAssignChildResult.IterationOfWarranty = _ItemChild.IterationOfWarranty; _MasterProductAssignChildResult.IsActive = _ItemChild.IsActive; _MasterProductAssignChildResult.IsDeadAssets = _ItemChild.IsDeadAssets; _MasterProductAssignChildResult.IsSaleProduct = _ItemChild.IsSaleProduct; _MasterProductAssignChildResult.MasterBranchId = _ItemChild.MasterBranchId; _MasterProductAssignChildResult.BranchTitle = _AdminBranches.Where(a => a.MasterBranchId == _ItemChild.MasterBranchId).Select(a => a.BranchTitle).FirstOrDefault(); _MasterProductAssignChildResult.MasterEmployeeId = _ItemChild.MasterEmployeeId; _MasterProductAssignChildResult.EmployeeName = _AdminEmployees.Where(a => a.MasterEmployeeId == _ItemChild.MasterEmployeeId).Select(a => a.EmployeeName).FirstOrDefault(); _MasterProductAssignChildResult.MasterAssetsAssignmentId = _ItemChild.MasterAssetsAssignmentId; _MasterProductAssignChildResult.AssetsAssignmentDate = _ItemChild.AssetsAssignmentDate; _MasterProductAssignChildResult.MasterVendorId = _ItemChild.MasterVendorId; _MasterProductAssignChildResult.VendorTitle = _AdminVendors.Where(a => a.MasterVendorId == _ItemChild.MasterVendorId).Select(a => a.VendorTitle).FirstOrDefault();; _MasterProductAssignChildResult.IsAssetsDeAssign = _ItemChild.IsAssetsDeAssign; objMasterProductAssignChildResultList.Add(_MasterProductAssignChildResult); } _MasterProductResult.ProductAssignChildList = objMasterProductAssignChildResultList; } return(objMasterProductResultList); } catch (Exception ex) { throw new Exception(ex.Message); } }
public IEnumerable <MasterProductResult> GetAllASMasterProduct() { try { var _data = (from MP in _Context.ASMasterProducts join MB in _Context.ASMasterBrands on MP.MasterBrandId equals MB.MasterBrandId into MBGroup from MB in MBGroup.DefaultIfEmpty() join SC in _Context.ASMasterSubCategories on MP.MasterSubCategoryId equals SC.MasterSubCategoryId into SCGroup from SC in SCGroup.DefaultIfEmpty() join CA in _Context.ASMasterCategories on SC.MasterCategoryId equals CA.MasterCategoryId into CAGroup from CA in CAGroup.DefaultIfEmpty() select new { MP.MasterProductId, MP.ProductTitle, MP.ProductSKU, MP.ProductHSNCode, MP.ProductBarCode, MP.ProductMainImage, MP.Description, MP.Specification, MP.LegalDisclamer, MP.SafetyWarning, MP.ProductModel, MP.Manufacturer, MP.DepreciatePercentage, MP.ReorderLevel, MP.CountryOfOrigin, //CO.CountryTitle, MP.ProductTaxCode, //MT.TaxTitle, //MT.IsTaxPercentageAmount, //MT.TaxValue, MP.ProductCurrency, //MC.CurrencyTitle, MP.Sequence, MP.IsActive, MP.EnterById, MP.EnterDate, MP.ModifiedById, MP.ModifiedDate, MP.MasterBrandId, MB.BrandTitle, MP.MasterSubCategoryId, SC.SubCategoryTitle, CA.CategoryTitle, CA.MasterCategoryId //TotalAssets = 2, //AssetsAllocated = 1 }).ToList(); var _Productdata = (from MC in _Context.ASMasterCategories join MSC in _Context.ASMasterSubCategories on MC.MasterCategoryId equals MSC.MasterCategoryId join MP in _Context.ASMasterProducts on MSC.MasterSubCategoryId equals MP.MasterSubCategoryId into MPGroup from MP in MPGroup.DefaultIfEmpty() join MPC in _Context.ASMasterProductChilds on MP.MasterProductId equals MPC.MasterProductId into MPCGroup from MPC in MPCGroup.DefaultIfEmpty() select new { MC.MasterCategoryId, MC.CategoryTitle, MSC.MasterSubCategoryId, MSC.SubCategoryTitle, MPC.MasterProductId, MPC.ProductChildTitle, MPC.ProductChildSKU, MPC.ManufacturerPartNumber, MPC.PurchasePrice, MPC.DepreciatePrice, MPC.IsActive, MPC.IsDeadAssets, MPC.IsSaleProduct, MPC.MasterBranchId, MPC.MasterEmployeeId, MPC.WarrantyExpiryDate }); var _AdminCountries = _AdminContext.ADMasterCountries.ToList(); var _AdminTaxes = _AdminContext.ADMasterTaxes.ToList(); var _AdminCurrencies = _AdminContext.ADMasterCurrencies.ToList(); List <MasterProductResult> objMasterProductResultList = new List <MasterProductResult>(); foreach (var _Item in _data.ToList()) { var _MasterProductResult = new MasterProductResult(); _MasterProductResult.MasterProductId = _Item.MasterProductId; _MasterProductResult.ProductTitle = _Item.ProductTitle; _MasterProductResult.MasterBrandId = _Item.MasterBrandId; _MasterProductResult.BrandTitle = _Item.BrandTitle; _MasterProductResult.MasterSubCategoryId = _Item.MasterSubCategoryId; _MasterProductResult.SubCategoryTitle = _Item.SubCategoryTitle; _MasterProductResult.MasterCategoryId = _Item.MasterCategoryId; _MasterProductResult.CategoryTitle = _Item.CategoryTitle; _MasterProductResult.ProductSKU = _Item.ProductSKU; _MasterProductResult.ProductHSNCode = _Item.ProductHSNCode; _MasterProductResult.ProductBarCode = _Item.ProductBarCode; _MasterProductResult.ProductMainImage = _Item.ProductMainImage; _MasterProductResult.Description = _Item.Description; _MasterProductResult.Specification = _Item.Specification; _MasterProductResult.LegalDisclamer = _Item.LegalDisclamer; _MasterProductResult.SafetyWarning = _Item.SafetyWarning; _MasterProductResult.ProductModel = _Item.ProductModel; _MasterProductResult.Manufacturer = _Item.Manufacturer; _MasterProductResult.DepreciatePercentage = _Item.DepreciatePercentage; _MasterProductResult.ReorderLevel = _Item.ReorderLevel; _MasterProductResult.CountryOfOrigin = _Item.CountryOfOrigin; _MasterProductResult.CountryOfOriginTitle = _AdminCountries.Where(a => a.MasterCountryId == _Item.CountryOfOrigin).Select(a => a.CountryTitle).FirstOrDefault(); _MasterProductResult.ProductTaxCode = _Item.ProductTaxCode; _MasterProductResult.ProductTaxCodeTitle = _AdminTaxes.Where(a => a.MasterTaxId == _Item.ProductTaxCode).Select(a => a.TaxTitle).FirstOrDefault(); _MasterProductResult.ProductCurrency = _Item.ProductCurrency; _MasterProductResult.ProductCurrencyTitle = _AdminCurrencies.Where(a => a.MasterCurrencyId == _Item.ProductCurrency).Select(a => a.CurrencyTitle).FirstOrDefault();; _MasterProductResult.Sequence = _Item.Sequence; _MasterProductResult.TotalAssetsInStock = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterProductResult.AssetsAssign = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false && (a.MasterEmployeeId != 0)).Count()); _MasterProductResult.AssetsInRepair = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterProductResult.ServiceInExpire = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.WarrantyExpiryDate <= DateTime.Now && a.IsActive == true && a.IsDeadAssets == false && a.IsSaleProduct == false).Count()); _MasterProductResult.AssetsInSold = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == false && a.IsDeadAssets == false && a.IsSaleProduct == true).Count()); _MasterProductResult.AssetsInDead = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsActive == false && a.IsDeadAssets == true && a.IsSaleProduct == false).Count()); _MasterProductResult.TotalAssetsCost = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsDeadAssets == false && a.IsSaleProduct == false).Sum(a => a.PurchasePrice) ?? 0); _MasterProductResult.TotalAssetsDepreciatedValue = (_Productdata.Where(a => a.MasterProductId == _Item.MasterProductId && a.IsDeadAssets == false && a.IsSaleProduct == false).Sum(a => a.DepreciatePrice) ?? 0); _MasterProductResult.IsActive = _Item.IsActive; _MasterProductResult.EnterById = _Item.EnterById; _MasterProductResult.EnterDate = _Item.EnterDate; _MasterProductResult.ModifiedById = _Item.ModifiedById; _MasterProductResult.ModifiedDate = _Item.ModifiedDate; objMasterProductResultList.Add(_MasterProductResult); } return(objMasterProductResultList.ToList()); } catch (Exception ex) { throw new Exception(ex.Message); } }