public PostVotesList GetPostVotesByPostId(Guid postId) { Database database = new Database("LooksGoodDatabase"); database.Command.Parameters.Clear(); database.Command.CommandType = CommandType.StoredProcedure; database.Command.CommandText = "tblPostVotesGetByPostId"; database.Command.Parameters.Add("@PostId", SqlDbType.UniqueIdentifier).Value = postId; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { PostVotes postvotes = new PostVotes(); Post post = new Post(); postvotes.Initialize(dr); postvotes.InitializeBusinessData(dr); postvotes.IsNew = false; postvotes.IsDirty = false; postvotes.Savable += PostVotes_Savable; _List.Add(postvotes); } return(this); }
public PostVotesList GetAll() { Database database = new Database("LooksGoodDatabase"); database.Command.Parameters.Clear(); database.Command.CommandType = CommandType.StoredProcedure; database.Command.CommandText = "tblPostVotesGetAll"; DataTable dt = database.ExecuteQuery(); foreach (DataRow dr in dt.Rows) { PostVotes pv = new PostVotes(); pv.Initialize(dr); pv.InitializeBusinessData(dr); pv.IsNew = false; pv.IsDirty = false; pv.Savable += PostVotes_Savable; _List.Add(pv); } return(this); }