/// <summary>
/// 新刊登存檔 - 教練刊登
/// </summary>
/// <param name="model"></param>
/// <param name="userId"></param>
public void SaveNewPost(NewPostToTeachModel model, string userId)
{
using (TransactionScope scope = new TransactionScope())
{
StringBuilder sql = new StringBuilder();
// 1.新增教練刊登主檔並取得新增的ID
sql.AppendLine(@"
INSERT INTO CoachPost(CoachId, IsOpen, HopeStudentSex, Memo, CreateDate)
OUTPUT INSERTED.PostId
VALUES({0}, 'Y', {1}, {2}, GETDATE())
");
int postId = dbConn.ExecuteQuery <int>(sql.ToString(), userId, model.HopeStudentSex, model.Memo ?? "").SingleOrDefault();
// 2.加入地區關聯檔
sql.Clear();
sql.AppendLine(@"
INSERT INTO PostHopeArea(PostCharacter, PostId, AreaId)
SELECT 'Coach' AS PostCharacter, {0} AS PostId, COD AS AreaId
FROM dbo.fn_SPLIT({1}, ',')
");
dbConn.ExecuteCommand(sql.ToString(), postId, model.HopeArea);
// 3.加入學習類型關聯檔
sql.Clear();
sql.AppendLine(@"
INSERT INTO PostLearnType(PostCharacter, PostId, TypeId)
SELECT 'Coach' AS PostCharacter, {0} AS PostId, COD AS TypeId
FROM dbo.fn_SPLIT({1}, ',')
");
dbConn.ExecuteCommand(sql.ToString(), postId, model.ToTeachType);
scope.Complete();
}
}
public JsonResult ToTeachPostSave(NewPostToTeachModel model)
{
using (PostDAC dac = new PostDAC())
{
try
{
dac.SaveNewPost(model, userId);
return(Json("SUCCESS"));
}
catch
{
return(Json("存檔失敗"));
}
}
}
