Example #1
0
        public async Task <bool> Delete(int glueid, int ingredientid)
        {
            var glueIngredient = _repoGlueIngredient.FindSingle(x => x.GlueID == glueid && x.IngredientID == ingredientid);

            if (glueIngredient != null)
            {
                _repoGlueIngredient.Remove(glueIngredient);
                return(await _repoGlueIngredient.SaveAll());
            }
            else
            {
                return(false);
            }
        }
Example #2
0
        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();
            }
        }
Example #3
0
        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
                });
            }
        }