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."); } }
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(); }