public static void CreateLivePost(string livePageID, string liveName, int fanPageId)
{
Context context = new Context();
//var fanPageID = context.FanPages.FirstOrDefault(x => x.FanPageName == fanPageName);
var livepost_repo = new LivePostsRepository();
var livepost = new LivePost()
{
LivePageID = livePageID,
LiveName = liveName,
FanPageID = fanPageId, //目前只有一個粉絲團，所以也暫時寫死，之後可選粉絲團後改fanPageID
postTime = DateTime.UtcNow.AddHours(8)
};
livepost_repo.Create(livepost);
}
public bool Create(LivePost livePost)
{
using (conn = new SqlConnection(connectionString))
{
try
{
string sql = "INSERT INTO LivePosts(LivePageID,LiveName,postTime,FanPageID) VALUES ( @LivePageID,@LiveName,@postTime,@FanPageID)";
conn.Execute(sql, new { livePost.LivePageID, livePost.LiveName, livePost.postTime, livePost.FanPageID });
return(true);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
}
