//Thêm Brand mới vào bảng ModelNo public async Task <bool> Add(ModelNoDto model) { var ModelNo = _mapper.Map <ModelNo>(model); _repoModelNo.Add(ModelNo); return(await _repoModelNo.SaveAll()); }
//Thêm Brand mới vào bảng Line public async Task <bool> Add(ModelNoDto model) { var Line = _mapper.Map <ModelNo>(model); _repoLine.Add(Line); return(await _repoLine.SaveAll()); }
public async Task <bool> CloneModelName(int modelNameID, int modelNOID, int articleNOID, int processID) { 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) .Include(x => x.Plans) .FirstOrDefaultAsync(x => x.ModelNameID == modelNameID && x.ModelNoID == modelNOID && x.ArticleNoID == articleNOID && x.ArtProcessID == processID); if (bpfc == null) { return(false); } var modelNameData = bpfc.ModelName; modelNameData.ID = 0; _repoModelName.Add(modelNameData); await _repoModelName.SaveAll(); var modelNoData = bpfc.ModelNo; modelNoData.ID = 0; modelNoData.ModelNameID = modelNameData.ID; _repoModelNO.Add(modelNoData); await _repoModelNO.SaveAll(); var articleNOData = bpfc.ArticleNo; articleNOData.ID = 0; articleNOData.ModelNoID = modelNoData.ID; _repoArticleNo.Add(articleNOData); await _repoArticleNo.SaveAll(); var artProcessData = bpfc.ArtProcess; artProcessData.ID = 0; artProcessData.ArticleNoID = articleNOData.ID; _repoArtProcess.Add(artProcessData); await _repoArtProcess.SaveAll(); var bpfcData = bpfc; bpfcData.ModelName = null; bpfcData.ModelNo = null; bpfcData.ArticleNo = null; bpfcData.ArtProcess = null; bpfcData.Glues = null; bpfcData.Plans = null; bpfcData.ID = 0; bpfcData.ModelNameID = modelNameData.ID; bpfcData.ModelNoID = modelNoData.ID; bpfcData.ArticleNoID = articleNOData.ID; bpfcData.ArtProcessID = artProcessData.ID; _repoBPFC.Add(bpfcData); await _repoBPFC.SaveAll(); var gluesData = bpfc.Glues.ToList(); gluesData.ForEach(item => { item.ID = 0; item.BPFCEstablishID = bpfcData.ID; }); _repoGlue.AddRange(gluesData); await _repoGlue.SaveAll(); var planData = bpfc.Plans.ToList(); planData.ForEach(item => { item.ID = 0; item.BPFCEstablishID = bpfcData.ID; }); _repoPlan.AddRange(planData); await _repoPlan.SaveAll(); scope.Complete(); } return(true); } catch (Exception ex) { Console.WriteLine("Loi clone model name", ex); return(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); } }