public List <DbRecommendation> Execute(Guid sessionID)
{
DbRecommendation rec = new DbRecommendation();
FindUser find = new FindUser();
int userId = int.Parse(find.GetUserIDBySessionId(sessionID).ToString());
string qry = "SELECT FDMUSER.firstname ||' '|| FDMUSER.lastname AS Name FROM FDMUSER JOIN RECOMMENDATIONS ON RECOMMENDATIONS.recomender_id = FDMUSER.user_id WHERE RECOMMENDATIONS.recomender_id = " + userId;
IReadOneCommand cmd = new ReadOneCommand();
rec.Recommender = cmd.Execute(qry);
string qry2 = "SELECT FDMUSER.firstname ||' '|| FDMUSER.lastname AS Name, JOBPOST.title, JOBPOST.job_id, recommendations.reason FROM FDMUSER JOIN RECOMMENDATIONS ON RECOMMENDATIONS.recomendee_id = FDMUSER.user_id JOIN JOBPOST ON RECOMMENDATIONS.job_id = JOBPOST.job_id WHERE RECOMMENDATIONS.recomender_id = " + userId;
IReadCommand cmd2 = new ReadCommand();
DataTable dt = cmd2.Execute(qry2);
List <DbRecommendation> recPeople = new List <DbRecommendation>(dt.Rows.Count);
recPeople = (from DataRow row in dt.Rows
select new DbRecommendation
{
Recommended = row["NAME"].ToString(),
JobTitle = row["TITLE"].ToString(),
JobID = int.Parse(row["JOB_ID"].ToString()),
Reason = row["REASON"].ToString()
}).ToList();
return(recPeople);
}
public List<DbRecommendation> Execute(Guid sessionID)
{
DbRecommendation rec = new DbRecommendation();
FindUser find = new FindUser();
int userId = int.Parse(find.GetUserIDBySessionId(sessionID).ToString());
string qry = "SELECT FDMUSER.firstname ||' '|| FDMUSER.lastname AS Name FROM FDMUSER JOIN RECOMMENDATIONS ON RECOMMENDATIONS.recomender_id = FDMUSER.user_id WHERE RECOMMENDATIONS.recomender_id = " + userId;
IReadOneCommand cmd = new ReadOneCommand();
rec.Recommender = cmd.Execute(qry);
string qry2 = "SELECT FDMUSER.firstname ||' '|| FDMUSER.lastname AS Name, JOBPOST.title, JOBPOST.job_id, recommendations.reason FROM FDMUSER JOIN RECOMMENDATIONS ON RECOMMENDATIONS.recomendee_id = FDMUSER.user_id JOIN JOBPOST ON RECOMMENDATIONS.job_id = JOBPOST.job_id WHERE RECOMMENDATIONS.recomender_id = " + userId;
IReadCommand cmd2 = new ReadCommand();
DataTable dt = cmd2.Execute(qry2);
List<DbRecommendation> recPeople = new List<DbRecommendation>(dt.Rows.Count);
recPeople = (from DataRow row in dt.Rows
select new DbRecommendation
{
Recommended = row["NAME"].ToString(),
JobTitle = row["TITLE"].ToString(),
JobID = int.Parse(row["JOB_ID"].ToString()),
Reason = row["REASON"].ToString()
}).ToList();
return recPeople;
}