예제 #1
0
 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));
 }
예제 #2
0
        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;
        }
예제 #3
0
 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));
 }
예제 #4
0
        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;
        }
예제 #5
0
        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());
        }
예제 #6
0
        public async Task <IActionResult> FindUser(FindUser findUser)
        {
            var user = await _metadataProvider.FindMojangUser(findUser.Username);

            findUser.FoundUser = user;
            return(View(findUser));
        }
예제 #7
0
 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));
 }
예제 #8
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 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);
 }
예제 #10
0
        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));
        }
예제 #11
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));
        }
예제 #12
0
        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));
        }
예제 #13
0
        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));
        }
예제 #14
0
        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));
        }
예제 #15
0
        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));
        }
예제 #16
0
 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);
 }
예제 #17
0
        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);
        }
예제 #18
0
        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 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();
 }
예제 #20
0
        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));
        }
예제 #21
0
        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"));
        }
예제 #22
0
 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);
        }
예제 #25
0
        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));
        }
예제 #26
0
        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);
        }
예제 #27
0
        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"));
                }
            }
        }
예제 #28
0
        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);
        }
예제 #29
0
        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;
        }
예제 #30
0
        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));
            }
        }
예제 #31
0
        // 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);
            }
        }
예제 #32
0
        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());
        }
예제 #33
0
        /// <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);
        }
예제 #34
0
        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);
        }
예제 #36
0
        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
            });
        }
예제 #37
0
        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());
        }
예제 #38
0
        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;
            }
        }
예제 #39
0
 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;
 }
예제 #40
0
        public void TestFindUserClass_ExecuteMethod_Accepts_Username_And_returns_A_ListOf_DbUser()
        {
            FindUser users = new FindUser();

            Assert.IsInstanceOf(typeof(List <DbUser>), users.Execute("hinnah.sarwar"));
        }
예제 #41
0
        public void TestFindUserClass_ExecuteMethod_Returns_One_With_Valid_UserName()
        {
            FindUser users = new FindUser();

            Assert.AreEqual(1, users.Execute("hinnah.sarwar").Count);
        }
예제 #42
0
        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;
        }
예제 #43
0
 public void Test_GetUserClass_ExecuteMethod_Returns_A_List_of_strings()
 {
     FindUser usernames = new FindUser();
     Assert.IsInstanceOf(typeof(List<string>), usernames.Execute());
 }
예제 #44
0
 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));
 }
예제 #45
0
 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));
 }
예제 #46
0
 public void Test_GetUserClass_UniqueUsernameMethod_Returns_False_When_Username_Already_Exsist_in_The_Database()
 {
     FindUser usernames = new FindUser();
     Assert.IsFalse(usernames.UniqueUsername("hinnah.sarwar"));
 }
예제 #47
0
 public void Test_GetUserClass_UniqueUsernameMethod_Returns_A_bool()
 {
     FindUser usernames = new FindUser();
     Assert.IsInstanceOf(typeof(bool), usernames.UniqueUsername("hinnah.sarwar"));
 }
예제 #48
0
 public List<DbUser> GetUserByUserName(string username)
 {
     FindUser user = new FindUser();
     return user.Execute(username);
 }
예제 #49
0
 public void Test_GetUserClass_UniqueUsernameMethod_Returns_True_When_Username_Doesnot_Exsist_in_The_Database()
 {
     FindUser usernames = new FindUser();
     Assert.IsTrue(usernames.UniqueUsername("sean.thurgood"));
 }
예제 #50
0
 public List<DbUser> FindUser(DbUser user)
 {
     FindUser userDetails = new FindUser();
     return userDetails.Execute(user);
 }
예제 #51
0
 public List<DbUser> GetAvailableConsultants(string stream)
 {
     FindUser find = new FindUser();
     return find.GetConsultants(stream);
 }
예제 #52
0
 public void TestFindUserClass_ExecuteMethod_Returns_One_With_Valid_UserName()
 {
     FindUser users = new FindUser();
     Assert.AreEqual(1, users.Execute("hinnah.sarwar").Count);
 }
예제 #53
0
 public List<string> GetUserNamesForAutoFill()
 {
     FindUser usernames = new FindUser();
     return usernames.Execute();
 }
예제 #54
0
 public void TestFindUserClass_ExecuteMethod_Accepts_Username_And_returns_A_ListOf_DbUser()
 {
     FindUser users = new FindUser();
     Assert.IsInstanceOf(typeof(List<DbUser>), users.Execute("hinnah.sarwar"));
 }
예제 #55
0
 public int GetNumOfUsers(string firstName, string lastName)
 {
     FindUser user = new FindUser();
     return user.NumOfUsers(firstName, lastName);
 }
예제 #56
0
 public string FindUsernameBySessionId(Guid sessionId)
 {
     FindUser findUser = new FindUser();
     return findUser.GetUsernameBySessionId(sessionId);
 }