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