Example #1
0
        public async Task <Response <int> > UpdateDepartmentApprovers(DepartmentApproversVM model)
        {
            try
            {
                int success = 0;
                List <DepartmentApprover> newList = new List <DepartmentApprover>();

                var list = await _context.DepartmentApprover.Where(x => x.Workflow_ID == model.Workflow_ID && x.Is_Active == true).ToListAsync();

                foreach (var item in list)
                {
                    if (!model.DepartmentApproverItems.Any(x => x.Department_ID == item.Department_ID && x.Role_ID == item.Role_ID && item.Is_Active == true))
                    {
                        item.Is_Active = false;
                    }
                }
                await _context.SaveChangesAsync();

                foreach (var item in model.DepartmentApproverItems)
                {
                    var _tempItem = list.Where(x => x.Department_ID == item.Department_ID && x.Role_ID == item.Role_ID && x.Workflow_ID == item.Workflow_ID).FirstOrDefault();
                    if (_tempItem == null)
                    {
                        item.Is_Active = true;
                        newList.Add(item);
                    }
                    else
                    {
                        if (_tempItem.Is_Active == false)
                        {
                            _tempItem.Is_Active = true;
                        }
                    }
                }
                _context.DepartmentApprover.AddRange(newList);
                await _context.SaveChangesAsync();

                return(new Response <int>()
                {
                    IsSuccess = true,
                    Model = success
                });
            }
            catch (Exception ex)
            {
                _log.Error(ex, _user.GetCurrentUser().User_Name);
                return(new Response <int>()
                {
                    IsSuccess = false,
                    Message = ex.Message
                });
            }
        }
        public async Task <ActionResult> UpdateDepartmentApprovers([FromBody] DepartmentApproversVM model)
        {
            if (ModelState.IsValid)
            {
                try
                {
                    await _repository.UpdateDepartmentApprovers(model);

                    return(Ok());
                }
                catch (Exception ex)
                {
                    if (ex.GetType().FullName == "Microsoft.EntityFrameworkCore.DbUpdateConcurrencyException")
                    {
                        return(NotFound());
                    }
                    return(BadRequest());
                }
            }
            return(BadRequest());
        }