public async Task CloneGlueByCloneDto(CloneDto clone, BPFCEstablish bpfc, BPFCEstablish bpfcClone)
{
var gluesData = new List <Glue>();
if (bpfcClone.Glues == null)
{
gluesData = bpfc.Glues.Where(x => x.isShow == true).ToList();
}
else
{
var list2 = bpfcClone.Glues.Where(x => x.isShow == true).Select(x => x.Name);
var list1 = bpfc.Glues.Where(x => x.isShow == true).Select(x => x.Name);
var check = list1.Except(list2);
gluesData = bpfc.Glues.Where(x => x.isShow == true && check.Contains(x.Name)).ToList();
}
if (gluesData.Count == 0)
{
return;
}
foreach (var item in gluesData)
{
var glue = new Glue();
glue.Code = await this.GenatateGlueCode(item.Code);
glue.Name = item.Name;
glue.isShow = true;
glue.Consumption = item.Consumption;
glue.CreatedBy = clone.CloneBy;
glue.MaterialID = item.MaterialID;
glue.KindID = item.KindID;
glue.PartID = item.PartID;
glue.ExpiredTime = item.ExpiredTime;
glue.BPFCEstablishID = bpfcClone.ID;
_repoGlue.Add(glue);
await _repoGlue.SaveAll();
var glueIngredients = item.GlueIngredients.ToList();
var glueIngredientData = glueIngredients.Select(x => new GlueIngredient
{
GlueID = glue.ID,
IngredientID = x.IngredientID,
Allow = x.Allow,
Percentage = x.Percentage,
CreatedDate = DateTime.Now.ToString("MMMM dd, yyyy HH:mm:ss tt"),
Position = x.Position,
}).ToList();
_repoGlueIngredient.AddRange(glueIngredientData);
await _repoGlueIngredient.SaveAll();
}
}
public async Task <BPFCEstablish> CreateNewBPFCByCloneDto(CloneDto clone, int artProcessID)
{
var bpfcData = new BPFCEstablish();
bpfcData.ModelNameID = clone.ModelNameID;
bpfcData.ModelNoID = clone.ModelNOID;
bpfcData.ArticleNoID = clone.ArticleNOID;
bpfcData.ArtProcessID = artProcessID;
bpfcData.ApprovalStatus = false;
bpfcData.FinishedStatus = false;
bpfcData.CreatedBy = clone.CloneBy;
bpfcData.ApprovalBy = 0;
bpfcData.CreatedBy = clone.CloneBy;
bpfcData.UpdateTime = DateTime.Now;
bpfcData.BuildingDate = DateTime.Now;
bpfcData.CreatedDate = DateTime.Now;
_repoBPFC.Add(bpfcData);
await _repoBPFC.SaveAll();
return(bpfcData);
}
public async Task <object> CloneModelName(CloneDto clone)
{
try
{
using (var scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
}, TransactionScopeAsyncFlowOption.Enabled))
{
var bpfc = await _repoBPFC.FindAll()
.Include(x => x.ModelName)
.Include(x => x.ModelNo)
.Include(x => x.ArtProcess)
.Include(x => x.ArticleNo)
.Include(x => x.Glues).ThenInclude(x => x.GlueIngredients)
.Include(x => x.Plans)
.FirstOrDefaultAsync(x => x.ID == clone.BPFCID);
var artProcessFirstAdd = _repoArtProcess.FindAll().FirstOrDefaultAsync(x => x.ArticleNoID == bpfc.ArticleNoID && x.ProcessID == clone.ArtProcessID);
if (bpfc == null)
{
return new
{
message = "The BPFC is invalid!",
status = false
}
}
;
if (artProcessFirstAdd.Result != null)
{
if (clone.ArtProcessID == artProcessFirstAdd.Result.ProcessID)
{
clone.ArtProcessID = artProcessFirstAdd.Result.ArticleNoID;
await CheckExistBPFC(clone);
return(new
{
message = "The BPFC exists!",
status = false
});
}
}
var artProcessData = new ArtProcess();
artProcessData.ArticleNoID = clone.ArticleNOID;
artProcessData.ProcessID = clone.ArtProcessID;
_repoArtProcess.Add(artProcessData);
await _repoArtProcess.SaveAll();
var artProcessLastAdd = _repoArtProcess.FindAll().FirstOrDefaultAsync(x => x.ArticleNoID == bpfc.ArticleNoID && x.ProcessID == clone.ArtProcessID);
var bpfcData = new BPFCEstablish();
bpfcData.ModelNameID = clone.ModelNameID;
bpfcData.ModelNoID = clone.ModelNOID;
bpfcData.ArticleNoID = clone.ArticleNOID;
bpfcData.ArtProcessID = artProcessLastAdd.Result.ID;
bpfcData.ApprovalStatus = false;
bpfcData.FinishedStatus = false;
bpfcData.CreatedBy = clone.CloneBy;
bpfcData.ApprovalBy = 0;
bpfcData.CreatedBy = clone.CloneBy;
bpfcData.UpdateTime = DateTime.Now;
bpfcData.BuildingDate = DateTime.Now;
bpfcData.CreatedDate = DateTime.Now;
_repoBPFC.Add(bpfcData);
await _repoBPFC.SaveAll();
var gluesData = bpfc.Glues.ToList();
foreach (var item in gluesData)
{
var glue = new Glue();
glue.Code = await this.GenatateGlueCode(item.Code);
glue.Name = item.Name;
glue.Consumption = item.Consumption;
glue.CreatedBy = clone.CloneBy;
glue.MaterialID = item.MaterialID;
glue.KindID = item.KindID;
glue.PartID = item.PartID;
glue.ExpiredTime = item.ExpiredTime;
glue.BPFCEstablishID = bpfcData.ID;
_repoGlue.Add(glue);
await _repoGlue.SaveAll();
var glueIngredients = item.GlueIngredients.ToList();
var glueIngredientData = glueIngredients.Select(x => new GlueIngredient
{
GlueID = glue.ID,
IngredientID = x.IngredientID,
Allow = x.Allow,
Percentage = x.Percentage,
CreatedDate = DateTime.Now.ToString("MMMM dd, yyyy HH:mm:ss tt"),
Position = x.Position,
}).ToList();
_repoGlueIngredient.AddRange(glueIngredientData);
await _repoGlueIngredient.SaveAll();
}
scope.Complete();
}
return(new
{
message = "The BPFC has been cloned!",
status = true
});
}
catch (Exception ex)
{
Console.WriteLine("Loi clone model name", ex);
return(new
{
message = "",
status = false
});
}
}
public async Task ImportExcel(List <BPFCEstablishDtoForImportExcel> bPFCEstablishDtos)
{
try
{
var list = new List <BPFCEstablishDto>();
var listChuaAdd = new List <BPFCEstablishDto>();
var listAddBiLoi = new List <BPFCEstablishDto>();
var result = bPFCEstablishDtos.DistinctBy(x => new
{
x.ModelName,
x.ModelNo,
x.ArticleNo,
x.Process
}).ToList();
foreach (var item in result)
{
var bpfc = await AddBPFC(item);
list.Add(bpfc);
}
var listAdd = new List <BPFCEstablish>();
foreach (var bpfc in list)
{
if (!await CheckExistBPFC(bpfc))
{
var bp = new BPFCEstablish();
bp.ModelNameID = bpfc.ModelNameID;
bp.ModelNoID = bpfc.ModelNoID;
bp.ArticleNoID = bpfc.ArticleNoID;
bp.ArtProcessID = bpfc.ArtProcessID;
bp.CreatedBy = bpfc.CreatedBy;
bp.ApprovalBy = bpfc.ApprovalBy;
bp.CreatedDate = DateTime.Now;
bp.UpdateTime = DateTime.Now;
bp.ApprovalStatus = bpfc.ApprovalStatus;
bp.FinishedStatus = bpfc.FinishedStatus;
bp.Season = bpfc.Season;
bp.ModelName = null;
bp.ModelNo = null;
bp.ArticleNo = null;
bp.ArtProcess = null;
bp.Glues = null;
bp.Plans = null;
_repoBPFCEstablish.Add(bp);
await _repoBPFCEstablish.SaveAll();
listAdd.Add(bp);
}
else
{
listChuaAdd.Add(bpfc);
}
}
var result1 = listAdd.Where(x => x.ID > 0).ToList();
var result2 = listAdd.Where(x => x.ID == 0).ToList();
}
catch
{
throw;
}
}
