public PassedList getPasses(int userID)
{
DBConnect objDB = new DBConnect();
SqlCommand objCmd = new SqlCommand();
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "TP_GetPasses";
objCmd.Parameters.AddWithValue("@passedBy", userID);
DataSet passesDS = objDB.GetDataSetUsingCmdObj(objCmd);
PassedList passedList = new PassedList();
if (passesDS.Tables[0].Rows.Count > 0)
{
if (objDB.GetField("Passed", 0) == DBNull.Value)
{
return(null);
}
else
{
passedList.List = passesDS.Tables[0].Rows[0]["Passed"].ToString().TrimEnd('|');
return(passedList);
}
}
else
{
return(null);
}
}
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);
}
}
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);
}