public static MsCrmResult CreateForumSubject(ForumSubject forumSubject, IOrganizationService service)
{
MsCrmResult returnValue = new MsCrmResult();
try
{
Entity ent = new Entity("new_forumsubject");
ent["new_name"] = forumSubject.Name;
ent["new_forumid"] = forumSubject.Forum;
ent["new_userid"] = forumSubject.User;
ent["new_content"] = forumSubject.Content;
ent["new_portalid"] = forumSubject.Portal;
returnValue.CrmId = service.Create(ent);
returnValue.Success = true;
returnValue.Result = "M050"; //"Konu başlığı oluşturuldu.";
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return(returnValue);
}
public void AddSubject(ForumSubjectModel model)
{
var userId = dBEntities.PanDogUser.Single(x => x.Login.Equals(model.AuthorLogin)).UserId;
var subj = new ForumSubject()
{
subjectName = model.SubjectName,
userId = userId
};
dBEntities.ForumSubject.Add(subj);
dBEntities.SaveChanges();
}
public MsCrmResult CreateForumSubject(string token, ForumSubject forumSubject)
{
MsCrmResult returnValue = new MsCrmResult();
LoginSession ls = new LoginSession();
try
{
if (!string.IsNullOrEmpty(token))
{
#region | CHECK SESSION |
MsCrmResultObject sessionResult = GetUserSession(token);
if (!sessionResult.Success)
{
returnValue.Result = sessionResult.Result;
return returnValue;
}
else
{
ls = (LoginSession)sessionResult.ReturnObject;
}
#endregion
IOrganizationService service = MSCRM.GetOrgService(true);
forumSubject.Portal = new EntityReference("new_portal", ls.PortalId);
returnValue = ForumHelper.CreateForumSubject(forumSubject, service);
}
else
{
returnValue.Success = false;
returnValue.Result = "M003"; //"Eksik parametre!-CreateForumSubject";
}
}
catch (Exception ex)
{
returnValue.Result = ex.Message;
}
return returnValue;
}
public static MsCrmResultObject GetForumSubjectInfo(Guid forumSubjectId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
fs.new_forumsubjectId AS Id
,fs.new_name AS Name
,fs.new_userId AS UserId
,fs.new_userIdName AS UserIdName
,fs.new_content AS Content
,fs.CreatedOn
,u.new_imageurl ImageUrl
FROM
new_forumsubject AS fs (NOLOCK)
JOIN
new_user AS u (NOLOCK)
ON
u.new_userId=fs.new_userId
WHERE
fs.new_forumsubjectId='{0}'
AND
fs.statecode=0
AND
fs.statuscode=1 --Active" ;
#endregion
DataTable dt = sda.getDataTable(string.Format(query, forumSubjectId));
if (dt != null && dt.Rows.Count > 0)
{
ForumSubject fs = new ForumSubject();
fs.Id = (Guid)dt.Rows[0]["Id"];
fs.Name = dt.Rows[0]["Name"] != DBNull.Value ? dt.Rows[0]["Name"].ToString() : string.Empty;
fs.Content = dt.Rows[0]["Content"] != DBNull.Value ? dt.Rows[0]["Content"].ToString() : string.Empty;
fs.PortalUserImage = dt.Rows[0]["ImageUrl"] != DBNull.Value ? dt.Rows[0]["ImageUrl"].ToString() : "nouserprofile.jpg";
fs.CreatedOn = (DateTime)dt.Rows[0]["CreatedOn"];
fs.CreatedOnString = ((DateTime)dt.Rows[0]["CreatedOn"]).ToString("dd MMMM yyyy ddddd HH:mm", new CultureInfo("tr-TR", false));
if (dt.Rows[0]["UserId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.Id = (Guid)dt.Rows[0]["UserId"];
er.Name = dt.Rows[0]["UserIdName"] != DBNull.Value ? dt.Rows[0]["UserIdName"].ToString() : string.Empty;
er.LogicalName = "new_user";
fs.User = er;
}
MsCrmResultObject resComment = CommentHelper.GetEntityComments(fs.Id, "new_forumsubject", 0, 10, sda);
if (resComment.Success)
{
fs.CommentList = (List <Comment>)resComment.ReturnObject;
}
MsCrmResultObject resultLike = LikeHelper.GetEntityLikeInfo(fs.Id, "new_forumsubject", sda);
if (resultLike.Success)
{
fs.LikeDetail = (LikeInfo)resultLike.ReturnObject;
}
returnValue.Success = true;
returnValue.ReturnObject = fs;
}
else
{
returnValue.Success = false;
returnValue.Result = "M049"; //"Forum konu başlığına ait bilgi bulunamadı!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return(returnValue);
}
public static MsCrmResultObject GetForumSubjects(Guid forumId, SqlDataAccess sda)
{
MsCrmResultObject returnValue = new MsCrmResultObject();
try
{
#region | SQL QUERY |
string query = @"SELECT
fs.new_forumsubjectId AS Id
,fs.new_name AS Name
,fs.new_userId AS UserId
,fs.new_userIdName AS UserIdName
,fs.new_content AS Content
,fs.CreatedOn
FROM
new_forumsubject AS fs (NOLOCK)
WHERE
fs.new_forumId='{0}'
AND
fs.statecode=0
AND
fs.statuscode=1 --Active
ORDER BY
fs.CreatedOn DESC" ;
#endregion
DataTable dt = sda.getDataTable(string.Format(query, forumId));
if (dt != null && dt.Rows.Count > 0)
{
List <ForumSubject> lstSub = new List <ForumSubject>();
for (int i = 0; i < dt.Rows.Count; i++)
{
ForumSubject fs = new ForumSubject();
fs.Id = (Guid)dt.Rows[i]["Id"];
fs.Name = dt.Rows[i]["Name"] != DBNull.Value ? dt.Rows[i]["Name"].ToString() : string.Empty;
fs.Content = dt.Rows[i]["Content"] != DBNull.Value ? dt.Rows[i]["Content"].ToString() : string.Empty;
fs.CreatedOn = (DateTime)dt.Rows[i]["CreatedOn"];
fs.CreatedOnString = ((DateTime)dt.Rows[i]["CreatedOn"]).ToString("dd.MM.yyyy HH:mm");
if (dt.Rows[i]["UserId"] != DBNull.Value)
{
EntityReference er = new EntityReference();
er.Id = (Guid)dt.Rows[i]["UserId"];
er.Name = dt.Rows[i]["UserIdName"] != DBNull.Value ? dt.Rows[i]["UserIdName"].ToString() : string.Empty;
er.LogicalName = "new_user";
fs.User = er;
}
MsCrmResultObject resComment = CommentHelper.GetEntityComments(fs.Id, "new_forumsubject", 0, 10, sda);
if (resComment.Success)
{
fs.CommentList = (List <Comment>)resComment.ReturnObject;
}
lstSub.Add(fs);
}
returnValue.Success = true;
returnValue.ReturnObject = lstSub;
}
else
{
returnValue.Success = false;
returnValue.Result = "M048"; //"Foruma ait konu başlığı bulunmamaktadır!";
}
}
catch (Exception ex)
{
returnValue.Success = false;
returnValue.Result = ex.Message;
}
return(returnValue);
}
