public List <DateRequest> getReceivedRequests(int userIDTo) { DBConnect objDB = new DBConnect(); SqlCommand objCmd = new SqlCommand(); objCmd.CommandType = CommandType.StoredProcedure; objCmd.CommandText = "TP_GetReceivedDateRequests"; objCmd.Parameters.AddWithValue("@requestTo", userIDTo); DataSet requestsDS = objDB.GetDataSetUsingCmdObj(objCmd); List <DateRequest> requestsList = new List <DateRequest>(); if (requestsDS.Tables[0].Rows.Count > 0) { foreach (DataRow row in requestsDS.Tables[0].Rows) { DateRequest dateRequest = new DateRequest(); dateRequest.UserIDTo = userIDTo; dateRequest.UserIDFrom = int.Parse(row["RequestFrom"].ToString()); dateRequest.Status = requestsDS.Tables[0].Rows[0]["Status"].ToString(); requestsList.Add(dateRequest); } return(requestsList); } else { return(requestsList); } }
public bool checkIfUserReceivedDateRequest(string usernameFrom, string usernameTo) { bool check = false; User tempUser = new User(); int userIDFrom = tempUser.getUserID(usernameFrom); int userIDTo = tempUser.getUserID(usernameTo); DateRequest tempRequest = new DateRequest(); List <DateRequest> sent = tempRequest.getReceivedRequests(userIDTo); foreach (DateRequest request in sent) { if (request.UserIDFrom == userIDFrom) { check = true; } } return(check); }
public bool checkIfSentRequestAccepted(string usernameFrom, string usernameTo) { bool check = false; User tempUser = new User(); int userIDFrom = tempUser.getUserID(usernameFrom); int userIDTo = tempUser.getUserID(usernameTo); DateRequest tempRequest = new DateRequest(); List <DateRequest> sent = tempRequest.getSentRequests(userIDFrom); foreach (DateRequest request in sent) { if (request.UserIDTo == userIDTo) { if (request.Status.Equals("Accepted")) { check = true; } } } return(check); }