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