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());
}
