public static MsCrmResultObject GetUserForums(Guid portalId, Guid portalUserId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
f.new_forumId AS Id
,f.new_name AS Name
,f.new_parentforumId AS ParentForumId
,f.new_parentforumIdName AS ParentForumIdName
,f.CreatedOn
FROM
new_forum AS f (NOLOCK)
JOIN
new_new_forum_new_role AS fr (NOLOCK)
ON
fr.new_forumid=f.new_forumId
JOIN
new_role AS r (NOLOCK)
ON
r.new_roleId=fr.new_roleid
AND
r.statecode=0
AND
r.statuscode=1 --Active
JOIN
new_new_user_new_role AS ur (NOLOCK)
ON
ur.new_userid='{1}'
WHERE
f.new_parentforumId IS NULL
AND
f.new_portalId='{0}'
AND
f.statecode=0
AND
f.statuscode=1 --Active
ORDER BY
f.CreatedOn DESC";
#endregion
DataTable dt = sda.getDataTable(string.Format(query, portalId, portalUserId));
if (dt != null && dt.Rows.Count > 0)
{
List <Forum> lstForum = new List <Forum>();
for (int i = 0; i < dt.Rows.Count; i++)
{
MsCrmResultObject frRes = ForumHelper.GetForumInfo((Guid)dt.Rows[i]["Id"], portalUserId, sda);
if (frRes.Success)
{
lstForum.Add((Forum)frRes.ReturnObject);
}
}
returnValue.Success = true;
returnValue.ReturnObject = lstForum;
}
else
{
returnValue.Success = false;
returnValue.Result = "M046"; //"Forum kaydı bulunamadı!!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return(returnValue);
}
