/// <summary>
/// 更新文章
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <string> EditArticle(ArticleViewModel_para para)
{
#region 驗證
if (string.IsNullOrEmpty(para.article_id) || !Guid.TryParse(para.article_id, out Guid id))
{
return("請選擇文章");
}
var GetArticle = await _articleRepo.GetById(id);
if (GetArticle == null)
{
return("該文章不存在");
}
var check = await ArticleVerify(para);
if (check != "success")
{
return(check);
}
#endregion
var UpdateArticle = new TArticleModel()
{
f_article_id = id,
f_category_id = new Guid(para.category_id),
f_article_name = para.article_name,
f_content = para.article_content
};
var update = await _articleRepo.UpdateArticle(UpdateArticle);
return("success");
}
/// <summary>
/// 更新文章
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <int> UpdateArticle(TArticleModel para)
{
var sqlQuery = $@"UPDATE t_article
SET f_category_id = @f_category_id
,f_article_name = @f_article_name
,f_content = @f_content
WHERE f_article_id = @f_article_id";
using (var conn = new SqlConnection(_dbList.Article))
{
return(await conn.ExecuteAsync(sqlQuery, para));
}
}
/// <summary>
/// 新增文章
/// </summary>
/// <param name="para"></param>
/// <returns></returns>
public async Task <int> CreateArticle(TArticleModel para)
{
var sqlQuery = $@"INSERT INTO t_article
(f_article_id
,f_category_id
,f_article_name
,f_content)
VALUES
(@f_article_id
,@f_category_id
,@f_article_name
,@f_content)";
using (var conn = new SqlConnection(_dbList.Article))
{
return(await conn.ExecuteAsync(sqlQuery, para));
}
}
/// <summary>
/// 新增文章
/// </summary>
/// <param name="category_id"></param>
/// <param name="name"></param>
/// <param name="content"></param>
/// <returns></returns>
public async Task <dynamic> CreateArticle(ArticleViewModel_para para)
{
#region 驗證
var check = await ArticleVerify(para);
if (check != "success")
{
return(check);
}
#endregion
var NewArticle = new TArticleModel()
{
f_article_id = Guid.NewGuid(),
f_category_id = new Guid(para.category_id),
f_article_name = para.article_name,
f_content = para.article_content
};
await _articleRepo.CreateArticle(NewArticle);
return("success");
}
public async Task <dynamic> DeleteArticle(TArticleModel para)
{
return(await _ArticleService.DeleteArticle(para.f_article_id));
}
