/// <summary>
/// Save a SQL request into history for later use
/// </summary>
/// <param name="request"></param>
public ResponseModel SaveCommand(SQLRequest request)
{
if (request.Query == null)
{
return(new ResponseModel
{
Success = true
});
}
var last = GetLastCommand();
if (last != null && last.Query == request.Query)
{
return(new ResponseModel
{
Success = true
});
}
var history = new SqlCommandHistoryModel
{
Query = request.Query
};
var response = Insert(history);
return(response.SetMessage(response.Success
? T("SqlCommand_Message_CreateSuccessfully")
: T("SqlCommand_Message_CreateFailure")));
}
internal ResponseModel Insert(SqlCommandHistoryModel historyModel)
{
var commandHistory = new SQLCommandHistory
{
Query = historyModel.Query
};
return(Insert(commandHistory));
}
