internal Board(SqlNullDataReader reader)
{
this.ID = reader.GetInt32("BoardId");
this.Name = reader.GetString("BoardName");
this.Description = reader.GetString("Description");
this.DateCreated = reader.GetDateTime("DateCreated");
}
internal Archive(SqlNullDataReader reader)
{
this.Year = reader.GetInt32("Year");
this.Month = reader.GetInt32("Month");
this.MonthName = reader.GetString("MonthName");
this.PostCount = reader.GetInt32("PostCount");
}
internal Source(SqlNullDataReader reader)
{
this.ID = reader.GetInt32("ContentSourceId");
this.Name = reader.GetString("SourceName");
this.Url = reader.GetString("Url");
this.Description = reader.GetString("Description");
}
public override List <Post> GetTopPosts(int boardId, int count)
{
List <Post> list = new List <Post>();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(this.ConnectionString, "dbo.yaf_topic_latest",
SqlHelper.CreateInputParam("@BoardID", SqlDbType.Int, 1),
SqlHelper.CreateInputParam("@NumPosts", SqlDbType.Int, count),
SqlHelper.CreateInputParam("@UserID", SqlDbType.Int, 2)))
{
while (reader.Read())
{
//LastPosted
//ForumID
//Forum
//Topic
//TopicID
//LastMessageID
//LastUserID
//NumPosts
//LastUserName
// Views
list.Add(new Post()
{
ID = reader.GetInt32("TopicID"),
ForumName = reader.GetString("Forum"),
DisplayName = reader.GetString("LastUserName"),
ParentID = reader.GetInt32("ForumID"),
PostDate = reader.GetDateTime("LastPosted"),
Title = reader.GetString("Forum")
});
}
}
return(list);
}
public override Forum GetForum(int id)
{
Forum forum = null;
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(ConnectionString, "dbo.lg_Forums_GetForum",
SqlHelper.CreateInputParam("@ForumId", SqlDbType.Int, id)))
{
if (reader.Read())
{
forum = new Forum(reader);
}
if (reader.NextResult())
{
// Roles
while (reader.Read())
{
forum.RequiredRoles.Add(reader.GetString("RoleName"));
}
}
if (reader.NextResult())
{
// Board
if (reader.Read())
{
forum.Board = new Board(reader);
}
}
}
return(forum);
}
private List <Post> GetPostsFromReader(SqlNullDataReader reader)
{
List <Post> list = new List <Post>();
while (reader.Read())
{
list.Add(new Post(reader));
}
// Categories
if (reader.NextResult())
{
while (reader.Read())
{
Post post = list.Find(new Predicate <Post>(delegate(Post p) { return(p.ID == reader.GetInt32("ContentPostId")); }));
if (post != null)
{
post.Categories.Add(new Category(reader));
}
}
}
// Tags
if (reader.NextResult())
{
while (reader.Read())
{
Post post = list.Find(new Predicate <Post>(delegate(Post p) { return(p.ID == reader.GetInt32("ContentPostId")); }));
if (post != null)
{
post.Tags.Add(reader.GetString("TagName"));
}
}
}
return(list);
}
internal Comment(SqlNullDataReader reader)
: this()
{
this.ID = reader.GetInt32("ContentCommentId");
this.Author = reader.GetString("Author");
this.Text = reader.GetString("CommentText");
this.DateCreated = reader.GetDateTime("DateCreated");
}
internal Transaction(SqlNullDataReader reader)
: this()
{
this.ID = reader.GetInt64("TransactionId");
this.IPAddress = reader.GetString("IPAddress");
this.Total = reader.GetDouble("Total");
this.CreditCardLast4 = reader.GetString("CreditCardLast4");
}
private static T GetActorFromReader <T>(SqlNullDataReader reader) where T : IActor
{
Initialize();
T obj = Activator.CreateInstance <T>();
obj.ID = reader.GetInt32("ObjectId");
obj.Name = reader.GetString("ObjectName");
obj.Properties = XmlHelper.FromXml <PropertyCollection>(reader.GetSqlXml("Properties").CreateReader());
return(obj);
}
internal void Load(SqlNullDataReader reader)
{
this.Replies = new List <Reply>();
this.Forum = null;
this.ViewCount = reader.GetInt32("ViewCount");
this.ReplyCount = reader.GetInt32("ReplyCount");
this.LastReplyDate = reader.GetDateTime("LastReplyDate");
this.LastAuthorDisplayName = reader.GetString("LastAuthorDisplayName");
this.LastAuthorImageUrl = reader.GetString("LastAuthorImageUrl");
}
private User GetUserFromReader(SqlNullDataReader reader)
{
return(new User(this.Name, reader.GetString("UserName"),
reader.GetInt32("UserId"), reader.GetString("Email"), reader.GetString("PasswordQuestion"),
null, reader.GetBoolean("IsApproved"), reader.GetBoolean("IsLockedOut"),
reader.GetDateTime("DateCreated"), reader.GetDateTime("DateLastLogin"),
DateTime.Now, reader.GetDateTime("DateLastPasswordChanged"), reader.GetDateTime("DateLastLockOut"),
reader.GetGuid("ConfirmationCode"), reader.GetInt32("Tokens"), reader.GetString("DisplayName"),
reader.GetString("ImageUrl"), reader.GetDateTime("BirthDate")));
}
public override List <Post> GetPosts(int startingRowIndex, int maxRows)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Content_GetPosts",
SqlHelper.CreateInputParam("@SourceName", SqlDbType.NVarChar, ContentManager.SourceName),
SqlHelper.CreateInputParam("@StartRowIndex", SqlDbType.Int, startingRowIndex),
SqlHelper.CreateInputParam("@MaxRows", SqlDbType.Int, maxRows)))
{
return(this.GetPostsFromReader(reader));
}
}
public override List <Post> GetPosts(int year, int month, string categoryName)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Content_GetPostsByMonthYear",
SqlHelper.CreateInputParam("@SourceName", SqlDbType.NVarChar, ContentManager.SourceName),
SqlHelper.CreateInputParam("@CategoryName", SqlDbType.NVarChar, categoryName),
SqlHelper.CreateInputParam("@Year", SqlDbType.Int, year),
SqlHelper.CreateInputParam("@Month", SqlDbType.Int, month)))
{
return(this.GetPostsFromReader(reader));
}
}
internal Product(SqlNullDataReader reader)
{
this.Quantity = 1;
this.ID = reader.GetInt32("ProductId");
this.Name = reader.GetString("ProductName");
this.UnitPrice = reader.GetDecimal("UnitPrice");
this.PurchaseQuantity = reader.GetInt32("PurchaseQuantity");
this.Description = reader.GetString("Description");
this.ImageUrl = reader.GetString("ImageUrl");
this.IsActive = reader.GetBoolean("IsActive");
}
internal Post(SqlNullDataReader reader)
: this()
{
this.ID = reader.GetInt32("ContentPostId");
this.Author = reader.GetString("Author");
this.Title = reader.GetString("Title");
this.Text = reader.GetString("PostText");
this.IsPublished = reader.GetBoolean("IsPublished");
this.IsCommentsEnabled = reader.GetBoolean("IsCommentsEnabled");
this.DateCreated = reader.GetDateTime("DateCreated");
}
public override Board GetBoard(int id)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(ConnectionString, "dbo.lg_Forums_GetBoard",
SqlHelper.CreateInputParam("@BoardId", SqlDbType.Int, id)))
{
if (reader.Read())
{
return(new Board(reader));
}
}
return(null);
}
internal Forum(SqlNullDataReader reader)
: this()
{
this.ID = reader.GetInt32("ForumId");
this.Title = reader.GetString("Title");
this.Description = reader.GetString("Description");
this.TopicCount = reader.GetInt32("TopicCount");
this.ReplyCount = reader.GetInt32("ReplyCount");
this.LastPostDate = reader.GetDateTime("LastPostDate");
this.DisplayName = reader.GetString("DisplayName");
this.ImageUrl = reader.GetString("ImageUrl");
}
private User GetMembershipUser(int userId)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Users_GetUser",
SqlHelper.CreateInputParam("@UserId", System.Data.SqlDbType.Int, userId)))
{
if (reader.Read())
{
return(this.GetUserFromReader(reader));
}
}
return(null);
}
private string GetDecryptedPassword(string username)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Users_GetUserByUserName",
SqlHelper.CreateInputParam("@UserName", System.Data.SqlDbType.NVarChar, username)))
{
if (reader.Read())
{
return(Cryptography.Decrypt(reader.GetString("Password"), SecurityManager.EncryptKey, SecurityManager.EncryptIV, EncryptionAlgorithm.Rijndael));
}
}
return(null);
}
private User GetMembershipUser(string username)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Users_GetUserByUserName",
SqlHelper.CreateInputParam("@UserName", System.Data.SqlDbType.NVarChar, username)))
{
if (reader.Read())
{
return(this.GetUserFromReader(reader));
}
}
return(null);
}
public override Product GetProduct(int id)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Products_GetProduct",
SqlHelper.CreateInputParam("@ProductId", SqlDbType.Int, id)))
{
if (reader.Read())
{
return(new Product(reader));
}
}
return(null);
}
private static void AddActorsFromReader <T>(T owner, SqlNullDataReader reader) where T : IActor
{
if (owner != null && reader.NextResult())
{
while (reader.Read())
{
T obj = GetActorFromReader <T>(reader);
obj.Owner = owner;
// TODO: Add the object to the owner.
}
}
}
internal Post(SqlNullDataReader reader)
{
this.ID = reader.GetInt32("ID");
this.ParentID = reader.GetInt32("ParentID");
this.Title = reader.GetString("Title");
this.Text = reader.GetString("Text");
this.PostDate = reader.GetDateTime("PostDate");
this.DisplayName = reader.GetString("DisplayName");
this.ImageUrl = reader.GetString("ImageUrl");
this.ForumName = reader.GetString("ForumName");
this.BoardName = reader.GetString("BoardName");
}
public override Post GetPost(int postId)
{
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Content_GetPost",
SqlHelper.CreateInputParam("@ContentPostId", SqlDbType.Int, postId)))
{
List <Post> posts = this.GetPostsFromReader(reader);
if (posts != null && posts.Count > 0)
{
return(posts[0]);
}
return(new Post());
}
}
public override List <Board> GetBoards()
{
List <Board> list = new List <Board>();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(ConnectionString, "dbo.lg_Forums_GetBoards"))
{
while (reader.Read())
{
list.Add(new Board(reader));
}
}
return(list);
}
public override List <Category> GetCategories()
{
List <Category> list = new List <Category>();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Content_GetCategories"))
{
while (reader.Read())
{
list.Add(new Category(reader));
}
}
return(list);
}
public override string[] GetAllRoles()
{
List <string> list = new List <string>();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Roles_GetAll"))
{
while (reader.Read())
{
list.Add(reader.GetString("RoleName"));
}
}
return(list.ToArray());
}
public override List <Product> GetActiveProducts()
{
List <Product> list = new List <Product>();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Products_GetActiveProducts"))
{
while (reader.Read())
{
list.Add(new Product(reader));
}
}
return(list);
}
public override Dictionary <string, string> GetSettings()
{
Dictionary <string, string> dic = new Dictionary <string, string>(StringComparer.InvariantCultureIgnoreCase);
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(_connectionString, "dbo.lg_Settings_GetAll"))
{
while (reader.Read())
{
dic.Add(reader.GetString("SettingName"), reader.GetString("SettingValue"));
}
}
return(dic);
}
public override List <Forum> GetForums(Board board)
{
List <Forum> list = new List <Forum>();
using (SqlNullDataReader reader = SqlHelper.ExecuteReader(ConnectionString, "dbo.lg_Forums_GetForumsForBoard",
SqlHelper.CreateInputParam("@BoardId", SqlDbType.Int, board.ID)))
{
while (reader.Read())
{
list.Add(new Forum(reader));
}
}
return(list);
}
