public void Test_FindUserClass_GetUserIdBySessionIdMethod_Returns_An_Int() { FindUser user = new FindUser(); SessionControlCommand cmd = new SessionControlCommand(); Guid session_id = cmd.SessionStart(1, 3); Assert.IsInstanceOf(typeof(string), user.GetUsernameBySessionId(session_id)); }
public bool GetCommand(int jobId, Guid sessionId, string commentText) { ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); IDbCommand cmd = new OleDbCommand("sp_add_comment", (OleDbConnection)cn); cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); //Get user id FindUser find = new FindUser(); int userId = int.Parse(find.GetUserIDBySessionId(sessionId).ToString()); cmd.Parameters.Add(new OleDbParameter("@user_id", userId)); cmd.Parameters.Add(new OleDbParameter("@job_id", jobId)); cmd.Parameters.Add(new OleDbParameter("@comText", commentText)); cmd.ExecuteNonQuery(); return true; } catch(OleDbException e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return false; }
public void Test_FindUserClass_GetUserIdBySessionIdMethod_Returns_Correct_UserId() { FindUser user = new FindUser(); SessionControlCommand cmd = new SessionControlCommand(); Guid session_id = cmd.SessionStart(1, 3); Assert.AreEqual("katie.hodgkiss", user.GetUsernameBySessionId(session_id)); }
public List<DbRecommendation> Execute(Guid sessionID) { DbRecommendation rec = new DbRecommendation(); FindUser find = new FindUser(); int userId = int.Parse(find.GetUserIDBySessionId(sessionID).ToString()); string qry = "SELECT FDMUSER.firstname ||' '|| FDMUSER.lastname AS Name FROM FDMUSER JOIN RECOMMENDATIONS ON RECOMMENDATIONS.recomender_id = FDMUSER.user_id WHERE RECOMMENDATIONS.recomender_id = " + userId; IReadOneCommand cmd = new ReadOneCommand(); rec.Recommender = cmd.Execute(qry); string qry2 = "SELECT FDMUSER.firstname ||' '|| FDMUSER.lastname AS Name, JOBPOST.title, JOBPOST.job_id, recommendations.reason FROM FDMUSER JOIN RECOMMENDATIONS ON RECOMMENDATIONS.recomendee_id = FDMUSER.user_id JOIN JOBPOST ON RECOMMENDATIONS.job_id = JOBPOST.job_id WHERE RECOMMENDATIONS.recomender_id = " + userId; IReadCommand cmd2 = new ReadCommand(); DataTable dt = cmd2.Execute(qry2); List<DbRecommendation> recPeople = new List<DbRecommendation>(dt.Rows.Count); recPeople = (from DataRow row in dt.Rows select new DbRecommendation { Recommended = row["NAME"].ToString(), JobTitle = row["TITLE"].ToString(), JobID = int.Parse(row["JOB_ID"].ToString()), Reason = row["REASON"].ToString() }).ToList(); return recPeople; }
public IEnumerable <Order> GetList(List <string> FindByUser, string OrderID) { HashSet <Order> result = new HashSet <Order>(); if (FindByUser.Count > 0) { foreach (var FindUser in FindByUser) { var listTemp = _unitOfWork.OrderRepository .Where(user => user.UserId.ToLower().Contains(FindUser.ToLower()) || user.Shipper.ToLower().Contains(FindUser.ToLower())); foreach (var temp in listTemp) { result.Add(temp); } } } else { var listTemp = _unitOfWork.OrderRepository .Where(order => order.Id.ToString().Contains(OrderID.ToLower())); foreach (var temp in listTemp) { result.Add(temp); } } return(result.OrderByDescending(sort => sort.CreateDate).AsEnumerable()); }
public async Task <IActionResult> FindUser(FindUser findUser) { var user = await _metadataProvider.FindMojangUser(findUser.Username); findUser.FoundUser = user; return(View(findUser)); }
public void Test_FindUserClass_ExecuteMethod_Returns_A_Listof_DbUsers() { FindUser user = new FindUser(); DbUser findUser = new DbUser(); findUser.TypeId = 1; Assert.IsInstanceOf(typeof(List<DbUser>), user.Execute(findUser)); }
public void Test_GetUserClass_NumOfUsersMethod_Returns_An_Int() { string firstName = "Hinnah"; string lastName = "Sarwar"; FindUser usernames = new FindUser(); Assert.IsInstanceOf(typeof(int),usernames.NumOfUsers(firstName, lastName)); }
public void TestGetConsultantsReturnsAListOfConsultants() { FindUser find = new FindUser(); List<DbUser> users = find.GetConsultants("Java"); Console.WriteLine(users.Count()); Console.WriteLine(users[0].Username); Assert.Greater(users.Count(), 0); }
public void Test_GetUserClass_NumOfUsersMethod_Returns_An_Int() { string firstName = "Hinnah"; string lastName = "Sarwar"; FindUser usernames = new FindUser(); Assert.IsInstanceOf(typeof(int), usernames.NumOfUsers(firstName, lastName)); }
public void Test_GetUserClass_NumOfUsersMethod_Returns_Three_With_MoreThanOneOccurance() { string firstName = "Thomas"; string lastName = "Shore"; FindUser usernames = new FindUser(); Assert.AreNotEqual(1, usernames.NumOfUsers(firstName, lastName)); }
public void Test_GetUserClass_NumOfUsersMethod_Returns_One_With_OneOccurance() { string firstName = "Hinnah"; string lastName = "Sarwar"; FindUser usernames = new FindUser(); Assert.AreEqual(1, usernames.NumOfUsers(firstName, lastName)); }
public void Test_FindUserClass_ExecuteMethod_Returns_A_Listof_DbUsers() { FindUser user = new FindUser(); DbUser findUser = new DbUser(); findUser.TypeId = 1; Assert.IsInstanceOf(typeof(List <DbUser>), user.Execute(findUser)); }
public void Test_FindUserClass_ExecuteMethod_Returns_MoreThanOneUser_InThe_Listof_DbUsers() { FindUser user = new FindUser(); DbUser findUser = new DbUser(); findUser.TypeId = 1; findUser.Username = "******"; Assert.AreNotEqual(0, user.Execute(findUser).Count); }
public void TestGetConsultantsReturnsAListOfConsultants() { FindUser find = new FindUser(); List <DbUser> users = find.GetConsultants("Java"); Console.WriteLine(users.Count()); Console.WriteLine(users[0].Username); Assert.Greater(users.Count(), 0); }
public ProfileViewModel(FindUser user) { user = (user == null) ? MainViewModel.GetInstance().GetUser : user; this.Email = user.Email; this.Name = user.Name; this.LastName = user.LastName; this.Image = "profile.png"; CameraHelper = new CameraHelper(); }
public async Task <ObjectResult> FindByColor([FromBody] FindUser item) { string link = commands.WallpaperFindColor(item); using var client = new HttpClient(); var content = await client.GetStringAsync(link); //item1 - ссылка WallhavenResponse wallhavenResponse = JsonConvert.DeserializeObject <WallhavenResponse>(content); return(new ObjectResult(wallhavenResponse)); }
public async Task <IActionResult> AddUser(FindUser findUser) { var u = new User { Id = findUser.FoundUser.Id, Name = findUser.FoundUser.Name, IsServerAdmin = false }; _userRepository.AddUser(u); return(RedirectToAction("Users")); }
private string Read(string username) { FindUser user = new FindUser(); string password = ""; if (user.GetUserByUsername(username).Username == username) { string cmdString = "SELECT password FROM FDMUser WHERE FDMUSER.Username = '******'"; IReadOneCommand cmd = new ReadOneCommand(); password = cmd.Execute(cmdString).ToString(); } return password; }
public bool CreateActive(string Email) { string Name = "", surname = ""; if (OpenDatabase()) { SqlCommand cmd = sqlConn.CreateCommand(); cmd.CommandText = "SELECT * FROM UserInfo"; SqlDataReader FindUser; try { FindUser = cmd.ExecuteReader(); } catch (Exception e) { sqlConn.Close(); return(false); } while (FindUser.Read()) { if (Email == FindUser["Email"].ToString()) { Name = FindUser["FirstName"].ToString(); surname = FindUser["LastName"].ToString(); break; } } FindUser.Close(); cmd = sqlConn.CreateCommand(); cmd.CommandText = "INSERT INTO ActiveUser([Email],[Name],[Surname],[UserActive]) " + "VALUES ('" + Email + "','" + Name + "','" + surname + "',1)"; try { cmd.ExecuteNonQuery(); } catch (Exception e) { sqlConn.Close(); return(false); } sqlConn.Close(); return(true); } else { sqlConn.Close(); return(false); } }
private User Find(FindUser predicate) { foreach (var user in _users) { if (predicate(user)) { return(user); } } return(null); }
public async Task <ObjectResult> FindCategory([FromBody] FindUser item) { string link = commands.FindByCategory(item); using var client = new HttpClient(); var content = await client.GetStringAsync(link); WallhavenResponse wallhavenResponse = JsonConvert.DeserializeObject <WallhavenResponse>(content); wallhavenResponse.id = item.id; return(new ObjectResult(wallhavenResponse)); }
public async Task TestMemoryFindUserById() { const int id = 1; var repository = new UserMemoryRepository(); repository.Create(new Core.Entities.User()); var findUser = new FindUser(repository); var user = await findUser.ByIdAsync(id); Assert.AreEqual(id, user.Id); }
public async Task <ObjectResult> DelFavourite([FromBody] FindUser item) { Users users_1 = commands.Get(Convert.ToString(item.id)); DataBase dataBase = new DataBase(); dataBase.users.Add(users_1); if (users_1 == null) { return(new ObjectResult("BAD")); } else { using var client = new HttpClient(); var content = await client.GetStringAsync($"https://api.unsplash.com/photos/{item.photoId}/?client_id=JGYSsjXO8ANdFCsiBrNZVmi3yXfOcSM5VD0jU8EpeY8"); RandomResponse wallhaven = JsonConvert.DeserializeObject <RandomResponse>(content); bool imagecontains = false; int index = 0; for (int i = 0; i < users_1.Images.Count; i++) { if (users_1.Images[i].Id == item.photoId) { index = i; imagecontains = true; break; } } if (imagecontains == false) { return(new ObjectResult("BAD")); } else { dataBase.users[0].Images.RemoveAt(index); commands.Update(Convert.ToString(item.id), dataBase.users[0]); return(new ObjectResult("Deleted")); } } }
public async Task TestDatabaseFindUserById() { const int id = 1; var options = new DbContextOptionsBuilder <UserContext>() .UseInMemoryDatabase("Users") .Options; await using var context = new UserContext(options); var repository = new UserDatabaseRepository(context); repository.Create(new Core.Entities.User()); var findUser = new FindUser(repository); var user = await findUser.ByIdAsync(id); Assert.AreEqual(id, user.Id); }
public bool Execute(DbUser alteredUser) { FindUser fuser = new FindUser(); List<DbUser> userList = fuser.Execute(alteredUser.Username); alteredUser.UserId = userList[0].UserId; ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); IDbCommand cmd = new OleDbCommand("sp_update_password", (OleDbConnection)cn); cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); cmd.Transaction = tran; // Add job cmd.Parameters.Add(new OleDbParameter("@userID", alteredUser.UserId)); cmd.Parameters.Add(new OleDbParameter("@newPass", alteredUser.Password)); int affectedRows = cmd.ExecuteNonQuery(); if (affectedRows > 0) { tran.Commit(); return true; } else { tran.Rollback(); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return false; }
public async Task <ObjectResult> GetFavorite([FromBody] FindUser item) { Users users = commands.Get(Convert.ToString(item.id)); DataBase dataBase = new DataBase(); dataBase.users.Add(users); if (users == null) { return(new ObjectResult("BAD")); } else { return(new ObjectResult(dataBase.users[0].Images)); } }
// POST: api/User_Find /// <summary> /// 查找用户 /// </summary> /// <param name="value"></param> /// <returns></returns> public ReturnFindUser Post([FromBody] FindUser value) { ReturnFindUser returnModel = new ReturnFindUser(); try { List <User> tmpUserList = new List <Models.User>(); //select * from info where name regexp 'ic' //like "%2%" List <string> accountList = myConnent.MySqlRead("SELECT * FROM 账号表 WHERE Account Like '%" + value.account + "%' OR UserName Like '%" + value.account + "%'", "Account"); if (accountList[0] != "error") { foreach (string account in accountList) { User tmpUser = new User(); tmpUser.account = account; tmpUser.email = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "email"); tmpUser.sex = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "sex"); tmpUser.userName = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "userName"); tmpUser.introduction = myConnent.MySqlReadReturn("SELECT * FROM 账号表 WHERE Account ='" + account + "'", "introduction"); tmpUserList.Add(tmpUser); } returnModel.result = "true"; returnModel.userList = tmpUserList; return(returnModel); } else { returnModel.result = "error"; return(returnModel); } } catch (Exception e) { Debug.WriteLine(e.ToString()); returnModel.result = "error"; return(returnModel); } }
public async Task <IActionResult> SearchUsername(SearchViewModel searchViewModel) { if (ModelState.IsValid) { FindUser findUser = new FindUser(searchViewModel.Username); EpicNameModel epicNameModel = await findUser.FindUserID(); StatsProcessor statsProcessor = new StatsProcessor(); EpicStatsModel epicStatsModel = await statsProcessor.LoadStats(epicNameModel); if (epicStatsModel.Global_Stats != null & epicStatsModel.Name != null) { ViewBag.name = epicStatsModel.Name; ViewBag.statistics = epicStatsModel.Global_Stats; return(View()); } ViewBag.name = "User does not exist."; } return(View()); }
/// <summary> /// 查找下一个处理者 /// </summary> /// yand 16.09.13 /// <param name="actionId"></param> /// <returns></returns> public UserInfo FindLastUser(int actionId, int instanceId) { UserInfo userinfo = new UserInfo(); //根据行为ID查找对应的通知用户 ActionInfo action = new BLL.Flow.Action().Get(actionId); IFindUser finduser = FindUser.CreateStrategy(action); //根据行为ID和实例ID查找下一个处理者 FlowData flowData = new FlowData() { InstanceId = instanceId, ActionId = actionId }; // 判断是否查到人,查不到分配总经理账户 int userId = finduser.FindUser(flowData) == null ? new DAL.User.UserInfoMapper().FindByRole("总经理").UserId : finduser.FindUser(flowData).Value; userinfo = new BLL.User.User().GetUser(userId); return(userinfo); }
public async Task <JwtToken> Login(Credentials credens) { var result = await _userContext.User.Find(FindUser.Email(credens.Email)).FirstOrDefaultAsync(); if (result != null && BCrypt.Net.BCrypt.Verify(credens.Password, result.Password)) { string refreshToken = _authServices.BuildRefreshToken(); await _authServices.SaveToken(result.Name, refreshToken); return(new JwtToken { Name = result.Name, AccessToken = _authServices.BuildAccessToken(credens.Email, result.Name), RefreshToken = refreshToken }); } throw new LoginException(Message.InvalidCredens); }
/// <summary> /// Get User info for input string /// </summary> /// <param name="username">user to get info for</param> /// <returns>user info</returns> public async Task <UserInfo> GetUserInfo(string username) { var _findUser = new FindUser(); _findUser.authentication = MvvmNanoIoC.Resolve <Authentication>(); _findUser.userToFind = username; _restUrl = "http://tutorscout24.vogel.codes:3000/tutorscout24/api/v1/user/userInfo"; var uri = new Uri(string.Format(_restUrl, string.Empty)); var json = JsonConvert.SerializeObject(_findUser); var content = new StringContent(json, Encoding.UTF8, "application/json"); var response = await _client.PostAsync(uri, content); if (response.IsSuccessStatusCode) { var rescontent = await response.Content.ReadAsStringAsync(); return(JsonConvert.DeserializeObject <UserInfo>(rescontent)); } return(null); }
public async Task <JwtToken> RefreshToken(JwtToken token) { ClaimsPrincipal principal = PrincipalToken(token.AccessToken); User userCheck = await _userContext.User.Find(FindUser.Name(principal.Identity.Name)).SingleAsync(); if (userCheck == null || userCheck.RefreshToken != token.RefreshToken) { throw new RefreshTokenException(Message.RefreshTokenNotFound); } string newRefreshToken = BuildRefreshToken(); await SaveToken(principal.Identity.Name, newRefreshToken); return(new JwtToken { Name = principal.Identity.Name, AccessToken = GenerateToken(principal.Claims), RefreshToken = newRefreshToken }); }
public User Handle(FindUser input) { var query = _context.Users.Include(f => f.Phones).AsQueryable(); if (input.Id.HasValue) { return(query.FirstOrDefault(w => w.Id == input.Id)); } else { if (!string.IsNullOrWhiteSpace(input.Email)) { query = query.Where(w => w.Email == input.Email); } if (!string.IsNullOrWhiteSpace(input.Password)) { query = query.Where(w => w.Password == input.Password); } } return(query.FirstOrDefault()); }
public async Task Register(UserParam user) { User result = await _userContext.User.Find(FindUser.Name(user.Name)).FirstOrDefaultAsync(); if (result != null) { throw new RegisterException(Message.NameAlready); } try { await _userContext.User.InsertOneAsync(new User { Name = user.Name, Email = user.Email, Password = BCrypt.Net.BCrypt.HashPassword(user.Password) }); } catch (MongoWriteException ex) { throw ex; } }
public DbUser DisplayProfile(Guid sessionid) { UserProfile profile = new UserProfile(); FindUser find = new FindUser(); int id = int.Parse(find.GetUserIDBySessionId(sessionid)); DbUser user = profile.GetUserDetails(id); return user; }
public void TestFindUserClass_ExecuteMethod_Accepts_Username_And_returns_A_ListOf_DbUser() { FindUser users = new FindUser(); Assert.IsInstanceOf(typeof(List <DbUser>), users.Execute("hinnah.sarwar")); }
public void TestFindUserClass_ExecuteMethod_Returns_One_With_Valid_UserName() { FindUser users = new FindUser(); Assert.AreEqual(1, users.Execute("hinnah.sarwar").Count); }
public bool GetCommand(DbJob job, List<string> skills, Guid sessionID) { //string cmdString = "sp_add_job(" + job[0].UserId + ",'" + job[0].StreamId + "','" + // job[0].StatusId + "','" + job[0].Description + "','" + // job[0].Title + "','" + job[0].Deadline + "','" + // job[0].Company + "'," + job[0].Location + ")"; //IWriteCommand cmd = new WriteCommand(); //cmd.SetCommand(cmdString); //if (cmd.Execute()) //{ // return true; //} //return false; ConnectionString cnString = new ConnectionString(); IDbConnection cn = new OleDbConnection(cnString.GetConnString()); IDbCommand cmd = new OleDbCommand("sp_add_job", (OleDbConnection)cn); cmd.CommandType = CommandType.StoredProcedure; try { cn.Open(); IDbTransaction tran = cn.BeginTransaction(); cmd.Transaction = tran; // Get IDs GetStatusID statusid = new GetStatusID(); int status_ID = int.Parse(statusid.Read(job.Status)); GetStreamID streamid = new GetStreamID(); int stream_ID = int.Parse(streamid.Read(job.Stream)); FindUser find = new FindUser(); int userId = int.Parse(find.GetUserIDBySessionId(sessionID).ToString()); // Add job cmd.Parameters.Add(new OleDbParameter("@user_id", userId)); cmd.Parameters.Add(new OleDbParameter("@stream_id", stream_ID)); cmd.Parameters.Add(new OleDbParameter("@status_id", status_ID)); cmd.Parameters.Add(new OleDbParameter("@description", job.Description)); cmd.Parameters.Add(new OleDbParameter("@title", job.Title)); cmd.Parameters.Add(new OleDbParameter("@deadline", job.Deadline)); cmd.Parameters.Add(new OleDbParameter("@company", job.Company)); cmd.Parameters.Add(new OleDbParameter("@location", job.Location)); int affectedRows = cmd.ExecuteNonQuery(); if (affectedRows > 0) { // Add jobskills for (int i = 0; i < skills.Count(); i++) { IDbCommand cmd2 = new OleDbCommand("sp_add_jobSkill", (OleDbConnection)cn); cmd2.Transaction = tran; cmd2.CommandType = CommandType.StoredProcedure; string formattedSkill = FormatSkill(skills[i]); GetSkillId id = new GetSkillId(); int skillid = int.Parse(id.Read(formattedSkill)); cmd2.Parameters.Add(new OleDbParameter("@skill_id", int.Parse(skillid.ToString()))); affectedRows = affectedRows + cmd2.ExecuteNonQuery(); } tran.Commit(); return true; } else { tran.Rollback(); } } catch (Exception e) { Console.WriteLine(e.Message); } finally { cn.Close(); } return false; }
public void Test_GetUserClass_ExecuteMethod_Returns_A_List_of_strings() { FindUser usernames = new FindUser(); Assert.IsInstanceOf(typeof(List<string>), usernames.Execute()); }
public void Test_GetUserClass_UniqueUsernameMethod_Returns_False_When_Username_Already_Exsist_in_The_Database() { FindUser usernames = new FindUser(); Assert.IsFalse(usernames.UniqueUsername("hinnah.sarwar")); }
public void Test_GetUserClass_UniqueUsernameMethod_Returns_A_bool() { FindUser usernames = new FindUser(); Assert.IsInstanceOf(typeof(bool), usernames.UniqueUsername("hinnah.sarwar")); }
public List<DbUser> GetUserByUserName(string username) { FindUser user = new FindUser(); return user.Execute(username); }
public void Test_GetUserClass_UniqueUsernameMethod_Returns_True_When_Username_Doesnot_Exsist_in_The_Database() { FindUser usernames = new FindUser(); Assert.IsTrue(usernames.UniqueUsername("sean.thurgood")); }
public List<DbUser> FindUser(DbUser user) { FindUser userDetails = new FindUser(); return userDetails.Execute(user); }
public List<DbUser> GetAvailableConsultants(string stream) { FindUser find = new FindUser(); return find.GetConsultants(stream); }
public List<string> GetUserNamesForAutoFill() { FindUser usernames = new FindUser(); return usernames.Execute(); }
public void TestFindUserClass_ExecuteMethod_Accepts_Username_And_returns_A_ListOf_DbUser() { FindUser users = new FindUser(); Assert.IsInstanceOf(typeof(List<DbUser>), users.Execute("hinnah.sarwar")); }
public int GetNumOfUsers(string firstName, string lastName) { FindUser user = new FindUser(); return user.NumOfUsers(firstName, lastName); }
public string FindUsernameBySessionId(Guid sessionId) { FindUser findUser = new FindUser(); return findUser.GetUsernameBySessionId(sessionId); }