Example #1
0
        public EndUser UpdateEnduser(EndUser enduser)
        {
            _IEndUserRepository.Update(enduser);
            _IUnitOfWork.Commit();

            return(enduser);
        }
Example #2
0
        public string CreateToken(EndUser user)
        {
            List <Claim> claims = new List <Claim>
            {
                new Claim(ClaimTypes.Name, user.UserName),
                new Claim(ClaimTypes.NameIdentifier, user.Id),
                new Claim(ClaimTypes.Email, user.Email)
            };

            var key = new SymmetricSecurityKey(Encoding.UTF8.GetBytes("very hideous key. don't look at it"));
            var signingCredentials = new SigningCredentials(key, SecurityAlgorithms.HmacSha512Signature);

            var tokenDescriptor = new SecurityTokenDescriptor
            {
                Subject            = new ClaimsIdentity(claims),
                Expires            = DateTime.Now.AddDays(30),
                SigningCredentials = signingCredentials
            };

            var tokenHandler = new JwtSecurityTokenHandler();

            SecurityToken token = tokenHandler.CreateToken(tokenDescriptor);

            return(tokenHandler.WriteToken(token));
        }
Example #3
0
 /// <summary>
 /// Initializes a new instance of the <see cref="Request"/> class.
 /// </summary>
 public Request()
 {
     TransactionData = new TransactionData();
     Enduser         = new EndUser();
     SalesData       = new SalesData();
     StatsData       = new StatsDetails();
 }
    protected void commandLogin_Click(object sender, EventArgs e)
    {
        if (IsValid)
        {
            EndUser           enduser      = new EndUser();
            ProcessAdminLogin processlogin = new ProcessAdminLogin();

            enduser.ContactInformation.Email = textUsername.Text;
            enduser.Password     = textPassword.Text;
            processlogin.EndUser = enduser;

            try
            {
                processlogin.Invoke();

                if (processlogin.IsAuthenticated)
                {
                    FormsAuthentication.RedirectFromLoginPage(textUsername.Text, false);
                }
                else
                {
                    labelMessage.Text = "Invalid login!";
                }
            }
            catch
            {
                Response.Redirect("../ErrorPage.aspx");
            }
        }
    }
Example #5
0
        public RegisterTests(CustomWebApplicationFactoryWithMariaDb <Admin.Startup> factory)
        {
            _client  = factory.CreateClient();
            _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>();
            Utils.RemoveAllEntities(_context);

            _context.Add(_org1    = Utils.CreateOrganization(code: 1, name: "org1"));
            _context.Add(_domain1 = new Domain {
                Id = Guid.NewGuid(), Name = "domain01", Organization = _org1
            });
            _context.Add(_user1 = new SuperAdmin {
                AccountName = "user0", Name = "user0", Password = Utils.HashPassword("user0")
            });                                                                                                                      // スーパー管理者
            _context.Add(_user2 = new UserAdmin {
                AccountName = "user1", Name = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1
            });                                                                                                                                        // ユーザー管理者
            _context.Add(_simGroup1 = new SimGroup()
            {
                Id                      = Guid.NewGuid(),
                Name                    = "simGroup1",
                Organization            = _org1,
                Apn                     = "apn",
                AuthenticationServerIp  = "AuthenticationServerIp",
                IsolatedNw1IpPool       = "IsolatedNw1IpPool",
                IsolatedNw1SecondaryDns = "IsolatedNw1SecondaryDns",
                IsolatedNw1IpRange      = "IsolatedNw1IpRange",
                IsolatedNw1PrimaryDns   = "IsolatedNw1PrimaryDns",
                NasIp                   = "NasIp",
                PrimaryDns              = "PrimaryDns",
                SecondaryDns            = "SecondaryDns",
                UserNameSuffix          = "UserNameSuffix",
            });
            _context.SaveChanges();
        }
Example #6
0
        public ListingTests(CustomWebApplicationFactory <JinCreek.Server.Admin.Startup> factory)
        {
            _client  = factory.CreateClient();
            _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>();

            Utils.RemoveAllEntities(_context);

            _context.Add(_org1    = Utils.CreateOrganization(code: 1, name: "org1"));
            _context.Add(_org2    = Utils.CreateOrganization(code: 2, name: "org2"));
            _context.Add(_domain1 = new Domain {
                Id = Guid.NewGuid(), Name = "domain01", Organization = _org1
            });
            _context.Add(_domain1a = new Domain {
                Id = Guid.NewGuid(), Name = "domain01a", Organization = _org1
            });
            _context.Add(_domain2 = new Domain {
                Id = Guid.NewGuid(), Name = "domain02", Organization = _org2
            });
            _context.Add(_user1 = new SuperAdmin {
                AccountName = "user0", Password = Utils.HashPassword("user0")
            });                                                                                                      // スーパー管理者
            _context.Add(_user2 = new UserAdmin {
                AccountName = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1
            });                                                                                                                       // ユーザー管理者
            _context.SaveChanges();
        }
Example #7
0
        public async Task <Boolean> AddEntityAsync(EndUser user)
        {
            var sql = $@"INSERT INTO [User]
                            ([Name],[LastName],[Email],
                            [Password],[Salt],[Role],
                            [EmailConfirmed],[IsActive],[DateJoined])
                        VALUES(
                            @name,@lastName,@email,
                            @password,@salt,@role,
                            @emailConfirmed,@isActive,@dateJoined)";

            await using var connection = new SqlConnection(_connectionString_);
            var result = await connection.ExecuteAsync(sql, new
            {
                name           = user.Name,
                lastName       = user.LastName,
                email          = user.Email,
                password       = user.Password,
                salt           = user.Salt,
                role           = user.Role,
                emailConfirmed = user.EmailConfirmed,
                isActive       = user.IsActive,
                dateJoined     = user.DateJoined.ToString("yyyy-MM-dd HH:mm:ss.fff")
            });

            return(result > 0);
        }
Example #8
0
        public IActionResult Put(int id, [FromBody] EndUserViewModel endUser)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            EndUser _endUserDb = _endUserRepository.GetSingle(id);

            if (_endUserDb == null)
            {
                return(NotFound());
            }
            else
            {
                _endUserDb.FirstName = endUser.FirstName;
                _endUserDb.LastName  = endUser.LastName;
                _endUserDb.Email     = endUser.Email;
                _endUserRepository.Commit();
            }

            endUser = Mapper.Map <EndUser, EndUserViewModel>(_endUserDb);

            return(new NoContentResult());
        }
Example #9
0
        public IActionResult Delete(int id)
        {
            EndUser _endUserDb = _endUserRepository.GetSingle(id);

            if (_endUserDb == null)
            {
                return(new NotFoundResult());
            }
            else
            {
                IEnumerable <JobAssignee> _jobAssignees = _jobAssigneeRepository.FindBy(a => a.EndUserId == id);

                foreach (var jobAssignee in _jobAssignees)
                {
                    _jobAssigneeRepository.Delete(jobAssignee);
                }


                _endUserRepository.Delete(_endUserDb);

                _endUserRepository.Commit();

                return(new NoContentResult());
            }
        }
        ////original
        // if (!ModelState.IsValid)
        // {
        //     return BadRequest(ModelState);
        // }

        // db.EveryBody.Add(enduser);
        // db.SaveChanges();

        // return CreatedAtRoute("DefaultApi", new { id = enduser.ID }, enduser);

        private void UpdateEndUserProducts(AssignedProductData[] selectedProducts, EndUser endUserToUpdate)
        {
            if (selectedProducts == null)
            {
                endUserToUpdate.ProductNews = new List <ProductNew>();
                return;
            }

            var selectedProductsHS = new HashSet <int>(selectedProducts.Where(i => i.Assigned).Select(i => i.ProductID));
            //  Select(c=>c.ProductID));

            var endUserProducts = new HashSet <int>(endUserToUpdate.ProductNews.Select(c => c.ProductID));

            foreach (var product in db.ProductNew)
            {
                if (selectedProductsHS.Contains(product.ProductID))
                {
                    if (!endUserProducts.Contains(product.ProductID))
                    {
                        endUserToUpdate.ProductNews.Add(product);
                    }
                }
                else
                {
                    if (endUserProducts.Contains(product.ProductID))
                    {
                        endUserToUpdate.ProductNews.Remove(product);
                    }
                }
            }
        }
        public ActionResult Edit([Bind(Include = "EndUserID,UserName,Email,BuildingID,RmNo,Tag,ComputerSerial,ComputerName,AdobeID,RequestID")] EndUserViewModel endUserVM)
        {
            if (ModelState.IsValid)
            {
                EndUser endUser = db.EndUsers.Find(endUserVM.EndUserID);
                endUser.UserName = endUserVM.UserName;
                endUser.Email    = endUserVM.Email;
                Building build = db.Buildings.Find(endUserVM.BuildingID);
                endUser.Building       = build;
                endUser.RmNo           = endUserVM.RmNo;
                endUser.Tag            = endUserVM.Tag;
                endUser.ComputerSerial = endUserVM.ComputerSerial;
                endUser.ComputerName   = endUserVM.ComputerName;
                endUser.AdobeID        = endUserVM.AdobeID;
                Request req = db.Requests.Find(endUserVM.RequestID);
                endUser.Request         = req;
                db.Entry(endUser).State = EntityState.Modified;
                try
                {
                    db.SaveChanges();
                    TempData["SuccessOHMsg"] = "End User " + endUser.UserName + " edited";
                    return(RedirectToAction("Index"));
                }
                catch
                {
                    TempData["DangerOHMsg"] = "Problem editing the End User" + endUser.UserName;
                    return(RedirectToAction("Index"));
                }
            }

            // TODO: Might want to change the dataTextField to another attribute of Request that is unique but also identifiable
            ViewBag.RequestList  = new SelectList(db.Requests.OrderBy(x => x.RequestID), "RequestID", "RequestID");
            ViewBag.BuildingList = new SelectList(db.Buildings.OrderBy(x => x.BuildingID), "BuildingID", "BuildingName");
            return(View(endUserVM));
        }
Example #12
0
        public IHttpActionResult EndUserRegister([FromBody] EndUserLoginModel model)
        {
            if (model == null)
            {
                return(BadRequest());
            }
            try
            {
                EndUser user = _IEndUserService.GetUser(model.Email);
                if (user != null)
                {
                    if (user.DateOfBirth.Equals(model.DateOfBirth))
                    {
                        user.PassOne   = model.Passcode1;
                        user.PassTwo   = model.Passcode2;
                        user.PassThree = model.Passcode3;
                        user.PassFour  = model.Passcode4;
                        var result = _IEndUserService.UpdateEnduser(user);
                        return(Ok(result));
                    }
                }

                return(BadRequest());
            }
            catch (Exception ex)
            {
                return(InternalServerError(ex));
            }
        }
Example #13
0
        public ActionResult EndUserForm([Bind(Include = "RequestID,UserName,Email,BuildingID,RmNo,Tag,ComputerSerial,ComputerName,AdobeID")] EndUserFormViewModel endUserForm)
        {
            // TODO: Might want to change the dataTextField to another attribute of Request that is unique but also identifiable
            ViewBag.RequestList  = new SelectList(db.Requests.OrderBy(x => x.RequestID), "RequestID", "RequestID");
            ViewBag.BuildingList = new SelectList(db.Buildings.OrderBy(x => x.BuildingID), "BuildingID", "BuildingName");

            if (ModelState.IsValid)
            {
                // Get objects from tables
                Request  req   = db.Requests.Find(endUserForm.RequestID);
                Building build = db.Buildings.Find(endUserForm.BuildingID);

                // Create new End User
                EndUser endUser = new EndUser();
                endUser.UserName       = endUserForm.UserName;
                endUser.Email          = endUserForm.Email;
                endUser.Building       = build;
                endUser.RmNo           = endUserForm.RmNo;
                endUser.Tag            = endUserForm.Tag;
                endUser.ComputerSerial = endUserForm.ComputerSerial;
                endUser.ComputerName   = endUserForm.ComputerName;
                endUser.AdobeID        = endUserForm.AdobeID; // Optional to include AdobeID right when the EndUser is created, but should be rare
                endUser.Request        = req;
                db.EndUsers.Add(endUser);
                db.SaveChanges();

                TempData["SuccessOHMsg"] = "End User " + endUser.UserName + " created";
                return(RedirectToAction("EndUserForm"));
            }
            ViewData["request"] = endUserForm.RequestID;
            ModelState.AddModelError("", "Problem Submitting the form. Model state is not valid.");
            return(View());
        }
Example #14
0
        public EndUser CreateEnduser(EndUser endUser)
        {
            _IEndUserRepository.Add(endUser);
            _IUnitOfWork.Commit();

            return(endUser);
        }
Example #15
0
        public IHttpActionResult PostEndUser(EndUser endUser)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.EndUser.Add(endUser);

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateException)
            {
                if (EndUserExists(endUser.user_name))
                {
                    return(Conflict());
                }
                else
                {
                    throw;
                }
            }

            return(CreatedAtRoute("DefaultApi", new { id = endUser.user_name }, endUser));
        }
Example #16
0
        public IHttpActionResult PutEndUser(string id, EndUser endUser)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != endUser.user_name)
            {
                return(BadRequest());
            }

            db.Entry(endUser).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!EndUserExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
 public MailOrderEntity(Guid id, string companyCode, string agentId, EndUser endUser)
 {
     ID          = id;
     CompanyCode = companyCode;
     AgentId     = agentId;
     EndUser     = endUser;
 }
Example #18
0
        public async Task <ActionResult <Content <Boolean> > > RegisterSelf([FromBody] EndUser user)
        {
            user.Id = 0;
            var result = await _endUserManager_.AddEntityAsync(user);

            return(result);
        }
Example #19
0
        public async Task <ActionResult <Content <Boolean> > > UpdateUser([FromBody] EndUser user)
        {
            var resultContent = new Content <Boolean>();
            var idString      = HttpContext.User.Claims.FirstOrDefault(x => x.Type.Equals(ClaimTypesExt.Id))?.Value;

            if (!String.IsNullOrWhiteSpace(idString) && Int32.TryParse(idString, out Int32 id))
            {
                user.Id = id;
                var result = await _endUserManager_.UpdateEntityAsync(user);

                if (result.HasError)
                {
                    resultContent.AppendError(result);
                }
                else
                {
                    resultContent.SetData(result.Data);
                }
            }
            else
            {
                resultContent.AppendError(new ArgumentException(), "User not signed in properly.");
            }
            return(resultContent);
        }
Example #20
0
        private void dgvEndUser_CellContentClick(object sender, DataGridViewCellEventArgs e) //Added the datagridview
        {
            Admin administrator = (Admin)dgvAdmin.SelectedRows[0].DataBoundItem;

            txtAAdminID.Text  = administrator.PIDAdmin.ToString();
            txtAFName.Text    = administrator.FName;
            txtALname.Text    = administrator.LName;
            txtAUname.Text    = administrator.UName;
            txtAPassword.Text = administrator.Password;

            Agent agents = (Agent)dgvCallAgent.SelectedRows[0].DataBoundItem;

            txtCID.Text         = agents.PIDAgent.ToString();
            txtCFName.Text      = agents.FName;
            txtCLName.Text      = agents.LName;
            txtCAgentEXT.Text   = agents.AgentEXT;
            txtCTotalCalls.Text = agents.TotalCalls.ToString();

            EndUser endUser = (EndUser)dgvEndUser.SelectedRows[0].DataBoundItem;

            txtEID.Text    = endUser.PIDEndUser.ToString();
            txtEFName.Text = endUser.FName;
            txtELName.Text = endUser.LName;
            txtEFBID.Text  = endUser.FBID;
            txtEEmail.Text = endUser.Email;
            txtECell.Text  = endUser.CellNumber;
        }
Example #21
0
        public ListingTests(CustomWebApplicationFactory <JinCreek.Server.Admin.Startup> factory)
        {
            _client  = factory.CreateClient();
            _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>();
            _context.Database.EnsureDeleted();
            _context.Database.EnsureCreated();

            _context.Add(_org1    = Utils.CreateOrganization(code: 1, name: "org1"));
            _context.Add(_org2    = Utils.CreateOrganization(code: 2, name: "org2"));
            _context.Add(_domain1 = new Domain {
                Id = Guid.NewGuid(), Name = "domain01", Organization = _org1
            });
            _context.Add(_domain2 = new Domain {
                Id = Guid.NewGuid(), Name = "domain02", Organization = _org2
            });
            _context.Add(_user1 = new SuperAdmin {
                AccountName = "user0", Password = Utils.HashPassword("user0")
            });                                                                                                      // スーパー管理者
            _context.Add(_user2 = new UserAdmin {
                AccountName = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1
            });                                                                                                                        // ユーザー管理者
            _context.Add(_simGroup1 = new SimGroup()
            {
                Id = Guid.NewGuid(), Name = "simGroup1", Organization = _org1
            });
            _context.Add(_simGroup2 = new SimGroup
            {
                Id = Guid.NewGuid(), Name = "simGroup2", Organization = _org2, IsolatedNw1IpPool = ""
            });
            _context.Add(_simGroup1a = new SimGroup
            {
                Id = Guid.NewGuid(), Name = "simGroup1a", Organization = _org1
            });
            _context.SaveChanges();
        }
        public async Task <MailOrderEntity> CreateMailOrderAsync(CreateMailOrderCommand createMailOrdercommand)
        {
            var ratios = await _ratioGrpcClient.GetRatiosAsync(new GetRatiosCommand()
            {
                CompanyCode           = createMailOrdercommand.CompanyCode,
                AgentId               = createMailOrdercommand.AgentId,
                BankId                = createMailOrdercommand.BankId,
                AddCommissionToAmount = true,
                Instalments           = createMailOrdercommand.Instalments
            });

            if (ratios == null)
            {
                throw new Exception("Ratio not found.");
            }

            var endUser = new EndUser(createMailOrdercommand.EndUserName, createMailOrdercommand.EndUserSurname,
                                      createMailOrdercommand.EndUserMail, createMailOrdercommand.EndUserPhone);

            var mailOrderEntity = new MailOrderEntity(createMailOrdercommand.CompanyCode, createMailOrdercommand.AgentId, endUser);

            var entity = await _mailOrderRepository.AddAsync(mailOrderEntity);

            _notification.SendMail(new SendMailCommand(mailOrderEntity.EndUser.EndUserMail, "mail subject", "mail body"));
            _notification.SendSms(new SendSmsCommand(mailOrderEntity.EndUser.EndUserPhone, "sms message"));

            return(entity);
        }
Example #23
0
 private void GetAllUsers(object sender, EventArgs e, bool showGridRowCount = true) {
     //populate gridView with tableAdapter data
     this.DataGridView1.DataSource = EndUser.GetAllEndUsers();
     //show number of records (NB requested by default)
     if (showGridRowCount)
         this.LblReturn.Text = (this.DataGridView1.RowCount - 1).ToString();
 }
Example #24
0
        public ActionResult Create()
        {
            var     endUserData = db.EndUsers.Include(x => x.MyFollow);
            EndUser endUser     = new EndUser();

            return(View());
        }
Example #25
0
        public bool EditEndUser(EndUser enduser, out string parametr)
        {
            EndUser enduserCurrent = db.EndUsers.FirstOrDefault(x => x.ID == enduser.ID);

            if (enduserCurrent != null)
            {
                if (enduserCurrent.DateOfBirth == enduser.DateOfBirth && enduserCurrent.IsManager == enduser.IsManager &&
                    enduserCurrent.Login == enduser.Login && enduserCurrent.Position == enduser.Position)
                {
                    parametr = "Данные не изменены";
                    return(false);
                }

                EndUser checkLogin = db.EndUsers.FirstOrDefault(x => x.Login == enduser.Login);
                if (checkLogin != null && checkLogin != enduserCurrent)
                {
                    parametr = "Пользователь с таким логином уже зарегисрирован";
                    return(false);
                }

                enduserCurrent.DateOfBirth = enduser.DateOfBirth;
                enduserCurrent.IsManager   = enduser.IsManager;
                enduserCurrent.Login       = enduser.Login;
                enduserCurrent.Position    = enduser.Position;

                db.Entry(enduserCurrent).State = EntityState.Modified;
                db.SaveChanges();
                parametr = "";
                return(true);
            }
            parametr = "Пользователь не найден. Закройте это окно и обновите страницу";
            return(false);
        }
Example #26
0
 public EndUser Insert(EndUser endUser)
 {
     return(this.authorizationDBContext
            .EndUsers
            .Add(endUser)
            .Entity);
 }
Example #27
0
        public IHttpActionResult GetAllOrder([FromBody] EndUserLoginModel model)
        {
            try
            {
                if (model == null)
                {
                    return(BadRequest());
                }

                EndUser user = _IEndUserService.GetUser(model.Email);
                if (user != null)
                {
                    if (user.PassOne == model.Passcode1 && user.PassTwo == model.Passcode2 &&
                        user.PassThree == model.Passcode3 && user.PassFour == model.Passcode4)
                    {
                        var orders = _IOrderService.GetAllOrderByUser(user.EndUserId);
                        if (orders != null)
                        {
                            return(Ok(orders));
                        }
                    }
                }
                return(BadRequest());
            }
            catch (Exception)
            {
                return(InternalServerError());
            }
        }
        public void IndexTestService_Test()
        {
            #region Arrange
            string expected    = "AAA?PartnerID=&TokenID=1234&BaseReturnURL=http%3a%2f%2fastrotoday.org%2fBR%2f366_test_637318069063217583&ServID=366";
            string murp_URL    = "AAA";
            string domain_url  = "astrotoday.org";
            var    queryString = new NameValueCollection
            {
                { "sid", "366" }
            };

            IService service = new Service();

            Mock <IDiagnostic> mock_trace = new Mock <IDiagnostic>();
            mock_trace.Setup(x => x.trace(It.IsAny <string>()));
            mock_trace.Setup(x => x.traceError(It.IsAny <string>()));

            Mock <ILogin> mock_login = new Mock <ILogin>();
            mock_login.Setup(x => x.GetTokenID()).Returns("1234");

            Mock <ICall> mock_call = new Mock <ICall>();
            mock_call.Setup(x => x.doCall(
                                It.IsAny <object>(), It.IsAny <CallMethod>(), It.IsAny <CallContentType>(), It.IsAny <string>(), It.IsAny <IResponseParser>(), It.IsAny <string>(), It.IsAny <Dictionary <string, object> >())
                            ).Returns(new Dictionary <string, object>()
            {
                { "RetCode", "OK" },
                { "Description", "TEST" },
            });

            var mock_appSettings = new Mock <IAppSettings>();
            mock_appSettings.Setup(x => x["murp_URL"]).Returns(murp_URL);

            IEndUser endUser = new EndUser(mock_appSettings.Object, mock_call.Object, mock_trace.Object, mock_login.Object);

            var mock_request = new Mock <HttpRequestBase>();
            mock_request.Setup(x => x.HttpMethod).Returns("GET");
            mock_request.Setup(x => x.Url).Returns(new Uri("http://" + domain_url));
            mock_request.SetupGet(x => x.QueryString).Returns(queryString);
            mock_request.SetupGet(x => x.Headers).Returns(
                new System.Net.WebHeaderCollection {
                //{"X-Requested-With", "XMLHttpRequest"}
                { "X-Requested-With", "SAFE" }
            });

            HomeController controller = new HomeController(mock_trace.Object, endUser, service);
            var            context    = new Mock <HttpContextBase>();
            context.SetupGet(x => x.Request).Returns(mock_request.Object);

            controller.ControllerContext = new ControllerContext(context.Object, new System.Web.Routing.RouteData(), controller);
            #endregion

            #region Act
            var actual = controller.Index() as RedirectResult;
            #endregion

            #region Assert
            Assert.AreEqual(expected, actual.Url);
            #endregion
        }
Example #29
0
        public InquiryTests(CustomWebApplicationFactory <JinCreek.Server.Admin.Startup> factory)
        {
            _client  = factory.CreateClient();
            _context = factory.Services.GetService <IServiceScopeFactory>().CreateScope().ServiceProvider.GetService <MainDbContext>();

            _context.Database.EnsureDeleted();
            _context.Database.EnsureCreated();


            _context.Add(_clientOs1 = new ClientOs {
                Id = Guid.NewGuid(), Name = "Windows 10"
            });
            _context.Add(_clientApp1 = new ClientApp {
                Id = Guid.NewGuid(), ClientOs = _clientOs1, Version = "1903"
            });
            _context.Add(_organizationClientApp1 = new OrganizationClientApp {
                Id = Guid.NewGuid(), Organization = _org1, ClientApp = _clientApp1
            });
            _context.Add(_org1    = Utils.CreateOrganization(code: 1, name: "org1"));
            _context.Add(_domain1 = new Domain {
                Id = Guid.NewGuid(), Name = "domain1", Organization = _org1
            });
            _context.Add(_deviceGroup1 = new DeviceGroup {
                Id = Guid.NewGuid(), Domain = _domain1, Name = "deviceGroup1"
            });
            _context.Add(_userGroup1 = new UserGroup {
                Id = Guid.NewGuid(), Domain = _domain1, Name = "userGroup1"
            });
            _context.Add(_lte1 = new LteModule {
                Id = Guid.NewGuid(), Name = "lte1"
            });
            _context.Add(_device1 = new Device
            {
                Id                 = Guid.NewGuid(),
                Name               = "deviceName1",
                Domain             = _domain1,
                ManagedNumber      = "0001",
                SerialNumber       = "0001",
                ProductName        = "Test1",
                UseTpm             = true,
                StartDate          = DateTime.Parse("2020-02-01"),
                EndDate            = DateTime.Parse("2021-03-01"),
                LteModule          = _lte1,
                DeviceGroupDevices = new HashSet <DeviceGroupDevice> {
                    new DeviceGroupDevice {
                        DeviceGroup = _deviceGroup1
                    }
                },
                WindowsSignInListCacheDays = 1,
                OrganizationClientApp      = _organizationClientApp1,
            });
            _context.Add(_user0 = new SuperAdmin {
                AccountName = "user0", Password = Utils.HashPassword("user0")
            });                                                                                                      // スーパー管理者;
            _context.Add(_user1 = new UserAdmin {
                AccountName = "user1", Password = Utils.HashPassword("user1"), Domain = _domain1
            });                                                                                                                        // ユーザー管理者1
            _context.SaveChanges();
        }
        public ActionResult DeleteConfirmed(string id)
        {
            EndUser endUser = db.EndUsers.Find(id);

            db.EndUsers.Remove(endUser);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }