public JsonResult KEYWORD_Synonym_Save(KEYWORD_SYNONYM_SAVE saveData)
{
RTN_SAVE_DATA rtnData = new KeywordService().KEYWORD_Synonym_Save(saveData);
return(new JsonResult {
Data = rtnData
});
}
public RTN_SAVE_DATA KEYWORD_Synonym_Save(KEYWORD_SYNONYM_SAVE saveData)
{
RTN_SAVE_DATA rtnData = new RTN_SAVE_DATA();
try
{
using (TransactionScope tran = new TransactionScope())
{
string sql = string.Empty;
sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\Keyword.xml"
, "KEYWORD_Synonym_Delete"
, saveData.BASE_CODE.ToString()
);
db.ExecuteCommand(sql);
if (saveData.KEYWORD_LIST != null)
{
foreach (T_KEYWORD Param in saveData.KEYWORD_LIST)
{
sql = Global.DBAgent.LoadSQL(sqlBasePath + "Advertising\\Keyword.xml"
, "KEYWORD_Synonym_Save"
, Param.BASE_CODE.ToString()
, Param.KEYWORD_NAME.ToString()
, Param.INSERT_CODE.ToString()
);
rtnData = db.ExecuteQuery <RTN_SAVE_DATA>(sql).First();
if (!string.IsNullOrEmpty(rtnData.ERROR_MESSAGE))
{
throw new Exception(rtnData.ERROR_MESSAGE);
}
}
}
tran.Complete();
}
}catch (Exception ex)
{
rtnData.ERROR_MESSAGE = ex.Message;
}
return(rtnData);
}
