public async Task <BPFCEstablish> FindBPFCByCloneDto(CloneDto clone, ArtProcess artProcess)
{
var bpfcForClone = 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.ModelNameID == clone.ModelNameID &&
x.ModelNoID == clone.ModelNOID &&
x.ArticleNoID == clone.ArticleNOID &&
x.ArtProcessID == artProcess.ID);
return(bpfcForClone);
}
public async Task <ArtProcess> FindArtProcessByCloneDto(CloneDto clone)
{
var artProcess = await _repoArtProcess.FindAll().FirstOrDefaultAsync(x => x.ArticleNoID == clone.ArticleNOID && x.ProcessID == clone.ArtProcessID);
if (artProcess != null)
{
return(artProcess);
}
else
{
var artProcessData = new ArtProcess();
artProcessData.ArticleNoID = clone.ArticleNOID;
artProcessData.ProcessID = clone.ArtProcessID;
_repoArtProcess.Add(artProcessData);
await _repoGlueIngredient.SaveAll();
return(artProcessData);
}
}
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
});
}
}
private async Task <BPFCEstablishDto> AddBPFC(BPFCEstablishDtoForImportExcel bPFCEstablishDto)
{
var result = new BPFCEstablishDto();
// make model name, model no, article no, process
using (var scope = new TransactionScope(TransactionScopeOption.Required,
new TransactionOptions {
IsolationLevel = IsolationLevel.ReadCommitted
}, TransactionScopeAsyncFlowOption.Enabled))
{
// make model name
var modelName = await _repoModelName.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(bPFCEstablishDto.ModelName.ToUpper()));
if (modelName != null)
{
result.ModelNameID = modelName.ID;
}
else
{
var modelNameModel = new ModelName {
Name = bPFCEstablishDto.ModelName
};
_repoModelName.Add(modelNameModel);
await _repoModelNo.SaveAll();
result.ModelNameID = modelNameModel.ID;
}
// end make model no
// Make model no
var modelNo = await _repoModelNo.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(bPFCEstablishDto.ModelNo.ToUpper()) && x.ModelNameID == result.ModelNameID);
if (modelNo != null)
{
result.ModelNoID = modelNo.ID;
}
else
{
var modelNoModel = new ModelNo {
Name = bPFCEstablishDto.ModelNo, ModelNameID = result.ModelNameID
};
_repoModelNo.Add(modelNoModel);
await _repoModelNo.SaveAll();
result.ModelNoID = modelNoModel.ID;
}
// end make model NO
// end make articleNO
var artNo = await _repoArticleNo.FindAll().FirstOrDefaultAsync(x => x.Name.ToUpper().Equals(bPFCEstablishDto.ArticleNo.ToUpper()) && x.ModelNoID == result.ModelNoID);
if (artNo != null)
{
result.ArticleNoID = artNo.ID;
}
else
{
// make art no
var articleNoModel = new ArticleNo {
Name = bPFCEstablishDto.ArticleNo, ModelNoID = result.ModelNoID
};
_repoArticleNo.Add(articleNoModel);
await _repoArticleNo.SaveAll();
result.ArticleNoID = articleNoModel.ID;
}
// end articleNO
// make Art Process
var artProcess = await _repoArtProcess.FindAll().FirstOrDefaultAsync(x => x.ProcessID.Equals(bPFCEstablishDto.Process.ToUpper() == "STF" ? 2 : 1) && x.ArticleNoID == result.ArticleNoID);
if (artProcess != null)
{
result.ArtProcessID = artProcess.ID;
}
else
{
// make art process
var artProcessModel = new ArtProcess {
ArticleNoID = result.ArticleNoID, ProcessID = bPFCEstablishDto.Process.ToUpper() == "STF" ? 2 : 1
};
_repoArtProcess.Add(artProcessModel);
await _repoArtProcess.SaveAll();
result.ArtProcessID = artProcessModel.ID;
}
//End make Art Process
result.CreatedBy = bPFCEstablishDto.CreatedBy;
scope.Complete();
return(result);
}
}
