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