public SaveCategoryRes Created(SaveCategoryReq category) { var result = new SaveCategoryRes() { Result = 0, Message = $"Đã xảy ra lỗi, vui lòng thử lại sau." }; try { DynamicParameters parameters = new DynamicParameters(); parameters.Add(@"ID", category.ID); parameters.Add(@"CategoryName", category.CategoryName); var response = SqlMapper.ExecuteScalar <int>(con, "proc_SaveCategory", param: parameters, commandType: CommandType.StoredProcedure); result.Result = response; result.Message = category.ID == 0 ? $"Brand created success." : $"Update brand success!"; return(result); } catch { return(result); } }
public async Task <SaveCategoryRes> Save(SaveCategoryReq request) { var result = new SaveCategoryRes() { CategoryId = 0, Message = "Something went wrong, please contact administrator." }; try { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@CategoryId", request.CategoryId); parameters.Add("@CategoryName", request.CategoryName); parameters.Add("@Status", request.Status); result = await SqlMapper.QueryFirstOrDefaultAsync <SaveCategoryRes>(cnn : connection, sql : "sp_SaveCategory", param : parameters, commandType : CommandType.StoredProcedure); return(result); } catch (Exception) { return(result); } }