public DataTable getFriendsList(string user_id)
{
storedProcedure myProc = new storedProcedure("getFriendsList");
myProc.addParam(new paramter("@user_id", user_id));
DataTable table = new DataTable();
return table = myProc.executeReader();
}
public DataTable getAllUsernames()
{
storedProcedure myProc = new storedProcedure("getAllUsernames");
DataTable table = new DataTable();
return(table = myProc.executeReader());
}
public DataTable GetSentMessages(string userID)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("GetSentMessages");
myProc.addParam(new paramter("@userId", userID));
return table = myProc.executeReader();
}
public DataTable GetUserList()
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("GetUserList");
return(table = myProc.executeReader());
}
public DataTable getAmountOfUnreadMsg(string UserId)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("getAmountOfUnreadMsg");
myProc.addParam(new paramter("@UserId", UserId));
return table = myProc.executeReader();
}
public DataTable GetUserDetails(string userId)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("GetUserDetails");
myProc.addParam(new paramter("@userId", userId));
return table = myProc.executeReader();
}
public DataTable GetSentMessages(string userID)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("GetSentMessages");
myProc.addParam(new paramter("@userId", userID));
return(table = myProc.executeReader());
}
public DataTable getAmountOfUnreadMsg(string UserId)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("getAmountOfUnreadMsg");
myProc.addParam(new paramter("@UserId", UserId));
return(table = myProc.executeReader());
}
public DataTable GetMessageDetails(int messageId)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("ReadMessage");
myProc.addParam(new paramter("@id", messageId.ToString()));
return table = myProc.executeReader();
}
public DataTable getConversation(string recieverID, string senderID)
{
storedProcedure myProc = new storedProcedure("getConversation");
myProc.addParam(new paramter("@recieverID", recieverID));
myProc.addParam(new paramter("@senderID", senderID));
DataTable table = new DataTable();
return table = myProc.executeReader();
}
public DataTable GetMessageDetails(int messageId)
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("ReadMessage");
myProc.addParam(new paramter("@id", messageId.ToString()));
return(table = myProc.executeReader());
}
public DataTable mutualFriends(string user_id, string visitedUser_Id)
{
storedProcedure myProc = new storedProcedure("mutualFriends");
myProc.addParam(new paramter("@user_id", user_id));
myProc.addParam(new paramter("@visitedUser_Id", visitedUser_Id));
DataTable table = new DataTable();
return table = myProc.executeReader();
}
public DataTable getFriendsList(string user_id)
{
storedProcedure myProc = new storedProcedure("getFriendsList");
myProc.addParam(new paramter("@user_id", user_id));
DataTable table = new DataTable();
return(table = myProc.executeReader());
}
public DataTable checkIfFriend(string user_id, string friend_id)
{
storedProcedure myProc = new storedProcedure("checkIfFriend");
myProc.addParam(new paramter("@user_id", user_id));
myProc.addParam(new paramter("@friend_id", friend_id));
DataTable table = new DataTable();
return table = myProc.executeReader();
}
public DataTable getConversation(string recieverID, string senderID)
{
storedProcedure myProc = new storedProcedure("getConversation");
myProc.addParam(new paramter("@recieverID", recieverID));
myProc.addParam(new paramter("@senderID", senderID));
DataTable table = new DataTable();
return(table = myProc.executeReader());
}
public DataTable mutualFriends(string user_id, string visitedUser_Id)
{
storedProcedure myProc = new storedProcedure("mutualFriends");
myProc.addParam(new paramter("@user_id", user_id));
myProc.addParam(new paramter("@visitedUser_Id", visitedUser_Id));
DataTable table = new DataTable();
return(table = myProc.executeReader());
}
public DataTable checkIfFriend(string user_id, string friend_id)
{
storedProcedure myProc = new storedProcedure("checkIfFriend");
myProc.addParam(new paramter("@user_id", user_id));
myProc.addParam(new paramter("@friend_id", friend_id));
DataTable table = new DataTable();
return(table = myProc.executeReader());
}
private void configure()
{
storedProcedure myProcReader = new storedProcedure("getAllMajors");
DataTable dt = myProcReader.executeReader();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
String majorName = dr["major_name"].ToString();
this.majorsList.Add(majorName);
}
}
else
{
Console.WriteLine("No rows found.");
}
}
private void configure()
{
storedProcedure myProcReader = new storedProcedure("getAllMajors");
DataTable dt = myProcReader.executeReader();
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
String majorName = dr["major_name"].ToString();
this.majorsList.Add(majorName);
}
}
else
{
Console.WriteLine("No rows found.");
}
}
public DataTable GetUserList()
{
DataTable table = new DataTable();
storedProcedure myProc = new storedProcedure("GetUserList");
return table = myProc.executeReader();
}
public DataTable getAllUsernames()
{
storedProcedure myProc = new storedProcedure("getAllUsernames");
DataTable table = new DataTable();
return table = myProc.executeReader();
}
