public async Task <IActionResult> CerateOrEdit([FromBody] ESysKeywords eSysKeywords) { bool flag = false; try { if (eSysKeywords.ID == 0) { using (var uow = _uowFactory.Create()) { flag = await _SysKeywordsRepository.AddAsync(eSysKeywords); uow.SaveChanges(); } if (flag) { return(Ok(new { status = true, message = "success" })); } else { return(Ok(new { status = false, message = "error" })); } } else { using (var uow = _uowFactory.Create()) { flag = await _SysKeywordsRepository.UpdateAsync(eSysKeywords); uow.SaveChanges(); } if (flag) { return(Ok(new { status = true, message = "success" })); } else { return(Ok(new { status = false, message = "error" })); } } } catch (Exception ex) { return(Ok(new { status = false, message = ex.Message })); } }
public async Task <bool> UpdateAsync(ESysKeywords eSysKeywords) { string sql = "update Sys_Keywords set Keyword=@Keyword,ReplaceValue=@ReplaceValue,Status=@Status where ID=@ID;"; return(await _context.ExecuteAsync(sql, eSysKeywords) > 0); }
public async Task <bool> AddAsync(ESysKeywords eSysKeywords) { string sql = "insert into Sys_Keywords(Keyword,ReplaceValue,Status) values(@Keyword,@ReplaceValue,@Status);select @@Identity;"; return(await _context.ExecuteAsync(sql, eSysKeywords) > 0); }