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