/// <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)); }