private static blogger.BlogEntry CreateBlogEntry(data.BlogEntry descriptor) { blogger.BlogEntry blogEntry = new blogger.BlogEntry(); blogEntry.Body = Text2Mobile.Filter(descriptor.Body); blogEntry.DTCreated = descriptor.DTCreated.Ticks.ToString(); blogEntry.ID = descriptor.BlogEntryID; blogEntry.Title = Text2Mobile.Filter(descriptor.Title); return(blogEntry); }
public static List <BlogEntry> GetBlogEntryByMemberID(string WebMemberID) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetBlogEntryByMemberID"); db.AddInParameter(dbCommand, "WebMemberID", DbType.String, WebMemberID); List <BlogEntry> BlogEntList = null; // Populate the datareader using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Call the PopulateObject method passing the datareader to return the object array BlogEntList = BlogEntry.PopulateObject(dr); dr.Close(); } return(BlogEntList); }
public void RemoveEntry(String nickname, String password, Int32 blogEntryID) { if (String.IsNullOrEmpty(nickname)) { throw new ArgumentNullException("nickname"); } if (String.IsNullOrEmpty(nickname)) { throw new ArgumentNullException("nickname"); } var member = data.Member.GetMemberViaNicknamePassword(nickname, password); var blogEntry = new data.BlogEntry(blogEntryID); if (blogEntry.MemberID != member.MemberID) { throw new ArgumentException(Resources.Argument_InvalidBlogEntryRemover); } data.BlogEntry.DeleteBlogEntry(blogEntryID); }
/// <summary> /// Gets the blog entries for the mobile application. /// </summary> public static BlogEntry[] GetMobileBlogEntry(int MemberID) { Database db = DatabaseFactory.CreateDatabase(); db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("HG_GetMobileBlogEntry"); db.AddInParameter(dbCommand, "MemberID", DbType.Int32, MemberID); List <BlogEntry> BlogEntList = null; // Populate the datareader using (IDataReader dr = db.ExecuteReader(dbCommand)) { // Call the PopulateObject method passing the datareader to return the object array BlogEntList = BlogEntry.PopulateObject(dr); dr.Close(); } return(BlogEntList.ToArray()); }
private static data.BlogEntry CreateBlogEntry(blogger.BlogEntry descriptor) { data.BlogEntry blogEntry = null; if (descriptor.ID == 0) { blogEntry = new data.BlogEntry(); } else { blogEntry = new data.BlogEntry(descriptor.ID); } blogEntry.Body = HttpUtility.HtmlEncode(descriptor.Body ?? ""); String dtCreatedRaw = descriptor.DTCreated; if (!String.IsNullOrEmpty(dtCreatedRaw)) { blogEntry.DTCreated = new DateTime(Convert.ToInt64(dtCreatedRaw)); } blogEntry.Title = HttpUtility.HtmlEncode(descriptor.Title ?? ""); return(blogEntry); }
/// <summary> /// Takes an prepopulated IDataReader and creates an array of BlogEntrys /// </summary> public static List<BlogEntry> PopulateObject(IDataReader dr) { ColumnFieldList list = new ColumnFieldList(dr); List<BlogEntry> arr = new List<BlogEntry>(); BlogEntry obj; while (dr.Read()) { obj = new BlogEntry(); if (list.IsColumnPresent("BlogEntryID")) { obj._blogEntryID = (int)dr["BlogEntryID"]; } if (list.IsColumnPresent("WebBlogEntryID")) { obj._webBlogEntryID = (string)dr["WebBlogEntryID"]; } if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("Title")) { obj._title = (string)dr["Title"]; } if (list.IsColumnPresent("Body")) { obj._body = (string)dr["Body"]; } if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; } arr.Add(obj); } dr.Close(); return arr; }
/// <summary> /// Takes an prepopulated IDataReader and creates an array of BlogEntrys /// </summary> public static List<BlogEntry> PopulateObjectWithJoin(IDataReader dr) { ColumnFieldList list = new ColumnFieldList(dr); List<BlogEntry> arr = new List<BlogEntry>(); BlogEntry obj; while (dr.Read()) { obj = new BlogEntry(); if (list.IsColumnPresent("BlogEntryID")) { obj._blogEntryID = (int)dr["BlogEntryID"]; } if (list.IsColumnPresent("WebBlogEntryID")) { obj._webBlogEntryID = (string)dr["WebBlogEntryID"]; } if (list.IsColumnPresent("MemberID")) { obj._memberID = (int)dr["MemberID"]; } if (list.IsColumnPresent("Title")) { obj._title = (string)dr["Title"]; } if (list.IsColumnPresent("Body")) { obj._body = (string)dr["Body"]; } if (list.IsColumnPresent("DTCreated")) { obj._dTCreated = (DateTime)dr["DTCreated"]; } obj.Member = new Member(); if (list.IsColumnPresent("MemberMemberID")) { obj.Member.MemberID = (int)dr["MemberMemberID"]; } if (list.IsColumnPresent("MemberWebMemberID")) { obj.Member.WebMemberID = (string)dr["MemberWebMemberID"]; } if (list.IsColumnPresent("MemberAdminStatusID")) { obj.Member.AdminStatusID = (int)dr["MemberAdminStatusID"]; } if (list.IsColumnPresent("MemberNickName")) { obj.Member.NickName = (string)dr["MemberNickName"]; } if (list.IsColumnPresent("MemberChannelID")) { obj.Member.ChannelID = (int)dr["MemberChannelID"]; } if (list.IsColumnPresent("MemberPassword")) { obj.Member.Password = (string)dr["MemberPassword"]; } if (list.IsColumnPresent("MemberEmail")) { obj.Member.Email = (string)dr["MemberEmail"]; } if (list.IsColumnPresent("MemberGender")) { obj.Member.Gender = (int)dr["MemberGender"]; } if (list.IsColumnPresent("MemberFirstName")) { obj.Member.FirstName = (string)dr["MemberFirstName"]; } if (list.IsColumnPresent("MemberLastName")) { obj.Member.LastName = (string)dr["MemberLastName"]; } if (list.IsColumnPresent("MemberProfilePhotoResourceFileID")) { obj.Member.ProfilePhotoResourceFileID = (int)dr["MemberProfilePhotoResourceFileID"]; } if (list.IsColumnPresent("MemberDOB")) { obj.Member.DOB = (DateTime)dr["MemberDOB"]; } if (list.IsColumnPresent("MemberISOCountry")) { obj.Member.ISOCountry = (string)dr["MemberISOCountry"]; } if (list.IsColumnPresent("MemberAccountType")) { obj.Member.AccountType = (int)dr["MemberAccountType"]; } if (list.IsColumnPresent("MemberZipPostcode")) { obj.Member.ZipPostcode = (string)dr["MemberZipPostcode"]; } if (list.IsColumnPresent("MemberPhoneNumber")) { obj.Member.PhoneNumber = (string)dr["MemberPhoneNumber"]; } if (list.IsColumnPresent("MemberMobilePhoneID")) { obj.Member.MobilePhoneID = (int)dr["MemberMobilePhoneID"]; } if (list.IsColumnPresent("MemberIPLocationID")) { obj.Member.IPLocationID = (int)dr["MemberIPLocationID"]; } if (list.IsColumnPresent("MemberCreatedDT")) { obj.Member.CreatedDT = (DateTime)dr["MemberCreatedDT"]; } arr.Add(obj); } dr.Close(); return arr; }
private static data.BlogEntry CreateBlogEntry(blogger.BlogEntry descriptor) { data.BlogEntry blogEntry = null; if (descriptor.ID == 0) blogEntry = new data.BlogEntry(); else blogEntry = new data.BlogEntry(descriptor.ID); blogEntry.Body = HttpUtility.HtmlEncode(descriptor.Body ?? ""); String dtCreatedRaw = descriptor.DTCreated; if (!String.IsNullOrEmpty(dtCreatedRaw)) blogEntry.DTCreated = new DateTime(Convert.ToInt64(dtCreatedRaw)); blogEntry.Title = HttpUtility.HtmlEncode(descriptor.Title ?? ""); return blogEntry; }
public void RemoveEntry(String nickname, String password, Int32 blogEntryID) { if (String.IsNullOrEmpty(nickname)) throw new ArgumentNullException("nickname"); if (String.IsNullOrEmpty(nickname)) throw new ArgumentNullException("nickname"); var member = data.Member.GetMemberViaNicknamePassword(nickname, password); var blogEntry = new data.BlogEntry(blogEntryID); if (blogEntry.MemberID != member.MemberID) throw new ArgumentException(Resources.Argument_InvalidBlogEntryRemover); data.BlogEntry.DeleteBlogEntry(blogEntryID); }
protected void Page_Load(object sender, EventArgs e) { AjaxPro.Utility.RegisterTypeForAjax(typeof(Blog)); member = (Member)Session["Member"]; if (member != null) { IsLoggedIn = true; } ViewingMember = ExtractPageParams.GetMember(this.Page, this.Context); string strPager = Request.Params["p"]; strBlogID = Request.Params["b"]; try { string []blogID = strBlogID.Split(new char[]{','}); if (blogID.Length != 0) { strBlogID = blogID[blogID.Length - 1]; } } catch{} Int32.TryParse(strPager, out PageTo); PageTo = (PageTo == 0) ? 1 : PageTo; if (member != null) { if (ViewingMember.WebMemberID == member.WebMemberID) { IsMyPage = true; } } if (ViewingMember != null) { blogs = BlogEntry.GetBlogEntryByMemberID(ViewingMember.WebMemberID); blogs = SortBlogsByDate(blogs); } if (blogs.Count == 0) { return; } HasContent = true; int i = 1; if (strBlogID != null) { foreach (BlogEntry b in blogs) { if (b.WebBlogEntryID == strBlogID) { blog = b; PageTo = i; break; } i++; } } else { if (PageTo > blogs.Count) PageTo = blogs.Count; blog = blogs[PageTo - 1]; } if (blog != null) { strBlogID = blog.WebBlogEntryID; WebBlogID = blog.WebBlogEntryID; Comments1.ObjectId = blog.BlogEntryID; Comments1.ObjectWebId = blog.WebBlogEntryID; Comments1.CommentType = CommentType.Blog; PopulateVariables(); BlogPager pager = new BlogPager("/users/" + ViewingMember.NickName + "/blog/", ViewingMember.NickName + "/", PageTo, blogs.Count); pager.PageSize = 1; DefaultHTMLPager = (blogs.Count > 0) ? "<span>" + pager.ToString() + "</span>" : string.Empty; } }
public string NewBlog( string Title, string Body ) { member = (Member)Session["Member"]; blog = new BlogEntry(); blog.MemberID = member.MemberID; blog.Title = Title; blog.Body = HTMLUtility.FormatForHTML(Body); blog.DTCreated = DateTime.Now; blog.WebBlogEntryID = Next2Friends.Misc.UniqueID.NewWebID(); blog.Save(); return blog.WebBlogEntryID; }
public string UpdateBlog(string WebBlogId, string Title, string Body) { member = (Member)Session["Member"]; blog = BlogEntry.GetBlogEntryByWebBlogEntryID(WebBlogId); if (blog.MemberID != member.MemberID) return null; blog.Title = Title; blog.Body = HTMLUtility.FormatForHTML(Body); blog.Save(); return HTMLUtility.AutoLink(blog.Body); }