public bool checkIfUserPassedOtherUser(string username1, string username2)
        {
            User tempUser = new User();
            int  userID1  = tempUser.getUserID(username1);
            int  userID2  = tempUser.getUserID(username2);

            PassedList tempList = new PassedList();

            try
            {
                string passedProfiles1 = tempList.getPasses(userID1).List;
                int[]  passedUserIDs1  = Array.ConvertAll(passedProfiles1.Split('|'), int.Parse);

                if (passedUserIDs1.Contains(userID2))
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            catch (NullReferenceException)
            {
                return(false);
            }
        }
Exemple #2
0
        public int addPassToDB(int userID, int passedUserID)
        {
            int        result = 0;
            DBConnect  objDB  = new DBConnect();
            SqlCommand objCmd = new SqlCommand();

            objCmd.CommandType = CommandType.StoredProcedure;


            PassedList tempPasses = new PassedList();
            string     passList;
            User       tempUser = new User();

            //int passedUserID = tempUser.getUserID(passedProfile);
            try
            {
                passList  = tempPasses.getPasses(userID).List;
                passList += "|" + passedUserID + "|";

                objCmd.CommandText = "TP_ModifyPasses";
                objCmd.Parameters.AddWithValue("@passed", passList);
                objCmd.Parameters.AddWithValue("@passedBy", userID);
                result = objDB.DoUpdateUsingCmdObj(objCmd);
            }
            catch (NullReferenceException)
            {
                //list of passed list is empty, so add the first pass
                passList           = passedUserID + "|";
                objCmd.CommandText = "TP_AddPass";
                objCmd.Parameters.AddWithValue("@passed", passList);
                objCmd.Parameters.AddWithValue("@passedBy", userID);
                result = objDB.DoUpdateUsingCmdObj(objCmd);
            }
            return(result);
        }