public async Task <OperationResult> ImportExcel(string pathFile, string user) { using (var package = new ExcelPackage(new FileInfo(pathFile))) { ExcelWorksheet workSheet = package.Workbook.Worksheets[0]; int totalRows = workSheet.Dimension.Rows; for (int i = 2; i <= totalRows; i++) { ArticleCategory_Dto articleCategory = new ArticleCategory_Dto(); articleCategory.Article_Cate_Name = workSheet.Cells[i, 1].Value.ToSafetyString().Trim(); articleCategory.Status = workSheet.Cells[i, 2].Value.ToBool(); articleCategory.Position = workSheet.Cells[i, 3].Value.ToInt(); articleCategory.Update_By = user; articleCategory.Update_Time = DateTime.Now; try { await Create(articleCategory); operationResult = new OperationResult { Message = "Import Success", Success = true }; } catch { operationResult = new OperationResult { Message = "Import Faild", Success = false }; } } } return(await Task.FromResult(operationResult)); }
public async Task <IActionResult> Update(ArticleCategory_Dto model) { model.Update_By = User.FindFirst(ClaimTypes.Name).Value; model.Update_Time = DateTime.Now; var data = await _articleCategoryService.Update(model); return(Ok(data)); }
public async Task <IActionResult> Update(ArticleCategory_Dto model) { model.Update_By = User.FindFirst(ClaimTypes.Name).Value; model.Update_Time = DateTime.Now; var result = await _articleCategoryService.Update(model); if (result.Success) { await _hubContext.Clients.All.LoadDataArticleCate(); } return(Ok(result)); }
public async Task <OperationResult> Update(ArticleCategory_Dto model) { var data = _mapper.Map <ArticleCategory>(model); try { _articleCategoryRepository.Update(data); await _articleCategoryRepository.Save(); operationResult = new OperationResult { Success = true, Message = "Article Category was successfully updated." }; } catch (System.Exception) { operationResult = new OperationResult { Success = false, Message = "Article Category was failes updated." }; } return(operationResult); }
public async Task <OperationResult> Create(ArticleCategory_Dto model) { model.Article_Cate_ID = await GetArticleCategoryID(); var data = _mapper.Map <ArticleCategory>(model); try { _articleCategoryRepository.Add(data); await _articleCategoryRepository.Save(); operationResult = new OperationResult { Success = true, Message = "Article Category was successfully added." }; } catch (System.Exception) { operationResult = new OperationResult { Success = false, Message = "Article Category was exists." }; } return(operationResult); }