/// <summary>
/// 更新分類
/// </summary>
/// <param name="category_id"></param>
/// <param name="name"></param>
/// <returns></returns>
public async Task <string> EditCategory(TCategoryModel para)
{
#region 驗證
var GetCategory = await _categoryRepo.GetById(para.f_category_id);
if (GetCategory == null)
{
return("此分類不存在");
}
if (string.IsNullOrEmpty(para.f_category_name))
{
return("分類名稱沒填");
}
if (GetCategory.f_category_name == para.f_category_name)
{
return("已有相同名稱的分類");
}
#endregion
var UpdateCategory = new TCategoryModel()
{
f_category_id = para.f_category_id,
f_category_name = para.f_category_name
};
var update = await _categoryRepo.UpdateCategory(UpdateCategory);
return("success");
}
/// <summary>
/// 更新分類
/// </summary>
/// <returns></returns>
public async Task <int> UpdateCategory(TCategoryModel para)
{
var sqlQuery = $@"UPDATE t_category
SET f_category_name = @f_category_name
WHERE f_category_id = @f_category_id";
using (var conn = new SqlConnection(_dbList.Article))
{
return(await conn.ExecuteAsync(sqlQuery, para));
}
}
/// <summary>
/// 新增分類
/// </summary>
/// <returns></returns>
public async Task <int> CreateCategory(TCategoryModel para)
{
var sqlQuery = $@"INSERT INTO t_category
(f_category_id
,f_category_name)
VALUES
(@f_category_id
,@f_category_name)";
using (var conn = new SqlConnection(_dbList.Article))
{
return(await conn.ExecuteAsync(sqlQuery, para));
}
}
/// <summary>
/// 新增分類
/// </summary>
/// <param name="name"></param>
/// <returns></returns>
public async Task <dynamic> CreateCategory(string name)
{
#region 驗證
if (string.IsNullOrEmpty(name))
{
return("分類名稱沒填");
}
var getCategory = await _categoryRepo.GetByName(name);
if (getCategory != null)
{
return("已有相同名稱的分類");
}
#endregion
var NewCategory = new TCategoryModel()
{
f_category_id = Guid.NewGuid(),
f_category_name = name
};
var create = await _categoryRepo.CreateCategory(NewCategory);
return("success");
}
public async Task <dynamic> CreateCateogry(TCategoryModel para)
{
return(await _CategoryService.CreateCategory(para.f_category_name));
}
public async Task <dynamic> DeleteCategory(TCategoryModel para)
{
return(await _CategoryService.DeleteCategory(para.f_category_id));
}
public async Task <dynamic> EditCategory(TCategoryModel para)
{
return(await _CategoryService.EditCategory(para));
}
