public int ImportData(List <Asset> lsAsset) { List <EavAttributeValue> lsLocation = new List <EavAttributeValue>(); List <EavAttributeValue> lsCategory = new List <EavAttributeValue>(); foreach (Asset item in lsAsset) { item.AssetId = this.GenerateAssetID(); item.CreatedAt = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); item.UpdatedAt = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); if (string.IsNullOrEmpty(item.AssetCode)) { item.AssetCode = item.AssetId; } if (item.CategoryID != null) { EavAttributeValue cate = new EavAttributeValue(); cate.Guid = Guid.NewGuid().ToString().ToUpper(); cate.CategoryId = item.AssetId; cate.EavId = item.CategoryID; cate.AttributeGroup = EnumEAV.EAV_Type.AssetCategory.ToString(); lsCategory.Add(cate); } if (item.LocationID != null) { EavAttributeValue cate = new EavAttributeValue(); cate.Guid = Guid.NewGuid().ToString().ToUpper(); cate.CategoryId = item.AssetId; cate.EavId = item.LocationID; cate.AttributeGroup = EnumEAV.EAV_Type.AssetLocation.ToString(); lsLocation.Add(cate); } } context.Asset.AddRange(lsAsset); context.EavAttributeValue.AddRange(lsLocation); context.EavAttributeValue.AddRange(lsCategory); return(context.SaveChanges()); }
public async Task <int> Add(ViewAsset viewAsset, IFormFileCollection formFileCollection) { DaoAssign daoAssign = new DaoAssign(context); DaoDeptAsset daoDeptAsset = new DaoDeptAsset(context); Asset asset = new Asset(); Assign assign = new Assign(); DeptAsset deptAsset = new DeptAsset(); asset = viewAsset.asset; assign = viewAsset.assign; deptAsset = viewAsset.DeptAsset; List <EavAttributeValue> lsAttributeValue = new List <EavAttributeValue>(); lsAttributeValue = viewAsset.EavAttributeValue; asset.AssetId = this.GenerateAssetID(); if (string.IsNullOrEmpty(asset.AssetCode)) { asset.AssetCode = asset.AssetId; } var checkCode = this.CheckUniqueAssetCode(asset.AssetCode, asset.AssetId); if (checkCode) { asset.CreatedAt = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); asset.UpdatedAt = DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"); context.Asset.Add(asset); if (asset.CategoryID != null) { EavAttributeValue cate = new EavAttributeValue(); cate.Guid = Guid.NewGuid().ToString().ToUpper(); cate.CategoryId = asset.AssetId; cate.EavId = asset.CategoryID; cate.AttributeGroup = EnumEAV.EAV_Type.AssetCategory.ToString(); context.EavAttributeValue.Add(cate); } if (asset.LocationID != null) { EavAttributeValue cate = new EavAttributeValue(); cate.Guid = Guid.NewGuid().ToString().ToUpper(); cate.CategoryId = asset.AssetId; cate.EavId = asset.LocationID; cate.AttributeGroup = EnumEAV.EAV_Type.AssetLocation.ToString(); context.EavAttributeValue.Add(cate); } if (assign != null && !string.IsNullOrEmpty(assign.ReceiverBy)) { assign.AssetId = asset.AssetId; daoAssign.AssignAsset(assign); } if (deptAsset != null && !string.IsNullOrEmpty(deptAsset.DeptId)) { deptAsset.AssetId = asset.AssetId; daoDeptAsset.Add(deptAsset); } if (lsAttributeValue != null) { foreach (EavAttributeValue item in lsAttributeValue) { item.Guid = Guid.NewGuid().ToString().ToUpper(); item.CategoryId = asset.AssetId; item.AttributeGroup = EnumEAV.EAV_Type.AssetAttribute.ToString(); context.EavAttributeValue.Add(item); } } List <Image> lsAssetImage = new List <Image>(); lsAssetImage = new Function().DangTaiHinhAnh(formFileCollection, asset.AssetId); context.Image.AddRange(lsAssetImage); } return(await context.SaveChangesAsync()); }