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