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 MasterAssetsAssignmentResult GetASMasterAssetsAssignmentByID(long MasterAssetsAssignmentId)
{
try
{
var _data = (from MP in _Context.ASMasterProducts
//join CO in _AdminContext.ADMasterCountries on MP.CountryOfOrigin equals CO.MasterCountryId into COGroup
//from CO in COGroup.DefaultIfEmpty()
//join MT in _AdminContext.ADMasterTaxes on MP.ProductTaxCode equals MT.MasterTaxId into MTGroup
//from MT in MTGroup.DefaultIfEmpty()
//join MC in _AdminContext.ADMasterCurrencies on MP.ProductCurrency equals MC.MasterCurrencyId into MCGroup
//from MC in MCGroup.DefaultIfEmpty()
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()
join MPC in _Context.ASMasterProductChilds on MP.MasterProductId equals MPC.MasterProductId
join MAA in _Context.ASMasterAssetsAssignments on MPC.MasterProductChildId equals MAA.MasterProductChildId
where MAA.MasterAssetsAssignmentId == MasterAssetsAssignmentId
select new
{
MPC.MasterProductChildId,
MPC.MasterProductId,
MPC.ProductChildSKU,
MPC.ProductChildTitle,
MPC.ManufacturerPartNumber,
MPC.PurchaseDate,
MPC.PurchasePrice,
MPC.DepreciatePrice,
MPC.MasterVendorId,
MPC.IsDeadAssets,
MPC.IsTimeToSaleProduct,
MPC.IsSaleProduct,
MPC.SaleDate,
MPC.SalePrice,
MPC.ProductQty,
MPC.ProductQtyUnit,
MPC.NumberOfItemIncludeInProduct,
MPC.ItemPackageQuantity,
MPC.IterationOfWarranty,
MPC.WarrantyStartDate,
MPC.WarrantyExpiryDate,
MPC.MasterBranchId,
MP.ProductTitle,
MP.ProductSKU,
MP.MasterSubCategoryId,
SC.SubCategoryTitle,
MP.MasterBrandId,
MB.BrandTitle,
CA.MasterCategoryId,
CA.CategoryTitle,
MP.DepreciatePercentage,
MP.ReorderLevel,
MP.ProductModel,
MP.Manufacturer,
MAA.MasterAssetsAssignmentId,
MAA.AssetsAssignmentDate,
MAA.ASMasterProductChilds,
MAA.MasterEmployeeId,
MAA.IsAssetsDeAssign,
MAA.AssetsDeAssignmentDate,
MAA.DeAssignReason,
MAA.MasterLocationId,
MAA.Sequence,
MAA.IsActive,
MAA.EnterById,
MAA.EnterDate,
MAA.ModifiedById,
MAA.ModifiedDate,
});
var _Item = _data.FirstOrDefault();
MasterAssetsAssignmentResult _MasterAssetsAssignmentResult = new MasterAssetsAssignmentResult();
if (_data != null)
{
_MasterAssetsAssignmentResult.MasterAssetsAssignmentId = _Item.MasterAssetsAssignmentId;
_MasterAssetsAssignmentResult.AssetsAssignmentDate = _Item.AssetsAssignmentDate;
_MasterAssetsAssignmentResult.MasterEmployeeId = _Item.MasterEmployeeId;
_MasterAssetsAssignmentResult.IsAssetsDeAssign = _Item.IsAssetsDeAssign;
_MasterAssetsAssignmentResult.AssetsDeAssignmentDate = _Item.AssetsDeAssignmentDate;
_MasterAssetsAssignmentResult.DeAssignReason = _Item.DeAssignReason;
_MasterAssetsAssignmentResult.MasterLocationId = _Item.MasterLocationId;
_MasterAssetsAssignmentResult.Sequence = _Item.Sequence;
_MasterAssetsAssignmentResult.IsActive = _Item.IsActive;
_MasterAssetsAssignmentResult.ActiveColor = "green";
_MasterAssetsAssignmentResult.ActiveIcon = "glyphicon glyphicon-ok";
_MasterAssetsAssignmentResult.EnterById = _Item.EnterById;
_MasterAssetsAssignmentResult.EnterDate = _Item.EnterDate;
_MasterAssetsAssignmentResult.ModifiedById = _Item.ModifiedById;
_MasterAssetsAssignmentResult.ModifiedDate = _Item.ModifiedDate;
if (_MasterAssetsAssignmentResult.IsActive == false)
{
_MasterAssetsAssignmentResult.ActiveColor = "red";
_MasterAssetsAssignmentResult.ActiveIcon = "glyphicon glyphicon-remove";
}
_MasterAssetsAssignmentResult.MasterProductChildId = _Item.MasterProductChildId;
_MasterAssetsAssignmentResult.MasterProductId = _Item.MasterProductId;
//_MasterAssetsAssignmentResult.ASMasterProducts = _Item.ASMasterProducts;
_MasterAssetsAssignmentResult.ProductChildSKU = _Item.ProductChildSKU;
_MasterAssetsAssignmentResult.ProductChildTitle = _Item.ProductChildTitle;
_MasterAssetsAssignmentResult.ManufacturerPartNumber = _Item.ManufacturerPartNumber;
//_MasterAssetsAssignmentResult.ASMasterProductSizes = _Item.ASMasterProductSizes;
_MasterAssetsAssignmentResult.PurchaseDate = _Item.PurchaseDate;
_MasterAssetsAssignmentResult.PurchasePrice = _Item.PurchasePrice;
_MasterAssetsAssignmentResult.DepreciatePrice = _Item.DepreciatePrice;
_MasterAssetsAssignmentResult.MasterVendorId = _Item.MasterVendorId;
_MasterAssetsAssignmentResult.IsDeadAssets = _Item.IsDeadAssets;
_MasterAssetsAssignmentResult.IsTimeToSaleProduct = _Item.IsTimeToSaleProduct;
_MasterAssetsAssignmentResult.IsSaleProduct = _Item.IsSaleProduct;
_MasterAssetsAssignmentResult.SaleDate = _Item.SaleDate;
_MasterAssetsAssignmentResult.SalePrice = _Item.SalePrice;
_MasterAssetsAssignmentResult.ProductQty = _Item.ProductQty;
_MasterAssetsAssignmentResult.ProductQtyUnit = _Item.ProductQtyUnit;
_MasterAssetsAssignmentResult.NumberOfItemIncludeInProduct = _Item.NumberOfItemIncludeInProduct;
_MasterAssetsAssignmentResult.ItemPackageQuantity = _Item.ItemPackageQuantity;
_MasterAssetsAssignmentResult.IterationOfWarranty = _Item.IterationOfWarranty;
_MasterAssetsAssignmentResult.WarrantyStartDate = _Item.WarrantyStartDate;
_MasterAssetsAssignmentResult.WarrantyExpiryDate = _Item.WarrantyExpiryDate;
_MasterAssetsAssignmentResult.MasterBranchId = _Item.MasterBranchId;
_MasterAssetsAssignmentResult.MasterEmployeeId = _Item.MasterEmployeeId;
_MasterAssetsAssignmentResult.ProductTitle = _Item.ProductTitle;
_MasterAssetsAssignmentResult.MasterBrandId = _Item.MasterBrandId;
_MasterAssetsAssignmentResult.BrandTitle = _Item.BrandTitle;
_MasterAssetsAssignmentResult.MasterSubCategoryId = _Item.MasterSubCategoryId;
_MasterAssetsAssignmentResult.SubCategoryTitle = _Item.SubCategoryTitle;
_MasterAssetsAssignmentResult.MasterCategoryId = _Item.MasterCategoryId;
_MasterAssetsAssignmentResult.CategoryTitle = _Item.CategoryTitle;
_MasterAssetsAssignmentResult.ProductSKU = _Item.ProductSKU;
_MasterAssetsAssignmentResult.ProductModel = _Item.ProductModel;
_MasterAssetsAssignmentResult.Manufacturer = _Item.Manufacturer;
_MasterAssetsAssignmentResult.DepreciatePercentage = _Item.DepreciatePercentage;
_MasterAssetsAssignmentResult.ReorderLevel = _Item.ReorderLevel;
}
return(_MasterAssetsAssignmentResult);
}
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);
}
}
public IEnumerable <MasterAssetsAssignmentResult> GetAllASMasterAssetsAssignment(long MasterEmployeeId)
{
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()
join MPC in _Context.ASMasterProductChilds on MP.MasterProductId equals MPC.MasterProductId
join MAA in _Context.ASMasterAssetsAssignments on MPC.MasterProductChildId equals MAA.MasterProductChildId
where MAA.MasterEmployeeId == MasterEmployeeId
select new
{
MPC.MasterProductChildId,
MPC.MasterProductId,
MPC.ProductChildSKU,
MPC.ProductChildTitle,
MPC.ManufacturerPartNumber,
MPC.PurchaseDate,
MPC.PurchasePrice,
MPC.DepreciatePrice,
MPC.MasterVendorId,
MPC.IsDeadAssets,
MPC.IsTimeToSaleProduct,
MPC.IsSaleProduct,
MPC.SaleDate,
MPC.SalePrice,
MPC.ProductQty,
MPC.ProductQtyUnit,
MPC.NumberOfItemIncludeInProduct,
MPC.ItemPackageQuantity,
MPC.IterationOfWarranty,
MPC.WarrantyStartDate,
MPC.WarrantyExpiryDate,
MPC.MasterBranchId,
MP.ProductTitle,
MP.ProductSKU,
MP.MasterSubCategoryId,
SC.SubCategoryTitle,
MP.MasterBrandId,
MB.BrandTitle,
CA.MasterCategoryId,
CA.CategoryTitle,
MP.DepreciatePercentage,
MP.ReorderLevel,
MP.ProductModel,
MP.Manufacturer,
MAA.MasterAssetsAssignmentId,
MAA.AssetsAssignmentDate,
MAA.ASMasterProductChilds,
MAA.MasterEmployeeId,
MAA.IsAssetsDeAssign,
MAA.AssetsDeAssignmentDate,
MAA.DeAssignReason,
MAA.MasterLocationId,
MAA.Sequence,
MAA.IsActive,
MAA.EnterById,
MAA.EnterDate,
MAA.ModifiedById,
MAA.ModifiedDate,
});
List <MasterAssetsAssignmentResult> objMasterAssetsAssignmentResultList = new List <MasterAssetsAssignmentResult>();
foreach (var _Item in _data.ToList())
{
var _MasterAssetsAssignmentResult = new MasterAssetsAssignmentResult();
_MasterAssetsAssignmentResult.MasterAssetsAssignmentId = _Item.MasterAssetsAssignmentId;
_MasterAssetsAssignmentResult.AssetsAssignmentDate = _Item.AssetsAssignmentDate;
_MasterAssetsAssignmentResult.MasterEmployeeId = _Item.MasterEmployeeId;
_MasterAssetsAssignmentResult.IsAssetsDeAssign = _Item.IsAssetsDeAssign;
_MasterAssetsAssignmentResult.AssetsDeAssignmentDate = _Item.AssetsDeAssignmentDate;
_MasterAssetsAssignmentResult.DeAssignReason = _Item.DeAssignReason;
_MasterAssetsAssignmentResult.MasterLocationId = _Item.MasterLocationId;
_MasterAssetsAssignmentResult.Sequence = _Item.Sequence;
_MasterAssetsAssignmentResult.IsActive = _Item.IsActive;
_MasterAssetsAssignmentResult.ActiveColor = "green";
_MasterAssetsAssignmentResult.ActiveIcon = "glyphicon glyphicon-ok";
_MasterAssetsAssignmentResult.EnterById = _Item.EnterById;
_MasterAssetsAssignmentResult.EnterDate = _Item.EnterDate;
_MasterAssetsAssignmentResult.ModifiedById = _Item.ModifiedById;
_MasterAssetsAssignmentResult.ModifiedDate = _Item.ModifiedDate;
if (_MasterAssetsAssignmentResult.IsActive == false)
{
_MasterAssetsAssignmentResult.ActiveColor = "red";
_MasterAssetsAssignmentResult.ActiveIcon = "glyphicon glyphicon-remove";
}
_MasterAssetsAssignmentResult.MasterProductChildId = _Item.MasterProductChildId;
_MasterAssetsAssignmentResult.MasterProductId = _Item.MasterProductId;
//_MasterAssetsAssignmentResult.ASMasterProducts = _Item.ASMasterProducts;
_MasterAssetsAssignmentResult.ProductChildSKU = _Item.ProductChildSKU;
_MasterAssetsAssignmentResult.ProductChildTitle = _Item.ProductChildTitle;
_MasterAssetsAssignmentResult.ManufacturerPartNumber = _Item.ManufacturerPartNumber;
//_MasterAssetsAssignmentResult.ASMasterProductSizes = _Item.ASMasterProductSizes;
_MasterAssetsAssignmentResult.PurchaseDate = _Item.PurchaseDate;
_MasterAssetsAssignmentResult.PurchasePrice = _Item.PurchasePrice;
_MasterAssetsAssignmentResult.DepreciatePrice = _Item.DepreciatePrice;
_MasterAssetsAssignmentResult.MasterVendorId = _Item.MasterVendorId;
_MasterAssetsAssignmentResult.IsDeadAssets = _Item.IsDeadAssets;
_MasterAssetsAssignmentResult.IsTimeToSaleProduct = _Item.IsTimeToSaleProduct;
_MasterAssetsAssignmentResult.IsSaleProduct = _Item.IsSaleProduct;
_MasterAssetsAssignmentResult.SaleDate = _Item.SaleDate;
_MasterAssetsAssignmentResult.SalePrice = _Item.SalePrice;
_MasterAssetsAssignmentResult.ProductQty = _Item.ProductQty;
_MasterAssetsAssignmentResult.ProductQtyUnit = _Item.ProductQtyUnit;
_MasterAssetsAssignmentResult.NumberOfItemIncludeInProduct = _Item.NumberOfItemIncludeInProduct;
_MasterAssetsAssignmentResult.ItemPackageQuantity = _Item.ItemPackageQuantity;
_MasterAssetsAssignmentResult.IterationOfWarranty = _Item.IterationOfWarranty;
_MasterAssetsAssignmentResult.WarrantyStartDate = _Item.WarrantyStartDate;
_MasterAssetsAssignmentResult.WarrantyExpiryDate = _Item.WarrantyExpiryDate;
_MasterAssetsAssignmentResult.MasterBranchId = _Item.MasterBranchId;
_MasterAssetsAssignmentResult.MasterEmployeeId = _Item.MasterEmployeeId;
_MasterAssetsAssignmentResult.EmployeeName = "";
_MasterAssetsAssignmentResult.ProductTitle = _Item.ProductTitle;
_MasterAssetsAssignmentResult.MasterBrandId = _Item.MasterBrandId;
_MasterAssetsAssignmentResult.BrandTitle = _Item.BrandTitle;
_MasterAssetsAssignmentResult.MasterSubCategoryId = _Item.MasterSubCategoryId;
_MasterAssetsAssignmentResult.SubCategoryTitle = _Item.SubCategoryTitle;
_MasterAssetsAssignmentResult.MasterCategoryId = _Item.MasterCategoryId;
_MasterAssetsAssignmentResult.CategoryTitle = _Item.CategoryTitle;
_MasterAssetsAssignmentResult.ProductSKU = _Item.ProductSKU;
_MasterAssetsAssignmentResult.ProductModel = _Item.ProductModel;
_MasterAssetsAssignmentResult.Manufacturer = _Item.Manufacturer;
_MasterAssetsAssignmentResult.DepreciatePercentage = _Item.DepreciatePercentage;
_MasterAssetsAssignmentResult.ReorderLevel = _Item.ReorderLevel;
objMasterAssetsAssignmentResultList.Add(_MasterAssetsAssignmentResult);
}
return(objMasterAssetsAssignmentResultList);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}