public bool AddPost(Post post, string subforum)
{
//Getting last id:
IEnumerable<int> postKeysList = (from m in ForumContext.PostKeyEntities
select m.PostKeyId);
int lastId = 0;
if (postKeysList.Count() != 0)
{
lastId = postKeysList.Max();
}
currentPostKeyId = lastId + 1;
PostKeyEntity pke = new PostKeyEntity();
pke.PostKeyId = currentPostKeyId;
pke.Username = post.Key.Username;
pke.Time = post.Key.Time;
PostEntity pe = new PostEntity();
pe.PostKeyId = currentPostKeyId;
pe.ParentPostKeyId = -1;
pe.Title = post.Title;
pe.Body = post.Body;
pe.SubforumName = subforum; //TODO - Why do we need 'subforum'?
try
{
ForumContext.AddToPostKeyEntities(pke);
ForumContext.AddToPostEntities(pe);
ForumContext.SaveChanges();
return true;
}
catch (Exception)
{
//TODO
throw;
}
}
/// <summary>
/// Create a new PostKeyEntity object.
/// </summary>
/// <param name="postKeyId">Initial value of the PostKeyId property.</param>
/// <param name="username">Initial value of the Username property.</param>
/// <param name="time">Initial value of the Time property.</param>
public static PostKeyEntity CreatePostKeyEntity(global::System.Int32 postKeyId, global::System.String username, global::System.DateTime time)
{
PostKeyEntity postKeyEntity = new PostKeyEntity();
postKeyEntity.PostKeyId = postKeyId;
postKeyEntity.Username = username;
postKeyEntity.Time = time;
return postKeyEntity;
}
public bool AddReply(Post reply, Postkey postKey)
{
try
{
// Find parent postkey:
IEnumerable<PostKeyEntity> postkeyQuery = GetPostKeyEntity(postKey);
IEnumerable<PostEntity> postQuery = GetPostEntity(postKey);
//Getting last id:
IEnumerable<int> postKeysList = (from m in ForumContext.PostKeyEntities
select m.PostKeyId);
int lastId = 0;
if (postKeysList.Count() != 0)
{
lastId = postKeysList.Max();
}
currentPostKeyId = lastId + 1;
PostKeyEntity pke = new PostKeyEntity();
pke.PostKeyId = currentPostKeyId;
pke.Username = reply.Key.Username;
pke.Time = reply.Key.Time;
ForumContext.AddToPostKeyEntities(pke);
PostEntity pe = new PostEntity();
pe.PostKeyId = currentPostKeyId;
//currentPostKeyId++;
pe.ParentPostKeyId = postkeyQuery.ElementAt(0).PostKeyId;
pe.Title = reply.Title;
pe.Body = reply.Body;
pe.SubforumName = postQuery.ElementAt(0).SubforumName;
ForumContext.AddToPostEntities(pe);
ForumContext.SaveChanges();
return true;
}
catch (Exception)
{
//TODO
throw;
}
}
/// <summary>
/// Deprecated Method for adding a new object to the PostKeyEntities EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPostKeyEntities(PostKeyEntity postKeyEntity)
{
base.AddObject("PostKeyEntities", postKeyEntity);
}