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);
}
